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_INTEREST_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 91: last_update_date = hz_utility_pub.last_update_date,

87: BEGIN
88: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
89: UPDATE AS_INTERESTS_ALL
90: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
91: last_update_date = hz_utility_pub.last_update_date,
92: last_updated_by = hz_utility_pub.user_id,
93: last_update_login = hz_utility_pub.last_update_login,
94: program_application_id = hz_utility_pub.program_application_id,
95: program_id = hz_utility_pub.program_id,

Line 92: last_updated_by = hz_utility_pub.user_id,

88: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
89: UPDATE AS_INTERESTS_ALL
90: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
91: last_update_date = hz_utility_pub.last_update_date,
92: last_updated_by = hz_utility_pub.user_id,
93: last_update_login = hz_utility_pub.last_update_login,
94: program_application_id = hz_utility_pub.program_application_id,
95: program_id = hz_utility_pub.program_id,
96: program_update_date = sysdate

Line 93: last_update_login = hz_utility_pub.last_update_login,

89: UPDATE AS_INTERESTS_ALL
90: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
91: last_update_date = hz_utility_pub.last_update_date,
92: last_updated_by = hz_utility_pub.user_id,
93: last_update_login = hz_utility_pub.last_update_login,
94: program_application_id = hz_utility_pub.program_application_id,
95: program_id = hz_utility_pub.program_id,
96: program_update_date = sysdate
97: where customer_id = p_from_fk_id;

Line 94: program_application_id = hz_utility_pub.program_application_id,

90: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
91: last_update_date = hz_utility_pub.last_update_date,
92: last_updated_by = hz_utility_pub.user_id,
93: last_update_login = hz_utility_pub.last_update_login,
94: program_application_id = hz_utility_pub.program_application_id,
95: program_id = hz_utility_pub.program_id,
96: program_update_date = sysdate
97: where customer_id = p_from_fk_id;
98: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site

Line 95: program_id = hz_utility_pub.program_id,

91: last_update_date = hz_utility_pub.last_update_date,
92: last_updated_by = hz_utility_pub.user_id,
93: last_update_login = hz_utility_pub.last_update_login,
94: program_application_id = hz_utility_pub.program_application_id,
95: program_id = hz_utility_pub.program_id,
96: program_update_date = sysdate
97: where customer_id = p_from_fk_id;
98: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
99: UPDATE AS_INTERESTS_ALL

Line 101: last_update_date = hz_utility_pub.last_update_date,

97: where customer_id = p_from_fk_id;
98: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
99: UPDATE AS_INTERESTS_ALL
100: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: program_application_id = hz_utility_pub.program_application_id,
105: program_id = hz_utility_pub.program_id,

Line 102: last_updated_by = hz_utility_pub.user_id,

98: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
99: UPDATE AS_INTERESTS_ALL
100: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: program_application_id = hz_utility_pub.program_application_id,
105: program_id = hz_utility_pub.program_id,
106: program_update_date = sysdate

Line 103: last_update_login = hz_utility_pub.last_update_login,

99: UPDATE AS_INTERESTS_ALL
100: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: program_application_id = hz_utility_pub.program_application_id,
105: program_id = hz_utility_pub.program_id,
106: program_update_date = sysdate
107: where address_id = p_from_fk_id;

Line 104: program_application_id = hz_utility_pub.program_application_id,

100: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: program_application_id = hz_utility_pub.program_application_id,
105: program_id = hz_utility_pub.program_id,
106: program_update_date = sysdate
107: where address_id = p_from_fk_id;
108: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact

Line 105: program_id = hz_utility_pub.program_id,

101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: program_application_id = hz_utility_pub.program_application_id,
105: program_id = hz_utility_pub.program_id,
106: program_update_date = sysdate
107: where address_id = p_from_fk_id;
108: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
109: UPDATE AS_INTERESTS_ALL

Line 111: last_update_date = hz_utility_pub.last_update_date,

107: where address_id = p_from_fk_id;
108: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
109: UPDATE AS_INTERESTS_ALL
110: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,

Line 112: last_updated_by = hz_utility_pub.user_id,

108: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
109: UPDATE AS_INTERESTS_ALL
110: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate

Line 113: last_update_login = hz_utility_pub.last_update_login,

109: UPDATE AS_INTERESTS_ALL
110: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate
117: where contact_id = p_from_fk_id;

Line 114: program_application_id = hz_utility_pub.program_application_id,

110: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate
117: where contact_id = p_from_fk_id;
118: END IF;

Line 115: program_id = hz_utility_pub.program_id,

111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate
117: where contact_id = p_from_fk_id;
118: END IF;
119: EXCEPTION

Line 208: last_update_date = hz_utility_pub.last_update_date,

204: BEGIN
205: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
206: UPDATE AS_CURRENT_ENVIRONMENT
207: set customer_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: where customer_id = p_from_fk_id;
212: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site

Line 209: last_updated_by = hz_utility_pub.user_id,

205: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
206: UPDATE AS_CURRENT_ENVIRONMENT
207: set customer_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: where customer_id = p_from_fk_id;
212: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
213: UPDATE AS_CURRENT_ENVIRONMENT

Line 210: last_update_login = hz_utility_pub.last_update_login

206: UPDATE AS_CURRENT_ENVIRONMENT
207: set customer_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: where customer_id = p_from_fk_id;
212: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
213: UPDATE AS_CURRENT_ENVIRONMENT
214: set address_id = p_to_fk_id,

Line 215: last_update_date = hz_utility_pub.last_update_date,

211: where customer_id = p_from_fk_id;
212: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
213: UPDATE AS_CURRENT_ENVIRONMENT
214: set address_id = p_to_fk_id,
215: last_update_date = hz_utility_pub.last_update_date,
216: last_updated_by = hz_utility_pub.user_id,
217: last_update_login = hz_utility_pub.last_update_login
218: where address_id = p_from_fk_id;
219: END IF;

Line 216: last_updated_by = hz_utility_pub.user_id,

212: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
213: UPDATE AS_CURRENT_ENVIRONMENT
214: set address_id = p_to_fk_id,
215: last_update_date = hz_utility_pub.last_update_date,
216: last_updated_by = hz_utility_pub.user_id,
217: last_update_login = hz_utility_pub.last_update_login
218: where address_id = p_from_fk_id;
219: END IF;
220: EXCEPTION

Line 217: last_update_login = hz_utility_pub.last_update_login

213: UPDATE AS_CURRENT_ENVIRONMENT
214: set address_id = p_to_fk_id,
215: last_update_date = hz_utility_pub.last_update_date,
216: last_updated_by = hz_utility_pub.user_id,
217: last_update_login = hz_utility_pub.last_update_login
218: where address_id = p_from_fk_id;
219: END IF;
220: EXCEPTION
221: WHEN OTHERS THEN