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 39: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

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

Line 44: UPDATE pa_budget_versions

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

Line 149: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

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

Line 192: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

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

Line 193: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

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

Line 194: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

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

Line 195: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;

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

Line 196: l_bv_version_number pa_budget_versions.version_number%TYPE;

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

Line 197: l_bv_version_name pa_budget_versions.version_name%TYPE;

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

Line 198: l_pfi_txn_project_id pa_budget_versions.project_id%TYPE;

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

Line 199: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

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

Line 200: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

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

Line 1538: FROM pa_budget_versions bv

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

Line 1711: FROM pa_budget_versions bv,

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

Line 1848: UPDATE pa_budget_versions

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

Line 3764: UPDATE pa_budget_versions

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

Line 4474: FROM pa_budget_versions

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

Line 5657: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;

5653: l_msg_index_out NUMBER;
5654: l_return_status VARCHAR2(2000);
5655: l_debug_mode VARCHAR2(30);
5656:
5657: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5658: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5659:
5660: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5661: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;

Line 5658: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;

5654: l_return_status VARCHAR2(2000);
5655: l_debug_mode VARCHAR2(30);
5656:
5657: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5658: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5659:
5660: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5661: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
5662:

Line 5670: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

5666: -- Bug 3927244
5667: l_copy_actuals_flag VARCHAR2(1) := 'Y';
5668: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5669: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5670: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5671:
5672: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5673:
5674: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS

Line 5672: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

5668: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5669: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5670: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5671:
5672: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5673:
5674: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5675: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5676: FROM pa_fin_plan_types_b pfb,

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

5670: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5671:
5672: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5673:
5674: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5675: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5676: FROM pa_fin_plan_types_b pfb,
5677: pa_budget_versions pbv
5678: WHERE pbv.budget_version_id = c_budget_version_id

Line 5677: pa_budget_versions pbv

5673:
5674: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5675: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5676: FROM pa_fin_plan_types_b pfb,
5677: pa_budget_versions pbv
5678: WHERE pbv.budget_version_id = c_budget_version_id
5679: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
5680: -- Bug 3927244
5681: