APPS.CS_ERES_INT_PKG dependencies on CS_SR_RELATED_SR_LIST_T

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

657:
658: return l_rel_onj_list;
659: END;
660:
661: FUNCTION Get_Related_SRs (x_incident_id number) return cs_sr_related_SR_list_t as
662:
663: CURSOR Get_Rel_Sr IS
664: SELECT CAST(MULTISET
665: (SELECT ltype.name RelatedSR_Name

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

692: AND severity.LANGUAGE = userenv('LANG')
693: AND tlSR.incident_id = relSR.incident_id
694: AND tlSR.language = userenv('lang')
695: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
696: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_SR_list_t) RELATED_SR_LIST
697: FROM DUAL;
698:
699: l_rel_sr_list cs_sr_related_SR_list_t;
700:

Line 699: l_rel_sr_list cs_sr_related_SR_list_t;

695: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
696: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_SR_list_t) RELATED_SR_LIST
697: FROM DUAL;
698:
699: l_rel_sr_list cs_sr_related_SR_list_t;
700:
701: BEGIN
702: OPEN Get_Rel_Sr;
703: FETCH Get_Rel_Sr INTO l_rel_sr_list;