APPS.GHR_GROUPBOX_USERS_AD_STM dependencies on GHR_API

Line 21: for i in 1..ghr_api.ghr_gbx_user_index loop

17: and U.EMPLOYEE_ID is not null;
18:
19: begin
20:
21: for i in 1..ghr_api.ghr_gbx_user_index loop
22: for c_emp_rec in c_emp
23: (ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
24: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).user_name)
25: loop

Line 23: (ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id,

19: begin
20:
21: for i in 1..ghr_api.ghr_gbx_user_index loop
22: for c_emp_rec in c_emp
23: (ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
24: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).user_name)
25: loop
26: l_id := c_emp_rec.employee_id;
27: l_name := c_emp_rec.name;

Line 24: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).user_name)

20:
21: for i in 1..ghr_api.ghr_gbx_user_index loop
22: for c_emp_rec in c_emp
23: (ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
24: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).user_name)
25: loop
26: l_id := c_emp_rec.employee_id;
27: l_name := c_emp_rec.name;
28: end loop;

Line 39: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id,

35: (p_user_orig_system => 'PER',
36: p_user_orig_system_id => l_id,
37: p_role_orig_system => 'GBX',
38: p_role_orig_system_id =>
39: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
40: p_expiration_date => trunc(sysdate)
41: );
42:
43: end loop;

Line 44: ghr_api.ghr_gbx_user_index := 0;

40: p_expiration_date => trunc(sysdate)
41: );
42:
43: end loop;
44: ghr_api.ghr_gbx_user_index := 0;
45:
46: end GHR_GROUPBOX_USERS_AD;