DBA Data[Home] [Help]

TRIGGER: APPS.RA_TERMS_LINES_DISCOUNTS+

Source

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