PACKAGE: APPS.PQH_PQHUSEPR_XMLP_PKG

Source

1 PACKAGE PQH_PQHUSEPR_XMLP_PKG AS
2 /* $Header: PQHUSEPRS.pls 120.1 2007/12/07 06:49:21 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   CP_BUSINESS_GROUP_NAME VARCHAR2(240);
16 
17   CP_TENURED_CNT NUMBER;
18 
19   CP_TENTRACK_CNT NUMBER;
20 
21   CP_TENELIGIBLE_CNT NUMBER;
22 
23   CP_TENDENIED_CNT NUMBER;
24 
25   FUNCTION BEFOREREPORT RETURN BOOLEAN;
26 
27   FUNCTION CF_GETTENURECOUNTFORMULA RETURN NUMBER;
28 
29   FUNCTION AFTERPFORM RETURN BOOLEAN;
30 
31   FUNCTION CF_JOB_NAMEFORMULA(JOB_ID IN NUMBER) RETURN CHAR;
32 
33   FUNCTION CF_ACADEMIC_RANKFORMULA(RANK_ID IN VARCHAR2) RETURN CHAR;
34 
35   FUNCTION CF_TENURE_STATUSFORMULA(TENURE_STATUS_CD IN VARCHAR2
36                                   ,RANK_ID IN VARCHAR2) RETURN CHAR;
37 
38   FUNCTION CF_MANAGER_NAMEFORMULA(MANAGER_ID IN NUMBER) RETURN VARCHAR2;
39 
40   FUNCTION CF_DIRECT_OR_HIERARCHIALFORMUL RETURN CHAR;
41 
42   FUNCTION GETMANAGERNAME(P_MANAGER_ID IN NUMBER) RETURN VARCHAR2;
43 
44   FUNCTION CF_MGR_NAMEFORMULA RETURN CHAR;
45 
46   FUNCTION AFTERREPORT RETURN BOOLEAN;
47 
48   FUNCTION CP_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
49 
50   FUNCTION CP_TENURED_CNT_P RETURN NUMBER;
51 
52   FUNCTION CP_TENTRACK_CNT_P RETURN NUMBER;
53 
54   FUNCTION CP_TENELIGIBLE_CNT_P RETURN NUMBER;
55 
56   FUNCTION CP_TENDENIED_CNT_P RETURN NUMBER;
57 
58   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
59 
60 END PQH_PQHUSEPR_XMLP_PKG;