TRIGGER: APPS.GHR_GROUPBOX_USERS_AU

Source

Description

GHR_GROUPBOX_USERS_AU
  after UPDATE of USER_NAME on "HR"."GHR_GROUPBOX_USERS#"
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_user_index := ghr_api.ghr_gbx_user_index + 1;
   ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id
              := :new.groupbox_id;
   ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name :=
              :new.user_name;
   ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id
              := :old.groupbox_id;
   ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).user_name := :old.user_name;


end GHR_GROUPBOX_USERS_AU;