rem 
rem $Header: L:\\\\model\\repman40\\api\\RCS\\ciappsac.mps 1.1 1998/05/28 16:03:28 mfrobins Exp $ 
rem 
Rem  Copyright (c) 1994 by Oracle Corporation 
Rem    NAME
Rem      ciappsac.mps - UID check for SAC's, name unique in application sys
Rem    DESCRIPTION
Rem      This is only used for a few Secondary Access Controlled elements (SAC) 
Rem      which need their name to be unique in an application system.
Rem      Currently this is being used for database triggers and foreign key
Rem      constraints. This is complicated by the possibility that the 
Rem      PAC being refered to by the SAC may be shared into more than one
Rem      application system. So the actual code checks whether another SAC 
Rem      has the same name as the SAC being checked in all the application 
Rem      systems that the SAC is shared into.
Rem    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     cvanes     08/01/96 -  Creation 
Rem     aheath     11/09/94 -  Creation 
CREATE OR REPLACE PACKAGE cimappsac IS

  procedure check_ciappsacu1(conid in number);
  function is_appsac_unique(i_irid in number
                           ,my_type out number
                           ,clash_id out number
                           ,clash_type out number
                           ,clash_app out number) return boolean;

END;
/