[Home] [Help]
PACKAGE: APPS.PA_FP_BUDGET_VERSIONS_PKG
Source
1 PACKAGE pa_fp_budget_versions_pkg AUTHID CURRENT_USER as
2 /* $Header: PAFPBVTS.pls 120.1 2005/08/19 16:24:21 mwasowic noship $ */
3 -- Start of Comments
4 -- Package name : PA_FP_BUDGET_VERSIONS_PKG
5 -- Purpose :
6 -- History :
7 -- 31-OCT-2002 rravipat Modified the Insert_Row and Update_Row apis
8 -- to include the newly added columns for
9 -- Bug:- 2634900
10 --
11 -- 26-JUN-2003 jwhite - Plannable Task Dev Effort:
12 -- For the Insert_Row procedure, add the
13 -- following IN-parameters:
14 -- 1) p_refresh_required_flag
15 -- 29-JAN-2003 rravipat - Bug 2634900 (IDC)
16 -- Included new columns for FP M Doosan.
17 -- 02-APR-2004 dbora FP.M Added p_est_equip_qty in parameter in
18 -- Insert_Row and Update_Row
19 -- NOTE :
20 -- End of Comments
21
22 PROCEDURE Insert_Row
23 ( px_budget_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
24 ,p_project_id IN pa_budget_versions.project_id%TYPE
25 := FND_API.G_MISS_NUM
26 ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
27 := FND_API.G_MISS_CHAR
28 ,p_version_number IN pa_budget_versions.version_number%TYPE
29 := FND_API.G_MISS_NUM
30 ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
31 := FND_API.G_MISS_CHAR
32 ,p_current_flag IN pa_budget_versions.current_flag%TYPE
33 := FND_API.G_MISS_CHAR
34 ,p_original_flag IN pa_budget_versions.original_flag%TYPE
35 := FND_API.G_MISS_CHAR
36 ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
37 := FND_API.G_MISS_CHAR
38 ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
39 := FND_API.G_MISS_CHAR
40 ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
41 := FND_API.G_MISS_NUM
42 ,p_version_name IN pa_budget_versions.version_name%TYPE
43 := FND_API.G_MISS_CHAR
44 ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
45 := FND_API.G_MISS_CHAR
46 ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
47 := FND_API.G_MISS_NUM
48 ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
49 := FND_API.G_MISS_DATE
50 ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
51 := FND_API.G_MISS_CHAR
52 ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
53 := FND_API.G_MISS_NUM
54 ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
55 := FND_API.G_MISS_CHAR
56 ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
57 := FND_API.G_MISS_NUM
58 ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
59 := FND_API.G_MISS_NUM
60 ,p_revenue IN pa_budget_versions.revenue%TYPE
61 := FND_API.G_MISS_NUM
62 ,p_description IN pa_budget_versions.description%TYPE
63 := FND_API.G_MISS_CHAR
64 ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
65 := FND_API.G_MISS_CHAR
66 ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
67 := FND_API.G_MISS_CHAR
68 ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
69 := FND_API.G_MISS_CHAR
70 ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
71 := FND_API.G_MISS_CHAR
72 ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
73 := FND_API.G_MISS_CHAR
74 ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
75 := FND_API.G_MISS_CHAR
76 ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
77 := FND_API.G_MISS_CHAR
78 ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
79 := FND_API.G_MISS_CHAR
80 ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
81 := FND_API.G_MISS_CHAR
82 ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
83 := FND_API.G_MISS_CHAR
84 ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
85 := FND_API.G_MISS_CHAR
86 ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
87 := FND_API.G_MISS_CHAR
88 ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
89 := FND_API.G_MISS_CHAR
90 ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
91 := FND_API.G_MISS_CHAR
92 ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
93 := FND_API.G_MISS_CHAR
94 ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
95 := FND_API.G_MISS_CHAR
96 ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
97 := FND_API.G_MISS_CHAR
98 ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
99 := FND_API.G_MISS_CHAR
100 ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
101 := FND_API.G_MISS_CHAR
102 ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
103 := FND_API.G_MISS_CHAR
104 ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
105 := FND_API.G_MISS_CHAR
106 ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
107 := FND_API.G_MISS_CHAR
108 ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
109 := FND_API.G_MISS_DATE
110 ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
111 := FND_API.G_MISS_CHAR
112 ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
113 := FND_API.G_MISS_NUM
114 ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
115 := FND_API.G_MISS_NUM
116 ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
117 := FND_API.G_MISS_NUM
118 ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
119 := FND_API.G_MISS_NUM
120 ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
121 := FND_API.G_MISS_CHAR
122 ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
123 := FND_API.G_MISS_NUM
124 ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
125 := FND_API.G_MISS_NUM
126 ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
127 := FND_API.G_MISS_NUM
128 ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
129 := FND_API.G_MISS_NUM
130 ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
131 := FND_API.G_MISS_NUM
132 ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
133 := FND_API.G_MISS_NUM
134 ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
135 := FND_API.G_MISS_NUM
136 ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
137 := FND_API.G_MISS_NUM
138 ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
139 := FND_API.G_MISS_NUM
140 ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
141 := FND_API.G_MISS_NUM
142 ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
143 := FND_API.G_MISS_NUM
144 ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
145 := FND_API.G_MISS_NUM
146 ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
147 := FND_API.G_MISS_NUM
148 ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
149 := FND_API.G_MISS_NUM
150 ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
151 := FND_API.G_MISS_NUM
152 ,p_version_type IN pa_budget_versions.version_type%TYPE
153 := FND_API.G_MISS_CHAR
154 ,p_request_id IN pa_budget_versions.request_id%TYPE
155 := FND_API.G_MISS_NUM
156 ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
157 := FND_API.G_MISS_NUM
158 ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
159 := FND_API.G_MISS_NUM
160 ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
161 := FND_API.G_MISS_NUM
162 ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
163 := FND_API.G_MISS_NUM
164 ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
165 := FND_API.G_MISS_CHAR
166 ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
167 := FND_API.G_MISS_CHAR
168 -- start of changes of Bug:- 2634900
169 ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
170 := FND_API.G_MISS_NUM
171 ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
172 := FND_API.G_MISS_NUM
173 ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
174 := FND_API.G_MISS_NUM
175 ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
176 := FND_API.G_MISS_NUM
177 ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
178 := FND_API.G_MISS_NUM
179 ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
180 := FND_API.G_MISS_NUM
181 ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
182 := FND_API.G_MISS_NUM
183 ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
184 := FND_API.G_MISS_NUM
185 ,p_ci_id IN pa_budget_versions.ci_id%TYPE
186 := FND_API.G_MISS_NUM
190 := FND_API.G_MISS_CHAR
187 ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
188 := FND_API.G_MISS_NUM
189 ,p_refresh_required_flag IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE
191 -- end of changes of Bug:- 2634900
192 -- Bug 3354518: start of new columns for FP-M
193 ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
194 := FND_API.G_MISS_CHAR
195 ,p_object_id IN pa_budget_versions.object_id%TYPE
196 := FND_API.G_MISS_NUM
197 ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
198 := FND_API.G_MISS_CHAR
199 ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
200 := FND_API.G_MISS_CHAR
201 ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
202 := FND_API.G_MISS_CHAR
203 ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
204 := FND_API.G_MISS_NUM
205 ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
206 := FND_API.G_MISS_CHAR
207 ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
208 := FND_API.G_MISS_CHAR
209 ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
210 := FND_API.G_MISS_CHAR
211 ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
212 := FND_API.G_MISS_NUM
213 ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
214 := FND_API.G_MISS_DATE
215 ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE
216 := FND_API.G_MISS_CHAR
217 -- Bug 3354518: end of new columns for FP-M
218
219 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
220 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
221
222 PROCEDURE Update_Row
223 ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
224 ,p_record_version_number IN NUMBER
225 := NULL
226 ,p_project_id IN pa_budget_versions.project_id%TYPE
227 := FND_API.G_MISS_NUM
228 ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
229 := FND_API.G_MISS_CHAR
230 ,p_version_number IN pa_budget_versions.version_number%TYPE
231 := FND_API.G_MISS_NUM
232 ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
233 := FND_API.G_MISS_CHAR
234 ,p_current_flag IN pa_budget_versions.current_flag%TYPE
235 := FND_API.G_MISS_CHAR
236 ,p_original_flag IN pa_budget_versions.original_flag%TYPE
237 := FND_API.G_MISS_CHAR
238 ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
239 := FND_API.G_MISS_CHAR
240 ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
241 := FND_API.G_MISS_CHAR
242 ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
243 := FND_API.G_MISS_NUM
244 ,p_version_name IN pa_budget_versions.version_name%TYPE
245 := FND_API.G_MISS_CHAR
246 ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
247 := FND_API.G_MISS_CHAR
248 ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
249 := FND_API.G_MISS_NUM
250 ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
251 := FND_API.G_MISS_DATE
252 ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
253 := FND_API.G_MISS_CHAR
254 ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
255 := FND_API.G_MISS_NUM
256 ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
257 := FND_API.G_MISS_CHAR
258 ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
259 := FND_API.G_MISS_NUM
260 ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
261 := FND_API.G_MISS_NUM
262 ,p_revenue IN pa_budget_versions.revenue%TYPE
263 := FND_API.G_MISS_NUM
264 ,p_description IN pa_budget_versions.description%TYPE
265 := FND_API.G_MISS_CHAR
266 ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
267 := FND_API.G_MISS_CHAR
268 ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
269 := FND_API.G_MISS_CHAR
270 ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
271 := FND_API.G_MISS_CHAR
272 ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
273 := FND_API.G_MISS_CHAR
274 ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
275 := FND_API.G_MISS_CHAR
276 ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
277 := FND_API.G_MISS_CHAR
281 := FND_API.G_MISS_CHAR
278 ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
279 := FND_API.G_MISS_CHAR
280 ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
282 ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
283 := FND_API.G_MISS_CHAR
284 ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
285 := FND_API.G_MISS_CHAR
286 ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
287 := FND_API.G_MISS_CHAR
288 ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
289 := FND_API.G_MISS_CHAR
290 ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
291 := FND_API.G_MISS_CHAR
292 ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
293 := FND_API.G_MISS_CHAR
294 ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
295 := FND_API.G_MISS_CHAR
296 ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
297 := FND_API.G_MISS_CHAR
298 ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
299 := FND_API.G_MISS_CHAR
300 ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
301 := FND_API.G_MISS_CHAR
302 ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
303 := FND_API.G_MISS_CHAR
304 ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
305 := FND_API.G_MISS_CHAR
306 ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
307 := FND_API.G_MISS_CHAR
308 ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
309 := FND_API.G_MISS_CHAR
310 ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
311 := FND_API.G_MISS_DATE
312 ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
313 := FND_API.G_MISS_CHAR
314 ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
315 := FND_API.G_MISS_NUM
316 ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
317 := FND_API.G_MISS_NUM
318 ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
319 := FND_API.G_MISS_NUM
320 ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
321 := FND_API.G_MISS_NUM
322 ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
323 := FND_API.G_MISS_CHAR
324 ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
325 := FND_API.G_MISS_NUM
326 ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
327 := FND_API.G_MISS_NUM
328 ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
329 := FND_API.G_MISS_NUM
330 ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
331 := FND_API.G_MISS_NUM
332 ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
333 := FND_API.G_MISS_NUM
334 ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
335 := FND_API.G_MISS_NUM
336 ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
337 := FND_API.G_MISS_NUM
338 ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
339 := FND_API.G_MISS_NUM
340 ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
341 := FND_API.G_MISS_NUM
342 ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
343 := FND_API.G_MISS_NUM
344 ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
345 := FND_API.G_MISS_NUM
346 ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
347 := FND_API.G_MISS_NUM
348 ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
349 := FND_API.G_MISS_NUM
350 ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
351 := FND_API.G_MISS_NUM
352 ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
353 := FND_API.G_MISS_NUM
354 ,p_version_type IN pa_budget_versions.version_type%TYPE
355 := FND_API.G_MISS_CHAR
356 ,p_request_id IN pa_budget_versions.request_id%TYPE
357 := FND_API.G_MISS_NUM
358 ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
359 := FND_API.G_MISS_NUM
360 ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
361 := FND_API.G_MISS_NUM
362 ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
363 := FND_API.G_MISS_NUM
364 ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
368 ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
365 := FND_API.G_MISS_NUM
366 ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
367 := FND_API.G_MISS_CHAR
369 := FND_API.G_MISS_CHAR
370 -- start of changes of Bug:- 2634900
371 ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
372 := FND_API.G_MISS_NUM
373 ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
374 := FND_API.G_MISS_NUM
375 ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
376 := FND_API.G_MISS_NUM
377 ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
378 := FND_API.G_MISS_NUM
379 ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
380 := FND_API.G_MISS_NUM
381 ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
382 := FND_API.G_MISS_NUM
383 ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
384 := FND_API.G_MISS_NUM
385 ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
386 := FND_API.G_MISS_NUM
387 ,p_ci_id IN pa_budget_versions.ci_id%TYPE
388 := FND_API.G_MISS_NUM
389 ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
390 := FND_API.G_MISS_NUM
391 -- end of changes of Bug:- 2634900
392 -- Bug 3354518: start of new columns for FP-M
393 ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
394 := FND_API.G_MISS_CHAR
395 ,p_object_id IN pa_budget_versions.object_id%TYPE
396 := FND_API.G_MISS_NUM
397 ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
398 := FND_API.G_MISS_CHAR
399 ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
400 := FND_API.G_MISS_CHAR
401 ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
402 := FND_API.G_MISS_CHAR
403 ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
404 := FND_API.G_MISS_NUM
405 ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
406 := FND_API.G_MISS_CHAR
407 ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
408 := FND_API.G_MISS_CHAR
409 ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
410 := FND_API.G_MISS_CHAR
411 ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
412 := FND_API.G_MISS_NUM
413 ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
414 := FND_API.G_MISS_DATE
415 ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE
416 := FND_API.G_MISS_CHAR
417 -- Bug 3354518: end of new columns for FP-M
418 ,p_row_id IN ROWID
419 := NULL
420 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
421
422 PROCEDURE Lock_Row
423 ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
424 ,p_record_version_number IN NUMBER
425 := NULL
426 ,p_row_id IN ROWID
427 := NULL
428 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
429
430 PROCEDURE Delete_Row
431 ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
432 ,p_record_version_number IN NUMBER
433 := NULL
434 ,p_row_id IN ROWID
435 := NULL
436 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
437
438 END pa_fp_budget_versions_pkg;