DBA Data[Home] [Help]

APPS.ARP_CTLGD_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 376: ra_customer_trx_lines.customer_trx_line_id%type)

372: +===========================================================================*/
373:
374:
375: PROCEDURE display_dist_f_ctl_id( p_customer_trx_line_id IN
376: ra_customer_trx_lines.customer_trx_line_id%type)
377: IS
378:
379: l_cust_trx_line_gl_dist_id
380: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

Line 1749: IN ra_customer_trx_lines.customer_trx_line_id%type,

1745: | |
1746: +===========================================================================*/
1747:
1748: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
1749: IN ra_customer_trx_lines.customer_trx_line_id%type,
1750: p_account_set_flag
1751: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1752: p_account_class
1753: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 2925: IN ra_customer_trx_lines.customer_trx_line_id%type,

2921: | |
2922: +===========================================================================*/
2923:
2924: procedure delete_f_ctl_id( p_customer_trx_line_id
2925: IN ra_customer_trx_lines.customer_trx_line_id%type,
2926: p_account_set_flag
2927: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2928: p_account_class
2929: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

3069: PROCEDURE delete_f_ct_ltctl_id_type(
3070: p_customer_trx_id IN
3071: ra_customer_trx.customer_trx_id%type,
3072: p_link_to_cust_trx_line_id IN
3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3074: p_line_type IN
3075: ra_customer_trx_lines.line_type%type,
3076: p_account_set_flag IN
3077: ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 3075: ra_customer_trx_lines.line_type%type,

3071: ra_customer_trx.customer_trx_id%type,
3072: p_link_to_cust_trx_line_id IN
3073: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3074: p_line_type IN
3075: ra_customer_trx_lines.line_type%type,
3076: p_account_set_flag IN
3077: ra_cust_trx_line_gl_dist.account_set_flag%type,
3078: p_account_class IN
3079: ra_cust_trx_line_gl_dist.account_class%type)

Line 3092: FROM ra_customer_trx_lines

3088: DELETE FROM ra_cust_trx_line_gl_dist
3089: WHERE customer_trx_id = p_customer_trx_id
3090: AND customer_trx_line_id in
3091: ( SELECT customer_trx_line_id
3092: FROM ra_customer_trx_lines
3093: WHERE customer_trx_id = p_customer_trx_id
3094: AND decode(p_link_to_cust_trx_line_id,
3095: null, -99,
3096: link_to_cust_trx_line_id) =

Line 3332: ra_customer_trx_lines.customer_trx_line_id%type,

3328: +===========================================================================*/
3329:
3330: PROCEDURE update_f_ctl_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3331: p_customer_trx_line_id IN
3332: ra_customer_trx_lines.customer_trx_line_id%type,
3333: p_account_set_flag
3334: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3335: p_account_class
3336: IN ra_cust_trx_line_gl_dist.account_class%type,

Line 3600: ra_customer_trx_lines.customer_trx_line_id%type,

3596: | |
3597: +===========================================================================*/
3598:
3599: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
3600: ra_customer_trx_lines.customer_trx_line_id%type,
3601: p_line_amount IN
3602: ra_customer_trx_lines.extended_amount%type,
3603: p_foreign_currency_code IN
3604: fnd_currencies.currency_code%type,

Line 3602: ra_customer_trx_lines.extended_amount%type,

3598:
3599: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
3600: ra_customer_trx_lines.customer_trx_line_id%type,
3601: p_line_amount IN
3602: ra_customer_trx_lines.extended_amount%type,
3603: p_foreign_currency_code IN
3604: fnd_currencies.currency_code%type,
3605: p_base_curr_code IN
3606: fnd_currencies.currency_code%type,