[Home] [Help]
PACKAGE BODY: APPS.PA_FP_ROLLUP_TMP_PKG
Source
1 PACKAGE BODY PA_FP_ROLLUP_TMP_PKG AS
2 /* $Header: PAFPRLTB.pls 120.1.12010000.2 2009/06/17 22:00:08 djanaswa ship $*/
3
4 g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_rollup_tmp_pkg';
5
6 PROCEDURE POPULATE_IN_BULK
7 ( p_res_assignment_id_tbl IN pa_fp_webadi_pkg.l_res_assignment_id_tbl_typ
8 , p_parent_assignment_id_tbl IN pa_fp_webadi_pkg.l_parent_assign_id_tbl_typ
9 , p_start_date_tbl IN pa_fp_webadi_pkg.l_start_date_tbl_typ
10 , p_end_date_tbl IN pa_fp_webadi_pkg.l_end_date_tbl_typ
11 , p_txn_currency_code_tbl IN pa_fp_webadi_pkg.l_txn_currency_code_tbl_typ
12 , p_proj_currency_code_tbl IN pa_fp_webadi_pkg.l_proj_currency_code_tbl_typ
13 , p_pf_currency_code_tbl IN pa_fp_webadi_pkg.l_pf_currency_code_tbl_typ
14 , p_proj_cost_rate_type_tbl IN pa_fp_webadi_pkg.l_proj_cost_rate_type_tbl_typ
15 , p_proj_cost_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_proj_cost_rt_dt_type_tbl_typ
16 , p_proj_cost_exc_rate_tbl IN pa_fp_webadi_pkg.l_proj_cost_exc_rate_tbl_typ
17 , p_proj_cost_rate_date_tbl IN pa_fp_webadi_pkg.l_proj_cost_rate_date_tbl_typ
18 , p_proj_rev_rate_type_tbl IN pa_fp_webadi_pkg.l_proj_rev_rate_type_tbl_typ
19 , p_proj_rev_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_proj_rev_rt_dt_type_tbl_typ
20 , p_proj_rev_exc_rate_tbl IN pa_fp_webadi_pkg.l_proj_rev_exc_rate_tbl_typ
21 , p_proj_rev_rate_date_tbl IN pa_fp_webadi_pkg.l_proj_rev_rate_date_tbl_typ
22 , p_pf_cost_rate_type_tbl IN pa_fp_webadi_pkg.l_pf_cost_rate_type_tbl_typ
23 , p_pf_cost_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_pf_cost_rt_dt_type_tbl_typ
24 , p_pf_cost_exc_rate_tbl IN pa_fp_webadi_pkg.l_pf_cost_exc_rate_tbl_typ
25 , p_pf_cost_rate_date_tbl IN pa_fp_webadi_pkg.l_pf_cost_rate_date_tbl_typ
26 , p_pf_rev_rate_type_tbl IN pa_fp_webadi_pkg.l_pf_rev_rate_type_tbl_typ
27 , p_pf_rev_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_pf_rev_rt_dt_type_tbl_typ
28 , p_pf_rev_exc_rate_tbl IN pa_fp_webadi_pkg.l_pf_rev_exc_rate_tbl_typ
29 , p_pf_rev_rate_date_tbl IN pa_fp_webadi_pkg.l_pf_rev_rate_date_tbl_typ
30 , p_old_proj_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
31 , p_old_proj_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
32 , p_old_proj_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
33 , p_old_pf_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
34 , p_old_pf_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
35 , p_old_pf_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
36 , p_old_quantity_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
37 , p_old_txn_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
38 , p_old_txn_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
39 , p_old_txn_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
40 , p_txn_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
41 , p_txn_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
42 , p_txn_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
43 , p_quantity_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
44 , p_delete_flag_tbl IN pa_fp_webadi_pkg.l_delete_flag_tbl_typ
45 , p_period_name_tbl IN pa_fp_webadi_pkg.l_period_name_tbl_typ
46 , p_change_reason_code_tbl IN pa_fp_webadi_pkg.l_change_reason_code_tbl_typ
47 , p_description_tbl IN pa_fp_webadi_pkg.l_description_tbl_typ
48 , p_pm_product_code_tbl IN pa_fp_webadi_pkg.l_pm_product_code_tbl_typ
49 , p_attribute_category_tbl IN pa_fp_webadi_pkg.l_attribute_category_tbl_typ
50 , p_attribute1_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
51 , p_attribute2_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
52 , p_attribute3_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
53 , p_attribute4_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
54 , p_attribute5_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
55 , p_attribute6_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
56 , p_attribute7_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
57 , p_attribute8_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
58 , p_attribute9_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
59 , p_attribute10_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
60 , p_attribute11_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
61 , p_attribute12_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
62 , p_attribute13_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
63 , p_attribute14_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
64 , p_attribute15_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
65 , p_budget_line_id_tbl IN pa_fp_webadi_pkg.l_budget_line_id_tbl_typ
66 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
68 , x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
69 IS
70 l_debug_mode VARCHAR2(1) ;
71 l_msg_count NUMBER := 0;
72 l_data VARCHAR2(2000);
73 l_msg_data VARCHAR2(2000);
74 l_msg_index_out NUMBER;
75 l_count NUMBER;
76 BEGIN
77 x_msg_count := 0;
78 x_return_status := FND_API.G_RET_STS_SUCCESS;
79 l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
80 IF l_debug_mode = 'Y' THEN
81
82 pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK');
83 pa_debug.set_process('PLSQL','LOG',l_debug_mode);
84
85 END IF;
86
87 IF l_debug_mode = 'Y' THEN
88 pa_debug.g_err_stage := ':In PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK p_res_assignment_id_tbl.last = ' || p_res_assignment_id_tbl.last;
89 pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
90 END IF;
91
92 IF nvl(p_res_assignment_id_tbl.LAST,0) > 0 THEN
93
94 FORALL i in p_res_assignment_id_tbl.first..p_res_assignment_id_tbl.last
95
96 INSERT INTO PA_FP_ROLLUP_TMP(
97 ROLLUP_ID
98 , RESOURCE_ASSIGNMENT_ID
99 , PARENT_ASSIGNMENT_ID
100 , START_DATE
101 , END_DATE
102 , TXN_CURRENCY_CODE
103 , PROJECT_CURRENCY_CODE
104 , PROJFUNC_CURRENCY_CODE
105 , PROJECT_COST_RATE_TYPE
106 , PROJECT_COST_RATE_DATE_TYPE
107 , PROJECT_COST_EXCHANGE_RATE
108 , PROJECT_COST_RATE_DATE
109 , PROJECT_REV_RATE_TYPE
110 , PROJECT_REV_RATE_DATE_TYPE
111 , PROJECT_REV_EXCHANGE_RATE
112 , PROJECT_REV_RATE_DATE
113 , PROJFUNC_COST_RATE_TYPE
114 , PROJFUNC_COST_RATE_DATE_TYPE
115 , PROJFUNC_COST_EXCHANGE_RATE
116 , PROJFUNC_COST_RATE_DATE
117 , PROJFUNC_REV_RATE_TYPE
118 , PROJFUNC_REV_RATE_DATE_TYPE
119 , PROJFUNC_REV_EXCHANGE_RATE
120 , PROJFUNC_REV_RATE_DATE
121 , OLD_PROJ_RAW_COST
122 , OLD_PROJ_BURDENED_COST
123 , OLD_PROJ_REVENUE
124 , OLD_PROJFUNC_RAW_COST
125 , OLD_PROJFUNC_BURDENED_COST
126 , OLD_PROJFUNC_REVENUE
127 , OLD_QUANTITY
128 , OLD_TXN_RAW_COST
129 , OLD_TXN_BURDENED_COST
130 , OLD_TXN_REVENUE
131 , TXN_RAW_COST
132 , TXN_BURDENED_COST
133 , TXN_REVENUE
134 , QUANTITY
135 , DELETE_FLAG
136 , PERIOD_NAME
137 , CHANGE_REASON_CODE
138 , DESCRIPTION
139 , PM_PRODUCT_CODE
140 , ATTRIBUTE_CATEGORY
141 , ATTRIBUTE1
142 , ATTRIBUTE2
143 , ATTRIBUTE3
144 , ATTRIBUTE4
145 , ATTRIBUTE5
146 , ATTRIBUTE6
147 , ATTRIBUTE7
148 , ATTRIBUTE8
149 , ATTRIBUTE9
150 , ATTRIBUTE10
151 , ATTRIBUTE11
152 , ATTRIBUTE12
153 , ATTRIBUTE13
154 , ATTRIBUTE14
155 , ATTRIBUTE15
156 , BUDGET_LINE_ID
157 , RAW_COST_SOURCE
158 , BURDENED_COST_SOURCE
159 , QUANTITY_SOURCE
160 , REVENUE_SOURCE
161 )
162 VALUES (
163 pa_fp_rollup_tmp_s.nextval
164 , p_res_assignment_id_tbl(i)
165 , p_parent_assignment_id_tbl(i)
166 , p_start_date_tbl(i)
167 , p_end_date_tbl(i)
168 , p_txn_currency_code_tbl(i)
169 , p_proj_currency_code_tbl(i)
170 , p_pf_currency_code_tbl(i)
171 , p_proj_cost_rate_type_tbl(i)
172 , p_proj_cost_rt_dt_type_tbl(i)
173 , p_proj_cost_exc_rate_tbl(i)
174 , p_proj_cost_rate_date_tbl(i)
175 , p_proj_rev_rate_type_tbl(i)
176 , p_proj_rev_rt_dt_type_tbl(i)
177 , p_proj_rev_exc_rate_tbl(i)
178 , p_proj_rev_rate_date_tbl(i)
179 , p_pf_cost_rate_type_tbl(i)
180 , p_pf_cost_rt_dt_type_tbl(i)
181 , p_pf_cost_exc_rate_tbl(i)
182 , p_pf_cost_rate_date_tbl(i)
183 , p_pf_rev_rate_type_tbl(i)
184 , p_pf_rev_rt_dt_type_tbl(i)
185 , p_pf_rev_exc_rate_tbl(i)
186 , p_pf_rev_rate_date_tbl(i)
187 , p_old_proj_raw_cost_tbl(i)
188 , p_old_proj_burdened_cost_tbl(i)
189 , p_old_proj_revenue_tbl(i)
190 , p_old_pf_raw_cost_tbl(i)
191 , p_old_pf_burdened_cost_tbl(i)
192 , p_old_pf_revenue_tbl(i)
193 , p_old_quantity_tbl(i)
194 , p_old_txn_raw_cost_tbl(i)
195 , p_old_txn_burdened_cost_tbl(i)
196 , p_old_txn_revenue_tbl(i)
197 , p_txn_raw_cost_tbl(i)
198 , p_txn_burdened_cost_tbl(i)
199 , p_txn_revenue_tbl(i)
200 , p_quantity_tbl(i)
201 , p_delete_flag_tbl(i)
202 , p_period_name_tbl(i)
203 , p_change_reason_code_tbl(i)
204 , p_description_tbl(i)
205 , p_pm_product_code_tbl(i)
206 , p_attribute_category_tbl(i)
207 , p_attribute1_tbl(i)
208 , p_attribute2_tbl(i)
209 , p_attribute3_tbl(i)
210 , p_attribute4_tbl(i)
211 , p_attribute5_tbl(i)
212 , p_attribute6_tbl(i)
213 , p_attribute7_tbl(i)
214 , p_attribute8_tbl(i)
215 , p_attribute9_tbl(i)
216 , p_attribute10_tbl(i)
217 , p_attribute11_tbl(i)
218 , p_attribute12_tbl(i)
219 , p_attribute13_tbl(i)
220 , p_attribute14_tbl(i)
221 , p_attribute15_tbl(i)
222 , p_budget_line_id_tbl(i)
223 , PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M
224 , PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M
225 , PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M
226 , PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M
227 );
228 END IF;
229 IF l_debug_mode = 'Y' THEN
230 l_count := sql%rowcount;
231 pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;
232 pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
233 END IF;
234
235 IF l_debug_mode = 'Y' THEN
236 pa_debug.g_err_stage:= 'Exiting POPULATE_IN_BULK';
237 pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
238 pa_debug.reset_err_stack;
239 END IF;
240
241 EXCEPTION
242 WHEN OTHERS THEN
243 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244 x_msg_count := 1;
245 x_msg_data := SQLERRM;
246 FND_MSG_PUB.add_exc_msg
247 ( p_pkg_name => 'PA_FP_WEBADI_PKG'
248 ,p_procedure_name => 'POPULATE_IN_BULK' );
249 IF l_debug_mode = 'Y' THEN
250 pa_debug.write('POPULATE_IN_BULK' || g_module_name,SQLERRM,4);
251 pa_debug.write('POPULATE_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
252 END IF;
253
254 pa_debug.reset_err_stack;
255
256 RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
257
258 END POPULATE_IN_BULK ;
259
260 PROCEDURE POPULATE_IN_MATRIX
261 ( p_res_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
262 , p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
263 , p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
264 , p_proj_currency_code IN pa_budget_lines.project_currency_code%TYPE
265 , p_pf_currency_code IN pa_budget_lines.projfunc_currency_code%TYPE
266 , p_proj_cost_rate_type IN pa_budget_lines.project_cost_rate_type%TYPE
267 , p_proj_cost_rt_dt_type IN pa_budget_lines.project_cost_rate_date_type%TYPE
268 , p_proj_cost_exc_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
269 , p_proj_cost_rate_date IN pa_budget_lines.project_cost_rate_date%TYPE
270 , p_proj_rev_rate_type IN pa_budget_lines.project_rev_rate_type%TYPE
271 , p_proj_rev_rt_dt_type IN pa_budget_lines.project_rev_rate_date_type%TYPE
272 , p_proj_rev_exc_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
273 , p_proj_rev_rate_date IN pa_budget_lines.project_rev_rate_date%TYPE
274 , p_pf_cost_rate_type IN pa_budget_lines.projfunc_cost_rate_type%TYPE
275 , p_pf_cost_rt_dt_type IN pa_budget_lines.projfunc_cost_rate_date_type%TYPE
276 , p_pf_cost_exc_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
277 , p_pf_cost_rate_date IN pa_budget_lines.projfunc_cost_rate_date%TYPE
278 , p_pf_rev_rate_type IN pa_budget_lines.projfunc_rev_rate_type%TYPE
279 , p_pf_rev_rt_dt_type IN pa_budget_lines.projfunc_rev_rate_date_type%TYPE
280 , p_pf_rev_exc_rate IN pa_budget_lines.projfunc_rev_exchange_rate%TYPE
281 , p_pf_rev_rate_date IN pa_budget_lines.projfunc_rev_rate_date%TYPE
282 , p_delete_flag IN VARCHAR2
283 , p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
284 , p_description IN pa_budget_lines.description%TYPE
285 , p_attribute_category IN pa_budget_lines.attribute_category%TYPE
286 , p_attribute1 IN pa_budget_lines.attribute1%TYPE
287 , p_attribute2 IN pa_budget_lines.attribute2%TYPE
288 , p_attribute3 IN pa_budget_lines.attribute3%TYPE
289 , p_attribute4 IN pa_budget_lines.attribute4%TYPE
290 , p_attribute5 IN pa_budget_lines.attribute5%TYPE
291 , p_attribute6 IN pa_budget_lines.attribute6%TYPE
292 , p_attribute7 IN pa_budget_lines.attribute7%TYPE
293 , p_attribute8 IN pa_budget_lines.attribute8%TYPE
294 , p_attribute9 IN pa_budget_lines.attribute9%TYPE
295 , p_attribute10 IN pa_budget_lines.attribute10%TYPE
296 , p_attribute11 IN pa_budget_lines.attribute11%TYPE
297 , p_attribute12 IN pa_budget_lines.attribute12%TYPE
298 , p_attribute13 IN pa_budget_lines.attribute13%TYPE
299 , p_attribute14 IN pa_budget_lines.attribute14%TYPE
300 , p_attribute15 IN pa_budget_lines.attribute15%TYPE
301 , p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
302 , p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
303 , p_quantity_source IN pa_budget_lines.quantity_source%TYPE
304 , p_revenue_source IN pa_budget_lines.revenue_source%TYPE
305 , p_start_date_tbl IN pa_fp_webadi_pkg.l_start_date_tbl_typ
306 , p_end_date_tbl IN pa_fp_webadi_pkg.l_end_date_tbl_typ
307 , p_period_name_tbl IN pa_fp_webadi_pkg.l_period_name_tbl_typ
308 , p_txn_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
309 , p_txn_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
310 , p_txn_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
311 , p_quantity_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
312 , p_bucketing_period_code_tbl IN pa_fp_webadi_pkg.l_bucketing_pd_code_tbl_typ
313 , p_pm_product_code_tbl IN pa_fp_webadi_pkg.l_pm_product_code_tbl_typ
314 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
315 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
316 , x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
317 IS
318 l_debug_mode VARCHAR2(1) ;
319 l_msg_count NUMBER := 0;
320 l_data VARCHAR2(2000);
321 l_msg_data VARCHAR2(2000);
322 l_msg_index_out NUMBER;
323 l_count NUMBER;
324 BEGIN
325 x_msg_count := 0;
326 x_return_status := FND_API.G_RET_STS_SUCCESS;
327 l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
328
329 IF l_debug_mode = 'Y' THEN
330 pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_MATRIX');
331 pa_debug.set_process('PLSQL','LOG',l_debug_mode);
332 END IF;
333
334 IF l_debug_mode = 'Y' THEN
335 pa_debug.g_err_stage:= 'in populate_in_matrix p_period_name_tbl.LAST = ' || p_period_name_tbl.LAST;
336 pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
337 END IF;
338
339 IF nvl(p_period_name_tbl.LAST,0) > 0 THEN
340
341 FORALL i in p_period_name_tbl.FIRST..p_period_name_tbl.LAST
342
343 INSERT INTO PA_FP_ROLLUP_TMP(
344 ROLLUP_ID
345 , RESOURCE_ASSIGNMENT_ID
346 , PARENT_ASSIGNMENT_ID
347 , TXN_CURRENCY_CODE
348 , PROJECT_CURRENCY_CODE
349 , PROJFUNC_CURRENCY_CODE
350 , PROJECT_COST_RATE_TYPE
351 , PROJECT_COST_RATE_DATE_TYPE
352 , PROJECT_COST_EXCHANGE_RATE
353 , PROJECT_COST_RATE_DATE
354 , PROJECT_REV_RATE_TYPE
355 , PROJECT_REV_RATE_DATE_TYPE
356 , PROJECT_REV_EXCHANGE_RATE
357 , PROJECT_REV_RATE_DATE
358 , PROJFUNC_COST_RATE_TYPE
359 , PROJFUNC_COST_RATE_DATE_TYPE
360 , PROJFUNC_COST_EXCHANGE_RATE
361 , PROJFUNC_COST_RATE_DATE
362 , PROJFUNC_REV_RATE_TYPE
363 , PROJFUNC_REV_RATE_DATE_TYPE
364 , PROJFUNC_REV_EXCHANGE_RATE
365 , PROJFUNC_REV_RATE_DATE
366 , DELETE_FLAG
367 , CHANGE_REASON_CODE
368 , DESCRIPTION
369 , PM_PRODUCT_CODE
370 , ATTRIBUTE_CATEGORY
371 , ATTRIBUTE1
372 , ATTRIBUTE2
373 , ATTRIBUTE3
374 , ATTRIBUTE4
375 , ATTRIBUTE5
376 , ATTRIBUTE6
377 , ATTRIBUTE7
378 , ATTRIBUTE8
379 , ATTRIBUTE9
380 , ATTRIBUTE10
381 , ATTRIBUTE11
382 , ATTRIBUTE12
383 , ATTRIBUTE13
384 , ATTRIBUTE14
385 , ATTRIBUTE15
386 , RAW_COST_SOURCE
387 , BURDENED_COST_SOURCE
388 , QUANTITY_SOURCE
389 , REVENUE_SOURCE
390 , START_DATE
391 , END_DATE
392 , PERIOD_NAME
393 , TXN_RAW_COST
394 , TXN_BURDENED_COST
395 , TXN_REVENUE
396 , QUANTITY
397 , BUCKETING_PERIOD_CODE )
398 (SELECT
399 pa_fp_rollup_tmp_s.nextval
400 , p_res_assignment_id
401 , p_parent_assignment_id
402 , p_txn_currency_code
403 , p_proj_currency_code
404 , p_pf_currency_code
405 , p_proj_cost_rate_type
406 , p_proj_cost_rt_dt_type
407 , p_proj_cost_exc_rate
408 , p_proj_cost_rate_date
409 , p_proj_rev_rate_type
410 , p_proj_rev_rt_dt_type
411 , p_proj_rev_exc_rate
412 , p_proj_rev_rate_date
413 , p_pf_cost_rate_type
414 , p_pf_cost_rt_dt_type
415 , p_pf_cost_exc_rate
416 , p_pf_cost_rate_date
417 , p_pf_rev_rate_type
418 , p_pf_rev_rt_dt_type
419 , p_pf_rev_exc_rate
420 , p_pf_rev_rate_date
421 , p_delete_flag
422 , p_change_reason_code
423 , p_description
424 , p_pm_product_code_tbl(i)
425 , p_attribute_category
426 , p_attribute1
427 , p_attribute2
428 , p_attribute3
429 , p_attribute4
430 , p_attribute5
431 , p_attribute6
432 , p_attribute7
433 , p_attribute8
434 , p_attribute9
435 , p_attribute10
436 , p_attribute11
437 , p_attribute12
438 , p_attribute13
439 , p_attribute14
440 , p_attribute15
441 , p_raw_cost_source
442 , p_burdened_cost_source
443 , p_quantity_source
444 , p_revenue_source
445 , p_start_date_tbl(i)
446 , p_end_date_tbl(i)
447 , p_period_name_tbl(i)
448 , p_txn_raw_cost_tbl(i)
449 , p_txn_burdened_cost_tbl(i)
450 , p_txn_revenue_tbl(i)
451 , p_quantity_tbl(i)
452 , p_bucketing_period_code_tbl(i)
453 FROM dual
454 WHERE p_start_date_tbl(i) is not null );
455 END IF;
456 IF l_debug_mode = 'Y' THEN
457 l_count := sql%rowcount;
458 pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;
459 pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
460 END IF;
461
462 IF l_debug_mode = 'Y' THEN
463 pa_debug.g_err_stage:= 'Exiting POPULATE_IN_MATRIX';
464 pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
465 pa_debug.reset_err_stack;
466 END IF;
467
468 EXCEPTION
469 WHEN OTHERS THEN
470 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471 x_msg_count := 1;
472 x_msg_data := SQLERRM;
473 FND_MSG_PUB.add_exc_msg
474 ( p_pkg_name => 'PA_FP_ROLLUP_TMP_PKG'
475 ,p_procedure_name => 'POPULATE_IN_MATRIX' );
476 IF l_debug_mode = 'Y' THEN
477 pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,SQLERRM,4);
478 pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,pa_debug.G_Err_Stack,4);
479 END IF;
480 pa_debug.reset_err_stack;
481 RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
482
483 END POPULATE_IN_MATRIX ;
484 END PA_FP_ROLLUP_TMP_PKG;