Rem
Rem $Header: sdk_service_level_pkgdef.sql 18-aug-2006.04:01:09 skotha Exp $
Rem
Rem sdk_service_level_pkgdef.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdk_service_level_pkgdef.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    skotha      07/21/06 - Exposing get_service_sla_value 
Rem    skotha      07/21/06 - Created
Rem

CREATE OR REPLACE PACKAGE MGMT_SERVICE_LEVEL AS

------------------------------------------------------------------------------
-- FUNCTION: GET_SERVICE_LEVEL_VALUE
------------------------------------------------------------------------------
--
-- PURPOSE
--   To compute the service level for a given service with in a given
--   time period.
-- RETURNS
--   Service Level value
-- PARAMETERS
--   p_service_name : Service name
--   p_service_type : Service type
--   p_start_time   : Start time (format 'MM-DD-YYYY HH24:MI:SS')
--   p_end_time     : End time (format 'MM-DD-YYYY HH24:MI:SS')
--   p_timezone     : Timezone
--
FUNCTION GET_SERVICE_LEVEL_VALUE(p_service_name IN VARCHAR2,
                                 p_service_type IN VARCHAR2,
                                 p_start_time   IN VARCHAR2,
                                 p_end_time     IN VARCHAR2,
                                 p_timezone     IN VARCHAR2)
RETURN NUMBER;

END MGMT_SERVICE_LEVEL;

/

SHOW ERRORS;