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.ARP_CTLGD_PKG dependencies on RA_CUSTOMER_TRX

Line 300: ra_customer_trx.customer_trx_id%type)

296: +===========================================================================*/
297:
298:
299: PROCEDURE display_dist_f_ct_id( p_customer_trx_id IN
300: ra_customer_trx.customer_trx_id%type)
301: IS
302:
303: l_cust_trx_line_gl_dist_id
304: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

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 825: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

821:
822: PROCEDURE bind_dist_variables(
823: p_update_cursor IN integer,
824: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
825: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
826: p_currency_code IN fnd_currencies.currency_code%type,
827: p_precision IN fnd_currencies.precision%type,
828: p_mau IN
829: fnd_currencies.minimum_accountable_unit%type)

Line 1388: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

1384: p_account_set_flag IN
1385: ra_cust_trx_line_gl_dist.account_set_flag%type,
1386: p_account_class IN
1387: ra_cust_trx_line_gl_dist.account_class%type,
1388: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1389: p_currency_code IN fnd_currencies.currency_code%type,
1390: p_precision IN fnd_currencies.precision%type,
1391: p_mau IN
1392: fnd_currencies.minimum_accountable_unit%type,

Line 1693: IN ra_customer_trx.customer_trx_id%type,

1689: | |
1690: +===========================================================================*/
1691:
1692: PROCEDURE lock_f_ct_id( p_customer_trx_id
1693: IN ra_customer_trx.customer_trx_id%type,
1694: p_account_set_flag
1695: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
1696: p_account_class
1697: IN ra_cust_trx_line_gl_dist.account_class%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 2870: IN ra_customer_trx.customer_trx_id%type,

2866: | |
2867: +===========================================================================*/
2868:
2869: procedure delete_f_ct_id( p_customer_trx_id
2870: IN ra_customer_trx.customer_trx_id%type,
2871: p_account_set_flag
2872: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
2873: p_account_class
2874: 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 3114: ra_customer_trx.customer_trx_id%type,

3110: +===========================================================================*/
3111:
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,

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 3217: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3213:
3214: PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3215: p_cust_trx_line_gl_dist_id IN
3216: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3217: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3218: DEFAULT 1,
3219: p_currency_code IN fnd_currencies.currency_code%type
3220: DEFAULT null,
3221: p_precision IN fnd_currencies.precision%type

Line 3300: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

3296: | |
3297: +===========================================================================*/
3298:
3299: PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3300: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3301: p_account_set_flag
3302: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3303: p_account_class
3304: IN ra_cust_trx_line_gl_dist.account_class%type,

Line 3305: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3301: p_account_set_flag
3302: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3303: p_account_class
3304: IN ra_cust_trx_line_gl_dist.account_class%type,
3305: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3306: DEFAULT 1,
3307: p_currency_code IN fnd_currencies.currency_code%type
3308: DEFAULT null,
3309: p_precision IN fnd_currencies.precision%type

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 3393: p_exchange_rate IN ra_customer_trx.exchange_rate%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,
3393: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3394: DEFAULT 1,
3395: p_currency_code IN fnd_currencies.currency_code%type
3396: DEFAULT null,
3397: p_precision IN fnd_currencies.precision%type

Line 3481: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3477: p_account_set_flag
3478: IN ra_cust_trx_line_gl_dist.account_set_flag%type,
3479: p_account_class
3480: IN ra_cust_trx_line_gl_dist.account_class%type,
3481: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3482: DEFAULT 1,
3483: p_currency_code IN fnd_currencies.currency_code%type
3484: DEFAULT null,
3485: p_precision IN fnd_currencies.precision%type

Line 3566: ra_customer_trx.exchange_rate%type,

3562: PROCEDURE update_acctd_amount(p_customer_trx_id IN number,
3563: p_base_curr_code IN
3564: fnd_currencies.currency_code%type,
3565: p_exchange_rate IN
3566: ra_customer_trx.exchange_rate%type,
3567: p_base_precision IN
3568: fnd_currencies.precision%type
3569: default null,
3570: p_base_min_acc_unit IN

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,

Line 3662: ra_customer_trx.exchange_rate%type,

3658: fnd_currencies.currency_code%type,
3659: p_base_curr_code IN
3660: fnd_currencies.currency_code%type,
3661: p_exchange_rate IN
3662: ra_customer_trx.exchange_rate%type,
3663: p_base_precision IN
3664: fnd_currencies.precision%type
3665: default null,
3666: p_base_min_acc_unit IN

Line 3766: p_exchange_rate IN ra_customer_trx.exchange_rate%type

3762: PROCEDURE insert_p(
3763: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
3764: p_cust_trx_line_gl_dist_id
3765: OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
3766: p_exchange_rate IN ra_customer_trx.exchange_rate%type
3767: DEFAULT 1,
3768: p_currency_code IN fnd_currencies.currency_code%type
3769: DEFAULT null,
3770: p_precision IN fnd_currencies.precision%type