1 package PA_PROGRESS_ROLLUP_PKG AUTHID CURRENT_USER as
2 /* $Header: PAPRPKGS.pls 120.1.12020000.2 2013/03/28 13:32:43 bpottipa ship $ */
3
4 procedure INSERT_ROW(
5 X_PROGRESS_ROLLUP_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6 ,X_PROJECT_ID IN NUMBER
7 ,X_OBJECT_ID IN NUMBER
8 ,X_OBJECT_TYPE IN VARCHAR2
9 ,X_AS_OF_DATE IN DATE
10 ,X_OBJECT_VERSION_ID IN NUMBER
11 ,X_LAST_UPDATE_DATE IN DATE
12 ,X_LAST_UPDATED_BY IN NUMBER
13 ,X_CREATION_DATE IN DATE
14 ,X_CREATED_BY IN NUMBER
15 ,X_PROGRESS_STATUS_CODE IN VARCHAR2
16 ,X_LAST_UPDATE_LOGIN IN NUMBER
17 ,X_INCREMENTAL_WORK_QTY IN NUMBER
18 ,X_CUMULATIVE_WORK_QTY IN NUMBER
19 ,X_BASE_PERCENT_COMPLETE IN NUMBER
20 ,X_EFF_ROLLUP_PERCENT_COMP IN NUMBER
21 ,X_COMPLETED_PERCENTAGE IN NUMBER
22 ,X_ESTIMATED_START_DATE IN DATE
23 ,X_ESTIMATED_FINISH_DATE IN DATE
24 ,X_ACTUAL_START_DATE IN DATE
25 ,X_ACTUAL_FINISH_DATE IN DATE
26 ,X_EST_REMAINING_EFFORT IN NUMBER
27 ,X_BASE_PERCENT_COMP_DERIV_CODE IN VARCHAR2
28 ,X_BASE_PROGRESS_STATUS_CODE IN VARCHAR2
29 ,X_EFF_ROLLUP_PROG_STAT_CODE IN VARCHAR2
30 ,x_percent_complete_id in number
31 ,X_STRUCTURE_TYPE IN VARCHAR2
32 ,X_PROJ_ELEMENT_ID IN NUMBER
33 ,X_STRUCTURE_VERSION_ID IN NUMBER
34 ,X_PPL_ACT_EFFORT_TO_DATE IN NUMBER
35 ,X_EQPMT_ACT_EFFORT_TO_DATE IN NUMBER
36 ,X_EQPMT_ETC_EFFORT IN NUMBER
37 ,X_OTH_ACT_COST_TO_DATE_TC IN NUMBER
38 ,X_OTH_ACT_COST_TO_DATE_FC IN NUMBER
39 ,X_OTH_ACT_COST_TO_DATE_PC IN NUMBER
40 ,X_OTH_ETC_COST_TC IN NUMBER
41 ,X_OTH_ETC_COST_FC IN NUMBER
42 ,X_OTH_ETC_COST_PC IN NUMBER
43 ,X_PPL_ACT_COST_TO_DATE_TC IN NUMBER
44 ,X_PPL_ACT_COST_TO_DATE_FC IN NUMBER
45 ,X_PPL_ACT_COST_TO_DATE_PC IN NUMBER
46 ,X_PPL_ETC_COST_TC IN NUMBER
47 ,X_PPL_ETC_COST_FC IN NUMBER
48 ,X_PPL_ETC_COST_PC IN NUMBER
49 ,X_EQPMT_ACT_COST_TO_DATE_TC IN NUMBER
50 ,X_EQPMT_ACT_COST_TO_DATE_FC IN NUMBER
51 ,X_EQPMT_ACT_COST_TO_DATE_PC IN NUMBER
52 ,X_EQPMT_ETC_COST_TC IN NUMBER
53 ,X_EQPMT_ETC_COST_FC IN NUMBER
54 ,X_EQPMT_ETC_COST_PC IN NUMBER
55 ,X_EARNED_VALUE IN NUMBER
56 ,X_TASK_WT_BASIS_CODE IN VARCHAR2
57 ,X_SUBPRJ_PPL_ACT_EFFORT IN NUMBER
58 ,X_SUBPRJ_EQPMT_ACT_EFFORT IN NUMBER
59 ,X_SUBPRJ_PPL_ETC_EFFORT IN NUMBER
60 ,X_SUBPRJ_EQPMT_ETC_EFFORT IN NUMBER
61 ,X_SBPJ_OTH_ACT_COST_TO_DATE_TC IN NUMBER
62 ,X_SBPJ_OTH_ACT_COST_TO_DATE_FC IN NUMBER
63 ,X_SBPJ_OTH_ACT_COST_TO_DATE_PC IN NUMBER
64 ,X_SUBPRJ_PPL_ACT_COST_TC IN NUMBER
65 ,X_SUBPRJ_PPL_ACT_COST_FC IN NUMBER
66 ,X_SUBPRJ_PPL_ACT_COST_PC IN NUMBER
67 ,X_SUBPRJ_EQPMT_ACT_COST_TC IN NUMBER
68 ,X_SUBPRJ_EQPMT_ACT_COST_FC IN NUMBER
69 ,X_SUBPRJ_EQPMT_ACT_COST_PC IN NUMBER
70 ,X_SUBPRJ_OTH_ETC_COST_TC IN NUMBER
71 ,X_SUBPRJ_OTH_ETC_COST_FC IN NUMBER
72 ,X_SUBPRJ_OTH_ETC_COST_PC IN NUMBER
73 ,X_SUBPRJ_PPL_ETC_COST_TC IN NUMBER
74 ,X_SUBPRJ_PPL_ETC_COST_FC IN NUMBER
75 ,X_SUBPRJ_PPL_ETC_COST_PC IN NUMBER
76 ,X_SUBPRJ_EQPMT_ETC_COST_TC IN NUMBER
77 ,X_SUBPRJ_EQPMT_ETC_COST_FC IN NUMBER
78 ,X_SUBPRJ_EQPMT_ETC_COST_PC IN NUMBER
79 ,X_SUBPRJ_EARNED_VALUE IN NUMBER
80 ,X_CURRENT_FLAG IN VARCHAR2
81 ,X_PROJFUNC_COST_RATE_TYPE VARCHAR2
82 ,X_PROJFUNC_COST_EXCHANGE_RATE NUMBER
83 ,X_PROJFUNC_COST_RATE_DATE DATE
84 ,X_PROJ_COST_RATE_TYPE VARCHAR2
85 ,X_PROJ_COST_EXCHANGE_RATE NUMBER
86 ,X_PROJ_COST_RATE_DATE DATE
87 ,X_TXN_CURRENCY_CODE VARCHAR2
88 ,X_PROG_PA_PERIOD_NAME VARCHAR2
89 ,X_PROG_GL_PERIOD_NAME VARCHAR2
90 ,X_OTH_QUANTITY_TO_DATE NUMBER
91 ,X_OTH_ETC_QUANTITY NUMBER
92 ,X_OTH_ACT_RAWCOST_TO_DATE_TC IN NUMBER
93 ,X_OTH_ACT_RAWCOST_TO_DATE_FC IN NUMBER
94 ,X_OTH_ACT_RAWCOST_TO_DATE_PC IN NUMBER
95 ,X_OTH_ETC_RAWCOST_TC IN NUMBER
96 ,X_OTH_ETC_RAWCOST_FC IN NUMBER
97 ,X_OTH_ETC_RAWCOST_PC IN NUMBER
98 ,X_PPL_ACT_RAWCOST_TO_DATE_TC IN NUMBER
99 ,X_PPL_ACT_RAWCOST_TO_DATE_FC IN NUMBER
100 ,X_PPL_ACT_RAWCOST_TO_DATE_PC IN NUMBER
101 ,X_PPL_ETC_RAWCOST_TC IN NUMBER
102 ,X_PPL_ETC_RAWCOST_FC IN NUMBER
103 ,X_PPL_ETC_RAWCOST_PC IN NUMBER
104 ,X_EQPMT_ACT_RAWCOST_TO_DATE_TC IN NUMBER
105 ,X_EQPMT_ACT_RAWCOST_TO_DATE_FC IN NUMBER
106 ,X_EQPMT_ACT_RAWCOST_TO_DATE_PC IN NUMBER
107 ,X_EQPMT_ETC_RAWCOST_TC IN NUMBER
108 ,X_EQPMT_ETC_RAWCOST_FC IN NUMBER
109 ,X_EQPMT_ETC_RAWCOST_PC IN NUMBER
110 ,X_SP_OTH_ACT_RAWCOST_TODATE_TC IN NUMBER
111 ,X_SP_OTH_ACT_RAWCOST_TODATE_FC IN NUMBER
112 ,X_SP_OTH_ACT_RAWCOST_TODATE_PC IN NUMBER
113 ,X_SUBPRJ_PPL_ACT_RAWCOST_TC IN NUMBER
114 ,X_SUBPRJ_PPL_ACT_RAWCOST_FC IN NUMBER
115 ,X_SUBPRJ_PPL_ACT_RAWCOST_PC IN NUMBER
116 ,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC IN NUMBER
117 ,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC IN NUMBER
118 ,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC IN NUMBER
119 ,X_SUBPRJ_OTH_ETC_RAWCOST_TC IN NUMBER
120 ,X_SUBPRJ_OTH_ETC_RAWCOST_FC IN NUMBER
121 ,X_SUBPRJ_OTH_ETC_RAWCOST_PC IN NUMBER
122 ,X_SUBPRJ_PPL_ETC_RAWCOST_TC IN NUMBER
123 ,X_SUBPRJ_PPL_ETC_RAWCOST_FC IN NUMBER
124 ,X_SUBPRJ_PPL_ETC_RAWCOST_PC IN NUMBER
125 ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC IN NUMBER
126 ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC IN NUMBER
127 ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC IN NUMBER
128 , X_CBS_ELEMENT_ID IN NUMBER DEFAULT NULL --Added for CBS 16200605
129 );
130
131 procedure UPDATE_ROW(
132 X_PROGRESS_ROLLUP_ID IN NUMBER
133 ,X_PROJECT_ID IN NUMBER
134 ,X_OBJECT_ID IN NUMBER
135 ,X_OBJECT_TYPE IN VARCHAR2
136 ,X_AS_OF_DATE IN DATE
137 ,X_OBJECT_VERSION_ID IN NUMBER
138 ,X_LAST_UPDATE_DATE IN DATE
139 ,X_LAST_UPDATED_BY IN NUMBER
140 ,X_PROGRESS_STATUS_CODE IN VARCHAR2
141 ,X_LAST_UPDATE_LOGIN IN NUMBER
142 ,X_INCREMENTAL_WORK_QTY IN NUMBER
143 ,X_CUMULATIVE_WORK_QTY IN NUMBER
144 ,X_BASE_PERCENT_COMPLETE IN NUMBER
145 ,X_EFF_ROLLUP_PERCENT_COMP IN NUMBER
146 ,X_COMPLETED_PERCENTAGE IN NUMBER
147 ,X_ESTIMATED_START_DATE IN DATE
148 ,X_ESTIMATED_FINISH_DATE IN DATE
149 ,X_ACTUAL_START_DATE IN DATE
150 ,X_ACTUAL_FINISH_DATE IN DATE
151 ,X_EST_REMAINING_EFFORT IN NUMBER
152 ,X_BASE_PERCENT_COMP_DERIV_CODE IN VARCHAR2
153 ,X_BASE_PROGRESS_STATUS_CODE IN VARCHAR2
154 ,X_EFF_ROLLUP_PROG_STAT_CODE IN VARCHAR2
155 ,X_RECORD_VERSION_NUMBER IN NUMBER
156 ,x_percent_complete_id in number
157 ,X_STRUCTURE_TYPE IN VARCHAR2
158 ,X_PROJ_ELEMENT_ID IN NUMBER
159 ,X_STRUCTURE_VERSION_ID IN NUMBER
160 ,X_PPL_ACT_EFFORT_TO_DATE IN NUMBER
161 ,X_EQPMT_ACT_EFFORT_TO_DATE IN NUMBER
162 ,X_EQPMT_ETC_EFFORT IN NUMBER
163 ,X_OTH_ACT_COST_TO_DATE_TC IN NUMBER
164 ,X_OTH_ACT_COST_TO_DATE_FC IN NUMBER
165 ,X_OTH_ACT_COST_TO_DATE_PC IN NUMBER
166 ,X_OTH_ETC_COST_TC IN NUMBER
167 ,X_OTH_ETC_COST_FC IN NUMBER
168 ,X_OTH_ETC_COST_PC IN NUMBER
169 ,X_PPL_ACT_COST_TO_DATE_TC IN NUMBER
170 ,X_PPL_ACT_COST_TO_DATE_FC IN NUMBER
171 ,X_PPL_ACT_COST_TO_DATE_PC IN NUMBER
172 ,X_PPL_ETC_COST_TC IN NUMBER
173 ,X_PPL_ETC_COST_FC IN NUMBER
174 ,X_PPL_ETC_COST_PC IN NUMBER
175 ,X_EQPMT_ACT_COST_TO_DATE_TC IN NUMBER
176 ,X_EQPMT_ACT_COST_TO_DATE_FC IN NUMBER
177 ,X_EQPMT_ACT_COST_TO_DATE_PC IN NUMBER
178 ,X_EQPMT_ETC_COST_TC IN NUMBER
179 ,X_EQPMT_ETC_COST_FC IN NUMBER
180 ,X_EQPMT_ETC_COST_PC IN NUMBER
181 ,X_EARNED_VALUE IN NUMBER
182 ,X_TASK_WT_BASIS_CODE IN VARCHAR2
183 ,X_SUBPRJ_PPL_ACT_EFFORT IN NUMBER
184 ,X_SUBPRJ_EQPMT_ACT_EFFORT IN NUMBER
185 ,X_SUBPRJ_PPL_ETC_EFFORT IN NUMBER
186 ,X_SUBPRJ_EQPMT_ETC_EFFORT IN NUMBER
187 ,X_SBPJ_OTH_ACT_COST_TO_DATE_TC IN NUMBER
188 ,X_SBPJ_OTH_ACT_COST_TO_DATE_FC IN NUMBER
189 ,X_SBPJ_OTH_ACT_COST_TO_DATE_PC IN NUMBER
190 ,X_SUBPRJ_PPL_ACT_COST_TC IN NUMBER
191 ,X_SUBPRJ_PPL_ACT_COST_FC IN NUMBER
192 ,X_SUBPRJ_PPL_ACT_COST_PC IN NUMBER
193 ,X_SUBPRJ_EQPMT_ACT_COST_TC IN NUMBER
194 ,X_SUBPRJ_EQPMT_ACT_COST_FC IN NUMBER
195 ,X_SUBPRJ_EQPMT_ACT_COST_PC IN NUMBER
196 ,X_SUBPRJ_OTH_ETC_COST_TC IN NUMBER
197 ,X_SUBPRJ_OTH_ETC_COST_FC IN NUMBER
198 ,X_SUBPRJ_OTH_ETC_COST_PC IN NUMBER
199 ,X_SUBPRJ_PPL_ETC_COST_TC IN NUMBER
200 ,X_SUBPRJ_PPL_ETC_COST_FC IN NUMBER
201 ,X_SUBPRJ_PPL_ETC_COST_PC IN NUMBER
202 ,X_SUBPRJ_EQPMT_ETC_COST_TC IN NUMBER
203 ,X_SUBPRJ_EQPMT_ETC_COST_FC IN NUMBER
204 ,X_SUBPRJ_EQPMT_ETC_COST_PC IN NUMBER
205 ,X_SUBPRJ_EARNED_VALUE IN NUMBER
206 ,X_CURRENT_FLAG IN VARCHAR2
207 ,X_PROJFUNC_COST_RATE_TYPE VARCHAR2
208 ,X_PROJFUNC_COST_EXCHANGE_RATE NUMBER
209 ,X_PROJFUNC_COST_RATE_DATE DATE
210 ,X_PROJ_COST_RATE_TYPE VARCHAR2
211 ,X_PROJ_COST_EXCHANGE_RATE NUMBER
212 ,X_PROJ_COST_RATE_DATE DATE
213 ,X_TXN_CURRENCY_CODE VARCHAR2
214 ,X_PROG_PA_PERIOD_NAME VARCHAR2
215 ,X_PROG_GL_PERIOD_NAME VARCHAR2
216 ,X_OTH_QUANTITY_TO_DATE NUMBER
217 ,X_OTH_ETC_QUANTITY NUMBER
218 ,X_OTH_ACT_RAWCOST_TO_DATE_TC IN NUMBER
219 ,X_OTH_ACT_RAWCOST_TO_DATE_FC IN NUMBER
220 ,X_OTH_ACT_RAWCOST_TO_DATE_PC IN NUMBER
221 ,X_OTH_ETC_RAWCOST_TC IN NUMBER
222 ,X_OTH_ETC_RAWCOST_FC IN NUMBER
223 ,X_OTH_ETC_RAWCOST_PC IN NUMBER
224 ,X_PPL_ACT_RAWCOST_TO_DATE_TC IN NUMBER
225 ,X_PPL_ACT_RAWCOST_TO_DATE_FC IN NUMBER
226 ,X_PPL_ACT_RAWCOST_TO_DATE_PC IN NUMBER
227 ,X_PPL_ETC_RAWCOST_TC IN NUMBER
228 ,X_PPL_ETC_RAWCOST_FC IN NUMBER
229 ,X_PPL_ETC_RAWCOST_PC IN NUMBER
230 ,X_EQPMT_ACT_RAWCOST_TO_DATE_TC IN NUMBER
231 ,X_EQPMT_ACT_RAWCOST_TO_DATE_FC IN NUMBER
232 ,X_EQPMT_ACT_RAWCOST_TO_DATE_PC IN NUMBER
233 ,X_EQPMT_ETC_RAWCOST_TC IN NUMBER
234 ,X_EQPMT_ETC_RAWCOST_FC IN NUMBER
235 ,X_EQPMT_ETC_RAWCOST_PC IN NUMBER
236 ,X_SP_OTH_ACT_RAWCOST_TODATE_TC IN NUMBER
237 ,X_SP_OTH_ACT_RAWCOST_TODATE_FC IN NUMBER
238 ,X_SP_OTH_ACT_RAWCOST_TODATE_PC IN NUMBER
239 ,X_SUBPRJ_PPL_ACT_RAWCOST_TC IN NUMBER
240 ,X_SUBPRJ_PPL_ACT_RAWCOST_FC IN NUMBER
241 ,X_SUBPRJ_PPL_ACT_RAWCOST_PC IN NUMBER
242 ,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC IN NUMBER
243 ,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC IN NUMBER
244 ,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC IN NUMBER
245 ,X_SUBPRJ_OTH_ETC_RAWCOST_TC IN NUMBER
246 ,X_SUBPRJ_OTH_ETC_RAWCOST_FC IN NUMBER
247 ,X_SUBPRJ_OTH_ETC_RAWCOST_PC IN NUMBER
248 ,X_SUBPRJ_PPL_ETC_RAWCOST_TC IN NUMBER
249 ,X_SUBPRJ_PPL_ETC_RAWCOST_FC IN NUMBER
250 ,X_SUBPRJ_PPL_ETC_RAWCOST_PC IN NUMBER
251 ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC IN NUMBER
252 ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC IN NUMBER
253 ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC IN NUMBER
254 , X_CBS_ELEMENT_ID IN NUMBER DEFAULT NULL --Added for CBS 16200605
255 );
256
257 Procedure DELETE_ROW(
258 p_row_id VARCHAR2 );
259
260
261 end PA_PROGRESS_ROLLUP_PKG;
262