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

Line 76: last_update_date = hz_utility_pub.last_update_date,

72: UPDATE IBW_PAGE_VIEWS SET
73: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
74: party_relationship_id = DECODE( party_relationship_id,p_from_fk_id,p_to_fk_id, party_relationship_id),
75: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
76: last_update_date = hz_utility_pub.last_update_date,
77: last_updated_by = hz_utility_pub.user_id,
78: last_update_login = hz_utility_pub.last_update_login,
79: request_id = hz_utility_pub.request_id,
80: program_application_id = hz_utility_pub.program_application_id,

Line 77: last_updated_by = hz_utility_pub.user_id,

73: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
74: party_relationship_id = DECODE( party_relationship_id,p_from_fk_id,p_to_fk_id, party_relationship_id),
75: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
76: last_update_date = hz_utility_pub.last_update_date,
77: last_updated_by = hz_utility_pub.user_id,
78: last_update_login = hz_utility_pub.last_update_login,
79: request_id = hz_utility_pub.request_id,
80: program_application_id = hz_utility_pub.program_application_id,
81: program_id = hz_utility_pub.program_id

Line 78: last_update_login = hz_utility_pub.last_update_login,

74: party_relationship_id = DECODE( party_relationship_id,p_from_fk_id,p_to_fk_id, party_relationship_id),
75: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
76: last_update_date = hz_utility_pub.last_update_date,
77: last_updated_by = hz_utility_pub.user_id,
78: last_update_login = hz_utility_pub.last_update_login,
79: request_id = hz_utility_pub.request_id,
80: program_application_id = hz_utility_pub.program_application_id,
81: program_id = hz_utility_pub.program_id
82: Where party_id = p_from_fk_id

Line 79: request_id = hz_utility_pub.request_id,

75: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
76: last_update_date = hz_utility_pub.last_update_date,
77: last_updated_by = hz_utility_pub.user_id,
78: last_update_login = hz_utility_pub.last_update_login,
79: request_id = hz_utility_pub.request_id,
80: program_application_id = hz_utility_pub.program_application_id,
81: program_id = hz_utility_pub.program_id
82: Where party_id = p_from_fk_id
83: OR party_relationship_id = p_from_fk_id ;

Line 80: program_application_id = hz_utility_pub.program_application_id,

76: last_update_date = hz_utility_pub.last_update_date,
77: last_updated_by = hz_utility_pub.user_id,
78: last_update_login = hz_utility_pub.last_update_login,
79: request_id = hz_utility_pub.request_id,
80: program_application_id = hz_utility_pub.program_application_id,
81: program_id = hz_utility_pub.program_id
82: Where party_id = p_from_fk_id
83: OR party_relationship_id = p_from_fk_id ;
84:

Line 81: program_id = hz_utility_pub.program_id

77: last_updated_by = hz_utility_pub.user_id,
78: last_update_login = hz_utility_pub.last_update_login,
79: request_id = hz_utility_pub.request_id,
80: program_application_id = hz_utility_pub.program_application_id,
81: program_id = hz_utility_pub.program_id
82: Where party_id = p_from_fk_id
83: OR party_relationship_id = p_from_fk_id ;
84:
85: l_count := sql%rowcount;

Line 194: last_update_date = hz_utility_pub.last_update_date,

190:
191: UPDATE IBW_SITE_VISITS SET
192: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
193: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login,
197: request_id = hz_utility_pub.request_id,
198: program_application_id = hz_utility_pub.program_application_id,

Line 195: last_updated_by = hz_utility_pub.user_id,

191: UPDATE IBW_SITE_VISITS SET
192: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
193: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login,
197: request_id = hz_utility_pub.request_id,
198: program_application_id = hz_utility_pub.program_application_id,
199: program_id = hz_utility_pub.program_id

Line 196: last_update_login = hz_utility_pub.last_update_login,

192: party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
193: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login,
197: request_id = hz_utility_pub.request_id,
198: program_application_id = hz_utility_pub.program_application_id,
199: program_id = hz_utility_pub.program_id
200: Where party_id = p_from_fk_id ;

Line 197: request_id = hz_utility_pub.request_id,

193: visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login,
197: request_id = hz_utility_pub.request_id,
198: program_application_id = hz_utility_pub.program_application_id,
199: program_id = hz_utility_pub.program_id
200: Where party_id = p_from_fk_id ;
201:

Line 198: program_application_id = hz_utility_pub.program_application_id,

194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login,
197: request_id = hz_utility_pub.request_id,
198: program_application_id = hz_utility_pub.program_application_id,
199: program_id = hz_utility_pub.program_id
200: Where party_id = p_from_fk_id ;
201:
202: l_count := sql%rowcount;

Line 199: program_id = hz_utility_pub.program_id

195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login,
197: request_id = hz_utility_pub.request_id,
198: program_application_id = hz_utility_pub.program_application_id,
199: program_id = hz_utility_pub.program_id
200: Where party_id = p_from_fk_id ;
201:
202: l_count := sql%rowcount;
203: