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_BF_BILL dependencies on ARP_GLOBAL

Line 71: last_update_date = arp_global.last_update_date,

67:
68: BEGIN
69: UPDATE ar_cons_inv
70: SET print_status = 'PENDING',
71: last_update_date = arp_global.last_update_date,
72: last_updated_by = arp_global.last_updated_by,
73: last_update_login = arp_global.last_update_login
74: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
75: AND concurrent_request_id = DECODE(P_consinv_id,

Line 72: last_updated_by = arp_global.last_updated_by,

68: BEGIN
69: UPDATE ar_cons_inv
70: SET print_status = 'PENDING',
71: last_update_date = arp_global.last_update_date,
72: last_updated_by = arp_global.last_updated_by,
73: last_update_login = arp_global.last_update_login
74: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
75: AND concurrent_request_id = DECODE(P_consinv_id,
76: NULL, P_request_id,

Line 73: last_update_login = arp_global.last_update_login

69: UPDATE ar_cons_inv
70: SET print_status = 'PENDING',
71: last_update_date = arp_global.last_update_date,
72: last_updated_by = arp_global.last_updated_by,
73: last_update_login = arp_global.last_update_login
74: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
75: AND concurrent_request_id = DECODE(P_consinv_id,
76: NULL, P_request_id,
77: concurrent_request_id);

Line 148: last_update_date = arp_global.last_update_date,

144: ELSE
145:
146: UPDATE ar_cons_inv
147: SET status = 'ACCEPTED',
148: last_update_date = arp_global.last_update_date,
149: last_updated_by = arp_global.last_updated_by,
150: last_update_login = arp_global.last_update_login
151: WHERE customer_id in (select cust_account_id
152: from hz_cust_accounts c

Line 149: last_updated_by = arp_global.last_updated_by,

145:
146: UPDATE ar_cons_inv
147: SET status = 'ACCEPTED',
148: last_update_date = arp_global.last_update_date,
149: last_updated_by = arp_global.last_updated_by,
150: last_update_login = arp_global.last_update_login
151: WHERE customer_id in (select cust_account_id
152: from hz_cust_accounts c
153: where c.account_number

Line 150: last_update_login = arp_global.last_update_login

146: UPDATE ar_cons_inv
147: SET status = 'ACCEPTED',
148: last_update_date = arp_global.last_update_date,
149: last_updated_by = arp_global.last_updated_by,
150: last_update_login = arp_global.last_update_login
151: WHERE customer_id in (select cust_account_id
152: from hz_cust_accounts c
153: where c.account_number
154: between nvl(P_cust_num_low, c.account_number)

Line 254: last_update_date = arp_global.last_update_date,

250:
251: UPDATE ar_cons_inv
252: SET status = 'PRE_REJECTED',
253: print_status = 'PRINTED',
254: last_update_date = arp_global.last_update_date,
255: last_updated_by = arp_global.last_updated_by,
256: last_update_login = arp_global.last_update_login
257: WHERE customer_id in (select cust_account_id
258: from hz_cust_accounts c

Line 255: last_updated_by = arp_global.last_updated_by,

251: UPDATE ar_cons_inv
252: SET status = 'PRE_REJECTED',
253: print_status = 'PRINTED',
254: last_update_date = arp_global.last_update_date,
255: last_updated_by = arp_global.last_updated_by,
256: last_update_login = arp_global.last_update_login
257: WHERE customer_id in (select cust_account_id
258: from hz_cust_accounts c
259: where c.account_number

Line 256: last_update_login = arp_global.last_update_login

252: SET status = 'PRE_REJECTED',
253: print_status = 'PRINTED',
254: last_update_date = arp_global.last_update_date,
255: last_updated_by = arp_global.last_updated_by,
256: last_update_login = arp_global.last_update_login
257: WHERE customer_id in (select cust_account_id
258: from hz_cust_accounts c
259: where c.account_number
260: between nvl(P_cust_num_low, c.account_number)

Line 1351: arp_global.last_update_date,

1347: l_cons_billno,
1348: L_sites.customer_id,
1349: L_sites.site_id,
1350: arp_standard.profile.request_id,
1351: arp_global.last_update_date,
1352: arp_global.last_updated_by,
1353: arp_global.creation_date,
1354: arp_global.created_by,
1355: arp_global.last_update_login,

Line 1352: arp_global.last_updated_by,

1348: L_sites.customer_id,
1349: L_sites.site_id,
1350: arp_standard.profile.request_id,
1351: arp_global.last_update_date,
1352: arp_global.last_updated_by,
1353: arp_global.creation_date,
1354: arp_global.created_by,
1355: arp_global.last_update_login,
1356: --Bug 5203710 get the cons_inv_type from customer setup

Line 1353: arp_global.creation_date,

1349: L_sites.site_id,
1350: arp_standard.profile.request_id,
1351: arp_global.last_update_date,
1352: arp_global.last_updated_by,
1353: arp_global.creation_date,
1354: arp_global.created_by,
1355: arp_global.last_update_login,
1356: --Bug 5203710 get the cons_inv_type from customer setup
1357: L_sites.cons_inv_type,

Line 1354: arp_global.created_by,

1350: arp_standard.profile.request_id,
1351: arp_global.last_update_date,
1352: arp_global.last_updated_by,
1353: arp_global.creation_date,
1354: arp_global.created_by,
1355: arp_global.last_update_login,
1356: --Bug 5203710 get the cons_inv_type from customer setup
1357: L_sites.cons_inv_type,
1358: P_print_option,

Line 1355: arp_global.last_update_login,

1351: arp_global.last_update_date,
1352: arp_global.last_updated_by,
1353: arp_global.creation_date,
1354: arp_global.created_by,
1355: arp_global.last_update_login,
1356: --Bug 5203710 get the cons_inv_type from customer setup
1357: L_sites.cons_inv_type,
1358: P_print_option,
1359: P_print_status,

Line 2524: last_update_date = arp_global.last_update_date,

2520: END IF;
2521:
2522: UPDATE ar_cons_inv
2523: SET print_status = 'PRINTED',
2524: last_update_date = arp_global.last_update_date,
2525: last_updated_by = arp_global.last_updated_by,
2526: last_update_login = arp_global.last_update_login
2527: WHERE (P_print_option = 'REPRINT'
2528: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)

Line 2525: last_updated_by = arp_global.last_updated_by,

2521:
2522: UPDATE ar_cons_inv
2523: SET print_status = 'PRINTED',
2524: last_update_date = arp_global.last_update_date,
2525: last_updated_by = arp_global.last_updated_by,
2526: last_update_login = arp_global.last_update_login
2527: WHERE (P_print_option = 'REPRINT'
2528: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)
2529: AND concurrent_request_id = DECODE (P_consinv_id,

Line 2526: last_update_login = arp_global.last_update_login

2522: UPDATE ar_cons_inv
2523: SET print_status = 'PRINTED',
2524: last_update_date = arp_global.last_update_date,
2525: last_updated_by = arp_global.last_updated_by,
2526: last_update_login = arp_global.last_update_login
2527: WHERE (P_print_option = 'REPRINT'
2528: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)
2529: AND concurrent_request_id = DECODE (P_consinv_id,
2530: NULL, P_request_id,