TRIGGER: APPS.CZ_DES_CHART_CELLS_T2

Source

Description

CZ_DES_CHART_CELLS_T2
  BEFORE UPDATE OR INSERT  OR DELETE
 ON CZ_DES_CHART_CELLS
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
IF INSERTING THEN
   UPDATE cz_devl_projects
   SET    last_logic_update = sysdate,
          post_migr_change_flag = DECODE(post_migr_change_flag, 'N', 'R', 'Z', 'R', post_migr_change_flag)
   WHERE  devl_project_id IN (SELECT model_id
			   FROM   cz_model_ref_expls
			   WHERE  model_ref_expl_id = :NEW.SECONDARY_FEAT_EXPL_ID
			   AND    deleted_flag = '0');
END IF;
IF UPDATING THEN
   UPDATE cz_devl_projects
   SET    last_logic_update = sysdate,
          post_migr_change_flag = DECODE(post_migr_change_flag, 'N', 'R', 'Z', 'R', post_migr_change_flag)
   WHERE  devl_project_id IN (SELECT model_id
			   FROM   cz_model_ref_expls
			   WHERE  model_ref_expl_id = :OLD.SECONDARY_FEAT_EXPL_ID
			   AND    deleted_flag = '0');
END IF;
IF DELETING THEN
   UPDATE CZ_RULES
   SET   CZ_RULES.LAST_UPDATE_DATE = SYSDATE
   WHERE CZ_RULES.RULE_ID = :OLD.RULE_ID;
END IF;
END;