PACKAGE: APPS.PQH_PQHUSRCP_XMLP_PKG

Source

1 PACKAGE PQH_PQHUSRCP_XMLP_PKG AS
2 /* $Header: PQHUSRCPS.pls 120.2 2007/12/07 06:58:01 vjaganat noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_LEVEL NUMBER;
8 
9   P_SUPERVISOR_ID NUMBER;
10 
11   P_AND_CLAUSE VARCHAR2(2000) := 'WHERE level =1';
12 
13   P_DIRECT_OR_ALL VARCHAR2(1);
14 
15   P_START_DATE DATE;
16 
17   P_END_DATE DATE;
18 
19   CP_TENUREDMGR_CNT NUMBER;
20 
21   CP_TENELIGIBLEMGR_CNT NUMBER;
22 
23   CP_TENUREDENIED_CNT NUMBER;
24 
25   CP_BUSINESS_GROUP_NAME VARCHAR2(240);
26 
27   CP_TENURED_CNT NUMBER;
28 
29   CP_TENELIGIBLE_CNT NUMBER;
30 
31   CP_TENDENIED_CNT NUMBER;
32 
33   CP_TENURED_FOR_PERIOD NUMBER;
34 
35   CP_TENURE_ELIGIBLE_FOR_PERIOD NUMBER;
36 
37   CP_TENURE_DENIED_FOR_PERIOD NUMBER;
38 
39   CP_TENUREDPERIOD_CNT NUMBER;
40 
41   CP_TENELIGIBLEPERIOD_CNT NUMBER;
42 
43   CP_TENDENIEDPERIOD_CNT NUMBER;
44 
45   FUNCTION BEFOREREPORT RETURN BOOLEAN;
46 
47   FUNCTION CF_GETTENURECOUNTFORMULA RETURN NUMBER;
48 
49   FUNCTION AFTERPFORM RETURN BOOLEAN;
50 
51   FUNCTION CF_JOB_NAMEFORMULA(JOB_ID IN NUMBER) RETURN CHAR;
52 
53   FUNCTION CF_ACADEMIC_RANKFORMULA(RANK_ID IN VARCHAR2) RETURN CHAR;
54 
55   FUNCTION CF_TENURE_STATUSFORMULA(TENURE_STATUS_CD IN VARCHAR2
56                                   ,RANK_ID IN VARCHAR2) RETURN CHAR;
57 
58   FUNCTION CF_MANAGER_NAMEFORMULA(MANAGER_ID IN NUMBER) RETURN VARCHAR2;
59 
60   FUNCTION CF_DIRECT_OR_HIERARCHIALFORMUL RETURN CHAR;
61 
62   FUNCTION GETMANAGERNAME(P_MANAGER_ID IN NUMBER) RETURN VARCHAR2;
63 
64   FUNCTION CF_MGR_NAMEFORMULA RETURN CHAR;
65 
66   FUNCTION CF_SET_TOTAL_FOR_PERIODFORMULA(TENURE_STATUS_CD IN VARCHAR2
67                                          ,CS_STATUS_HEADCOUNT IN NUMBER) RETURN NUMBER;
68 
69   FUNCTION CF_GETTENURECNTFORMULA(MANAGER_ID IN NUMBER) RETURN NUMBER;
70 
71   FUNCTION AFTERREPORT RETURN BOOLEAN;
72 
73   FUNCTION CP_TENUREDMGR_CNT_P RETURN NUMBER;
74 
75   FUNCTION CP_TENELIGIBLEMGR_CNT_P RETURN NUMBER;
76 
77   FUNCTION CP_TENUREDENIED_CNT_P RETURN NUMBER;
78 
79   FUNCTION CP_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
80 
81   FUNCTION CP_TENURED_CNT_P RETURN NUMBER;
82 
83   FUNCTION CP_TENELIGIBLE_CNT_P RETURN NUMBER;
84 
85   FUNCTION CP_TENDENIED_CNT_P RETURN NUMBER;
86 
87   FUNCTION CP_TENURED_FOR_PERIOD_P RETURN NUMBER;
88 
89   FUNCTION CP_TENURE_DENIED_FOR_PERIOD_P RETURN NUMBER;
90 
91   FUNCTION CP_TENUREDPERIOD_CNT_P RETURN NUMBER;
92 
93   FUNCTION CP_TENELIGIBLEPERIOD_CNT_P RETURN NUMBER;
94 
95   FUNCTION CP_TENDENIEDPERIOD_CNT_P RETURN NUMBER;
96 
97   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
98 
99 END PQH_PQHUSRCP_XMLP_PKG;