create or replace package cioassociation_end as -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- File: cioaen.pkh -- Auth: RM3 Generated -- Date: 22nd Sep 1999, 05:29:14pm -- Cont: Element Type Interface (Specification) for -- product -- element type -- short name -- Note: Generated from database schema SCHEMA4012_D -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Properties -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - type rm_values is record ( /* ASSOCIATION_END */ aggregation varchar2(6) , /* ASSOCIATION_END */ association_reference number(38) , /* ASSOCIATION_END */ association_role_in varchar2(3) , /* ELEMENT */ changed_by varchar2(30) , /* ASSOCIATION_END */ change_restriction varchar2(8) , /* ASSOCIATION_END */ classifier_reference number(38) , /* ASSOCIATION_END */ cor_depth_level number(12) , /* ELEMENT */ created_by varchar2(30) , /* ELEMENT */ date_changed date , /* ELEMENT */ date_created date , /* ASSOCIATION_END */ db_collection_as_refs_flag varchar2(1) , /* ASSOCIATION_END */ default_column_name varchar2(30) , /* ASSOCIATION_END */ default_db_collection_name varchar2(30) , /* ASSOCIATION_END */ default_db_collection_type varchar2(12) , /* ACCESS_CONTROLLED_ELEMENT */ element_type_name varchar2(10) , /* ASSOCIATION_END */ entity_object_reference number(38) , /* ASSOCIATION_END */ generate_class_member_flag varchar2(1) , /* ASSOCIATION_END */ generic_class_reference number(38) , /* ELEMENT */ id number(38) , /* ASSOCIATION_END */ interface_classifier_reference number(38) , /* CIELEMENT */ irid number(38) , /* CIELEMENT */ ivid number(38) , /* ASSOCIATION_END */ maximum_multiplicity varchar2(10) , /* ASSOCIATION_END */ minimum_multiplicity number(10) , /* ASSOCIATION_END */ name varchar2(100), /* ASSOCIATION_END */ navigation_target_flag varchar2(1) , /* ELEMENT */ number_of_times_modified number(38) , /* ASSOCIATION_END */ ordered_flag varchar2(1) , /* SECONDARY_ACCESS_ELEMENT */ pac_reference number(38) , /* SECONDARY_ACCESS_ELEMENT */ parent_ivid number(38) , /* ASSOCIATION_END */ persistent_flag varchar2(1) , /* ASSOCIATION_END */ scope varchar2(8) , /* ASSOCIATION_END */ sequence number(6) , /* ASSOCIATION_END */ serializable_flag varchar2(1) , /* ASSOCIATION_END */ sort_order_direction varchar2(1) , /* ASSOCIATION_END */ sort_order_sequence number(6) , /* ASSOCIATION_END */ store_ref_with_rowid_flag varchar2(1) , /* ELEMENT */ types number(38) , /* ASSOCIATION_END */ uniqueness_rule_reference number(38) , /* ASSOCIATION_END */ visibility varchar2(10) , /* ASSOCIATION_END */ volatile_flag varchar2(1) ); type rm_indicators is record ( aggregation boolean not null default false, association_reference boolean not null default false, association_role_in boolean not null default false, changed_by boolean not null default false, change_restriction boolean not null default false, classifier_reference boolean not null default false, cor_depth_level 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, db_collection_as_refs_flag boolean not null default false, default_column_name boolean not null default false, default_db_collection_name boolean not null default false, default_db_collection_type boolean not null default false, element_type_name boolean not null default false, entity_object_reference boolean not null default false, generate_class_member_flag boolean not null default false, generic_class_reference boolean not null default false, id boolean not null default false, interface_classifier_reference boolean not null default false, irid boolean not null default false, ivid boolean not null default false, maximum_multiplicity boolean not null default false, minimum_multiplicity boolean not null default false, name boolean not null default false, navigation_target_flag boolean not null default false, number_of_times_modified boolean not null default false, ordered_flag boolean not null default false, pac_reference boolean not null default false, parent_ivid boolean not null default false, persistent_flag boolean not null default false, scope boolean not null default false, sequence boolean not null default false, serializable_flag boolean not null default false, sort_order_direction boolean not null default false, sort_order_sequence boolean not null default false, store_ref_with_rowid_flag boolean not null default false, types boolean not null default false, uniqueness_rule_reference boolean not null default false, visibility boolean not null default false, volatile_flag 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 cioassociation_end; / REM End of cioaen.pkh