create or replace
package ciotransition as
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- File: ciotra.pkh
-- Auth: RM3 Generated
-- Date: 22nd Sep 1999, 10:00:27pm
-- Cont: Element Type Interface (Specification) for
--         product      <CI>
--         element type <TRANSITION>
--         short name   <TRA>
-- Note: Generated from database schema SCHEMA4012_D
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

type rm_values is record
(
  /* TRANSITION        */ activity_signature_flag       varchar2(1)  ,
  /* TRANSITION        */ automatic_invocation_flag     varchar2(1)  ,
  /* ELEMENT           */ changed_by                    varchar2(30) ,
  /* TRANSITION        */ channel_name                  varchar2(240),
  /* TRANSITION        */ channel_type                  varchar2(5)  ,
  /* TRANSITION        */ creatable_flag                varchar2(1)  ,
  /* ELEMENT           */ created_by                    varchar2(30) ,
  /* ELEMENT           */ date_changed                  date         ,
  /* ELEMENT           */ date_created                  date         ,
  /* TRANSITION        */ deletable_flag                varchar2(1)  ,
  /* INTERSECTION      */ element_type_name             varchar2(10) ,
  /* TRANSITION        */ event_publication_reference   number(38)   ,
  /* TRANSITION        */ event_subscription_reference  number(38)   ,
  /* ELEMENT           */ id                            number(38)   ,
  /* CIELEMENT         */ irid                          number(38)   ,
  /* CIELEMENT         */ ivid                          number(38)   ,
  /* TRANSITION        */ messaging_audit               varchar2(12) ,
  /* TRANSITION        */ named_rule_reference          number(38)   ,
  /* ELEMENT           */ number_of_times_modified      number(38)   ,
  /* STRUCTURE_ELEMENT */ pac_reference                 number(38)   ,
  /* STRUCTURE_ELEMENT */ parent_ivid                   number(38)   ,
  /* TRANSITION        */ primary_flag                  varchar2(1)  ,
  /* TRANSITION        */ retrievable_flag              varchar2(1)  ,
  /* TRANSITION        */ sequence_number               number(6)    ,
  /* TRANSITION        */ source_activity_reference     number(38)   ,
  /* TRANSITION        */ source_act_usage_reference    number(38)   ,
  /* TRANSITION        */ source_event_reference        number(38)   ,
  /* TRANSITION        */ source_object_state_reference number(38)   ,
  /* TRANSITION        */ source_pseudostate_reference  number(38)   ,
  /* TRANSITION        */ source_type                   varchar2(6)  ,
  /* TRANSITION        */ target_activity_reference     number(38)   ,
  /* TRANSITION        */ target_act_usage_reference    number(38)   ,
  /* TRANSITION        */ target_event_reference        number(38)   ,
  /* TRANSITION        */ target_object_state_reference number(38)   ,
  /* TRANSITION        */ target_pseudostate_reference  number(38)   ,
  /* TRANSITION        */ target_type                   varchar2(6)  ,
  /* TRANSITION        */ transition_reference          number(38)   ,
  /* TRANSITION        */ triggering_flag               varchar2(1)  ,
  /* TRANSITION        */ trigger_event_reference       number(38)   ,
  /* ELEMENT           */ types                         number(38)   ,
  /* TRANSITION        */ updatable_flag                varchar2(1)
);

type rm_indicators is record
(
  activity_signature_flag       boolean not null default false,
  automatic_invocation_flag     boolean not null default false,
  changed_by                    boolean not null default false,
  channel_name                  boolean not null default false,
  channel_type                  boolean not null default false,
  creatable_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,
  deletable_flag                boolean not null default false,
  element_type_name             boolean not null default false,
  event_publication_reference   boolean not null default false,
  event_subscription_reference  boolean not null default false,
  id                            boolean not null default false,
  irid                          boolean not null default false,
  ivid                          boolean not null default false,
  messaging_audit               boolean not null default false,
  named_rule_reference          boolean not null default false,
  number_of_times_modified      boolean not null default false,
  pac_reference                 boolean not null default false,
  parent_ivid                   boolean not null default false,
  primary_flag                  boolean not null default false,
  retrievable_flag              boolean not null default false,
  sequence_number               boolean not null default false,
  source_activity_reference     boolean not null default false,
  source_act_usage_reference    boolean not null default false,
  source_event_reference        boolean not null default false,
  source_object_state_reference boolean not null default false,
  source_pseudostate_reference  boolean not null default false,
  source_type                   boolean not null default false,
  target_activity_reference     boolean not null default false,
  target_act_usage_reference    boolean not null default false,
  target_event_reference        boolean not null default false,
  target_object_state_reference boolean not null default false,
  target_pseudostate_reference  boolean not null default false,
  target_type                   boolean not null default false,
  transition_reference          boolean not null default false,
  triggering_flag               boolean not null default false,
  trigger_event_reference       boolean not null default false,
  types                         boolean not null default false,
  updatable_flag                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 ciotransition;
/

REM End of ciotra.pkh