[Home] [Help]
PACKAGE: APPS.PA_PAXMGTSD_XMLP_PKG
Source
1 PACKAGE PA_PAXMGTSD_XMLP_PKG AS
2 /* $Header: PAXMGTSDS.pls 120.0 2008/01/02 11:38:41 krreddy noship $ */
3 PROJ NUMBER;
4
5 PA_PERIOD VARCHAR2(40);
6
7 P_DEBUG_MODE VARCHAR2(3);
8
9 P_CONC_REQUEST_ID NUMBER;
10
11 P_RULE_OPTIMIZER VARCHAR2(3);
12
13 COST_BGT_CODE VARCHAR2(30);
14
15 REV_BGT_CODE VARCHAR2(30);
16
17 TASK NUMBER;
18
19 TASK_MGR NUMBER;
20
21 TASK_ORG NUMBER;
22
23 C_SUM_RPT_TOTALS VARCHAR2(5);
24
25 C_COMPANY_NAME_HEADER VARCHAR2(50);
26
27 C_NO_DATA_FOUND VARCHAR2(80);
28
29 C_ORG VARCHAR2(60);
30
31 C_PROJ_NUM VARCHAR2(30);
32
33 C_PROJ_NAME VARCHAR2(30);
34
35 C_MGR VARCHAR2(30);
36
37 C_START_DATE VARCHAR2(20);
38
39 C_END_DATE VARCHAR2(20);
40
41 C_COST_BGT_NAME VARCHAR2(30);
42
43 C_REV_BGT_NAME VARCHAR2(30);
44
45 C_COST_BGT_CODE VARCHAR2(30);
46
47 C_REV_BGT_CODE VARCHAR2(30);
48
49 C_TASK_NUM VARCHAR2(30);
50
51 C_TASK_NAME VARCHAR2(30);
52
53 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
54
55 FUNCTION BEFOREREPORT RETURN BOOLEAN;
56
57 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
58
59 FUNCTION NO_DATA_FOUND_FUNC RETURN BOOLEAN;
60
61 FUNCTION GET_PERIOD(SD IN DATE) RETURN VARCHAR2;
62
63 FUNCTION PERIOD_NAMEFORMULA RETURN VARCHAR2;
64
65 FUNCTION AFTERREPORT RETURN BOOLEAN;
66
67 FUNCTION C_TASK_ACTUAL_COSTFORMULA RETURN NUMBER;
68
69 FUNCTION C_ACT_PER_REVFORMULA(RESOURCE_LIST_MEMBER_ID IN NUMBER
70 ,TASK_ID3 IN NUMBER
71 ,PERIOD_NAME IN VARCHAR2
72 ,PROJECT_ID2 IN NUMBER) RETURN NUMBER;
73
74 FUNCTION GET_PERIOD_AMT(X_TYPE IN VARCHAR2
75 ,X_RSRC_LIST_MEMBER_ID IN NUMBER
76 ,X_TASK_ID IN NUMBER
77 ,PERIOD_NAME IN VARCHAR2
78 ,PROJECT_ID2 IN NUMBER) RETURN NUMBER;
79
80 FUNCTION C_ACT_PER_COSTFORMULA(RESOURCE_LIST_MEMBER_ID1 IN NUMBER
84
81 ,TASK_ID5 IN NUMBER
82 ,PERIOD_NAME IN VARCHAR2
83 ,PROJECT_ID2 IN NUMBER) RETURN NUMBER;
85 FUNCTION C_ACT_PER_REV_SUMFORMULA(C_ACT_PER_REV IN NUMBER
86 ,MEMBER_LEVEL2 IN NUMBER) RETURN NUMBER;
87
88 FUNCTION GET_RSRC_NAME_DISP(X_ALIAS IN VARCHAR2
89 ,X_LEVEL IN NUMBER) RETURN VARCHAR2;
90
91 FUNCTION C_ACT_PER_COST_SUMFORMULA(C_ACT_PER_COST IN NUMBER
92 ,MEMBER_LEVEL1 IN NUMBER) RETURN NUMBER;
93
94 FUNCTION GET_PERIOD_AMT_SUM(X_AMT IN NUMBER
95 ,X_LEVEL IN NUMBER) RETURN NUMBER;
96
97 FUNCTION C_SUM_RPT_TOTALSFORMULA(PARENT_TASK_ID IN NUMBER) RETURN VARCHAR2;
98
99 FUNCTION CHECK_SUM_RPT_TOTALS(PARENT_TASK_ID IN NUMBER) RETURN VARCHAR2;
100
101 FUNCTION C_RPT_BGT_COST_SUMFORMULA(BGT_COST_SUM IN NUMBER) RETURN NUMBER;
102
103 FUNCTION GET_REPORT_LINE_TOTAL(X_AMOUNT IN NUMBER) RETURN NUMBER;
104
105 FUNCTION C_RPT_ACT_COST_SUMFORMULA(ACT_COST_SUM IN NUMBER) RETURN NUMBER;
106
107 FUNCTION C_RPT_ACT_PER_COST_SUMFORMULA(C_ACT_PER_COST_SUM IN NUMBER) RETURN NUMBER;
108
109 FUNCTION C_RPT_ACT_REV_SUMFORMULA(ACT_REV_SUM IN NUMBER) RETURN NUMBER;
110
111 FUNCTION C_RPT_ACT_PER_REV_SUMFORMULA(C_ACT_PER_REV_SUM IN NUMBER) RETURN NUMBER;
112
113 FUNCTION C_RPT_BGT_REV_SUMFORMULA(BGT_REV_SUM IN NUMBER) RETURN NUMBER;
114
115 FUNCTION CF_CURRENCY_CODEFORMULA RETURN CHAR;
116
117 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
118
119 FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
120
121 FUNCTION C_ORG_P RETURN VARCHAR2;
122
123 FUNCTION C_PROJ_NUM_P RETURN VARCHAR2;
124
125 FUNCTION C_PROJ_NAME_P RETURN VARCHAR2;
126
127 FUNCTION C_MGR_P RETURN VARCHAR2;
128
129 FUNCTION C_START_DATE_P RETURN DATE;
130
131 FUNCTION C_END_DATE_P RETURN DATE;
132
133 FUNCTION C_COST_BGT_NAME_P RETURN VARCHAR2;
134
135 FUNCTION C_REV_BGT_NAME_P RETURN VARCHAR2;
136
137 FUNCTION C_COST_BGT_CODE_P RETURN VARCHAR2;
138
139 FUNCTION C_REV_BGT_CODE_P RETURN VARCHAR2;
140
141 FUNCTION C_TASK_NUM_P RETURN VARCHAR2;
142
143 FUNCTION C_TASK_NAME_P RETURN VARCHAR2;
144
145 END PA_PAXMGTSD_XMLP_PKG;