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:

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:
274: -- Start 9267199

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:
274: -- Start 9267199
275: l_default_pay_site_id ap_supplier_sites.vendor_site_id%type;

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:
274: -- Start 9267199
275: l_default_pay_site_id ap_supplier_sites.vendor_site_id%type;
276: l_valid_pay_site_flag VARCHAR2(1);

Line 1651: INSERT INTO ap_invoices_all (

1647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1648: debug_info);
1649: END IF;
1650:
1651: INSERT INTO ap_invoices_all (
1652: org_id,
1653: invoice_id,
1654: last_update_date,
1655: last_updated_by,

Line 1833: l_exc_rate ap_invoices_all.exchange_rate%type;

1829: l_calling_sequence varchar2(2000);
1830: l_success boolean;
1831:
1832: --Bug#12644273
1833: l_exc_rate ap_invoices_all.exchange_rate%type;
1834:
1835: BEGIN
1836:
1837: l_calling_sequence := p_calling_sequence ||' <- Create_dm_Tax';

Line 1858: FROM ap_invoices_all

1854:
1855: --Introduced SELECT for bug#12644273
1856: SELECT exchange_rate
1857: INTO l_exc_rate
1858: FROM ap_invoices_all
1859: WHERE invoice_id= p_invoice_id;
1860:
1861: IF (l_lines_total <> p_invoice_amount and nvl(l_lines_total,0) <> 0) THEN
1862: