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 1259: (AP_INVOICES_INTERFACE_S.nextval

1255: ,exchange_rate
1256: ,exchange_rate_type
1257: ,exchange_date)
1258: VALUES
1259: (AP_INVOICES_INTERFACE_S.nextval
1260: ,NVL(l_invoice_num
1261: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)
1262: ,ROUND(l_header_amount,l_precision)
1263: ,exp_ap_cache(l_start).pn_export_currency_code

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

1768: /* Create the header */
1769:
1770: l_lineNumber := 0;
1771:
1772: l_context := 'Inserting into ap_invoices_interface ...';
1773:
1774: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');
1775:
1776: fnd_currency.get_info(exp_ap_cache(item).pn_export_currency_code,

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

1770: l_lineNumber := 0;
1771:
1772: l_context := 'Inserting into ap_invoices_interface ...';
1773:
1774: pnp_debug_pkg.log(' Inserting into ap_invoices_interface ...');
1775:
1776: fnd_currency.get_info(exp_ap_cache(item).pn_export_currency_code,
1777: l_precision,
1778: l_ext_precision,

Line 1781: INSERT INTO ap_invoices_interface

1777: l_precision,
1778: l_ext_precision,
1779: l_min_acct_unit);
1780:
1781: INSERT INTO ap_invoices_interface
1782: (invoice_id
1783: ,invoice_num
1784: ,invoice_amount
1785: ,invoice_currency_code

Line 1808: (AP_INVOICES_INTERFACE_S.nextval

1804: ,exchange_rate
1805: ,exchange_rate_type
1806: ,exchange_date)
1807: VALUES
1808: (AP_INVOICES_INTERFACE_S.nextval
1809: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval
1810: ,ROUND(exp_ap_cache(item).pn_export_currency_amount,l_precision)
1811: ,exp_ap_cache(item).pn_export_currency_code
1812: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num