create or replace package cioactivity_usage as -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- File: cioactorg.pkh -- Auth: RM3 Generated -- Date: 22nd Sep 1999, 05:19:16pm -- Cont: Element Type Interface (Specification) for -- product -- element type -- short name -- Note: Generated from database schema SCHEMA4012_D -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Properties -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - type rm_values is record ( /* ACTIVITY_USAGE */ activity_reference number(38) , /* ACTIVITY_USAGE */ activity_usage_error_reference number(38) , /* ACTIVITY_USAGE */ activity_usage_reference number(38) , /* ACTIVITY_USAGE */ additional_cost_rate number(23,3) , /* ACTIVITY_USAGE */ additional_cost_rate_unit varchar2(10) , /* ELEMENT */ changed_by varchar2(30) , /* ACTIVITY_USAGE */ cpa_finish_date date , /* ACTIVITY_USAGE */ cpa_relative_finish_time number(23,3) , /* ACTIVITY_USAGE */ cpa_relative_start_time number(23,3) , /* ACTIVITY_USAGE */ cpa_start_date date , /* ELEMENT */ created_by varchar2(30) , /* ACTIVITY_USAGE */ critical_path_flag varchar2(1) , /* ELEMENT */ date_changed date , /* ELEMENT */ date_created date , /* INTERSECTION */ element_type_name varchar2(10) , /* ACTIVITY_USAGE */ execution_string varchar2(240), /* ACTIVITY_USAGE */ frequency number(6) , /* ACTIVITY_USAGE */ frequency_unit varchar2(10) , /* ELEMENT */ id number(38) , /* CIELEMENT */ irid number(38) , /* CIELEMENT */ ivid number(38) , /* ACTIVITY_USAGE */ max_duration number(23,3) , /* ACTIVITY_USAGE */ max_duration_unit varchar2(10) , /* ACTIVITY_USAGE */ messaging_priority number(6) , /* ACTIVITY_USAGE */ min_duration number(23,3) , /* ACTIVITY_USAGE */ min_duration_unit varchar2(10) , /* ACTIVITY_USAGE */ multiplicity varchar2(1) , /* ELEMENT */ number_of_times_modified number(38) , /* ACTIVITY_USAGE */ organization_unit_reference number(38) , /* STRUCTURE_ELEMENT */ pac_reference number(38) , /* STRUCTURE_ELEMENT */ parent_ivid number(38) , /* ACTIVITY_USAGE */ quality_percent number(3) , /* ACTIVITY_USAGE */ sequence_number number(6) , /* ACTIVITY_USAGE */ total_cost_rate number(23,3) , /* ACTIVITY_USAGE */ total_cost_rate_unit varchar2(10) , /* ACTIVITY_USAGE */ total_duration number(23,3) , /* ACTIVITY_USAGE */ total_duration_unit varchar2(10) , /* ELEMENT */ types number(38) , /* ACTIVITY_USAGE */ value_added varchar2(1) , /* ACTIVITY_USAGE */ wf_enabled_flag varchar2(1) , /* ACTIVITY_USAGE */ wf_implementation_name varchar2(30) , /* ACTIVITY_USAGE */ wf_rerun_mode varchar2(6) , /* ACTIVITY_USAGE */ wf_security_level number(6) , /* ACTIVITY_USAGE */ wf_type varchar2(12) , /* ACTIVITY_USAGE */ workflow_item_type_reference number(38) , /* ACTIVITY_USAGE */ workflow_mess_type_reference number(38) ); type rm_indicators is record ( activity_reference boolean not null default false, activity_usage_error_reference boolean not null default false, activity_usage_reference boolean not null default false, additional_cost_rate boolean not null default false, additional_cost_rate_unit boolean not null default false, changed_by boolean not null default false, cpa_finish_date boolean not null default false, cpa_relative_finish_time boolean not null default false, cpa_relative_start_time boolean not null default false, cpa_start_date boolean not null default false, created_by boolean not null default false, critical_path_flag 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, execution_string boolean not null default false, frequency boolean not null default false, frequency_unit boolean not null default false, id boolean not null default false, irid boolean not null default false, ivid boolean not null default false, max_duration boolean not null default false, max_duration_unit boolean not null default false, messaging_priority boolean not null default false, min_duration boolean not null default false, min_duration_unit boolean not null default false, multiplicity boolean not null default false, number_of_times_modified boolean not null default false, organization_unit_reference boolean not null default false, pac_reference boolean not null default false, parent_ivid boolean not null default false, quality_percent boolean not null default false, sequence_number boolean not null default false, total_cost_rate boolean not null default false, total_cost_rate_unit boolean not null default false, total_duration boolean not null default false, total_duration_unit boolean not null default false, types boolean not null default false, value_added boolean not null default false, wf_enabled_flag boolean not null default false, wf_implementation_name boolean not null default false, wf_rerun_mode boolean not null default false, wf_security_level boolean not null default false, wf_type boolean not null default false, workflow_item_type_reference boolean not null default false, workflow_mess_type_reference 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 cioactivity_usage; / REM End of cioactorg.pkh