APPS.JTF_NOTES_MERGE_PKG dependencies on JTF_NOTE_CONTEXTS

Line 144: IF ( (p_entity_name <> 'JTF_NOTE_CONTEXTS')

140: BEGIN
141:
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: IF ( (p_entity_name <> 'JTF_NOTE_CONTEXTS')
145: OR (p_parent_entity_name NOT IN ('HZ_PARTIES','HZ_PARTY_SITES'))
146: )
147: THEN
148: FND_MESSAGE.SET_NAME('JTF', 'NOTES_MSG');

Line 187: UPDATE jtf_note_contexts

183: IF ( (p_from_fk_id <> p_to_fk_id)
184: AND (p_parent_entity_name = 'HZ_PARTIES')
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

Line 205: UPDATE jtf_note_contexts

201: ELSIF ( (p_from_fk_id <> p_to_fk_id)
202: AND (p_parent_entity_name = 'HZ_PARTY_SITES')
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