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_AUTO_DM_CREATION_PKG dependencies on AP_INVOICES_ALL

Line 264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

260: l_po_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
261: l_dist_tab AP_MATCHING_PKG.DIST_TAB_TYPE;
262: l_error_code VARCHAR2(4000);
263: l_success BOOLEAN;
264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;

Line 266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980

262: l_error_code VARCHAR2(4000);
263: l_success BOOLEAN;
264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;

Line 267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;

263: l_success BOOLEAN;
264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;

Line 268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;

264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980

Line 269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;

265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin

Line 270: l_relationship_id ap_invoices_all.relationship_id%TYPE;

266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin
274:

Line 271: l_remit_party_id ap_invoices_all.party_id%TYPE;

267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin
274:
275: curr_calling_sequence := p_calling_sequence ||' <- Create_DM';

Line 272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980

268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin
274:
275: curr_calling_sequence := p_calling_sequence ||' <- Create_DM';
276: l_invoice_exists := 'N';

Line 1568: INSERT INTO ap_invoices_all (

1564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1565: debug_info);
1566: END IF;
1567:
1568: INSERT INTO ap_invoices_all (
1569: org_id,
1570: invoice_id,
1571: last_update_date,
1572: last_updated_by,