1 PACKAGE PQH_PQHWSPCH_XMLP_PKG AS
2 /* $Header: PQHWSPCHS.pls 120.1 2007/12/07 07:04:05 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_BUSINESS_GROUP_NAME VARCHAR2(240);
30
31 CP_HIERARCHY_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_ID1 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_ORG_PROJECTED_EXPFORMULA(BUDGET_UNIT_ID IN NUMBER
65 ,CF_ORG_ACTUAL_AMT IN NUMBER
66 ,CF_ORG_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
67
68 FUNCTION CF_ORG_DEF_EX_AMTFORMULA(CF_ORG_BUDGETED_AMT IN NUMBER
69 ,CF_ORG_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
70
71 FUNCTION CF_ORG_ACT_PERFORMULA(CF_ORG_BUDGETED_AMT IN NUMBER
72 ,CF_ORG_ACTUAL_AMT IN NUMBER) RETURN NUMBER;
73
74 FUNCTION CF_ORG_COM_PERFORMULA(CF_ORG_BUDGETED_AMT IN NUMBER
75 ,CF_ORG_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
76
77 FUNCTION CF_ORG_PROJ_PERFORMULA(CF_ORG_BUDGETED_AMT IN NUMBER
78 ,CF_ORG_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
79
80 FUNCTION CF_ORG_DEF_EX_PERFORMULA(CF_ORG_BUDGETED_AMT IN NUMBER
81 ,CF_ORG_DEF_EX_AMT IN NUMBER) RETURN NUMBER;
82
83 FUNCTION CF_ORG_BUDGETED_AMTFORMULA(ORGANIZATION_ID1 IN NUMBER
84 ,BUDGET_UNIT_ID IN NUMBER) RETURN NUMBER;
85
86 FUNCTION CF_ORG_ACTUAL_AMTFORMULA(ORGANIZATION_ID1 IN NUMBER
87 ,BUDGET_UNIT_ID IN NUMBER) RETURN NUMBER;
88
89 FUNCTION CF_ORG_COMMITTED_AMTFORMULA(ORGANIZATION_ID1 IN NUMBER
90 ,BUDGET_UNIT_ID IN NUMBER) RETURN NUMBER;
91
92 FUNCTION CF_BGRP_BUDGETED_AMTFORMULA(BGRP_BUDGET_UNIT_ID IN NUMBER
93 ,BGRP_ACTUAL_AMT IN NUMBER
94 ,BGRP_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
95
96 FUNCTION CF_BGRP_DEF_EX_AMTFORMULA(BGRP_BUDGETED_AMT IN NUMBER
97 ,CF_BGRP_PROJECTED_AMT IN NUMBER) RETURN NUMBER;
98
99 FUNCTION CF_BGRP_COM_PERFORMULA(BGRP_BUDGETED_AMT IN NUMBER
100 ,BGRP_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
101
102 FUNCTION CF_BGRP_PROJ_PERFORMULA(BGRP_BUDGETED_AMT IN NUMBER
103 ,CF_BGRP_PROJECTED_AMT IN NUMBER) RETURN NUMBER;
104
105 FUNCTION CF_BGRP_DEF_EX_PERFORMULA(BGRP_BUDGETED_AMT IN NUMBER
106 ,CF_BGRP_DEF_EX_AMT IN NUMBER) RETURN NUMBER;
107
108 FUNCTION CF_BGRP_ACTUAL_PERFORMULA(BGRP_BUDGETED_AMT IN NUMBER
109 ,BGRP_ACTUAL_AMT IN NUMBER) RETURN NUMBER;
110
111 FUNCTION CF_FORMAT_MASK2(BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
112
113 FUNCTION CF_FORMAT_MASK1(BUDGET_UNIT_ID1 IN NUMBER) RETURN CHAR;
114
115 FUNCTION CF_FORMAT_MASK3(BGRP_BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
116
117 FUNCTION AFTERREPORT RETURN BOOLEAN;
118
119 FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
120
121 FUNCTION CP_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
122
123 FUNCTION CP_HIERARCHY_NAME_P RETURN VARCHAR2;
124
125 FUNCTION CP_POSITION_TYPE_P RETURN VARCHAR2;
126
127 FUNCTION CP_CURRENCY_P RETURN VARCHAR2;
128
129 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
130
131 FUNCTION CP_SESSION_DT_P RETURN DATE;
132
133 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
134
135 END PQH_PQHWSPCH_XMLP_PKG;