[Home] [Help]
TRIGGER: APPS.MSC_APPS_INSTANCES_T1
Source
Description
MSC_APPS_INSTANCES_T1
BEFORE INSERT
ON MSC_APPS_INSTANCES
FOR EACH ROW
Type
BEFORE EACH ROW
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
lv_sql_stmt VARCHAR2(500);
BEGIN
IF :new.instance_type <> 3 THEN
lv_sql_stmt := 'BEGIN MSC_CL_EXCHANGE_PARTTBL.create_st_partition (:instance_id); END;';
ELSE
lv_sql_stmt := 'BEGIN MSC_CL_EXCHANGE_PARTTBL.modify_st_partition_add (:instance_id); END;';
END IF;
EXECUTE IMMEDIATE lv_sql_stmt USING :new.instance_id;
END;