DBA Data[Home] [Help]

APPS.GHR_GROUPBOX_USERS_AI_STM dependencies on GHR_API

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

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

Line 22: (ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,

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;

Line 23: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_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;

Line 34: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,

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: );

Line 40: ghr_api.ghr_gbx_user_index := 0;

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;