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 3676: the columns that are part of both pa_budget_versions and also pa_proj_fp_otions.

3672: should be updated in the budget versions table. This procedure
3673: doesnot do anything if amounts exist for the version.
3674:
3675: Bug 3425122: From plan settings page the api would be called to synchronise
3676: the columns that are part of both pa_budget_versions and also pa_proj_fp_otions.
3677: They are resource_list_id, period_mask_id and current_planning_period.
3678: actual_amts_thru_period is a column present only in budget versions table. So,
3679: only this column is passed and rest of the values should be read from
3680: pa_proj_fp_options table

Line 3687: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3683: all the related existing code
3684: */
3685: procedure SYNCHRONIZE_BUDGET_VERSION
3686: (
3687: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3688: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3689: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3690: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3691: )

Line 3694: l_project_id pa_budget_versions.project_id%TYPE;

3690: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3691: )
3692: IS
3693:
3694: l_project_id pa_budget_versions.project_id%TYPE;
3695: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3696: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
3697: /*
3698: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

Line 3698: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

3694: l_project_id pa_budget_versions.project_id%TYPE;
3695: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3696: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
3697: /*
3698: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3699: l_curr_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3700: l_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3701: l_curr_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3702: l_start_period pa_proj_period_profiles.period_name1%TYPE;

Line 3699: l_curr_period_profile_id pa_budget_versions.period_profile_id%TYPE;

3695: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3696: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
3697: /*
3698: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3699: l_curr_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3700: l_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3701: l_curr_period_type pa_proj_period_profiles.plan_period_type%TYPE;
3702: l_start_period pa_proj_period_profiles.period_name1%TYPE;
3703: l_end_period pa_proj_period_profiles.period_name1%TYPE;

Line 3802: UPDATE pa_budget_versions

3798: -- Updation of current planning period,period mask id and actuals thru period and resource list id is possible always
3799: -- for a working version
3800:
3801: IF (version_option_info_rec.fin_plan_preference_code = 'COST_ONLY') THEN
3802: UPDATE pa_budget_versions
3803: SET current_planning_period = version_option_info_rec.cost_current_planning_period
3804: ,period_mask_id = version_option_info_rec.cost_period_mask_id
3805: --- ,actual_amts_thru_period = p_actual_amts_thru_period
3806: ,resource_list_id = version_option_info_rec.cost_resource_list_id

Line 3810: UPDATE pa_budget_versions

3806: ,resource_list_id = version_option_info_rec.cost_resource_list_id
3807: ,record_version_number = record_version_number + 1
3808: WHERE budget_version_id = p_budget_version_id;
3809: ELSIF (version_option_info_rec.fin_plan_preference_code = 'REVENUE_ONLY') THEN
3810: UPDATE pa_budget_versions
3811: SET current_planning_period = version_option_info_rec.rev_current_planning_period
3812: ,period_mask_id = version_option_info_rec.rev_period_mask_id
3813: --- ,actual_amts_thru_period = p_actual_amts_thru_period
3814: ,resource_list_id = version_option_info_rec.revenue_resource_list_id

Line 3818: UPDATE pa_budget_versions

3814: ,resource_list_id = version_option_info_rec.revenue_resource_list_id
3815: ,record_version_number = record_version_number + 1
3816: WHERE budget_version_id = p_budget_version_id;
3817: ELSIF (version_option_info_rec.fin_plan_preference_code = 'COST_AND_REV_SAME') THEN
3818: UPDATE pa_budget_versions
3819: SET current_planning_period = version_option_info_rec.all_current_planning_period
3820: ,period_mask_id = version_option_info_rec.all_period_mask_id
3821: --- ,actual_amts_thru_period = p_actual_amts_thru_period
3822: ,resource_list_id = version_option_info_rec.all_resource_list_id

Line 3850: from pa_budget_versions

3846: BEGIN
3847:
3848: select period_profile_id,project_id
3849: into l_period_profile_id,l_project_id
3850: from pa_budget_versions
3851: where budget_version_id = p_budget_version_id;
3852:
3853: EXCEPTION
3854:

Line 3945: update pa_budget_versions

3941:
3942: END IF; -- check for period profile id being null.
3943:
3944: IF l_update_flag = 'Y' THEN
3945: update pa_budget_versions
3946: set period_profile_id = l_curr_period_profile_id
3947: where budget_version_id = p_budget_version_id;
3948:
3949: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4008: p_target_version_type IN pa_budget_versions.version_type%TYPE,

4004: Initial Creation
4005: =====================================================================================*/
4006: FUNCTION Gen_Src_Plan_Version_Id(
4007: p_target_project_id IN pa_projects_all.project_id%TYPE,
4008: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4009: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
4010: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
4011: RETURN pa_budget_versions.budget_version_id%TYPE is
4012:

Line 4011: RETURN pa_budget_versions.budget_version_id%TYPE is

4007: p_target_project_id IN pa_projects_all.project_id%TYPE,
4008: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4009: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
4010: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
4011: RETURN pa_budget_versions.budget_version_id%TYPE is
4012:
4013: l_return_status VARCHAR2(2000);
4014: l_msg_count NUMBER := 0;
4015: l_msg_data VARCHAR2(2000);

Line 4024: l_gen_src_plan_version_id pa_budget_versions.budget_version_id%TYPE;

4020: l_data VARCHAR2(2000);
4021: l_debug_mode VARCHAR2(30);
4022:
4023: l_dummy_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4024: l_gen_src_plan_version_id pa_budget_versions.budget_version_id%TYPE;
4025:
4026: CURSOR src_plan_type_info_cur (c_fin_plan_type_id NUMBER, c_project_id NUMBER) IS
4027: SELECT fin_plan_preference_code
4028: FROM pa_proj_fp_options

Line 4256: RETURN pa_budget_versions.budget_version_id%TYPE is

4252: =====================================================================================*/
4253: FUNCTION Gen_Src_WP_Version_Id(
4254: p_target_project_id IN pa_projects_all.project_id%TYPE,
4255: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
4256: RETURN pa_budget_versions.budget_version_id%TYPE is
4257:
4258: l_return_status VARCHAR2(2000);
4259: l_msg_count NUMBER := 0;
4260: l_msg_data VARCHAR2(2000);

Line 4268: l_gen_src_wp_ver_id pa_budget_versions.budget_version_id%TYPE;

4264: l_msg_index_out NUMBER := 0;
4265: l_data VARCHAR2(2000);
4266: l_debug_mode VARCHAR2(30);
4267:
4268: l_gen_src_wp_ver_id pa_budget_versions.budget_version_id%TYPE;
4269:
4270: CURSOR last_published_wp_version_cur IS
4271: select bv.budget_version_id
4272: from pa_budget_versions bv,

Line 4272: from pa_budget_versions bv,

4268: l_gen_src_wp_ver_id pa_budget_versions.budget_version_id%TYPE;
4269:
4270: CURSOR last_published_wp_version_cur IS
4271: select bv.budget_version_id
4272: from pa_budget_versions bv,
4273: pa_proj_elem_ver_structure ver
4274: where bv.project_id = p_target_project_id
4275: and bv.wp_version_flag = 'Y'
4276: and bv.project_id = ver.project_id

Line 4282: from pa_budget_versions bv,

4278: and ver.LATEST_EFF_PUBLISHED_FLAG = 'Y';
4279:
4280: CURSOR baselined_wp_version_cur IS
4281: select bv.budget_version_id
4282: from pa_budget_versions bv,
4283: pa_proj_elem_ver_structure ver
4284: where bv.project_id = p_target_project_id
4285: and bv.wp_version_flag = 'Y'
4286: and bv.project_id = ver.project_id

Line 4292: from pa_budget_versions bv,

4288: and ver.current_baseline_date is not null ;
4289:
4290: CURSOR current_working_wp_version_cur IS
4291: select bv.budget_version_id
4292: from pa_budget_versions bv,
4293: pa_proj_elem_ver_structure ver
4294: where bv.project_id = p_target_project_id
4295: and bv.wp_version_flag = 'Y'
4296: and bv.project_id = ver.project_id