DBA Data[Home] [Help]

TRIGGER: APPS.XDO_DS_DEFINITIONS_TL+

Source

Description
"APPS"."XDO_DS_DEFINITIONS_TL+" before insert or update or delete on "XDO"."XDO_DS_DEFINITIONS_TL#" for each row  
Type
BEFORE EACH ROW
Event
INSERT OR UPDATE OR DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
declare   l_current varchar2(30) := sys_context('userenv', 'current_edition_name');   l_default varchar2(30); begin    select property_value into l_default   from   database_properties where  property_name = 'DEFAULT_EDITION';   if l_current > l_default and l_current != 'V_20130813_1018' then     raise_application_error(-20002,'Seed Data Table has not been prepared for patching');   end if;   if INSERTING then      :new.zd_edition_name := 'V_20130813_1018';   end if; end;