MTL_CATEGORIES_B_TA_IBE
/* $Header: INVITCA1.sql 115.1 2003/12/26 03:16:05 wwahid ship $ */
AFTER DELETE
ON MTL_CATEGORIES_B
FOR EACH ROW
Type
AFTER EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
plsql_block VARCHAR2(2000);
BEGIN
IF ( INV_Item_Util.g_Appl_Inst.IBE <> 0 ) THEN
plsql_block :=
' BEGIN '||
' IBE_INV_Database_Trigger_PVT.MTL_Categories_B_Deleted '||
' ( p_old_category_id => :old_category_id '||
' ); '||
' EXCEPTION '||
' WHEN others THEN '||
' NULL; '||
' END;';
EXECUTE IMMEDIATE plsql_block
USING IN :old.category_id ;
END IF; -- IBE installed
EXCEPTION
WHEN others THEN
NULL;
END MTL_CATEGORIES_B_TA_IBE;