--------------------------------------------------------

--  File created - Friday-June-12-2015   

--------------------------------------------------------

--------------------------------------------------------

--  DDL for Package GET_URP_REPORT_DETAILS

--------------------------------------------------------



  CREATE OR REPLACE PACKAGE "MYASUPDSS"."GET_URP_REPORT_DETAILS" AS 



  procedure sp_customer_system_details(p_job_id in number,

                                  p_key_name IN VARCHAR2,

                                  p_sheets IN VARCHAR2,

                                  p_system OUT nocopy sys_refcursor,

                                  p_customer_site_info OUT nocopy sys_refcursor,                                  

                                  p_case OUT nocopy sys_refcursor,

                                  p_system_age OUT nocopy sys_refcursor,

                                  p_contract_dtl OUT nocopy sys_refcursor,

                                  p_capacity_forecast OUT nocopy sys_refcursor,

                                  p_epic_controller OUT nocopy sys_refcursor,

                                  p_epic_shelf OUT nocopy sys_refcursor,

                                  p_epic_disk OUT nocopy sys_refcursor,

                                  p_osfw_system OUT nocopy sys_refcursor,

                                  p_osfw_motherboard OUT nocopy sys_refcursor,

                                  p_osfw_shelf OUT nocopy sys_refcursor,

                                  p_osfw_disk OUT nocopy sys_refcursor,

                                  p_osfw_rlm OUT nocopy sys_refcursor,

                                  p_dave_hitz OUT nocopy sys_refcursor,

                                  p_perf_summary OUT nocopy sys_refcursor,

                                  p_fear_disk OUT nocopy sys_refcursor,

                                  p_fear_volume OUT nocopy sys_refcursor,

                                  p_fear_aggregate OUT nocopy sys_refcursor,

                                  p_fear_lun OUT nocopy sys_refcursor,

                                  p_fear_vol_option OUT nocopy sys_refcursor,

                                  p_fear_system_option OUT nocopy sys_refcursor,

                                  p_fear_license OUT nocopy sys_refcursor,

                                  p_invalid_serial_no OUT nocopy sys_refcursor);

                                  

  procedure sp_site_system_details(p_job_id in number,

                                  p_key_name IN VARCHAR2,

                                  p_sheets IN VARCHAR2,

                                  p_system OUT nocopy sys_refcursor,

                                  p_customer_site_info OUT nocopy sys_refcursor,                                  

                                  p_case OUT nocopy sys_refcursor,

                                  p_system_age OUT nocopy sys_refcursor,

                                  p_contract_dtl OUT nocopy sys_refcursor,

                                  p_capacity_forecast OUT nocopy sys_refcursor,

                                  p_epic_controller OUT nocopy sys_refcursor,

                                  p_epic_shelf OUT nocopy sys_refcursor,

                                  p_epic_disk OUT nocopy sys_refcursor,

                                  p_osfw_system OUT nocopy sys_refcursor,

                                  p_osfw_motherboard OUT nocopy sys_refcursor,

                                  p_osfw_shelf OUT nocopy sys_refcursor,

                                  p_osfw_disk OUT nocopy sys_refcursor,

                                  p_osfw_rlm OUT nocopy sys_refcursor,

                                  p_dave_hitz OUT nocopy sys_refcursor,

                                  p_perf_summary OUT nocopy sys_refcursor,

                                  p_fear_disk OUT nocopy sys_refcursor,

                                  p_fear_volume OUT nocopy sys_refcursor,

                                  p_fear_aggregate OUT nocopy sys_refcursor,

                                  p_fear_lun OUT nocopy sys_refcursor,

                                  p_fear_vol_option OUT nocopy sys_refcursor,

                                  p_fear_system_option OUT nocopy sys_refcursor,

                                  p_fear_license OUT nocopy sys_refcursor,

                                  p_invalid_serial_no OUT nocopy sys_refcursor);

                                  

  procedure sp_custom_group_system_details(p_job_id in number,

                                  p_key_name IN VARCHAR2,

                                  p_sheets IN VARCHAR2,

                                  p_system OUT nocopy sys_refcursor,

                                  p_customer_site_info OUT nocopy sys_refcursor,                                  

                                  p_case OUT nocopy sys_refcursor,

                                  p_system_age OUT nocopy sys_refcursor,

                                  p_contract_dtl OUT nocopy sys_refcursor,

                                  p_capacity_forecast OUT nocopy sys_refcursor,

                                  p_epic_controller OUT nocopy sys_refcursor,

                                  p_epic_shelf OUT nocopy sys_refcursor,

                                  p_epic_disk OUT nocopy sys_refcursor,

                                  p_osfw_system OUT nocopy sys_refcursor,

                                  p_osfw_motherboard OUT nocopy sys_refcursor,

                                  p_osfw_shelf OUT nocopy sys_refcursor,

                                  p_osfw_disk OUT nocopy sys_refcursor,

                                  p_osfw_rlm OUT nocopy sys_refcursor,

                                  p_dave_hitz OUT nocopy sys_refcursor,

                                  p_perf_summary OUT nocopy sys_refcursor,

                                  p_fear_disk OUT nocopy sys_refcursor,

                                  p_fear_volume OUT nocopy sys_refcursor,

                                  p_fear_aggregate OUT nocopy sys_refcursor,

                                  p_fear_lun OUT nocopy sys_refcursor,

                                  p_fear_vol_option OUT nocopy sys_refcursor,

                                  p_fear_system_option OUT nocopy sys_refcursor,

                                  p_fear_license OUT nocopy sys_refcursor,

                                  p_invalid_serial_no OUT nocopy sys_refcursor);



END GET_URP_REPORT_DETAILS;



/



