APPS.CS_ERES_INT_PKG dependencies on CS_SR_TASK_LIST_T

Line 745: l_date_format varchar2) return cs_sr_task_list_t as

741:
742: FUNCTION Get_SR_Tasks (x_incident_id number,
743: l_source_timezone_id number,
744: l_desc_timezone_id number,
745: l_date_format varchar2) return cs_sr_task_list_t as
746:
747: CURSOR Get_Tasks IS
748: SELECT CAST(MULTISET
749: (SELECT

Line 801: ORDER BY jtf1B.creation_date) AS cs_sr_task_list_t) TASK_LIST

797: AND statusB.task_status_id = jtf1B.task_status_id
798: AND obj_vl.object_code = jtf1B.owner_type_code
799: AND obj_vl.LANGUAGE = userenv('LANG')
800: AND jtf1B.parent_task_id = jtf2.task_id (+)
801: ORDER BY jtf1B.creation_date) AS cs_sr_task_list_t) TASK_LIST
802: FROM DUAL;
803:
804: l_task_list cs_sr_task_list_t;
805:

Line 804: l_task_list cs_sr_task_list_t;

800: AND jtf1B.parent_task_id = jtf2.task_id (+)
801: ORDER BY jtf1B.creation_date) AS cs_sr_task_list_t) TASK_LIST
802: FROM DUAL;
803:
804: l_task_list cs_sr_task_list_t;
805:
806: BEGIN
807: OPEN Get_Tasks;
808: FETCH Get_Tasks INTO l_task_list;