[Home] [Help]
TRIGGER: APPS.GHR_GROUPBOX_USERS_AD
Source
Description
GHR_GROUPBOX_USERS_AD
after DELETE on 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;