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 146: last_update_date = hz_utility_pub.last_update_date,

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

Line 147: last_updated_by = hz_utility_pub.user_id,

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

Line 148: last_update_login = hz_utility_pub.last_update_login,

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

Line 149: program_application_id=hz_utility_pub.program_application_id,

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

Line 150: program_id = hz_utility_pub.program_id,

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

Line 164: last_update_date = hz_utility_pub.last_update_date,

160: salesforce_id=( select resource_id
161: from jtf_rs_resource_extns
162: where category = 'PARTNER'
163: and source_id = p_to_fk_id),
164: last_update_date = hz_utility_pub.last_update_date,
165: last_updated_by = hz_utility_pub.user_id,
166: last_update_login = hz_utility_pub.last_update_login,
167: program_application_id=hz_utility_pub.program_application_id,
168: program_id = hz_utility_pub.program_id,

Line 165: last_updated_by = hz_utility_pub.user_id,

161: from jtf_rs_resource_extns
162: where category = 'PARTNER'
163: and source_id = p_to_fk_id),
164: last_update_date = hz_utility_pub.last_update_date,
165: last_updated_by = hz_utility_pub.user_id,
166: last_update_login = hz_utility_pub.last_update_login,
167: program_application_id=hz_utility_pub.program_application_id,
168: program_id = hz_utility_pub.program_id,
169: program_update_date = sysdate

Line 166: last_update_login = hz_utility_pub.last_update_login,

162: where category = 'PARTNER'
163: and source_id = p_to_fk_id),
164: last_update_date = hz_utility_pub.last_update_date,
165: last_updated_by = hz_utility_pub.user_id,
166: last_update_login = hz_utility_pub.last_update_login,
167: program_application_id=hz_utility_pub.program_application_id,
168: program_id = hz_utility_pub.program_id,
169: program_update_date = sysdate
170: where partner_customer_id = p_from_fk_id;

Line 167: program_application_id=hz_utility_pub.program_application_id,

163: and source_id = p_to_fk_id),
164: last_update_date = hz_utility_pub.last_update_date,
165: last_updated_by = hz_utility_pub.user_id,
166: last_update_login = hz_utility_pub.last_update_login,
167: program_application_id=hz_utility_pub.program_application_id,
168: program_id = hz_utility_pub.program_id,
169: program_update_date = sysdate
170: where partner_customer_id = p_from_fk_id;
171: Exception

Line 168: program_id = hz_utility_pub.program_id,

164: last_update_date = hz_utility_pub.last_update_date,
165: last_updated_by = hz_utility_pub.user_id,
166: last_update_login = hz_utility_pub.last_update_login,
167: program_application_id=hz_utility_pub.program_application_id,
168: program_id = hz_utility_pub.program_id,
169: program_update_date = sysdate
170: where partner_customer_id = p_from_fk_id;
171: Exception
172: when salesforce_id_null then

Line 176: last_update_date = hz_utility_pub.last_update_date,

172: when salesforce_id_null then
173: FND_FILE.PUT_LINE(FND_FILE.LOG,'At exception: '||sqlerrm);
174: UPDATE AS_ACCESSES_ALL
175: set partner_customer_id = p_to_fk_id,
176: last_update_date = hz_utility_pub.last_update_date,
177: last_updated_by = hz_utility_pub.user_id,
178: last_update_login = hz_utility_pub.last_update_login,
179: program_application_id=hz_utility_pub.program_application_id,
180: program_id = hz_utility_pub.program_id,

Line 177: last_updated_by = hz_utility_pub.user_id,

173: FND_FILE.PUT_LINE(FND_FILE.LOG,'At exception: '||sqlerrm);
174: UPDATE AS_ACCESSES_ALL
175: set partner_customer_id = p_to_fk_id,
176: last_update_date = hz_utility_pub.last_update_date,
177: last_updated_by = hz_utility_pub.user_id,
178: last_update_login = hz_utility_pub.last_update_login,
179: program_application_id=hz_utility_pub.program_application_id,
180: program_id = hz_utility_pub.program_id,
181: program_update_date = sysdate

Line 178: last_update_login = hz_utility_pub.last_update_login,

174: UPDATE AS_ACCESSES_ALL
175: set partner_customer_id = p_to_fk_id,
176: last_update_date = hz_utility_pub.last_update_date,
177: last_updated_by = hz_utility_pub.user_id,
178: last_update_login = hz_utility_pub.last_update_login,
179: program_application_id=hz_utility_pub.program_application_id,
180: program_id = hz_utility_pub.program_id,
181: program_update_date = sysdate
182: where partner_customer_id = p_from_fk_id;

Line 179: program_application_id=hz_utility_pub.program_application_id,

175: set partner_customer_id = p_to_fk_id,
176: last_update_date = hz_utility_pub.last_update_date,
177: last_updated_by = hz_utility_pub.user_id,
178: last_update_login = hz_utility_pub.last_update_login,
179: program_application_id=hz_utility_pub.program_application_id,
180: program_id = hz_utility_pub.program_id,
181: program_update_date = sysdate
182: where partner_customer_id = p_from_fk_id;
183: End;

Line 180: program_id = hz_utility_pub.program_id,

176: last_update_date = hz_utility_pub.last_update_date,
177: last_updated_by = hz_utility_pub.user_id,
178: last_update_login = hz_utility_pub.last_update_login,
179: program_application_id=hz_utility_pub.program_application_id,
180: program_id = hz_utility_pub.program_id,
181: program_update_date = sysdate
182: where partner_customer_id = p_from_fk_id;
183: End;
184:

Line 188: last_update_date = hz_utility_pub.last_update_date,

184:
185: -- party merge for partner_cont_party_id
186: UPDATE AS_ACCESSES_ALL
187: set partner_cont_party_id = p_to_fk_id,
188: last_update_date = hz_utility_pub.last_update_date,
189: last_updated_by = hz_utility_pub.user_id,
190: last_update_login = hz_utility_pub.last_update_login,
191: program_application_id=hz_utility_pub.program_application_id,
192: program_id = hz_utility_pub.program_id,

Line 189: last_updated_by = hz_utility_pub.user_id,

185: -- party merge for partner_cont_party_id
186: UPDATE AS_ACCESSES_ALL
187: set partner_cont_party_id = p_to_fk_id,
188: last_update_date = hz_utility_pub.last_update_date,
189: last_updated_by = hz_utility_pub.user_id,
190: last_update_login = hz_utility_pub.last_update_login,
191: program_application_id=hz_utility_pub.program_application_id,
192: program_id = hz_utility_pub.program_id,
193: program_update_date = sysdate

Line 190: last_update_login = hz_utility_pub.last_update_login,

186: UPDATE AS_ACCESSES_ALL
187: set partner_cont_party_id = p_to_fk_id,
188: last_update_date = hz_utility_pub.last_update_date,
189: last_updated_by = hz_utility_pub.user_id,
190: last_update_login = hz_utility_pub.last_update_login,
191: program_application_id=hz_utility_pub.program_application_id,
192: program_id = hz_utility_pub.program_id,
193: program_update_date = sysdate
194: where partner_cont_party_id = p_from_fk_id;

Line 191: program_application_id=hz_utility_pub.program_application_id,

187: set partner_cont_party_id = p_to_fk_id,
188: last_update_date = hz_utility_pub.last_update_date,
189: last_updated_by = hz_utility_pub.user_id,
190: last_update_login = hz_utility_pub.last_update_login,
191: program_application_id=hz_utility_pub.program_application_id,
192: program_id = hz_utility_pub.program_id,
193: program_update_date = sysdate
194: where partner_cont_party_id = p_from_fk_id;
195: -- end ffang 012204, bug 3395366

Line 192: program_id = hz_utility_pub.program_id,

188: last_update_date = hz_utility_pub.last_update_date,
189: last_updated_by = hz_utility_pub.user_id,
190: last_update_login = hz_utility_pub.last_update_login,
191: program_application_id=hz_utility_pub.program_application_id,
192: program_id = hz_utility_pub.program_id,
193: program_update_date = sysdate
194: where partner_cont_party_id = p_from_fk_id;
195: -- end ffang 012204, bug 3395366
196:

Line 218: last_update_date = hz_utility_pub.last_update_date,

214: -- merge party site
215: UPDATE AS_ACCESSES_ALL
216: set object_version_number = nvl(object_version_number,0) + 1,
217: address_id = p_to_fk_id,
218: last_update_date = hz_utility_pub.last_update_date,
219: last_updated_by = hz_utility_pub.user_id,
220: last_update_login = hz_utility_pub.last_update_login,
221: program_application_id=hz_utility_pub.program_application_id,
222: program_id = hz_utility_pub.program_id,

Line 219: last_updated_by = hz_utility_pub.user_id,

215: UPDATE AS_ACCESSES_ALL
216: set object_version_number = nvl(object_version_number,0) + 1,
217: address_id = p_to_fk_id,
218: last_update_date = hz_utility_pub.last_update_date,
219: last_updated_by = hz_utility_pub.user_id,
220: last_update_login = hz_utility_pub.last_update_login,
221: program_application_id=hz_utility_pub.program_application_id,
222: program_id = hz_utility_pub.program_id,
223: program_update_date = sysdate

Line 220: last_update_login = hz_utility_pub.last_update_login,

216: set object_version_number = nvl(object_version_number,0) + 1,
217: address_id = p_to_fk_id,
218: last_update_date = hz_utility_pub.last_update_date,
219: last_updated_by = hz_utility_pub.user_id,
220: last_update_login = hz_utility_pub.last_update_login,
221: program_application_id=hz_utility_pub.program_application_id,
222: program_id = hz_utility_pub.program_id,
223: program_update_date = sysdate
224: where address_id = p_from_fk_id;

Line 221: program_application_id=hz_utility_pub.program_application_id,

217: address_id = p_to_fk_id,
218: last_update_date = hz_utility_pub.last_update_date,
219: last_updated_by = hz_utility_pub.user_id,
220: last_update_login = hz_utility_pub.last_update_login,
221: program_application_id=hz_utility_pub.program_application_id,
222: program_id = hz_utility_pub.program_id,
223: program_update_date = sysdate
224: where address_id = p_from_fk_id;
225:

Line 222: program_id = hz_utility_pub.program_id,

218: last_update_date = hz_utility_pub.last_update_date,
219: last_updated_by = hz_utility_pub.user_id,
220: last_update_login = hz_utility_pub.last_update_login,
221: program_application_id=hz_utility_pub.program_application_id,
222: program_id = hz_utility_pub.program_id,
223: program_update_date = sysdate
224: where address_id = p_from_fk_id;
225:
226: -- ffang 012204, bug 3395366, party merge for partners

Line 230: last_update_date = hz_utility_pub.last_update_date,

226: -- ffang 012204, bug 3395366, party merge for partners
227: -- party merge for partner_address_id
228: UPDATE AS_ACCESSES_ALL
229: set partner_address_id = p_to_fk_id,
230: last_update_date = hz_utility_pub.last_update_date,
231: last_updated_by = hz_utility_pub.user_id,
232: last_update_login = hz_utility_pub.last_update_login,
233: program_application_id=hz_utility_pub.program_application_id,
234: program_id = hz_utility_pub.program_id,

Line 231: last_updated_by = hz_utility_pub.user_id,

227: -- party merge for partner_address_id
228: UPDATE AS_ACCESSES_ALL
229: set partner_address_id = p_to_fk_id,
230: last_update_date = hz_utility_pub.last_update_date,
231: last_updated_by = hz_utility_pub.user_id,
232: last_update_login = hz_utility_pub.last_update_login,
233: program_application_id=hz_utility_pub.program_application_id,
234: program_id = hz_utility_pub.program_id,
235: program_update_date = sysdate

Line 232: last_update_login = hz_utility_pub.last_update_login,

228: UPDATE AS_ACCESSES_ALL
229: set partner_address_id = p_to_fk_id,
230: last_update_date = hz_utility_pub.last_update_date,
231: last_updated_by = hz_utility_pub.user_id,
232: last_update_login = hz_utility_pub.last_update_login,
233: program_application_id=hz_utility_pub.program_application_id,
234: program_id = hz_utility_pub.program_id,
235: program_update_date = sysdate
236: where partner_address_id = p_from_fk_id;

Line 233: program_application_id=hz_utility_pub.program_application_id,

229: set partner_address_id = p_to_fk_id,
230: last_update_date = hz_utility_pub.last_update_date,
231: last_updated_by = hz_utility_pub.user_id,
232: last_update_login = hz_utility_pub.last_update_login,
233: program_application_id=hz_utility_pub.program_application_id,
234: program_id = hz_utility_pub.program_id,
235: program_update_date = sysdate
236: where partner_address_id = p_from_fk_id;
237: -- end ffang 012204, bug 3395366

Line 234: program_id = hz_utility_pub.program_id,

230: last_update_date = hz_utility_pub.last_update_date,
231: last_updated_by = hz_utility_pub.user_id,
232: last_update_login = hz_utility_pub.last_update_login,
233: program_application_id=hz_utility_pub.program_application_id,
234: program_id = hz_utility_pub.program_id,
235: program_update_date = sysdate
236: where partner_address_id = p_from_fk_id;
237: -- end ffang 012204, bug 3395366
238:

Line 333: last_update_date = hz_utility_pub.last_update_date,

329:
330: UPDATE AS_CHANGED_ACCOUNTS_ALL
331: set object_version_number = nvl(object_version_number,0) + 1,
332: customer_id = p_to_fk_id,
333: last_update_date = hz_utility_pub.last_update_date,
334: last_updated_by = hz_utility_pub.user_id,
335: last_update_login = hz_utility_pub.last_update_login,
336: program_application_id = hz_utility_pub.program_application_id,
337: program_id = hz_utility_pub.program_id,

Line 334: last_updated_by = hz_utility_pub.user_id,

