APPS.PA_FP_COPY_FROM_PKG dependencies on PA_FP_BL_MAP_TMP

Line 5128: --Populate the pa_fp_bl_map_tmp table so that the MRC API can have the mapping readily defined.

5124: pa_debug.g_err_stage:='No. of Budget lines inserted '||l_temp;
5125: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5126: END IF;
5127:
5128: --Populate the pa_fp_bl_map_tmp table so that the MRC API can have the mapping readily defined.
5129: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703
5130: --The below table need not be popluated for worplan versions since MRC is not maintained for
5131: --workplan versions
5132: IF l_wp_version_flag='N' THEN

Line 5129: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703

5125: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5126: END IF;
5127:
5128: --Populate the pa_fp_bl_map_tmp table so that the MRC API can have the mapping readily defined.
5129: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703
5130: --The below table need not be popluated for worplan versions since MRC is not maintained for
5131: --workplan versions
5132: IF l_wp_version_flag='N' THEN
5133:

Line 5134: INSERT INTO pa_fp_bl_map_tmp

5130: --The below table need not be popluated for worplan versions since MRC is not maintained for
5131: --workplan versions
5132: IF l_wp_version_flag='N' THEN
5133:
5134: INSERT INTO pa_fp_bl_map_tmp
5135: (source_budget_line_id,
5136: target_budget_line_id)
5137: SELECT pbls.budget_line_id,
5138: pblt.budget_line_id

Line 9303: PA_FP_BL_MAP_TMP on which the api COPY_MC_BUDGET_LINES_APPR_REV would be dependant.

9299: given resource_assignment_id and start_date combination has the transaction currency same as the project
9300: functional currency. If not, then copy the attributes from the first listed source line,
9301: ordering by transaction currency.
9302: 4) This api is dependant on PA_FP_RA_MAP_TMP being populated before it is called and it populates
9303: PA_FP_BL_MAP_TMP on which the api COPY_MC_BUDGET_LINES_APPR_REV would be dependant.
9304: =========================================================================*/
9305:
9306: --Bug 4290043. Added p_derv_rates_missing_amts_flag to indicate whether the missing amounts in the target version
9307: --should be derived or not after copy

Line 9568: DELETE FROM PA_FP_BL_MAP_TMP;

9564: pa_fin_plan_types_b fin
9565: WHERE pbv.fin_plan_type_id=fin.fin_plan_type_id
9566: AND pbv.budget_version_id = p_source_plan_version_id;
9567:
9568: DELETE FROM PA_FP_BL_MAP_TMP;
9569:
9570: FOR rec_group_source_budget_lines IN cur_group_source_budget_lines LOOP
9571:
9572: -- InitPLSQLTab; ** bug 3709036

Line 9665: INSERT INTO PA_FP_BL_MAP_TMP

9661: l_ref := j;
9662:
9663: END IF;
9664:
9665: INSERT INTO PA_FP_BL_MAP_TMP
9666: ( source_budget_line_id
9667: ,target_budget_line_id
9668: )
9669: VALUES (l_budget_line_idTab(j),