DBA Data[Home] [Help]

PACKAGE: APPS.PQH_PQHWSEPS_XMLP_PKG

Source


1 PACKAGE PQH_PQHWSEPS_XMLP_PKG AS
2 /* $Header: PQHWSEPSS.pls 120.3 2007/12/21 17:29:56 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   LP_START_DATE varchar2(20);
12 
13   LP_END_DATE varchar2(20);
14 
15   P_START_DATE DATE;
16 
17   P_END_DATE DATE;
18 
19   P_ELEMENT_TYPE_ID NUMBER;
20 
21   P_POSITION_TYPE VARCHAR2(40);
22 
23   P_VARIANCE_PERCENT NUMBER;
24 
25   P_CURRENCY_CODE VARCHAR2(15);
26 
27   P_EFFECTIVE_DATE DATE;
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_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_ELM_ACTUAL_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
65                                    ,SUM_ACTUAL_AMT IN NUMBER) RETURN NUMBER;
66 
67   FUNCTION CF_ELM_COMMIT_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
68                                    ,SUM_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
69 
70   FUNCTION CF_ELM_PROJECTED_EXPFORMULA(ELM_BUDGET_UNIT_ID IN NUMBER
71                                       ,SUM_ACTUAL_AMT IN NUMBER
72                                       ,SUM_COMMITTED_AMT IN NUMBER) RETURN NUMBER;
73 
74   FUNCTION CF_ELM_PROJ_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
75                                  ,CF_ELM_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
76 
77   FUNCTION CF_ELM_DEF_EX_AMTFORMULA(SUM_BUDGETED_AMT IN NUMBER
78                                    ,CF_ELM_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
79 
80   FUNCTION CF_ELM_DEF_EX_PERFORMULA(SUM_BUDGETED_AMT IN NUMBER
81                                    ,CF_ELM_DEF_EX_AMT IN NUMBER) RETURN NUMBER;
82 
83   FUNCTION CF_FORMAT_MASK2(ELM_BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
84 
85   FUNCTION CF_FORMAT_MASK1(BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
86 
87   FUNCTION AFTERREPORT RETURN BOOLEAN;
88 
89   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
90 
91   FUNCTION CP_ELEMENT_NAME_P RETURN VARCHAR2;
92 
93   FUNCTION CP_POSITION_TYPE_P RETURN VARCHAR2;
94 
95   FUNCTION CP_CURRENCY_P RETURN VARCHAR2;
96 
97   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
98 
99   FUNCTION CP_SESSION_DT_P RETURN DATE;
100 
101   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
102 
103 END PQH_PQHWSEPS_XMLP_PKG;