create or replace
package ciobusiness_unit_to_objective as
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- File: cioa8.pkh
-- Auth: RM3 Generated
-- Date: 22nd Sep 1999, 05:46:25pm
-- Cont: Element Type Interface (Specification) for
--         product      <CI>
--         element type <BUSINESS_UNIT_TO_OBJECTIVE>
--         short name   <A8>
-- Note: Generated from database schema SCHEMA4012_D
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

type rm_values is record
(
  /* BUSINESS_UNIT_TO_OBJECTIVE */ achievement_comment      varchar2(30) ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ business_unit_reference  number(38)   ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ cdate_required           varchar2(20) ,
  /* ELEMENT                    */ changed_by               varchar2(30) ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ comments                 varchar2(70) ,
  /* ELEMENT                    */ created_by               varchar2(30) ,
  /* ELEMENT                    */ date_changed             date         ,
  /* ELEMENT                    */ date_created             date         ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ date_placed              varchar2(20) ,
  /* INTERSECTION               */ element_type_name        varchar2(10) ,
  /* ELEMENT                    */ id                       number(38)   ,
  /* CIELEMENT                  */ irid                     number(38)   ,
  /* CIELEMENT                  */ ivid                     number(38)   ,
  /* ELEMENT                    */ number_of_times_modified number(38)   ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ objective_reference      number(38)   ,
  /* STRUCTURE_ELEMENT          */ pac_reference            number(38)   ,
  /* STRUCTURE_ELEMENT          */ parent_ivid              number(38)   ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ set_by                   varchar2(30) ,
  /* ELEMENT                    */ types                    number(38)   ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ unit_of_measure          varchar2(20) ,
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_0  varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_10 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_11 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_12 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_13 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_14 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_15 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_16 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_17 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_18 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_19 varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_7  varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_8  varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ user_defined_property_9  varchar2(240),
  /* BUSINESS_UNIT_TO_OBJECTIVE */ value                    varchar2(16)
);

type rm_indicators is record
(
  achievement_comment      boolean not null default false,
  business_unit_reference  boolean not null default false,
  cdate_required           boolean not null default false,
  changed_by               boolean not null default false,
  comments                 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,
  date_placed              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,
  ivid                     boolean not null default false,
  number_of_times_modified boolean not null default false,
  objective_reference      boolean not null default false,
  pac_reference            boolean not null default false,
  parent_ivid              boolean not null default false,
  set_by                   boolean not null default false,
  types                    boolean not null default false,
  unit_of_measure          boolean not null default false,
  user_defined_property_0  boolean not null default false,
  user_defined_property_10 boolean not null default false,
  user_defined_property_11 boolean not null default false,
  user_defined_property_12 boolean not null default false,
  user_defined_property_13 boolean not null default false,
  user_defined_property_14 boolean not null default false,
  user_defined_property_15 boolean not null default false,
  user_defined_property_16 boolean not null default false,
  user_defined_property_17 boolean not null default false,
  user_defined_property_18 boolean not null default false,
  user_defined_property_19 boolean not null default false,
  user_defined_property_7  boolean not null default false,
  user_defined_property_8  boolean not null default false,
  user_defined_property_9  boolean not null default false,
  value                    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 ciobusiness_unit_to_objective;
/

REM End of cioa8.pkh