APPS.CS_ERES_INT_PKG dependencies on CS_SR_NOTE_LIST_T

Line 712: l_date_format varchar2) return cs_sr_note_list_t as

708:
709: FUNCTION Get_SR_Notes (x_incident_id number,
710: l_source_timezone_id number,
711: l_desc_timezone_id number,
712: l_date_format varchar2) return cs_sr_note_list_t as
713:
714: l_source_tz_code varchar2(50);
715: l_dest_tz_code varchar2(50);
716:

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

746: AND ext_userb.user_id (+) = fnd1.user_id
747: AND ext_usert.language (+)= userenv('LANG')
748: AND ext_userb.resource_id = ext_usert.resource_id (+)
749: AND ext_userb.category = ext_usert.category (+)
750: order by JNB.entered_date ) AS cs_sr_note_list_t) NOTE_LIST
751: FROM DUAL;
752:
753: l_note_list cs_sr_note_list_t;
754: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349

Line 753: l_note_list cs_sr_note_list_t;

749: AND ext_userb.category = ext_usert.category (+)
750: order by JNB.entered_date ) AS cs_sr_note_list_t) NOTE_LIST
751: FROM DUAL;
752:
753: l_note_list cs_sr_note_list_t;
754: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
755: Select timezone_code
756: From fnd_timezones_b
757: Where upgrade_tz_id = l_time_zone_id;