APPS.JTF_NOTES_MERGE_PKG dependencies on JTF_NOTES_B

Line 29: IF ( (p_entity_name <> 'JTF_NOTES_B')

25: BEGIN
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: IF ( (p_entity_name <> 'JTF_NOTES_B')
30: OR (p_parent_entity_name NOT IN ('HZ_PARTIES','HZ_PARTY_SITES'))
31: )
32: THEN
33: FND_MESSAGE.SET_NAME ('JTF', 'NOTES_MSG');

Line 63: -- For example in JTF_NOTES_B table, if party_id 1 got merged to party_id 2

59: END IF;
60:
61: -- If the parent has changed(ie. Parent is getting merged) then transfer the
62: -- dependent record to the new parent.
63: -- For example in JTF_NOTES_B table, if party_id 1 got merged to party_id 2
64: -- then, we have to update all records with new_source_object_id 1 to 2
65: -- p_to_fk_id is the new value which has to be put
66: -- p_from_id is the jtf_note_id
67: IF ( (P_FROM_FK_ID <> P_TO_FK_ID)

Line 71: UPDATE jtf_notes_b

67: IF ( (P_FROM_FK_ID <> P_TO_FK_ID)
68: AND (p_parent_entity_name = 'HZ_PARTIES')
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

Line 89: UPDATE jtf_notes_b

85: ELSIF ( (P_FROM_FK_ID <> P_TO_FK_ID)
86: AND (p_parent_entity_name = 'HZ_PARTY_SITES')
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

Line 178: -- For example in JTF_NOTES_B table, if party_id 1 got merged to party_id 2

174: END IF;
175:
176: -- If the parent has changed(ie. Parent is getting merged) then transfer the
177: -- dependent record to the new parent.
178: -- For example in JTF_NOTES_B table, if party_id 1 got merged to party_id 2
179: -- then, we have to update all records with new_source_object_id 1 to 2
180: -- p_to_fk_id is the new value which has to be put
181: -- p_from_id is the jtf_note_id
182: