APPS.CS_ERES_INT_PKG dependencies on CS_SR_RELATED_SR_LIST_T

Line 645: FUNCTION Get_Related_SRs (x_incident_id number) return cs_sr_related_SR_list_t as

641:
642: return l_rel_onj_list;
643: END;
644:
645: FUNCTION Get_Related_SRs (x_incident_id number) return cs_sr_related_SR_list_t as
646:
647: CURSOR Get_Rel_Sr IS
648: SELECT CAST(MULTISET
649: (SELECT ltype.name RelatedSR_Name

Line 680: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_SR_list_t) RELATED_SR_LIST

676: AND severity.LANGUAGE = userenv('LANG')
677: AND tlSR.incident_id = relSR.incident_id
678: AND tlSR.language = userenv('lang')
679: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
680: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_SR_list_t) RELATED_SR_LIST
681: FROM DUAL;
682:
683: l_rel_sr_list cs_sr_related_SR_list_t;
684:

Line 683: l_rel_sr_list cs_sr_related_SR_list_t;

679: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
680: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_SR_list_t) RELATED_SR_LIST
681: FROM DUAL;
682:
683: l_rel_sr_list cs_sr_related_SR_list_t;
684:
685: BEGIN
686: OPEN Get_Rel_Sr;
687: FETCH Get_Rel_Sr INTO l_rel_sr_list;