APPS.PA_BUDGET_PVT dependencies on PA_BUDGET_TYPES

Line 20: FROM pa_budget_types

16: CURSOR l_budget_amount_code_csr
17: (c_budget_type_code VARCHAR2 )
18: IS
19: SELECT budget_amount_code
20: FROM pa_budget_types
21: WHERE budget_type_code = c_budget_type_code;
22:
23: -- Cursor to validate the change reason code
24: CURSOR l_budget_change_reason_csr ( c_change_reason_code VARCHAR2 )

Line 156: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE

152: ,p_init_msg_list IN VARCHAR2
153: ,px_pa_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
154: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE
155: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
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

Line 189: ,x_budget_amount_code OUT NOCOPY pa_budget_types.budget_amount_code%TYPE --Added for bug 4224464. --File.Sql.39 bug 4440895

185: ,p_replace_current_working_flag IN VARCHAR2
186: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
187: ,p_calling_module IN VARCHAR2
188: ,p_using_resource_lists_flag IN VARCHAR2
189: ,x_budget_amount_code OUT NOCOPY pa_budget_types.budget_amount_code%TYPE --Added for bug 4224464. --File.Sql.39 bug 4440895
190: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
191: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
192: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
193: ) IS

Line 218: l_budget_amount_code pa_budget_types.budget_amount_code%TYPE;

214:
215: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
216:
217:
218: l_budget_amount_code pa_budget_types.budget_amount_code%TYPE;
219:
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

Line 330: ( c_budget_type_code pa_budget_types.budget_type_code%TYPE

326:
327: -- Cursor to know whether a version exists for plan type created by upgrading the budget type
328: -- which is given as input. Crated as part of changes due to finplan in AMG
329: CURSOR is_budget_type_upgraded_csr
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

Line 5695: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE

5691: PROCEDURE Validate_Budget_Lines
5692: ( p_calling_context IN VARCHAR2 DEFAULT 'BUDGET_LINE_LEVEL_VALIDATION'
5693: ,p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE
5694: ,p_pa_project_id IN pa_projects_all.project_id%TYPE
5695: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
5696: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5697: ,p_version_type IN pa_budget_versions.version_type%TYPE
5698: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
5699: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

Line 5893: l_budget_amount_code pa_budget_types.budget_amount_code%TYPE;

5889: l_amg_task_number VARCHAR2(50);
5890: l_amg_top_task_number VARCHAR2(50);
5891: l_any_error_occurred_flag VARCHAR2(1) :='N';
5892: l_budget_lines_tbl_index NUMBER;
5893: l_budget_amount_code pa_budget_types.budget_amount_code%TYPE;
5894: l_txn_tbl_index NUMBER;
5895: i NUMBER;
5896: l_valid_txn_curr BOOLEAN;
5897: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;