"APPS"."XDP_FE_ATTRIBUTE_DEF_TL+" before insert or update or delete on "XDP"."XDP_FE_ATTRIBUTE_DEF_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 != 'ORA$BASE' then raise_application_error(-20002,'Seed Data Table has not been prepared for patching'); end if; if INSERTING then :new.zd_edition_name := 'ORA$BASE'; end if; end;