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_FP_ORG_FCST_GEN_PUB dependencies on PA_BUDGET_VERSIONS

Line 40: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

36: g_module_name VARCHAR2(100):= 'pa.plsql.pa_fp_org_fcst_gen_pub';
37: g_plsql_max_array_size NUMBER := 200;
38:
39: FUNCTION budget_version_in_error
40: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
41: ) RETURN NUMBER IS
42:
43: BEGIN
44:

Line 45: UPDATE pa_budget_versions

41: ) RETURN NUMBER IS
42:
43: BEGIN
44:
45: UPDATE pa_budget_versions
46: SET plan_processing_code = 'E'
47: WHERE budget_version_id = p_budget_version_id;
48:
49: COMMIT;

Line 150: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

146: ,p_is_start_org IN VARCHAR2
147: := NULL
148: ,p_starting_organization_id IN hr_organization_units.organization_id%TYPE
149: := NULL
150: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
151: := NULL)
152: IS
153:
154: /* Local Variables */

Line 193: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

189:
190: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
191: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
192: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
193: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;

Line 194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

190: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
191: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
192: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
193: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;

Line 195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

191: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
192: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
193: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;
199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;

Line 196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;

192: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
193: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;
199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;
200: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

Line 197: l_bv_version_number pa_budget_versions.version_number%TYPE;

193: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;
199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;
200: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
201: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

Line 198: l_bv_version_name pa_budget_versions.version_name%TYPE;

194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;
199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;
200: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
201: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
202: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;

Line 199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;

195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;
199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;
200: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
201: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
202: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
203: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;

Line 200: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;
197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;
199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;
200: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
201: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
202: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
203: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
204: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;

Line 201: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

197: l_bv_version_number pa_budget_versions.version_number%TYPE;
198: l_bv_version_name pa_budget_versions.version_name%TYPE;
199: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;
200: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
201: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
202: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
203: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
204: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
205: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;

Line 1539: FROM pa_budget_versions bv

1535: SELECT nvl(max(bv.version_number),0) + 1,
1536: DECODE(nvl(max(bv.version_number),0) + 1,1,'Y','N')
1537: INTO l_bv_version_number
1538: ,l_current_working_flag
1539: FROM pa_budget_versions bv
1540: WHERE bv.project_id = l_project_id
1541: AND bv.fin_plan_type_id = l_fin_plan_type_id
1542: AND bv.budget_status_code in ('W','S');
1543:

Line 1712: FROM pa_budget_versions bv,

1708: l_bv_rec_ver_num,
1709: l_period_profile_id,
1710: l_organization_id,
1711: l_org_projfunc_currency_code
1712: FROM pa_budget_versions bv,
1713: pa_projects pa
1714: WHERE bv.budget_version_id = p_budget_version_id
1715: AND pa.project_id = bv.project_id;
1716:

Line 1849: UPDATE pa_budget_versions

1845: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1846: END IF;
1847: l_stage := 4900;
1848: -- hr_utility.trace(to_char(l_stage));
1849: UPDATE pa_budget_versions
1850: SET
1851: version_name = DECODE(version_name,null,l_bv_version_name
1852: ||'-'||to_char(l_budget_version_id),
1853: version_name)

Line 3765: UPDATE pa_budget_versions

3761: IF P_PA_DEBUG_MODE = 'Y' THEN
3762: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3763: END IF;
3764:
3765: UPDATE pa_budget_versions
3766: SET
3767: record_version_number = record_version_number+1
3768: ,version_name = DECODE(version_name,null,l_bv_version_name
3769: ||'-'||to_char(l_budget_version_id),

Line 4475: FROM pa_budget_versions

4471: END IF;
4472:
4473: SELECT project_id
4474: INTO l_source_project_id
4475: FROM pa_budget_versions
4476: WHERE budget_version_id = p_source_plan_version_id;
4477:
4478: --IF target project id isn't passed, copy source projecct to target project
4479:

Line 5662: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;

5658: l_msg_index_out NUMBER;
5659: l_return_status VARCHAR2(2000);
5660: l_debug_mode VARCHAR2(30);
5661:
5662: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5663: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5664:
5665: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5666: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;

Line 5663: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;

5659: l_return_status VARCHAR2(2000);
5660: l_debug_mode VARCHAR2(30);
5661:
5662: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5663: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5664:
5665: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5666: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
5667:

Line 5675: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

5671: -- Bug 3927244
5672: l_copy_actuals_flag VARCHAR2(1) := 'Y';
5673: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5674: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5675: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5676:
5677: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5678:
5679: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS

Line 5677: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

5673: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5674: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5675: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5676:
5677: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5678:
5679: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5680: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5681: FROM pa_fin_plan_types_b pfb,

Line 5679: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS

5675: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5676:
5677: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5678:
5679: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5680: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5681: FROM pa_fin_plan_types_b pfb,
5682: pa_budget_versions pbv
5683: WHERE pbv.budget_version_id = c_budget_version_id

Line 5682: pa_budget_versions pbv

5678:
5679: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5680: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5681: FROM pa_fin_plan_types_b pfb,
5682: pa_budget_versions pbv
5683: WHERE pbv.budget_version_id = c_budget_version_id
5684: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
5685: -- Bug 3927244
5686: