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 138: last_update_date = arp_global.last_update_date,

134:
135: --Bug 10023214.
136: UPDATE ar_cons_inv
137: SET status = 'ACCEPTED',
138: last_update_date = arp_global.last_update_date,
139: last_updated_by = arp_global.last_updated_by,
140: last_update_login = arp_global.last_update_login
141: WHERE customer_id in (select cust_account_id
142: from hz_cust_accounts c

Line 139: last_updated_by = arp_global.last_updated_by,

135: --Bug 10023214.
136: UPDATE ar_cons_inv
137: SET status = 'ACCEPTED',
138: last_update_date = arp_global.last_update_date,
139: last_updated_by = arp_global.last_updated_by,
140: last_update_login = arp_global.last_update_login
141: WHERE customer_id in (select cust_account_id
142: from hz_cust_accounts c
143: where c.account_number

Line 140: last_update_login = arp_global.last_update_login

136: UPDATE ar_cons_inv
137: SET status = 'ACCEPTED',
138: last_update_date = arp_global.last_update_date,
139: last_updated_by = arp_global.last_updated_by,
140: last_update_login = arp_global.last_update_login
141: WHERE customer_id in (select cust_account_id
142: from hz_cust_accounts c
143: where c.account_number
144: between nvl(P_cust_num_low, c.account_number)

Line 233: last_update_date = arp_global.last_update_date,

229: --Bug 10023214
230: UPDATE ar_cons_inv
231: SET status = 'PRE_REJECTED',
232: print_status = 'PRINTED',
233: last_update_date = arp_global.last_update_date,
234: last_updated_by = arp_global.last_updated_by,
235: last_update_login = arp_global.last_update_login
236: WHERE customer_id in (select cust_account_id
237: from hz_cust_accounts c

Line 234: last_updated_by = arp_global.last_updated_by,

230: UPDATE ar_cons_inv
231: SET status = 'PRE_REJECTED',
232: print_status = 'PRINTED',
233: last_update_date = arp_global.last_update_date,
234: last_updated_by = arp_global.last_updated_by,
235: last_update_login = arp_global.last_update_login
236: WHERE customer_id in (select cust_account_id
237: from hz_cust_accounts c
238: where c.account_number

Line 235: last_update_login = arp_global.last_update_login

231: SET status = 'PRE_REJECTED',
232: print_status = 'PRINTED',
233: last_update_date = arp_global.last_update_date,
234: last_updated_by = arp_global.last_updated_by,
235: last_update_login = arp_global.last_update_login
236: WHERE customer_id in (select cust_account_id
237: from hz_cust_accounts c
238: where c.account_number
239: between nvl(P_cust_num_low, c.account_number)

Line 1343: arp_global.last_update_date,

1339: l_cons_billno,
1340: L_sites.customer_id,
1341: L_sites.site_id,
1342: arp_standard.profile.request_id,
1343: arp_global.last_update_date,
1344: arp_global.last_updated_by,
1345: arp_global.creation_date,
1346: arp_global.created_by,
1347: arp_global.last_update_login,

Line 1344: arp_global.last_updated_by,

1340: L_sites.customer_id,
1341: L_sites.site_id,
1342: arp_standard.profile.request_id,
1343: arp_global.last_update_date,
1344: arp_global.last_updated_by,
1345: arp_global.creation_date,
1346: arp_global.created_by,
1347: arp_global.last_update_login,
1348: --Bug 5203710 get the cons_inv_type from customer setup

Line 1345: arp_global.creation_date,

1341: L_sites.site_id,
1342: arp_standard.profile.request_id,
1343: arp_global.last_update_date,
1344: arp_global.last_updated_by,
1345: arp_global.creation_date,
1346: arp_global.created_by,
1347: arp_global.last_update_login,
1348: --Bug 5203710 get the cons_inv_type from customer setup
1349: L_sites.cons_inv_type,

Line 1346: arp_global.created_by,

1342: arp_standard.profile.request_id,
1343: arp_global.last_update_date,
1344: arp_global.last_updated_by,
1345: arp_global.creation_date,
1346: arp_global.created_by,
1347: arp_global.last_update_login,
1348: --Bug 5203710 get the cons_inv_type from customer setup
1349: L_sites.cons_inv_type,
1350: P_print_option,

Line 1347: arp_global.last_update_login,

1343: arp_global.last_update_date,
1344: arp_global.last_updated_by,
1345: arp_global.creation_date,
1346: arp_global.created_by,
1347: arp_global.last_update_login,
1348: --Bug 5203710 get the cons_inv_type from customer setup
1349: L_sites.cons_inv_type,
1350: P_print_option,
1351: P_print_status,

Line 2777: last_update_date = arp_global.last_update_date,

2773: END IF;
2774:
2775: UPDATE ar_cons_inv
2776: SET print_status = 'PRINTED',
2777: last_update_date = arp_global.last_update_date,
2778: last_updated_by = arp_global.last_updated_by,
2779: last_update_login = arp_global.last_update_login
2780: WHERE (P_print_option = 'REPRINT'
2781: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)

Line 2778: last_updated_by = arp_global.last_updated_by,

2774:
2775: UPDATE ar_cons_inv
2776: SET print_status = 'PRINTED',
2777: last_update_date = arp_global.last_update_date,
2778: last_updated_by = arp_global.last_updated_by,
2779: last_update_login = arp_global.last_update_login
2780: WHERE (P_print_option = 'REPRINT'
2781: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)
2782: AND concurrent_request_id = DECODE (P_consinv_id,

Line 2779: last_update_login = arp_global.last_update_login

2775: UPDATE ar_cons_inv
2776: SET print_status = 'PRINTED',
2777: last_update_date = arp_global.last_update_date,
2778: last_updated_by = arp_global.last_updated_by,
2779: last_update_login = arp_global.last_update_login
2780: WHERE (P_print_option = 'REPRINT'
2781: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)
2782: AND concurrent_request_id = DECODE (P_consinv_id,
2783: NULL, P_request_id,