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

Line 73: , last_update_date = hz_utility_pub.last_update_date

69: )
70: THEN
71: UPDATE jtf_notes_b
72: SET source_object_id = p_to_fk_id
73: , last_update_date = hz_utility_pub.last_update_date
74: , last_updated_by = hz_utility_pub.user_id
75: , last_update_login = hz_utility_pub.last_update_login
76: WHERE source_object_code IN (SELECT ojt.object_code
77: FROM jtf_objects_b ojt

Line 74: , last_updated_by = hz_utility_pub.user_id

70: THEN
71: UPDATE jtf_notes_b
72: SET source_object_id = p_to_fk_id
73: , last_update_date = hz_utility_pub.last_update_date
74: , last_updated_by = hz_utility_pub.user_id
75: , last_update_login = hz_utility_pub.last_update_login
76: WHERE source_object_code IN (SELECT ojt.object_code
77: FROM jtf_objects_b ojt
78: , jtf_object_usages oue

Line 75: , last_update_login = hz_utility_pub.last_update_login

71: UPDATE jtf_notes_b
72: SET source_object_id = p_to_fk_id
73: , last_update_date = hz_utility_pub.last_update_date
74: , last_updated_by = hz_utility_pub.user_id
75: , last_update_login = hz_utility_pub.last_update_login
76: WHERE source_object_code IN (SELECT ojt.object_code
77: FROM jtf_objects_b ojt
78: , jtf_object_usages oue
79: WHERE ojt.object_code = oue.object_code

Line 91: , last_update_date = hz_utility_pub.last_update_date

87: )
88: THEN
89: UPDATE jtf_notes_b
90: SET source_object_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: WHERE source_object_code IN (SELECT ojt.object_code
95: FROM jtf_objects_b ojt

Line 92: , last_updated_by = hz_utility_pub.user_id

88: THEN
89: UPDATE jtf_notes_b
90: SET source_object_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: WHERE source_object_code IN (SELECT ojt.object_code
95: FROM jtf_objects_b ojt
96: , jtf_object_usages oue

Line 93: , last_update_login = hz_utility_pub.last_update_login

89: UPDATE jtf_notes_b
90: SET source_object_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: WHERE source_object_code IN (SELECT ojt.object_code
95: FROM jtf_objects_b ojt
96: , jtf_object_usages oue
97: WHERE ojt.object_code = oue.object_code

Line 189: , last_update_date = hz_utility_pub.last_update_date

185: )
186: THEN
187: UPDATE jtf_note_contexts
188: SET note_context_type_id = p_to_fk_id
189: , last_update_date = hz_utility_pub.last_update_date
190: , last_updated_by = hz_utility_pub.user_id
191: , last_update_login = hz_utility_pub.last_update_login
192: WHERE note_context_type IN (SELECT ojt.object_code
193: FROM jtf_objects_b ojt

Line 190: , last_updated_by = hz_utility_pub.user_id

186: THEN
187: UPDATE jtf_note_contexts
188: SET note_context_type_id = p_to_fk_id
189: , last_update_date = hz_utility_pub.last_update_date
190: , last_updated_by = hz_utility_pub.user_id
191: , last_update_login = hz_utility_pub.last_update_login
192: WHERE note_context_type IN (SELECT ojt.object_code
193: FROM jtf_objects_b ojt
194: , jtf_object_usages oue

Line 191: , last_update_login = hz_utility_pub.last_update_login

187: UPDATE jtf_note_contexts
188: SET note_context_type_id = p_to_fk_id
189: , last_update_date = hz_utility_pub.last_update_date
190: , last_updated_by = hz_utility_pub.user_id
191: , last_update_login = hz_utility_pub.last_update_login
192: WHERE note_context_type IN (SELECT ojt.object_code
193: FROM jtf_objects_b ojt
194: , jtf_object_usages oue
195: WHERE ojt.object_code = oue.object_code

Line 207: , last_update_date = hz_utility_pub.last_update_date

203: )
204: THEN
205: UPDATE jtf_note_contexts
206: SET note_context_type_id = p_to_fk_id
207: , last_update_date = hz_utility_pub.last_update_date
208: , last_updated_by = hz_utility_pub.user_id
209: , last_update_login = hz_utility_pub.last_update_login
210: WHERE note_context_type IN (SELECT ojt.object_code
211: FROM jtf_objects_b ojt

Line 208: , last_updated_by = hz_utility_pub.user_id

204: THEN
205: UPDATE jtf_note_contexts
206: SET note_context_type_id = p_to_fk_id
207: , last_update_date = hz_utility_pub.last_update_date
208: , last_updated_by = hz_utility_pub.user_id
209: , last_update_login = hz_utility_pub.last_update_login
210: WHERE note_context_type IN (SELECT ojt.object_code
211: FROM jtf_objects_b ojt
212: , jtf_object_usages oue

Line 209: , last_update_login = hz_utility_pub.last_update_login

205: UPDATE jtf_note_contexts
206: SET note_context_type_id = p_to_fk_id
207: , last_update_date = hz_utility_pub.last_update_date
208: , last_updated_by = hz_utility_pub.user_id
209: , last_update_login = hz_utility_pub.last_update_login
210: WHERE note_context_type IN (SELECT ojt.object_code
211: FROM jtf_objects_b ojt
212: , jtf_object_usages oue
213: WHERE ojt.object_code = oue.object_code