eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_BUDGET_VERSIONS

Line 149: FROM pa_budget_versions

145: plan_type_info_rec plan_type_info_cur%ROWTYPE;
146:
147: CURSOR plan_version_info_cur (c_budget_version_id NUMBER) IS
148: SELECT ci_id
149: FROM pa_budget_versions
150: WHERE budget_version_id = c_budget_version_id;
151:
152: plan_version_info_rec plan_version_info_cur%ROWTYPE;
153:

Line 3631: the columns that are part of both pa_budget_versions and also pa_proj_fp_otions.

3627: should be updated in the budget versions table. This procedure
3628: doesnot do anything if amounts exist for the version.
3629:
3630: Bug 3425122: From plan settings page the api would be called to synchronise
3631: the columns that are part of both pa_budget_versions and also pa_proj_fp_otions.
3632: They are resource_list_id, period_mask_id and current_planning_period.
3633: actual_amts_thru_period is a column present only in budget versions table. So,
3634: only this column is passed and rest of the values should be read from
3635: pa_proj_fp_options table

Line 3642: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3638: all the related existing code
3639: */
3640: procedure SYNCHRONIZE_BUDGET_VERSION
3641: (
3642: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3643: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3644: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3645: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3646: )

Line 3649: l_project_id pa_budget_versions.project_id%TYPE;

