DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_FIN_PLAN_UTILS

Line 1255: l_time_phased_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_source_version_id);

1251: IF l_source_project_id <> l_target_project_id THEN
1252:
1253: --Bug 4200168. Call Pa_Prj_Period_Profile_Utils.Get_Prj_Defaults only if source
1254: --current planning period is not null and target time phased code is P or G.
1255: l_time_phased_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_source_version_id);
1256: IF ( (l_time_phased_code = 'P' OR l_time_phased_code = 'G') AND l_source_cur_planning_period IS NOT NULL) THEN
1257: Pa_Prj_Period_Profile_Utils.Get_Prj_Defaults(
1258: p_project_id => p_target_project_id
1259: ,p_info_flag => 'ALL'

Line 1272: --l_time_phased_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_source_version_id);

1268: ,x_prj_start_date => l_prj_start_date
1269: ,x_prj_end_date => l_prj_end_date );
1270: END IF;
1271:
1272: --l_time_phased_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_source_version_id);
1273:
1274: IF l_source_cur_planning_period IS NOT NULL THEN
1275:
1276: IF l_time_phased_code = 'P' THEN

Line 1306: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number

1302: WHERE project_id = l_project_id
1303: AND fin_plan_type_id = l_fin_plan_type_id
1304: AND budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING,
1305: PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED); */
1306: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number
1307: (p_project_id => l_target_project_id
1308: ,p_fin_plan_type_id => l_fin_plan_type_id
1309: ,p_version_type => l_version_type
1310: ,p_copy_mode => PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING

Line 1357: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number

1353: AND fin_plan_type_id = l_fin_plan_type_id
1354: AND budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED;
1355: */
1356:
1357: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number
1358: (p_project_id => l_target_project_id
1359: ,p_fin_plan_type_id => l_fin_plan_type_id
1360: ,p_version_type => l_version_type
1361: ,p_copy_mode => PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED

Line 6998: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(

6994: pa_debug.g_err_stage := 'Fetching baselined cost plan version';
6995: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
6996: END IF;
6997:
6998: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
6999: p_project_id => p_source_project_id
7000: ,p_fin_plan_type_id => l_fin_plan_type_id
7001: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
7002: ,x_fp_options_id => l_fp_options_id

Line 7021: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(

7017: pa_debug.g_err_stage := 'Fetching current cost woking plan version if any';
7018: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7019: END IF;
7020:
7021: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(
7022: p_project_id => p_source_project_id
7023: ,p_fin_plan_type_id => l_fin_plan_type_id
7024: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
7025: ,x_fp_options_id => l_fp_options_id

Line 7056: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(

7052: pa_debug.g_err_stage := 'Fetching baselined revenue plan version';
7053: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7054: END IF;
7055:
7056: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
7057: p_project_id => p_source_project_id
7058: ,p_fin_plan_type_id => l_fin_plan_type_id
7059: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
7060: ,x_fp_options_id => l_fp_options_id

Line 7079: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(

7075: pa_debug.g_err_stage := 'Fetching current revenue woking plan version if any';
7076: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7077: END IF;
7078:
7079: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(
7080: p_project_id => p_source_project_id
7081: ,p_fin_plan_type_id => l_fin_plan_type_id
7082: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
7083: ,x_fp_options_id => l_fp_options_id

Line 7118: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(

7114: pa_debug.g_err_stage := 'Fetching baselined plan version if any';
7115: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7116: END IF;
7117:
7118: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
7119: p_project_id => p_source_project_id
7120: ,p_fin_plan_type_id => l_fin_plan_type_id
7121: ,p_version_type => NULL
7122: ,x_fp_options_id => l_fp_options_id

Line 7141: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(

7137: pa_debug.g_err_stage := 'Fetching current woking plan version if any';
7138: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7139: END IF;
7140:
7141: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(
7142: p_project_id => p_source_project_id
7143: ,p_fin_plan_type_id => l_fin_plan_type_id
7144: ,p_version_type => NULL
7145: ,x_fp_options_id => l_fp_options_id

Line 7415: l_target_time_phased_code := PA_FIN_PLAN_UTILS.get_time_phased_code(p_target_plan_version_id);

7411: END IF;
7412:
7413: --Fetch the target versions time phased code
7414:
7415: l_target_time_phased_code := PA_FIN_PLAN_UTILS.get_time_phased_code(p_target_plan_version_id);
7416: l_target_budget_entry_level := PA_FIN_PLAN_UTILS.get_fin_plan_level_code(p_target_plan_version_id); /*bug2726011*/
7417:
7418: IF P_PA_DEBUG_MODE = 'Y' THEN
7419: pa_debug.g_err_stage:='Time Phased Code ='|| l_target_time_phased_code;

Line 7416: l_target_budget_entry_level := PA_FIN_PLAN_UTILS.get_fin_plan_level_code(p_target_plan_version_id); /*bug2726011*/

7412:
7413: --Fetch the target versions time phased code
7414:
7415: l_target_time_phased_code := PA_FIN_PLAN_UTILS.get_time_phased_code(p_target_plan_version_id);
7416: l_target_budget_entry_level := PA_FIN_PLAN_UTILS.get_fin_plan_level_code(p_target_plan_version_id); /*bug2726011*/
7417:
7418: IF P_PA_DEBUG_MODE = 'Y' THEN
7419: pa_debug.g_err_stage:='Time Phased Code ='|| l_target_time_phased_code;
7420: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);

Line 8564: PA_FIN_PLAN_UTILS.Get_Shifted_Period (

8560: pa_debug.g_err_stage:= 'Calling get_Shifted_period';
8561: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8562: END IF;
8563:
8564: PA_FIN_PLAN_UTILS.Get_Shifted_Period (
8565: p_period_name => l_start_period
8566: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8567: ,p_number_of_periods => (source_profile_info_rec.number_of_periods -1)
8568: ,x_shifted_period => l_end_period

Line 8593: PA_FIN_PLAN_UTILS.Get_Period_Details(

8589: l_end_period := l_target_proj_end_period;
8590:
8591: -- Fetch the end date of the above period
8592:
8593: PA_FIN_PLAN_UTILS.Get_Period_Details(
8594: p_period_name => l_end_period
8595: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8596: ,x_start_date => l_end_period_start_date
8597: ,x_end_date => l_end_period_end_date

Line 8605: PA_FIN_PLAN_UTILS.Get_Shifted_Period (

8601:
8602: -- Fetch the start period of the target period profile by moving backward from the end period
8603: -- by the number of periods of the source period profile
8604:
8605: PA_FIN_PLAN_UTILS.Get_Shifted_Period (
8606: p_period_name => l_end_period
8607: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8608: ,p_number_of_periods => (-source_profile_info_rec.number_of_periods+1)
8609: ,x_shifted_period => l_start_period

Line 8626: Pa_Fin_Plan_Utils.Get_Period_Details(

8622:
8623: -- If the fetched start period doesn't fall in the project duration, then
8624: -- set the project start period as the period profile start period
8625:
8626: Pa_Fin_Plan_Utils.Get_Period_Details(
8627: p_period_name => l_start_period
8628: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8629: ,x_start_date => l_start_period_start_date
8630: ,x_end_date => l_start_period_end_date

Line 8957: --l_src_resource_list_id := pa_fin_plan_utils.get_resource_list_id(l_src_budget_version_id); //Commented out for bug 4200168.

8953: l_src_budget_version_id := PA_PLANNING_TRANSACTION_UTILS.Get_Wp_Budget_Version_Id(p_src_sv_ids_tbl(i));
8954:
8955: IF p_source_project_id <> p_target_project_id THEN
8956:
8957: --l_src_resource_list_id := pa_fin_plan_utils.get_resource_list_id(l_src_budget_version_id); //Commented out for bug 4200168.
8958: --l_targ_resource_list_id := l_src_resource_list_id;--RESOURCE FOUNDATION api TO GET THE TARGET RESOURCE LIST ID; //Commented out for bug 4200168.
8959: l_adj_percentage:= 0.9999;
8960: ELSE
8961:

Line 8962: --l_src_resource_list_id := pa_fin_plan_utils.get_resource_list_id(l_src_budget_version_id); //Commented out for bug 4200168.

8958: --l_targ_resource_list_id := l_src_resource_list_id;--RESOURCE FOUNDATION api TO GET THE TARGET RESOURCE LIST ID; //Commented out for bug 4200168.
8959: l_adj_percentage:= 0.9999;
8960: ELSE
8961:
8962: --l_src_resource_list_id := pa_fin_plan_utils.get_resource_list_id(l_src_budget_version_id); //Commented out for bug 4200168.
8963: --l_targ_resource_list_id := l_src_resource_list_id; //Commented out for bug 4200168.
8964: l_adj_percentage:= 0;
8965: END IF;
8966: