[Home] [Help]
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);
190:
191:
192: --This API is an overloaded version of an already existing procedure. It is
193: --created as part of FP.M Changes for FP AMG Apis. All header level validations
194: --required for PA_BUDGET_PUB.add_budget_line have been added to this API.
195: --This API handles validations for budget versions in new as well as old models.
196:
197: PROCEDURE Validate_Header_Info
198: ( p_api_version_number IN NUMBER DEFAULT 1.0
286: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
287: ,p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
288: /* Bug 3986129: end */
289:
290: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
291: /* bug 3133930 included out pl/sql table */
292: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
293: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
294: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
288: /* Bug 3986129: end */
289:
290: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
291: /* bug 3133930 included out pl/sql table */
292: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
293: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
294: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
295: ,x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895
296: ,x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
307: 1) PA_FIN_PLAN_UTILS2.Get_AMG_BdgtLineRejctions
308:
309: Parameters:
310: IN 1)p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
311: 2)p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
312: =======================================================================*/
313:
314: PROCEDURE GET_FIN_PLAN_LINES_STATUS
315: (p_calling_context IN VARCHAR2 DEFAULT NULL
313:
314: PROCEDURE GET_FIN_PLAN_LINES_STATUS
315: (p_calling_context IN VARCHAR2 DEFAULT NULL
316: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
317: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
318: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
319: ,x_return_status OUT NOCOPY VARCHAR2
320: ,x_msg_count OUT NOCOPY NUMBER
321: ,x_msg_data OUT NOCOPY VARCHAR2);
314: PROCEDURE GET_FIN_PLAN_LINES_STATUS
315: (p_calling_context IN VARCHAR2 DEFAULT NULL
316: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
317: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
318: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
319: ,x_return_status OUT NOCOPY VARCHAR2
320: ,x_msg_count OUT NOCOPY NUMBER
321: ,x_msg_data OUT NOCOPY VARCHAR2);
322:
333:
334: /*================================================================================
335: Procedure Name : VALID_RATE_TYPE
336: Earlier this procedure was a local procedure to this package only. But now it has
337: has been made public as we need to use it directly from pa_budget_pub
338: =================================================================================*/
339: PROCEDURE VALID_RATE_TYPE
340: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE