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.AS_TAP_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 144: last_update_date = hz_utility_pub.last_update_date,

140: -- merge party
141: UPDATE AS_ACCESSES_ALL
142: set object_version_number = nvl(object_version_number,0) + 1,
143: customer_id = p_to_fk_id,
144: last_update_date = hz_utility_pub.last_update_date,
145: last_updated_by = hz_utility_pub.user_id,
146: last_update_login = hz_utility_pub.last_update_login,
147: program_application_id=hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,

Line 145: last_updated_by = hz_utility_pub.user_id,

141: UPDATE AS_ACCESSES_ALL
142: set object_version_number = nvl(object_version_number,0) + 1,
143: customer_id = p_to_fk_id,
144: last_update_date = hz_utility_pub.last_update_date,
145: last_updated_by = hz_utility_pub.user_id,
146: last_update_login = hz_utility_pub.last_update_login,
147: program_application_id=hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate

Line 146: last_update_login = hz_utility_pub.last_update_login,

142: set object_version_number = nvl(object_version_number,0) + 1,
143: customer_id = p_to_fk_id,
144: last_update_date = hz_utility_pub.last_update_date,
145: last_updated_by = hz_utility_pub.user_id,
146: last_update_login = hz_utility_pub.last_update_login,
147: program_application_id=hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate
150: where customer_id = p_from_fk_id;

Line 147: program_application_id=hz_utility_pub.program_application_id,

143: customer_id = p_to_fk_id,
144: last_update_date = hz_utility_pub.last_update_date,
145: last_updated_by = hz_utility_pub.user_id,
146: last_update_login = hz_utility_pub.last_update_login,
147: program_application_id=hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate
150: where customer_id = p_from_fk_id;
151:

Line 148: program_id = hz_utility_pub.program_id,

144: last_update_date = hz_utility_pub.last_update_date,
145: last_updated_by = hz_utility_pub.user_id,
146: last_update_login = hz_utility_pub.last_update_login,
147: program_application_id=hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate
150: where customer_id = p_from_fk_id;
151:
152: -- ffang 012204, bug 3395366, party merge for partners

Line 160: last_update_date = hz_utility_pub.last_update_date,

156: salesforce_id=( select resource_id
157: from jtf_rs_resource_extns
158: where category = 'PARTNER'
159: and source_id = p_to_fk_id),
160: last_update_date = hz_utility_pub.last_update_date,
161: last_updated_by = hz_utility_pub.user_id,
162: last_update_login = hz_utility_pub.last_update_login,
163: program_application_id=hz_utility_pub.program_application_id,
164: program_id = hz_utility_pub.program_id,

Line 161: last_updated_by = hz_utility_pub.user_id,

157: from jtf_rs_resource_extns
158: where category = 'PARTNER'
159: and source_id = p_to_fk_id),
160: last_update_date = hz_utility_pub.last_update_date,
161: last_updated_by = hz_utility_pub.user_id,
162: last_update_login = hz_utility_pub.last_update_login,
163: program_application_id=hz_utility_pub.program_application_id,
164: program_id = hz_utility_pub.program_id,
165: program_update_date = sysdate

Line 162: last_update_login = hz_utility_pub.last_update_login,

158: where category = 'PARTNER'
159: and source_id = p_to_fk_id),
160: last_update_date = hz_utility_pub.last_update_date,
161: last_updated_by = hz_utility_pub.user_id,
162: last_update_login = hz_utility_pub.last_update_login,
163: program_application_id=hz_utility_pub.program_application_id,
164: program_id = hz_utility_pub.program_id,
165: program_update_date = sysdate
166: where partner_customer_id = p_from_fk_id;

Line 163: program_application_id=hz_utility_pub.program_application_id,

159: and source_id = p_to_fk_id),
160: last_update_date = hz_utility_pub.last_update_date,
161: last_updated_by = hz_utility_pub.user_id,
162: last_update_login = hz_utility_pub.last_update_login,
163: program_application_id=hz_utility_pub.program_application_id,
164: program_id = hz_utility_pub.program_id,
165: program_update_date = sysdate
166: where partner_customer_id = p_from_fk_id;
167:

Line 164: program_id = hz_utility_pub.program_id,

