APPS.MSC_A2A_XML_WF dependencies on MSC_WIP_JOB_SCHEDULE_INTERFACE

Line 156: DELETE MSC_WIP_JOB_SCHEDULE_INTERFACE

152: DELETE MSC_PO_REQUISITIONS_INTERFACE
153: WHERE source_line_id = p_unique_id;
154:
155: ELSIF p_map_code = 'MSC_PRODORDERO_OAG71_OUT' THEN
156: DELETE MSC_WIP_JOB_SCHEDULE_INTERFACE
157: WHERE source_line_id = p_unique_id;
158:
159: DELETE MSC_WIP_JOB_DTLS_INTERFACE
160: WHERE parent_header_id = p_unique_id;

Line 163: DELETE MSC_WIP_JOB_SCHEDULE_INTERFACE

159: DELETE MSC_WIP_JOB_DTLS_INTERFACE
160: WHERE parent_header_id = p_unique_id;
161:
162: ELSIF p_map_code = 'MSC_PRODORDERC_OAG71_OUT' THEN
163: DELETE MSC_WIP_JOB_SCHEDULE_INTERFACE
164: WHERE source_line_id = p_unique_id;
165:
166: DELETE MSC_WIP_JOB_DTLS_INTERFACE
167: WHERE parent_header_id = p_unique_id;

Line 281: 'select distinct source_line_id from msc_wip_job_schedule_interface '

277:
278: -- Sync Work Orders
279:
280: OPEN c_cur FOR
281: 'select distinct source_line_id from msc_wip_job_schedule_interface '
282: ||' where sr_instance_id = :instance_id'
283: ||' and load_type in (3,6)' USING p_instance_id;
284:
285: LOOP

Line 302: 'select distinct source_line_id from msc_wip_job_schedule_interface '

298:
299: -- Create Work Orders
300:
301: OPEN c_cur FOR
302: 'select distinct source_line_id from msc_wip_job_schedule_interface '
303: ||' where sr_instance_id = :instance_id '
304: ||' and load_type not in (3,6)' USING p_instance_id;
305:
306: LOOP