DBA Data[Home] [Help]

APPS.JTF_TASKS_PUB dependencies on JTF_TASK_PHONES

Line 6550: CURSOR c_contact_points(b_contact_id jtf_task_phones.task_contact_id%TYPE) IS

6546: , primary_flag
6547: FROM jtf_task_contacts
6548: WHERE task_id = l_source_task_id;
6549:
6550: CURSOR c_contact_points(b_contact_id jtf_task_phones.task_contact_id%TYPE) IS
6551: SELECT phone_id
6552: , task_phone_id
6553: , primary_flag
6554: FROM jtf_task_phones

Line 6554: FROM jtf_task_phones

6550: CURSOR c_contact_points(b_contact_id jtf_task_phones.task_contact_id%TYPE) IS
6551: SELECT phone_id
6552: , task_phone_id
6553: , primary_flag
6554: FROM jtf_task_phones
6555: WHERE task_contact_id = b_contact_id;
6556:
6557: tasks c_task%ROWTYPE;
6558: depends c_depends%ROWTYPE;

Line 6902: jtf_task_phones_pub.create_task_phones(

6898: ------ Create contact point for the customer
6899: ------ (where task_contact_id = task_id)
6900: ------
6901: FOR contact_points IN c_contact_points(l_source_task_id) LOOP
6902: jtf_task_phones_pub.create_task_phones(
6903: p_api_version => 1.0
6904: , p_init_msg_list => fnd_api.g_false
6905: , p_commit => fnd_api.g_false
6906: , p_task_contact_id => l_target_task_id

Line 7234: jtf_task_phones_pub.create_task_phones(

7230: ------ Create contact points for each contact
7231: ------
7232: IF fnd_api.to_boolean(p_copy_task_contact_points) THEN
7233: FOR contact_points IN c_contact_points(contacts.task_contact_id) LOOP
7234: jtf_task_phones_pub.create_task_phones(
7235: p_api_version => 1.0
7236: , p_init_msg_list => fnd_api.g_false
7237: , p_commit => fnd_api.g_false
7238: , p_task_contact_id => l_task_contact_id