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 151: l_debug_info := 'Getting next sequence from ap_invoices_interface_s';

147: -- Get sequence-generated invoice_id if this is the first line
148: --
149: if (l_count = 1) then
150: -----------------------------------------------------------------------
151: l_debug_info := 'Getting next sequence from ap_invoices_interface_s';
152: -----------------------------------------------------------------------
153: select ap_invoices_interface_s.nextval
154: into l_invoice_id
155: from dual;

Line 153: select ap_invoices_interface_s.nextval

149: if (l_count = 1) then
150: -----------------------------------------------------------------------
151: l_debug_info := 'Getting next sequence from ap_invoices_interface_s';
152: -----------------------------------------------------------------------
153: select ap_invoices_interface_s.nextval
154: into l_invoice_id
155: from dual;
156:
157: P_INVOICE_ID := l_invoice_id;

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

269: close lines_cursor;
270:
271: --
272: -- If any records were inserted into AP_INVOICE_LINES_INTERFACE
273: -- then insert a single header record into AP_INVOICES_INTERFACE.
274: --
275: if (l_count > 0) then
276: --
277: -- Need vendor (payee) information from AP_CARD_PROGRAMS

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

288: from ap_card_programs
289: where card_program_id = P_CARD_PROGRAM_ID;
290:
291: -----------------------------------------------------------------------
292: l_debug_info := 'Inserting into AP_INVOICES_INTERFACE';
293: -----------------------------------------------------------------------
294: insert into AP_INVOICES_INTERFACE
295: (INVOICE_ID,
296: INVOICE_NUM,

Line 294: insert into AP_INVOICES_INTERFACE

290:
291: -----------------------------------------------------------------------
292: l_debug_info := 'Inserting into AP_INVOICES_INTERFACE';
293: -----------------------------------------------------------------------
294: insert into AP_INVOICES_INTERFACE
295: (INVOICE_ID,
296: INVOICE_NUM,
297: VENDOR_ID,
298: VENDOR_SITE_ID,