DBA Data[Home] [Help]

APPS.JTF_TASKS_PUB dependencies on JTF_TASK_PHONES

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

6571: , primary_flag
6572: FROM jtf_task_contacts
6573: WHERE task_id = l_source_task_id;
6574:
6575: CURSOR c_contact_points(b_contact_id jtf_task_phones.task_contact_id%TYPE) IS
6576: SELECT phone_id
6577: , task_phone_id
6578: , primary_flag
6579: FROM jtf_task_phones

Line 6579: FROM jtf_task_phones

6575: CURSOR c_contact_points(b_contact_id jtf_task_phones.task_contact_id%TYPE) IS
6576: SELECT phone_id
6577: , task_phone_id
6578: , primary_flag
6579: FROM jtf_task_phones
6580: WHERE task_contact_id = b_contact_id;
6581:
6582: tasks c_task%ROWTYPE;
6583: depends c_depends%ROWTYPE;

Line 6927: jtf_task_phones_pub.create_task_phones(

6923: ------ Create contact point for the customer
6924: ------ (where task_contact_id = task_id)
6925: ------
6926: FOR contact_points IN c_contact_points(l_source_task_id) LOOP
6927: jtf_task_phones_pub.create_task_phones(
6928: p_api_version => 1.0
6929: , p_init_msg_list => fnd_api.g_false
6930: , p_commit => fnd_api.g_false
6931: , p_task_contact_id => l_target_task_id

Line 7259: jtf_task_phones_pub.create_task_phones(

7255: ------ Create contact points for each contact
7256: ------
7257: IF fnd_api.to_boolean(p_copy_task_contact_points) THEN
7258: FOR contact_points IN c_contact_points(contacts.task_contact_id) LOOP
7259: jtf_task_phones_pub.create_task_phones(
7260: p_api_version => 1.0
7261: , p_init_msg_list => fnd_api.g_false
7262: , p_commit => fnd_api.g_false
7263: , p_task_contact_id => l_task_contact_id