APPS.CS_ERES_INT_PKG dependencies on CS_SR_RELATED_OBJ_LIST_T

Line 616: FUNCTION Get_Related_Objs (x_incident_id number) return cs_sr_related_OBJ_list_t as

612: -- Following functions are internally used by the Generate_XML_Document while generating the
613: -- XML Document.
614: ---------------------------------------------------------------------------------------------
615:
616: FUNCTION Get_Related_Objs (x_incident_id number) return cs_sr_related_OBJ_list_t as
617:
618: CURSOR Get_Rel_Obj IS
619: SELECT CAST(MULTISET
620: (SELECT obj.name RelatedOB_name

Line 632: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_OBJ_list_t) RELATED_OB_LIST

628: AND SrLnkEO.object_type <> 'SR'
629: AND obj.object_code (+) = SrLnkEO.object_type
630: AND obj.language (+) = userenv('LANG')
631: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
632: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_OBJ_list_t) RELATED_OB_LIST
633: FROM DUAL;
634:
635: l_rel_onj_list cs_sr_related_OBJ_list_t;
636:

Line 635: l_rel_onj_list cs_sr_related_OBJ_list_t;

631: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
632: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_OBJ_list_t) RELATED_OB_LIST
633: FROM DUAL;
634:
635: l_rel_onj_list cs_sr_related_OBJ_list_t;
636:
637: BEGIN
638: OPEN Get_Rel_Obj;
639: FETCH Get_Rel_Obj INTO l_rel_onj_list;