-- A collection of procedures for deleting rows from the
-- repository meta model tables

prompt Package Header : jr_rm_del

create or replace package jr_rm_del is

  -------------------------------------------------------------------------
  -- Procedure : delete_element_type
  -------------------------------------------------------------------------
  procedure delete_element_type (i_product varchar2, i_name varchar2);
  procedure delete_element_type (i_irid    number  , i_ivid number);

  -------------------------------------------------------------------------
  -- Procedure : rm_property_del
  --
  -- Delete a property, its property map(s), and property extension
  -------------------------------------------------------------------------
  procedure rm_property_del ( property_irid number);

  -------------------------------------------------------------------------
  -- Procedure : rm_property_del
  --
  -- Delete a property, its property map(s), and property extension
  -- Exception NO_PROPERTY_EXISTS raised if no such property exists
  -------------------------------------------------------------------------
  procedure rm_property_del ( type_irid     number
                            , property_name varchar2
                            , product       varchar2  default 'CI'
                            );

  -------------------------------------------------------------------------
  -- Procedure : delete_table
  -------------------------------------------------------------------------
  procedure delete_table (i_name varchar2);
  procedure delete_table (i_irid number, i_ivid number);

  -------------------------------------------------------------------------
  -- Procedure : delete_view
  -------------------------------------------------------------------------
  procedure delete_view (i_name varchar2);
  procedure delete_view (i_irid number, i_ivid number);

  -------------------------------------------------------------------------
  -- Procedure : delete_sequence
  -------------------------------------------------------------------------
  procedure delete_sequence (i_name varchar2);
  procedure delete_sequence (i_irid number, i_ivid number);

  -------------------------------------------------------------------------
  -- Procedure : delete_stored_object
  -------------------------------------------------------------------------
  procedure delete_stored_object (i_name varchar2);
  procedure delete_stored_object (i_irid number, i_ivid number);

  -------------------------------------------------------------------------
  -- Procedure : delete_synonym
  -------------------------------------------------------------------------
  procedure delete_synonym (i_name varchar2);
  procedure delete_synonym (i_irid number, i_ivid number);

  -------------------------------------------------------------------------
  -- Procedure : delete_meta_data
  -------------------------------------------------------------------------
  procedure delete_meta_data ( object_irid  number
                             , object_ivid  number
                             , object_type  varchar2
                             );

  --------------------------------------------------------------------------
  -- Procedure : drop_schema
  --
  -- Note, this procedure is called by either :
  -- 1) jr_registration.drop_schema - the public registration interface
  --    or
  -- 2) directly when dropping our own models so we can set options
  --    that we don't want to allow for users
  -- 
  -- See jr_registration.drop_schema for descriptions of parameters
  --
  -- Extra parameters here are :
  --
  --  delete_logical_model  : Delete meta data in the logical model ? (rm_element_types,
  --                          rm_properties etc).
  --                          For internal use only when dropping the Designer model,
  --                          since configuration provides the meta data in the
  --                          logical model)
  --
  --
  --------------------------------------------------------------------------
  procedure drop_schema ( schema_name          varchar2
                        , log_file_location    varchar2  default null
                        , ddl_file_location    varchar2  default null
                        , log_file_name        varchar2  default 'jr_del.log'
                        , drop_ddl_file        varchar2  default 'jrdel.sql'
                        , delete_meta_data     boolean   default true
                        , delete_logical_model boolean   default true
                        );

  -------------------------------------------------------------------------
  -- Procedure : drop_all_schemas
  --
  -- See notes above for drop_schema
  -------------------------------------------------------------------------
  procedure drop_all_schemas ( log_file_location    varchar2  default null
                             , ddl_file_location    varchar2  default null
                             , log_file_name        varchar2  default 'jr_del.log'
                             , drop_ddl_file        varchar2  default 'jrdel.sql'
                             , delete_meta_data     boolean   default true
                             , delete_logical_model boolean   default true
                             );

  -------------------------------------------------------------------------
  -- Procedure : rm_link_property_del_pk_end 
  -------------------------------------------------------------------------
  procedure rm_link_property_del_pk_end (i_irid number);

  -------------------------------------------------------------------------
  -- Procedure : rm_link_property_del_fk_end 
  -------------------------------------------------------------------------
  procedure rm_link_property_del_fk_end (i_irid number);

  -------------------------------------------------------------------------
  -- Exceptions
  -------------------------------------------------------------------------
  NO_PROPERTY_EXISTS  exception;

end jr_rm_del;
/