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_OPP_MERGE_PKG dependencies on AS_LEAD_CONTACTS_ALL

Line 123: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_party_id';

119: program_id = hz_utility_pub.program_id,
120: program_update_date = sysdate
121: where competitor_id = p_from_fk_id;
122:
123: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_party_id';
124:
125: UPDATE AS_LEAD_CONTACTS_ALL
126: set object_version_number = nvl(object_version_number,0) + 1, contact_party_id = p_to_fk_id,
127: last_update_date = hz_utility_pub.last_update_date,

Line 125: UPDATE AS_LEAD_CONTACTS_ALL

121: where competitor_id = p_from_fk_id;
122:
123: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_party_id';
124:
125: UPDATE AS_LEAD_CONTACTS_ALL
126: set object_version_number = nvl(object_version_number,0) + 1, contact_party_id = p_to_fk_id,
127: last_update_date = hz_utility_pub.last_update_date,
128: last_updated_by = hz_utility_pub.user_id,
129: last_update_login = hz_utility_pub.last_update_login,

Line 136: l_col_name := 'AS_LEAD_CONTACTS_ALL.customer_id';

132: program_id = hz_utility_pub.program_id,
133: program_update_date = sysdate
134: where contact_party_id = p_from_fk_id;
135:
136: l_col_name := 'AS_LEAD_CONTACTS_ALL.customer_id';
137:
138: UPDATE AS_LEAD_CONTACTS_ALL
139: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
140: last_update_date = hz_utility_pub.last_update_date,

Line 138: UPDATE AS_LEAD_CONTACTS_ALL

134: where contact_party_id = p_from_fk_id;
135:
136: l_col_name := 'AS_LEAD_CONTACTS_ALL.customer_id';
137:
138: UPDATE AS_LEAD_CONTACTS_ALL
139: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
140: last_update_date = hz_utility_pub.last_update_date,
141: last_updated_by = hz_utility_pub.user_id,
142: last_update_login = hz_utility_pub.last_update_login,

Line 261: l_col_name := 'AS_LEAD_CONTACTS_ALL.address_id';

257: program_update_date = sysdate
258: where end_user_address_id = p_from_fk_id;
259: */
260:
261: l_col_name := 'AS_LEAD_CONTACTS_ALL.address_id';
262:
263: UPDATE AS_LEAD_CONTACTS_ALL
264: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
265: last_update_date = hz_utility_pub.last_update_date,

Line 263: UPDATE AS_LEAD_CONTACTS_ALL

259: */
260:
261: l_col_name := 'AS_LEAD_CONTACTS_ALL.address_id';
262:
263: UPDATE AS_LEAD_CONTACTS_ALL
264: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
265: last_update_date = hz_utility_pub.last_update_date,
266: last_updated_by = hz_utility_pub.user_id,
267: last_update_login = hz_utility_pub.last_update_login,

Line 331: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_id';

327:
328: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN
329:
330:
331: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_id';
332:
333: UPDATE AS_LEAD_CONTACTS_ALL
334: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
335: last_update_date = hz_utility_pub.last_update_date,

Line 333: UPDATE AS_LEAD_CONTACTS_ALL

329:
330:
331: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_id';
332:
333: UPDATE AS_LEAD_CONTACTS_ALL
334: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
335: last_update_date = hz_utility_pub.last_update_date,
336: last_updated_by = hz_utility_pub.user_id,
337: last_update_login = hz_utility_pub.last_update_login,

Line 346: l_col_name := 'AS_LEAD_CONTACTS_ALL.phone_id';

342: where contact_id = p_from_fk_id;
343:
344: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN
345:
346: l_col_name := 'AS_LEAD_CONTACTS_ALL.phone_id';
347:
348: UPDATE AS_LEAD_CONTACTS_ALL
349: set object_version_number = nvl(object_version_number,0) + 1, phone_id = p_to_fk_id,
350: last_update_date = hz_utility_pub.last_update_date,

Line 348: UPDATE AS_LEAD_CONTACTS_ALL

344: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN
345:
346: l_col_name := 'AS_LEAD_CONTACTS_ALL.phone_id';
347:
348: UPDATE AS_LEAD_CONTACTS_ALL
349: set object_version_number = nvl(object_version_number,0) + 1, phone_id = p_to_fk_id,
350: last_update_date = hz_utility_pub.last_update_date,
351: last_updated_by = hz_utility_pub.user_id,
352: last_update_login = hz_utility_pub.last_update_login,