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

Line 56: last_update_date = arp_global.last_update_date,

52:
53: BEGIN
54: UPDATE ar_cons_inv
55: SET print_status = 'PENDING',
56: last_update_date = arp_global.last_update_date,
57: last_updated_by = arp_global.last_updated_by,
58: last_update_login = arp_global.last_update_login
59: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
60: AND concurrent_request_id = DECODE(P_consinv_id,

Line 57: last_updated_by = arp_global.last_updated_by,

53: BEGIN
54: UPDATE ar_cons_inv
55: SET print_status = 'PENDING',
56: last_update_date = arp_global.last_update_date,
57: last_updated_by = arp_global.last_updated_by,
58: last_update_login = arp_global.last_update_login
59: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
60: AND concurrent_request_id = DECODE(P_consinv_id,
61: NULL, P_request_id,

Line 58: last_update_login = arp_global.last_update_login

54: UPDATE ar_cons_inv
55: SET print_status = 'PENDING',
56: last_update_date = arp_global.last_update_date,
57: last_updated_by = arp_global.last_updated_by,
58: last_update_login = arp_global.last_update_login
59: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
60: AND concurrent_request_id = DECODE(P_consinv_id,
61: NULL, P_request_id,
62: concurrent_request_id);

Line 133: last_update_date = arp_global.last_update_date,

129:
130: FORALL i IN 1..l_site_use_id.count
131: UPDATE ar_cons_inv
132: SET status = 'MERGED',
133: last_update_date = arp_global.last_update_date,
134: last_updated_by = arp_global.last_updated_by,
135: last_update_login = arp_global.last_update_login
136: WHERE status = 'DRAFT_MERGE'
137: AND site_use_id = l_site_use_id(i)

Line 134: last_updated_by = arp_global.last_updated_by,

130: FORALL i IN 1..l_site_use_id.count
131: UPDATE ar_cons_inv
132: SET status = 'MERGED',
133: last_update_date = arp_global.last_update_date,
134: last_updated_by = arp_global.last_updated_by,
135: last_update_login = arp_global.last_update_login
136: WHERE status = 'DRAFT_MERGE'
137: AND site_use_id = l_site_use_id(i)
138: AND currency_code = l_currency_code(i)

Line 135: last_update_login = arp_global.last_update_login

131: UPDATE ar_cons_inv
132: SET status = 'MERGED',
133: last_update_date = arp_global.last_update_date,
134: last_updated_by = arp_global.last_updated_by,
135: last_update_login = arp_global.last_update_login
136: WHERE status = 'DRAFT_MERGE'
137: AND site_use_id = l_site_use_id(i)
138: AND currency_code = l_currency_code(i)
139: AND cut_off_date <= l_cut_off_date(i) ;

Line 144: last_update_date = arp_global.last_update_date,

140: -- bug2778646 end
141:
142: UPDATE ar_cons_inv
143: SET status = 'ACCEPTED',
144: last_update_date = arp_global.last_update_date,
145: last_updated_by = arp_global.last_updated_by,
146: last_update_login = arp_global.last_update_login
147: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
148: AND concurrent_request_id = DECODE(P_consinv_id,

Line 145: last_updated_by = arp_global.last_updated_by,

141:
142: UPDATE ar_cons_inv
143: SET status = 'ACCEPTED',
144: last_update_date = arp_global.last_update_date,
145: last_updated_by = arp_global.last_updated_by,
146: last_update_login = arp_global.last_update_login
147: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
148: AND concurrent_request_id = DECODE(P_consinv_id,
149: NULL, P_request_id,

Line 146: last_update_login = arp_global.last_update_login

142: UPDATE ar_cons_inv
143: SET status = 'ACCEPTED',
144: last_update_date = arp_global.last_update_date,
145: last_updated_by = arp_global.last_updated_by,
146: last_update_login = arp_global.last_update_login
147: WHERE cons_inv_id = nvl(P_consinv_id, cons_inv_id)
148: AND concurrent_request_id = DECODE(P_consinv_id,
149: NULL, P_request_id,
150: concurrent_request_id)

Line 332: last_update_date = arp_global.last_update_date,

328:
329: FORALL i IN 1..l_site_use_id.count
330: UPDATE ar_cons_inv
331: SET status = 'MERGE_PENDING',
332: last_update_date = arp_global.last_update_date,
333: last_updated_by = arp_global.last_updated_by,
334: last_update_login = arp_global.last_update_login
335: WHERE status = 'DRAFT_MERGE'
336: AND site_use_id = l_site_use_id(i)

Line 333: last_updated_by = arp_global.last_updated_by,

329: FORALL i IN 1..l_site_use_id.count
330: UPDATE ar_cons_inv
331: SET status = 'MERGE_PENDING',
332: last_update_date = arp_global.last_update_date,
333: last_updated_by = arp_global.last_updated_by,
334: last_update_login = arp_global.last_update_login
335: WHERE status = 'DRAFT_MERGE'
336: AND site_use_id = l_site_use_id(i)
337: AND currency_code = l_currency_code(i)

Line 334: last_update_login = arp_global.last_update_login

330: UPDATE ar_cons_inv
331: SET status = 'MERGE_PENDING',
332: last_update_date = arp_global.last_update_date,
333: last_updated_by = arp_global.last_updated_by,
334: last_update_login = arp_global.last_update_login
335: WHERE status = 'DRAFT_MERGE'
336: AND site_use_id = l_site_use_id(i)
337: AND currency_code = l_currency_code(i)
338: AND cut_off_date <= l_cut_off_date(i) ;

Line 925: arp_global.last_update_date,

921: l_cons_billno,
922: L_sites.customer_id,
923: L_sites.site_id,
924: arp_standard.profile.request_id,
925: arp_global.last_update_date,
926: arp_global.last_updated_by,
927: arp_global.creation_date,
928: arp_global.created_by,
929: arp_global.last_update_login,

Line 926: arp_global.last_updated_by,

922: L_sites.customer_id,
923: L_sites.site_id,
924: arp_standard.profile.request_id,
925: arp_global.last_update_date,
926: arp_global.last_updated_by,
927: arp_global.creation_date,
928: arp_global.created_by,
929: arp_global.last_update_login,
930: C_detail_option,

Line 927: arp_global.creation_date,

923: L_sites.site_id,
924: arp_standard.profile.request_id,
925: arp_global.last_update_date,
926: arp_global.last_updated_by,
927: arp_global.creation_date,
928: arp_global.created_by,
929: arp_global.last_update_login,
930: C_detail_option,
931: DECODE(P_print_option,

Line 928: arp_global.created_by,

924: arp_standard.profile.request_id,
925: arp_global.last_update_date,
926: arp_global.last_updated_by,
927: arp_global.creation_date,
928: arp_global.created_by,
929: arp_global.last_update_login,
930: C_detail_option,
931: DECODE(P_print_option,
932: 'DRAFT', 'DRAFT',

Line 929: arp_global.last_update_login,

925: arp_global.last_update_date,
926: arp_global.last_updated_by,
927: arp_global.creation_date,
928: arp_global.created_by,
929: arp_global.last_update_login,
930: C_detail_option,
931: DECODE(P_print_option,
932: 'DRAFT', 'DRAFT',
933: 'ACCEPTED'),

Line 1769: last_update_date = arp_global.last_update_date,

1765: END IF;
1766:
1767: UPDATE ar_cons_inv
1768: SET print_status = 'PRINTED',
1769: last_update_date = arp_global.last_update_date,
1770: last_updated_by = arp_global.last_updated_by,
1771: last_update_login = arp_global.last_update_login
1772: WHERE (P_print_option = 'REPRINT'
1773: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)

Line 1770: last_updated_by = arp_global.last_updated_by,

1766:
1767: UPDATE ar_cons_inv
1768: SET print_status = 'PRINTED',
1769: last_update_date = arp_global.last_update_date,
1770: last_updated_by = arp_global.last_updated_by,
1771: last_update_login = arp_global.last_update_login
1772: WHERE (P_print_option = 'REPRINT'
1773: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)
1774: AND concurrent_request_id = DECODE (P_consinv_id,

Line 1771: last_update_login = arp_global.last_update_login

1767: UPDATE ar_cons_inv
1768: SET print_status = 'PRINTED',
1769: last_update_date = arp_global.last_update_date,
1770: last_updated_by = arp_global.last_updated_by,
1771: last_update_login = arp_global.last_update_login
1772: WHERE (P_print_option = 'REPRINT'
1773: AND cons_inv_id = nvl(P_consinv_id,cons_inv_id)
1774: AND concurrent_request_id = DECODE (P_consinv_id,
1775: NULL, P_request_id,