DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_FP_BL_MAP_TMP

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

5136: pa_debug.g_err_stage:='No. of Budget lines inserted '||l_temp;
5137: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5138: END IF;
5139:
5140: --Populate the pa_fp_bl_map_tmp table so that the MRC API can have the mapping readily defined.
5141: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703
5142: --The below table need not be popluated for worplan versions since MRC is not maintained for
5143: --workplan versions
5144: IF l_wp_version_flag='N' THEN

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

5137: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5138: END IF;
5139:
5140: --Populate the pa_fp_bl_map_tmp table so that the MRC API can have the mapping readily defined.
5141: --The logic of inserting into pa_budget_lines using pa_fp_bl_map_tmp is removed for bug 4224703
5142: --The below table need not be popluated for worplan versions since MRC is not maintained for
5143: --workplan versions
5144: IF l_wp_version_flag='N' THEN
5145:

Line 5146: INSERT INTO pa_fp_bl_map_tmp

5142: --The below table need not be popluated for worplan versions since MRC is not maintained for
5143: --workplan versions
5144: IF l_wp_version_flag='N' THEN
5145:
5146: INSERT INTO pa_fp_bl_map_tmp
5147: (source_budget_line_id,
5148: target_budget_line_id)
5149: SELECT pbls.budget_line_id,
5150: pblt.budget_line_id

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

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
9334: --should be derived or not after copy

Line 9595: DELETE FROM PA_FP_BL_MAP_TMP;

9591: pa_fin_plan_types_b fin
9592: WHERE pbv.fin_plan_type_id=fin.fin_plan_type_id
9593: AND pbv.budget_version_id = p_source_plan_version_id;
9594:
9595: DELETE FROM PA_FP_BL_MAP_TMP;
9596:
9597: FOR rec_group_source_budget_lines IN cur_group_source_budget_lines LOOP
9598:
9599: -- InitPLSQLTab; ** bug 3709036

Line 9692: INSERT INTO PA_FP_BL_MAP_TMP

9688: l_ref := j;
9689:
9690: END IF;
9691:
9692: INSERT INTO PA_FP_BL_MAP_TMP
9693: ( source_budget_line_id
9694: ,target_budget_line_id
9695: )
9696: VALUES (l_budget_line_idTab(j),