[Home] [Help]
1879: from pa_fp_planning_transaction_pub.copy_planning_transactions.This API will be used
1880: to populate the global temporary table PA_FP_RA_MAP_TEMP which will be used for
1881: the creation of target resource assignment records.
1882:
1883: New columns in pa_fp_ra_map_tmp that will be used for FP M are given below
1884: planning_start_Date -> planning_start_date for target resource assignment id
1885: planning_end_Date -> planning_end_date for target resource assignment id
1886: schedule_start_Date -> schedule_start_date for target resource assignment id .. For TA specifically..
1887: schedule_end_Date -> schedule_end_date for target resource assignment id .. For TA specifically..
2026: pa_debug.g_err_stage:='About to create the mapping between source and target element version ids';
2027: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
2028: END IF;
2029:
2030: DELETE FROM pa_fp_ra_map_tmp;
2031:
2032:
2033: --When p_context is BUDGET then the copy will not happen accorss projects. The task id in the source and
2034: --target would be same for the corresponding resource assignments. Hence the FOR loop which creates the tbl
2074:
2075: END IF;--IF NVL(p_context,'-99')<>'BUDGET' THEN
2076:
2077: IF l_debug_mode = 'Y' THEN
2078: pa_debug.g_err_stage:='About to bulk insert into pa_fp_ra_map_tmp';
2079: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
2080: END IF;
2081:
2082: --Bulk insert into the pa_fp_ra_map_tmp table
2078: pa_debug.g_err_stage:='About to bulk insert into pa_fp_ra_map_tmp';
2079: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
2080: END IF;
2081:
2082: --Bulk insert into the pa_fp_ra_map_tmp table
2083:
2084: -- Bug 4187294: performance fix-splitting the below insert into 2 statments
2085: -- depending upon the context to avoid inner decode statements
2086:
2085: -- depending upon the context to avoid inner decode statements
2086:
2087: IF p_context = 'BUDGET' THEN
2088: FORALL i in p_src_ra_id_tbl.first..p_src_ra_id_tbl.last
2089: INSERT INTO pa_fp_ra_map_tmp
2090: ( source_res_assignment_id
2091: ,target_res_assignment_id
2092: ,source_task_id
2093: ,target_task_id
2118:
2119: --Bug 4187294: Removed the calls to get_mapped_id.Used the pl/sql tbl l_targ_elem_ver_id_tbl
2120: --derived above.
2121: FORALL i in p_src_ra_id_tbl.first..p_src_ra_id_tbl.last
2122: INSERT INTO pa_fp_ra_map_tmp
2123: ( source_res_assignment_id
2124: ,target_res_assignment_id
2125: ,source_task_id
2126: ,target_task_id
2226:
2227: 5/13/2004 Raja FP M IB2 changes Bug 3615617
2228: Logic to derive target resource list memer id has been moved to
2229: create_res_task_maps api. Target resource list member id is part
2230: of pa_fp_ra_map_tmp table. System_reference4 column has the value.
2231:
2232: --Added parameter p_rbs_map_diff_flag for Bug 3974569. This parameter can be passed as Y if the RBS mapping of
2233: --the target resource assignments is different from that of the source resource assignments.If this is passed as Y then
2234: ---->1.copy resource assignments will look at pa_rbs_plans_out_tmp table for rbs_element_id and txn_accum_header_id
2235: ---->of target resource assignments and it assumes that source_id in pa_rbs_plans_out_tmp corresponds to the
2236: ----> resource_assignment_id in the source budget version.
2237:
2238: --Bug 3948128. Included scheduled_delay in the list of columns that would get copied.
2239: --Bug 4200168: Changed the logic so that the copy is not based on pa_fp_ra_map_tmp when
2240: --the API is called for copying resource assignments between budget versions
2241: ===========================================================================*/
2242:
2243: PROCEDURE Copy_Resource_Assignments(
2362: pa_debug.g_err_stage:='l_target_project_id ='||l_target_project_id;
2363: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2364: END IF;
2365: */
2366: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp
2367:
2368: IF P_PA_DEBUG_MODE = 'Y' THEN
2369: pa_debug.g_err_stage:='Copying the source version records as target version records';
2370: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2632: ,pra.named_role
2633: ,pra.txn_accum_header_id
2634: ,scheduled_delay --For Bug 3948128
2635: ,pra.CBS_ELEMENT_ID -- bug#16200605
2636: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
2637: ,PA_RESOURCE_ASSIGNMENTS pra
2638: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2639: AND pra.budget_version_id = p_source_plan_version_id ;
2640:
2650:
2651:
2652: SELECT COUNT(*)
2653: INTO l_tmp
2654: FROM PA_FP_RA_MAP_TMP;
2655:
2656: pa_debug.g_err_stage:='PA_FP_RA_MAP_TMP count '||l_tmp;
2657: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2658:
2652: SELECT COUNT(*)
2653: INTO l_tmp
2654: FROM PA_FP_RA_MAP_TMP;
2655:
2656: pa_debug.g_err_stage:='PA_FP_RA_MAP_TMP count '||l_tmp;
2657: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2658:
2659: SELECT COUNT(*)
2660: INTO l_tmp
2912: ,pra.named_role
2913: ,rmap.txn_accum_header_id
2914: ,scheduled_delay --For Bug 3948128,
2915: ,pra.CBS_ELEMENT_ID -- bug#16200605
2916: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
2917: ,PA_RESOURCE_ASSIGNMENTS pra
2918: ,pa_rbs_plans_out_tmp rmap
2919: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2920: AND pra.budget_version_id = p_source_plan_version_id
5528: ,fnd_global.user_id
5529: ,fnd_global.login_id
5530: ,pfrmt.parent_assignment_id --parent_assignment_id
5531: FROM PA_PROJ_PERIODS_DENORM pppd
5532: ,PA_FP_RA_MAP_TMP pfrmt
5533: WHERE budget_version_id = p_source_plan_version_id
5534: AND pppd.resource_assignment_id = pfrmt.source_res_assignment_id
5535: AND pppd.object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT
5536: AND pppd.amount_type_code <> l_ignore_amount_type;
9241: END IF;
9242: END IF;
9243:
9244: PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api
9245: ( p_source => 'PA_FP_RA_MAP_TMP'
9246: ,p_budget_version_id => l_targ_budget_version_id
9247: ,x_return_status => x_return_status
9248: ,x_msg_data => x_msg_data
9249: ,x_msg_count => x_msg_count);
9325: 3) For the DFF attributes, change reason and description, copy the attributes if any of the source lines for the
9326: given resource_assignment_id and start_date combination has the transaction currency same as the project
9327: functional currency. If not, then copy the attributes from the first listed source line,
9328: ordering by transaction currency.
9329: 4) This api is dependant on PA_FP_RA_MAP_TMP being populated before it is called and it populates
9330: PA_FP_BL_MAP_TMP on which the api COPY_MC_BUDGET_LINES_APPR_REV would be dependant.
9331: =========================================================================*/
9332:
9333: --Bug 4290043. Added p_derv_rates_missing_amts_flag to indicate whether the missing amounts in the target version