APPS.CS_ERES_INT_PKG dependencies on CS_SR_TASK_LIST_T

Line 779: l_date_format varchar2) return cs_sr_task_list_t as

775:
776: FUNCTION Get_SR_Tasks (x_incident_id number,
777: l_source_timezone_id number,
778: l_desc_timezone_id number,
779: l_date_format varchar2) return cs_sr_task_list_t as
780:
781:
782: l_source_tz_code varchar2(50);
783: l_dest_tz_code varchar2(50);

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

844: AND statusB.task_status_id = jtf1B.task_status_id
845: AND obj_vl.object_code = jtf1B.owner_type_code
846: AND obj_vl.LANGUAGE = userenv('LANG')
847: AND jtf1B.parent_task_id = jtf2.task_id (+)
848: ORDER BY jtf1B.creation_date) AS cs_sr_task_list_t) TASK_LIST
849: FROM DUAL;
850:
851: l_task_list cs_sr_task_list_t;
852: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349

Line 851: l_task_list cs_sr_task_list_t;

847: AND jtf1B.parent_task_id = jtf2.task_id (+)
848: ORDER BY jtf1B.creation_date) AS cs_sr_task_list_t) TASK_LIST
849: FROM DUAL;
850:
851: l_task_list cs_sr_task_list_t;
852: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
853: Select timezone_code
854: From fnd_timezones_b
855: Where upgrade_tz_id = l_time_zone_id;