1 PACKAGE PQH_PQHWSEES_XMLP_PKG AS
2 /* $Header: PQHWSEESS.pls 120.1 2007/12/07 07:00:24 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_ELEMENT_TYPE_ID NUMBER;
16
17 P_POSITION_TYPE VARCHAR2(40);
18
19 P_VARIANCE_PERCENT NUMBER;
20
21 P_CURRENCY_CODE VARCHAR2(15);
22
23 P_EFFECTIVE_DATE DATE;
24
25 P_BUDGETED_ENTITY_CD VARCHAR2(40);
26
27 P_ENTITY_TYPE VARCHAR2(40);
28
29 C_REPORT_SUBTITLE VARCHAR2(60);
30
31 CP_ELEMENT_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_ENTITY_NAME VARCHAR2(80);
40
41 CP_SESSION_DT DATE;
42
43 FUNCTION BEFOREREPORT RETURN BOOLEAN;
44
45 FUNCTION CF_1FORMULA(BUDGET_UNIT_ID IN NUMBER
46 ,ACTUAL_AMT IN NUMBER
47 ,COMMITTED_AMT IN NUMBER) RETURN NUMBER;
48
49 FUNCTION CF_DEF_EX_AMTFORMULA(BUDGETED_AMT IN NUMBER
50 ,CF_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
51
52 FUNCTION BEFOREPFORM RETURN BOOLEAN;
53
54 FUNCTION CF_ACT_PERFORMULA(BUDGETED_AMT IN NUMBER
55 ,ACTUAL_AMT IN NUMBER) RETURN NUMBER;
56
57 FUNCTION CF_COM_PERFORMULA(BUDGETED_AMT IN NUMBER
58 ,COMMITTED_AMT IN NUMBER) RETURN NUMBER;
59
60 FUNCTION CF_PROJ_PERFORMULA(BUDGETED_AMT IN NUMBER
61 ,CF_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
62
63 FUNCTION CF_DEF_EX_PERFORMULA(BUDGETED_AMT IN NUMBER
64 ,CF_DEF_EX_AMT IN NUMBER) RETURN NUMBER;
65
66 FUNCTION CF_ELM_ACTUAL_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
67 ,SUM_ACTUAL_AMT IN NUMBER) RETURN NUMBER;
68
69 FUNCTION CF_ELM_COMMIT_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
70 ,SUM_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
71
72 FUNCTION CF_ELM_PROJECTED_EXPFORMULA(ELM_BUDGET_UNIT_ID IN NUMBER
73 ,SUM_ACTUAL_AMT IN NUMBER
74 ,SUM_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
75
76 FUNCTION CF_ELM_PROJ_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
77 ,CF_ELM_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
78
79 FUNCTION CF_ELM_DEF_EX_AMTFORMULA(SUM_BUDGETED_AMT IN NUMBER
80 ,CF_ELM_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
81
82 FUNCTION CF_ELM_DEF_EX_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
83 ,CF_ELM_DEF_EX_AMT IN NUMBER) RETURN NUMBER;
84
85 FUNCTION CF_FORMAT_MASK2(ELM_BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
86
87 FUNCTION CF_FORMAT_MASK1(BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
88
89 FUNCTION AFTERREPORT RETURN BOOLEAN;
90
91 FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
92
93 FUNCTION CP_ELEMENT_NAME_P RETURN VARCHAR2;
94
95 FUNCTION CP_POSITION_TYPE_P RETURN VARCHAR2;
96
97 FUNCTION CP_CURRENCY_P RETURN VARCHAR2;
98
99 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
100
101 FUNCTION CP_ENTITY_NAME_P RETURN VARCHAR2;
102
103 FUNCTION CP_SESSION_DT_P RETURN DATE;
104
105 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
106
107 END PQH_PQHWSEES_XMLP_PKG;