160: last_update_date = hz_utility_pub.last_update_date,
161: last_updated_by = hz_utility_pub.user_id,
162: last_update_login = hz_utility_pub.last_update_login,
163: program_application_id=hz_utility_pub.program_application_id,
164: program_id = hz_utility_pub.program_id,
165: program_update_date = sysdate
166: where partner_customer_id = p_from_fk_id;
167:
168: -- party merge for partner_cont_party_id

Line 171: last_update_date = hz_utility_pub.last_update_date,

167:
168: -- party merge for partner_cont_party_id
169: UPDATE AS_ACCESSES_ALL
170: set partner_cont_party_id = p_to_fk_id,
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login,
174: program_application_id=hz_utility_pub.program_application_id,
175: program_id = hz_utility_pub.program_id,

Line 172: last_updated_by = hz_utility_pub.user_id,

168: -- party merge for partner_cont_party_id
169: UPDATE AS_ACCESSES_ALL
170: set partner_cont_party_id = p_to_fk_id,
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login,
174: program_application_id=hz_utility_pub.program_application_id,
175: program_id = hz_utility_pub.program_id,
176: program_update_date = sysdate

Line 173: last_update_login = hz_utility_pub.last_update_login,

169: UPDATE AS_ACCESSES_ALL
170: set partner_cont_party_id = p_to_fk_id,
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login,
174: program_application_id=hz_utility_pub.program_application_id,
175: program_id = hz_utility_pub.program_id,
176: program_update_date = sysdate
177: where partner_cont_party_id = p_from_fk_id;

Line 174: program_application_id=hz_utility_pub.program_application_id,

170: set partner_cont_party_id = p_to_fk_id,
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login,
174: program_application_id=hz_utility_pub.program_application_id,
175: program_id = hz_utility_pub.program_id,
176: program_update_date = sysdate
177: where partner_cont_party_id = p_from_fk_id;
178: -- end ffang 012204, bug 3395366

Line 175: program_id = hz_utility_pub.program_id,

171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,
173: last_update_login = hz_utility_pub.last_update_login,
174: program_application_id=hz_utility_pub.program_application_id,
175: program_id = hz_utility_pub.program_id,
176: program_update_date = sysdate
177: where partner_cont_party_id = p_from_fk_id;
178: -- end ffang 012204, bug 3395366
179:

Line 201: last_update_date = hz_utility_pub.last_update_date,

197: -- merge party site
198: UPDATE AS_ACCESSES_ALL
199: set object_version_number = nvl(object_version_number,0) + 1,
200: address_id = p_to_fk_id,
201: last_update_date = hz_utility_pub.last_update_date,
202: last_updated_by = hz_utility_pub.user_id,
203: last_update_login = hz_utility_pub.last_update_login,
204: program_application_id=hz_utility_pub.program_application_id,
205: program_id = hz_utility_pub.program_id,

Line 202: last_updated_by = hz_utility_pub.user_id,

198: UPDATE AS_ACCESSES_ALL
199: set object_version_number = nvl(object_version_number,0) + 1,
200: address_id = p_to_fk_id,
201: last_update_date = hz_utility_pub.last_update_date,
202: last_updated_by = hz_utility_pub.user_id,
203: last_update_login = hz_utility_pub.last_update_login,
204: program_application_id=hz_utility_pub.program_application_id,
205: program_id = hz_utility_pub.program_id,
206: program_update_date = sysdate

Line 203: last_update_login = hz_utility_pub.last_update_login,

199: set object_version_number = nvl(object_version_number,0) + 1,
200: address_id = p_to_fk_id,
201: last_update_date = hz_utility_pub.last_update_date,
202: last_updated_by = hz_utility_pub.user_id,
203: last_update_login = hz_utility_pub.last_update_login,
204: program_application_id=hz_utility_pub.program_application_id,
205: program_id = hz_utility_pub.program_id,
206: program_update_date = sysdate
207: where address_id = p_from_fk_id;

Line 204: program_application_id=hz_utility_pub.program_application_id,

200: address_id = p_to_fk_id,
201: last_update_date = hz_utility_pub.last_update_date,
202: last_updated_by = hz_utility_pub.user_id,
203: last_update_login = hz_utility_pub.last_update_login,
204: program_application_id=hz_utility_pub.program_application_id,
205: program_id = hz_utility_pub.program_id,
206: program_update_date = sysdate
207: where address_id = p_from_fk_id;
208:

