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_EXPENSE_FEED_DISTS

Line 10: -- for payment of records in AP_EXPENSE_FEED_DISTS.

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
14: -- o AP_EXPENSE_FEED_LINES.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

Line 13: -- AP_EXPENSE_FEED_DISTS where

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.
17: -- o AP_EXPENSE_FEED_DISTS.STATUS = 'APPROVED' or status is

Line 15: -- o AP_EXPENSE_FEED_DISTS.TRANSACTION_DATE between

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.
17: -- o AP_EXPENSE_FEED_DISTS.STATUS = 'APPROVED' or status is
18: -- not excepted from payment as defined at the card program
19: --

Line 17: -- o AP_EXPENSE_FEED_DISTS.STATUS = 'APPROVED' or status is

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.
17: -- o AP_EXPENSE_FEED_DISTS.STATUS = 'APPROVED' or status is
18: -- not excepted from payment as defined at the card program
19: --
20: -- These records are summarized (rolled up) by
21: -- AP_EXPENSE_FEED_DISTS.DIST_CODE_COMBINATION_ID, TAX_CODE, and

Line 21: -- AP_EXPENSE_FEED_DISTS.DIST_CODE_COMBINATION_ID, TAX_CODE, and

17: -- o AP_EXPENSE_FEED_DISTS.STATUS = 'APPROVED' or status is
18: -- not excepted from payment as defined at the card program
19: --
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.

Line 27: -- Records in AP_EXPENSE_FEED_DISTS updated to reflect invoice interface

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'
30: -- o AP_EXPENSE_FEED_DISTS.INVOICE_ID =
31: -- o AP_EXPENSE_FEED_DISTS.INVOICE_LINE_ID =

Line 29: -- o AP_EXPENSE_FEED_DISTS.INVOICED_FLAG = 'Y'

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'
30: -- o AP_EXPENSE_FEED_DISTS.INVOICE_ID =
31: -- o AP_EXPENSE_FEED_DISTS.INVOICE_LINE_ID =
32: --
33: ---------------------------------------------------------------------------

Line 30: -- o AP_EXPENSE_FEED_DISTS.INVOICE_ID =

26: --
27: -- Records in AP_EXPENSE_FEED_DISTS updated to reflect invoice interface
28: -- insertions.
29: -- o AP_EXPENSE_FEED_DISTS.INVOICED_FLAG = 'Y'
30: -- o AP_EXPENSE_FEED_DISTS.INVOICE_ID =
31: -- o AP_EXPENSE_FEED_DISTS.INVOICE_LINE_ID =
32: --
33: ---------------------------------------------------------------------------
34: PROCEDURE CREATE_INVOICE(

Line 31: -- o AP_EXPENSE_FEED_DISTS.INVOICE_LINE_ID =

27: -- Records in AP_EXPENSE_FEED_DISTS updated to reflect invoice interface
28: -- insertions.
29: -- o AP_EXPENSE_FEED_DISTS.INVOICED_FLAG = 'Y'
30: -- o AP_EXPENSE_FEED_DISTS.INVOICE_ID =
31: -- o AP_EXPENSE_FEED_DISTS.INVOICE_LINE_ID =
32: --
33: ---------------------------------------------------------------------------
34: PROCEDURE CREATE_INVOICE(
35: P_CARD_PROGRAM_ID IN NUMBER,

Line 80: ap_expense_feed_dists efd,

76: efd.attribute13,
77: efd.attribute14,
78: efd.attribute15
79: from ap_expense_feed_lines efl,
80: ap_expense_feed_dists efd,
81: ap_card_programs cp
82: where efl.feed_line_id = efd.feed_line_id
83: and efl.card_program_id = P_CARD_PROGRAM_ID
84: and efl.card_program_id = cp.card_program_id

Line 139: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;

135:
136: --Commenting unnecessary variables 14457995.
137: /* l_amount number;
138: l_ccid number;
139: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;
140: l_amount_includes_tax_flag
141: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;
142:
143: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := ''; */

Line 141: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;

137: /* l_amount number;
138: l_ccid number;
139: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;
140: l_amount_includes_tax_flag
141: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;
142:
143: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := ''; */
144: l_invoice_currency_code
145: AP_CARD_PROGRAMS.card_program_currency_code%TYPE := '';

Line 143: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := ''; */

139: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;
140: l_amount_includes_tax_flag
141: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;
142:
143: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := ''; */
144: l_invoice_currency_code
145: AP_CARD_PROGRAMS.card_program_currency_code%TYPE := '';
146: l_transaction_date date;
147: l_count number := 0;

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 315: -- Update the record AP_EXPENSE_FEED_DISTS with the ID of the

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: --
318: -----------------------------------------------------------------------
319: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS with DIST ID';

Line 319: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS with DIST ID';

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: -----------------------------------------------------------------------
321: update AP_EXPENSE_FEED_DISTS
322: set invoiced_flag = 'Y',
323: INVOICE_ID = l_invoice_id,

Line 321: update AP_EXPENSE_FEED_DISTS

317: --
318: -----------------------------------------------------------------------
319: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS with DIST ID';
320: -----------------------------------------------------------------------
321: update AP_EXPENSE_FEED_DISTS
322: set invoiced_flag = 'Y',
323: INVOICE_ID = l_invoice_id,
324: INVOICE_LINE_ID = l_invoice_line_id
325: where feed_distribution_id = rec_lines_int.feed_distribution_id;

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 332: -- Update the records AP_EXPENSE_FEED_DISTS matching the group

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.
335: --
336: -----------------------------------------------------------------------

Line 337: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS';

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: -----------------------------------------------------------------------
339: /*Bug 4997769*/
340: /*Replaced the transaction date by posted date*/
341: update AP_EXPENSE_FEED_DISTS EFD

Line 341: update AP_EXPENSE_FEED_DISTS EFD

337: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS';
338: -----------------------------------------------------------------------
339: /*Bug 4997769*/
340: /*Replaced the transaction date by posted date*/
341: update AP_EXPENSE_FEED_DISTS EFD
342: set invoiced_flag = 'Y',
343: INVOICE_ID = l_invoice_id,
344: INVOICE_LINE_ID = l_invoice_line_id
345: where nvl(invoiced_flag,'N') = 'N'