APPS.MSC_A2A_XML_WF dependencies on MSC_PO_RESCHEDULE_INTERFACE

Line 148: DELETE MSC_PO_RESCHEDULE_INTERFACE

144: PROCEDURE PURGE_INTERFACE(p_map_code IN VARCHAR2, p_unique_id IN NUMBER) IS
145: BEGIN
146:
147: IF p_map_code = 'MSC_POO_OAG71_OUT' THEN
148: DELETE MSC_PO_RESCHEDULE_INTERFACE
149: WHERE purchase_order_id = p_unique_id;
150:
151: ELSIF p_map_code = 'MSC_REQUISITNO_OAG71_OUT' THEN
152: DELETE MSC_PO_REQUISITIONS_INTERFACE

Line 241: 'select distinct purchase_order_id from msc_po_reschedule_interface '

237:
238: -- reschedule POs
239:
240: OPEN c_cur FOR
241: 'select distinct purchase_order_id from msc_po_reschedule_interface '
242: ||' where sr_instance_id = :instance_id' USING p_instance_id;
243:
244: LOOP
245: