TRIGGER: APPS.CZ_ITEM_MASTERS_T2

Source

Description

CZ_ITEM_MASTERS_T2
  BEFORE UPDATE OR DELETE
 ON CZ_ITEM_MASTERS
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW

Type

BEFORE EACH ROW

Event

UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
IF((DELETING AND NVL(:old.DELETED_FLAG, '0') = '0') OR
   ((NVL(:new.DELETED_FLAG, 0) <> NVL(:old.DELETED_FLAG, 0)) OR
    (NVL(:new.ITEM_TYPE_ID, 0) <> NVL(:old.ITEM_TYPE_ID, 0))))THEN

--This may update more models than necessary. A model needs to be updated only if it uses any of
--the item type's properties as such i.e. uses property's default value through the item type of
--the ps_node_id's item_id. However it is not always possible to establish that (e.g. properties
--applied to an iterator with no ps_node_id until the generation time).

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 deleted_flag = '0'
   AND devl_project_id IN (
    SELECT devl_project_id FROM cz_rules
     WHERE deleted_flag = '0'
       AND disabled_flag = '0'
       AND rule_id IN (
        SELECT rule_id FROM cz_expression_nodes
         WHERE deleted_flag = '0'
           AND expr_type = 207
           AND property_id IN (
            SELECT property_id FROM cz_item_type_properties
             WHERE deleted_flag = '0'
               AND item_type_id = :old.item_type_id
           )
       )
   );
END IF;
END;