1 PACKAGE FA_TRANS_API_PUB AUTHID CURRENT_USER AS
2 /* $Header: FAPTAPIS.pls 120.12.12020000.2 2012/07/23 09:56:58 rmandali ship $ */
3
4 PROCEDURE do_addition (
5 -- Standard Parameters --
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11 x_msg_count OUT NOCOPY NUMBER,
12 x_msg_data OUT NOCOPY VARCHAR2,
13 p_calling_fn IN VARCHAR2,
14 -- API Options --
15 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
16 -- Out Parameters --
17 x_asset_id OUT NOCOPY NUMBER,
18 x_asset_number OUT NOCOPY VARCHAR2,
19 x_transaction_header_id OUT NOCOPY NUMBER,
20 x_dist_transaction_header_id OUT NOCOPY NUMBER,
21 -- Transaction Info (Books) --
22 p_transaction_date_entered IN DATE DEFAULT NULL,
23 p_transaction_name IN VARCHAR2 DEFAULT NULL,
24 p_transaction_subtype IN VARCHAR2 DEFAULT NULL,
25 p_amortization_start_date IN DATE DEFAULT NULL,
26 p_mass_reference_id IN NUMBER DEFAULT NULL,
27 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
28 p_last_update_date IN DATE,
29 p_last_updated_by IN NUMBER,
30 p_created_by IN NUMBER,
31 p_creation_date IN DATE,
32 p_last_update_login IN NUMBER,
33 p_attribute1 IN VARCHAR2 DEFAULT NULL,
34 p_attribute2 IN VARCHAR2 DEFAULT NULL,
35 p_attribute3 IN VARCHAR2 DEFAULT NULL,
36 p_attribute4 IN VARCHAR2 DEFAULT NULL,
37 p_attribute5 IN VARCHAR2 DEFAULT NULL,
38 p_attribute6 IN VARCHAR2 DEFAULT NULL,
39 p_attribute7 IN VARCHAR2 DEFAULT NULL,
40 p_attribute8 IN VARCHAR2 DEFAULT NULL,
41 p_attribute9 IN VARCHAR2 DEFAULT NULL,
42 p_attribute10 IN VARCHAR2 DEFAULT NULL,
43 p_attribute11 IN VARCHAR2 DEFAULT NULL,
44 p_attribute12 IN VARCHAR2 DEFAULT NULL,
45 p_attribute13 IN VARCHAR2 DEFAULT NULL,
46 p_attribute14 IN VARCHAR2 DEFAULT NULL,
47 p_attribute15 IN VARCHAR2 DEFAULT NULL,
48 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
49 -- Transaction Info (Distributions) --
50 p_dist_transaction_name IN VARCHAR2 DEFAULT NULL,
51 p_dist_attribute1 IN VARCHAR2 DEFAULT NULL,
52 p_dist_attribute2 IN VARCHAR2 DEFAULT NULL,
53 p_dist_attribute3 IN VARCHAR2 DEFAULT NULL,
54 p_dist_attribute4 IN VARCHAR2 DEFAULT NULL,
55 p_dist_attribute5 IN VARCHAR2 DEFAULT NULL,
56 p_dist_attribute6 IN VARCHAR2 DEFAULT NULL,
57 p_dist_attribute7 IN VARCHAR2 DEFAULT NULL,
58 p_dist_attribute8 IN VARCHAR2 DEFAULT NULL,
59 p_dist_attribute9 IN VARCHAR2 DEFAULT NULL,
60 p_dist_attribute10 IN VARCHAR2 DEFAULT NULL,
61 p_dist_attribute11 IN VARCHAR2 DEFAULT NULL,
62 p_dist_attribute12 IN VARCHAR2 DEFAULT NULL,
63 p_dist_attribute13 IN VARCHAR2 DEFAULT NULL,
64 p_dist_attribute14 IN VARCHAR2 DEFAULT NULL,
65 p_dist_attribute15 IN VARCHAR2 DEFAULT NULL,
66 p_dist_attribute_category_code IN VARCHAR2 DEFAULT NULL,
67 -- Asset Header Info --
68 p_asset_id IN NUMBER DEFAULT NULL,
69 p_book_type_code IN VARCHAR2,
70 p_set_of_books_id IN NUMBER DEFAULT NULL,
71 -- Asset Description Info --
72 p_asset_number IN VARCHAR2 DEFAULT NULL,
73 p_description IN VARCHAR2,
74 p_tag_number IN VARCHAR2 DEFAULT NULL,
75 p_serial_number IN VARCHAR2 DEFAULT NULL,
76 p_asset_key_ccid IN NUMBER DEFAULT NULL,
77 p_parent_asset_id IN NUMBER DEFAULT NULL,
78 p_status IN VARCHAR2 DEFAULT NULL,
79 p_manufacturer_name IN VARCHAR2 DEFAULT NULL,
80 p_model_number IN VARCHAR2 DEFAULT NULL,
81 p_warranty_id IN NUMBER DEFAULT NULL,
82 p_property_type_code IN VARCHAR2,
83 p_property_1245_1250_code IN VARCHAR2,
84 p_in_use_flag IN VARCHAR2,
85 p_inventorial IN VARCHAR2 DEFAULT NULL,
86 p_commitment IN VARCHAR2 DEFAULT NULL,
87 p_investment_law IN VARCHAR2 DEFAULT NULL,
88 p_owned_leased IN VARCHAR2,
89 p_new_used IN VARCHAR2,
90 p_lease_id IN NUMBER DEFAULT NULL,
91 p_ls_attribute1 IN VARCHAR2 DEFAULT NULL,
92 p_ls_attribute2 IN VARCHAR2 DEFAULT NULL,
93 p_ls_attribute3 IN VARCHAR2 DEFAULT NULL,
94 p_ls_attribute4 IN VARCHAR2 DEFAULT NULL,
95 p_ls_attribute5 IN VARCHAR2 DEFAULT NULL,
96 p_ls_attribute6 IN VARCHAR2 DEFAULT NULL,
97 p_ls_attribute7 IN VARCHAR2 DEFAULT NULL,
98 p_ls_attribute8 IN VARCHAR2 DEFAULT NULL,
99 p_ls_attribute9 IN VARCHAR2 DEFAULT NULL,
100 p_ls_attribute10 IN VARCHAR2 DEFAULT NULL,
101 p_ls_attribute11 IN VARCHAR2 DEFAULT NULL,
102 p_ls_attribute12 IN VARCHAR2 DEFAULT NULL,
103 p_ls_attribute13 IN VARCHAR2 DEFAULT NULL,
104 p_ls_attribute14 IN VARCHAR2 DEFAULT NULL,
105 p_ls_attribute15 IN VARCHAR2 DEFAULT NULL,
106 p_ls_attribute_category_code IN VARCHAR2 DEFAULT NULL,
107 p_ad_global_attribute1 IN VARCHAR2 DEFAULT NULL,
108 p_ad_global_attribute2 IN VARCHAR2 DEFAULT NULL,
109 p_ad_global_attribute3 IN VARCHAR2 DEFAULT NULL,
110 p_ad_global_attribute4 IN VARCHAR2 DEFAULT NULL,
111 p_ad_global_attribute5 IN VARCHAR2 DEFAULT NULL,
112 p_ad_global_attribute6 IN VARCHAR2 DEFAULT NULL,
113 p_ad_global_attribute7 IN VARCHAR2 DEFAULT NULL,
114 p_ad_global_attribute8 IN VARCHAR2 DEFAULT NULL,
115 p_ad_global_attribute9 IN VARCHAR2 DEFAULT NULL,
116 p_ad_global_attribute10 IN VARCHAR2 DEFAULT NULL,
117 p_ad_global_attribute11 IN VARCHAR2 DEFAULT NULL,
118 p_ad_global_attribute12 IN VARCHAR2 DEFAULT NULL,
119 p_ad_global_attribute13 IN VARCHAR2 DEFAULT NULL,
120 p_ad_global_attribute14 IN VARCHAR2 DEFAULT NULL,
121 p_ad_global_attribute15 IN VARCHAR2 DEFAULT NULL,
122 p_ad_global_attribute16 IN VARCHAR2 DEFAULT NULL,
123 p_ad_global_attribute17 IN VARCHAR2 DEFAULT NULL,
124 p_ad_global_attribute18 IN VARCHAR2 DEFAULT NULL,
125 p_ad_global_attribute19 IN VARCHAR2 DEFAULT NULL,
126 p_ad_global_attribute20 IN VARCHAR2 DEFAULT NULL,
127 p_ad_global_attribute_category IN VARCHAR2 DEFAULT NULL,
128 -- Asset Type Info --
129 p_asset_type IN VARCHAR2,
130 -- Asset Category Info --
131 p_category_id IN NUMBER,
132 p_cat_attribute1 IN VARCHAR2 DEFAULT NULL,
133 p_cat_attribute2 IN VARCHAR2 DEFAULT NULL,
134 p_cat_attribute3 IN VARCHAR2 DEFAULT NULL,
135 p_cat_attribute4 IN VARCHAR2 DEFAULT NULL,
136 p_cat_attribute5 IN VARCHAR2 DEFAULT NULL,
137 p_cat_attribute6 IN VARCHAR2 DEFAULT NULL,
138 p_cat_attribute7 IN VARCHAR2 DEFAULT NULL,
139 p_cat_attribute8 IN VARCHAR2 DEFAULT NULL,
140 p_cat_attribute9 IN VARCHAR2 DEFAULT NULL,
141 p_cat_attribute10 IN VARCHAR2 DEFAULT NULL,
142 p_cat_attribute11 IN VARCHAR2 DEFAULT NULL,
143 p_cat_attribute12 IN VARCHAR2 DEFAULT NULL,
144 p_cat_attribute13 IN VARCHAR2 DEFAULT NULL,
145 p_cat_attribute14 IN VARCHAR2 DEFAULT NULL,
146 p_cat_attribute15 IN VARCHAR2 DEFAULT NULL,
147 p_cat_attribute16 IN VARCHAR2 DEFAULT NULL,
148 p_cat_attribute17 IN VARCHAR2 DEFAULT NULL,
149 p_cat_attribute18 IN VARCHAR2 DEFAULT NULL,
150 p_cat_attribute19 IN VARCHAR2 DEFAULT NULL,
151 p_cat_attribute20 IN VARCHAR2 DEFAULT NULL,
152 p_cat_attribute21 IN VARCHAR2 DEFAULT NULL,
153 p_cat_attribute22 IN VARCHAR2 DEFAULT NULL,
154 p_cat_attribute23 IN VARCHAR2 DEFAULT NULL,
155 p_cat_attribute24 IN VARCHAR2 DEFAULT NULL,
156 p_cat_attribute25 IN VARCHAR2 DEFAULT NULL,
157 p_cat_attribute26 IN VARCHAR2 DEFAULT NULL,
158 p_cat_attribute27 IN VARCHAR2 DEFAULT NULL,
159 p_cat_attribute28 IN VARCHAR2 DEFAULT NULL,
160 p_cat_attribute29 IN VARCHAR2 DEFAULT NULL,
161 p_cat_attribute30 IN VARCHAR2 DEFAULT NULL,
162 p_cat_attribute_category_code IN VARCHAR2 DEFAULT NULL,
163 p_context IN VARCHAR2 DEFAULT NULL,
164 -- Asset Hierarchy Info --
165 p_parent_hierarchy_id IN NUMBER DEFAULT NULL,
166 -- Asset Financial Info --
167 p_cost IN NUMBER,
168 p_original_cost IN NUMBER,
169 p_unrevalued_cost IN NUMBER DEFAULT NULL,
170 p_salvage_value IN NUMBER,
171 p_ceiling_name IN VARCHAR2 DEFAULT NULL,
172 p_reval_ceiling IN NUMBER DEFAULT NULL,
173 p_depreciate_flag IN VARCHAR2,
174 -- HH group ed.
175 p_disabled_flag IN VARCHAR2 DEFAULT NULL,
176 p_date_placed_in_service IN DATE,
177 p_prorate_convention_code IN VARCHAR2,
178 p_deprn_method_code IN VARCHAR2,
179 p_life_in_months IN NUMBER DEFAULT NULL,
180 p_basic_rate IN NUMBER DEFAULT NULL,
181 p_adjusted_rate IN NUMBER DEFAULT NULL,
182 p_production_capacity IN NUMBER DEFAULT NULL,
183 p_unit_of_measure IN VARCHAR2 DEFAULT NULL,
184 p_bonus_rule IN VARCHAR2 DEFAULT NULL,
185 p_itc_amount_id IN NUMBER DEFAULT NULL,
186 p_short_fiscal_year_flag IN VARCHAR2 DEFAULT NULL,
187 p_conversion_date IN DATE DEFAULT NULL,
188 p_orig_deprn_start_date IN DATE DEFAULT NULL,
189 p_group_asset_id IN NUMBER DEFAULT NULL,
190 /* toru */
191 -- Addition for Group Depreciation
192 p_percent_salvage_value IN NUMBER DEFAULT NULL,
193 p_allowed_deprn_limit IN NUMBER DEFAULT NULL,
194 p_allowed_deprn_limit_amount IN NUMBER DEFAULT NULL,
195 p_super_group_id IN NUMBER DEFAULT NULL,
196 p_reduction_rate IN NUMBER DEFAULT NULL,
197 p_reduce_addition_flag IN VARCHAR2 DEFAULT NULL,
198 p_reduce_adjustment_flag IN VARCHAR2 DEFAULT NULL,
199 p_reduce_retirement_flag IN VARCHAR2 DEFAULT NULL,
200 p_over_depreciate_option IN VARCHAR2 DEFAULT NULL,
201 p_recognize_gain_loss IN VARCHAR2 DEFAULT NULL,
202 p_recapture_reserve_flag IN VARCHAR2 DEFAULT NULL,
203 p_limit_proceeds_flag IN VARCHAR2 DEFAULT NULL,
204 p_terminal_gain_loss IN VARCHAR2 DEFAULT NULL,
205 p_exclude_proceeds_from_basis IN VARCHAR2 DEFAULT NULL,
206 p_retirement_deprn_option IN VARCHAR2 DEFAULT NULL,
207 p_salvage_type IN VARCHAR2 DEFAULT NULL,
208 p_deprn_limit_type IN VARCHAR2 DEFAULT NULL,
209 p_tracking_method IN VARCHAR2 DEFAULT NULL,
210 p_allocate_to_fully_rsv_flag IN VARCHAR2 DEFAULT NULL,
211 p_allocate_to_fully_ret_flag IN VARCHAR2 DEFAULT NULL,
212 p_excess_allocation_option IN VARCHAR2 DEFAULT NULL,
213 p_depreciation_option IN VARCHAR2 DEFAULT NULL,
214 p_member_rollup_flag IN VARCHAR2 DEFAULT NULL,
215 p_ytd_proceeds IN NUMBER DEFAULT NULL,
216 p_ltd_proceeds IN NUMBER DEFAULT NULL,
217 p_exclude_fully_rsv_flag IN VARCHAR2 DEFAULT NULL,
218 p_eofy_reserve IN NUMBER DEFAULT NULL,
219 p_reclass_transfer_type IN VARCHAR2 DEFAULT NULL,
220 p_reclass_transfer_amount IN NUMBER DEFAULT NULL,
221 p_reclass_src_expense IN NUMBER DEFAULT NULL,
222 p_reclass_dest_expense IN NUMBER DEFAULT NULL,
223 p_reclass_src_eofy_reserve IN NUMBER DEFAULT NULL,
224 p_reclass_dest_eofy_reserve IN NUMBER DEFAULT NULL,
225 -- End of Addition for Group Depreciation
226 /* Etoru */
227 p_bk_global_attribute1 IN VARCHAR2 DEFAULT NULL,
228 p_bk_global_attribute2 IN VARCHAR2 DEFAULT NULL,
229 p_bk_global_attribute3 IN VARCHAR2 DEFAULT NULL,
230 p_bk_global_attribute4 IN VARCHAR2 DEFAULT NULL,
231 p_bk_global_attribute5 IN VARCHAR2 DEFAULT NULL,
232 p_bk_global_attribute6 IN VARCHAR2 DEFAULT NULL,
233 p_bk_global_attribute7 IN VARCHAR2 DEFAULT NULL,
234 p_bk_global_attribute8 IN VARCHAR2 DEFAULT NULL,
238 p_bk_global_attribute12 IN VARCHAR2 DEFAULT NULL,
235 p_bk_global_attribute9 IN VARCHAR2 DEFAULT NULL,
236 p_bk_global_attribute10 IN VARCHAR2 DEFAULT NULL,
237 p_bk_global_attribute11 IN VARCHAR2 DEFAULT NULL,
239 p_bk_global_attribute13 IN VARCHAR2 DEFAULT NULL,
240 p_bk_global_attribute14 IN VARCHAR2 DEFAULT NULL,
241 p_bk_global_attribute15 IN VARCHAR2 DEFAULT NULL,
242 p_bk_global_attribute16 IN VARCHAR2 DEFAULT NULL,
243 p_bk_global_attribute17 IN VARCHAR2 DEFAULT NULL,
244 p_bk_global_attribute18 IN VARCHAR2 DEFAULT NULL,
245 p_bk_global_attribute19 IN VARCHAR2 DEFAULT NULL,
246 p_bk_global_attribute20 IN VARCHAR2 DEFAULT NULL,
247 p_bk_global_attribute_category IN VARCHAR2 DEFAULT NULL,
248 -- Asset Depreciation Info --
249 p_ytd_deprn IN NUMBER DEFAULT NULL,
250 p_deprn_reserve IN NUMBER DEFAULT NULL,
251 p_reval_deprn_reserve IN NUMBER DEFAULT NULL,
252 p_ytd_production IN NUMBER DEFAULT NULL,
253 p_ltd_production IN NUMBER DEFAULT NULL,
254 -- IAS36 Impairment Info --
255 p_cash_generating_unit_id IN NUMBER DEFAULT NULL,
256 p_nbv_at_switch IN NUMBER DEFAULT NULL, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
257 p_prior_deprn_limit_type IN VARCHAR2 DEFAULT NULL,
258 p_prior_deprn_limit_amount IN NUMBER DEFAULT NULL,
259 p_prior_deprn_limit IN NUMBER DEFAULT NULL,
260 p_period_counter_fully_rsrved IN NUMBER DEFAULT NULL,
261 p_extended_depreciation_period IN NUMBER DEFAULT NULL,
262 p_prior_deprn_method IN VARCHAR2 DEFAULT NULL,
263 p_prior_life_in_months IN NUMBER DEFAULT NULL,
264 p_prior_basic_rate IN NUMBER DEFAULT NULL,
265 p_prior_adjusted_rate IN NUMBER DEFAULT NULL,
266 p_extended_deprn_flag IN VARCHAR2 DEFAULT NULL
267 -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
268
269 );
270
271
272 PROCEDURE do_adjustment (
273 -- Standard Parameters --
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
276 p_commit IN VARCHAR2 := FND_API.G_FALSE,
277 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2,
281 p_calling_fn IN VARCHAR2,
282 -- API Options --
283 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
284 p_reset_miss_flag IN VARCHAR2 DEFAULT 'NO',
285 -- Out Parameters --
286 x_transaction_header_id OUT NOCOPY NUMBER,
287 -- Transaction Info (Books) --
288 p_transaction_date_entered IN DATE DEFAULT NULL,
289 p_transaction_name IN VARCHAR2 DEFAULT NULL,
290 p_transaction_subtype IN VARCHAR2 DEFAULT NULL,
291 p_amortization_start_date IN DATE DEFAULT NULL,
292 p_mass_reference_id IN NUMBER DEFAULT NULL,
293 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
294 p_last_update_date IN DATE,
295 p_last_updated_by IN NUMBER,
296 p_created_by IN NUMBER,
297 p_creation_date IN DATE,
298 p_last_update_login IN NUMBER,
299 p_attribute1 IN VARCHAR2 DEFAULT NULL,
300 p_attribute2 IN VARCHAR2 DEFAULT NULL,
301 p_attribute3 IN VARCHAR2 DEFAULT NULL,
302 p_attribute4 IN VARCHAR2 DEFAULT NULL,
303 p_attribute5 IN VARCHAR2 DEFAULT NULL,
304 p_attribute6 IN VARCHAR2 DEFAULT NULL,
305 p_attribute7 IN VARCHAR2 DEFAULT NULL,
306 p_attribute8 IN VARCHAR2 DEFAULT NULL,
307 p_attribute9 IN VARCHAR2 DEFAULT NULL,
308 p_attribute10 IN VARCHAR2 DEFAULT NULL,
309 p_attribute11 IN VARCHAR2 DEFAULT NULL,
310 p_attribute12 IN VARCHAR2 DEFAULT NULL,
311 p_attribute13 IN VARCHAR2 DEFAULT NULL,
312 p_attribute14 IN VARCHAR2 DEFAULT NULL,
313 p_attribute15 IN VARCHAR2 DEFAULT NULL,
314 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
315 -- Asset Header Info --
316 p_asset_id IN NUMBER,
317 p_book_type_code IN VARCHAR2,
318 p_set_of_books_id IN NUMBER DEFAULT NULL,
319 -- Asset Financial Info --
320 p_cost IN NUMBER DEFAULT NULL,
321 p_original_cost IN NUMBER DEFAULT NULL,
322 p_unrevalued_cost IN NUMBER DEFAULT NULL,
323 p_recoverable_cost IN NUMBER DEFAULT NULL,
324 p_salvage_value IN NUMBER DEFAULT NULL,
325 p_ceiling_name IN VARCHAR2 DEFAULT NULL,
326 p_reval_ceiling IN NUMBER DEFAULT NULL,
327 p_depreciate_flag IN VARCHAR2 DEFAULT NULL,
328 -- HH group ed.
329 p_disabled_flag IN VARCHAR2 DEFAULT NULL,
330 p_date_placed_in_service IN DATE DEFAULT NULL,
331 p_prorate_convention_code IN VARCHAR2 DEFAULT NULL,
332 p_deprn_method_code IN VARCHAR2 DEFAULT NULL,
336 p_production_capacity IN NUMBER DEFAULT NULL,
333 p_life_in_months IN NUMBER DEFAULT NULL,
334 p_basic_rate IN NUMBER DEFAULT NULL,
335 p_adjusted_rate IN NUMBER DEFAULT NULL,
337 p_unit_of_measure IN VARCHAR2 DEFAULT NULL,
338 p_bonus_rule IN VARCHAR2 DEFAULT NULL,
339 p_itc_amount_id IN NUMBER DEFAULT NULL,
340 p_short_fiscal_year_flag IN VARCHAR2 DEFAULT NULL,
341 p_conversion_date IN DATE DEFAULT NULL,
342 p_orig_deprn_start_date IN DATE DEFAULT NULL,
343 p_group_asset_id IN NUMBER DEFAULT NULL,
344 /* toru */
345 -- Addition for Group Depreciation
346 p_percent_salvage_value IN NUMBER DEFAULT NULL,
347 p_allowed_deprn_limit IN NUMBER DEFAULT NULL,
348 p_allowed_deprn_limit_amount IN NUMBER DEFAULT NULL,
349 p_super_group_id IN NUMBER DEFAULT NULL,
350 p_reduction_rate IN NUMBER DEFAULT NULL,
351 p_reduce_addition_flag IN VARCHAR2 DEFAULT NULL,
352 p_reduce_adjustment_flag IN VARCHAR2 DEFAULT NULL,
353 p_reduce_retirement_flag IN VARCHAR2 DEFAULT NULL,
354 p_over_depreciate_option IN VARCHAR2 DEFAULT NULL,
355 p_recognize_gain_loss IN VARCHAR2 DEFAULT NULL,
356 p_recapture_reserve_flag IN VARCHAR2 DEFAULT NULL,
357 p_limit_proceeds_flag IN VARCHAR2 DEFAULT NULL,
358 p_terminal_gain_loss IN VARCHAR2 DEFAULT NULL,
359 p_exclude_proceeds_from_basis IN VARCHAR2 DEFAULT NULL,
360 p_retirement_deprn_option IN VARCHAR2 DEFAULT NULL,
361 p_salvage_type IN VARCHAR2 DEFAULT NULL,
362 p_deprn_limit_type IN VARCHAR2 DEFAULT NULL,
363 p_tracking_method IN VARCHAR2 DEFAULT NULL,
364 p_allocate_to_fully_rsv_flag IN VARCHAR2 DEFAULT NULL,
365 p_allocate_to_fully_ret_flag IN VARCHAR2 DEFAULT NULL,
366 p_excess_allocation_option IN VARCHAR2 DEFAULT NULL,
367 p_depreciation_option IN VARCHAR2 DEFAULT NULL,
368 p_member_rollup_flag IN VARCHAR2 DEFAULT NULL,
369 p_ytd_proceeds IN NUMBER DEFAULT NULL,
370 p_ltd_proceeds IN NUMBER DEFAULT NULL,
371 p_exclude_fully_rsv_flag IN VARCHAR2 DEFAULT NULL,
372 p_eofy_reserve IN NUMBER DEFAULT NULL,
373 p_reclass_transfer_type IN VARCHAR2 DEFAULT NULL,
374 p_reclass_transfer_amount IN NUMBER DEFAULT NULL,
375 p_reclass_src_expense IN NUMBER DEFAULT NULL,
376 p_reclass_dest_expense IN NUMBER DEFAULT NULL,
377 p_reclass_src_eofy_reserve IN NUMBER DEFAULT NULL,
378 p_reclass_dest_eofy_reserve IN NUMBER DEFAULT NULL,
379 -- End of Addition for Group Depreciation
380 /* Etoru */
381 p_bk_global_attribute1 IN VARCHAR2 DEFAULT NULL,
382 p_bk_global_attribute2 IN VARCHAR2 DEFAULT NULL,
383 p_bk_global_attribute3 IN VARCHAR2 DEFAULT NULL,
384 p_bk_global_attribute4 IN VARCHAR2 DEFAULT NULL,
385 p_bk_global_attribute5 IN VARCHAR2 DEFAULT NULL,
386 p_bk_global_attribute6 IN VARCHAR2 DEFAULT NULL,
387 p_bk_global_attribute7 IN VARCHAR2 DEFAULT NULL,
388 p_bk_global_attribute8 IN VARCHAR2 DEFAULT NULL,
389 p_bk_global_attribute9 IN VARCHAR2 DEFAULT NULL,
390 p_bk_global_attribute10 IN VARCHAR2 DEFAULT NULL,
391 p_bk_global_attribute11 IN VARCHAR2 DEFAULT NULL,
392 p_bk_global_attribute12 IN VARCHAR2 DEFAULT NULL,
393 p_bk_global_attribute13 IN VARCHAR2 DEFAULT NULL,
394 p_bk_global_attribute14 IN VARCHAR2 DEFAULT NULL,
395 p_bk_global_attribute15 IN VARCHAR2 DEFAULT NULL,
396 p_bk_global_attribute16 IN VARCHAR2 DEFAULT NULL,
397 p_bk_global_attribute17 IN VARCHAR2 DEFAULT NULL,
398 p_bk_global_attribute18 IN VARCHAR2 DEFAULT NULL,
399 p_bk_global_attribute19 IN VARCHAR2 DEFAULT NULL,
400 p_bk_global_attribute20 IN VARCHAR2 DEFAULT NULL,
401 p_bk_global_attribute_category IN VARCHAR2 DEFAULT NULL,
402 -- Asset Depreciation Info --
403 p_ytd_deprn IN NUMBER DEFAULT NULL,
404 p_deprn_reserve IN NUMBER DEFAULT NULL,
405 p_reval_deprn_reserve IN NUMBER DEFAULT NULL,
406 p_ytd_production IN NUMBER DEFAULT NULL,
407 p_ltd_production IN NUMBER DEFAULT NULL,
408 -- Invoice Info --
409 p_invoice_transaction_type IN VARCHAR2 DEFAULT NULL,
410 -- Group Reclass Options --
411 p_transfer_flag IN VARCHAR2 DEFAULT NULL,
412 p_manual_amount IN NUMBER DEFAULT NULL,
413 p_manual_flag IN VARCHAR2 DEFAULT NULL,
414 -- IAS36 Impairment Info --
415 p_cash_generating_unit_id IN NUMBER DEFAULT NULL,
416 p_nbv_at_switch IN NUMBER DEFAULT NULL, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
417 p_prior_deprn_limit_type IN VARCHAR2 DEFAULT NULL,
418 p_prior_deprn_limit_amount IN NUMBER DEFAULT NULL,
419 p_prior_deprn_limit IN NUMBER DEFAULT NULL,
420 p_period_counter_fully_rsrved IN VARCHAR2 DEFAULT NULL,
421 p_extended_depreciation_period IN VARCHAR2 DEFAULT NULL,
422 p_prior_deprn_method IN VARCHAR2 DEFAULT NULL,
423 p_prior_life_in_months IN NUMBER DEFAULT NULL,
424 p_prior_basic_rate IN NUMBER DEFAULT NULL,
428 );
425 p_prior_adjusted_rate IN NUMBER DEFAULT NULL,
426 p_extended_deprn_flag IN VARCHAR2 DEFAULT NULL
427 -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
429
430 PROCEDURE do_unit_adjustment(
431 -- Standard Parameters --
432 p_api_version IN NUMBER,
433 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
434 p_commit IN VARCHAR2 := FND_API.G_FALSE,
435 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
436 x_return_status OUT NOCOPY VARCHAR2,
437 x_msg_count OUT NOCOPY NUMBER,
438 x_msg_data OUT NOCOPY VARCHAR2,
439 p_calling_fn IN VARCHAR2,
440 -- API Options --
441 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
442 -- Out Parameters --
443 x_transaction_header_id OUT NOCOPY NUMBER,
444 -- Transaction Info --
445 p_transaction_date_entered IN DATE DEFAULT NULL,
446 p_transaction_name IN VARCHAR2 DEFAULT NULL,
447 p_mass_reference_id IN NUMBER DEFAULT NULL,
448 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
449 p_last_update_date IN DATE,
450 p_last_updated_by IN NUMBER,
451 p_created_by IN NUMBER,
452 p_creation_date IN DATE,
453 p_last_update_login IN NUMBER,
454 p_attribute1 IN VARCHAR2 DEFAULT NULL,
455 p_attribute2 IN VARCHAR2 DEFAULT NULL,
456 p_attribute3 IN VARCHAR2 DEFAULT NULL,
457 p_attribute4 IN VARCHAR2 DEFAULT NULL,
458 p_attribute5 IN VARCHAR2 DEFAULT NULL,
459 p_attribute6 IN VARCHAR2 DEFAULT NULL,
460 p_attribute7 IN VARCHAR2 DEFAULT NULL,
461 p_attribute8 IN VARCHAR2 DEFAULT NULL,
462 p_attribute9 IN VARCHAR2 DEFAULT NULL,
463 p_attribute10 IN VARCHAR2 DEFAULT NULL,
464 p_attribute11 IN VARCHAR2 DEFAULT NULL,
465 p_attribute12 IN VARCHAR2 DEFAULT NULL,
466 p_attribute13 IN VARCHAR2 DEFAULT NULL,
467 p_attribute14 IN VARCHAR2 DEFAULT NULL,
468 p_attribute15 IN VARCHAR2 DEFAULT NULL,
469 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
470 -- Asset Header Info --
471 p_asset_id IN NUMBER,
472 p_book_type_code IN VARCHAR2,
473 p_set_of_books_id IN NUMBER DEFAULT NULL
474 );
475
476 PROCEDURE do_transfer(
477 -- Standard Parameters --
478 p_api_version IN NUMBER,
479 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
480 p_commit IN VARCHAR2 := FND_API.G_FALSE,
481 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482 x_return_status OUT NOCOPY VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484 x_msg_data OUT NOCOPY VARCHAR2,
485 p_calling_fn IN VARCHAR2,
486 -- API Options --
487 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
488 -- Out Parameters --
489 x_transaction_header_id OUT NOCOPY NUMBER,
490 -- Transaction Info --
491 p_transaction_date_entered IN DATE DEFAULT NULL,
492 p_transaction_name IN VARCHAR2 DEFAULT NULL,
493 p_mass_reference_id IN NUMBER DEFAULT NULL,
494 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
495 p_last_update_date IN DATE,
496 p_last_updated_by IN NUMBER,
497 p_created_by IN NUMBER,
498 p_creation_date IN DATE,
499 p_last_update_login IN NUMBER,
500 p_attribute1 IN VARCHAR2 DEFAULT NULL,
501 p_attribute2 IN VARCHAR2 DEFAULT NULL,
502 p_attribute3 IN VARCHAR2 DEFAULT NULL,
503 p_attribute4 IN VARCHAR2 DEFAULT NULL,
504 p_attribute5 IN VARCHAR2 DEFAULT NULL,
505 p_attribute6 IN VARCHAR2 DEFAULT NULL,
506 p_attribute7 IN VARCHAR2 DEFAULT NULL,
507 p_attribute8 IN VARCHAR2 DEFAULT NULL,
508 p_attribute9 IN VARCHAR2 DEFAULT NULL,
509 p_attribute10 IN VARCHAR2 DEFAULT NULL,
510 p_attribute11 IN VARCHAR2 DEFAULT NULL,
511 p_attribute12 IN VARCHAR2 DEFAULT NULL,
512 p_attribute13 IN VARCHAR2 DEFAULT NULL,
513 p_attribute14 IN VARCHAR2 DEFAULT NULL,
514 p_attribute15 IN VARCHAR2 DEFAULT NULL,
515 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
516 -- Asset Header Info --
517 p_asset_id IN NUMBER,
518 p_book_type_code IN VARCHAR2,
519 p_set_of_books_id IN NUMBER DEFAULT NULL
520 );
521
522 PROCEDURE do_invoice_transfer (
523 -- Standard Parameters --
524 p_api_version IN NUMBER,
525 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
526 p_commit IN VARCHAR2 := FND_API.G_FALSE,
527 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
528 x_return_status OUT NOCOPY VARCHAR2,
532 -- API Options --
529 x_msg_count OUT NOCOPY NUMBER,
530 x_msg_data OUT NOCOPY VARCHAR2,
531 p_calling_fn IN VARCHAR2,
533 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
534 -- Out Parameters --
535 x_src_transaction_header_id OUT NOCOPY NUMBER,
536 x_dest_transaction_header_id OUT NOCOPY NUMBER,
537 -- Transaction Info --
538 p_transaction_date_entered IN DATE DEFAULT NULL,
539 p_amortization_start_date IN DATE DEFAULT NULL,
540 p_mass_reference_id IN NUMBER DEFAULT NULL,
541 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
542 p_last_update_date IN DATE,
543 p_last_updated_by IN NUMBER,
544 p_created_by IN NUMBER,
545 p_creation_date IN DATE,
546 p_last_update_login IN NUMBER,
547 -- Source Asset Header Info --
548 p_src_asset_id IN NUMBER,
549 p_book_type_code IN VARCHAR2,
550 p_set_of_books_id IN NUMBER DEFAULT NULL,
551 -- Destination Asset Header Info --
552 p_dest_asset_id IN NUMBER
553 );
554
555 PROCEDURE do_reclass(
556 -- Standard Parameters --
557 p_api_version IN NUMBER,
558 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
559 p_commit IN VARCHAR2 := FND_API.G_FALSE,
560 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
561 x_return_status OUT NOCOPY VARCHAR2,
562 x_msg_count OUT NOCOPY NUMBER,
563 x_msg_data OUT NOCOPY VARCHAR2,
564 p_calling_fn IN VARCHAR2,
565 -- API Options --
566 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
567 -- Out Parameters --
568 x_transaction_header_id OUT NOCOPY NUMBER,
569 -- Transaction Info --
570 p_transaction_date_entered IN DATE DEFAULT NULL,
571 p_transaction_name IN VARCHAR2 DEFAULT NULL,
572 p_transaction_subtype IN VARCHAR2 DEFAULT NULL,
573 p_amortization_start_date IN DATE DEFAULT NULL,
574 p_mass_reference_id IN NUMBER DEFAULT NULL,
575 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
576 p_last_update_date IN DATE,
577 p_last_updated_by IN NUMBER,
578 p_created_by IN NUMBER,
579 p_creation_date IN DATE,
580 p_last_update_login IN NUMBER,
581 p_attribute1 IN VARCHAR2 DEFAULT NULL,
582 p_attribute2 IN VARCHAR2 DEFAULT NULL,
583 p_attribute3 IN VARCHAR2 DEFAULT NULL,
584 p_attribute4 IN VARCHAR2 DEFAULT NULL,
585 p_attribute5 IN VARCHAR2 DEFAULT NULL,
586 p_attribute6 IN VARCHAR2 DEFAULT NULL,
587 p_attribute7 IN VARCHAR2 DEFAULT NULL,
588 p_attribute8 IN VARCHAR2 DEFAULT NULL,
589 p_attribute9 IN VARCHAR2 DEFAULT NULL,
590 p_attribute10 IN VARCHAR2 DEFAULT NULL,
591 p_attribute11 IN VARCHAR2 DEFAULT NULL,
592 p_attribute12 IN VARCHAR2 DEFAULT NULL,
593 p_attribute13 IN VARCHAR2 DEFAULT NULL,
594 p_attribute14 IN VARCHAR2 DEFAULT NULL,
595 p_attribute15 IN VARCHAR2 DEFAULT NULL,
596 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
597 -- Asset Header Info --
598 p_asset_id IN NUMBER,
599 -- Asset Category Info --
600 p_new_category_id IN NUMBER,
601 p_cat_attribute1 IN VARCHAR2 DEFAULT NULL,
602 p_cat_attribute2 IN VARCHAR2 DEFAULT NULL,
603 p_cat_attribute3 IN VARCHAR2 DEFAULT NULL,
604 p_cat_attribute4 IN VARCHAR2 DEFAULT NULL,
605 p_cat_attribute5 IN VARCHAR2 DEFAULT NULL,
606 p_cat_attribute6 IN VARCHAR2 DEFAULT NULL,
607 p_cat_attribute7 IN VARCHAR2 DEFAULT NULL,
608 p_cat_attribute8 IN VARCHAR2 DEFAULT NULL,
609 p_cat_attribute9 IN VARCHAR2 DEFAULT NULL,
610 p_cat_attribute10 IN VARCHAR2 DEFAULT NULL,
611 p_cat_attribute11 IN VARCHAR2 DEFAULT NULL,
612 p_cat_attribute12 IN VARCHAR2 DEFAULT NULL,
613 p_cat_attribute13 IN VARCHAR2 DEFAULT NULL,
614 p_cat_attribute14 IN VARCHAR2 DEFAULT NULL,
615 p_cat_attribute15 IN VARCHAR2 DEFAULT NULL,
616 p_cat_attribute16 IN VARCHAR2 DEFAULT NULL,
617 p_cat_attribute17 IN VARCHAR2 DEFAULT NULL,
618 p_cat_attribute18 IN VARCHAR2 DEFAULT NULL,
619 p_cat_attribute19 IN VARCHAR2 DEFAULT NULL,
620 p_cat_attribute20 IN VARCHAR2 DEFAULT NULL,
621 p_cat_attribute21 IN VARCHAR2 DEFAULT NULL,
622 p_cat_attribute22 IN VARCHAR2 DEFAULT NULL,
623 p_cat_attribute23 IN VARCHAR2 DEFAULT NULL,
624 p_cat_attribute24 IN VARCHAR2 DEFAULT NULL,
625 p_cat_attribute25 IN VARCHAR2 DEFAULT NULL,
626 p_cat_attribute26 IN VARCHAR2 DEFAULT NULL,
627 p_cat_attribute27 IN VARCHAR2 DEFAULT NULL,
628 p_cat_attribute28 IN VARCHAR2 DEFAULT NULL,
632 p_context IN VARCHAR2 DEFAULT NULL,
629 p_cat_attribute29 IN VARCHAR2 DEFAULT NULL,
630 p_cat_attribute30 IN VARCHAR2 DEFAULT NULL,
631 p_cat_attribute_category_code IN VARCHAR2 DEFAULT NULL,
633 -- Reclass Options Info --
634 p_copy_cat_desc_flag IN VARCHAR2 DEFAULT 'NO',
635 p_redefault_flag IN VARCHAR2 DEFAULT 'NO'
636 );
637
638 PROCEDURE do_retirement(
639 -- Standard Parameters --
640 p_api_version IN NUMBER,
641 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
642 p_commit IN VARCHAR2 := FND_API.G_FALSE,
643 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
644 x_return_status OUT NOCOPY VARCHAR2,
645 x_msg_count OUT NOCOPY NUMBER,
646 x_msg_data OUT NOCOPY VARCHAR2,
647 p_calling_fn IN VARCHAR2,
648 -- API Options --
649 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
650 -- Out Parameters --
651 x_retirement_id OUT NOCOPY NUMBER,
652 x_transaction_header_id OUT NOCOPY NUMBER,
653 x_dist_transaction_header_id OUT NOCOPY NUMBER,
654 -- Transaction Info (Retirement) --
655 p_transaction_date_entered IN DATE DEFAULT NULL,
656 p_transaction_name IN VARCHAR2 DEFAULT NULL,
657 p_mass_reference_id IN NUMBER DEFAULT NULL,
658 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
659 p_last_update_date IN DATE,
660 p_last_updated_by IN NUMBER,
661 p_created_by IN NUMBER,
662 p_creation_date IN DATE,
663 p_last_update_login IN NUMBER,
664 p_attribute1 IN VARCHAR2 DEFAULT NULL,
665 p_attribute2 IN VARCHAR2 DEFAULT NULL,
666 p_attribute3 IN VARCHAR2 DEFAULT NULL,
667 p_attribute4 IN VARCHAR2 DEFAULT NULL,
668 p_attribute5 IN VARCHAR2 DEFAULT NULL,
669 p_attribute6 IN VARCHAR2 DEFAULT NULL,
670 p_attribute7 IN VARCHAR2 DEFAULT NULL,
671 p_attribute8 IN VARCHAR2 DEFAULT NULL,
672 p_attribute9 IN VARCHAR2 DEFAULT NULL,
673 p_attribute10 IN VARCHAR2 DEFAULT NULL,
674 p_attribute11 IN VARCHAR2 DEFAULT NULL,
675 p_attribute12 IN VARCHAR2 DEFAULT NULL,
676 p_attribute13 IN VARCHAR2 DEFAULT NULL,
677 p_attribute14 IN VARCHAR2 DEFAULT NULL,
678 p_attribute15 IN VARCHAR2 DEFAULT NULL,
679 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
680 -- Transaction Info (Distributions) --
681 p_dist_transaction_name IN VARCHAR2 DEFAULT NULL,
682 p_dist_attribute1 IN VARCHAR2 DEFAULT NULL,
683 p_dist_attribute2 IN VARCHAR2 DEFAULT NULL,
684 p_dist_attribute3 IN VARCHAR2 DEFAULT NULL,
685 p_dist_attribute4 IN VARCHAR2 DEFAULT NULL,
686 p_dist_attribute5 IN VARCHAR2 DEFAULT NULL,
687 p_dist_attribute6 IN VARCHAR2 DEFAULT NULL,
688 p_dist_attribute7 IN VARCHAR2 DEFAULT NULL,
689 p_dist_attribute8 IN VARCHAR2 DEFAULT NULL,
690 p_dist_attribute9 IN VARCHAR2 DEFAULT NULL,
691 p_dist_attribute10 IN VARCHAR2 DEFAULT NULL,
692 p_dist_attribute11 IN VARCHAR2 DEFAULT NULL,
693 p_dist_attribute12 IN VARCHAR2 DEFAULT NULL,
694 p_dist_attribute13 IN VARCHAR2 DEFAULT NULL,
695 p_dist_attribute14 IN VARCHAR2 DEFAULT NULL,
696 p_dist_attribute15 IN VARCHAR2 DEFAULT NULL,
697 p_dist_attribute_category_code IN VARCHAR2 DEFAULT NULL,
698 -- Asset Header Info --
699 p_asset_id IN NUMBER,
700 p_book_type_code IN VARCHAR2,
701 p_set_of_books_id IN NUMBER DEFAULT NULL,
702 -- Asset Retirement Info --
703 p_calculate_gain_loss IN VARCHAR2 DEFAULT FND_API.G_FALSE,
704 p_units_retired IN NUMBER DEFAULT NULL,
705 p_cost_retired IN NUMBER DEFAULT NULL,
706 p_proceeds_of_sale IN NUMBER DEFAULT NULL,
707 p_cost_of_removal IN NUMBER DEFAULT NULL,
708 p_retirement_type_code IN VARCHAR2 DEFAULT NULL,
709 p_retire_prorate_convention IN VARCHAR2 DEFAULT NULL,
710 p_stl_method_code IN VARCHAR2 DEFAULT NULL,
711 p_stl_life_in_months IN NUMBER DEFAULT NULL,
712 p_sold_to IN VARCHAR2 DEFAULT NULL,
713 p_trade_in_asset_id IN NUMBER DEFAULT NULL,
714 p_status IN VARCHAR2 DEFAULT NULL,
715 p_reference_num IN VARCHAR2 DEFAULT NULL,
716 p_recognize_gain_loss IN VARCHAR2 DEFAULT NULL,
717 p_recapture_reserve_flag IN VARCHAR2 DEFAULT NULL,
718 p_limit_proceeds_flag IN VARCHAR2 DEFAULT NULL,
719 p_terminal_gain_loss IN VARCHAR2 DEFAULT NULL,
720 p_reduction_rate IN NUMBER DEFAULT NULL,
721 p_reserve_retired IN NUMBER DEFAULT NULL,
722 p_eofy_reserve IN NUMBER DEFAULT NULL,
723 p_ret_attribute1 IN VARCHAR2 DEFAULT NULL,
724 p_ret_attribute2 IN VARCHAR2 DEFAULT NULL,
725 p_ret_attribute3 IN VARCHAR2 DEFAULT NULL,
729 p_ret_attribute7 IN VARCHAR2 DEFAULT NULL,
726 p_ret_attribute4 IN VARCHAR2 DEFAULT NULL,
727 p_ret_attribute5 IN VARCHAR2 DEFAULT NULL,
728 p_ret_attribute6 IN VARCHAR2 DEFAULT NULL,
730 p_ret_attribute8 IN VARCHAR2 DEFAULT NULL,
731 p_ret_attribute9 IN VARCHAR2 DEFAULT NULL,
732 p_ret_attribute10 IN VARCHAR2 DEFAULT NULL,
733 p_ret_attribute11 IN VARCHAR2 DEFAULT NULL,
734 p_ret_attribute12 IN VARCHAR2 DEFAULT NULL,
735 p_ret_attribute13 IN VARCHAR2 DEFAULT NULL,
736 p_ret_attribute14 IN VARCHAR2 DEFAULT NULL,
737 p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
738 p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
739 );
740
741 PROCEDURE undo_retirement(
742 -- Standard Parameters --
743 p_api_version IN NUMBER,
744 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
745 p_commit IN VARCHAR2 := FND_API.G_FALSE,
746 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
747 x_return_status OUT NOCOPY VARCHAR2,
748 x_msg_count OUT NOCOPY NUMBER,
749 x_msg_data OUT NOCOPY VARCHAR2,
750 p_calling_fn IN VARCHAR2,
751 -- API Options --
752 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
753 -- Transaction Info (Retirement) --
754 p_last_update_date IN DATE,
755 p_last_updated_by IN NUMBER,
756 p_last_update_login IN NUMBER,
757 -- Asset Header Info --
758 p_asset_id IN NUMBER,
759 p_book_type_code IN VARCHAR2,
760 p_set_of_books_id IN NUMBER DEFAULT NULL,
761 -- Asset Retirement Info --
762 p_retirement_id IN NUMBER DEFAULT NULL,
763 p_status IN VARCHAR2 DEFAULT NULL
764 );
765
766 PROCEDURE do_reinstatement(
767 -- Standard Parameters --
768 p_api_version IN NUMBER,
769 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
770 p_commit IN VARCHAR2 := FND_API.G_FALSE,
771 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
772 x_return_status OUT NOCOPY VARCHAR2,
773 x_msg_count OUT NOCOPY NUMBER,
774 x_msg_data OUT NOCOPY VARCHAR2,
775 p_calling_fn IN VARCHAR2,
776 -- API Options --
777 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
778 -- Out Parameters --
779 x_transaction_header_id OUT NOCOPY NUMBER,
780 -- Transaction Info --
781 p_transaction_date_entered IN DATE DEFAULT NULL,
782 p_transaction_name IN VARCHAR2 DEFAULT NULL,
783 p_mass_reference_id IN NUMBER DEFAULT NULL,
784 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
785 p_last_update_date IN DATE,
786 p_last_updated_by IN NUMBER,
787 p_created_by IN NUMBER,
788 p_creation_date IN DATE,
789 p_last_update_login IN NUMBER,
790 p_attribute1 IN VARCHAR2 DEFAULT NULL,
791 p_attribute2 IN VARCHAR2 DEFAULT NULL,
792 p_attribute3 IN VARCHAR2 DEFAULT NULL,
793 p_attribute4 IN VARCHAR2 DEFAULT NULL,
794 p_attribute5 IN VARCHAR2 DEFAULT NULL,
795 p_attribute6 IN VARCHAR2 DEFAULT NULL,
796 p_attribute7 IN VARCHAR2 DEFAULT NULL,
797 p_attribute8 IN VARCHAR2 DEFAULT NULL,
798 p_attribute9 IN VARCHAR2 DEFAULT NULL,
799 p_attribute10 IN VARCHAR2 DEFAULT NULL,
800 p_attribute11 IN VARCHAR2 DEFAULT NULL,
801 p_attribute12 IN VARCHAR2 DEFAULT NULL,
802 p_attribute13 IN VARCHAR2 DEFAULT NULL,
803 p_attribute14 IN VARCHAR2 DEFAULT NULL,
804 p_attribute15 IN VARCHAR2 DEFAULT NULL,
805 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
806 -- Asset Header Info --
807 p_asset_id IN NUMBER,
808 p_book_type_code IN VARCHAR2,
809 p_set_of_books_id IN NUMBER DEFAULT NULL,
810 -- Asset Retirement Info --
811 p_calculate_gain_loss IN VARCHAR2 DEFAULT FND_API.G_FALSE,
812 p_retirement_id IN NUMBER DEFAULT NULL,
813 p_proceeds_of_sale IN NUMBER DEFAULT NULL,
814 p_cost_of_removal IN NUMBER DEFAULT NULL,
815 p_retirement_type_code IN VARCHAR2 DEFAULT NULL,
816 p_retire_prorate_convention IN VARCHAR2 DEFAULT NULL,
817 p_sold_to IN VARCHAR2 DEFAULT NULL,
818 p_trade_in_asset_id IN NUMBER DEFAULT NULL,
819 p_status IN VARCHAR2 DEFAULT NULL,
820 p_reference_num IN VARCHAR2 DEFAULT NULL,
821 p_ret_attribute1 IN VARCHAR2 DEFAULT NULL,
822 p_ret_attribute2 IN VARCHAR2 DEFAULT NULL,
823 p_ret_attribute3 IN VARCHAR2 DEFAULT NULL,
824 p_ret_attribute4 IN VARCHAR2 DEFAULT NULL,
825 p_ret_attribute5 IN VARCHAR2 DEFAULT NULL,
826 p_ret_attribute6 IN VARCHAR2 DEFAULT NULL,
830 p_ret_attribute10 IN VARCHAR2 DEFAULT NULL,
827 p_ret_attribute7 IN VARCHAR2 DEFAULT NULL,
828 p_ret_attribute8 IN VARCHAR2 DEFAULT NULL,
829 p_ret_attribute9 IN VARCHAR2 DEFAULT NULL,
831 p_ret_attribute11 IN VARCHAR2 DEFAULT NULL,
832 p_ret_attribute12 IN VARCHAR2 DEFAULT NULL,
833 p_ret_attribute13 IN VARCHAR2 DEFAULT NULL,
834 p_ret_attribute14 IN VARCHAR2 DEFAULT NULL,
835 p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
836 p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
837 );
838
839 PROCEDURE undo_reinstatement(
840 -- Standard Parameters --
841 p_api_version IN NUMBER,
842 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
843 p_commit IN VARCHAR2 := FND_API.G_FALSE,
844 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
845 x_return_status OUT NOCOPY VARCHAR2,
846 x_msg_count OUT NOCOPY NUMBER,
847 x_msg_data OUT NOCOPY VARCHAR2,
848 p_calling_fn IN VARCHAR2,
849 -- API Options --
850 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
851 -- Transaction Info (Retirement) --
852 p_last_update_date IN DATE,
853 p_last_updated_by IN NUMBER,
854 p_last_update_login IN NUMBER,
855 -- Asset Header Info --
856 p_asset_id IN NUMBER,
857 p_book_type_code IN VARCHAR2,
858 p_set_of_books_id IN NUMBER DEFAULT NULL,
859 -- Asset Retirement Info --
860 p_retirement_id IN NUMBER DEFAULT NULL,
861 p_status IN VARCHAR2 DEFAULT NULL
862 );
863
864 PROCEDURE do_capitalization (
865 -- Standard Parameters --
866 p_api_version IN NUMBER,
867 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
868 p_commit IN VARCHAR2 := FND_API.G_FALSE,
869 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
870 x_return_status OUT NOCOPY VARCHAR2,
871 x_msg_count OUT NOCOPY NUMBER,
872 x_msg_data OUT NOCOPY VARCHAR2,
873 p_calling_fn IN VARCHAR2,
874 -- API Options --
875 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
876 -- Out Parameters --
877 x_transaction_header_id OUT NOCOPY NUMBER,
878 -- Transaction Info --
879 p_transaction_date_entered IN DATE DEFAULT NULL,
880 p_transaction_name IN VARCHAR2 DEFAULT NULL,
881 p_mass_reference_id IN NUMBER DEFAULT NULL,
882 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
883 p_last_update_date IN DATE,
884 p_last_updated_by IN NUMBER,
885 p_created_by IN NUMBER,
886 p_creation_date IN DATE,
887 p_last_update_login IN NUMBER,
888 p_attribute1 IN VARCHAR2 DEFAULT NULL,
889 p_attribute2 IN VARCHAR2 DEFAULT NULL,
890 p_attribute3 IN VARCHAR2 DEFAULT NULL,
891 p_attribute4 IN VARCHAR2 DEFAULT NULL,
892 p_attribute5 IN VARCHAR2 DEFAULT NULL,
893 p_attribute6 IN VARCHAR2 DEFAULT NULL,
894 p_attribute7 IN VARCHAR2 DEFAULT NULL,
895 p_attribute8 IN VARCHAR2 DEFAULT NULL,
896 p_attribute9 IN VARCHAR2 DEFAULT NULL,
897 p_attribute10 IN VARCHAR2 DEFAULT NULL,
898 p_attribute11 IN VARCHAR2 DEFAULT NULL,
899 p_attribute12 IN VARCHAR2 DEFAULT NULL,
900 p_attribute13 IN VARCHAR2 DEFAULT NULL,
901 p_attribute14 IN VARCHAR2 DEFAULT NULL,
902 p_attribute15 IN VARCHAR2 DEFAULT NULL,
903 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
904 -- Asset Header Info --
905 p_asset_id IN NUMBER,
906 p_book_type_code IN VARCHAR2,
907 p_set_of_books_id IN NUMBER DEFAULT NULL,
908 -- Asset Financial Info --
909 p_date_placed_in_service IN DATE
910 );
911
912 PROCEDURE do_reverse (
913 -- Standard Parameters --
914 p_api_version IN NUMBER,
915 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
916 p_commit IN VARCHAR2 := FND_API.G_FALSE,
917 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
918 x_return_status OUT NOCOPY VARCHAR2,
919 x_msg_count OUT NOCOPY NUMBER,
920 x_msg_data OUT NOCOPY VARCHAR2,
921 p_calling_fn IN VARCHAR2,
922 -- API Options --
923 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
924 -- Out Parameters --
925 x_transaction_header_id OUT NOCOPY NUMBER,
926 -- Transaction Info --
927 p_transaction_date_entered IN DATE DEFAULT NULL,
928 p_transaction_name IN VARCHAR2 DEFAULT NULL,
929 p_mass_reference_id IN NUMBER DEFAULT NULL,
930 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
931 p_last_update_date IN DATE,
932 p_last_updated_by IN NUMBER,
933 p_created_by IN NUMBER,
937 p_attribute2 IN VARCHAR2 DEFAULT NULL,
934 p_creation_date IN DATE,
935 p_last_update_login IN NUMBER,
936 p_attribute1 IN VARCHAR2 DEFAULT NULL,
938 p_attribute3 IN VARCHAR2 DEFAULT NULL,
939 p_attribute4 IN VARCHAR2 DEFAULT NULL,
940 p_attribute5 IN VARCHAR2 DEFAULT NULL,
941 p_attribute6 IN VARCHAR2 DEFAULT NULL,
942 p_attribute7 IN VARCHAR2 DEFAULT NULL,
943 p_attribute8 IN VARCHAR2 DEFAULT NULL,
944 p_attribute9 IN VARCHAR2 DEFAULT NULL,
945 p_attribute10 IN VARCHAR2 DEFAULT NULL,
946 p_attribute11 IN VARCHAR2 DEFAULT NULL,
947 p_attribute12 IN VARCHAR2 DEFAULT NULL,
948 p_attribute13 IN VARCHAR2 DEFAULT NULL,
949 p_attribute14 IN VARCHAR2 DEFAULT NULL,
950 p_attribute15 IN VARCHAR2 DEFAULT NULL,
951 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
952 -- Asset Header Info --
953 p_asset_id IN NUMBER,
954 p_book_type_code IN VARCHAR2,
955 p_set_of_books_id IN NUMBER DEFAULT NULL,
956 -- Asset Financial Info --
957 p_date_placed_in_service IN DATE
958 );
959
960 PROCEDURE do_asset_desc_update (
961 -- Standard Parameters --
962 p_api_version IN NUMBER,
963 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
964 p_commit IN VARCHAR2 := FND_API.G_FALSE,
965 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
966 x_return_status OUT NOCOPY VARCHAR2,
967 x_msg_count OUT NOCOPY NUMBER,
968 x_msg_data OUT NOCOPY VARCHAR2,
969 p_calling_fn IN VARCHAR2,
970 -- API Options --
971 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
972 p_reset_miss_flag IN VARCHAR2 DEFAULT 'NO',
973 -- Transaction Info --
974 p_last_update_date IN DATE,
975 p_last_updated_by IN NUMBER,
976 p_last_update_login IN NUMBER,
977 -- Asset Header Info --
978 p_asset_id IN NUMBER,
979 -- Asset Description Info --
980 p_asset_number IN VARCHAR2 DEFAULT NULL,
981 p_description IN VARCHAR2 DEFAULT NULL,
982 p_tag_number IN VARCHAR2 DEFAULT NULL,
983 p_serial_number IN VARCHAR2 DEFAULT NULL,
984 p_asset_key_ccid IN NUMBER DEFAULT NULL,
985 p_current_units IN NUMBER DEFAULT NULL,
986 p_parent_asset_id IN NUMBER DEFAULT NULL,
987 p_status IN VARCHAR2 DEFAULT NULL,
988 p_manufacturer_name IN VARCHAR2 DEFAULT NULL,
989 p_model_number IN VARCHAR2 DEFAULT NULL,
990 p_warranty_id IN NUMBER DEFAULT NULL,
991 p_property_type_code IN VARCHAR2 DEFAULT NULL,
992 p_property_1245_1250_code IN VARCHAR2 DEFAULT NULL,
993 p_in_use_flag IN VARCHAR2 DEFAULT NULL,
994 p_inventorial IN VARCHAR2 DEFAULT NULL,
995 p_commitment IN VARCHAR2 DEFAULT NULL,
996 p_investment_law IN VARCHAR2 DEFAULT NULL,
997 p_owned_leased IN VARCHAR2 DEFAULT NULL,
998 p_new_used IN VARCHAR2 DEFAULT NULL,
999 p_lease_id IN NUMBER DEFAULT NULL,
1000 p_ls_attribute1 IN VARCHAR2 DEFAULT NULL,
1001 p_ls_attribute2 IN VARCHAR2 DEFAULT NULL,
1002 p_ls_attribute3 IN VARCHAR2 DEFAULT NULL,
1003 p_ls_attribute4 IN VARCHAR2 DEFAULT NULL,
1004 p_ls_attribute5 IN VARCHAR2 DEFAULT NULL,
1005 p_ls_attribute6 IN VARCHAR2 DEFAULT NULL,
1006 p_ls_attribute7 IN VARCHAR2 DEFAULT NULL,
1007 p_ls_attribute8 IN VARCHAR2 DEFAULT NULL,
1008 p_ls_attribute9 IN VARCHAR2 DEFAULT NULL,
1009 p_ls_attribute10 IN VARCHAR2 DEFAULT NULL,
1010 p_ls_attribute11 IN VARCHAR2 DEFAULT NULL,
1011 p_ls_attribute12 IN VARCHAR2 DEFAULT NULL,
1012 p_ls_attribute13 IN VARCHAR2 DEFAULT NULL,
1013 p_ls_attribute14 IN VARCHAR2 DEFAULT NULL,
1014 p_ls_attribute15 IN VARCHAR2 DEFAULT NULL,
1015 p_ls_attribute_category_code IN VARCHAR2 DEFAULT NULL,
1016 p_ad_global_attribute1 IN VARCHAR2 DEFAULT NULL,
1017 p_ad_global_attribute2 IN VARCHAR2 DEFAULT NULL,
1018 p_ad_global_attribute3 IN VARCHAR2 DEFAULT NULL,
1019 p_ad_global_attribute4 IN VARCHAR2 DEFAULT NULL,
1020 p_ad_global_attribute5 IN VARCHAR2 DEFAULT NULL,
1021 p_ad_global_attribute6 IN VARCHAR2 DEFAULT NULL,
1022 p_ad_global_attribute7 IN VARCHAR2 DEFAULT NULL,
1023 p_ad_global_attribute8 IN VARCHAR2 DEFAULT NULL,
1024 p_ad_global_attribute9 IN VARCHAR2 DEFAULT NULL,
1025 p_ad_global_attribute10 IN VARCHAR2 DEFAULT NULL,
1026 p_ad_global_attribute11 IN VARCHAR2 DEFAULT NULL,
1027 p_ad_global_attribute12 IN VARCHAR2 DEFAULT NULL,
1028 p_ad_global_attribute13 IN VARCHAR2 DEFAULT NULL,
1029 p_ad_global_attribute14 IN VARCHAR2 DEFAULT NULL,
1030 p_ad_global_attribute15 IN VARCHAR2 DEFAULT NULL,
1034 p_ad_global_attribute19 IN VARCHAR2 DEFAULT NULL,
1031 p_ad_global_attribute16 IN VARCHAR2 DEFAULT NULL,
1032 p_ad_global_attribute17 IN VARCHAR2 DEFAULT NULL,
1033 p_ad_global_attribute18 IN VARCHAR2 DEFAULT NULL,
1035 p_ad_global_attribute20 IN VARCHAR2 DEFAULT NULL,
1036 p_ad_global_attribute_category IN VARCHAR2 DEFAULT NULL,
1037 -- Asset Category Info --
1038 p_category_id IN NUMBER,
1039 p_cat_attribute1 IN VARCHAR2 DEFAULT NULL,
1040 p_cat_attribute2 IN VARCHAR2 DEFAULT NULL,
1041 p_cat_attribute3 IN VARCHAR2 DEFAULT NULL,
1042 p_cat_attribute4 IN VARCHAR2 DEFAULT NULL,
1043 p_cat_attribute5 IN VARCHAR2 DEFAULT NULL,
1044 p_cat_attribute6 IN VARCHAR2 DEFAULT NULL,
1045 p_cat_attribute7 IN VARCHAR2 DEFAULT NULL,
1046 p_cat_attribute8 IN VARCHAR2 DEFAULT NULL,
1047 p_cat_attribute9 IN VARCHAR2 DEFAULT NULL,
1048 p_cat_attribute10 IN VARCHAR2 DEFAULT NULL,
1049 p_cat_attribute11 IN VARCHAR2 DEFAULT NULL,
1050 p_cat_attribute12 IN VARCHAR2 DEFAULT NULL,
1051 p_cat_attribute13 IN VARCHAR2 DEFAULT NULL,
1052 p_cat_attribute14 IN VARCHAR2 DEFAULT NULL,
1053 p_cat_attribute15 IN VARCHAR2 DEFAULT NULL,
1054 p_cat_attribute16 IN VARCHAR2 DEFAULT NULL,
1055 p_cat_attribute17 IN VARCHAR2 DEFAULT NULL,
1056 p_cat_attribute18 IN VARCHAR2 DEFAULT NULL,
1057 p_cat_attribute19 IN VARCHAR2 DEFAULT NULL,
1058 p_cat_attribute20 IN VARCHAR2 DEFAULT NULL,
1059 p_cat_attribute21 IN VARCHAR2 DEFAULT NULL,
1060 p_cat_attribute22 IN VARCHAR2 DEFAULT NULL,
1061 p_cat_attribute23 IN VARCHAR2 DEFAULT NULL,
1062 p_cat_attribute24 IN VARCHAR2 DEFAULT NULL,
1063 p_cat_attribute25 IN VARCHAR2 DEFAULT NULL,
1064 p_cat_attribute26 IN VARCHAR2 DEFAULT NULL,
1065 p_cat_attribute27 IN VARCHAR2 DEFAULT NULL,
1066 p_cat_attribute28 IN VARCHAR2 DEFAULT NULL,
1067 p_cat_attribute29 IN VARCHAR2 DEFAULT NULL,
1068 p_cat_attribute30 IN VARCHAR2 DEFAULT NULL,
1069 p_cat_attribute_category_code IN VARCHAR2 DEFAULT NULL,
1070 p_context IN VARCHAR2 DEFAULT NULL
1071 );
1072
1073 PROCEDURE do_invoice_desc_update (
1074 -- Standard Parameters --
1075 p_api_version IN NUMBER,
1076 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1077 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1078 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1079 x_return_status OUT NOCOPY VARCHAR2,
1080 x_msg_count OUT NOCOPY NUMBER,
1081 x_msg_data OUT NOCOPY VARCHAR2,
1082 p_calling_fn IN VARCHAR2,
1083 -- API Options --
1084 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
1085 p_reset_miss_flag IN VARCHAR2 DEFAULT 'NO',
1086 -- Transaction Info --
1087 p_last_update_date IN DATE,
1088 p_last_updated_by IN NUMBER,
1089 p_last_update_login IN NUMBER,
1090 -- Asset Header Info --
1091 p_asset_id IN NUMBER,
1092 p_book_type_code IN VARCHAR2,
1093 p_set_of_books_id IN NUMBER DEFAULT NULL
1094 );
1095
1096 PROCEDURE do_retirement_desc_update (
1097 -- Standard Parameters --
1098 p_api_version IN NUMBER,
1099 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1100 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1101 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1102 x_return_status OUT NOCOPY VARCHAR2,
1103 x_msg_count OUT NOCOPY NUMBER,
1104 x_msg_data OUT NOCOPY VARCHAR2,
1105 p_calling_fn IN VARCHAR2,
1106 -- API Options --
1107 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
1108 p_reset_miss_flag IN VARCHAR2 DEFAULT 'NO',
1109 -- Transaction Info (Retirement) --
1110 p_last_update_date IN DATE,
1111 p_last_updated_by IN NUMBER,
1112 p_last_update_login IN NUMBER,
1113 -- Asset Header Info --
1114 p_asset_id IN NUMBER,
1115 p_book_type_code IN VARCHAR2,
1116 p_set_of_books_id IN NUMBER DEFAULT NULL,
1117 -- Asset Retirement Info --
1118 p_retirement_id IN NUMBER,
1119 p_proceeds_of_sale IN NUMBER DEFAULT NULL,
1120 p_cost_of_removal IN NUMBER DEFAULT NULL,
1121 p_retirement_type_code IN VARCHAR2 DEFAULT NULL,
1122 p_retire_prorate_convention IN VARCHAR2 DEFAULT NULL,
1123 p_sold_to IN VARCHAR2 DEFAULT NULL,
1124 p_trade_in_asset_id IN NUMBER DEFAULT NULL,
1125 p_status IN VARCHAR2 DEFAULT NULL,
1126 p_reference_num IN VARCHAR2 DEFAULT NULL,
1127 p_ret_attribute1 IN VARCHAR2 DEFAULT NULL,
1128 p_ret_attribute2 IN VARCHAR2 DEFAULT NULL,
1129 p_ret_attribute3 IN VARCHAR2 DEFAULT NULL,
1130 p_ret_attribute4 IN VARCHAR2 DEFAULT NULL,
1131 p_ret_attribute5 IN VARCHAR2 DEFAULT NULL,
1135 p_ret_attribute9 IN VARCHAR2 DEFAULT NULL,
1132 p_ret_attribute6 IN VARCHAR2 DEFAULT NULL,
1133 p_ret_attribute7 IN VARCHAR2 DEFAULT NULL,
1134 p_ret_attribute8 IN VARCHAR2 DEFAULT NULL,
1136 p_ret_attribute10 IN VARCHAR2 DEFAULT NULL,
1137 p_ret_attribute11 IN VARCHAR2 DEFAULT NULL,
1138 p_ret_attribute12 IN VARCHAR2 DEFAULT NULL,
1139 p_ret_attribute13 IN VARCHAR2 DEFAULT NULL,
1140 p_ret_attribute14 IN VARCHAR2 DEFAULT NULL,
1141 p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
1142 p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
1143 );
1144
1145 PROCEDURE do_unplanned (
1146 -- Standard Parameters --
1147 p_api_version IN NUMBER,
1148 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1151 x_return_status OUT NOCOPY VARCHAR2,
1152 x_msg_count OUT NOCOPY NUMBER,
1153 x_msg_data OUT NOCOPY VARCHAR2,
1154 p_calling_fn IN VARCHAR2,
1155 -- API Options --
1156 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
1157 -- Out Parameters --
1158 x_transaction_header_id OUT NOCOPY NUMBER,
1159 -- Transaction Info --
1160 p_transaction_date_entered IN DATE DEFAULT NULL,
1161 p_transaction_name IN VARCHAR2 DEFAULT NULL,
1162 p_transaction_subtype IN VARCHAR2 DEFAULT NULL,
1163 p_amortization_start_date IN DATE DEFAULT NULL,
1164 p_mass_reference_id IN NUMBER DEFAULT NULL,
1165 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
1166 p_last_update_date IN DATE,
1167 p_last_updated_by IN NUMBER,
1168 p_created_by IN NUMBER,
1169 p_creation_date IN DATE,
1170 p_last_update_login IN NUMBER,
1171 p_attribute1 IN VARCHAR2 DEFAULT NULL,
1172 p_attribute2 IN VARCHAR2 DEFAULT NULL,
1173 p_attribute3 IN VARCHAR2 DEFAULT NULL,
1174 p_attribute4 IN VARCHAR2 DEFAULT NULL,
1175 p_attribute5 IN VARCHAR2 DEFAULT NULL,
1176 p_attribute6 IN VARCHAR2 DEFAULT NULL,
1177 p_attribute7 IN VARCHAR2 DEFAULT NULL,
1178 p_attribute8 IN VARCHAR2 DEFAULT NULL,
1179 p_attribute9 IN VARCHAR2 DEFAULT NULL,
1180 p_attribute10 IN VARCHAR2 DEFAULT NULL,
1181 p_attribute11 IN VARCHAR2 DEFAULT NULL,
1182 p_attribute12 IN VARCHAR2 DEFAULT NULL,
1183 p_attribute13 IN VARCHAR2 DEFAULT NULL,
1184 p_attribute14 IN VARCHAR2 DEFAULT NULL,
1185 p_attribute15 IN VARCHAR2 DEFAULT NULL,
1186 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
1187 -- Asset Header Info --
1188 p_asset_id IN NUMBER,
1189 p_book_type_code IN VARCHAR2,
1190 p_set_of_books_id IN NUMBER DEFAULT NULL,
1191 -- Unplanned Depreciation Info --
1192 p_code_combination_id IN NUMBER,
1193 p_unplanned_amount IN NUMBER,
1194 p_unplanned_type IN VARCHAR2 DEFAULT NULL
1195 );
1196
1197 PROCEDURE do_reserve_transfer (
1198 -- Standard Parameters --
1199 p_api_version IN NUMBER,
1200 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1201 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203 x_return_status OUT NOCOPY VARCHAR2,
1204 x_msg_count OUT NOCOPY NUMBER,
1205 x_msg_data OUT NOCOPY VARCHAR2,
1206 p_calling_fn IN VARCHAR2,
1207 -- API Options --
1208 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
1209 -- Out Parameters --
1210 x_src_transaction_header_id OUT NOCOPY NUMBER,
1211 x_dest_transaction_header_id OUT NOCOPY NUMBER,
1212 -- Transaction Info --
1213 p_transaction_date_entered IN DATE DEFAULT NULL,
1214 p_transaction_name IN VARCHAR2 DEFAULT NULL,
1215 p_transaction_subtype IN VARCHAR2 DEFAULT NULL,
1216 p_amortization_start_date IN DATE DEFAULT NULL,
1217 p_mass_reference_id IN NUMBER DEFAULT NULL,
1218 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
1219 p_last_update_date IN DATE,
1220 p_last_updated_by IN NUMBER,
1221 p_created_by IN NUMBER,
1222 p_creation_date IN DATE,
1223 p_last_update_login IN NUMBER,
1224 p_attribute1 IN VARCHAR2 DEFAULT NULL,
1225 p_attribute2 IN VARCHAR2 DEFAULT NULL,
1226 p_attribute3 IN VARCHAR2 DEFAULT NULL,
1227 p_attribute4 IN VARCHAR2 DEFAULT NULL,
1228 p_attribute5 IN VARCHAR2 DEFAULT NULL,
1229 p_attribute6 IN VARCHAR2 DEFAULT NULL,
1230 p_attribute7 IN VARCHAR2 DEFAULT NULL,
1231 p_attribute8 IN VARCHAR2 DEFAULT NULL,
1232 p_attribute9 IN VARCHAR2 DEFAULT NULL,
1233 p_attribute10 IN VARCHAR2 DEFAULT NULL,
1237 p_attribute14 IN VARCHAR2 DEFAULT NULL,
1234 p_attribute11 IN VARCHAR2 DEFAULT NULL,
1235 p_attribute12 IN VARCHAR2 DEFAULT NULL,
1236 p_attribute13 IN VARCHAR2 DEFAULT NULL,
1238 p_attribute15 IN VARCHAR2 DEFAULT NULL,
1239 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
1240 -- Asset Header Info --
1241 p_src_asset_id IN NUMBER, -- Source Asset Id
1242 p_book_type_code IN VARCHAR2,-- Source Book Type Code
1243 -- Reserve Transfer Info --
1244 p_transfer_amount IN NUMBER,
1245 p_dest_asset_id IN NUMBER -- Destination Asset Id
1246 );
1247
1248 PROCEDURE do_retirement_adjustment (
1249 -- Standard Parameters --
1250 p_api_version IN NUMBER,
1251 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1252 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1253 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1254 x_return_status OUT NOCOPY VARCHAR2,
1255 x_msg_count OUT NOCOPY NUMBER,
1256 x_msg_data OUT NOCOPY VARCHAR2,
1257 p_calling_fn IN VARCHAR2,
1258 -- API Options --
1259 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
1260 -- Out Parameters --
1261 x_transaction_header_id OUT NOCOPY NUMBER,
1262 -- Transaction Info --
1263 p_transaction_date_entered IN DATE DEFAULT NULL,
1264 p_transaction_name IN VARCHAR2 DEFAULT NULL,
1265 p_transaction_subtype IN VARCHAR2 DEFAULT NULL,
1266 p_amortization_start_date IN DATE DEFAULT NULL,
1267 p_mass_reference_id IN NUMBER DEFAULT NULL,
1268 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
1269 p_last_update_date IN DATE,
1270 p_last_updated_by IN NUMBER,
1271 p_created_by IN NUMBER,
1272 p_creation_date IN DATE,
1273 p_last_update_login IN NUMBER,
1274 p_attribute1 IN VARCHAR2 DEFAULT NULL,
1275 p_attribute2 IN VARCHAR2 DEFAULT NULL,
1276 p_attribute3 IN VARCHAR2 DEFAULT NULL,
1277 p_attribute4 IN VARCHAR2 DEFAULT NULL,
1278 p_attribute5 IN VARCHAR2 DEFAULT NULL,
1279 p_attribute6 IN VARCHAR2 DEFAULT NULL,
1280 p_attribute7 IN VARCHAR2 DEFAULT NULL,
1281 p_attribute8 IN VARCHAR2 DEFAULT NULL,
1282 p_attribute9 IN VARCHAR2 DEFAULT NULL,
1283 p_attribute10 IN VARCHAR2 DEFAULT NULL,
1284 p_attribute11 IN VARCHAR2 DEFAULT NULL,
1285 p_attribute12 IN VARCHAR2 DEFAULT NULL,
1286 p_attribute13 IN VARCHAR2 DEFAULT NULL,
1287 p_attribute14 IN VARCHAR2 DEFAULT NULL,
1288 p_attribute15 IN VARCHAR2 DEFAULT NULL,
1289 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
1290 -- Asset Header Info --
1291 p_asset_id IN NUMBER,
1292 p_book_type_code IN VARCHAR2,
1293 -- Retirement Adjustment Info --
1294 p_proceeds_of_sale IN NUMBER,
1295 p_cost_of_removal IN NUMBER
1296 );
1297
1298 PROCEDURE do_tax_reserve_adjustment(
1299 -- Standard Parameters --
1300 p_api_version IN NUMBER,
1301 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1302 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1303 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1304 x_return_status OUT NOCOPY VARCHAR2,
1305 x_msg_count OUT NOCOPY NUMBER,
1306 x_msg_data OUT NOCOPY VARCHAR2,
1307 p_calling_fn IN VARCHAR2,
1308 -- API Options --
1309 p_debug_flag IN VARCHAR2 DEFAULT 'NO',
1310 -- Out Parameters --
1311 x_transaction_header_id OUT NOCOPY NUMBER,
1312 -- Transaction Info --
1313 p_transaction_name IN VARCHAR2 DEFAULT NULL,
1314 p_mass_reference_id IN NUMBER DEFAULT NULL,
1315 p_calling_interface IN VARCHAR2 DEFAULT 'CUSTOM',
1316 p_last_update_date IN DATE,
1317 p_last_updated_by IN NUMBER,
1318 p_created_by IN NUMBER,
1319 p_creation_date IN DATE,
1320 p_last_update_login IN NUMBER,
1321 p_attribute1 IN VARCHAR2 DEFAULT NULL,
1322 p_attribute2 IN VARCHAR2 DEFAULT NULL,
1323 p_attribute3 IN VARCHAR2 DEFAULT NULL,
1324 p_attribute4 IN VARCHAR2 DEFAULT NULL,
1325 p_attribute5 IN VARCHAR2 DEFAULT NULL,
1326 p_attribute6 IN VARCHAR2 DEFAULT NULL,
1327 p_attribute7 IN VARCHAR2 DEFAULT NULL,
1328 p_attribute8 IN VARCHAR2 DEFAULT NULL,
1329 p_attribute9 IN VARCHAR2 DEFAULT NULL,
1330 p_attribute10 IN VARCHAR2 DEFAULT NULL,
1331 p_attribute11 IN VARCHAR2 DEFAULT NULL,
1332 p_attribute12 IN VARCHAR2 DEFAULT NULL,
1333 p_attribute13 IN VARCHAR2 DEFAULT NULL,
1334 p_attribute14 IN VARCHAR2 DEFAULT NULL,
1335 p_attribute15 IN VARCHAR2 DEFAULT NULL,
1336 p_attribute_category_code IN VARCHAR2 DEFAULT NULL,
1337 -- Asset Header Info --
1338 p_asset_id IN NUMBER,
1339 p_book_type_code IN VARCHAR2,
1340 -- Tax Reserve Adjustment Info --
1341 p_fiscal_year IN NUMBER,
1342 p_adjusted_ytd_deprn IN OUT NOCOPY NUMBER, -- Delta (New_FY_Ytd_Deprn - Old_FY_Ytd_Deprn)
1343 p_deprn_basis_formula IN NUMBER,
1344 p_run_mode IN VARCHAR2 DEFAULT 'RUN'
1345 );
1346
1347 END FA_TRANS_API_PUB;
[Home] [Help]