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 1754: IN ra_customer_trx_lines.customer_trx_line_id%type,

1750: | |
1751: +===========================================================================*/
1752:
1753: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
1754: IN ra_customer_trx_lines.customer_trx_line_id%type,
1755: p_account_set_flag
1756: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1757: p_account_class
1758: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 2939: IN ra_customer_trx_lines.customer_trx_line_id%type,

2935: | |
2936: +===========================================================================*/
2937:
2938: procedure delete_f_ctl_id( p_customer_trx_line_id
2939: IN ra_customer_trx_lines.customer_trx_line_id%type,
2940: p_account_set_flag
2941: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2942: p_account_class
2943: IN ra_cust_trx_line_gl_dist.account_class%type)

Line 2967: FROM ra_customer_trx_lines

2963: SELECT sum(nvl(amount,0)), sum(nvl(acctd_amount,0))
2964: INTO l_amt, l_acctd_amt
2965: FROM ra_cust_trx_line_gl_dist
2966: WHERE customer_trx_id = (SELECT customer_trx_id
2967: FROM ra_customer_trx_lines
2968: WHERE customer_trx_line_id = p_customer_trx_line_id)
2969: AND account_class <> 'REC'
2970: AND account_set_flag = 'N';
2971: EXCEPTION

Line 2984: FROM ra_customer_trx_lines

2980: last_updated_by = pg_user_id,
2981: last_update_date = sysdate,
2982: last_update_login = pg_login_id
2983: WHERE customer_trx_id = (SELECT customer_trx_id
2984: FROM ra_customer_trx_lines
2985: WHERE customer_trx_line_id = p_customer_trx_line_id)
2986: and account_class = 'REC'
2987: and account_set_flag = 'N';
2988:

Line 3116: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

3112: PROCEDURE delete_f_ct_ltctl_id_type(
3113: p_customer_trx_id IN
3114: ra_customer_trx.customer_trx_id%type,
3115: p_link_to_cust_trx_line_id IN
3116: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3117: p_line_type IN
3118: ra_customer_trx_lines.line_type%type,
3119: p_account_set_flag IN
3120: ra_cust_trx_line_gl_dist.account_set_flag%type,

Line 3118: ra_customer_trx_lines.line_type%type,

3114: ra_customer_trx.customer_trx_id%type,
3115: p_link_to_cust_trx_line_id IN
3116: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3117: p_line_type IN
3118: ra_customer_trx_lines.line_type%type,
3119: p_account_set_flag IN
3120: ra_cust_trx_line_gl_dist.account_set_flag%type,
3121: p_account_class IN
3122: ra_cust_trx_line_gl_dist.account_class%type)

Line 3135: FROM ra_customer_trx_lines

3131: DELETE FROM ra_cust_trx_line_gl_dist
3132: WHERE customer_trx_id = p_customer_trx_id
3133: AND customer_trx_line_id in
3134: ( SELECT customer_trx_line_id
3135: FROM ra_customer_trx_lines
3136: WHERE customer_trx_id = p_customer_trx_id
3137: AND decode(p_link_to_cust_trx_line_id,
3138: null, -99,
3139: link_to_cust_trx_line_id) =

Line 3388: ra_customer_trx_lines.customer_trx_line_id%type,

3384: +===========================================================================*/
3385:
3386: PROCEDURE update_f_ctl_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3387: p_customer_trx_line_id IN
3388: ra_customer_trx_lines.customer_trx_line_id%type,
3389: p_account_set_flag
3390: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3391: p_account_class
3392: IN ra_cust_trx_line_gl_dist.account_class%type,

Line 3654: ra_customer_trx_lines.customer_trx_line_id%type,

3650: | |
3651: +===========================================================================*/
3652:
3653: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
3654: ra_customer_trx_lines.customer_trx_line_id%type,
3655: p_line_amount IN
3656: ra_customer_trx_lines.extended_amount%type,
3657: p_foreign_currency_code IN
3658: fnd_currencies.currency_code%type,

Line 3656: ra_customer_trx_lines.extended_amount%type,

3652:
3653: PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
3654: ra_customer_trx_lines.customer_trx_line_id%type,
3655: p_line_amount IN
3656: ra_customer_trx_lines.extended_amount%type,
3657: p_foreign_currency_code IN
3658: fnd_currencies.currency_code%type,
3659: p_base_curr_code IN
3660: fnd_currencies.currency_code%type,