create or replace
package cioplanning_item as
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- File: cioa9.pkh
-- Auth: RM3 Generated
-- Date: 22nd Sep 1999, 08:39:15pm
-- Cont: Element Type Interface (Specification) for
--         product      <CI>
--         element type <PLANNING_ITEM>
--         short name   <A9>
-- Note: Generated from database schema SCHEMA4012_D
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

type rm_values is record
(
  /* PLANNING_ITEM     */ budget                   varchar2(16) ,
  /* PLANNING_ITEM     */ bunit_of_measure         varchar2(20) ,
  /* PLANNING_ITEM     */ business_unit_reference  number(38)   ,
  /* PLANNING_ITEM     */ cdate_effective          varchar2(20) ,
  /* ELEMENT           */ changed_by               varchar2(30) ,
  /* PLANNING_ITEM     */ comments                 varchar2(70) ,
  /* ELEMENT           */ created_by               varchar2(30) ,
  /* ELEMENT           */ date_changed             date         ,
  /* ELEMENT           */ date_created             date         ,
  /* INTERSECTION      */ element_type_name        varchar2(10) ,
  /* PLANNING_ITEM     */ hcunit_of_measure        varchar2(20) ,
  /* PLANNING_ITEM     */ headcount                varchar2(20) ,
  /* ELEMENT           */ id                       number(38)   ,
  /* CIELEMENT         */ irid                     number(38)   ,
  /* CIELEMENT         */ ivid                     number(38)   ,
  /* PLANNING_ITEM     */ location_reference       number(38)   ,
  /* ELEMENT           */ number_of_times_modified number(38)   ,
  /* STRUCTURE_ELEMENT */ pac_reference            number(38)   ,
  /* STRUCTURE_ELEMENT */ parent_ivid              number(38)   ,
  /* PLANNING_ITEM     */ set_by                   varchar2(30) ,
  /* ELEMENT           */ types                    number(38)   ,
  /* PLANNING_ITEM     */ user_defined_property_0  varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_10 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_11 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_12 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_13 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_14 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_15 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_16 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_17 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_18 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_19 varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_7  varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_8  varchar2(240),
  /* PLANNING_ITEM     */ user_defined_property_9  varchar2(240)
);

type rm_indicators is record
(
  budget                   boolean not null default false,
  bunit_of_measure         boolean not null default false,
  business_unit_reference  boolean not null default false,
  cdate_effective          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,
  element_type_name        boolean not null default false,
  hcunit_of_measure        boolean not null default false,
  headcount                boolean not null default false,
  id                       boolean not null default false,
  irid                     boolean not null default false,
  ivid                     boolean not null default false,
  location_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,
  set_by                   boolean not null default false,
  types                    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
);

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

REM End of cioa9.pkh