DBA Data[Home] [Help]

TRIGGER: APPS_NE.spConsiderStandbyShif14$xd1858

Source

Description
"APPS_NE"."spConsiderStandbyShif14$xd1858" after delete or update on "APPS_NE"."spConsiderStandbyShif1471_TAB" for each row 
Type
AFTER EACH ROW
Event
UPDATE OR DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN  IF (deleting) THEN xdb.xdb_pitrig_pkg.pitrig_del('APPS_NE','spConsiderStandbyShif1471_TAB', :old.sys_nc_oid$, 'CF79A12DF07860F1E0439315B98B49F3' ); END IF;   IF (updating) THEN xdb.xdb_pitrig_pkg.pitrig_upd('APPS_NE','spConsiderStandbyShif1471_TAB', :old.sys_nc_oid$, 'CF79A12DF07860F1E0439315B98B49F3', user ); END IF; END;