create or replace
package rmoviolation as
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- File: rmovi.pkh
-- Auth: RM3 Generated
-- Date: 22nd Sep 1999, 10:54:41pm
-- Cont: Element Type Interface (Specification) for
--         product      <RM>
--         element type <VIOLATION>
--         short name   <VI>
-- Note: Generated from database schema SCHEMA4012_D
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

type rm_values is record
(
  /* VIOLATION */ activity                 number(38)   ,
  /* VIOLATION */ assertion                number(38)   ,
  /* ELEMENT   */ changed_by               varchar2(30) ,
  /* ELEMENT   */ created_by               varchar2(30) ,
  /* ELEMENT   */ date_changed             date         ,
  /* ELEMENT   */ date_created             date         ,
  /* VIOLATION */ element                  number(38)   ,
  /* ELEMENT   */ id                       number(38)   ,
  /* ELEMENT   */ number_of_times_modified number(38)   ,
  /* VIOLATION */ p0                       varchar2(240),
  /* VIOLATION */ p1                       varchar2(240),
  /* VIOLATION */ p2                       varchar2(240),
  /* VIOLATION */ p3                       varchar2(240),
  /* VIOLATION */ p4                       varchar2(240),
  /* VIOLATION */ p5                       varchar2(240),
  /* VIOLATION */ p6                       varchar2(240),
  /* VIOLATION */ p7                       varchar2(240),
  /* VIOLATION */ pok                      varchar2(1)  ,
  /* VIOLATION */ property                 number(38)   ,
  /* ELEMENT   */ types                    number(38)
);

type rm_indicators is record
(
  activity                 boolean not null default false,
  assertion                boolean not null default false,
  changed_by               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                  boolean not null default false,
  id                       boolean not null default false,
  number_of_times_modified boolean not null default false,
  p0                       boolean not null default false,
  p1                       boolean not null default false,
  p2                       boolean not null default false,
  p3                       boolean not null default false,
  p4                       boolean not null default false,
  p5                       boolean not null default false,
  p6                       boolean not null default false,
  p7                       boolean not null default false,
  pok                      boolean not null default false,
  property                 boolean not null default false,
  types                    boolean not null default false
);

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


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

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

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

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

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

--
-- upd
--
procedure upd
(
  id in     number,
  pl in out 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 compute_parms(rec in out rmoviolation.data,mgname in varchar2);

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- 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 rmoviolation;
/

REM End of rmovi.pkh