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_ADJUSTMENTS_PKG dependencies on RA_CUSTOMER_TRX

Line 135: FROM ra_customer_trx ct,ra_cust_trx_types ctt

131:
132: /*Bug 7461503 Changes for adjustment posting */
133: SELECT decode(ctt.post_to_gl,'Y','Y' ,nvl(ctt.adj_post_to_gl,'N'))
134: INTO l_adj_post_to_gl_flag
135: FROM ra_customer_trx ct,ra_cust_trx_types ctt
136: WHERE ct.customer_trx_id=p_adj_rec.customer_trx_id
137: AND ctt.cust_trx_type_id=ct.cust_trx_type_id;
138:
139: IF l_adj_post_to_gl_flag = 'Y' THEN

Line 1069: IN ra_customer_trx.customer_trx_id%type )

1065: | |
1066: +===========================================================================*/
1067:
1068: PROCEDURE lock_f_ct_id( p_customer_trx_id
1069: IN ra_customer_trx.customer_trx_id%type )
1070: IS
1071:
1072: CURSOR LOCK_C IS
1073: SELECT adjustment_id

Line 1121: IN ra_customer_trx.customer_trx_id%type )

1117: | |
1118: +===========================================================================*/
1119:
1120: PROCEDURE lock_f_st_id( p_subsequent_trx_id
1121: IN ra_customer_trx.customer_trx_id%type )
1122: IS
1123:
1124: CURSOR LOCK_C IS
1125: SELECT adjustment_id

Line 1225: IN ra_customer_trx_lines.customer_trx_line_id%type)

1221: | |
1222: +===========================================================================*/
1223:
1224: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
1225: IN ra_customer_trx_lines.customer_trx_line_id%type)
1226: IS
1227:
1228: CURSOR lock_c IS
1229: SELECT adjustment_id

Line 2377: IN ra_customer_trx.customer_trx_id%type)

2373: | |
2374: +===========================================================================*/
2375:
2376: procedure delete_f_ct_id( p_customer_trx_id
2377: IN ra_customer_trx.customer_trx_id%type)
2378: IS
2379:
2380: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2381:

Line 2444: IN ra_customer_trx.customer_trx_id%type)

2440: | |
2441: +===========================================================================*/
2442:
2443: procedure delete_f_st_id( p_subsequent_trx_id
2444: IN ra_customer_trx.customer_trx_id%type)
2445: IS
2446:
2447: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2448:

Line 2579: IN ra_customer_trx_lines.customer_trx_line_id%type)

2575: | |
2576: +===========================================================================*/
2577:
2578: procedure delete_f_ctl_id( p_customer_trx_line_id
2579: IN ra_customer_trx_lines.customer_trx_line_id%type)
2580: IS
2581:
2582: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2583:

Line 2707: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

2703: | |
2704: +===========================================================================*/
2705:
2706: PROCEDURE update_f_ct_id( p_adj_rec IN ar_adjustments%rowtype,
2707: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2708: p_exchange_rate IN ar_payment_schedules.exchange_rate%type)
2709: IS
2710:
2711:

Line 2765: p_subsequent_trx_id IN ra_customer_trx.customer_trx_id%type,

2761: | |
2762: +===========================================================================*/
2763:
2764: PROCEDURE update_f_st_id( p_adj_rec IN ar_adjustments%rowtype,
2765: p_subsequent_trx_id IN ra_customer_trx.customer_trx_id%type,
2766: p_exchange_rate IN ar_payment_schedules.exchange_rate%type)
2767: IS
2768:
2769: BEGIN

Line 2885: ra_customer_trx_lines.customer_trx_line_id%type,

2881: +===========================================================================*/
2882:
2883: PROCEDURE update_f_ctl_id( p_adj_rec IN ar_adjustments%rowtype,
2884: p_customer_trx_line_id IN
2885: ra_customer_trx_lines.customer_trx_line_id%type,
2886: p_exchange_rate IN
2887: ar_payment_schedules.exchange_rate%type)
2888: IS
2889:

Line 3002: FROM ra_customer_trx ct,ra_cust_trx_types ctt

2998: /* Bug 7461503 get value of added flag in transaction types*/
2999:
3000: SELECT decode(ctt.post_to_gl,'Y','Y', nvl(ctt.adj_post_to_gl ,'N'))
3001: INTO l_adj_post_to_gl_flag
3002: FROM ra_customer_trx ct,ra_cust_trx_types ctt
3003: WHERE ct.customer_trx_id=p_adj_rec.customer_trx_id
3004: AND ctt.cust_trx_type_id=ct.cust_trx_type_id;
3005:
3006: