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

Line 137: last_update_date = hz_utility_pub.last_update_date,

133: IF l_to_prof_amt_id = FND_API.G_MISS_NUM THEN
134:
135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,

Line 138: last_updated_by = hz_utility_pub.user_id,

134:
135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,

Line 139: last_update_login = hz_utility_pub.last_update_login,

135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate

Line 140: request_id = hz_utility_pub.request_id,

136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate
144: WHERE cust_acct_profile_amt_id = l_rec.cust_acct_profile_amt_id;

Line 141: program_application_id = hz_utility_pub.program_application_id,

137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate
144: WHERE cust_acct_profile_amt_id = l_rec.cust_acct_profile_amt_id;
145:

Line 142: program_id = hz_utility_pub.program_id,

138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate
144: WHERE cust_acct_profile_amt_id = l_rec.cust_acct_profile_amt_id;
145:
146: END IF;

Line 208: last_update_date = hz_utility_pub.last_update_date,

204: -- Site Use Level Stuff
205: -- Transfert
206: UPDATE hz_customer_profiles
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,

Line 209: last_updated_by = hz_utility_pub.user_id,

205: -- Transfert
206: UPDATE hz_customer_profiles
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,

Line 210: last_update_login = hz_utility_pub.last_update_login,

206: UPDATE hz_customer_profiles
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate

Line 211: request_id = hz_utility_pub.request_id,

207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate
215: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;

Line 212: program_application_id = hz_utility_pub.program_application_id,

208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate
215: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
216:

Line 213: program_id = hz_utility_pub.program_id,

209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate
215: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
216:
217:

Line 224: last_update_date = hz_utility_pub.last_update_date,

220: -- Account Level Stuff
221: -- Transfert
222: UPDATE hz_customer_profiles
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,

Line 225: last_updated_by = hz_utility_pub.user_id,

221: -- Transfert
222: UPDATE hz_customer_profiles
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,

Line 226: last_update_login = hz_utility_pub.last_update_login,

222: UPDATE hz_customer_profiles
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate

Line 227: request_id = hz_utility_pub.request_id,

223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;

Line 228: program_application_id = hz_utility_pub.program_application_id,

224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
232:

Line 229: program_id = hz_utility_pub.program_id,

225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
232:
233: ELSE

Line 244: last_update_date = hz_utility_pub.last_update_date,

240:
241: -- Transfert Party Profile
242: UPDATE hz_customer_profiles
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,

Line 245: last_updated_by = hz_utility_pub.user_id,

241: -- Transfert Party Profile
242: UPDATE hz_customer_profiles
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,

Line 246: last_update_login = hz_utility_pub.last_update_login,

242: UPDATE hz_customer_profiles
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate

Line 247: request_id = hz_utility_pub.request_id,

243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate
251: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;

Line 248: program_application_id = hz_utility_pub.program_application_id,

244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate
251: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
252:

Line 249: program_id = hz_utility_pub.program_id,

245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate
251: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
252:
253: ELSE

Line 263: last_update_date = hz_utility_pub.last_update_date,

259: END IF;
260:
261: UPDATE hz_customer_profiles
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,

Line 264: last_updated_by = hz_utility_pub.user_id,

260:
261: UPDATE hz_customer_profiles
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,

Line 265: last_update_login = hz_utility_pub.last_update_login,

261: UPDATE hz_customer_profiles
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate

Line 266: request_id = hz_utility_pub.request_id,

262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate
270: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;

Line 267: program_application_id = hz_utility_pub.program_application_id,

263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate
270: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
271:

Line 268: program_id = hz_utility_pub.program_id,

264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate
270: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
271:
272: END IF;