eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on PO_HEADERS_ALL

Line 6136: -- po_headers_all

6132: -- Bug 10635312 start
6133: /*=============================================================================
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

Line 6167: l_debug_info := 'Updating po_headers_all';

6163: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
6164: FND_LOG.STRING( G_LEVEL_PROCEDURE, G_MODULE_NAME||l_calling_sequence, l_log_msg );
6165: END IF;
6166:
6167: l_debug_info := 'Updating po_headers_all';
6168: UPDATE po_headers_all
6169: SET vendor_contact_id = new_vendor_contact_id
6170: WHERE vendor_contact_id = old_vendor_contact_id;
6171:

Line 6168: UPDATE po_headers_all

6164: FND_LOG.STRING( G_LEVEL_PROCEDURE, G_MODULE_NAME||l_calling_sequence, l_log_msg );
6165: END IF;
6166:
6167: l_debug_info := 'Updating po_headers_all';
6168: UPDATE po_headers_all
6169: SET vendor_contact_id = new_vendor_contact_id
6170: WHERE vendor_contact_id = old_vendor_contact_id;
6171:
6172: l_debug_info := 'Updating po_headers_archive_all';

Line 6216: -- po_headers_all

6212:
6213: /*=============================================================================
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

Line 6249: l_debug_info := 'Updating po_headers_all';

6245: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
6246: FND_LOG.STRING( G_LEVEL_PROCEDURE, G_MODULE_NAME||l_calling_sequence, l_log_msg );
6247: END IF;
6248:
6249: l_debug_info := 'Updating po_headers_all';
6250:
6251: EXECUTE IMMEDIATE
6252: 'MERGE INTO po_headers_all poh
6253: USING (SELECT DISTINCT poh.po_header_id,

Line 6252: 'MERGE INTO po_headers_all poh

6248:
6249: l_debug_info := 'Updating po_headers_all';
6250:
6251: EXECUTE IMMEDIATE
6252: 'MERGE INTO po_headers_all poh
6253: USING (SELECT DISTINCT poh.po_header_id,
6254: tmp.new_vendor_contact_id,
6255: tmp.current_vendor_contact_id
6256: FROM '|| p_driver_table || ' tmp,'||

Line 6257: 'po_headers_all poh

6253: USING (SELECT DISTINCT poh.po_header_id,
6254: tmp.new_vendor_contact_id,
6255: tmp.current_vendor_contact_id
6256: FROM '|| p_driver_table || ' tmp,'||
6257: 'po_headers_all poh
6258: WHERE poh.vendor_contact_id = tmp.current_vendor_contact_id
6259: and tmp.current_vendor_contact_id <> tmp.new_vendor_contact_id --bug13863902
6260: and tmp.process_flag = ''Y''
6261: ) a