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

Line 130: last_update_date = hz_utility_pub.last_update_date,

126: UPDATE prp_proposals SET
127: party_id = DECODE(party_id, p_from_fk_id, p_to_fk_id, party_id),
128: contact_party_id = DECODE(contact_party_id, p_from_fk_id, p_to_fk_id,
129: contact_party_id),
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: program_id = hz_utility_pub.program_id,
134: program_login_id = hz_utility_pub.last_update_login,

Line 131: last_updated_by = hz_utility_pub.user_id,

127: party_id = DECODE(party_id, p_from_fk_id, p_to_fk_id, party_id),
128: contact_party_id = DECODE(contact_party_id, p_from_fk_id, p_to_fk_id,
129: contact_party_id),
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: program_id = hz_utility_pub.program_id,
134: program_login_id = hz_utility_pub.last_update_login,
135: program_application_id = hz_utility_pub.program_application_id,

Line 132: last_update_login = hz_utility_pub.last_update_login,

128: contact_party_id = DECODE(contact_party_id, p_from_fk_id, p_to_fk_id,
129: contact_party_id),
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: program_id = hz_utility_pub.program_id,
134: program_login_id = hz_utility_pub.last_update_login,
135: program_application_id = hz_utility_pub.program_application_id,
136: request_id = hz_utility_pub.request_id

Line 133: program_id = hz_utility_pub.program_id,

129: contact_party_id),
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: program_id = hz_utility_pub.program_id,
134: program_login_id = hz_utility_pub.last_update_login,
135: program_application_id = hz_utility_pub.program_application_id,
136: request_id = hz_utility_pub.request_id
137: WHERE party_id = p_from_fk_id

Line 134: program_login_id = hz_utility_pub.last_update_login,

130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: program_id = hz_utility_pub.program_id,
134: program_login_id = hz_utility_pub.last_update_login,
135: program_application_id = hz_utility_pub.program_application_id,
136: request_id = hz_utility_pub.request_id
137: WHERE party_id = p_from_fk_id
138: OR contact_party_id = p_from_fk_id;

Line 135: program_application_id = hz_utility_pub.program_application_id,

131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: program_id = hz_utility_pub.program_id,
134: program_login_id = hz_utility_pub.last_update_login,
135: program_application_id = hz_utility_pub.program_application_id,
136: request_id = hz_utility_pub.request_id
137: WHERE party_id = p_from_fk_id
138: OR contact_party_id = p_from_fk_id;
139:

Line 136: request_id = hz_utility_pub.request_id

132: last_update_login = hz_utility_pub.last_update_login,
133: program_id = hz_utility_pub.program_id,
134: program_login_id = hz_utility_pub.last_update_login,
135: program_application_id = hz_utility_pub.program_application_id,
136: request_id = hz_utility_pub.request_id
137: WHERE party_id = p_from_fk_id
138: OR contact_party_id = p_from_fk_id;
139:
140: -- Get the row count

Line 277: last_update_date = hz_utility_pub.last_update_date,

273:
274: -- Update table
275: UPDATE prp_email_recipients SET
276: party_id = p_to_fk_id,
277: last_update_date = hz_utility_pub.last_update_date,
278: last_updated_by = hz_utility_pub.user_id,
279: last_update_login = hz_utility_pub.last_update_login,
280: program_id = hz_utility_pub.program_id,
281: program_login_id = hz_utility_pub.last_update_login,

Line 278: last_updated_by = hz_utility_pub.user_id,

274: -- Update table
275: UPDATE prp_email_recipients SET
276: party_id = p_to_fk_id,
277: last_update_date = hz_utility_pub.last_update_date,
278: last_updated_by = hz_utility_pub.user_id,
279: last_update_login = hz_utility_pub.last_update_login,
280: program_id = hz_utility_pub.program_id,
281: program_login_id = hz_utility_pub.last_update_login,
282: program_application_id = hz_utility_pub.program_application_id,

Line 279: last_update_login = hz_utility_pub.last_update_login,

275: UPDATE prp_email_recipients SET
276: party_id = p_to_fk_id,
277: last_update_date = hz_utility_pub.last_update_date,
278: last_updated_by = hz_utility_pub.user_id,
279: last_update_login = hz_utility_pub.last_update_login,
280: program_id = hz_utility_pub.program_id,
281: program_login_id = hz_utility_pub.last_update_login,
282: program_application_id = hz_utility_pub.program_application_id,
283: request_id = hz_utility_pub.request_id

Line 280: program_id = hz_utility_pub.program_id,

276: party_id = p_to_fk_id,
277: last_update_date = hz_utility_pub.last_update_date,
278: last_updated_by = hz_utility_pub.user_id,
279: last_update_login = hz_utility_pub.last_update_login,
280: program_id = hz_utility_pub.program_id,
281: program_login_id = hz_utility_pub.last_update_login,
282: program_application_id = hz_utility_pub.program_application_id,
283: request_id = hz_utility_pub.request_id
284: WHERE party_id = p_from_fk_id;

Line 281: program_login_id = hz_utility_pub.last_update_login,

277: last_update_date = hz_utility_pub.last_update_date,
278: last_updated_by = hz_utility_pub.user_id,
279: last_update_login = hz_utility_pub.last_update_login,
280: program_id = hz_utility_pub.program_id,
281: program_login_id = hz_utility_pub.last_update_login,
282: program_application_id = hz_utility_pub.program_application_id,
283: request_id = hz_utility_pub.request_id
284: WHERE party_id = p_from_fk_id;
285:

Line 282: program_application_id = hz_utility_pub.program_application_id,

278: last_updated_by = hz_utility_pub.user_id,
279: last_update_login = hz_utility_pub.last_update_login,
280: program_id = hz_utility_pub.program_id,
281: program_login_id = hz_utility_pub.last_update_login,
282: program_application_id = hz_utility_pub.program_application_id,
283: request_id = hz_utility_pub.request_id
284: WHERE party_id = p_from_fk_id;
285:
286: -- Get the row count

Line 283: request_id = hz_utility_pub.request_id

279: last_update_login = hz_utility_pub.last_update_login,
280: program_id = hz_utility_pub.program_id,
281: program_login_id = hz_utility_pub.last_update_login,
282: program_application_id = hz_utility_pub.program_application_id,
283: request_id = hz_utility_pub.request_id
284: WHERE party_id = p_from_fk_id;
285:
286: -- Get the row count
287: l_count := sql%rowcount;