APPS.PA_FIN_PLAN_PUB dependencies on PA_BUDGET_VERSIONS_S

Line 3880: select pa_budget_versions_s.nextVal into l_budget_version_id from dual;

3876: /* create the plan version */
3877: IF P_PA_DEBUG_MODE = 'Y' THEN
3878: pa_debug.write_file('Create_Version_OrgFcst: ' || 'calling pa_fp_budget_versions_pkg.Insert_Row to create a budget version');
3879: END IF;
3880: select pa_budget_versions_s.nextVal into l_budget_version_id from dual;
3881: /* the new version is the current working only if it's the ONLY working version */
3882: if (l_max_version = 0) then
3883: l_current_working_flag := 'Y';
3884: else

Line 5998: SELECT pa_budget_versions_s.NEXTVAL

5994: pa_debug.g_err_stage:='Fetching new budget_version_id';
5995: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
5996: END IF;
5997:
5998: SELECT pa_budget_versions_s.NEXTVAL
5999: INTO l_new_budget_version_id
6000: FROM DUAL;
6001: ELSE
6002: l_new_budget_version_id := px_budget_version_id;

Line 6501: UPDATE Pa_Budget_Versions SET

6497: END IF;
6498:
6499: -- Update the budget versions table with the converted estimated amounts in projfunc currency
6500:
6501: UPDATE Pa_Budget_Versions SET
6502: est_projfunc_raw_cost = l_est_projfunc_raw_cost,
6503: est_projfunc_burdened_cost = l_est_projfunc_bd_cost,
6504: est_projfunc_revenue = l_est_projfunc_revenue
6505: WHERE Budget_Version_Id = l_new_budget_version_id;