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 1401: l_context := 'Inserting into ap_invoice_lines_interface ...';

1397: FOR i IN 1..acc_acnt_tab.COUNT LOOP
1398:
1399: l_lineNumber := l_lineNumber + 1;
1400:
1401: l_context := 'Inserting into ap_invoice_lines_interface ...';
1402:
1403: INSERT INTO ap_invoice_lines_interface
1404: (invoice_id
1405: ,invoice_line_id

Line 1403: INSERT INTO ap_invoice_lines_interface

1399: l_lineNumber := l_lineNumber + 1;
1400:
1401: l_context := 'Inserting into ap_invoice_lines_interface ...';
1402:
1403: INSERT INTO ap_invoice_lines_interface
1404: (invoice_id
1405: ,invoice_line_id
1406: ,line_type_lookup_code
1407: ,amount

Line 1431: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1427: ,tax_classification_code
1428: ,tax_code_override_flag)
1429: VALUES
1430: (l_invoice_id
1431: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1432: ,'ITEM'
1433: ,ROUND(((exp_ap_cache(item).pn_export_currency_amount)
1434: * nvl(acc_acnt_tab(i).percentage,100)/100), l_precision)
1435: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num

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

1478:
1479: FOR i IN 1..exp_acnt_tab.COUNT LOOP
1480:
1481: l_lineNumber := l_lineNumber + 1;
1482: l_context := 'Inserting into ap_invoice_lines_interface ...';
1483:
1484: l_amt := ROUND((l_exp_amt * nvl(exp_acnt_tab(i).percentage,100)/100),l_precision);
1485: l_total_exp_amt := l_total_exp_amt + l_amt;
1486: l_total_exp_percent := l_total_exp_percent + nvl(exp_acnt_tab(i).percentage,100);

Line 1493: INSERT INTO ap_invoice_lines_interface

1489: l_diff_amt := l_total_exp_amt - l_exp_amt;
1490: l_amt := l_amt - l_diff_amt;
1491: END IF;
1492:
1493: INSERT INTO ap_invoice_lines_interface
1494: ( invoice_id
1495: ,invoice_line_id
1496: ,line_type_lookup_code
1497: ,amount

Line 1521: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1517: ,tax_classification_code /*--Bug 6392393--*/
1518: ,tax_code_override_flag)
1519: VALUES
1520: (l_invoice_id
1521: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1522: ,'ITEM'
1523: ,l_amt
1524: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num
1525: ,exp_acnt_tab(i).account_id

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

1860: FOR i IN 1..acc_acnt_tab.COUNT LOOP
1861:
1862: l_lineNumber := l_lineNumber + 1;
1863:
1864: l_context := 'Inserting into ap_invoice_lines_interface ...';
1865:
1866: INSERT INTO ap_invoice_lines_interface
1867: (invoice_id
1868: ,invoice_line_id

Line 1866: INSERT INTO ap_invoice_lines_interface

1862: l_lineNumber := l_lineNumber + 1;
1863:
1864: l_context := 'Inserting into ap_invoice_lines_interface ...';
1865:
1866: INSERT INTO ap_invoice_lines_interface
1867: (invoice_id
1868: ,invoice_line_id
1869: ,line_type_lookup_code
1870: ,amount

Line 1894: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1890: ,tax_classification_code
1891: ,tax_code_override_flag)
1892: values
1893: (l_invoice_id
1894: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1895: ,'ITEM'
1896: ,ROUND(((exp_ap_cache(item).pn_export_currency_amount)
1897: * nvl(acc_acnt_tab(i).percentage,100)/100), l_precision)
1898: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num

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

1941:
1942: FOR i IN 1..exp_acnt_tab.COUNT LOOP
1943:
1944: l_lineNumber := l_lineNumber + 1;
1945: l_context := 'Inserting into ap_invoice_lines_interface ...';
1946:
1947: l_amt := ROUND((l_exp_amt * nvl(exp_acnt_tab(i).percentage,100)/100),l_precision);
1948: l_total_exp_amt := l_total_exp_amt + l_amt;
1949: l_total_exp_percent := l_total_exp_percent + nvl(exp_acnt_tab(i).percentage,100);

Line 1956: INSERT INTO ap_invoice_lines_interface

1952: l_diff_amt := l_total_exp_amt - l_exp_amt;
1953: l_amt := l_amt - l_diff_amt;
1954: END IF;
1955:
1956: INSERT INTO ap_invoice_lines_interface
1957: (invoice_id
1958: ,invoice_line_id
1959: ,line_type_lookup_code
1960: ,amount

Line 1984: ,AP_INVOICE_LINES_INTERFACE_S.nextval

1980: ,tax_classification_code
1981: ,tax_code_override_flag)
1982: VALUES
1983: (l_invoice_id
1984: ,AP_INVOICE_LINES_INTERFACE_S.nextval
1985: ,'ITEM'
1986: ,l_amt
1987: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num
1988: ,exp_acnt_tab(i).account_id