[Home] [Help]
232: l_escalation_id jtf_tasks_b.task_id%TYPE := p_esc_id;
233: l_escalation_number jtf_tasks_b.task_number%TYPE := p_esc_number;
234: l_return_status varchar2(1) := 'x';
235: l_api_name varchar2(30) := 'Create_Esc_Contacts';
236: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
237: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;
238:
239: BEGIN
240:
572: l_escalation_contact_id jtf_task_contacts.task_contact_id%TYPE;
573: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
574: l_temp VARCHAR2(10);
575: l_esc_status_id jtf_tasks_b.task_status_id%TYPE;
576: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
577: l_user_id NUMBER := p_user_id;
578: l_resp_appl_id NUMBER := p_resp_appl_id;
579: l_resp_id NUMBER := p_resp_id;
580: l_login_id NUMBER := p_login_id;
967: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
968:
969: -- insert the phone_id (contact_point) for this contact
970:
971: Jtf_Task_Phones_Pub.create_task_phones (
972: p_api_version => l_api_version,
973: p_init_msg_list => fnd_api.g_false,
974: p_commit => fnd_api.g_false,
975: p_task_contact_id => l_escalation_contact_id,
1237: l_esc_task_id jtf_tasks_b.task_id%TYPE := NULL; --esc id where ref doc is escalated
1238: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;
1239: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
1240: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;
1241: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
1242: l_owner_changed VARCHAR2(1) := 'N';
1243: l_level_changed VARCHAR2(1) := 'N';
1244: l_status_changed VARCHAR2(1) := 'N';
1245: l_target_date_changed VARCHAR2(1) := 'N';
1254: l_object_type_code jtf_task_references_b.object_type_code%TYPE;
1255:
1256: cursor c_cont_phone_id (p_task_contact_id NUMBER) is
1257: select task_phone_id, object_version_number
1258: from jtf_task_phones
1259: where task_contact_id = p_task_contact_id;
1260:
1261: cursor c_get_old_esc_data(p_escalation_id NUMBER) Is
1262: select owner_id, task_status_id, escalation_level, planned_end_date
1783: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1784: raise fnd_api.g_exc_unexpected_error;
1785: end if;
1786:
1787: Jtf_Task_Phones_Pub.delete_task_phones (
1788: p_api_version => l_api_version,
1789: p_init_msg_list => fnd_api.g_false,
1790: p_commit => fnd_api.g_false,
1791: p_object_version_number => l_cont_points(j).object_version_number,
1818: end if;
1819:
1820: l_return_status := 'x';
1821:
1822: Jtf_Task_Phones_Pub.update_task_phones(
1823: p_api_version => l_api_version,
1824: p_init_msg_list => fnd_api.g_false,
1825: p_commit => fnd_api.g_false,
1826: p_object_version_number => l_cont_points(j).object_version_number,
1863: --------------------------------------------------------------------------------------------------
1864:
1865: for j in 1..l_esc_contacts.COUNT loop
1866:
1867: -- deletes an existing contact. Removes the corresponding contact points from jtf_task_phones.
1868:
1869: if l_esc_contacts(j).action_code = 'D' then
1870:
1871: l_return_status := 'x';
1901: -- delete the contact points
1902:
1903: for c in c_cont_phone_id(l_esc_contacts(j).task_contact_id) loop
1904:
1905: Jtf_Task_Phones_Pub.delete_task_phones (
1906: p_api_version => l_api_version,
1907: p_init_msg_list => fnd_api.g_false,
1908: p_commit => fnd_api.g_false,
1909: p_object_version_number => c.object_version_number,
2068: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
2069:
2070: -- create a phone_id for this contact
2071:
2072: Jtf_Task_Phones_Pub.create_task_phones (
2073: p_api_version => l_api_version,
2074: p_init_msg_list => fnd_api.g_false,
2075: p_commit => fnd_api.g_false,
2076: p_task_contact_id => l_escalation_contact_id,