TRIGGER: APPS.JTF_AUTH_PRINCIPAL_MAPS_T3

Source

Description

JTF_AUTH_PRINCIPAL_MAPS_T3
AFTER DELETE ON JTF.JTF_AUTH_PRINCIPAL_MAPS
FOR EACH ROW

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
  DELETE FROM JTF_AUTH_MAPS_SOURCES
  WHERE JTF_AUTH_MAPS_SOURCES.JTF_AUTH_PRINCIPAL_MAPPING_ID = :old.JTF_AUTH_PRINCIPAL_MAPPING_ID;
EXCEPTION
  WHEN NO_DATA_FOUND THEN NULL;
END ;