APPS.PA_FIN_PLAN_PUB dependencies on PA_BUDGET_VERSIONS_S

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

3860: /* create the plan version */
3861: IF P_PA_DEBUG_MODE = 'Y' THEN
3862: pa_debug.write_file('Create_Version_OrgFcst: ' || 'calling pa_fp_budget_versions_pkg.Insert_Row to create a budget version');
3863: END IF;
3864: select pa_budget_versions_s.nextVal into l_budget_version_id from dual;
3865: /* the new version is the current working only if it's the ONLY working version */
3866: if (l_max_version = 0) then
3867: l_current_working_flag := 'Y';
3868: else

Line 5981: SELECT pa_budget_versions_s.NEXTVAL

5977: pa_debug.g_err_stage:='Fetching new budget_version_id';
5978: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
5979: END IF;
5980:
5981: SELECT pa_budget_versions_s.NEXTVAL
5982: INTO l_new_budget_version_id
5983: FROM DUAL;
5984: ELSE
5985: l_new_budget_version_id := px_budget_version_id;

Line 6481: UPDATE Pa_Budget_Versions SET

6477: END IF;
6478:
6479: -- Update the budget versions table with the converted estimated amounts in projfunc currency
6480:
6481: UPDATE Pa_Budget_Versions SET
6482: est_projfunc_raw_cost = l_est_projfunc_raw_cost,
6483: est_projfunc_burdened_cost = l_est_projfunc_bd_cost,
6484: est_projfunc_revenue = l_est_projfunc_revenue
6485: WHERE Budget_Version_Id = l_new_budget_version_id;