APPS.CS_ERES_INT_PKG dependencies on CS_SR_NOTE_LIST_T

Line 696: l_date_format varchar2) return cs_sr_note_list_t as

692:
693: FUNCTION Get_SR_Notes (x_incident_id number,
694: l_source_timezone_id number,
695: l_desc_timezone_id number,
696: l_date_format varchar2) return cs_sr_note_list_t as
697:
698: CURSOR Get_Notes IS
699: SELECT CAST(MULTISET
700: (SELECT nvl2(ext_usert.resource_name, ext_usert.resource_name, fnd1.user_name) as Note_Created_By

Line 728: order by JNB.entered_date ) AS cs_sr_note_list_t) NOTE_LIST

724: AND ext_userb.user_id (+) = fnd1.user_id
725: AND ext_usert.language (+)= userenv('LANG')
726: AND ext_userb.resource_id = ext_usert.resource_id (+)
727: AND ext_userb.category = ext_usert.category (+)
728: order by JNB.entered_date ) AS cs_sr_note_list_t) NOTE_LIST
729: FROM DUAL;
730:
731: l_note_list cs_sr_note_list_t;
732:

Line 731: l_note_list cs_sr_note_list_t;

727: AND ext_userb.category = ext_usert.category (+)
728: order by JNB.entered_date ) AS cs_sr_note_list_t) NOTE_LIST
729: FROM DUAL;
730:
731: l_note_list cs_sr_note_list_t;
732:
733: BEGIN
734: OPEN Get_Notes;
735: FETCH Get_Notes INTO l_note_list;