DBA Data[Home] [Help]

APPS.JTF_TASK_CONTACTS_PUB dependencies on JTF_TASKS_B

Line 82: l_task_id jtf_tasks_b.task_id%TYPE;

78: l_api_version CONSTANT NUMBER := 1.0;
79: l_api_name CONSTANT VARCHAR2(30)
80: := 'CREATE_TASK_CONTACTS';
81: l_rowid ROWID;
82: l_task_id jtf_tasks_b.task_id%TYPE;
83: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
84: x CHAR;
85: l_person_id NUMBER;
86:

Line 444: l_task_id jtf_tasks_b.task_id%TYPE;

440: l_api_name CONSTANT VARCHAR2(30)
441: := 'UPDATE_TASK_CONTACTS';
442: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
443: l_contact_id jtf_task_contacts.contact_id%TYPE;
444: l_task_id jtf_tasks_b.task_id%TYPE;
445: CURSOR c_task_contacts
446: IS
447: SELECT task_contact_id,
448: task_id,

Line 867: l_task_id jtf_tasks_b.task_id%TYPE;

863: IS
864: l_api_version CONSTANT NUMBER := 1.0;
865: l_api_name CONSTANT VARCHAR2(30)
866: := 'DELETE_TASK_CONTACTS';
867: l_task_id jtf_tasks_b.task_id%TYPE;
868: l_contact_id jtf_task_contacts.contact_id%TYPE;
869: l_contact_type_code jtf_task_contacts.contact_type_code%TYPE;
870: CURSOR con_con_orig (b_task_contact_id IN NUMBER)
871: IS