TRIGGER: APPS.GHR_GROUPBOX_USERS_AI_STM

Source

Description

GHR_GROUPBOX_USERS_AI_STM  after INSERT
  on "HR"."GHR_GROUPBOX_USERS#"

Type

AFTER STATEMENT

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
l_ID     FND_USER.EMPLOYEE_ID%TYPE;
l_name   GHR_GROUPBOXES.NAME%TYPE;
l_parms  wf_parameter_list_t;

Cursor c_emp(p_groupbox_id in number,
             p_user_name   in varchar2) is
   select
       U.EMPLOYEE_ID,
       GBX.NAME
   from   GHR_GROUPBOXES GBX,
          FND_USER U
   where  p_GROUPBOX_ID   = GBX.GROUPBOX_ID
   and    p_USER_NAME     = U.USER_NAME
   and    U.EMPLOYEE_ID is not null;

begin
for i in 1..ghr_api.ghr_gbx_user_index loop
  for c_emp_rec in c_emp
    (ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
     ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name)
 loop
    l_id   := c_emp_rec.employee_id;
    l_name := c_emp_rec.name;
  end loop;

   wf_local_synch.propagate_user_role
       (p_user_orig_system      => 'PER',
        p_user_orig_system_id   => l_id,
        p_role_orig_system      => 'GBX',
        p_role_orig_system_id   =>
          ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
		-- Bug 	4897157
		  p_overwrite => TRUE
		-- End 	4897157
       );
end loop;
ghr_api.ghr_gbx_user_index := 0;

end GHR_GROUPBOX_USERS_AI_STM;