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

217: --
218: -- Get sequence-generated invoice_line_id
219: --
220: -----------------------------------------------------------------------
221: l_debug_info := 'Getting next sequence from ap_invoice_lines_interface_s';
222: -----------------------------------------------------------------------
223: select ap_invoice_lines_interface_s.nextval
224: into l_invoice_line_id
225: from dual;

Line 223: select ap_invoice_lines_interface_s.nextval

219: --
220: -----------------------------------------------------------------------
221: l_debug_info := 'Getting next sequence from ap_invoice_lines_interface_s';
222: -----------------------------------------------------------------------
223: select ap_invoice_lines_interface_s.nextval
224: into l_invoice_line_id
225: from dual;
226:
227: --Bug 10218303: CTETALA Added code to move transaction date to next open period

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

243: end if;
244:
245:
246: -----------------------------------------------------------------------
247: l_debug_info := 'inserting into ap_invoice_lines_interface';
248: -----------------------------------------------------------------------
249: insert into ap_invoice_lines_interface
250: (INVOICE_ID,
251: INVOICE_LINE_ID,

Line 249: insert into ap_invoice_lines_interface

245:
246: -----------------------------------------------------------------------
247: l_debug_info := 'inserting into ap_invoice_lines_interface';
248: -----------------------------------------------------------------------
249: insert into ap_invoice_lines_interface
250: (INVOICE_ID,
251: INVOICE_LINE_ID,
252: LINE_NUMBER,
253: LINE_TYPE_LOOKUP_CODE,

Line 313: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.

309:
310: if (rec_lines_int.feed_distribution_id is not null) then
311: --
312: -- Insertion is detail-level, therefore one-to-one correspondence
313: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
314: --
315: -- Update the record AP_EXPENSE_FEED_DISTS with the ID of the
316: -- newly created line in AP_INVOICE_LINES_INTERFACE.
317: --

Line 316: -- newly created line in AP_INVOICE_LINES_INTERFACE.

312: -- Insertion is detail-level, therefore one-to-one correspondence
313: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
314: --
315: -- Update the record AP_EXPENSE_FEED_DISTS with the ID of the
316: -- newly created line in AP_INVOICE_LINES_INTERFACE.
317: --
318: -----------------------------------------------------------------------
319: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS with DIST ID';
320: -----------------------------------------------------------------------

Line 330: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.

326:
327: else
328: --
329: -- Insertion is summary-level, therefore many-to-one correspondence
330: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
331: --
332: -- Update the records AP_EXPENSE_FEED_DISTS matching the group
333: -- criteria of the lines_cursor with the ID of the newly created
334: -- line in AP_INVOICE_LINES_INTERFACE.

Line 334: -- line in AP_INVOICE_LINES_INTERFACE.

330: -- between AP_EXPENSE_FEED_DISTS and AP_INVOICE_LINES_INTERFACE.
331: --
332: -- Update the records AP_EXPENSE_FEED_DISTS matching the group
333: -- criteria of the lines_cursor with the ID of the newly created
334: -- line in AP_INVOICE_LINES_INTERFACE.
335: --
336: -----------------------------------------------------------------------
337: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS';
338: -----------------------------------------------------------------------

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

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