PACKAGE: APPS.PQH_PQHWSPBD_XMLP_PKG

Source

1 PACKAGE PQH_PQHWSPBD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PQHWSPBDS.pls 120.1 2007/12/07 07:02:54 vjaganat noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_SESSION_DATE DATE;
6 
7   P_REPORT_TITLE VARCHAR2(80);
8 
9   P_CONC_REQUEST_ID NUMBER;
10 
11   P_START_DATE DATE;
12 
13   P_END_DATE DATE;
14 
15   P_POSITION_ID NUMBER;
16 
17   P_ORGANIZATION_ID NUMBER;
18 
19   P_POSITION_TYPE VARCHAR2(40);
20 
21   P_VARIANCE_PERCENT NUMBER;
22 
23   P_CURRENCY_CODE VARCHAR2(32767);
24 
25   P_EFFECTIVE_DATE DATE;
26 
27   C_REPORT_SUBTITLE VARCHAR2(60);
28 
29   CP_ORGANIZATION_NAME VARCHAR2(240);
30 
31   CP_POSITION_NAME VARCHAR2(240);
32 
33   CP_POSITION_TYPE VARCHAR2(80);
34 
35   CP_CURRENCY VARCHAR2(80);
36 
37   C_BUSINESS_GROUP_NAME VARCHAR2(240);
38 
39   CP_SESSION_DT DATE;
40 
41   FUNCTION BEFOREREPORT RETURN BOOLEAN;
42 
43   FUNCTION CF_1FORMULA(BUDGET_UNIT_ID IN NUMBER
44                       ,ACTUAL_AMT IN NUMBER
45                       ,COMMITTED_AMT IN NUMBER) RETURN NUMBER;
46 
47   FUNCTION CF_DEF_EX_AMTFORMULA(BUDGETED_AMT IN NUMBER
48                                ,CF_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
49 
50   FUNCTION BEFOREPFORM RETURN BOOLEAN;
51 
52   FUNCTION CF_ACT_PERFORMULA(BUDGETED_AMT IN NUMBER
53                             ,ACTUAL_AMT IN NUMBER) RETURN NUMBER;
54 
55   FUNCTION CF_COM_PERFORMULA(BUDGETED_AMT IN NUMBER
56                             ,COMMITTED_AMT IN NUMBER) RETURN NUMBER;
57 
58   FUNCTION CF_PROJ_PERFORMULA(BUDGETED_AMT IN NUMBER
59                              ,CF_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
60 
61   FUNCTION CF_DEF_EX_PERFORMULA(BUDGETED_AMT IN NUMBER
62                                ,CF_DEF_EX_AMT IN NUMBER) RETURN NUMBER;
63 
64   FUNCTION CF_FORMAT_MASK(BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
65 
66   FUNCTION AFTERREPORT RETURN BOOLEAN;
67 
68   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
69 
70   FUNCTION CP_ORGANIZATION_NAME_P RETURN VARCHAR2;
71 
72   FUNCTION CP_POSITION_NAME_P RETURN VARCHAR2;
73 
74   FUNCTION CP_POSITION_TYPE_P RETURN VARCHAR2;
75 
76   FUNCTION CP_CURRENCY_P RETURN VARCHAR2;
77 
78   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
79 
80   FUNCTION CP_SESSION_DT_P RETURN DATE;
81 
82   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
83 
84 END PQH_PQHWSPBD_XMLP_PKG;