Line 205: program_id = hz_utility_pub.program_id,

201: last_update_date = hz_utility_pub.last_update_date,
202: last_updated_by = hz_utility_pub.user_id,
203: last_update_login = hz_utility_pub.last_update_login,
204: program_application_id=hz_utility_pub.program_application_id,
205: program_id = hz_utility_pub.program_id,
206: program_update_date = sysdate
207: where address_id = p_from_fk_id;
208:
209: -- ffang 012204, bug 3395366, party merge for partners

Line 213: last_update_date = hz_utility_pub.last_update_date,

209: -- ffang 012204, bug 3395366, party merge for partners
210: -- party merge for partner_address_id
211: UPDATE AS_ACCESSES_ALL
212: set partner_address_id = p_to_fk_id,
213: last_update_date = hz_utility_pub.last_update_date,
214: last_updated_by = hz_utility_pub.user_id,
215: last_update_login = hz_utility_pub.last_update_login,
216: program_application_id=hz_utility_pub.program_application_id,
217: program_id = hz_utility_pub.program_id,

Line 214: last_updated_by = hz_utility_pub.user_id,

210: -- party merge for partner_address_id
211: UPDATE AS_ACCESSES_ALL
212: set partner_address_id = p_to_fk_id,
213: last_update_date = hz_utility_pub.last_update_date,
214: last_updated_by = hz_utility_pub.user_id,
215: last_update_login = hz_utility_pub.last_update_login,
216: program_application_id=hz_utility_pub.program_application_id,
217: program_id = hz_utility_pub.program_id,
218: program_update_date = sysdate

Line 215: last_update_login = hz_utility_pub.last_update_login,

211: UPDATE AS_ACCESSES_ALL
212: set partner_address_id = p_to_fk_id,
213: last_update_date = hz_utility_pub.last_update_date,
214: last_updated_by = hz_utility_pub.user_id,
215: last_update_login = hz_utility_pub.last_update_login,
216: program_application_id=hz_utility_pub.program_application_id,
217: program_id = hz_utility_pub.program_id,
218: program_update_date = sysdate
219: where partner_address_id = p_from_fk_id;

Line 216: program_application_id=hz_utility_pub.program_application_id,

212: set partner_address_id = p_to_fk_id,
213: last_update_date = hz_utility_pub.last_update_date,
214: last_updated_by = hz_utility_pub.user_id,
215: last_update_login = hz_utility_pub.last_update_login,
216: program_application_id=hz_utility_pub.program_application_id,
217: program_id = hz_utility_pub.program_id,
218: program_update_date = sysdate
219: where partner_address_id = p_from_fk_id;
220: -- end ffang 012204, bug 3395366

Line 217: program_id = hz_utility_pub.program_id,

213: last_update_date = hz_utility_pub.last_update_date,
214: last_updated_by = hz_utility_pub.user_id,
215: last_update_login = hz_utility_pub.last_update_login,
216: program_application_id=hz_utility_pub.program_application_id,
217: program_id = hz_utility_pub.program_id,
218: program_update_date = sysdate
219: where partner_address_id = p_from_fk_id;
220: -- end ffang 012204, bug 3395366
221:

Line 316: last_update_date = hz_utility_pub.last_update_date,

312:
313: UPDATE AS_CHANGED_ACCOUNTS_ALL
314: set object_version_number = nvl(object_version_number,0) + 1,
315: customer_id = p_to_fk_id,
316: last_update_date = hz_utility_pub.last_update_date,
317: last_updated_by = hz_utility_pub.user_id,
318: last_update_login = hz_utility_pub.last_update_login,
319: program_application_id = hz_utility_pub.program_application_id,
320: program_id = hz_utility_pub.program_id,

Line 317: last_updated_by = hz_utility_pub.user_id,

313: UPDATE AS_CHANGED_ACCOUNTS_ALL
314: set object_version_number = nvl(object_version_number,0) + 1,
315: customer_id = p_to_fk_id,
316: last_update_date = hz_utility_pub.last_update_date,
317: last_updated_by = hz_utility_pub.user_id,
318: last_update_login = hz_utility_pub.last_update_login,
319: program_application_id = hz_utility_pub.program_application_id,
320: program_id = hz_utility_pub.program_id,
321: program_update_date = sysdate

Line 318: last_update_login = hz_utility_pub.last_update_login,

314: set object_version_number = nvl(object_version_number,0) + 1,
315: customer_id = p_to_fk_id,
316: last_update_date = hz_utility_pub.last_update_date,
317: last_updated_by = hz_utility_pub.user_id,
318: last_update_login = hz_utility_pub.last_update_login,
319: program_application_id = hz_utility_pub.program_application_id,
320: program_id = hz_utility_pub.program_id,
321: program_update_date = sysdate
322: where customer_id = p_from_fk_id;

Line 319: program_application_id = hz_utility_pub.program_application_id,

315: customer_id = p_to_fk_id,
316: last_update_date = hz_utility_pub.last_update_date,
317: last_updated_by = hz_utility_pub.user_id,
318: last_update_login = hz_utility_pub.last_update_login,
319: program_application_id = hz_utility_pub.program_application_id,
320: program_id = hz_utility_pub.program_id,
321: program_update_date = sysdate
322: where customer_id = p_from_fk_id;
323:

Line 320: program_id = hz_utility_pub.program_id,

316: last_update_date = hz_utility_pub.last_update_date,
317: last_updated_by = hz_utility_pub.user_id,
318: last_update_login = hz_utility_pub.last_update_login,
319: program_application_id = hz_utility_pub.program_application_id,
320: program_id = hz_utility_pub.program_id,
321: program_update_date = sysdate
322: where customer_id = p_from_fk_id;
323:
324:

Line 338: last_update_date = hz_utility_pub.last_update_date,

334:
335: UPDATE AS_CHANGED_ACCOUNTS_ALL
336: set object_version_number = nvl(object_version_number,0) + 1,
337: address_id = p_to_fk_id,
338: last_update_date = hz_utility_pub.last_update_date,
339: last_updated_by = hz_utility_pub.user_id,
340: last_update_login = hz_utility_pub.last_update_login,
341: program_application_id = hz_utility_pub.program_application_id,
342: program_id = hz_utility_pub.program_id,

Line 339: last_updated_by = hz_utility_pub.user_id,

335: UPDATE AS_CHANGED_ACCOUNTS_ALL
336: set object_version_number = nvl(object_version_number,0) + 1,
337: address_id = p_to_fk_id,
338: last_update_date = hz_utility_pub.last_update_date,
339: last_updated_by = hz_utility_pub.user_id,
340: last_update_login = hz_utility_pub.last_update_login,
341: program_application_id = hz_utility_pub.program_application_id,
342: program_id = hz_utility_pub.program_id,
343: program_update_date = sysdate

Line 340: last_update_login = hz_utility_pub.last_update_login,

336: set object_version_number = nvl(object_version_number,0) + 1,
337: address_id = p_to_fk_id,
338: last_update_date = hz_utility_pub.last_update_date,
339: last_updated_by = hz_utility_pub.user_id,
340: last_update_login = hz_utility_pub.last_update_login,
341: program_application_id = hz_utility_pub.program_application_id,
342: program_id = hz_utility_pub.program_id,
343: program_update_date = sysdate
344: where address_id = p_from_fk_id

Line 341: program_application_id = hz_utility_pub.program_application_id,

337: address_id = p_to_fk_id,
338: last_update_date = hz_utility_pub.last_update_date,
339: last_updated_by = hz_utility_pub.user_id,
340: last_update_login = hz_utility_pub.last_update_login,
341: program_application_id = hz_utility_pub.program_application_id,
342: program_id = hz_utility_pub.program_id,
343: program_update_date = sysdate
344: where address_id = p_from_fk_id
345: and customer_id not in(select customer_id from as_changed_accounts_all

Line 342: program_id = hz_utility_pub.program_id,

338: last_update_date = hz_utility_pub.last_update_date,
339: last_updated_by = hz_utility_pub.user_id,
340: last_update_login = hz_utility_pub.last_update_login,
341: program_application_id = hz_utility_pub.program_application_id,
342: program_id = hz_utility_pub.program_id,
343: program_update_date = sysdate
344: where address_id = p_from_fk_id
345: and customer_id not in(select customer_id from as_changed_accounts_all
346: where address_id=p_to_fk_id) ;