APPS.AP_ACCTG_DATA_FIX_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 6140: -- po_requisition_lines_all

6136: -- po_headers_all
6137: -- po_headers_archive_all
6138: -- po_rfq_vendors
6139: -- po_vendor_list_entries
6140: -- po_requisition_lines_all
6141: -- po_reqexpress_lines_all
6142: -- This function returns a 1 if it is successful. It returns a 0
6143: -- if there are exceptions.
6144: --PARAMETERS : new_vendor_contact_id - this is the new vendor contact id that

Line 6187: l_debug_info := 'Updating po_requisition_lines_all';

6183: UPDATE po_vendor_list_entries
6184: SET vendor_contact_id = new_vendor_contact_id
6185: WHERE vendor_contact_id = old_vendor_contact_id;
6186:
6187: l_debug_info := 'Updating po_requisition_lines_all';
6188: UPDATE po_requisition_lines_all
6189: SET vendor_contact_id = new_vendor_contact_id
6190: WHERE vendor_contact_id = old_vendor_contact_id;
6191:

Line 6188: UPDATE po_requisition_lines_all

6184: SET vendor_contact_id = new_vendor_contact_id
6185: WHERE vendor_contact_id = old_vendor_contact_id;
6186:
6187: l_debug_info := 'Updating po_requisition_lines_all';
6188: UPDATE po_requisition_lines_all
6189: SET vendor_contact_id = new_vendor_contact_id
6190: WHERE vendor_contact_id = old_vendor_contact_id;
6191:
6192: l_debug_info := 'Updating po_reqexpress_lines_all';

Line 6220: -- po_requisition_lines_all

6216: -- po_headers_all
6217: -- po_headers_archive_all
6218: -- po_rfq_vendors
6219: -- po_vendor_list_entries
6220: -- po_requisition_lines_all
6221: -- po_reqexpress_lines_all
6222: -- This function returns a 1 if it is successful. It returns a 0
6223: -- if there are exceptions.
6224: --PARAMETERS : p_bug_no - GDF bug that is calling the fix

Line 6315: l_debug_info := 'Updating po_requisition_lines_all';

6311: ) a
6312: on (poh.vendor_list_entry_id = a.vendor_list_entry_id)
6313: WHEN MATCHED THEN UPDATE SET poh.vendor_contact_id = a.new_vendor_contact_id';
6314:
6315: l_debug_info := 'Updating po_requisition_lines_all';
6316:
6317: EXECUTE IMMEDIATE
6318: 'MERGE INTO po_requisition_lines_all poh
6319: USING (SELECT DISTINCT poh.requisition_line_id,

Line 6318: 'MERGE INTO po_requisition_lines_all poh

6314:
6315: l_debug_info := 'Updating po_requisition_lines_all';
6316:
6317: EXECUTE IMMEDIATE
6318: 'MERGE INTO po_requisition_lines_all poh
6319: USING (SELECT DISTINCT poh.requisition_line_id,
6320: tmp.new_vendor_contact_id,
6321: tmp.current_vendor_contact_id
6322: FROM '|| p_driver_table || ' tmp,'||

Line 6323: 'po_requisition_lines_all poh

6319: USING (SELECT DISTINCT poh.requisition_line_id,
6320: tmp.new_vendor_contact_id,
6321: tmp.current_vendor_contact_id
6322: FROM '|| p_driver_table || ' tmp,'||
6323: 'po_requisition_lines_all poh
6324: WHERE poh.vendor_contact_id = tmp.current_vendor_contact_id
6325: and tmp.current_vendor_contact_id <> tmp.new_vendor_contact_id --bug13863902
6326: AND tmp.process_flag = ''Y''
6327: ) a