1 package PA_BUDGET_PVT AUTHID DEFINER as
2 /*$Header: PAPMBUVS.pls 120.6.12020000.2 2013/04/10 07:39:38 djambhek ship $*/
3
4 --Declared the following variables as part of changes to AMG due to finplan model
5 g_task_number pa_tasks.task_number%TYPE;
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);
15 TYPE res_assign_tbl_type IS TABLE OF res_assign_rec_type
16 INDEX BY BINARY_INTEGER;
17 TYPE res_assign_tbl_type1 IS TABLE OF res_assign_rec_type
18 INDEX BY varchar2(17);
19 G_res_assign_tbl res_assign_tbl_type;
20 --end changes for bug 5509192
21
22
23
24 PROCEDURE insert_budget_line
25 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
27 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30 ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31 ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32 ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
33 ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
34 ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
35 ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
37 ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38 ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
39 ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40 ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
41 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42 ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59 ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
60 ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61 ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62 ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63 ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64 ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65 ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
66 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );--Bug 4224464
67
68
69 /* Bug 4224464- This procedure has been modified extensively during FP.M changes for AMG.
70 * If you do not want to update a parameter then either do not pass it or pass its value
71 * as NULL, and if you want to null out a parameter then pass it as FND_API.G_MISS_XXX*/
72 PROCEDURE update_budget_line_sql
73 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74 ,p_budget_entry_method_code IN VARCHAR2 := NULL
75 ,p_resource_assignment_id IN NUMBER := NULL
76 ,p_start_date IN DATE := NULL
77 ,p_time_phased_type_code IN VARCHAR2 := NULL
78 ,p_description IN VARCHAR2 := NULL
79 ,p_quantity IN NUMBER := NULL
80 ,p_raw_cost IN NUMBER := NULL
81 ,p_burdened_cost IN NUMBER := NULL
82 ,p_revenue IN NUMBER := NULL
83 ,p_change_reason_code IN VARCHAR2 := NULL
84 ,p_attribute_category IN VARCHAR2 := NULL
85 ,p_attribute1 IN VARCHAR2 := NULL
86 ,p_attribute2 IN VARCHAR2 := NULL
87 ,p_attribute3 IN VARCHAR2 := NULL
88 ,p_attribute4 IN VARCHAR2 := NULL
89 ,p_attribute5 IN VARCHAR2 := NULL
90 ,p_attribute6 IN VARCHAR2 := NULL
91 ,p_attribute7 IN VARCHAR2 := NULL
92 ,p_attribute8 IN VARCHAR2 := NULL
93 ,p_attribute9 IN VARCHAR2 := NULL
94 ,p_attribute10 IN VARCHAR2 := NULL
95 ,p_attribute11 IN VARCHAR2 := NULL
96 ,p_attribute12 IN VARCHAR2 := NULL
97 ,p_attribute13 IN VARCHAR2 := NULL
98 ,p_attribute14 IN VARCHAR2 := NULL
99 ,p_attribute15 IN VARCHAR2 := NULL
100 );
101
102 PROCEDURE get_valid_period_dates
103 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
104 ,p_project_id IN NUMBER
105 ,p_task_id IN NUMBER
106 ,p_time_phased_type_code IN VARCHAR2
107 ,p_entry_level_code IN VARCHAR2
108 ,p_period_name_in IN VARCHAR2
109 ,p_budget_start_date_in IN DATE
110 ,p_budget_end_date_in IN DATE
111 ,p_period_name_out OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112 ,p_budget_start_date_out OUT NOCOPY DATE --File.Sql.39 bug 4440895
113 ,p_budget_end_date_out OUT NOCOPY DATE --File.Sql.39 bug 4440895
114
115 -- Bug 3986129: FP.M Web ADI Dev changes
116 ,p_context IN VARCHAR2 DEFAULT NULL
117 ,p_calling_model_context IN VARCHAR2
118 ,x_error_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
119
120 PROCEDURE check_entry_method_flags
121 ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122 ,p_budget_amount_code IN VARCHAR2
123 ,p_budget_entry_method_code IN VARCHAR2
124 ,p_quantity IN NUMBER
125 ,p_raw_cost IN NUMBER
126 ,p_burdened_cost IN NUMBER
127 ,p_revenue IN NUMBER
128 ,p_version_type IN VARCHAR2 := NULL
129 ,p_allow_qty_flag IN VARCHAR2 := NULL
130 ,p_allow_raw_cost_flag IN VARCHAR2 := NULL
131 ,p_allow_burdened_cost_flag IN VARCHAR2 := NULL
132 ,p_allow_revenue_flag IN VARCHAR2 := NULL
133
134 -- Bug 3986129: FP.M Web ADI Dev changes
135 ,p_context IN VARCHAR2 DEFAULT NULL
136 ,p_raw_cost_rate IN NUMBER DEFAULT NULL
137 ,p_burdened_cost_rate IN NUMBER DEFAULT NULL
138 ,p_bill_rate IN NUMBER DEFAULT NULL
139 ,p_allow_raw_cost_rate_flag IN VARCHAR2 DEFAULT NULL
140 ,p_allow_burd_cost_rate_flag IN VARCHAR2 DEFAULT NULL
141 ,p_allow_bill_rate_flag IN VARCHAR2 DEFAULT NULL
142 ,x_webadi_error_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
143
144 PROCEDURE Validate_Header_Info
145 ( p_api_version_number IN NUMBER
146 ,p_budget_version_name IN VARCHAR2 /* Introduced for bug 3133930*/
147 ,p_init_msg_list IN VARCHAR2
148 ,px_pa_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
149 ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE
150 ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
151 ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
152 ,p_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
153 ,px_resource_list_name IN OUT NOCOPY pa_resource_lists_tl.name%TYPE --File.Sql.39 bug 4440895
154 ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895
155 ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
156 ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
157 ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
158 ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
159 ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
160 ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
161 ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
162 ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
163 ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
164 ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
165 ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
166 ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
167 ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
168 ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
169 ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
170 ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
171 ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
172 ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
173 ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174 ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175 ,px_revenue_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
176 ,px_cost_qty_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
177 ,px_revenue_qty_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
178 ,px_all_qty_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179 ,p_create_new_curr_working_flag IN VARCHAR2
180 ,p_replace_current_working_flag IN VARCHAR2
181 ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
182 ,p_calling_module IN VARCHAR2
183 --New parameter for fin plan.
184 ,p_using_resource_lists_flag IN VARCHAR2 default 'Y'
185 ,x_budget_amount_code OUT NOCOPY pa_budget_types.budget_amount_code%TYPE --Added for bug 4224464. --File.Sql.39 bug 4440895
186 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
187 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
189
190 ) ;
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
200 ,p_api_name IN VARCHAR2 DEFAULT NULL
201 ,p_init_msg_list IN VARCHAR2
202 ,px_pa_project_id IN OUT NOCOPY NUMBER
203 ,p_pm_project_reference IN VARCHAR2
204 ,p_pm_product_code IN VARCHAR2
205 ,px_budget_type_code IN OUT NOCOPY VARCHAR2
206 ,px_fin_plan_type_id IN OUT NOCOPY NUMBER
207 ,px_fin_plan_type_name IN OUT NOCOPY VARCHAR2
208 ,px_version_type IN OUT NOCOPY VARCHAR2
209 ,p_budget_version_number IN NUMBER
210 ,p_change_reason_code IN VARCHAR2
211 ,p_function_name IN VARCHAR2
212 ,x_budget_entry_method_code OUT NOCOPY VARCHAR2
213 ,x_resource_list_id OUT NOCOPY NUMBER
214 ,x_budget_version_id OUT NOCOPY NUMBER
215 ,x_fin_plan_level_code OUT NOCOPY VARCHAR2
216 ,x_time_phased_code OUT NOCOPY VARCHAR2
217 ,x_plan_in_multi_curr_flag OUT NOCOPY VARCHAR2
218 ,x_budget_amount_code OUT NOCOPY VARCHAR2
219 ,x_categorization_code OUT NOCOPY VARCHAR2
220 ,x_project_number OUT NOCOPY VARCHAR2
221 /* Plan Amount Entry flags introduced by bug 6408139 */
222 ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2
223 ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2
224 ,px_revenue_flag IN OUT NOCOPY VARCHAR2
225 ,px_cost_qty_flag IN OUT NOCOPY VARCHAR2
226 ,px_revenue_qty_flag IN OUT NOCOPY VARCHAR2
227 ,px_all_qty_flag IN OUT NOCOPY VARCHAR2
228 ,px_bill_rate_flag IN OUT NOCOPY VARCHAR2
229 ,px_cost_rate_flag IN OUT NOCOPY VARCHAR2
230 ,px_burden_rate_flag IN OUT NOCOPY VARCHAR2
231 /* Plan Amount Entry flags introduced by bug 6408139 */
232 ,x_msg_count OUT NOCOPY NUMBER
233 ,x_msg_data OUT NOCOPY VARCHAR2
234 ,x_return_status OUT NOCOPY VARCHAR2
235 );
236
237
238 PROCEDURE Validate_Budget_Lines
239 ( p_calling_context IN VARCHAR2 DEFAULT 'BUDGET_LINE_LEVEL_VALIDATION'
240 ,p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE DEFAULT NULL
241 ,p_pa_project_id IN pa_projects_all.project_id%TYPE
242 ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
243 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
244 ,p_version_type IN pa_budget_versions.version_type%TYPE
245 ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
246 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
247 ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
248 ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
249 ,p_allow_qty_flag IN VARCHAR2
250 ,p_allow_raw_cost_flag IN VARCHAR2
251 ,p_allow_burdened_cost_flag IN VARCHAR2
252 ,p_allow_revenue_flag IN VARCHAR2
253 ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
254 ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
255 ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
256 ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
257 ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
258 ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
259 ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
260 ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
261 ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
262 ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
263 ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
264 ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
265 ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
266 ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
267 ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
268 ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
269 ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
270
271 /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added*/
272 ,p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols DEFAULT NULL
273 ,p_allow_raw_cost_rate_flag IN VARCHAR2 DEFAULT NULL
274 ,p_allow_burd_cost_rate_flag IN VARCHAR2 DEFAULT NULL
275 ,p_allow_bill_rate_flag IN VARCHAR2 DEFAULT NULL
276 ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
277 ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
278 ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
279 ,p_uom_tbl IN SYSTEM.pa_varchar2_80_tbl_type DEFAULT SYSTEM.pa_varchar2_80_tbl_type()
280 ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
281 ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
282 ,p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
283 ,p_mfc_cost_type_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
284 ,p_spread_curve_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
285 ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
286 ,p_etc_method_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
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
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
298 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
299 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
300 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
301 );
302
303 /*=====================================================================
304 Procedure Name: GET_FIN_PLAN_LINES_STATUS
305 This procedure is added as part of B and F AMG API changes. Tracking Bug - 3507156.
306 Patchset M: B and F impact changes : AMG
307 Purpose: This API calls the following apis :
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
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
324
325 -- Function : Is_bc_enabled_for_budget
326 -- Purpose : This functions returns true if a record exists in
327 -- PA_BC_BALANCES table for the given budget version id
328 -- Parameters : Budget Version Id.
329 --
330 FUNCTION Is_bc_enabled_for_budget
331 ( p_budget_version_id IN NUMBER )
332 RETURN BOOLEAN;
333
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
343 ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
344 ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
345 ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
346 ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
347 ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
348 ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
349 ,x_is_rate_type_valid OUT NOCOPY BOOLEAN
350 ,x_return_status OUT NOCOPY VARCHAR2
351 ,x_msg_count OUT NOCOPY NUMBER
352 ,x_msg_data OUT NOCOPY VARCHAR2
353 );
354
355
356 --Name: Get_Latest_BC_Year
357 --Type: Procedure
358 --Description: For budgetary control projects, this procedure fetches the
359 -- latest encumbrance year for the project's set-of-books.
360 --
361 --
362 --
363 --History:
364 -- 27-SEP-2005 jwhite Created per bug 4588279
365
366 PROCEDURE Get_Latest_BC_Year
367 ( p_pa_project_id IN pa_projects_all.project_id%TYPE
368 ,x_latest_encumbrance_year OUT NOCOPY gl_ledgers.Latest_Encumbrance_Year%TYPE
369 ,x_return_status OUT NOCOPY VARCHAR2
370 ,x_msg_count OUT NOCOPY NUMBER
371 ,x_msg_data OUT NOCOPY VARCHAR2
372 );
373
374
375
376
377 end PA_BUDGET_PVT;