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_INVOICE_LINES_INTERFACE

Line 206: l_tax_code_override_flag ap_invoice_lines_interface.tax_code_override_flag%TYPE := NULL;

202: FROM ap_tax_codes_all
203: WHERE tax_id = p_tax_id;
204:
205: l_tax_name ap_tax_codes.name%TYPE;
206: l_tax_code_override_flag ap_invoice_lines_interface.tax_code_override_flag%TYPE := NULL;
207:
208: -- functional currrency code
209:
210: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS

Line 253: l_invoice_line_id ap_invoice_lines_interface.invoice_line_id%type;

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:
257: l_system_grouping_rule_id NUMBER;

Line 1040: -- statement into 'ap_invoice_lines_interface' table.

1036: -- the same invoice number then,
1037: -- DO NOT PROCESS ANY ITEM with that INVOICE_NUM
1038: -- 30-NOV-05 Hareesha o Code changes for LE uptake.
1039: -- 24-SEP-07 rkartha o Bug # 6392393. Added tax_classification_code in the INSERT
1040: -- statement into 'ap_invoice_lines_interface' table.
1041: --------------------------------------------------------------------------------
1042: PROCEDURE group_and_export_items(errbuf IN OUT NOCOPY VARCHAR2,
1043: retcode IN OUT NOCOPY NUMBER,
1044: p_group_id VARCHAR2,

Line 1397: l_context := 'Inserting into ap_invoice_lines_interface ...';

1393: FOR i IN 1..acc_acnt_tab.COUNT LOOP
1394:
1395: l_lineNumber := l_lineNumber + 1;
1396:
1397: l_context := 'Inserting into ap_invoice_lines_interface ...';
1398:
1399: INSERT INTO ap_invoice_lines_interface
1400: (invoice_id
1401: ,invoice_line_id

Line 1399: INSERT INTO ap_invoice_lines_interface

1395: l_lineNumber := l_lineNumber + 1;
1396:
1397: l_context := 'Inserting into ap_invoice_lines_interface ...';
1398:
1399: INSERT INTO ap_invoice_lines_interface
1400: (invoice_id
1401: ,invoice_line_id
1402: ,line_type_lookup_code
1403: ,amount

Line 1426: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1422: ,tax_classification_code
1423: ,tax_code_override_flag)
1424: VALUES
1425: (l_invoice_id
1426: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1427: ,'ITEM'
1428: ,ROUND(((exp_ap_cache(item).pn_export_currency_amount)
1429: * nvl(acc_acnt_tab(i).percentage,100)/100), l_precision)
1430: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num

Line 1476: l_context := 'Inserting into ap_invoice_lines_interface ...';

1472:
1473: FOR i IN 1..exp_acnt_tab.COUNT LOOP
1474:
1475: l_lineNumber := l_lineNumber + 1;
1476: l_context := 'Inserting into ap_invoice_lines_interface ...';
1477:
1478: l_amt := ROUND((l_exp_amt * nvl(exp_acnt_tab(i).percentage,100)/100),l_precision);
1479: l_total_exp_amt := l_total_exp_amt + l_amt;
1480: l_total_exp_percent := l_total_exp_percent + nvl(exp_acnt_tab(i).percentage,100);

Line 1487: INSERT INTO ap_invoice_lines_interface

1483: l_diff_amt := l_total_exp_amt - l_exp_amt;
1484: l_amt := l_amt - l_diff_amt;
1485: END IF;
1486:
1487: INSERT INTO ap_invoice_lines_interface
1488: ( invoice_id
1489: ,invoice_line_id
1490: ,line_type_lookup_code
1491: ,amount

Line 1514: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1510: ,tax_classification_code /*--Bug 6392393--*/
1511: ,tax_code_override_flag)
1512: VALUES
1513: (l_invoice_id
1514: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1515: ,'ITEM'
1516: ,l_amt
1517: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num
1518: ,exp_acnt_tab(i).account_id

Line 1852: l_context := 'Inserting into ap_invoice_lines_interface ...';

1848: FOR i IN 1..acc_acnt_tab.COUNT LOOP
1849:
1850: l_lineNumber := l_lineNumber + 1;
1851:
1852: l_context := 'Inserting into ap_invoice_lines_interface ...';
1853:
1854: INSERT INTO ap_invoice_lines_interface
1855: (invoice_id
1856: ,invoice_line_id

Line 1854: INSERT INTO ap_invoice_lines_interface

1850: l_lineNumber := l_lineNumber + 1;
1851:
1852: l_context := 'Inserting into ap_invoice_lines_interface ...';
1853:
1854: INSERT INTO ap_invoice_lines_interface
1855: (invoice_id
1856: ,invoice_line_id
1857: ,line_type_lookup_code
1858: ,amount

Line 1881: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1877: ,tax_classification_code
1878: ,tax_code_override_flag)
1879: values
1880: (l_invoice_id
1881: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1882: ,'ITEM'
1883: ,ROUND(((exp_ap_cache(item).pn_export_currency_amount)
1884: * nvl(acc_acnt_tab(i).percentage,100)/100), l_precision)
1885: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num

Line 1931: l_context := 'Inserting into ap_invoice_lines_interface ...';

1927:
1928: FOR i IN 1..exp_acnt_tab.COUNT LOOP
1929:
1930: l_lineNumber := l_lineNumber + 1;
1931: l_context := 'Inserting into ap_invoice_lines_interface ...';
1932:
1933: l_amt := ROUND((l_exp_amt * nvl(exp_acnt_tab(i).percentage,100)/100),l_precision);
1934: l_total_exp_amt := l_total_exp_amt + l_amt;
1935: l_total_exp_percent := l_total_exp_percent + nvl(exp_acnt_tab(i).percentage,100);

Line 1942: INSERT INTO ap_invoice_lines_interface

1938: l_diff_amt := l_total_exp_amt - l_exp_amt;
1939: l_amt := l_amt - l_diff_amt;
1940: END IF;
1941:
1942: INSERT INTO ap_invoice_lines_interface
1943: (invoice_id
1944: ,invoice_line_id
1945: ,line_type_lookup_code
1946: ,amount

Line 1969: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1965: ,tax_classification_code
1966: ,tax_code_override_flag)
1967: VALUES
1968: (l_invoice_id
1969: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1970: ,'ITEM'
1971: ,l_amt
1972: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num
1973: ,exp_acnt_tab(i).account_id