DBA Data[Home] [Help]

APPS.PA_BUDGET_PVT dependencies on PA_FIN_PLAN_TYPES_TL

Line 161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895

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
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895

Line 436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;
438:
439: l_called_from_agr_pub VARCHAR2(1) := NULL; -- Bug 3099706
440:

Line 437: l_context_info pa_fin_plan_types_tl.name%TYPE;

433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;
438:
439: l_called_from_agr_pub VARCHAR2(1) := NULL; -- Bug 3099706
440:
441: ---- Bug # 3507156

Line 2838: l_context_info pa_fin_plan_types_tl.name%TYPE;

2834: -- is reported while validating the input parameters
2835: -- passed by the user
2836: l_any_error_occurred_flag VARCHAR2(1) :='N';
2837:
2838: l_context_info pa_fin_plan_types_tl.name%TYPE;
2839: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
2840:
2841: --Local variables needed for calling Funds Check API
2842: l_fck_req_flag VARCHAR2(1) := NULL;

Line 5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

5897: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
5898: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
5899: l_res_group_name pa_resource_list_members.alias%TYPE;
5900: l_valid_rlmid VARCHAR2(1);
5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5902: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5903: l_context_info pa_fin_plan_types_tl.name%TYPE;
5904: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;
5905:

Line 5903: l_context_info pa_fin_plan_types_tl.name%TYPE;

5899: l_res_group_name pa_resource_list_members.alias%TYPE;
5900: l_valid_rlmid VARCHAR2(1);
5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5902: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5903: l_context_info pa_fin_plan_types_tl.name%TYPE;
5904: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;
5905:
5906: -- Cursor used in validating the product code
5907: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)