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.

[Home] [Help]

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 62: ap_expense_feed_dists efd,

58: decode(P_ROLLUP_FLAG,
59: 'N',efd.description),
60: efd.org_id -- Bug 5592139
61: from ap_expense_feed_lines efl,
62: ap_expense_feed_dists efd,
63: ap_card_programs cp
64: where efl.feed_line_id = efd.feed_line_id
65: and efl.card_program_id = P_CARD_PROGRAM_ID
66: and efl.card_program_id = cp.card_program_id

Line 102: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;

98: efd.org_id; -- Bug 5620010
99:
100: l_amount number;
101: l_ccid number;
102: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;
103: l_amount_includes_tax_flag
104: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;
105: l_transaction_date date;
106: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := '';

Line 104: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;

100: l_amount number;
101: l_ccid number;
102: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;
103: l_amount_includes_tax_flag
104: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;
105: l_transaction_date date;
106: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := '';
107: l_invoice_currency_code
108: AP_CARD_PROGRAMS.card_program_currency_code%TYPE := '';

Line 106: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := '';

102: l_tax_code AP_EXPENSE_FEED_DISTS.tax_code%TYPE;
103: l_amount_includes_tax_flag
104: AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;
105: l_transaction_date date;
106: l_description AP_EXPENSE_FEED_DISTS.description%TYPE := '';
107: l_invoice_currency_code
108: AP_CARD_PROGRAMS.card_program_currency_code%TYPE := '';
109: l_count number := 0;
110: l_sum number := 0;

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

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

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

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: -----------------------------------------------------------------------
209: update AP_EXPENSE_FEED_DISTS
210: set invoiced_flag = 'Y',
211: INVOICE_ID = l_invoice_id,

Line 209: update AP_EXPENSE_FEED_DISTS

205: --
206: -----------------------------------------------------------------------
207: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS with DIST ID';
208: -----------------------------------------------------------------------
209: update AP_EXPENSE_FEED_DISTS
210: set invoiced_flag = 'Y',
211: INVOICE_ID = l_invoice_id,
212: INVOICE_LINE_ID = l_invoice_line_id
213: where feed_distribution_id = l_feed_distribution_id;

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

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.
223: --
224: -----------------------------------------------------------------------

Line 225: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS';

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: -----------------------------------------------------------------------
227: /*Bug 4997769*/
228: /*Replaced the transaction date by posted date*/
229: update AP_EXPENSE_FEED_DISTS EFD

Line 229: update AP_EXPENSE_FEED_DISTS EFD

225: l_debug_info := 'Updating AP_EXPENSE_FEED_DISTS';
226: -----------------------------------------------------------------------
227: /*Bug 4997769*/
228: /*Replaced the transaction date by posted date*/
229: update AP_EXPENSE_FEED_DISTS EFD
230: set invoiced_flag = 'Y',
231: INVOICE_ID = l_invoice_id,
232: INVOICE_LINE_ID = l_invoice_line_id
233: where nvl(invoiced_flag,'N') = 'N'