80:
81: x_return_status := fnd_api.g_ret_sts_success;
82:
83: Select 'x' into l_dummy
84: From jtf_task_contacts
85: Where task_id = p_escalation_id
86: And escalation_requester_flag = 'Y';
87:
88: Exception
455: cursor c_contact_exists(p_contact_id NUMBER,
456: p_contact_type_code VARCHAR2,
457: p_escalation_id NUMBER) Is
458: Select 'x'
459: from jtf_task_contacts
460: where task_id = p_escalation_id
461: and contact_id = p_contact_id
462: and contact_type_code = p_contact_type_code;
463:
778: cursor c_check_phone_id(p_task_phone_id NUMBER,
779: p_escalation_id NUMBER) Is
780: select 'x'
781: from jtf_task_phones ph,
782: jtf_task_contacts c
783: where ph.task_phone_id = p_task_phone_id
784: and ph.task_contact_id = c.task_contact_id
785: and c.task_id = p_escalation_id;
786:
833: cursor c_check_contact( p_contact_id NUMBER,
834: p_contact_type_code VARCHAR2,
835: p_escalation_id NUMBER) Is
836: select c.task_contact_id
837: from jtf_task_contacts c
838: where c.contact_id = p_contact_id
839: and c.task_id = p_escalation_id
840: and c.contact_type_code = p_contact_type_code;
841:
883:
884: cursor c_check_task_contact_id(p_task_contact_id NUMBER,
885: p_escalation_id NUMBER) Is
886: select 'x'
887: from jtf_task_contacts
888: where task_contact_id = p_task_contact_id
889: and task_id = p_escalation_id;
890:
891: l_dummy varchar2(1);
1096: FUNCTION Get_Requester_Name(p_escalation_id IN NUMBER) RETURN VARCHAR2 Is
1097:
1098: cursor get_requester_details (p_esc_id NUMBER) Is
1099: SELECT contact_id, contact_type_code
1100: FROM jtf_task_contacts
1101: WHERE task_id = p_esc_id
1102: AND NVL(escalation_requester_flag,'N') = 'Y';
1103:
1104: