-- jr_ues_chk
-- Helper package to support deletion if elements where user extended 
-- associations exist

prompt Package Header : jr_ues_chk

create or replace package jr_ues_chk is

  -- Called by the following triggers to check for existance of UE instance data
  -- if any exists the delete is BLOCKED.
  --
  -- SDD_ATT_d    SDD_BUN_d    SDD_COL_d     SDD_COM_d     SDD_DAT_d 
  -- SDD_DBU_d    SDD_DFI_d    SDD_DOC_d     SDD_DOM_d     SDD_DST_d 
  -- SDD_E1_d     SDD_E2_d     SDD_E3_d      SDD_E4_d      SDD_E5_d 
  -- SDD_E6_d     SDD_E20_d    SDD_ENT_d     SDD_EXT_d     SDD_FIL_d 
  -- SDD_FILES_d  SDD_FUN_d    SDD_GRP_d     SDD_LAN_d     SDD_MOD_d 
  -- SDD_MUN_d    SDD_OCL_d    SDD_ODB_d     SDD_ORS_d     SDD_ORT_d 
  -- SDD_OSP_d    SDD_OSQ_d    SDD_OTB_d     SDD_PRS_d     SDD_QTD_d 
  -- SDD_QUE_d    SDD_SYN_d    SDD_TAB_d     SDD_UEE_D
  
  function check_ues_blocks_delete (object_ivid number
                                   ,object_irid number
                                   ,object_type number
                                   ,action VARCHAR2
                                   ) return boolean;



  -- Called by trigger SDD_ENT_D to check for existance of UE instance data
  -- if any exists the delete is BLOCKED.
  
  function FK_UES_TO_ATT_cmd (irid number, ivid number) return boolean;

  -- Called by trigger SDD_TAB_D to check for existance of UE instance data
  -- if any exists the delete is BLOCKED.

  function FK_UES_TO_COL_cmd (irid number, ivid number) return boolean;

  -- Called by trigger SDD_ORT_D to check for existance of UE instance data
  -- if any exists the delete is BLOCKED.

  function FK_UES_TO_DAT_cmd (irid number, ivid number) return boolean;

  -- Called by trigger SDD_ODB_D to check for existance of UE instance data
  -- if any exists the delete is BLOCKED.

  function FK_UES_TO_DBU_cmd (irid number, ivid number) return boolean;
  function FK_UES_TO_GRP_cmd (irid number, ivid number) return boolean;
  function FK_UES_TO_ORS_cmd (irid number, ivid number) return boolean;
  function FK_UES_TO_OTB_cmd (irid number, ivid number) return boolean;
  function FK_UES_TO_DFI_cmd (irid number, ivid number) return boolean;

  -- Called by trigger SDD_MOD_D to check for existance of UE instance data
  -- if any exists the delete is BLOCKED.

  function FK_UES_TO_MUN_cmd (irid number, ivid number) return boolean;
  
end jr_ues_chk;
/