TRIGGER: APPS.MTL_CYCLE_COUNT_ENTRIES_T1

Source

Description

mtl_cycle_count_entries_t1
AFTER UPDATE
OF EXPORT_FLAG
ON MTL_CYCLE_COUNT_ENTRIES
FOR EACH ROW

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
BEGIN
  BEGIN
     IF UPDATING AND (:old.export_flag = 1 and :new.export_flag=2) THEN
        UPDATE MTL_CC_ENTRIES_INTERFACE
        SET
           delete_flag = 1
        WHERE
           cycle_count_entry_id = :old.cycle_count_entry_id
           and lock_flag <> 1 ;
         --
         IF SQL%ROWCOUNT  = 0 THEN
              FND_MESSAGE.SET_NAME('INV','INV_CCEOI_IS_LOCKED');
              APP_EXCEPTION.RAISE_EXCEPTION;
         END IF;
     END IF;
  END;
END;