DBA Data[Home] [Help]

TRIGGER: APPS.PFT_VAL_INDEX_FORMULA_DL

Source

Description
PFT_VAL_INDEX_FORMULA_DL
/* $Header: PFTVALINDEX.sql 120.0 2005/10/19 19:17:58 appldev noship $
*=======================================================================+
|            Copyright (c) 1996-2005  Oracle Corporation                |
|                       Redwood Shores, CA, USA                         |
|                         All rights reserved.                          |
+=======================================================================+
| TRIGGERNAME                                                           |
|     PFT_VAL_INDEX_FORMULA_DL                                          |
|                                                                       |
+======================================================================*/
INSTEAD OF delete ON PFT_VAL_INDEX_FORMULA_VL
referencing old as PFT_VAL_IND
FOR EACH ROW
Type
INSTEAD OF
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS PFT_VAL_IND
Body
BEGIN
  PFT_VAL_INDEX_FORMULA_PKG.DELETE_ROW(
    X_VALUE_INDEX_FORMULA_ID => :PFT_VAL_IND.VALUE_INDEX_FORMULA_ID);
END PFT_VAL_INDEX_FORMULA_DL;