16: and p_USER_NAME = U.USER_NAME
17: and U.EMPLOYEE_ID is not null;
18:
19: begin
20: for i in 1..ghr_api.ghr_gbx_user_index loop
21: for c_emp_rec in c_emp
22: (ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
23: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name)
24: loop
18:
19: begin
20: for i in 1..ghr_api.ghr_gbx_user_index loop
21: for c_emp_rec in c_emp
22: (ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
23: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name)
24: loop
25: l_id := c_emp_rec.employee_id;
26: l_name := c_emp_rec.name;
19: begin
20: for i in 1..ghr_api.ghr_gbx_user_index loop
21: for c_emp_rec in c_emp
22: (ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
23: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name)
24: loop
25: l_id := c_emp_rec.employee_id;
26: l_name := c_emp_rec.name;
27: end loop;
30: (p_user_orig_system => 'PER',
31: p_user_orig_system_id => l_id,
32: p_role_orig_system => 'GBX',
33: p_role_orig_system_id =>
34: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
35: -- Bug 4897157
36: p_overwrite => TRUE
37: -- End 4897157
38: );
36: p_overwrite => TRUE
37: -- End 4897157
38: );
39: end loop;
40: ghr_api.ghr_gbx_user_index := 0;
41:
42: end GHR_GROUPBOX_USERS_AI_STM;