TRIGGER: APPS.PER_ABV_OVN

Source

Description

"APPS"."PER_ABV_OVN" 
before insert or update
 ON  "HR"."PER_ASSIGNMENT_BUDGET_VALUES_#"  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 not per_abv_shd.return_api_dml_status then
    if inserting then
      begin
        :NEW.object_version_number :=
          dt_api.Get_Object_Version_Number
           (p_base_table_name => 'PER_ASSIGNMENT_BUDGET_VALUES_F',
            P_BASE_KEY_COLUMN => 'ASSIGNMENT_BUDGET_VALUE_ID',
            P_BASE_KEY_VALUE  => :NEW.assignment_budget_Value_id);
      exception
        when others then
          if (sqlcode = -4091) then
            :NEW.object_version_number := 1;
          else
            raise;
          end if;
      end;
    else
      :NEW.object_version_number := :OLD.object_version_number + 1;
    end if;
  end if;
 end if;
end per_abv_ovn;