create or replace
package ciopassed_value as
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- File: ciopvl.pkh
-- Auth: RM3 Generated
-- Date: 22nd Sep 1999, 08:34:23pm
-- Cont: Element Type Interface (Specification) for
--         product      <CI>
--         element type <PASSED_VALUE>
--         short name   <PVL>
-- Note: Generated from database schema SCHEMA4012_D
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

type rm_values is record
(
  /* PASSED_VALUE              */ called_argument_value_from varchar2(6)  ,
  /* ELEMENT                   */ changed_by                 varchar2(30) ,
  /* ELEMENT                   */ created_by                 varchar2(30) ,
  /* ELEMENT                   */ date_changed               date         ,
  /* ELEMENT                   */ date_created               date         ,
  /* ACCESS_CONTROLLED_ELEMENT */ element_type_name          varchar2(10) ,
  /* ELEMENT                   */ id                         number(38)   ,
  /* CIELEMENT                 */ irid                       number(38)   ,
  /* PASSED_VALUE              */ item_reference             number(38)   ,
  /* CIELEMENT                 */ ivid                       number(38)   ,
  /* PASSED_VALUE              */ module_argument_reference  number(38)   ,
  /* PASSED_VALUE              */ module_network_reference   number(38)   ,
  /* ELEMENT                   */ number_of_times_modified   number(38)   ,
  /* SECONDARY_ACCESS_ELEMENT  */ pac_reference              number(38)   ,
  /* SECONDARY_ACCESS_ELEMENT  */ parent_ivid                number(38)   ,
  /* PASSED_VALUE              */ passed_value_type          varchar2(3)  ,
  /* ELEMENT                   */ types                      number(38)   ,
  /* PASSED_VALUE              */ value                      varchar2(240)
);

type rm_indicators is record
(
  called_argument_value_from 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_type_name          boolean not null default false,
  id                         boolean not null default false,
  irid                       boolean not null default false,
  item_reference             boolean not null default false,
  ivid                       boolean not null default false,
  module_argument_reference  boolean not null default false,
  module_network_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,
  passed_value_type          boolean not null default false,
  types                      boolean not null default false,
  value                      boolean not null default false
);

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


-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
procedure traverse_to_root(cid IN number, eid IN number, is_requery IN boolean);
procedure check_traversals;
procedure check_references;


-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

is_installed boolean := false;

end ciopassed_value;
/

REM End of ciopvl.pkh