create or replace
package ciomethod as
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- File: ciomet.pkh
-- Auth: RM3 Generated
-- Date: 22nd Sep 1999, 07:54:42pm
-- Cont: Element Type Interface (Specification) for
--         product      <CI>
--         element type <METHOD>
--         short name   <MET>
-- Note: Generated from database schema SCHEMA4012_D
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- Properties
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

type rm_values is record
(
  /* ELEMENT                   */ changed_by                   varchar2(30) ,
  /* METHOD                    */ classifier_reference         number(38)   ,
  /* METHOD                    */ collect_classifier_reference number(38)   ,
  /* METHOD                    */ constructor_flag             varchar2(1)  ,
  /* ELEMENT                   */ created_by                   varchar2(30) ,
  /* ELEMENT                   */ date_changed                 date         ,
  /* ELEMENT                   */ date_created                 date         ,
  /* ACCESS_CONTROLLED_ELEMENT */ element_type_name            varchar2(10) ,
  /* METHOD                    */ elevated_method_reference    number(38)   ,
  /* METHOD                    */ exported_flag                varchar2(1)  ,
  /* ELEMENT                   */ id                           number(38)   ,
  /* METHOD                    */ implementation_tier          varchar2(11) ,
  /* METHOD                    */ internal_name                varchar2(100),
  /* CIELEMENT                 */ irid                         number(38)   ,
  /* CIELEMENT                 */ ivid                         number(38)   ,
  /* METHOD                    */ modifies_state_flag          varchar2(1)  ,
  /* METHOD                    */ name                         varchar2(100),
  /* METHOD                    */ native_flag                  varchar2(1)  ,
  /* ELEMENT                   */ number_of_times_modified     number(38)   ,
  /* METHOD                    */ overridable                  varchar2(6)  ,
  /* METHOD                    */ overriding_method_reference  number(38)   ,
  /* SECONDARY_ACCESS_ELEMENT  */ pac_reference                number(38)   ,
  /* SECONDARY_ACCESS_ELEMENT  */ parent_ivid                  number(38)   ,
  /* METHOD                    */ return_classifier_reference  number(38)   ,
  /* METHOD                    */ return_collection_size       varchar2(10) ,
  /* METHOD                    */ return_type_defined_by       varchar2(10) ,
  /* METHOD                    */ return_type_scalar           varchar2(15) ,
  /* METHOD                    */ sequence                     number(6)    ,
  /* METHOD                    */ static_flag                  varchar2(1)  ,
  /* METHOD                    */ synchronized_flag            varchar2(1)  ,
  /* ELEMENT                   */ types                        number(38)   ,
  /* METHOD                    */ visibility                   varchar2(10)
);

type rm_indicators is record
(
  changed_by                   boolean not null default false,
  classifier_reference         boolean not null default false,
  collect_classifier_reference boolean not null default false,
  constructor_flag             boolean not null default false,
  created_by                   boolean not null default false,
  date_changed                 boolean not null default false,
  date_created                 boolean not null default false,
  element_type_name            boolean not null default false,
  elevated_method_reference    boolean not null default false,
  exported_flag                boolean not null default false,
  id                           boolean not null default false,
  implementation_tier          boolean not null default false,
  internal_name                boolean not null default false,
  irid                         boolean not null default false,
  ivid                         boolean not null default false,
  modifies_state_flag          boolean not null default false,
  name                         boolean not null default false,
  native_flag                  boolean not null default false,
  number_of_times_modified     boolean not null default false,
  overridable                  boolean not null default false,
  overriding_method_reference  boolean not null default false,
  pac_reference                boolean not null default false,
  parent_ivid                  boolean not null default false,
  return_classifier_reference  boolean not null default false,
  return_collection_size       boolean not null default false,
  return_type_defined_by       boolean not null default false,
  return_type_scalar           boolean not null default false,
  sequence                     boolean not null default false,
  static_flag                  boolean not null default false,
  synchronized_flag            boolean not null default false,
  types                        boolean not null default false,
  visibility                   boolean not null default false
);

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


-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- Operations
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

--
-- lck
--
procedure lck
(
  id in number
);

--
-- ins
--
procedure ins
(
  id in     number,
  pl in out NOCOPY data
);

--
-- del
--
procedure del
(
  id in number
);

--
-- upd
--
procedure upd
(
  id in     number,
  pl in out NOCOPY data
);

--
-- sel
--
procedure sel
(
  id in     number,
  pl in out NOCOPY data
);


-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- Constraints
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

procedure constraint_check(rec in data,isins in boolean);
procedure traverse_to_root(cid IN number, eid IN number, is_requery IN boolean);
procedure check_traversals;
procedure check_references;
procedure copy_sac(i_irid in number
                  ,pl in out NOCOPY data
                  ,ensure_unique in varchar2 default 'Y'
                  ,deep in varchar2 default 'Y'
                  ,copy_deps_policy in varchar2 default 'Y');


-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- Exceptions
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

element_locked exception;
  element_locked_fac  constant varchar2(3) := 'RME';
  element_locked_code constant number      := 10;
invalid_ref exception;
  invalid_ref_fac  constant varchar2(3) := 'RME';
  invalid_ref_code constant number      := 9;
operation_failed exception;
  operation_failed_fac  constant varchar2(3) := 'RME';
  operation_failed_code constant number      := 11;

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- Globals
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

is_installed boolean := false;

end ciomethod;
/

REM End of ciomet.pkh