-- A collection of procedures for inserting rows into the -- repository meta model tables prompt Package Header : jr_rm_ins create or replace package jr_rm_ins is --------------------------------------------- -- Procedure : set_schema --------------------------------------------- procedure set_schema ( schema_irid number , schema_ivid number ); --------------------------------------------- -- Procedure : set_product_code --------------------------------------------- procedure set_product_code (product varchar2 default 'JR'); --------------------------------------------- -- Procedure : set_product --------------------------------------------- procedure set_product (product varchar2 default 'JR'); --------------------------------------------- -- Fucntion : get_product --------------------------------------------- function get_product return varchar2; pragma restrict_references(get_product, wnps, wnds); --------------------------------------------- -- Procedure : rm_sql_schema_version_ins --------------------------------------------- procedure rm_sql_schema_version_ins ( p_name varchar2 -- , p_product varchar2 , p_comments varchar2 , p_irid out number , p_ivid out number , p_type varchar2 default 'USER' ); --------------------------------------------- -- Procedure : rm_sql_table_ins --------------------------------------------- procedure rm_sql_table_ins ( p_table_name varchar2 , p_table_irid number , p_table_ivid number default 1 , p_populate_logical_model varchar2 default 'Y' , p_gen_api varchar2 default 'Y' , p_gen_api_callout varchar2 default 'N' , p_gen_api_callout_stub varchar2 default 'N' , p_maintain_dependent_objs boolean default false , p_is_system varchar2 default null , p_schema_type varchar2 default 'USER' , p_pct_free number default null , p_pct_used number default null , p_ini_trans number default null , p_max_trans number default null , p_initial_extent number default null , p_next_extent number default null , p_min_extents number default null , p_max_extents number default null , p_pct_increase number default null , p_comments varchar2 default null , p_extension varchar2 default null , p_owned_by varchar2 default null , p_nls varchar2 default null ); --------------------------------------------- -- Procedure : rm_sql_table_upd --------------------------------------------- procedure rm_sql_table_upd ( p_table_irid number , p_table_ivid number , p_owning_table varchar2 default null , p_name_column varchar2 default null , p_logical_type_column varchar2 default null , p_date_created_column varchar2 default null , p_date_changed_column varchar2 default null , p_created_by_column varchar2 default null , p_changed_by_column varchar2 default null , p_notm_column varchar2 default null ); --------------------------------------------- -- Procedure : rm_sql_table_property_ins --------------------------------------------- procedure rm_sql_table_property_ins ( p_table_irid number , p_table_ivid number , p_property varchar2 , p_value varchar2 ); --------------------------------------------- -- Procedure : rm_sql_column_ins --------------------------------------------- procedure rm_sql_column_ins ( p_table_irid number , p_id number , p_column_name varchar2 , p_column_seq number , p_data_type varchar2 , p_data_length number , p_data_precision number , p_data_scale number , p_nullable varchar2 , p_table_ivid number default 1 , p_default_length number default null , p_data_default long default null , p_num_distinct number default null , p_low_value raw default null , p_high_value raw default null , p_comments varchar2 default null , p_lob_index_name varchar2 default null , p_lob_chunk number default null , p_lob_pctversion number default null , p_lob_cache varchar2 default null , p_lob_logging varchar2 default null , p_lob_in_row varchar2 default null , p_nls varchar2 default null ); --------------------------------------------- -- Procedure : define_column -- Usage : Only use to define meta data -- for the special columns : -- IRID -- IVID -- PARENT_IVID --------------------------------------------- procedure define_column ( i_col_table_irid number , i_col_table_ivid number , i_col_id number , i_col_name varchar2 ); --------------------------------------------- -- Procedure : rm_sql_column_property_ins --------------------------------------------- procedure rm_sql_column_property_ins ( p_col_table_irid number , p_col_table_ivid number , p_col_column_id number , p_property varchar2 , p_value varchar2 ); --------------------------------------------- -- Procedure : rm_sql_constraint_ins --------------------------------------------- procedure rm_sql_constraint_ins ( p_constraint_irid number , p_constraint_ivid number , p_table_irid number , p_table_ivid number , p_constraint_name varchar2 , p_constraint_type varchar2 , p_search_condition long , p_r_constraint_name varchar2 , p_delete_rule varchar2 , p_deferrable varchar2 , p_is_owning_fk varchar2 , p_key_updateable varchar2 default 'Y' ); --------------------------------------------- -- Procedure : rm_sql_cons_column_ins --------------------------------------------- procedure rm_sql_cons_column_ins ( p_constraint_irid number , p_constraint_ivid number , p_position number , p_column_name varchar2 ); --------------------------------------------- -- Procedure : rm_sql_trigger_ins --------------------------------------------- procedure rm_sql_trigger_ins ( p_trigger_irid number , p_trigger_ivid number , p_table_irid number , p_table_ivid number , p_trigger_name varchar2 , p_trigger_type varchar2 , p_triggering_event varchar2 , p_referencing_names varchar2 , p_when_clause varchar2 , p_description varchar2 , p_trigger_body long ); --------------------------------------------- -- Procedure : rm_sql_index_ins --------------------------------------------- procedure rm_sql_index_ins ( p_index_irid number , p_index_ivid number , p_table_irid number , p_table_ivid number , p_index_name varchar2 , p_index_type varchar2 , p_uniqueness varchar2 , p_ini_trans number , p_max_trans number , p_initial_extent number , p_next_extent number , p_min_extents number , p_max_extents number , p_pct_increase number , p_pct_threshold number , p_include_column number , p_freelists number , p_freelist_groups number , p_pct_free number ); --------------------------------------------- -- Procedure : rm_sql_ind_column_ins --------------------------------------------- procedure rm_sql_ind_column_ins ( p_index_irid number , p_index_ivid number , p_column_position number , p_column_name varchar2 , p_column_length number ); --------------------------------------------- -- Procedure : rm_sql_view_ins --------------------------------------------- procedure rm_sql_view_ins ( p_view_irid number , p_view_ivid number , p_view_name varchar2 , p_text_length number , p_text long , p_type_text_length number , p_type_text varchar2 , p_oid_text_length number , p_oid_text varchar2 , p_view_type_owner varchar2 , p_view_type varchar2 ); --------------------------------------------- -- Procedure : rm_sql_sequence_ins --------------------------------------------- procedure rm_sql_sequence_ins ( p_sequence_irid number , p_sequence_ivid number , p_sequence_name varchar2 , p_min_value number , p_max_value number , p_increment_by number , p_cycle_flag varchar2 , p_order_flag varchar2 , p_cache_size number , p_start_with number ); --------------------------------------------- -- Procedure : rm_sql_stored_object_ins --------------------------------------------- procedure rm_sql_stored_object_ins ( p_stored_object_irid number , p_stored_object_ivid number , p_object_name varchar2 , p_object_type varchar2 ); --------------------------------------------- -- Procedure : rm_sql_source_ins --------------------------------------------- procedure rm_sql_source_ins ( p_stored_object_irid number , p_stored_object_ivid number , p_line number , p_text varchar2 ); --------------------------------------------- -- Procedure : rm_sql_synonym_ins --------------------------------------------- procedure rm_sql_synonym_ins ( p_synonym_irid number , p_synonym_ivid number , p_synonym_name varchar2 , p_object_name varchar2 ); ------------------------------------------------------------------------- -- Procedure : rm_interface_impl_ins ------------------------------------------------------------------------- procedure rm_interface_impl_ins ( i_interface number , i_class_implementation number , i_inheritance_level varchar2 ); ------------------------------------------------------------------------- -- Procedure : rm_link_descriptor_prop_ins ------------------------------------------------------------------------- procedure rm_link_descriptor_prop_ins ( i_property number , i_link_type number , i_sequence number ); --------------------------------------------- -- Procedure : rm_element_type_ins -- -- CW 23-Mar-99 -- Fix bug 855799, register types as subtype of PAC or SAC --------------------------------------------- procedure rm_element_type_ins ( i_element_type_irid number , i_table_irid number , i_type_name varchar2 , i_type_short_name varchar2 , i_type_plural_name varchar2 , i_nls_name varchar2 , i_nls_plural_name varchar2 , i_owned_by varchar2 , o_srt_id number , i_product varchar2 default 'JR' , i_is_primary varchar2 default 'Y' , i_abstract varchar2 default 'N' , i_interface varchar2 default 'N' , i_java_full_name varchar2 default null , i_supertype_id number default null , i_help_tag varchar2 default null , i_user_extension varchar2 default 'NNY' , i_element_type_ivid number default 1 , i_schema_type varchar2 default 'USER' ); -------------------------------------------------------------------- -- Function : create_data_type -------------------------------------------------------------------- function create_data_type ( i_data_type varchar2 , i_data_length number , i_data_precision number , i_data_scale number , i_domain_name varchar2 default null , i_super_dt_id number default null , i_java_datatype varchar2 default null ) return number; /* --------------------------------------------- -- Procedure : rm_data_type_ins --------------------------------------------- procedure rm_data_type_ins ( i_datatype_id number , i_domain_name varchar2 , i_data_type varchar2 , i_data_length number , i_data_precision number , i_data_scale number , i_supertypes number default null ); */ --------------------------------------------- -- Procedure : rm_data_type_value_ins --------------------------------------------- procedure rm_data_type_value_ins ( data_type_id number , value_identifier varchar2 , value varchar2 , value_seq number ); ----------------------------------------------------------- -- Procedure : rm_property_range_ins ----------------------------------------------------------- procedure rm_property_range_ins ( property_id number , lovalue number , hivalue number ); ----------------------------------------------------------- -- Procedure : rm_property_map_ins ----------------------------------------------------------- procedure rm_property_map_ins ( i_element_type_irid number , i_property_irid number , i_srt_id number , i_column_id number ); ----------------------------------------------------------- -- Procedure : rm_property_map_upd ----------------------------------------------------------- procedure rm_property_map_upd ( pm_irid number , column_irid number ); ----------------------------------------------------------- -- Function : rm_property_map_upd -- Return true (and id of property) if property is one of : -- IRID, IVID, PAC_REF, PAC_REFERENCE, PARENT_IVID -- DATE_CREATED, CREATED_BY, DATE_CHANGED, CHANGED_BY -- NOTM, NUMBER_OF_TIMES_MODIFIED -- TYPES ----------------------------------------------------------- function is_id_or_audit_property ( pname in varchar2 , pid out number ) return boolean; ----------------------------------------------------------- -- Procedure : rm_property_ins ----------------------------------------------------------- procedure rm_property_ins ( i_element_type_irid number , i_property_irid number , i_srt_id number , i_column_id number , i_prop_name varchar2 , i_data_type varchar2 , i_data_length number , i_data_precision number , i_data_scale number , i_nullable varchar2 , i_default_length number , i_data_default varchar2 , i_prop_nls_name varchar2 , i_prop_nls_default varchar2 , i_prop_nls_hint varchar2 , i_prop_case_mode varchar2 default 'M' , i_prop_displayed varchar2 default 'Y' , i_prop_display_seq number default 1 , i_prop_maintained varchar2 default 'U' , i_prop_update_mode varchar2 default 'U' , i_prop_help_tag varchar2 default null , i_descriptor_seq number default null , i_is_stored varchar2 default 'Y' , i_user_extension varchar2 default 'NNY' , i_domain_id number default null , i_domain_name varchar2 default null , i_java_datatype varchar2 default null , i_property_ivid number default 1 ); ------------------------------------------------------------------------- -- Procedure : rm_link_type_ins ------------------------------------------------------------------------- procedure rm_link_type_ins ( i_link_type_irid number , i_name varchar2 default null ); ------------------------------------------------------------------------- -- Procedure : rm_link_property_ins ------------------------------------------------------------------------- procedure rm_link_property_ins ( i_element_type_irid number , i_link_prop_irid number , i_link_prop_name varchar2 , i_link_type_irid number , i_min_cardinality number , i_max_cardinality number , i_mandatory varchar2 , i_navigable varchar2 , i_transferable varchar2 , i_ordered_set varchar2 , i_aggregation varchar2 , i_friendly_name varchar2 , i_descriptor_seq number default null , i_sequence_in_link number default 1 , i_case_mode varchar2 default 'M' -- Mixed , i_displayed varchar2 default 'Y' , i_is_stored varchar2 default 'Y' , i_maintained varchar2 default 'U' -- User , i_update_mode varchar2 default 'U' , i_user_extension varchar2 default 'NNY' , i_arc_no number default null , i_is_owning_assoc varchar2 default 'N' , i_link_prop_ivid number default 1 ); ------------------------------------------------------------------------- -- Procedure : rm_link_property_ins_pk_end ------------------------------------------------------------------------- -- procedure rm_link_property_ins_pk_end -- ( i_element_type_irid number -- , i_pk_name varchar2 -- , i_is_owning_assoc varchar2 -- , i_link_type_id number -- , i_fk_link_property_id number -- , i_pk_property_name varchar2 -- , i_sequence_in_link number -- ); ------------------------------------------------------------------------- -- Procedure : rm_link_property_ins_fk_end ------------------------------------------------------------------------- procedure rm_link_property_ins_fk_end ( i_property_irid number , i_fk_name varchar2 , i_pk_name varchar2 , i_is_owning_assoc varchar2 , i_pk_element_type_id number , i_pk_property_name varchar2 , i_link_type_id in out number , i_sequence_in_link number ); procedure rm_assertion_ins(id NUMBER, name VARCHAR2, element_id NUMBER, message_usage_id NUMBER, expression_id NUMBER, classification VARCHAR2, deferred VARCHAR2, enabled VARCHAR2, facility VARCHAR2, generated VARCHAR2, product VARCHAR2, cnRM_ASSERTIONS NUMBER); procedure rm_expression_ins(id NUMBER, text VARCHAR2, syntax VARCHAR2, cnRM_EXPRESSIONS NUMBER); procedure rm_expression_prop_usage_ins(id NUMBER, element_id NUMBER, expression_id NUMBER, property_id NUMBER, sequence NUMBER, cnRM_EXPRESSION_PROP_USAGES NUMBER); function rm_sql_row_type_ins (i_table_irid number) return number; end jr_rm_ins; /