DBA Data[Home] [Help]

APPS.MSC_REL_WF dependencies on MSC_PO_RESCHEDULE_INTERFACE

Line 996: -- xml fix : for legacy instances insert into msc_po_reschedule_interface

992: when NO_DATA_FOUND then
993: null;
994: end;
995:
996: -- xml fix : for legacy instances insert into msc_po_reschedule_interface
997:
998: begin
999: if (p_plan_type>100) then --- rp plan
1000: SELECT s.sr_instance_id,

Line 1114: INSERT INTO msc_po_reschedule_interface

1110: s.disposition_id,s.po_line_id, s.order_number,s.plan_id;
1111: end if;
1112:
1113: forall a in 1..p_po_instance_id.count
1114: INSERT INTO msc_po_reschedule_interface
1115: (process_id,
1116: quantity,
1117: need_by_date,
1118: line_id,

Line 1154: from msc_po_reschedule_interface

1150: v_temp :=0;
1151:
1152: select count(*)
1153: into v_temp
1154: from msc_po_reschedule_interface
1155: where sr_instance_id = cur.sr_instance_id;
1156:
1157: if v_temp > 0 then
1158: arg_po_res_id.extend(1);