TRIGGER: APPS.GHR_GROUPBOX_USERS_AD

Source

Description

GHR_GROUPBOX_USERS_AD
  after DELETE on "HR"."GHR_GROUPBOX_USERS#"
for each row

Type

AFTER EACH ROW

Event

DELETE

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_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_AD;