APPS.CS_ERES_INT_PKG dependencies on CS_SR_RELATED_OBJ_LIST_T

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

628: -- Following functions are internally used by the Generate_XML_Document while generating the
629: -- XML Document.
630: ---------------------------------------------------------------------------------------------
631:
632: FUNCTION Get_Related_Objs (x_incident_id number) return cs_sr_related_OBJ_list_t as
633:
634: CURSOR Get_Rel_Obj IS
635: SELECT CAST(MULTISET
636: (SELECT obj.name RelatedOB_name

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

644: AND SrLnkEO.object_type <> 'SR'
645: AND obj.object_code (+) = SrLnkEO.object_type
646: AND obj.language (+) = userenv('LANG')
647: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
648: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_OBJ_list_t) RELATED_OB_LIST
649: FROM DUAL;
650:
651: l_rel_onj_list cs_sr_related_OBJ_list_t;
652:

Line 651: l_rel_onj_list cs_sr_related_OBJ_list_t;

647: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
648: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_OBJ_list_t) RELATED_OB_LIST
649: FROM DUAL;
650:
651: l_rel_onj_list cs_sr_related_OBJ_list_t;
652:
653: BEGIN
654: OPEN Get_Rel_Obj;
655: FETCH Get_Rel_Obj INTO l_rel_onj_list;