DBA Data[Home] [Help]

APPS.HRI_OLTP_PTL_PARAM dependencies on HRI_BPL_SECURITY

Line 7: employee_id := hri_bpl_security.get_apps_signin_person_id;

3: FUNCTION get_params(region_id IN VARCHAR2) RETURN VARCHAR2 IS
4: employee_id NUMBER(10);
5: employee_name VARCHAR2(240);
6: BEGIN
7: employee_id := hri_bpl_security.get_apps_signin_person_id;
8: BEGIN
9: SELECT per.full_name INTO employee_name
10: FROM per_all_people_f per
11: WHERE per.person_id = employee_id

Line 51: employee_id := NVL(hri_bpl_security.get_apps_signin_person_id,-1);

47: employee_name VARCHAR2(240);
48: currency FII_CURRENCIES_V.VALUE%TYPE;
49: BEGIN
50: -- bug 3886182, wrapped in an NVL(, -1)
51: employee_id := NVL(hri_bpl_security.get_apps_signin_person_id,-1);
52: currency:='FII_GLOBAL1';
53:
54: IF (region_id = 'HRI_PMV_MGR_PARAM_PORTLET') THEN
55: RETURN '&'||'AS_OF_DATE='||TO_CHAR(TRUNC(sysdate),'DD-MON-YYYY')||

Line 76: return NVL(hri_bpl_security.get_apps_signin_person_id,-1);

72:
73: FUNCTION get_dbi_mgr_id RETURN VARCHAR2 IS
74: BEGIN
75: -- bug 3886182, wrapped in an NVL(, -1)
76: return NVL(hri_bpl_security.get_apps_signin_person_id,-1);
77: END get_dbi_mgr_id;
78:
79:
80: FUNCTION get_dbi_curr RETURN VARCHAR2 IS