[Home] [Help]
208: AND
209: l_struct_sharing_code = 'SHARE_FULL')
210: OR
211: p_calling_context = 'FINANCIAL_PLAN' THEN
212: INSERT INTO PA_FP_CALC_AMT_TMP1
213: ( RESOURCE_ASSIGNMENT_ID
214: ,BUDGET_VERSION_ID
215: ,PROJECT_ID
216: ,TASK_ID
372:
373: ELSIF (p_calling_context = 'WORK_PLAN'
374: AND p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag = 'Y'
375: AND l_struct_sharing_code = 'SPLIT_NO_MAPPING') THEN
376: INSERT INTO PA_FP_CALC_AMT_TMP1
377: ( RESOURCE_ASSIGNMENT_ID
378: ,BUDGET_VERSION_ID
379: ,PROJECT_ID
380: ,TASK_ID
525: AND
526: p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag = 'Y'
527: AND
528: l_struct_sharing_code <> 'SHARE_FULL') THEN
529: INSERT INTO PA_FP_CALC_AMT_TMP1
530: ( RESOURCE_ASSIGNMENT_ID
531: ,BUDGET_VERSION_ID
532: ,PROJECT_ID
533: ,TASK_ID
692: /*else part is used when p_calling_context = 'WORK_PLAN'and
693: p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag = 'N' and
694: structure sharing code is not null */
695: --dbms_output.put_line('Value for track_workplan_costs_flag:' || p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag);
696: INSERT INTO PA_FP_CALC_AMT_TMP1
697: ( RESOURCE_ASSIGNMENT_ID
698: ,BUDGET_VERSION_ID
699: ,PROJECT_ID
700: ,TASK_ID
808: l_start_date_tab,
809: l_end_date_tab,
810: l_res_list_member_id_tab, /* Bug 4070849 */
811: l_cbs_id_tab
812: FROM pa_fp_calc_amt_tmp1
813: WHERE NVL(mapped_fin_task_id,0) = p_task_id;
814:
815: --dbms_output.put_line('Count value for l_res_asg_id_tab : '||l_res_asg_id_tab.count );
816:
2381: *Scenario: Other sources (Actual or commitment etc): Rate-based;
2382: * Generated amount from main source: Non rate-based
2383: *Strategy: Only take amount from other sources. Need to convert
2384: * the rate-based flag of the actual to be non rate-based.
2385: *Implementation: parse pa_fp_calc_amt_tmp1 table to check each target
2386: * resource assignment,for each rate based target res asg,
2387: * as long as there exists one source res asg with rate
2388: * based flag of 'N', target res asg will be updated to
2389: * non rate based. And for this target res asg, all existing
2417: END IF;
2418: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2419:
2420: -- Bug 4170419 : Start
2421: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2422: -- DISTINCT target_res_asg_id
2423: --BULK COLLECT
2424: --INTO l_tgt_res_asg_tab
2425: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2421: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2422: -- DISTINCT target_res_asg_id
2423: --BULK COLLECT
2424: --INTO l_tgt_res_asg_tab
2425: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2426: --WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2427: -- AND ra.rate_based_flag = 'Y'
2428: -- AND tmp.rate_based_flag = 'N';
2429: l_bv_id := p_fp_cols_rec.x_budget_version_id;
2436: SELECT /*+ LEADING(tmp) */
2437: DISTINCT target_res_asg_id
2438: BULK COLLECT
2439: INTO l_tgt_res_asg_tab
2440: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2441: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2442: AND ra.rate_based_flag = 'Y'
2443: AND tmp.rate_based_flag = 'N';
2444:
2453: SELECT /*+ LEADING(tmp) */
2454: DISTINCT target_res_asg_id
2455: BULK COLLECT
2456: INTO l_tgt_res_asg_tab
2457: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2458: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2459: AND ra.rate_based_flag = 'Y'
2460: AND tmp.rate_based_flag = 'N'
2461: AND ( ra.transaction_source_code is not null
2475: SELECT /*+ LEADING(tmp) */
2476: DISTINCT target_res_asg_id
2477: BULK COLLECT
2478: INTO l_tgt_res_asg_tab
2479: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2480: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2481: AND ra.rate_based_flag = 'Y'
2482: AND tmp.rate_based_flag = 'N'
2483: AND ( ra.transaction_source_code is not null