rem 
rem $Header: L:\\\\model\\repman40\\api\\RCS\\ciueet.ops 1.1 1998/05/28 16:56:59 mfrobins Exp $ 
rem 
rem Copyright (c) Oracle Corporation 1991.  All Rights Reserved.
rem
rem  NAME
rem    ciueet.ops             - Operation Package Specification
rem  DESCRIPTION
rem    This package is responsible for managing UE element
rem    type extensions to the CASE Repository.
rem  PUBLIC FUNCTION(S)
rem    ins         - INSert a new extended element type 
rem    upd         - UPDate an existing element type
rem    del         - DELete an existing element type
rem    publish     - PUBLISH an existing element type
rem  NOTES
rem  MODIFIED   (MM/DD/YY)
rem    bferris   03/15/95 -  Added nls_name and plural_name
Rem    aheath    02/14/95 -  Added to api release structure
rem    bferris   12/19/94 -  Creation


CREATE OR REPLACE PACKAGE cioue_element_type IS

--
--  Element type record
--

type rm_values is record
(
  id                       number(38)    ,
  short_name               varchar2(10)   ,
  name                     varchar2(27)  ,
  plural_name              varchar2(27)  ,
  nls_name                 varchar2(240) ,
  nls_plural_name          varchar2(240)
);

type rm_indicators is record
(
  id              boolean not null default false,
  short_name      boolean not null default false,
  name            boolean not null default false,
  plural_name     boolean not null default false,
  nls_name        boolean not null default false,
  nls_plural_name boolean not null default false
);

type data is record
(
 v rm_values,
 i rm_indicators
);

--
--  Operations
--

procedure ins     (id IN number,
                   pl IN OUT data);
procedure upd     (id IN number,
                   pl IN OUT data);
procedure del     (id IN number);

procedure publish (id IN number);

procedure unpublish (id IN number);

procedure remap(id IN number, short_name IN varchar2);

procedure drop_views_packs(id IN number);

--
--  Constant globals
--

ueet_fac constant varchar2(3) := 'CDA';

--
--  Exceptions
--

ueet_invalid_sn   exception;
  ueet_invalid_sn_code   constant number := 830;
ueet_miss_sn      exception;
  ueet_miss_sn_code      constant number := 831;
ueet_duplicate_sn exception;
  ueet_duplicate_sn_code constant number := 832;

ueet_miss_nm      exception;
  ueet_miss_nm_code      constant number := 833;
ueet_duplicate_nm   exception;
  ueet_duplicate_nm_code constant number := 834;

ueet_miss_pn      exception;
  ueet_miss_pn_code      constant number := 835;
ueet_duplicate_pn exception;
  ueet_duplicate_pn_code constant number := 836;

ueet_not_exist    exception;
  ueet_not_exist_code    constant number := 837;
ueet_not_user     exception;
  ueet_not_user_code     constant number := 838;
ueet_is_published exception;
  ueet_is_published_code constant number := 839;

ueet_data_exists  exception;
  ueet_data_exists_code  constant number := 870;
ueet_assoc_exists  exception;
  ueet_assoc_exists_code constant number := 871;
ueet_text_u_exists  exception;
  ueet_text_u_exists_code constant number := 872;
ueet_is_not_published  exception;
  ueet_is_not_published_code  constant number := 873;

ueet_is_not_user_type exception;
  ueet_is_not_user_type_code constant number := 875;
end cioue_element_type;
/