SSOQ
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IDM_STAGING.AUXILIARY_ACTIONS
Parameters
Name
Type
Mode
Definition
PACKAGE BODY AUXILIARY_ACTIONS AS PROCEDURE DELETE_AUXILIARY_ACTIONS ( ACTION IN VARCHAR2 , AO_ID IN VARCHAR2 ) AS BEGIN IF (ACTION = 'DELETE' ) THEN -- Delete all actions except update -- DELETE FROM IDM_STAGING.AUXILIARY_ACTION WHERE action_object_id=AO_ID and action in ('ENABLE','DISABLE','ADD'); ELSE DELETE FROM IDM_STAGING.AUXILIARY_ACTION WHERE action_object_id=AO_ID ; END IF; END DELETE_AUXILIARY_ACTIONS; END AUXILIARY_ACTIONS;