工单状态修改

DECLARE
l_iface_rec wip.wip_job_schedule_interface%ROWTYPE;
x_return_status VARCHAR2(30);
x_msg_data VARCHAR2(2000);
BEGIN
BEGIN
fnd_global.apps_initialize(user_id => 10783,
resp_id => 50737,
resp_appl_id => 20006);
mo_global.init(p_appl_short_name => 'CUX');
END;
l_iface_rec := NULL;

l_iface_rec.last_update_date := SYSDATE;
--l_iface_rec.last_updated_by := g_user_id;
--l_iface_rec.last_updated_by_name := cux_common_utl.get_user_name(g_user_id);
l_iface_rec.creation_date := SYSDATE;

l_iface_rec.created_by := 10783;
l_iface_rec.last_updated_by := 10783;
l_iface_rec.last_update_login := -1;
l_iface_rec.group_id := -999;

l_iface_rec.load_type := 3;

l_iface_rec.process_phase := 2; --2 Validation;3 Explosion;4 Completion;5 Creation;
l_iface_rec.process_status := 1; --1 Pending;2 Running;3 Error;4 Complete;5 Warning;
l_iface_rec.status_type := 4; --1 UnReleased/3 Released 需要开会计期

l_iface_rec.wip_entity_id := 1160794;
l_iface_rec.organization_id := 96;

l_iface_rec.last_unit_completion_date := SYSDATE;

INSERT INTO wip.wip_job_schedule_interface
VALUES l_iface_rec;

wip_massload_pub.massloadjobs(p_groupid => -999, -- Group ID
p_validationlevel => 2, -- Validation Level
p_commitflag => 0, -- Commit 1 =Yes , 0 ='No'
x_returnstatus => x_return_status,
x_errormsg => x_msg_data);
dbms_output.put_line(x_return_status);
dbms_output.put_line(x_msg_data);
END;

 

/*DELETE wip_job_schedule_interface v
WHERE v.GROUP_ID = -999;

SELECT v.status_type
FROM wip_discrete_jobs v
WHERE v.wip_entity_id = 1160794;

SELECT COUNT(1)
,listagg(wie2.error,
'') within GROUP(ORDER BY wie2.error)

FROM (SELECT DISTINCT TRIM(substrb(wie.error,
instr(wie.error,
':') + 1)) error
FROM wip_interface_errors wie
,wip.wip_job_schedule_interface wjs
WHERE wie.interface_id = wjs.interface_id
AND wie.error IS NOT NULL
AND rownum <= 5
AND wjs.group_id = -999) wie2;*/