APPS.AP_ACCTG_DATA_FIX_PKG dependencies on PO_RFQ_VENDORS

Line 6138: -- po_rfq_vendors

6134: --DESCRIPTION : this fuction will replace the new vendor contact id in place of
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

Line 6177: l_debug_info := 'Updating po_rfq_vendors';

6173: UPDATE po_headers_archive_all
6174: SET vendor_contact_id = new_vendor_contact_id
6175: WHERE vendor_contact_id = old_vendor_contact_id;
6176:
6177: l_debug_info := 'Updating po_rfq_vendors';
6178: UPDATE po_rfq_vendors
6179: SET vendor_contact_id = new_vendor_contact_id
6180: WHERE vendor_contact_id = old_vendor_contact_id;
6181:

Line 6178: UPDATE po_rfq_vendors

6174: SET vendor_contact_id = new_vendor_contact_id
6175: WHERE vendor_contact_id = old_vendor_contact_id;
6176:
6177: l_debug_info := 'Updating po_rfq_vendors';
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';

Line 6218: -- po_rfq_vendors

6214: --DESCRIPTION : this fuction will replace the new vendor contact id in place of
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

Line 6282: l_debug_info := 'Updating po_rfq_vendors';

6278: ) a
6279: on (poh.po_header_id = a.po_header_id and poh.revision_num = a.revision_num)
6280: WHEN MATCHED THEN UPDATE SET poh.vendor_contact_id = a.new_vendor_contact_id';
6281:
6282: l_debug_info := 'Updating po_rfq_vendors';
6283:
6284: EXECUTE IMMEDIATE
6285: 'MERGE INTO po_rfq_vendors poh
6286: USING (SELECT DISTINCT poh.po_header_id,

Line 6285: 'MERGE INTO po_rfq_vendors poh

6281:
6282: l_debug_info := 'Updating po_rfq_vendors';
6283:
6284: EXECUTE IMMEDIATE
6285: 'MERGE INTO po_rfq_vendors poh
6286: USING (SELECT DISTINCT poh.po_header_id,
6287: poh.sequence_num,
6288: tmp.new_vendor_contact_id,
6289: tmp.current_vendor_contact_id

Line 6291: 'po_rfq_vendors poh

6287: poh.sequence_num,
6288: tmp.new_vendor_contact_id,
6289: tmp.current_vendor_contact_id
6290: FROM '|| p_driver_table || ' tmp,'||
6291: 'po_rfq_vendors poh
6292: WHERE poh.vendor_contact_id = tmp.current_vendor_contact_id
6293: and tmp.current_vendor_contact_id <> tmp.new_vendor_contact_id --bug13863902
6294: AND tmp.process_flag = ''Y''
6295: ) a