PACKAGE: APPS.PQH_PQHWSBPR_XMLP_PKG

Source

1 PACKAGE PQH_PQHWSBPR_XMLP_PKG AS
2 /* $Header: PQHWSBPRS.pls 120.1 2007/12/07 06:59:28 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_BUDGET_VERSION_ID NUMBER;
12 
13   P_EFFECTIVE_DATE DATE;
14 
15   P_RECORD_TYPE VARCHAR2(30);
16 
17   C_REPORT_SUBTITLE VARCHAR2(60);
18 
19   CP_BUDGET_NAME VARCHAR2(240);
20 
21   CP_BUDGET_VERSION NUMBER;
22 
23   CP_CURRENCY_CODE VARCHAR2(15);
24 
25   C_BUSINESS_GROUP_NAME VARCHAR2(240);
26 
27   CP_SESSION_DT DATE;
28 
29   CP_RECORD_VALUE VARCHAR2(80);
30 
31   FUNCTION BEFOREREPORT RETURN BOOLEAN;
32 
33   FUNCTION CF_1FORMULA(BUDGET_UNIT_ID IN NUMBER
34                       ,BUDGET_PERIOD_ACTUAL_VALUE IN NUMBER
35                       ,BUDGET_PERIOD_CMMTMNT_VALUE IN NUMBER) RETURN NUMBER;
36 
37   FUNCTION CF_DEF_EX_AMTFORMULA(BUDGET_PERIOD_BUDGETED_VALUE IN NUMBER
38                                ,CF_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
39 
40   FUNCTION BEFOREPFORM RETURN BOOLEAN;
41 
42   FUNCTION CF_ACT_PERFORMULA(BUDGET_PERIOD_BUDGETED_VALUE IN NUMBER
43                             ,BUDGET_PERIOD_ACTUAL_VALUE IN NUMBER) RETURN NUMBER;
44 
45   FUNCTION CF_COM_PERFORMULA(BUDGET_PERIOD_BUDGETED_VALUE IN NUMBER
46                             ,BUDGET_PERIOD_CMMTMNT_VALUE IN NUMBER) RETURN NUMBER;
47 
48   FUNCTION CF_PROJ_PERFORMULA(BUDGET_PERIOD_BUDGETED_VALUE IN NUMBER
49                              ,CF_PROJECTED_EXP IN NUMBER) RETURN NUMBER;
50 
51   FUNCTION CF_DEF_EX_PERFORMULA(BUDGET_PERIOD_BUDGETED_VALUE IN NUMBER
52                                ,CF_DEF_EX_AMT IN NUMBER) RETURN NUMBER;
53 
54   FUNCTION CF_FORMAT_MASKFORMULA(BUDGET_UNIT_ID IN NUMBER) RETURN CHAR;
55 
56   FUNCTION AFTERREPORT RETURN BOOLEAN;
57 
58   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
59 
60   FUNCTION CP_BUDGET_NAME_P RETURN VARCHAR2;
61 
62   FUNCTION CP_BUDGET_VERSION_P RETURN NUMBER;
63 
64   FUNCTION CP_CURRENCY_CODE_P RETURN VARCHAR2;
65 
66   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
67 
68   FUNCTION CP_SESSION_DT_P RETURN DATE;
69 
70   FUNCTION CP_RECORD_VALUE_P RETURN VARCHAR2;
71 
72   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
73 
74 END PQH_PQHWSBPR_XMLP_PKG;