REM
REM $Header: emcore/source/oracle/sysman/emdrep/sql/core/11.2.0.1/slm/em_slm_computation_types.sql rbali_oneoff_updated/1 2025/03/14 06:41:13 rbali Exp $
REM
REM em_slm_computation_types.sql
REM
REM Copyright (c) 2007, 2025, Oracle and/or its affiliates. 
REM All rights reserved.

REM BEGIN EMRU_FILE_METADATA
REM EMRU_SOURCE_FILE:emcore/source/oracle/sysman/emdrep/sql/core/11.2.0.1/slm/em_slm_computation_types.sql
REM EMRU_UNIX_DELIVERABLES:
REM emcore/source/oracle/sysman/emdrep/sql/core/11.2.0.1/slm/em_slm_computation_types.sql

REM EMRU_FILE_POSTINSTALL:<!!! enter the view based location of the executable file. If there is NONE leave as-is !!!>
REM EMRU_GENERIC_FLAG:NONE
REM END EMRU_FILE_METADATA

REM
REM    NAME
REM      em_slm_computation_types.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    rnadidar    02/11/15 - cut over to EBR
REM    mfidanbo    03/20/07 - add headers
REM    mfidanbo    02/23/07 - Created
REM

--  here guid represents target_guid
CREATE OR REPLACE TYPE EM_SLM_STATUS AS OBJECT
(  guid   RAW(16),
   status NUMBER
);
/

CREATE TYPE EM_SLM_STATUS_ARRAY AS TABLE OF EM_SLM_STATUS;
/


ALTER SESSION SET CURRENT_SCHEMA=SYSMAN_TYPES;

CREATE OR REPLACE TYPE EM_SLM_AVAIL_OBJECT AS OBJECT
(  status         NUMBER,
   total_duration NUMBER,
   occurrences    NUMBER,
   max_duration   NUMBER
);
/


grant execute on EM_SLM_AVAIL_OBJECT to sysman;

create or replace noneditionable synonym SYSMAN.EM_SLM_AVAIL_OBJECT for EM_SLM_AVAIL_OBJECT;


CREATE OR REPLACE TYPE EM_SLM_AVAIL_OBJECT_ARRAY AS VARRAY(10) OF EM_SLM_AVAIL_OBJECT;
/

grant execute on EM_SLM_AVAIL_OBJECT_ARRAY to sysman;

create or replace noneditionable synonym SYSMAN.EM_SLM_AVAIL_OBJECT_ARRAY for EM_SLM_AVAIL_OBJECT_ARRAY;


ALTER SESSION SET CURRENT_SCHEMA=SYSMAN;

CREATE OR REPLACE TYPE EM_SLM_COMP_NUMBER_ARRAY AS TABLE OF NUMBER;
/




