APPS.JTF_TASK_PHONES_PUB dependencies on JTF_TASK_CONTACTS

Line 83: l_contact_id jtf_task_contacts.contact_id%TYPE;

79: l_api_name CONSTANT VARCHAR2(30)
80: := 'CREATE_TASK_PHONES';
81: l_rowid ROWID;
82: l_task_id jtf_tasks_b.task_id%TYPE;
83: l_contact_id jtf_task_contacts.contact_id%TYPE;
84: l_task_phone_id jtf_task_phones.task_phone_id%TYPE;
85: x CHAR;
86:
87: l_primary_flag VARCHAR2(1) := p_primary_flag; -- For fixing a bug 2644132

Line 372: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;

368: l_api_version CONSTANT NUMBER := 1.0;
369: l_api_name CONSTANT VARCHAR2(30)
370: := 'UPDATE_TASK_PHONES';
371: l_rowid ROWID;
372: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
373: l_contact_id jtf_task_contacts.contact_id%TYPE;
374: x CHAR;
375:
376: CURSOR c_task_phones

Line 373: l_contact_id jtf_task_contacts.contact_id%TYPE;

369: l_api_name CONSTANT VARCHAR2(30)
370: := 'UPDATE_TASK_PHONES';
371: l_rowid ROWID;
372: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
373: l_contact_id jtf_task_contacts.contact_id%TYPE;
374: x CHAR;
375:
376: CURSOR c_task_phones
377: IS

Line 499: NVL (owner_table_name, 'JTF_TASK_CONTACTS')

495:
496: BEGIN
497: --- Added the nvl clause for backward compatibility
498: SELECT task_contact_id,
499: NVL (owner_table_name, 'JTF_TASK_CONTACTS')
500: INTO l_task_contact_id,
501: l_owner_table_name
502: FROM jtf_task_phones
503: WHERE task_phone_id = p_task_phone_id;

Line 513: IF l_owner_table_name = 'JTF_TASK_CONTACTS'

509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: RAISE fnd_api.g_exc_unexpected_error;
511: END;
512:
513: IF l_owner_table_name = 'JTF_TASK_CONTACTS'
514: THEN
515: BEGIN
516: SELECT contact_id
517: INTO l_contact_id

Line 518: FROM jtf_task_contacts

514: THEN
515: BEGIN
516: SELECT contact_id
517: INTO l_contact_id
518: FROM jtf_task_contacts
519: WHERE task_contact_id = l_task_contact_id;
520: EXCEPTION
521: WHEN NO_DATA_FOUND
522: THEN

Line 786: IF p_owner_table_name = 'JTF_TASK_CONTACTS'

782: )
783: IS
784: BEGIN
785: -- select contact points of the same type and unmark the primary flag
786: IF p_owner_table_name = 'JTF_TASK_CONTACTS'
787: THEN
788: UPDATE jtf_task_phones
789: SET primary_flag = 'N'
790: WHERE task_contact_id = p_task_contact_id

Line 800: FROM jtf_task_contacts

796: FROM hz_contact_points
797: WHERE contact_point_id = p_phone_id
798: AND owner_table_id =
799: (SELECT contact_id
800: FROM jtf_task_contacts
801: WHERE task_contact_id =
802: p_task_contact_id))
803: AND owner_table_id =
804: (SELECT contact_id

Line 805: FROM jtf_task_contacts

801: WHERE task_contact_id =
802: p_task_contact_id))
803: AND owner_table_id =
804: (SELECT contact_id
805: FROM jtf_task_contacts
806: WHERE task_contact_id = p_task_contact_id))
807: AND primary_flag = 'Y';
808: ELSE
809: -- select contact points of the same type and unmark the primary flag