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:
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,
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