330: UPDATE AS_CHANGED_ACCOUNTS_ALL
331: set object_version_number = nvl(object_version_number,0) + 1,
332: customer_id = p_to_fk_id,
333: last_update_date = hz_utility_pub.last_update_date,
334: last_updated_by = hz_utility_pub.user_id,
335: last_update_login = hz_utility_pub.last_update_login,
336: program_application_id = hz_utility_pub.program_application_id,
337: program_id = hz_utility_pub.program_id,
338: program_update_date = sysdate

Line 335: last_update_login = hz_utility_pub.last_update_login,

331: set object_version_number = nvl(object_version_number,0) + 1,
332: customer_id = p_to_fk_id,
333: last_update_date = hz_utility_pub.last_update_date,
334: last_updated_by = hz_utility_pub.user_id,
335: last_update_login = hz_utility_pub.last_update_login,
336: program_application_id = hz_utility_pub.program_application_id,
337: program_id = hz_utility_pub.program_id,
338: program_update_date = sysdate
339: where customer_id = p_from_fk_id;

Line 336: program_application_id = hz_utility_pub.program_application_id,

332: customer_id = p_to_fk_id,
333: last_update_date = hz_utility_pub.last_update_date,
334: last_updated_by = hz_utility_pub.user_id,
335: last_update_login = hz_utility_pub.last_update_login,
336: program_application_id = hz_utility_pub.program_application_id,
337: program_id = hz_utility_pub.program_id,
338: program_update_date = sysdate
339: where customer_id = p_from_fk_id;
340:

Line 337: program_id = hz_utility_pub.program_id,

333: last_update_date = hz_utility_pub.last_update_date,
334: last_updated_by = hz_utility_pub.user_id,
335: last_update_login = hz_utility_pub.last_update_login,
336: program_application_id = hz_utility_pub.program_application_id,
337: program_id = hz_utility_pub.program_id,
338: program_update_date = sysdate
339: where customer_id = p_from_fk_id;
340:
341:

Line 355: last_update_date = hz_utility_pub.last_update_date,

351:
352: UPDATE AS_CHANGED_ACCOUNTS_ALL
353: set object_version_number = nvl(object_version_number,0) + 1,
354: address_id = p_to_fk_id,
355: last_update_date = hz_utility_pub.last_update_date,
356: last_updated_by = hz_utility_pub.user_id,
357: last_update_login = hz_utility_pub.last_update_login,
358: program_application_id = hz_utility_pub.program_application_id,
359: program_id = hz_utility_pub.program_id,

Line 356: last_updated_by = hz_utility_pub.user_id,

352: UPDATE AS_CHANGED_ACCOUNTS_ALL
353: set object_version_number = nvl(object_version_number,0) + 1,
354: address_id = p_to_fk_id,
355: last_update_date = hz_utility_pub.last_update_date,
356: last_updated_by = hz_utility_pub.user_id,
357: last_update_login = hz_utility_pub.last_update_login,
358: program_application_id = hz_utility_pub.program_application_id,
359: program_id = hz_utility_pub.program_id,
360: program_update_date = sysdate

Line 357: last_update_login = hz_utility_pub.last_update_login,

353: set object_version_number = nvl(object_version_number,0) + 1,
354: address_id = p_to_fk_id,
355: last_update_date = hz_utility_pub.last_update_date,
356: last_updated_by = hz_utility_pub.user_id,
357: last_update_login = hz_utility_pub.last_update_login,
358: program_application_id = hz_utility_pub.program_application_id,
359: program_id = hz_utility_pub.program_id,
360: program_update_date = sysdate
361: where address_id = p_from_fk_id

Line 358: program_application_id = hz_utility_pub.program_application_id,

354: address_id = p_to_fk_id,
355: last_update_date = hz_utility_pub.last_update_date,
356: last_updated_by = hz_utility_pub.user_id,
357: last_update_login = hz_utility_pub.last_update_login,
358: program_application_id = hz_utility_pub.program_application_id,
359: program_id = hz_utility_pub.program_id,
360: program_update_date = sysdate
361: where address_id = p_from_fk_id
362: and customer_id not in(select customer_id from as_changed_accounts_all

Line 359: program_id = hz_utility_pub.program_id,

355: last_update_date = hz_utility_pub.last_update_date,
356: last_updated_by = hz_utility_pub.user_id,
357: last_update_login = hz_utility_pub.last_update_login,
358: program_application_id = hz_utility_pub.program_application_id,
359: program_id = hz_utility_pub.program_id,
360: program_update_date = sysdate
361: where address_id = p_from_fk_id
362: and customer_id not in(select customer_id from as_changed_accounts_all
363: where address_id=p_to_fk_id) ;