[Home] [Help]
PACKAGE BODY: APPS.HRI_OLTP_PTL_PARAM
Source
1 PACKAGE BODY hri_oltp_ptl_param AS
2 /*$Header: hriopprm.pkb 120.1 2005/09/27 07:10:54 cbridge noship $ */
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
12 AND TRUNC(SYSDATE) BETWEEN per.effective_start_date
13 AND per.effective_end_date;
14 EXCEPTION
15 WHEN NO_DATA_FOUND THEN
16 employee_name := NULL;
17 END;
18
19 IF (region_id = 'HRI_P_SALABV_SUP_RCM') THEN
20 RETURN '&'||'HRI_P_SUP_LNAME_CN='||employee_name;
21 ELSIF (region_id = 'HRI_P_ABV_HIRAC_SUP_X') THEN
22 RETURN '&'||'HRI_P_SUP_ID='||employee_name||
23 '&'||'HRI_P_ABV_ID='||'Head Count';
24 ELSIF (region_id = 'HRI_P_ABV_CHG_X') THEN
25 RETURN '&'||'HRI_P_SUP_ID='||employee_name||
26 '&'||'HRI_P_ABV_ID='||'Head Count';
27 ELSIF (region_id = 'HRI_P_ABVTRN_SUPRO_SEPRSN_RPD') THEN
28 RETURN '&'||'HRI_P_SUP_ID='||employee_name||
29 '&'||'HRI_P_ABV_ID='||'Head Count'||
30 '&'||'HRI_P_PDRNG_ID='||'Quarter';
31 ELSIF (region_id = 'HRI_P_ABVTRN_SUPRO_LOW_RPD') THEN
32 RETURN '&'||'HRI_P_SUP_ID='||employee_name||
33 '&'||'HRI_P_ABV_ID='||'Head Count'||
34 '&'||'HRI_P_PDRNG_ID='||'Quarter';
35 ELSIF (region_id = 'HRI_P_ABV_SEP_SUP_RPD') THEN
36 RETURN '&'||'HRI_P_SUP_ID='||employee_name||
37 '&'||'HRI_P_ABV_ID='||'Head Count'||
38 '&'||'PERIOD='||'Quarter';
39 ELSIF (region_id = 'HRI_P_SALABV_NEWHIRE_JB_RPD') THEN
40 RETURN '&'||'HRI_P_SUP_ID='||employee_name||
41 '&'||'HRI_P_PDRNG_ID='||'Quarter';
42 END IF;
43 END get_params;
44
45 FUNCTION get_dbi_params(region_id IN VARCHAR2) RETURN VARCHAR2 IS
46 employee_id NUMBER(10);
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')||
56 '&'||'BIS_MANAGER='||employee_id||
57 '&'||'CURRENCY='||currency||
58 '&'||'SEQUENTIAL=TIME_COMPARISON_TYPE+SEQUENTIAL'||
59 '&'||'TIME+FII_ROLLING_QTR=TIME+FII_ROLLING_QTR' ;
60 --
61 ELSIF (region_id = 'HRI_PMV_ABS_PARAM_PORTLET') THEN
62 RETURN '&'||'AS_OF_DATE='||TO_CHAR(TRUNC(sysdate),'DD-MON-YYYY')||
63 '&'||'BIS_MANAGER='||employee_id||
64 '&'||'CURRENCY='||currency||
65 '&'||'SEQUENTIAL=TIME_COMPARISON_TYPE+SEQUENTIAL'||
66 '&'||'TIME+FII_ROLLING_QTR=TIME+FII_ROLLING_QTR' ;
67 --
68 ELSE
69 RETURN NULL;
70 END IF;
71 END get_dbi_params;
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
81 currency FII_CURRENCIES_V.VALUE%TYPE;
82 BEGIN
83 RETURN 'FII_GLOBAL1';
84 END get_dbi_curr;
85
86 FUNCTION get_dbi_date RETURN VARCHAR2 IS
87 BEGIN
88 RETURN TO_CHAR(TRUNC(sysdate),'DD-MON-YYYY');
89 END get_dbi_date;
90
91 END hri_oltp_ptl_param;