APPS.JTF_TASK_PARTY_MERGE_PKG dependencies on JTF_TASK_PHONES

Line 1236: -- Performs contact_point_id merge in JTF_TASK_PHONES table.

1232:
1233:
1234: ------------------------------------------------------------------------------------------
1235: -- Procedure: TASK_MERGE_CONTACT_POINTS
1236: -- Performs contact_point_id merge in JTF_TASK_PHONES table.
1237: -- Columns: PHONE_ID
1238: ------------------------------------------------------------------------------------------
1239:
1240: PROCEDURE TASK_MERGE_CONTACT_POINTS(

Line 1291: -- For JTF_TASK_PHONES table, if contact_point_id 1000 got merged to contact_point_id

1287:
1288:
1289: -- If the parent has changed(ie. Parent is getting merged) then transfer the
1290: -- dependent record to the new parent.
1291: -- For JTF_TASK_PHONES table, if contact_point_id 1000 got merged to contact_point_id
1292: -- 2000 then, we have to update all records with phone_id = 1000 to 2000
1293:
1294: if p_from_fk_id <> p_to_fk_id then
1295:

Line 1296: UPDATE jtf_task_phones

1292: -- 2000 then, we have to update all records with phone_id = 1000 to 2000
1293:
1294: if p_from_fk_id <> p_to_fk_id then
1295:
1296: UPDATE jtf_task_phones
1297: SET phone_id = p_to_fk_id,
1298: last_update_date = hz_utility_pub.last_update_date,
1299: last_updated_by = hz_utility_pub.user_id,
1300: last_update_login = hz_utility_pub.last_update_login,