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_INVOICE_LINES_INTERFACE

Line 8: -- Inserts records into AP_INVOICE_LINES_INTERFACE and

4: ---------------------------------------------------------------------------
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

Line 12: -- Records inserted into AP_INVOICE_LINES_INTERFACE from

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
14: -- o AP_EXPENSE_FEED_LINES.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
15: -- o AP_EXPENSE_FEED_DISTS.TRANSACTION_DATE between
16: -- P_START_DATE and P_END_DATE.

Line 25: -- to those records inserted into AP_INVOICE_LINES_INTERFACE.

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.
29: -- o AP_EXPENSE_FEED_DISTS.INVOICED_FLAG = 'Y'

Line 165: l_debug_info := 'Getting next sequence from ap_invoice_lines_interface_s';

161: --
162: -- Get sequence-generated invoice_line_id
163: --
164: -----------------------------------------------------------------------
165: l_debug_info := 'Getting next sequence from ap_invoice_lines_interface_s';
166: -----------------------------------------------------------------------
167: select ap_invoice_lines_interface_s.nextval
168: into l_invoice_line_id
169: from dual;

Line 167: select ap_invoice_lines_interface_s.nextval

163: --
164: -----------------------------------------------------------------------
165: l_debug_info := 'Getting next sequence from ap_invoice_lines_interface_s';
166: -----------------------------------------------------------------------
167: select ap_invoice_lines_interface_s.nextval
168: into l_invoice_line_id
169: from dual;
170:
171: -----------------------------------------------------------------------

Line 172: l_debug_info := 'inserting into ap_invoice_lines_interface';

168: into l_invoice_line_id
169: from dual;
170:
171: -----------------------------------------------------------------------
172: l_debug_info := 'inserting into ap_invoice_lines_interface';
173: -----------------------------------------------------------------------
174: insert into ap_invoice_lines_interface
175: (INVOICE_ID,
176: INVOICE_LINE_ID,

Line 174: insert into ap_invoice_lines_interface

170:
171: -----------------------------------------------------------------------
172: l_debug_info := 'inserting into ap_invoice_lines_interface';
173: -----------------------------------------------------------------------
174: insert into ap_invoice_lines_interface
175: (INVOICE_ID,
176: INVOICE_LINE_ID,
177: LINE_NUMBER,
178: LINE_TYPE_LOOKUP_CODE,

Line 201: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.

197:
198: if (l_feed_distribution_id is not null) then
199: --
200: -- Insertion is detail-level, therefore one-to-one correspondence
201: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
202: --
203: -- Update the record AP_EXPENSE_FEED_DISTS with the ID of the
204: -- newly created line in AP_INVOICE_LINES_INTERFACE.
205: --

Line 204: -- newly created line in AP_INVOICE_LINES_INTERFACE.

200: -- Insertion is detail-level, therefore one-to-one correspondence
201: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
202: --
203: -- Update the record AP_EXPENSE_FEED_DISTS with the ID of the
204: -- newly created line in AP_INVOICE_LINES_INTERFACE.
205: --
206: -----------------------------------------------------------------------
207: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS with DIST ID';
208: -----------------------------------------------------------------------

Line 218: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.

214:
215: else
216: --
217: -- Insertion is summary-level, therefore many-to-one correspondence
218: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
219: --
220: -- Update the records AP_EXPENSE_FEED_DISTS matching the group
221: -- criteria of the lines_cursor with the ID of the newly created
222: -- line in AP_INVOICE_LINES_INTERFACE.

Line 222: -- line in AP_INVOICE_LINES_INTERFACE.

218: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
219: --
220: -- Update the records AP_EXPENSE_FEED_DISTS matching the group
221: -- criteria of the lines_cursor with the ID of the newly created
222: -- line in AP_INVOICE_LINES_INTERFACE.
223: --
224: -----------------------------------------------------------------------
225: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS';
226: -----------------------------------------------------------------------

Line 272: -- If any records were inserted into AP_INVOICE_LINES_INTERFACE

268:
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: --