TRIGGER: APPS.PER_QUERY_CRITERIA_OVN

Source

Description

PER_QUERY_CRITERIA_OVN
BEFORE INSERT OR UPDATE ON PER_QUERY_CRITERIA for each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
     if hr_general.g_data_migrator_mode <> 'Y' then
	   if inserting then
		:NEW.object_version_number := 1;
	   else
		:NEW.object_version_number := :OLD.object_version_number + 1;
	   end if;
     end if;
end PER_QUERY_CRITERIA_OVN;