PACKAGE: APPS.PQH_PQHWSEES_XMLP_PKG

Source

1 PACKAGE PQH_PQHWSEES_XMLP_PKG AUTHID CURRENT_USER 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;