3645: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3646: )
3647: IS
3648:
3649: l_project_id pa_budget_versions.project_id%TYPE;
3650: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3651: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
3652: /*
3653: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

Line 3653: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

3649: l_project_id pa_budget_versions.project_id%TYPE;
3650: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3651: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
3652: /*
3653: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3654: l_curr_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3655: l_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3656: l_curr_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3657: l_start_period pa_proj_period_profiles.period_name1%TYPE;

Line 3654: l_curr_period_profile_id pa_budget_versions.period_profile_id%TYPE;

3650: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3651: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
3652: /*
3653: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3654: l_curr_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3655: l_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3656: l_curr_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3657: l_start_period pa_proj_period_profiles.period_name1%TYPE;
3658: l_end_period pa_proj_period_profiles.period_name1%TYPE;

Line 3757: UPDATE pa_budget_versions

3753: -- Updation of current planning period,period mask id and actuals thru period and resource list id is possible always
3754: -- for a working version
3755:
3756: IF (version_option_info_rec.fin_plan_preference_code = 'COST_ONLY') THEN
3757: UPDATE pa_budget_versions
3758: SET current_planning_period = version_option_info_rec.cost_current_planning_period
3759: ,period_mask_id = version_option_info_rec.cost_period_mask_id
3760: --- ,actual_amts_thru_period = p_actual_amts_thru_period
3761: ,resource_list_id = version_option_info_rec.cost_resource_list_id

Line 3765: UPDATE pa_budget_versions

3761: ,resource_list_id = version_option_info_rec.cost_resource_list_id
3762: ,record_version_number = record_version_number + 1
3763: WHERE budget_version_id = p_budget_version_id;
3764: ELSIF (version_option_info_rec.fin_plan_preference_code = 'REVENUE_ONLY') THEN
3765: UPDATE pa_budget_versions
3766: SET current_planning_period = version_option_info_rec.rev_current_planning_period
3767: ,period_mask_id = version_option_info_rec.rev_period_mask_id
3768: --- ,actual_amts_thru_period = p_actual_amts_thru_period
3769: ,resource_list_id = version_option_info_rec.revenue_resource_list_id

Line 3773: UPDATE pa_budget_versions

3769: ,resource_list_id = version_option_info_rec.revenue_resource_list_id
3770: ,record_version_number = record_version_number + 1
3771: WHERE budget_version_id = p_budget_version_id;
3772: ELSIF (version_option_info_rec.fin_plan_preference_code = 'COST_AND_REV_SAME') THEN
3773: UPDATE pa_budget_versions
3774: SET current_planning_period = version_option_info_rec.all_current_planning_period
3775: ,period_mask_id = version_option_info_rec.all_period_mask_id
3776: --- ,actual_amts_thru_period = p_actual_amts_thru_period
3777: ,resource_list_id = version_option_info_rec.all_resource_list_id

Line 3805: from pa_budget_versions

3801: BEGIN
3802:
3803: select period_profile_id,project_id
3804: into l_period_profile_id,l_project_id
3805: from pa_budget_versions
3806: where budget_version_id = p_budget_version_id;
3807:
3808: EXCEPTION
3809:

Line 3900: update pa_budget_versions

3896:
3897: END IF; -- check for period profile id being null.
3898:
3899: IF l_update_flag = 'Y' THEN
3900: update pa_budget_versions
3901: set period_profile_id = l_curr_period_profile_id
3902: where budget_version_id = p_budget_version_id;
3903:
3904: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3963: p_target_version_type IN pa_budget_versions.version_type%TYPE,

3959: Initial Creation
3960: =====================================================================================*/
3961: FUNCTION Gen_Src_Plan_Version_Id(
3962: p_target_project_id IN pa_projects_all.project_id%TYPE,
3963: p_target_version_type IN pa_budget_versions.version_type%TYPE,
3964: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
3965: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
3966: RETURN pa_budget_versions.budget_version_id%TYPE is
3967:

Line 3966: RETURN pa_budget_versions.budget_version_id%TYPE is

3962: p_target_project_id IN pa_projects_all.project_id%TYPE,
3963: p_target_version_type IN pa_budget_versions.version_type%TYPE,
3964: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
3965: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
3966: RETURN pa_budget_versions.budget_version_id%TYPE is
3967:
3968: l_return_status VARCHAR2(2000);
3969: l_msg_count NUMBER := 0;
3970: l_msg_data VARCHAR2(2000);

Line 3979: l_gen_src_plan_version_id pa_budget_versions.budget_version_id%TYPE;

3975: l_data VARCHAR2(2000);
3976: l_debug_mode VARCHAR2(30);
3977:
3978: l_dummy_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3979: l_gen_src_plan_version_id pa_budget_versions.budget_version_id%TYPE;
3980:
3981: CURSOR src_plan_type_info_cur (c_fin_plan_type_id NUMBER, c_project_id NUMBER) IS
3982: SELECT fin_plan_preference_code
3983: FROM pa_proj_fp_options

Line 4211: RETURN pa_budget_versions.budget_version_id%TYPE is

4207: =====================================================================================*/
4208: FUNCTION Gen_Src_WP_Version_Id(
4209: p_target_project_id IN pa_projects_all.project_id%TYPE,
4210: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
4211: RETURN pa_budget_versions.budget_version_id%TYPE is
4212:
4213: l_return_status VARCHAR2(2000);
4214: l_msg_count NUMBER := 0;
4215: l_msg_data VARCHAR2(2000);

Line 4223: l_gen_src_wp_ver_id pa_budget_versions.budget_version_id%TYPE;

4219: l_msg_index_out NUMBER := 0;
4220: l_data VARCHAR2(2000);
4221: l_debug_mode VARCHAR2(30);
4222:
4223: l_gen_src_wp_ver_id pa_budget_versions.budget_version_id%TYPE;
4224:
4225: CURSOR last_published_wp_version_cur IS
4226: select bv.budget_version_id
4227: from pa_budget_versions bv,

Line 4227: from pa_budget_versions bv,

4223: l_gen_src_wp_ver_id pa_budget_versions.budget_version_id%TYPE;
4224:
4225: CURSOR last_published_wp_version_cur IS
4226: select bv.budget_version_id
4227: from pa_budget_versions bv,
4228: pa_proj_elem_ver_structure ver
4229: where bv.project_id = p_target_project_id
4230: and bv.wp_version_flag = 'Y'
4231: and bv.project_id = ver.project_id

Line 4237: from pa_budget_versions bv,

4233: and ver.LATEST_EFF_PUBLISHED_FLAG = 'Y';
4234:
4235: CURSOR baselined_wp_version_cur IS
4236: select bv.budget_version_id
4237: from pa_budget_versions bv,
4238: pa_proj_elem_ver_structure ver
4239: where bv.project_id = p_target_project_id
4240: and bv.wp_version_flag = 'Y'
4241: and bv.project_id = ver.project_id

Line 4247: from pa_budget_versions bv,

4243: and ver.current_baseline_date is not null ;
4244:
4245: CURSOR current_working_wp_version_cur IS
4246: select bv.budget_version_id
4247: from pa_budget_versions bv,
4248: pa_proj_elem_ver_structure ver
4249: where bv.project_id = p_target_project_id
4250: and bv.wp_version_flag = 'Y'
4251: and bv.project_id = ver.project_id