"APPS"."FND_FLEX_VALUES+" before insert or update or delete on "APPLSYS"."FND_FLEX_VALUES#" 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;