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

Line 9: -- AP_INVOICES_INTERFACE to create invoice for credit card issuer

5: --
6: -- Procedure CREATE_INVOICE
7: --
8: -- Inserts records into AP_INVOICE_LINES_INTERFACE and
9: -- AP_INVOICES_INTERFACE to create invoice for credit card issuer
10: -- for payment of records in AP_EXPENSE_FEED_DISTS.
11: --
12: -- Records inserted into AP_INVOICE_LINES_INTERFACE from
13: -- AP_EXPENSE_FEED_DISTS where

Line 24: -- Single record inserted into AP_INVOICES_INTERFACE which serves as header

20: -- These records are summarized (rolled up) by
21: -- AP_EXPENSE_FEED_DISTS.DIST_CODE_COMBINATION_ID, TAX_CODE, and
22: -- AMOUNT_INCLUDES_TAX_FLAG when P_ROLLUP_FLAG = 'Y'
23: --
24: -- Single record inserted into AP_INVOICES_INTERFACE which serves as header
25: -- to those records inserted into AP_INVOICE_LINES_INTERFACE.
26: --
27: -- Records in AP_EXPENSE_FEED_DISTS updated to reflect invoice interface
28: -- insertions.

Line 207: l_debug_info := 'Getting next sequence from ap_invoices_interface_s';

203: -- Get sequence-generated invoice_id if this is the first line
204: --
205: if (l_count = 1) then
206: -----------------------------------------------------------------------
207: l_debug_info := 'Getting next sequence from ap_invoices_interface_s';
208: -----------------------------------------------------------------------
209: select ap_invoices_interface_s.nextval
210: into l_invoice_id
211: from dual;

Line 209: select ap_invoices_interface_s.nextval

205: if (l_count = 1) then
206: -----------------------------------------------------------------------
207: l_debug_info := 'Getting next sequence from ap_invoices_interface_s';
208: -----------------------------------------------------------------------
209: select ap_invoices_interface_s.nextval
210: into l_invoice_id
211: from dual;
212:
213: P_INVOICE_ID := l_invoice_id;

Line 389: -- then insert a single header record into AP_INVOICES_INTERFACE.

385: close lines_cursor;
386:
387: --
388: -- If any records were inserted into AP_INVOICE_LINES_INTERFACE
389: -- then insert a single header record into AP_INVOICES_INTERFACE.
390: --
391: if (l_count > 0) then
392: --
393: -- Need vendor (payee) information from AP_CARD_PROGRAMS

Line 408: l_debug_info := 'Inserting into AP_INVOICES_INTERFACE';

404: from ap_card_programs
405: where card_program_id = P_CARD_PROGRAM_ID;
406:
407: -----------------------------------------------------------------------
408: l_debug_info := 'Inserting into AP_INVOICES_INTERFACE';
409: -----------------------------------------------------------------------
410: insert into AP_INVOICES_INTERFACE
411: (INVOICE_ID,
412: INVOICE_NUM,

Line 410: insert into AP_INVOICES_INTERFACE

406:
407: -----------------------------------------------------------------------
408: l_debug_info := 'Inserting into AP_INVOICES_INTERFACE';
409: -----------------------------------------------------------------------
410: insert into AP_INVOICES_INTERFACE
411: (INVOICE_ID,
412: INVOICE_NUM,
413: VENDOR_ID,
414: VENDOR_SITE_ID,