APPS.JTF_TASK_CONTACTS_PUB dependencies on JTF_TASK_PHONES

Line 941: --Delete the associated contact points in JTF_TASK_PHONES

937: x_return_status := fnd_api.g_ret_sts_unexp_error;
938: RAISE fnd_api.g_exc_unexpected_error;
939: END IF;
940:
941: --Delete the associated contact points in JTF_TASK_PHONES
942: IF p_delete_cascade = jtf_task_utl.g_yes THEN
943: do_delete_cascade (
944: p_task_contact_id => p_task_contact_id
945: ) ;

Line 1049: l_task_phone_id jtf_task_phones.task_phone_id%TYPE;

1045: PROCEDURE do_delete_cascade(
1046: p_task_contact_id IN NUMBER
1047: ) IS
1048:
1049: l_task_phone_id jtf_task_phones.task_phone_id%TYPE;
1050:
1051: CURSOR c_phone_id(p_task_contact_id NUMBER)
1052: IS
1053: SELECT task_phone_id

Line 1054: FROM jtf_task_phones

1050:
1051: CURSOR c_phone_id(p_task_contact_id NUMBER)
1052: IS
1053: SELECT task_phone_id
1054: FROM jtf_task_phones
1055: WHERE task_contact_id = p_task_contact_id
1056: AND owner_table_name = 'JTF_TASK_CONTACTS';
1057:
1058: BEGIN

Line 1064: DELETE FROM jtf_task_phones

1060: LOOP
1061: FETCH c_phone_id INTO l_task_phone_id;
1062: EXIT WHEN c_phone_id%NOTFOUND;
1063:
1064: DELETE FROM jtf_task_phones
1065: WHERE task_phone_id = l_task_phone_id;
1066: END LOOP;
1067: CLOSE c_phone_id;
1068: END;