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_BUDGET_PVT dependencies on PA_FIN_PLAN_TYPES_B

Line 160: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

156: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
157: ,p_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
158: ,px_resource_list_name IN OUT NOCOPY pa_resource_lists_tl.name%TYPE --File.Sql.39 bug 4440895
159: ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895
160: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895

Line 224: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

220: -- Cursor to get the plan type details of the version being created. Created as part
221: -- of changes due to fin plan in AMG
222: CURSOR l_proj_fp_options_csr
223: ( c_project_id pa_projects.project_id%TYPE
224: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
225: IS
226: SELECT fin_plan_preference_code
227: ,nvl(plan_in_multi_curr_flag,'N') plan_in_multi_curr_flag
228: ,approved_rev_plan_type_flag

Line 265: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE

261: -- Cursor to get the planning level ,resource list and time phasing from the plan type
262: -- Added as part of changes due to finplan in AMG
263: CURSOR l_plan_type_settings_csr
264: ( c_project_id pa_projects.project_id%TYPE
265: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
266: ,c_version_type VARCHAR2)
267:
268: IS
269: SELECT decode(c_version_type,

Line 334: FROM pa_fin_plan_types_b fin ,pa_proj_fp_options pfo

330: ( c_budget_type_code pa_budget_types.budget_type_code%TYPE
331: ,c_project_id pa_projects_all.project_id%TYPE)
332: IS
333: SELECT 'X'
334: FROM pa_fin_plan_types_b fin ,pa_proj_fp_options pfo
335: WHERE pfo.project_id=c_project_id
336: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE --AMG UT2
337: AND pfo.fin_plan_type_id = fin.fin_plan_type_id
338: AND fin.migrated_frm_bdgt_typ_code = c_budget_type_code;

Line 384: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

380: l_copy_conv_attr boolean;
381: l_conv_attrs_to_be_validated VARCHAR2(10);
382: l_old_budget_version_id pa_budget_versions.budget_version_id%TYPE;
383: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
384: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
385:
386: l_allow_cost_budget_entry_flag pa_project_types_all.allow_cost_budget_entry_flag%TYPE;
387: l_allow_rev_budget_entry_flag pa_project_types_all.allow_rev_budget_entry_flag%TYPE;
388:

Line 452: px_fin_plan_type_id_in pa_fin_plan_types_b.fin_plan_type_id%TYPE;

448: l_res_list_migration_code pa_resource_list_members.migration_code%TYPE := FND_API.G_MISS_CHAR;
449: l_targ_request_id pa_budget_versions.request_id%TYPE;
450: px_pa_project_id_in pa_projects_all.project_id%TYPE;
451: px_resource_list_id_in pa_resource_lists_all_bg.resource_list_id%TYPE;
452: px_fin_plan_type_id_in pa_fin_plan_types_b.fin_plan_type_id%TYPE;
453:
454: BEGIN
455:
456: --dbms_output.put_line('In validate header info');

Line 2726: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

2722:
2723: --This cursor is used to check if a fin_plan_type_id is
2724: --used to store workplan data
2725: CURSOR l_use_for_wp_csr
2726: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
2727: IS
2728: SELECT 1
2729: FROM pa_fin_plan_types_b
2730: WHERE fin_plan_type_id = p_fin_plan_type_id

Line 2729: FROM pa_fin_plan_types_b

2725: CURSOR l_use_for_wp_csr
2726: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
2727: IS
2728: SELECT 1
2729: FROM pa_fin_plan_types_b
2730: WHERE fin_plan_type_id = p_fin_plan_type_id
2731: AND use_for_workplan_flag = 'Y';
2732:
2733: --Cursor to get the details of the budget entry method passed

Line 2747: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE

2743:
2744: --Cursor to get the plan type details of the version being created.
2745: CURSOR l_proj_fp_options_csr
2746: ( c_project_id pa_projects.project_id%TYPE
2747: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
2748: ,c_version_type pa_budget_versions.version_type%TYPE
2749: ,c_fin_plan_version_id pa_budget_versions.budget_version_id%TYPE)
2750: IS
2751: SELECT nvl(plan_in_multi_curr_flag,'N') multi_curr_flag

Line 5679: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

5675: ( p_calling_context IN VARCHAR2 DEFAULT 'BUDGET_LINE_LEVEL_VALIDATION'
5676: ,p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE
5677: ,p_pa_project_id IN pa_projects_all.project_id%TYPE
5678: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
5679: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5680: ,p_version_type IN pa_budget_versions.version_type%TYPE
5681: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
5682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
5683: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE

Line 5826: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE

5822:
5823: --This cursor is used to get the approved rev plan type flag of the plan type
5824: --Added as part of the changes for fin plan model in FP L
5825: CURSOR l_approved_revenue_flag_csr
5826: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
5827: ,c_project_id pa_projects_all.project_id%TYPE)
5828: IS
5829: SELECT approved_rev_plan_type_flag,
5830: proj_fp_options_id

Line 5843: pa_fin_plan_types_b pt

5839: IS
5840: SELECT pt.plan_class_code
5841: ,bv.etc_start_date
5842: FROM pa_budget_versions bv,
5843: pa_fin_plan_types_b pt
5844: WHERE bv.budget_version_id = c_budget_version_id
5845: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
5846:
5847: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 5847: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

5843: pa_fin_plan_types_b pt
5844: WHERE bv.budget_version_id = c_budget_version_id
5845: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
5846:
5847: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5848: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5849: /* Bug 4224464: FP M Changes End */
5850:
5851: l_app_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;