The following lines contain the word 'select', 'insert', 'update' or 'delete':
organizations to be deleted from the database. It is used
primarily by the Define Organization form (PERORDOR).
Change List
-----------
Version Date Author ER/CR No. Description of Change
-------+---------+----------+---------+--------------------------
70.0 10-JUN-93 TMathers Date Created.
05/27/96 gkokts Moved to admin/sql from invpeorg.pkh
Also, commented out show errors.
*/
--
PROCEDURE inv_predel_validation (p_organization_id IN number) is
--
-- Parameters
-- p_organization_id : UID of organization being deleted.
--
-- Local Variable
v_dummy varchar2(1);
select 1
into v_dummy
from sys.dual
where exists(select 'exists'
from mtl_parameters mp
where mp.organization_id = p_organization_id);