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 6981: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(

6977: pa_debug.g_err_stage := 'Fetching baselined cost plan version';
6978: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
6979: END IF;
6980:
6981: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
6982: p_project_id => p_source_project_id
6983: ,p_fin_plan_type_id => l_fin_plan_type_id
6984: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
6985: ,x_fp_options_id => l_fp_options_id

Line 7004: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(

7000: pa_debug.g_err_stage := 'Fetching current cost woking plan version if any';
7001: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7002: END IF;
7003:
7004: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(
7005: p_project_id => p_source_project_id
7006: ,p_fin_plan_type_id => l_fin_plan_type_id
7007: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
7008: ,x_fp_options_id => l_fp_options_id

Line 7039: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(

7035: pa_debug.g_err_stage := 'Fetching baselined revenue plan version';
7036: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7037: END IF;
7038:
7039: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
7040: p_project_id => p_source_project_id
7041: ,p_fin_plan_type_id => l_fin_plan_type_id
7042: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
7043: ,x_fp_options_id => l_fp_options_id

Line 7062: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(

7058: pa_debug.g_err_stage := 'Fetching current revenue woking plan version if any';
7059: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7060: END IF;
7061:
7062: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(
7063: p_project_id => p_source_project_id
7064: ,p_fin_plan_type_id => l_fin_plan_type_id
7065: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
7066: ,x_fp_options_id => l_fp_options_id

Line 7101: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(

7097: pa_debug.g_err_stage := 'Fetching baselined plan version if any';
7098: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7099: END IF;
7100:
7101: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
7102: p_project_id => p_source_project_id
7103: ,p_fin_plan_type_id => l_fin_plan_type_id
7104: ,p_version_type => NULL
7105: ,x_fp_options_id => l_fp_options_id

Line 7124: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(

7120: pa_debug.g_err_stage := 'Fetching current woking plan version if any';
7121: pa_debug.write( g_module_name,pa_debug.g_err_stage,3);
7122: END IF;
7123:
7124: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(
7125: p_project_id => p_source_project_id
7126: ,p_fin_plan_type_id => l_fin_plan_type_id
7127: ,p_version_type => NULL
7128: ,x_fp_options_id => l_fp_options_id

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

7392: END IF;
7393:
7394: --Fetch the target versions time phased code
7395:
7396: l_target_time_phased_code := PA_FIN_PLAN_UTILS.get_time_phased_code(p_target_plan_version_id);
7397: l_target_budget_entry_level := PA_FIN_PLAN_UTILS.get_fin_plan_level_code(p_target_plan_version_id); /*bug2726011*/
7398:
7399: IF P_PA_DEBUG_MODE = 'Y' THEN
7400: pa_debug.g_err_stage:='Time Phased Code ='|| l_target_time_phased_code;

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

7393:
7394: --Fetch the target versions time phased code
7395:
7396: l_target_time_phased_code := PA_FIN_PLAN_UTILS.get_time_phased_code(p_target_plan_version_id);
7397: l_target_budget_entry_level := PA_FIN_PLAN_UTILS.get_fin_plan_level_code(p_target_plan_version_id); /*bug2726011*/
7398:
7399: IF P_PA_DEBUG_MODE = 'Y' THEN
7400: pa_debug.g_err_stage:='Time Phased Code ='|| l_target_time_phased_code;
7401: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);

Line 8537: PA_FIN_PLAN_UTILS.Get_Shifted_Period (

8533: pa_debug.g_err_stage:= 'Calling get_Shifted_period';
8534: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8535: END IF;
8536:
8537: PA_FIN_PLAN_UTILS.Get_Shifted_Period (
8538: p_period_name => l_start_period
8539: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8540: ,p_number_of_periods => (source_profile_info_rec.number_of_periods -1)
8541: ,x_shifted_period => l_end_period

Line 8566: PA_FIN_PLAN_UTILS.Get_Period_Details(

8562: l_end_period := l_target_proj_end_period;
8563:
8564: -- Fetch the end date of the above period
8565:
8566: PA_FIN_PLAN_UTILS.Get_Period_Details(
8567: p_period_name => l_end_period
8568: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8569: ,x_start_date => l_end_period_start_date
8570: ,x_end_date => l_end_period_end_date

Line 8578: PA_FIN_PLAN_UTILS.Get_Shifted_Period (

8574:
8575: -- Fetch the start period of the target period profile by moving backward from the end period
8576: -- by the number of periods of the source period profile
8577:
8578: PA_FIN_PLAN_UTILS.Get_Shifted_Period (
8579: p_period_name => l_end_period
8580: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8581: ,p_number_of_periods => (-source_profile_info_rec.number_of_periods+1)
8582: ,x_shifted_period => l_start_period

Line 8599: Pa_Fin_Plan_Utils.Get_Period_Details(

8595:
8596: -- If the fetched start period doesn't fall in the project duration, then
8597: -- set the project start period as the period profile start period
8598:
8599: Pa_Fin_Plan_Utils.Get_Period_Details(
8600: p_period_name => l_start_period
8601: ,p_plan_period_type => source_profile_info_rec.plan_period_type
8602: ,x_start_date => l_start_period_start_date
8603: ,x_end_date => l_start_period_end_date

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

8926: l_src_budget_version_id := PA_PLANNING_TRANSACTION_UTILS.Get_Wp_Budget_Version_Id(p_src_sv_ids_tbl(i));
8927:
8928: IF p_source_project_id <> p_target_project_id THEN
8929:
8930: --l_src_resource_list_id := pa_fin_plan_utils.get_resource_list_id(l_src_budget_version_id); //Commented out for bug 4200168.
8931: --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.
8932: l_adj_percentage:= 0.9999;
8933: ELSE
8934:

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

8931: --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.
8932: l_adj_percentage:= 0.9999;
8933: ELSE
8934:
8935: --l_src_resource_list_id := pa_fin_plan_utils.get_resource_list_id(l_src_budget_version_id); //Commented out for bug 4200168.
8936: --l_targ_resource_list_id := l_src_resource_list_id; //Commented out for bug 4200168.
8937: l_adj_percentage:= 0;
8938: END IF;
8939: