create or replace package ciodatabase_object_grant as -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- File: ciodog.pkh -- Auth: RM3 Generated -- Date: 22nd Sep 1999, 06:17:27pm -- Cont: Element Type Interface (Specification) for -- product -- element type -- short name -- Note: Generated from database schema SCHEMA4012_D -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Properties -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - type rm_values is record ( /* DATABASE_OBJECT_GRANT */ all_access_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ alter_flag varchar2(1) , /* ELEMENT */ changed_by varchar2(30) , /* ELEMENT */ created_by varchar2(30) , /* DATABASE_OBJECT_GRANT */ create_synonym_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ database_user_reference number(38) , /* ELEMENT */ date_changed date , /* ELEMENT */ date_created date , /* DATABASE_OBJECT_GRANT */ delete_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ dequeue_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ directory_reference number(38) , /* ACCESS_CONTROLLED_ELEMENT */ element_type_name varchar2(10) , /* DATABASE_OBJECT_GRANT */ enqueue_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ execute_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ grant_access_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ grant_option_for varchar2(3) , /* DATABASE_OBJECT_GRANT */ grant_option_to varchar2(3) , /* ELEMENT */ id number(38) , /* DATABASE_OBJECT_GRANT */ index_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ insert_flag varchar2(1) , /* CIELEMENT */ irid number(38) , /* CIELEMENT */ ivid number(38) , /* DATABASE_OBJECT_GRANT */ jmi_reference number(38) , /* ELEMENT */ number_of_times_modified number(38) , /* SECONDARY_ACCESS_ELEMENT */ pac_reference number(38) , /* SECONDARY_ACCESS_ELEMENT */ parent_ivid number(38) , /* DATABASE_OBJECT_GRANT */ plsql_module_reference number(38) , /* DATABASE_OBJECT_GRANT */ qui_reference number(38) , /* DATABASE_OBJECT_GRANT */ read_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ reference_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ remark varchar2(240), /* DATABASE_OBJECT_GRANT */ role_reference number(38) , /* DATABASE_OBJECT_GRANT */ select_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ sequence_reference number(38) , /* DATABASE_OBJECT_GRANT */ snapshot_reference number(38) , /* DATABASE_OBJECT_GRANT */ table_reference number(38) , /* ELEMENT */ types number(38) , /* DATABASE_OBJECT_GRANT */ update_flag varchar2(1) , /* DATABASE_OBJECT_GRANT */ user_defined_property_0 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_1 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_10 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_11 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_12 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_13 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_14 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_15 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_16 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_17 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_18 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_19 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_2 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_3 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_4 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_5 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_6 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_7 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_8 varchar2(240), /* DATABASE_OBJECT_GRANT */ user_defined_property_9 varchar2(240), /* DATABASE_OBJECT_GRANT */ view_reference number(38) ); type rm_indicators is record ( all_access_flag boolean not null default false, alter_flag boolean not null default false, changed_by boolean not null default false, created_by boolean not null default false, create_synonym_flag boolean not null default false, database_user_reference boolean not null default false, date_changed boolean not null default false, date_created boolean not null default false, delete_flag boolean not null default false, dequeue_flag boolean not null default false, directory_reference boolean not null default false, element_type_name boolean not null default false, enqueue_flag boolean not null default false, execute_flag boolean not null default false, grant_access_flag boolean not null default false, grant_option_for boolean not null default false, grant_option_to boolean not null default false, id boolean not null default false, index_flag boolean not null default false, insert_flag boolean not null default false, irid boolean not null default false, ivid boolean not null default false, jmi_reference boolean not null default false, number_of_times_modified 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, qui_reference boolean not null default false, read_flag boolean not null default false, reference_flag boolean not null default false, remark boolean not null default false, role_reference boolean not null default false, select_flag boolean not null default false, sequence_reference boolean not null default false, snapshot_reference boolean not null default false, table_reference boolean not null default false, types boolean not null default false, update_flag 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, view_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 ciodatabase_object_grant; / REM End of ciodog.pkh