APPS.ARP_INSERT_DIST_COVER dependencies on RA_CUSTOMER_TRX

Line 7: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE

3:
4: pg_msg_level_debug binary_integer;
5:
6: FUNCTION set_original_gl_date(
7: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
9: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
10: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
11: RETURN DATE;

Line 8: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE

4: pg_msg_level_debug binary_integer;
5:
6: FUNCTION set_original_gl_date(
7: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
9: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
10: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
11: RETURN DATE;
12:

Line 93: ra_customer_trx.exchange_rate%type,

89: PROCEDURE insert_dist_cover(
90: p_form_name IN varchar2,
91: p_form_version IN number,
92: p_exchange_rate IN
93: ra_customer_trx.exchange_rate%type,
94: p_base_currency_code IN
95: fnd_currencies.currency_code%type,
96: p_base_precision IN
97: fnd_currencies.precision%type,

Line 371: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE

367: | |
368: +===========================================================================*/
369:
370: FUNCTION set_original_gl_date(
371: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
372: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
373: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
374: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
375: RETURN DATE

Line 372: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE

368: +===========================================================================*/
369:
370: FUNCTION set_original_gl_date(
371: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
372: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE
373: ,p_original_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE
374: ,p_account_class IN ra_cust_trx_line_gl_dist.account_class%TYPE)
375: RETURN DATE
376: IS

Line 379: FROM ra_customer_trx_lines ctl,

375: RETURN DATE
376: IS
377: CURSOR c_rule_based_inv IS
378: SELECT ctl.accounting_rule_id, ctt.type
379: FROM ra_customer_trx_lines ctl,
380: ra_cust_trx_types ctt,
381: ra_customer_trx ct
382: WHERE ctl.customer_trx_id = ct.customer_trx_id
383: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 381: ra_customer_trx ct

377: CURSOR c_rule_based_inv IS
378: SELECT ctl.accounting_rule_id, ctt.type
379: FROM ra_customer_trx_lines ctl,
380: ra_cust_trx_types ctt,
381: ra_customer_trx ct
382: WHERE ctl.customer_trx_id = ct.customer_trx_id
383: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
384: AND ctl.customer_trx_line_id = p_customer_trx_line_id;
385:

Line 391: WHERE ra.customer_trx_line_id = p_customer_trx_line_id

387: SELECT ra.gl_date
388: FROM ar_revenue_assignments ra,
389: gl_sets_of_books sob,
390: ar_system_parameters sp
391: WHERE ra.customer_trx_line_id = p_customer_trx_line_id
392: AND sob.set_of_books_id = sp.set_of_books_id
393: AND ra.period_set_name = sob.period_set_name
394: AND ra.account_class = 'REV'
395: and ROWNUM = 1;