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.PN_EXP_TO_AP dependencies on AP_INVOICES_INTERFACE

Line 251: l_invoice_id ap_invoices_interface.invoice_id%type;

247: l_error_ctr NUMBER := 0;
248:
249: -- for interface
250:
251: l_invoice_id ap_invoices_interface.invoice_id%type;
252: l_invoice_num ap_invoices_interface.invoice_num%type;
253: l_invoice_line_id ap_invoice_lines_interface.invoice_line_id%type;
254:
255: -- other variables

Line 252: l_invoice_num ap_invoices_interface.invoice_num%type;

248:
249: -- for interface
250:
251: l_invoice_id ap_invoices_interface.invoice_id%type;
252: l_invoice_num ap_invoices_interface.invoice_num%type;
253: l_invoice_line_id ap_invoice_lines_interface.invoice_line_id%type;
254:
255: -- other variables
256:

Line 694: FROM ap_invoices_interface

690: ,p_org_ID IN NUMBER) IS
691: SELECT 1
692: FROM DUAL
693: WHERE EXISTS(SELECT 1
694: FROM ap_invoices_interface
695: WHERE invoice_num = p_invoice_num
696: AND vendor_id = p_vendor_id
697: AND org_ID = p_org_ID);
698:

Line 1061: FROM ap_invoices_interface

1057: ,p_vendor_id IN NUMBER
1058: ,p_org_ID IN NUMBER) IS
1059: SELECT invoice_id
1060: ,invoice_num
1061: FROM ap_invoices_interface
1062: WHERE invoice_num = p_invoice_num
1063: AND vendor_id = p_vendor_id
1064: AND org_ID = p_org_ID;
1065:

Line 1067: ( invoice_id ap_invoices_interface.invoice_id%TYPE

1063: AND vendor_id = p_vendor_id
1064: AND org_ID = p_org_ID;
1065:
1066: TYPE inv_rec IS RECORD
1067: ( invoice_id ap_invoices_interface.invoice_id%TYPE
1068: ,invoice_num ap_invoices_interface.invoice_num%TYPE
1069: ,items_proc NUMBER);
1070:
1071: TYPE inv_tab IS TABLE OF inv_rec INDEX BY BINARY_INTEGER;

Line 1068: ,invoice_num ap_invoices_interface.invoice_num%TYPE

1064: AND org_ID = p_org_ID;
1065:
1066: TYPE inv_rec IS RECORD
1067: ( invoice_id ap_invoices_interface.invoice_id%TYPE
1068: ,invoice_num ap_invoices_interface.invoice_num%TYPE
1069: ,items_proc NUMBER);
1070:
1071: TYPE inv_tab IS TABLE OF inv_rec INDEX BY BINARY_INTEGER;
1072:

Line 1180: l_context := 'Inserting into ap_invoices_interface ...';

1176: -- Create the header
1177:
1178: l_lineNumber := 0;
1179:
1180: l_context := 'Inserting into ap_invoices_interface ...';
1181:
1182: fnd_currency.get_info(exp_ap_cache(l_start).pn_export_currency_code,
1183: l_precision,
1184: l_ext_precision,

Line 1232: INSERT INTO ap_invoices_interface

1228: END IF;
1229:
1230: SAVEPOINT beforeinsert;
1231:
1232: INSERT INTO ap_invoices_interface
1233: (invoice_id
1234: ,invoice_num
1235: ,invoice_amount
1236: ,invoice_currency_code

Line 1261: (AP_INVOICES_INTERFACE_S.nextval

1257: ,exchange_date
1258: ,CALC_TAX_DURING_IMPORT_FLAG
1259: ,ADD_TAX_TO_INV_AMT_FLAG)--For Bug 9068811
1260: VALUES
1261: (AP_INVOICES_INTERFACE_S.nextval
1262: ,NVL(l_invoice_num
1263: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)
1264: ,ROUND(l_header_amount,l_precision)
1265: ,exp_ap_cache(l_start).pn_export_currency_code

Line 1780: l_context := 'Inserting into ap_invoices_interface ...';

1776: /* Create the header */
1777:
1778: l_lineNumber := 0;
1779:
1780: l_context := 'Inserting into ap_invoices_interface ...';
1781:
1782: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');
1783:
1784: fnd_currency.get_info(exp_ap_cache(item).pn_export_currency_code,

Line 1782: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');

1778: l_lineNumber := 0;
1779:
1780: l_context := 'Inserting into ap_invoices_interface ...';
1781:
1782: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');
1783:
1784: fnd_currency.get_info(exp_ap_cache(item).pn_export_currency_code,
1785: l_precision,
1786: l_ext_precision,

Line 1789: INSERT INTO ap_invoices_interface

1785: l_precision,
1786: l_ext_precision,
1787: l_min_acct_unit);
1788:
1789: INSERT INTO ap_invoices_interface
1790: (invoice_id
1791: ,invoice_num
1792: ,invoice_amount
1793: ,invoice_currency_code

Line 1818: (AP_INVOICES_INTERFACE_S.nextval

1814: ,exchange_date
1815: ,CALC_TAX_DURING_IMPORT_FLAG
1816: ,ADD_TAX_TO_INV_AMT_FLAG)--For Bug 9068811
1817: VALUES
1818: (AP_INVOICES_INTERFACE_S.nextval
1819: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval
1820: ,ROUND(exp_ap_cache(item).pn_export_currency_amount,l_precision)
1821: ,exp_ap_cache(item).pn_export_currency_code
1822: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num