[Home] [Help]
205: AND
206: l_struct_sharing_code = 'SHARE_FULL')
207: OR
208: p_calling_context = 'FINANCIAL_PLAN' THEN
209: INSERT INTO PA_FP_CALC_AMT_TMP1
210: ( RESOURCE_ASSIGNMENT_ID
211: ,BUDGET_VERSION_ID
212: ,PROJECT_ID
213: ,TASK_ID
367:
368: ELSIF (p_calling_context = 'WORK_PLAN'
369: AND p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag = 'Y'
370: AND l_struct_sharing_code = 'SPLIT_NO_MAPPING') THEN
371: INSERT INTO PA_FP_CALC_AMT_TMP1
372: ( RESOURCE_ASSIGNMENT_ID
373: ,BUDGET_VERSION_ID
374: ,PROJECT_ID
375: ,TASK_ID
518: AND
519: p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag = 'Y'
520: AND
521: l_struct_sharing_code <> 'SHARE_FULL') THEN
522: INSERT INTO PA_FP_CALC_AMT_TMP1
523: ( RESOURCE_ASSIGNMENT_ID
524: ,BUDGET_VERSION_ID
525: ,PROJECT_ID
526: ,TASK_ID
683: /*else part is used when p_calling_context = 'WORK_PLAN'and
684: p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag = 'N' and
685: structure sharing code is not null */
686: --dbms_output.put_line('Value for track_workplan_costs_flag:' || p_fp_cols_rec_etc_wp.x_track_workplan_costs_flag);
687: INSERT INTO PA_FP_CALC_AMT_TMP1
688: ( RESOURCE_ASSIGNMENT_ID
689: ,BUDGET_VERSION_ID
690: ,PROJECT_ID
691: ,TASK_ID
795: INTO l_res_asg_id_tab,
796: l_start_date_tab,
797: l_end_date_tab,
798: l_res_list_member_id_tab /* Bug 4070849 */
799: FROM pa_fp_calc_amt_tmp1
800: WHERE NVL(mapped_fin_task_id,0) = p_task_id;
801:
802: --dbms_output.put_line('Count value for l_res_asg_id_tab : '||l_res_asg_id_tab.count );
803:
2348: *Scenario: Other sources (Actual or commitment etc): Rate-based;
2349: * Generated amount from main source: Non rate-based
2350: *Strategy: Only take amount from other sources. Need to convert
2351: * the rate-based flag of the actual to be non rate-based.
2352: *Implementation: parse pa_fp_calc_amt_tmp1 table to check each target
2353: * resource assignment,for each rate based target res asg,
2354: * as long as there exists one source res asg with rate
2355: * based flag of 'N', target res asg will be updated to
2356: * non rate based. And for this target res asg, all existing
2384: END IF;
2385: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2386:
2387: -- Bug 4170419 : Start
2388: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2389: -- DISTINCT target_res_asg_id
2390: --BULK COLLECT
2391: --INTO l_tgt_res_asg_tab
2392: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2388: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2389: -- DISTINCT target_res_asg_id
2390: --BULK COLLECT
2391: --INTO l_tgt_res_asg_tab
2392: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2393: --WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2394: -- AND ra.rate_based_flag = 'Y'
2395: -- AND tmp.rate_based_flag = 'N';
2396: l_bv_id := p_fp_cols_rec.x_budget_version_id;
2403: SELECT /*+ LEADING(tmp) */
2404: DISTINCT target_res_asg_id
2405: BULK COLLECT
2406: INTO l_tgt_res_asg_tab
2407: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2408: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2409: AND ra.rate_based_flag = 'Y'
2410: AND tmp.rate_based_flag = 'N';
2411:
2420: SELECT /*+ LEADING(tmp) */
2421: DISTINCT target_res_asg_id
2422: BULK COLLECT
2423: INTO l_tgt_res_asg_tab
2424: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2425: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2426: AND ra.rate_based_flag = 'Y'
2427: AND tmp.rate_based_flag = 'N'
2428: AND ( ra.transaction_source_code is not null
2442: SELECT /*+ LEADING(tmp) */
2443: DISTINCT target_res_asg_id
2444: BULK COLLECT
2445: INTO l_tgt_res_asg_tab
2446: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2447: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2448: AND ra.rate_based_flag = 'Y'
2449: AND tmp.rate_based_flag = 'N'
2450: AND ( ra.transaction_source_code is not null