CZ_DEVL_PROJECTS_T2
BEFORE DELETE
ON CZ_DEVL_PROJECTS
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
Type
BEFORE EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
DELETE FROM CZ_RP_ENTRIES
WHERE OBJECT_TYPE = 'PRJ' AND OBJECT_ID = :OLD.DEVL_PROJECT_ID;
DELETE FROM CZ_PERSISTENT_REC_IDS
WHERE devl_project_id = :OLD.DEVL_PROJECT_ID;
--Re: bug #2131259.
DELETE FROM CZ_XFR_PROJECT_BILLS
WHERE MODEL_PS_NODE_ID = :OLD.DEVL_PROJECT_ID;
END;