create or replace package ciofunction as -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- File: ciofun.pkh -- Auth: RM3 Generated -- Date: 22nd Sep 1999, 07:10:11pm -- Cont: Element Type Interface (Specification) for -- product -- element type -- short name -- Note: Generated from database schema SCHEMA4012_D -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Properties -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - type rm_values is record ( /* FUNCTION */ additional_cost_rate number(23,3) , /* FUNCTION */ additional_cost_rate_unit varchar2(10) , /* FUNCTION */ bpr_generate_flag varchar2(1) , /* ELEMENT */ changed_by varchar2(30) , /* FUNCTION */ common_function_reference number(38) , /* FUNCTION */ competitive_index_value number(5,2) , /* FUNCTION */ cpa_finish_date date , /* FUNCTION */ cpa_relative_finish_time number(23,3) , /* FUNCTION */ cpa_relative_start_time number(23,3) , /* FUNCTION */ cpa_start_date date , /* ELEMENT */ created_by varchar2(30) , /* FUNCTION */ critical_path_flag varchar2(1) , /* ELEMENT */ date_changed date , /* ELEMENT */ date_created date , /* FUNCTION */ elementary_flag varchar2(1) , /* ACCESS_CONTROLLED_ELEMENT */ element_type_name varchar2(10) , /* FUNCTION */ execution_string varchar2(70) , /* FUNCTION */ export_id number(38) , /* FUNCTION */ frequency number(6) , /* FUNCTION */ frequency_unit varchar2(10) , /* FUNCTION */ function_label varchar2(30) , /* FUNCTION */ function_type varchar2(2) , /* FUNCTION */ icon_file varchar2(60) , /* ELEMENT */ id number(38) , /* FUNCTION */ image_file varchar2(60) , /* CIELEMENT */ irid number(38) , /* CIELEMENT */ ivid number(38) , /* FUNCTION */ measured_time_1 number(23,3) , /* FUNCTION */ measured_time_2 number(23,3) , /* FUNCTION */ measured_time_3 number(23,3) , /* FUNCTION */ measured_time_unit varchar2(10) , /* FUNCTION */ note_picture_file varchar2(240), /* FUNCTION */ note_text varchar2(240), /* FUNCTION */ note_type varchar2(1) , /* ELEMENT */ number_of_times_modified number(38) , /* FUNCTION */ overhead_cost_rate number(23,3) , /* FUNCTION */ overhead_cost_rate_unit varchar2(10) , /* FUNCTION */ parent_reference number(38) , /* FUNCTION */ person_cost_rate number(23,3) , /* FUNCTION */ person_cost_rate_unit varchar2(10) , /* FUNCTION */ post_delay_time number(23,3) , /* FUNCTION */ post_delay_time_unit varchar2(10) , /* FUNCTION */ prior_delay_time number(23,3) , /* FUNCTION */ prior_delay_time_unit varchar2(10) , /* FUNCTION */ quality_check_time number(23,3) , /* FUNCTION */ quality_check_time_unit varchar2(10) , /* FUNCTION */ quality_percent number(3) , /* FUNCTION */ resource_required_1 varchar2(100), /* FUNCTION */ resource_required_2 varchar2(100), /* FUNCTION */ resource_required_3 varchar2(100), /* FUNCTION */ resource_required_4 varchar2(100), /* FUNCTION */ response_needed varchar2(12) , /* FUNCTION */ sequence_in_parent number(6) , /* FUNCTION */ short_definition varchar2(240), /* FUNCTION */ sound_file varchar2(60) , /* FUNCTION */ total_cost_rate number(23,3) , /* FUNCTION */ total_cost_rate_unit varchar2(10) , /* FUNCTION */ total_time number(23,3) , /* FUNCTION */ total_time_unit varchar2(10) , /* FUNCTION */ to_be_automated_flag varchar2(1) , /* ELEMENT */ types number(38) , /* FUNCTION */ user_defined_property_0 varchar2(240), /* FUNCTION */ user_defined_property_1 varchar2(240), /* FUNCTION */ user_defined_property_10 varchar2(240), /* FUNCTION */ user_defined_property_11 varchar2(240), /* FUNCTION */ user_defined_property_12 varchar2(240), /* FUNCTION */ user_defined_property_13 varchar2(240), /* FUNCTION */ user_defined_property_14 varchar2(240), /* FUNCTION */ user_defined_property_15 varchar2(240), /* FUNCTION */ user_defined_property_16 varchar2(240), /* FUNCTION */ user_defined_property_17 varchar2(240), /* FUNCTION */ user_defined_property_18 varchar2(240), /* FUNCTION */ user_defined_property_19 varchar2(240), /* FUNCTION */ user_defined_property_2 varchar2(240), /* FUNCTION */ user_defined_property_3 varchar2(240), /* FUNCTION */ user_defined_property_4 varchar2(240), /* FUNCTION */ user_defined_property_5 varchar2(240), /* FUNCTION */ user_defined_property_6 varchar2(240), /* FUNCTION */ user_defined_property_7 varchar2(240), /* FUNCTION */ user_defined_property_8 varchar2(240), /* FUNCTION */ user_defined_property_9 varchar2(240), /* FUNCTION */ value_added varchar2(1) , /* FUNCTION */ video_file varchar2(60) , /* FUNCTION */ work_time number(23,3) , /* FUNCTION */ work_time_unit varchar2(10) ); type rm_indicators is record ( additional_cost_rate boolean not null default false, additional_cost_rate_unit boolean not null default false, bpr_generate_flag boolean not null default false, changed_by boolean not null default false, common_function_reference boolean not null default false, competitive_index_value 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, elementary_flag boolean not null default false, element_type_name boolean not null default false, execution_string boolean not null default false, export_id boolean not null default false, frequency boolean not null default false, frequency_unit boolean not null default false, function_label boolean not null default false, function_type boolean not null default false, icon_file boolean not null default false, id boolean not null default false, image_file boolean not null default false, irid boolean not null default false, ivid boolean not null default false, measured_time_1 boolean not null default false, measured_time_2 boolean not null default false, measured_time_3 boolean not null default false, measured_time_unit boolean not null default false, note_picture_file boolean not null default false, note_text boolean not null default false, note_type boolean not null default false, number_of_times_modified boolean not null default false, overhead_cost_rate boolean not null default false, overhead_cost_rate_unit boolean not null default false, parent_reference boolean not null default false, person_cost_rate boolean not null default false, person_cost_rate_unit boolean not null default false, post_delay_time boolean not null default false, post_delay_time_unit boolean not null default false, prior_delay_time boolean not null default false, prior_delay_time_unit boolean not null default false, quality_check_time boolean not null default false, quality_check_time_unit boolean not null default false, quality_percent boolean not null default false, resource_required_1 boolean not null default false, resource_required_2 boolean not null default false, resource_required_3 boolean not null default false, resource_required_4 boolean not null default false, response_needed boolean not null default false, sequence_in_parent boolean not null default false, short_definition boolean not null default false, sound_file boolean not null default false, total_cost_rate boolean not null default false, total_cost_rate_unit boolean not null default false, total_time boolean not null default false, total_time_unit boolean not null default false, to_be_automated_flag boolean not null default false, types boolean not null default false, user_defined_property_0 boolean not null default false, user_defined_property_1 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_2 boolean not null default false, user_defined_property_3 boolean not null default false, user_defined_property_4 boolean not null default false, user_defined_property_5 boolean not null default false, user_defined_property_6 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_added boolean not null default false, video_file boolean not null default false, work_time boolean not null default false, work_time_unit 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 check_out(i_irid number ,i_ivid number ,i_lock varchar2 default 'Y' ,i_notes varchar2 default null ,i_vlabel varchar2 default null ,o_ivid out number ,copy_deps_policy in varchar2 default 'Y'); procedure check_in(i_irid number ,i_ivid number ,i_notes varchar2 default null ,i_vlabel varchar2 default null ,o_ivid out number); procedure copy_pac(i_irid in number ,container_reference 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 ciofunction; / REM End of ciofun.pkh