DBA Data[Home] [Help]

APPS.PA_BUDGET_PVT dependencies on PA_BUDGET_ENTRY_METHODS

Line 157: ,p_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE

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
161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895

Line 208: (c_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

204: AND ppa.project_type = ppt.project_type;
205:
206: -- Cursor to get the details of the budget entry method passed
207: CURSOR l_budget_entry_method_csr
208: (c_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
209: IS
210: SELECT *
211: FROM pa_budget_entry_methods
212: WHERE budget_entry_method_code = c_budget_entry_method_code

Line 211: FROM pa_budget_entry_methods

207: CURSOR l_budget_entry_method_csr
208: (c_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
209: IS
210: SELECT *
211: FROM pa_budget_entry_methods
212: WHERE budget_entry_method_code = c_budget_entry_method_code
213: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
214:
215: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

Line 215: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

211: FROM pa_budget_entry_methods
212: WHERE budget_entry_method_code = c_budget_entry_method_code
213: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
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:

Line 2735: (c_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

2731: AND use_for_workplan_flag = 'Y';
2732:
2733: --Cursor to get the details of the budget entry method passed
2734: CURSOR l_budget_entry_method_csr
2735: (c_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
2736: IS
2737: SELECT entry_level_code
2738: ,categorization_code
2739: ,time_phased_type_code

Line 2740: FROM pa_budget_entry_methods

2736: IS
2737: SELECT entry_level_code
2738: ,categorization_code
2739: ,time_phased_type_code
2740: FROM pa_budget_entry_methods
2741: WHERE budget_entry_method_code = c_budget_entry_method_code
2742: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
2743:
2744: --Cursor to get the plan type details of the version being created.

Line 4825: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type)

4821:
4822: --cursor added as part of fix for Bug#1406799 to check the burdened_cost_flag
4823:
4824: CURSOR l_budget_entry_method_csr
4825: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type)
4826: IS
4827: SELECT burdened_cost_flag
4828: FROM pa_budget_entry_methods
4829: WHERE budget_entry_method_code = p_budget_entry_method_code

Line 4828: FROM pa_budget_entry_methods

4824: CURSOR l_budget_entry_method_csr
4825: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type)
4826: IS
4827: SELECT burdened_cost_flag
4828: FROM pa_budget_entry_methods
4829: WHERE budget_entry_method_code = p_budget_entry_method_code
4830: AND trunc(sysdate)
4831: BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
4832:

Line 5700: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_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
5700: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
5701: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
5702: ,p_allow_qty_flag IN VARCHAR2
5703: ,p_allow_raw_cost_flag IN VARCHAR2
5704: ,p_allow_burdened_cost_flag IN VARCHAR2