PACKAGE: APPS.PA_PAXPCPRS_XMLP_PKG

Source

1 PACKAGE PA_PAXPCPRS_XMLP_PKG AS
2   /* $Header: PAXPCPRSS.pls 120.0 2008/01/02 11:43:21 krreddy noship $ */
3   INCLUDE_CLOSED_PROJECTS VARCHAR2(40);
4 
5   PROJECT_ORGANIZATION NUMBER;
6 
7   PROJ NUMBER;
8 
9   ACCRUE_THROUGH_DATE DATE;
10 
11   ACCRUE_THROUGH_DATE1 VARCHAR2(30);
12 
13   PROJECT_MANAGER NUMBER;
14 
15   P_CONC_REQUEST_ID NUMBER;
16 
17   P_DEBUG_MODE VARCHAR2(3);
18 
19   P_RULE_OPTIMIZER VARCHAR2(3);
20 
21   C_COMPANY_NAME_HEADER VARCHAR2(50);
22 
23   C_NO_DATA_FOUND VARCHAR2(80);
24 
25   C_PROJ_ORG VARCHAR2(60);
26 
27   C_PROJ_NUMBER VARCHAR2(40);
28 
29   C_PROJ_MANAGER VARCHAR2(240);
30 
31   C_YES_NO VARCHAR2(40);
32 
33   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
34 
35   FUNCTION BEFOREREPORT RETURN BOOLEAN;
36 
37   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
38 
39   FUNCTION NO_DATA_FOUND_FUNC RETURN BOOLEAN;
40 
41   FUNCTION C_DIFFFORMULA(PARTIAL_POTENTIAL_REVENUE IN NUMBER
42                         ,PARTIAL_ACCRUED_REVENUE IN NUMBER) RETURN NUMBER;
43 
44   FUNCTION AFTERREPORT RETURN BOOLEAN;
45 
46   FUNCTION C_DIFF2FORMULA(TOTAL_POTENTIAL_REVENUE IN NUMBER
47                          ,TOTAL_ACCRUED_REVENUE IN NUMBER) RETURN NUMBER;
48 
49   FUNCTION C_DISP_ORG_POT_REVFORMULA(C_ORG_POT_REV IN NUMBER) RETURN VARCHAR2;
50 
51   FUNCTION C_DISP_ORG_ACC_REVFORMULA(C_ORG_ACC_REV IN NUMBER) RETURN VARCHAR2;
52 
53   FUNCTION C_DISP_ORG_DIFF_REVFORMULA(C_ORG_DIFF_REV IN NUMBER) RETURN VARCHAR2;
54 
55   FUNCTION C_DISP_ORG_TOT_POTFORMULA(C_ORG_TOT_POT IN NUMBER) RETURN VARCHAR2;
56 
57   FUNCTION C_DISP_ORG_TOT_ACCFORMULA(C_ORG_TOT_ACC IN NUMBER) RETURN VARCHAR2;
58 
59   FUNCTION C_DISP_ORG_TOT_DIFFFORMULA(C_ORG_TOT_DIFF IN NUMBER) RETURN VARCHAR2;
60 
61   FUNCTION C_DISP_MGR_POT_REVFORMULA(C_MGR_POT_REV IN NUMBER) RETURN VARCHAR2;
62 
63   FUNCTION C_DISP_MGR_ACC_REVFORMULA(C_MGR_ACC_REV IN NUMBER) RETURN VARCHAR2;
64 
65   FUNCTION C_DISP_MGR_DIFF_REVFORMULA(C_MGR_DIFF_REV IN NUMBER) RETURN VARCHAR2;
66 
67   FUNCTION C_DISP_MGR_TOT_POTFORMULA(C_MGR_TOT_POT IN NUMBER) RETURN VARCHAR2;
68 
69   FUNCTION C_DISP_MGR_TOT_ACCFORMULA(C_MGR_TOT_ACC IN NUMBER) RETURN VARCHAR2;
70 
71   FUNCTION C_DISP_MGR_TOT_DIFFFORMULA(C_MGR_TOT_DIFF IN NUMBER) RETURN VARCHAR2;
72 
73   FUNCTION C_DISP_TOT_POT_REVFORMULA(TOTAL_POTENTIAL_REVENUE IN NUMBER) RETURN VARCHAR2;
74 
75   FUNCTION C_DISP_TOT_ACC_REVFORMULA(TOTAL_ACCRUED_REVENUE IN NUMBER) RETURN VARCHAR2;
76 
77   FUNCTION C_DISP_DIFFFORMULA(C_DIFF IN NUMBER) RETURN VARCHAR2;
78 
79   FUNCTION C_DISP_PAR_POT_REVFORMULA(PARTIAL_POTENTIAL_REVENUE IN NUMBER) RETURN VARCHAR2;
80 
81   FUNCTION C_DISP_PAR_ACC_REVFORMULA(PARTIAL_ACCRUED_REVENUE IN NUMBER) RETURN VARCHAR2;
82 
83   FUNCTION C_DISP_DIFF2FORMULA(C_DIFF2 IN NUMBER) RETURN VARCHAR2;
84 
85   FUNCTION C_DISP_REP_POT_REVFORMULA(C_REP_POT_REV IN NUMBER) RETURN VARCHAR2;
86 
87   FUNCTION C_DISP_REP_ACC_REVFORMULA(C_REP_ACC_REV IN NUMBER) RETURN VARCHAR2;
88 
89   FUNCTION C_DISP_REP_DIFF_REVFORMULA(C_REP_DIFF_REV IN NUMBER) RETURN VARCHAR2;
90 
91   FUNCTION C_DISP_REP_TOT_POTFORMULA(C_REP_TOT_POT IN NUMBER) RETURN VARCHAR2;
92 
93   FUNCTION C_DISP_REP_TOT_ACCFORMULA(C_REP_TOT_ACC IN NUMBER) RETURN VARCHAR2;
94 
95   FUNCTION C_DISP_REP_TOT_DIFFFORMULA(C_REP_TOT_DIFF IN NUMBER) RETURN VARCHAR2;
96 
97   FUNCTION CF_CURRENCY_CODEFORMULA RETURN VARCHAR2;
98 
99   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
100 
101   FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
102 
103   FUNCTION C_PROJ_ORG_P RETURN VARCHAR2;
104 
105   FUNCTION C_PROJ_NUMBER_P RETURN VARCHAR2;
106 
107   FUNCTION C_PROJ_MANAGER_P RETURN VARCHAR2;
108 
109   FUNCTION C_YES_NO_P RETURN VARCHAR2;
110 
111   FUNCTION GET_CURRENCY_CODE RETURN VARCHAR2;
112 
113   FUNCTION ROUND_CURRENCY_AMT(X_AMOUNT IN NUMBER) RETURN NUMBER;
114 
115   FUNCTION CURRENCY_FMT_MASK(X_LENGTH IN NUMBER) RETURN VARCHAR2;
116 
117   FUNCTION RPT_CURRENCY_FMT_MASK(X_ORG_ID IN NUMBER
118                                 ,X_LENGTH IN NUMBER) RETURN VARCHAR2;
119 
120 END PA_PAXPCPRS_XMLP_PKG;