DBA Data[Home] [Help]

APPS.HRI_BPL_SECURITY dependencies on FND_GLOBAL

Line 15: otherwise returns fnd_global.employee_id */

11: END get_named_user_profile_value;
12:
13: /* wrapper function, checks the value for the new CHO
14: profile option and returns that if its set
15: otherwise returns fnd_global.employee_id */
16: FUNCTION get_apps_signin_person_id RETURN NUMBER IS
17:
18: CURSOR check_cho_resp IS
19: SELECT 1

Line 23: AND fnd_global.resp_id = responsibility_id;

19: SELECT 1
20: FROM fnd_responsibility
21: WHERE application_id = 453
22: AND responsibility_key = 'HRI_DBI_CHIEF_HR_OFFICER'
23: AND fnd_global.resp_id = responsibility_id;
24:
25: l_cho_resp_ind NUMBER :=0;
26: l_person_id NUMBER := fnd_global.employee_id;
27:

Line 26: l_person_id NUMBER := fnd_global.employee_id;

22: AND responsibility_key = 'HRI_DBI_CHIEF_HR_OFFICER'
23: AND fnd_global.resp_id = responsibility_id;
24:
25: l_cho_resp_ind NUMBER :=0;
26: l_person_id NUMBER := fnd_global.employee_id;
27:
28: BEGIN
29:
30: OPEN check_cho_resp;

Line 36: l_person_id := NVL(get_named_user_profile_value,fnd_global.employee_id);

32: CLOSE check_cho_resp;
33:
34: IF l_cho_resp_ind = 1 THEN
35: -- return the CHO named user profile option person_id
36: l_person_id := NVL(get_named_user_profile_value,fnd_global.employee_id);
37: ELSE
38: l_person_id := fnd_global.employee_id;
39: END IF;
40:

Line 38: l_person_id := fnd_global.employee_id;

34: IF l_cho_resp_ind = 1 THEN
35: -- return the CHO named user profile option person_id
36: l_person_id := NVL(get_named_user_profile_value,fnd_global.employee_id);
37: ELSE
38: l_person_id := fnd_global.employee_id;
39: END IF;
40:
41: RETURN l_person_id;
42:

Line 256: l_mgr_id := get_mgr_id(fnd_global.employee_id, fnd_global.resp_id, fnd_global.resp_appl_id);

252: l_mgr_id NUMBER(15);
253: --
254: BEGIN
255: --
256: l_mgr_id := get_mgr_id(fnd_global.employee_id, fnd_global.resp_id, fnd_global.resp_appl_id);
257: --
258: RETURN(l_mgr_id);
259: --
260: END get_mgr_id;

Line 271: l_org_id := get_org_id(fnd_global.employee_id, fnd_global.resp_id, fnd_global.resp_appl_id);

267: l_org_id NUMBER(15);
268: --
269: BEGIN
270: --
271: l_org_id := get_org_id(fnd_global.employee_id, fnd_global.resp_id, fnd_global.resp_appl_id);
272: --
273: RETURN(l_org_id);
274: --
275: END get_org_id;