APPS.GHR_GROUPBOX_USERS_AU_STM dependencies on GHR_API

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

22: and p_USER_NAME = U.USER_NAME
23: and U.EMPLOYEE_ID is not null;
24:
25: begin
26: for i in 1..ghr_api.ghr_gbx_user_index loop
27: for c_old_emp_rec in c_old_emp(
28: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).user_name
29: ) loop
30: l_oldID := c_old_emp_rec.employee_id;

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

24:
25: begin
26: for i in 1..ghr_api.ghr_gbx_user_index loop
27: for c_old_emp_rec in c_old_emp(
28: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).user_name
29: ) loop
30: l_oldID := c_old_emp_rec.employee_id;
31: end loop;
32:

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

30: l_oldID := c_old_emp_rec.employee_id;
31: end loop;
32:
33: for c_emp_rec in c_emp
34: (ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
35: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name)
36: loop
37: l_id := c_emp_rec.employee_id;
38: l_name := c_emp_rec.name;

Line 35: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name)

31: end loop;
32:
33: for c_emp_rec in c_emp
34: (ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
35: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).user_name)
36: loop
37: l_id := c_emp_rec.employee_id;
38: l_name := c_emp_rec.name;
39: end loop;

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

45: (p_user_orig_system => 'PER',
46: p_user_orig_system_id => l_oldID,
47: p_role_orig_system => 'GBX',
48: p_role_orig_system_id =>
49: ghr_api.ghr_gbx_user_old_tab(ghr_api.ghr_gbx_user_index).groupbox_id,
50: p_expiration_date => trunc(sysdate)
51: );
52:
53: l_parms := null;

Line 59: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id

55: (p_user_orig_system => 'PER',
56: p_user_orig_system_id => l_id,
57: p_role_orig_system => 'GBX',
58: p_role_orig_system_id =>
59: ghr_api.ghr_gbx_user_new_tab(ghr_api.ghr_gbx_user_index).groupbox_id
60: );
61:
62: end loop;
63:

Line 64: ghr_api.ghr_gbx_user_index := 0;

60: );
61:
62: end loop;
63:
64: ghr_api.ghr_gbx_user_index := 0;
65:
66: end GHR_GROUPBOX_USERS_AU_STM;