create or replace package ciomodule_argument as -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- File: cioarg.pkh -- Auth: RM3 Generated -- Date: 22nd Sep 1999, 07:58:42pm -- Cont: Element Type Interface (Specification) for -- product -- element type -- short name -- Note: Generated from database schema SCHEMA4012_D -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Properties -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - type rm_values is record ( /* MODULE_ARGUMENT */ attribute_or_dataitem number(38) , /* ELEMENT */ changed_by varchar2(30) , /* MODULE_ARGUMENT */ column_reference number(38) , /* ELEMENT */ created_by varchar2(30) , /* MODULE_ARGUMENT */ datastructure_reference number(38) , /* MODULE_ARGUMENT */ datatype varchar2(70) , /* ELEMENT */ date_changed date , /* ELEMENT */ date_created date , /* MODULE_ARGUMENT */ default_value varchar2(60) , /* MODULE_ARGUMENT */ default_value_type varchar2(15) , /* MODULE_ARGUMENT */ display_flag varchar2(1) , /* MODULE_ARGUMENT */ domain_reference number(38) , /* ACCESS_CONTROLLED_ELEMENT */ element_type_name varchar2(10) , /* MODULE_ARGUMENT */ general_module_reference number(38) , /* ELEMENT */ id number(38) , /* MODULE_ARGUMENT */ input_mask varchar2(20) , /* MODULE_ARGUMENT */ input_output_identifier varchar2(13) , /* CIELEMENT */ irid number(38) , /* CIELEMENT */ ivid number(38) , /* MODULE_ARGUMENT */ length number(6) , /* MODULE_ARGUMENT */ module_argument_for varchar2(8) , /* MODULE_ARGUMENT */ module_type_for varchar2(3) , /* MODULE_ARGUMENT */ name varchar2(30) , /* ELEMENT */ number_of_times_modified number(38) , /* MODULE_ARGUMENT */ optional_flag varchar2(1) , /* MODULE_ARGUMENT */ oracle_type_reference number(38) , /* SECONDARY_ACCESS_ELEMENT */ pac_reference number(38) , /* SECONDARY_ACCESS_ELEMENT */ parent_ivid number(38) , /* MODULE_ARGUMENT */ plsql_module_reference number(38) , /* MODULE_ARGUMENT */ position number(6) , /* MODULE_ARGUMENT */ prompt varchar2(130), /* MODULE_ARGUMENT */ remark varchar2(240), /* MODULE_ARGUMENT */ scale number(3) , /* MODULE_ARGUMENT */ soft_lov varchar2(1) , /* MODULE_ARGUMENT */ substitution_variable varchar2(40) , /* MODULE_ARGUMENT */ suggestion_list_flag varchar2(1) , /* MODULE_ARGUMENT */ table_definition_reference number(38) , /* ELEMENT */ types number(38) , /* MODULE_ARGUMENT */ user_defined_property_0 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_1 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_10 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_11 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_12 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_13 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_14 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_15 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_16 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_17 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_18 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_19 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_2 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_3 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_4 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_5 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_6 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_7 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_8 varchar2(240), /* MODULE_ARGUMENT */ user_defined_property_9 varchar2(240) ); type rm_indicators is record ( attribute_or_dataitem boolean not null default false, changed_by boolean not null default false, column_reference boolean not null default false, created_by boolean not null default false, datastructure_reference boolean not null default false, datatype boolean not null default false, date_changed boolean not null default false, date_created boolean not null default false, default_value boolean not null default false, default_value_type boolean not null default false, display_flag boolean not null default false, domain_reference boolean not null default false, element_type_name boolean not null default false, general_module_reference boolean not null default false, id boolean not null default false, input_mask boolean not null default false, input_output_identifier boolean not null default false, irid boolean not null default false, ivid boolean not null default false, length boolean not null default false, module_argument_for boolean not null default false, module_type_for boolean not null default false, name boolean not null default false, number_of_times_modified boolean not null default false, optional_flag boolean not null default false, oracle_type_reference boolean not null default false, pac_reference boolean not null default false, parent_ivid boolean not null default false, plsql_module_reference boolean not null default false, position boolean not null default false, prompt boolean not null default false, remark boolean not null default false, scale boolean not null default false, soft_lov boolean not null default false, substitution_variable boolean not null default false, suggestion_list_flag boolean not null default false, table_definition_reference 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 ); 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 ciomodule_argument; / REM End of cioarg.pkh