TRIGGER: APPS.MSC_APPS_INSTANCES_T1

Source

Description

"APPS"."MSC_APPS_INSTANCES_T1" 
BEFORE INSERT
 ON  "MSC"."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;