TRIGGER: APPS.GHR_GROUPBOXES_AD_STM

Source

Description

GHR_GROUPBOXES_AD_STM
  after DELETE on "HR"."GHR_GROUPBOXES#"

Type

AFTER STATEMENT

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
  l_parms   wf_parameter_list_t;
begin
-- construct attribute list --
for i in 1..ghr_api.ghr_gbx_index loop
  wf_event.AddParameterToList('DELETE','TRUE', l_parms);

    wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
    wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);

  -- added to synchronize the wf_local_roles table
  wf_local_synch.propagate_role
   (p_orig_system      => 'GBX',
    p_orig_system_id   => ghr_api.ghr_gbx_tab(i).groupbox_id,
    p_attributes       => l_parms,
    p_expiration_date  => sysdate
   );
end loop;
ghr_api.ghr_gbx_index := 0;

end  GHR_GROUPBOXES_AD_STM;