DBA Data[Home] [Help]

APPS.PA_BUDGET_PVT dependencies on PA_BUDGET_PUB

Line 10: defined only for the api pa_budget_pub.update_plannning_element_attr

6: g_start_date pa_budget_lines.start_date%TYPE;
7: g_resource_alias pa_resource_list_members.alias%TYPE;
8:
9: /*Bug 5509192 this record type, table type and table are
10: defined only for the api pa_budget_pub.update_plannning_element_attr
11: This global table will be populated only by pa_budget_pvt.
12: validate_budget_lines. No other API should use this*/
13: TYPE res_assign_rec_type IS RECORD
14: (resource_assignment_id number);

Line 195: --required for PA_BUDGET_PUB.add_budget_line have been added to this API.

191:
192:
193: --This API is an overloaded version of an already existing procedure. It is
194: --created as part of FP.M Changes for FP AMG Apis. All header level validations
195: --required for PA_BUDGET_PUB.add_budget_line have been added to this API.
196: --This API handles validations for budget versions in new as well as old models.
197:
198: PROCEDURE Validate_Header_Info
199: ( p_api_version_number IN NUMBER DEFAULT 1.0

Line 291: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895

287: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
288: ,p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
289: /* Bug 3986129: end */
290:
291: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
292: /* bug 3133930 included out pl/sql table */
293: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
294: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
295: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 293: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895

289: /* Bug 3986129: end */
290:
291: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
292: /* bug 3133930 included out pl/sql table */
293: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
294: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
295: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
296: ,x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895
297: ,x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 312: 2)p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type

308: 1) PA_FIN_PLAN_UTILS2.Get_AMG_BdgtLineRejctions
309:
310: Parameters:
311: IN 1)p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
312: 2)p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
313: =======================================================================*/
314:
315: PROCEDURE GET_FIN_PLAN_LINES_STATUS
316: (p_calling_context IN VARCHAR2 DEFAULT NULL

Line 318: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type

314:
315: PROCEDURE GET_FIN_PLAN_LINES_STATUS
316: (p_calling_context IN VARCHAR2 DEFAULT NULL
317: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
318: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
319: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
320: ,x_return_status OUT NOCOPY VARCHAR2
321: ,x_msg_count OUT NOCOPY NUMBER
322: ,x_msg_data OUT NOCOPY VARCHAR2);

Line 319: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type

315: PROCEDURE GET_FIN_PLAN_LINES_STATUS
316: (p_calling_context IN VARCHAR2 DEFAULT NULL
317: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
318: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
319: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
320: ,x_return_status OUT NOCOPY VARCHAR2
321: ,x_msg_count OUT NOCOPY NUMBER
322: ,x_msg_data OUT NOCOPY VARCHAR2);
323:

Line 338: has been made public as we need to use it directly from pa_budget_pub

334:
335: /*================================================================================
336: Procedure Name : VALID_RATE_TYPE
337: Earlier this procedure was a local procedure to this package only. But now it has
338: has been made public as we need to use it directly from pa_budget_pub
339: =================================================================================*/
340: PROCEDURE VALID_RATE_TYPE
341: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
342: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE