TRIGGER: APPS.GHR_GROUPBOXES_AU

Source

Description

GHR_GROUPBOXES_AU
after update on "HR"."GHR_GROUPBOXES#"
for each row

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
   ghr_api.ghr_gbx_index := ghr_api.ghr_gbx_index + 1;
   ghr_api.ghr_gbx_tab(ghr_api.ghr_gbx_index).groupbox_id
              := :new.groupbox_id;
  ghr_api.ghr_gbx_tab(ghr_api.ghr_gbx_index).name := :new.name;
  ghr_api.ghr_gbx_tab(ghr_api.ghr_gbx_index).display_name := :new.display_name;
  ghr_api.ghr_gbx_tab(ghr_api.ghr_gbx_index).description :=  :new.description;

  -- BUG # 14479249 added old details
  ghr_api.ghr_gbx_old_tab(ghr_api.ghr_gbx_index).name := :old.name;
  ghr_api.ghr_gbx_old_tab(ghr_api.ghr_gbx_index).display_name := :old.display_name;
  ghr_api.ghr_gbx_old_tab(ghr_api.ghr_gbx_index).description :=  :old.description;
end GHR_GROUPBOXES_AU;