create or replace package ciocolumn as -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- File: ciocol.pkh -- Auth: RM3 Generated -- Date: 22nd Sep 1999, 06:00:57pm -- Cont: Element Type Interface (Specification) for -- product -- element type -- short name -- Note: Generated from database schema SCHEMA4012_D -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Properties -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - type rm_values is record ( /* COLUMN */ auto_generated varchar2(2) , /* COLUMN */ average_length number(5) , /* COLUMN */ base_column_reference number(38) , /* ELEMENT */ changed_by varchar2(30) , /* COLUMN */ cluster_column_reference number(38) , /* COLUMN */ column_denormalised_from number(38) , /* COLUMN */ column_for varchar2(3) , /* COLUMN */ complete_flag varchar2(1) , /* COLUMN */ constraint_denormalised_via number(38) , /* ELEMENT */ created_by varchar2(30) , /* COLUMN */ datatype varchar2(35) , /* ELEMENT */ date_changed date , /* ELEMENT */ date_created date , /* COLUMN */ decimal_places number(4) , /* COLUMN */ default_display_type varchar2(20) , /* COLUMN */ default_implementation_item varchar2(30) , /* COLUMN */ default_value varchar2(60) , /* COLUMN */ default_value_type varchar2(15) , /* COLUMN */ denormalized_summary_function varchar2(19) , /* COLUMN */ derivation_expression_type varchar2(14) , /* COLUMN */ descriptor_column number(2) , /* COLUMN */ display_flag varchar2(1) , /* COLUMN */ display_height number(6) , /* COLUMN */ display_length number(5) , /* COLUMN */ display_sequence number(6) , /* COLUMN */ domain_reference number(38) , /* ACCESS_CONTROLLED_ELEMENT */ element_type_name varchar2(10) , /* COLUMN */ expression_text varchar2(240) , /* COLUMN */ field_initial_value varchar2(120) , /* COLUMN */ field_level varchar2(2) , /* COLUMN */ field_null_value varchar2(20) , /* COLUMN */ final_volume number(3) , /* COLUMN */ format_modifier varchar2(60) , /* COLUMN */ help_text varchar2(2000), /* COLUMN */ highlighting varchar2(240) , /* ELEMENT */ id number(38) , /* COLUMN */ initial_volume number(3) , /* CIELEMENT */ irid number(38) , /* CIELEMENT */ ivid number(38) , /* COLUMN */ justification varchar2(6) , /* COLUMN */ maximum_length number(5) , /* COLUMN */ name varchar2(30) , /* COLUMN */ null_indicator varchar2(8) , /* ELEMENT */ number_of_times_modified number(38) , /* COLUMN */ object_type_inclusion varchar2(6) , /* COLUMN */ occurs varchar2(30) , /* COLUMN */ oracle_object_type_reference number(38) , /* COLUMN */ oracle_type_reference number(38) , /* COLUMN */ order_sequence number(6) , /* SECONDARY_ACCESS_ELEMENT */ pac_reference number(38) , /* SECONDARY_ACCESS_ELEMENT */ parent_ivid number(38) , /* COLUMN */ prompt varchar2(132) , /* COLUMN */ redefines varchar2(30) , /* COLUMN */ relation_selection_reference number(38) , /* COLUMN */ relation_type varchar2(6) , /* COLUMN */ remark varchar2(2000), /* COLUMN */ scope_table_reference number(38) , /* COLUMN */ sequence_number number(6) , /* COLUMN */ sequence_reference number(38) , /* COLUMN */ server_defaulted_flag varchar2(1) , /* COLUMN */ server_derived_flag varchar2(1) , /* COLUMN */ signed varchar2(1) , /* COLUMN */ soft_lov varchar2(1) , /* COLUMN */ sorting_order varchar2(1) , /* COLUMN */ source_attribute_reference number(38) , /* COLUMN */ source_entity_derived_from number(38) , /* COLUMN */ source_relationship_end number(38) , /* COLUMN */ source_rel_entity number(38) , /* COLUMN */ source_rel_entity_attribute number(38) , /* COLUMN */ storage_format varchar2(16) , /* COLUMN */ store_ref_with_rowid_flag varchar2(1) , /* COLUMN */ suggestion_list_flag varchar2(1) , /* COLUMN */ table_reference number(38) , /* ELEMENT */ types number(38) , /* COLUMN */ uppercase varchar2(1) , /* COLUMN */ user_defined_property_0 varchar2(240) , /* COLUMN */ user_defined_property_1 varchar2(240) , /* COLUMN */ user_defined_property_10 varchar2(240) , /* COLUMN */ user_defined_property_11 varchar2(240) , /* COLUMN */ user_defined_property_12 varchar2(240) , /* COLUMN */ user_defined_property_13 varchar2(240) , /* COLUMN */ user_defined_property_14 varchar2(240) , /* COLUMN */ user_defined_property_15 varchar2(240) , /* COLUMN */ user_defined_property_16 varchar2(240) , /* COLUMN */ user_defined_property_17 varchar2(240) , /* COLUMN */ user_defined_property_18 varchar2(240) , /* COLUMN */ user_defined_property_19 varchar2(240) , /* COLUMN */ user_defined_property_2 varchar2(240) , /* COLUMN */ user_defined_property_3 varchar2(240) , /* COLUMN */ user_defined_property_4 varchar2(240) , /* COLUMN */ user_defined_property_5 varchar2(240) , /* COLUMN */ user_defined_property_6 varchar2(240) , /* COLUMN */ user_defined_property_7 varchar2(240) , /* COLUMN */ user_defined_property_8 varchar2(240) , /* COLUMN */ user_defined_property_9 varchar2(240) , /* COLUMN */ validation_failure_message varchar2(70) , /* COLUMN */ where_validation_type varchar2(14) ); type rm_indicators is record ( auto_generated boolean not null default false, average_length boolean not null default false, base_column_reference boolean not null default false, changed_by boolean not null default false, cluster_column_reference boolean not null default false, column_denormalised_from boolean not null default false, column_for boolean not null default false, complete_flag boolean not null default false, constraint_denormalised_via boolean not null default false, created_by 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, decimal_places boolean not null default false, default_display_type boolean not null default false, default_implementation_item boolean not null default false, default_value boolean not null default false, default_value_type boolean not null default false, denormalized_summary_function boolean not null default false, derivation_expression_type boolean not null default false, descriptor_column boolean not null default false, display_flag boolean not null default false, display_height boolean not null default false, display_length boolean not null default false, display_sequence boolean not null default false, domain_reference boolean not null default false, element_type_name boolean not null default false, expression_text boolean not null default false, field_initial_value boolean not null default false, field_level boolean not null default false, field_null_value boolean not null default false, final_volume boolean not null default false, format_modifier boolean not null default false, help_text boolean not null default false, highlighting boolean not null default false, id boolean not null default false, initial_volume boolean not null default false, irid boolean not null default false, ivid boolean not null default false, justification boolean not null default false, maximum_length boolean not null default false, name boolean not null default false, null_indicator boolean not null default false, number_of_times_modified boolean not null default false, object_type_inclusion boolean not null default false, occurs boolean not null default false, oracle_object_type_reference boolean not null default false, oracle_type_reference boolean not null default false, order_sequence boolean not null default false, pac_reference boolean not null default false, parent_ivid boolean not null default false, prompt boolean not null default false, redefines boolean not null default false, relation_selection_reference boolean not null default false, relation_type boolean not null default false, remark boolean not null default false, scope_table_reference boolean not null default false, sequence_number boolean not null default false, sequence_reference boolean not null default false, server_defaulted_flag boolean not null default false, server_derived_flag boolean not null default false, signed boolean not null default false, soft_lov boolean not null default false, sorting_order boolean not null default false, source_attribute_reference boolean not null default false, source_entity_derived_from boolean not null default false, source_relationship_end boolean not null default false, source_rel_entity boolean not null default false, source_rel_entity_attribute boolean not null default false, storage_format boolean not null default false, store_ref_with_rowid_flag boolean not null default false, suggestion_list_flag boolean not null default false, table_reference boolean not null default false, types boolean not null default false, uppercase 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, validation_failure_message boolean not null default false, where_validation_type 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 ciocolumn; / REM End of ciocol.pkh