APPS.AP_ACCTG_DATA_FIX_PKG dependencies on PO_VENDOR_LIST_ENTRIES

Line 6139: -- po_vendor_list_entries

6135: old vendor contact id in
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.

Line 6182: l_debug_info := 'Updating po_vendor_list_entries';

6178: UPDATE po_rfq_vendors
6179: SET vendor_contact_id = new_vendor_contact_id
6180: WHERE vendor_contact_id = old_vendor_contact_id;
6181:
6182: l_debug_info := 'Updating po_vendor_list_entries';
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:

Line 6183: UPDATE po_vendor_list_entries

6179: SET vendor_contact_id = new_vendor_contact_id
6180: WHERE vendor_contact_id = old_vendor_contact_id;
6181:
6182: l_debug_info := 'Updating po_vendor_list_entries';
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';

Line 6219: -- po_vendor_list_entries

6215: old vendor contact id in
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.

Line 6299: l_debug_info := 'Updating po_vendor_list_entries';

6295: ) a
6296: on (poh.po_header_id = a.po_header_id and poh.sequence_num = a.sequence_num)
6297: WHEN MATCHED THEN UPDATE SET poh.vendor_contact_id = a.new_vendor_contact_id';
6298:
6299: l_debug_info := 'Updating po_vendor_list_entries';
6300:
6301: EXECUTE IMMEDIATE
6302: 'MERGE INTO po_vendor_list_entries poh
6303: USING (SELECT DISTINCT poh.vendor_list_entry_id,

Line 6302: 'MERGE INTO po_vendor_list_entries poh

6298:
6299: l_debug_info := 'Updating po_vendor_list_entries';
6300:
6301: EXECUTE IMMEDIATE
6302: 'MERGE INTO po_vendor_list_entries poh
6303: USING (SELECT DISTINCT poh.vendor_list_entry_id,
6304: tmp.new_vendor_contact_id,
6305: tmp.current_vendor_contact_id
6306: FROM '|| p_driver_table || ' tmp,'||

Line 6307: 'po_vendor_list_entries poh

6303: USING (SELECT DISTINCT poh.vendor_list_entry_id,
6304: tmp.new_vendor_contact_id,
6305: tmp.current_vendor_contact_id
6306: FROM '|| p_driver_table || ' tmp,'||
6307: 'po_vendor_list_entries poh
6308: WHERE poh.vendor_contact_id = tmp.current_vendor_contact_id
6309: and tmp.current_vendor_contact_id <> tmp.new_vendor_contact_id --bug13863902
6310: AND tmp.process_flag = ''Y''
6311: ) a