[Home] [Help]
PACKAGE BODY: APPS.FA_MASS_ADDITIONS_PKG3
Source
1 PACKAGE BODY FA_MASS_ADDITIONS_PKG3 as
2 /* $Header: faxima3b.pls 120.9 2009/07/17 03:31:44 snandiko ship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Mass_Addition_Id IN OUT NOCOPY NUMBER ,
6 X_Asset_Number VARCHAR2 DEFAULT NULL,
7 X_Tag_Number VARCHAR2 DEFAULT NULL,
8 X_Description VARCHAR2 DEFAULT NULL,
9 X_Asset_Category_Id NUMBER DEFAULT NULL,
10 X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
11 X_Serial_Number VARCHAR2 DEFAULT NULL,
12 X_Model_Number VARCHAR2 DEFAULT NULL,
13 X_Book_Type_Code VARCHAR2 DEFAULT NULL,
14 X_Date_Placed_In_Service DATE DEFAULT NULL,
15 X_Fixed_Assets_Cost NUMBER DEFAULT NULL,
16 X_Payables_Units NUMBER DEFAULT NULL,
17 X_Fixed_Assets_Units NUMBER DEFAULT NULL,
18 X_Payables_Code_Combination_Id NUMBER DEFAULT NULL,
19 X_Expense_Code_Combination_Id NUMBER DEFAULT NULL,
20 X_Location_Id NUMBER DEFAULT NULL,
21 X_Assigned_To NUMBER DEFAULT NULL,
22 X_Feeder_System_Name VARCHAR2 DEFAULT NULL,
23 X_Create_Batch_Date DATE DEFAULT NULL,
24 X_Create_Batch_Id NUMBER DEFAULT NULL,
25 X_Last_Update_Date DATE DEFAULT NULL,
26 X_Last_Updated_By NUMBER DEFAULT NULL,
27 X_Reviewer_Comments VARCHAR2 DEFAULT NULL,
28 X_Invoice_Number VARCHAR2 DEFAULT NULL,
29 X_Vendor_Number VARCHAR2 DEFAULT NULL,
30 X_Po_Vendor_Id NUMBER DEFAULT NULL,
31 X_Po_Number VARCHAR2 DEFAULT NULL,
32 X_Posting_Status VARCHAR2 DEFAULT NULL,
33 X_Queue_Name VARCHAR2 DEFAULT NULL,
34 X_Invoice_Date DATE DEFAULT NULL,
35 X_Invoice_Created_By NUMBER DEFAULT NULL,
36 X_Invoice_Updated_By NUMBER DEFAULT NULL,
37 X_Payables_Cost NUMBER DEFAULT NULL,
38 X_Invoice_Id NUMBER DEFAULT NULL,
39 X_Payables_Batch_Name VARCHAR2 DEFAULT NULL,
40 X_Depreciate_Flag VARCHAR2 DEFAULT NULL,
41 X_Parent_Mass_Addition_Id NUMBER DEFAULT NULL,
42 X_Parent_Asset_Id NUMBER DEFAULT NULL,
43 X_Split_Merged_Code VARCHAR2 DEFAULT NULL,
44 X_Ap_Distribution_Line_Number NUMBER DEFAULT NULL,
45 X_Post_Batch_Id NUMBER DEFAULT NULL,
46 X_Add_To_Asset_Id NUMBER DEFAULT NULL,
47 X_Amortize_Flag VARCHAR2 DEFAULT NULL,
48 X_New_Master_Flag VARCHAR2 DEFAULT NULL,
49 X_Asset_Key_Ccid NUMBER DEFAULT NULL,
50 X_Asset_Type VARCHAR2 DEFAULT NULL,
51 X_Deprn_Reserve NUMBER DEFAULT NULL,
52 X_Ytd_Deprn NUMBER DEFAULT NULL,
53 X_Beginning_Nbv NUMBER DEFAULT NULL,
54 X_Created_By NUMBER DEFAULT NULL,
55 X_Creation_Date DATE DEFAULT NULL,
56 X_Last_Update_Login NUMBER DEFAULT NULL,
57 X_Salvage_Value NUMBER DEFAULT NULL,
58 X_Accounting_Date DATE DEFAULT NULL,
59 X_Attribute1 VARCHAR2 DEFAULT NULL,
60 X_Attribute2 VARCHAR2 DEFAULT NULL,
61 X_Attribute3 VARCHAR2 DEFAULT NULL,
62 X_Attribute4 VARCHAR2 DEFAULT NULL,
63 X_Attribute5 VARCHAR2 DEFAULT NULL,
64 X_Attribute6 VARCHAR2 DEFAULT NULL,
65 X_Attribute7 VARCHAR2 DEFAULT NULL,
66 X_Attribute8 VARCHAR2 DEFAULT NULL,
67 X_Attribute9 VARCHAR2 DEFAULT NULL,
68 X_Attribute10 VARCHAR2 DEFAULT NULL,
69 X_Attribute11 VARCHAR2 DEFAULT NULL,
70 X_Attribute12 VARCHAR2 DEFAULT NULL,
71 X_Attribute13 VARCHAR2 DEFAULT NULL,
72 X_Attribute14 VARCHAR2 DEFAULT NULL,
73 X_Attribute15 VARCHAR2 DEFAULT NULL,
74 X_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
75 X_Fully_Rsvd_Revals_Counter NUMBER DEFAULT NULL,
76 X_Merge_Invoice_Number VARCHAR2 DEFAULT NULL,
77 X_Merge_Vendor_Number VARCHAR2 DEFAULT NULL,
78 X_Production_Capacity NUMBER DEFAULT NULL,
79 X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
80 X_Reval_Reserve NUMBER DEFAULT NULL,
81 X_Unit_Of_Measure VARCHAR2 DEFAULT NULL,
82 X_Unrevalued_Cost NUMBER DEFAULT NULL,
83 X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
84 X_Attribute16 VARCHAR2 DEFAULT NULL,
85 X_Attribute17 VARCHAR2 DEFAULT NULL,
86 X_Attribute18 VARCHAR2 DEFAULT NULL,
87 X_Attribute19 VARCHAR2 DEFAULT NULL,
88 X_Attribute20 VARCHAR2 DEFAULT NULL,
89 X_Attribute21 VARCHAR2 DEFAULT NULL,
90 X_Attribute22 VARCHAR2 DEFAULT NULL,
91 X_Attribute23 VARCHAR2 DEFAULT NULL,
92 X_Attribute24 VARCHAR2 DEFAULT NULL,
93 X_Attribute25 VARCHAR2 DEFAULT NULL,
94 X_Attribute26 VARCHAR2 DEFAULT NULL,
95 X_Attribute27 VARCHAR2 DEFAULT NULL,
96 X_Attribute28 VARCHAR2 DEFAULT NULL,
97 X_Attribute29 VARCHAR2 DEFAULT NULL,
98 X_Attribute30 VARCHAR2 DEFAULT NULL,
99 X_Merged_Code VARCHAR2 DEFAULT NULL,
100 X_Split_Code VARCHAR2 DEFAULT NULL,
101 X_Merge_Parent_Mass_Add_Id NUMBER DEFAULT NULL,
102 X_Split_Parent_Mass_Add_Id NUMBER DEFAULT NULL,
103 X_Sum_Units VARCHAR2 DEFAULT NULL,
104 X_Context VARCHAR2 DEFAULT NULL,
105 X_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
106 X_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
107 X_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
108 X_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
109 X_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
110 X_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
111 X_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
112 X_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
113 X_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
114 X_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
115 X_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
116 X_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
117 X_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
118 X_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
119 X_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
120 X_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
121 X_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
122 X_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
123 X_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
124 X_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
125 X_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
126 X_Inventorial VARCHAR2 DEFAULT NULL,
127 X_Transaction_type_code VARCHAR2 DEFAULT NULL,
128 X_transaction_date DATE DEFAULT NULL,
129 X_warranty_id NUMBER DEFAULT NULL,
130 X_lease_id NUMBER DEFAULT NULL,
131 X_lessor_id NUMBER DEFAULT NULL,
132 X_property_type_code VARCHAR2 DEFAULT NULL,
133 X_property_1245_1250_code VARCHAR2 DEFAULT NULL,
134 X_in_use_flag VARCHAR2 DEFAULT NULL,
135 X_owned_leased VARCHAR2 DEFAULT NULL,
136 X_new_used VARCHAR2 DEFAULT NULL,
137 X_asset_id NUMBER DEFAULT NULL,
138 X_group_asset_id NUMBER DEFAULT NULL,
139 X_deprn_method_code VARCHAR2 DEFAULT NULL,
140 X_life_in_months VARCHAR2 DEFAULT NULL,
141 X_basic_rate NUMBER DEFAULT NULL,
142 X_adjusted_rate NUMBER DEFAULT NULL,
143 X_bonus_rule VARCHAR2 DEFAULT NULL, --Bug 8675206
144 X_prorate_convention_code VARCHAR2 DEFAULT NULL, --Bug8675206
145 X_deprn_limit_type VARCHAR2 DEFAULT NULL,
146 X_allowed_deprn_limit_amount NUMBER DEFAULT NULL,
147 X_allowed_deprn_limit NUMBER DEFAULT NULL,
148 X_salvage_type VARCHAR2 DEFAULT NULL,
149 X_percent_salvage_value NUMBER DEFAULT NULL,
150 X_nbv_at_switch NUMBER DEFAULT NULL, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
151 X_prior_deprn_limit_type VARCHAR2 DEFAULT NULL,
152 X_prior_deprn_limit_amount NUMBER DEFAULT NULL,
153 X_prior_deprn_limit NUMBER DEFAULT NULL,
154 X_prior_deprn_method VARCHAR2 DEFAULT NULL,
155 X_prior_life_in_months NUMBER DEFAULT NULL,
156 X_prior_basic_rate NUMBER DEFAULT NULL,
157 X_prior_adjusted_rate NUMBER DEFAULT NULL,
158 X_period_full_reserve VARCHAR2 DEFAULT NULL,
159 X_period_extd_deprn VARCHAR2 DEFAULT NULL,
160 -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
161 X_invoice_distribution_id NUMBER DEFAULT NULL,
165 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
162 X_invoice_line_number NUMBER DEFAULT NULL,
163 X_po_distribution_id NUMBER DEFAULT NULL,
164 X_warranty_number VARCHAR2 DEFAULT NULL,
166 CURSOR C IS SELECT rowid FROM fa_mass_additions
167 WHERE mass_addition_id = X_Mass_Addition_Id;
168 CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
169 BEGIN
170 if (X_Mass_Addition_Id is NULL) then
171 OPEN C2;
172 FETCH C2 INTO X_Mass_Addition_Id;
173 CLOSE C2;
174 end if;
175
176 INSERT INTO fa_mass_additions(
177
178 mass_addition_id,
179 asset_number,
180 tag_number,
181 description,
182 asset_category_id,
183 manufacturer_name,
184 serial_number,
185 model_number,
186 book_type_code,
187 date_placed_in_service,
188 fixed_assets_cost,
189 payables_units,
190 fixed_assets_units,
191 payables_code_combination_id,
192 expense_code_combination_id,
193 location_id,
194 assigned_to,
195 feeder_system_name,
196 create_batch_date,
197 create_batch_id,
198 last_update_date,
199 last_updated_by,
200 reviewer_comments,
201 invoice_number,
202 vendor_number,
203 po_vendor_id,
204 po_number,
205 posting_status,
206 queue_name,
207 invoice_date,
208 invoice_created_by,
209 invoice_updated_by,
210 payables_cost,
211 invoice_id,
212 payables_batch_name,
213 depreciate_flag,
214 parent_mass_addition_id,
215 parent_asset_id,
216 split_merged_code,
217 ap_distribution_line_number,
218 post_batch_id,
219 add_to_asset_id,
220 amortize_flag,
221 new_master_flag,
222 asset_key_ccid,
223 asset_type,
224 deprn_reserve,
225 ytd_deprn,
226 beginning_nbv,
227 created_by,
228 creation_date,
229 last_update_login,
230 salvage_value,
231 accounting_date,
232 attribute1,
233 attribute2,
234 attribute3,
235 attribute4,
236 attribute5,
237 attribute6,
238 attribute7,
239 attribute8,
240 attribute9,
241 attribute10,
242 attribute11,
243 attribute12,
244 attribute13,
245 attribute14,
246 attribute15,
247 attribute_category_code,
248 fully_rsvd_revals_counter,
249 merge_invoice_number,
250 merge_vendor_number,
251 production_capacity,
252 reval_amortization_basis,
253 reval_reserve,
254 unit_of_measure,
255 unrevalued_cost,
256 ytd_reval_deprn_expense,
257 attribute16,
258 attribute17,
259 attribute18,
260 attribute19,
261 attribute20,
262 attribute21,
263 attribute22,
264 attribute23,
265 attribute24,
266 attribute25,
267 attribute26,
268 attribute27,
269 attribute28,
270 attribute29,
271 attribute30,
272 merged_code,
273 split_code,
274 merge_parent_mass_additions_id,
275 split_parent_mass_additions_id,
276 sum_units,
277 context,
278 global_attribute1,
279 global_attribute2,
280 global_attribute3,
281 global_attribute4,
282 global_attribute5,
283 global_attribute6,
284 global_attribute7,
285 global_attribute8,
286 global_attribute9,
287 global_attribute10,
288 global_attribute11,
289 global_attribute12,
290 global_attribute13,
291 global_attribute14,
292 global_attribute15,
293 global_attribute16,
294 global_attribute17,
295 global_attribute18,
296 global_attribute19,
297 global_attribute20,
298 global_attribute_category,
299 inventorial,
300 transaction_type_code,
301 transaction_date,
302 warranty_id,
303 lease_id,
304 lessor_id,
305 property_type_code,
306 property_1245_1250_code,
307 in_use_flag,
308 owned_leased,
309 new_used,
310 asset_id,
311 group_asset_id,
312 deprn_method_code,
313 life_in_months ,
314 basic_rate ,
315 adjusted_rate
316 ,prorate_convention_code --Bug8675206
320 , allowed_deprn_limit
317 ,bonus_rule --Bug 8675206
318 , deprn_limit_type -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
319 , allowed_deprn_limit_amount
321 , salvage_type
322 , percent_salvage_value
323 , nbv_at_switch
324 , prior_deprn_limit_type
325 , prior_deprn_limit_amount
326 , prior_deprn_limit
327 , prior_deprn_method
328 , prior_life_in_months
329 , prior_basic_rate
330 , prior_adjusted_rate
331 , period_full_reserve
332 , period_extd_deprn
333 -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
334 ,invoice_distribution_id,
335 invoice_line_number,
336 po_distribution_id,
337 warranty_number
338 ) VALUES (
339
340 X_Mass_Addition_Id,
341 X_Asset_Number,
342 X_Tag_Number,
343 X_Description,
344 X_Asset_Category_Id,
345 X_Manufacturer_Name,
346 X_Serial_Number,
347 X_Model_Number,
348 X_Book_Type_Code,
349 X_Date_Placed_In_Service,
350 X_Fixed_Assets_Cost,
351 X_Payables_Units,
352 X_Fixed_Assets_Units,
353 X_Payables_Code_Combination_Id,
354 X_Expense_Code_Combination_Id,
355 X_Location_Id,
356 X_Assigned_To,
357 X_Feeder_System_Name,
358 X_Create_Batch_Date,
359 X_Create_Batch_Id,
360 X_Last_Update_Date,
361 X_Last_Updated_By,
362 X_Reviewer_Comments,
363 X_Invoice_Number,
364 X_Vendor_Number,
365 X_Po_Vendor_Id,
366 X_Po_Number,
367 X_Posting_Status,
368 X_Queue_Name,
369 X_Invoice_Date,
370 X_Invoice_Created_By,
371 X_Invoice_Updated_By,
372 X_Payables_Cost,
373 X_Invoice_Id,
374 X_Payables_Batch_Name,
375 X_Depreciate_Flag,
376 X_Parent_Mass_Addition_Id,
377 X_Parent_Asset_Id,
378 X_Split_Merged_Code,
379 X_Ap_Distribution_Line_Number,
380 X_Post_Batch_Id,
381 X_Add_To_Asset_Id,
382 X_Amortize_Flag,
383 X_New_Master_Flag,
384 X_Asset_Key_Ccid,
385 X_Asset_Type,
386 X_Deprn_Reserve,
387 X_Ytd_Deprn,
388 X_Beginning_Nbv,
389 X_Created_By,
390 X_Creation_Date,
391 X_Last_Update_Login,
392 X_Salvage_Value,
393 X_Accounting_Date,
394 X_Attribute1,
395 X_Attribute2,
396 X_Attribute3,
397 X_Attribute4,
398 X_Attribute5,
399 X_Attribute6,
400 X_Attribute7,
401 X_Attribute8,
402 X_Attribute9,
403 X_Attribute10,
404 X_Attribute11,
405 X_Attribute12,
406 X_Attribute13,
407 X_Attribute14,
408 X_Attribute15,
409 X_Attribute_Category_Code,
410 X_Fully_Rsvd_Revals_Counter,
411 X_Merge_Invoice_Number,
412 X_Merge_Vendor_Number,
413 X_Production_Capacity,
414 X_Reval_Amortization_Basis,
415 X_Reval_Reserve,
416 X_Unit_Of_Measure,
417 X_Unrevalued_Cost,
418 X_Ytd_Reval_Deprn_Expense,
419 X_Attribute16,
420 X_Attribute17,
421 X_Attribute18,
422 X_Attribute19,
423 X_Attribute20,
424 X_Attribute21,
425 X_Attribute22,
426 X_Attribute23,
427 X_Attribute24,
428 X_Attribute25,
429 X_Attribute26,
430 X_Attribute27,
431 X_Attribute28,
432 X_Attribute29,
433 X_Attribute30,
434 X_Merged_Code,
435 X_Split_Code,
436 X_Merge_Parent_Mass_Add_Id,
437 X_Split_Parent_Mass_Add_Id,
438 X_Sum_Units,
439 X_Context,
440 X_global_attribute1,
441 X_global_attribute2,
442 X_global_attribute3,
443 X_global_attribute4,
444 X_global_attribute5,
445 X_global_attribute6,
446 X_global_attribute7,
447 X_global_attribute8,
448 X_global_attribute9,
449 X_global_attribute10,
450 X_global_attribute11,
451 X_global_attribute12,
452 X_global_attribute13,
453 X_global_attribute14,
454 X_global_attribute15,
455 X_global_attribute16,
456 X_global_attribute17,
457 X_global_attribute18,
458 X_global_attribute19,
459 X_global_attribute20,
460 X_global_attribute_category,
461 X_Inventorial,
462 X_Transaction_type_code,
463 X_transaction_date,
464 X_warranty_id,
465 X_lease_id,
466 X_lessor_id,
470 X_owned_leased,
467 X_property_type_code,
468 X_property_1245_1250_code,
469 X_in_use_flag,
471 X_new_used,
472 X_asset_id,
473 X_group_asset_id,
474 X_deprn_method_code ,
475 X_life_in_months ,
476 X_basic_rate ,
477 X_adjusted_rate ,
478 X_prorate_convention_code , --Bug8675206
479 X_bonus_rule , --Bug8675206
480 -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
481 X_deprn_limit_type ,
482 X_allowed_deprn_limit_amount ,
483 X_allowed_deprn_limit ,
484 X_salvage_type ,
485 X_percent_salvage_value ,
486 X_nbv_at_switch ,
487 X_prior_deprn_limit_type ,
488 X_prior_deprn_limit_amount ,
489 X_prior_deprn_limit ,
490 X_prior_deprn_method ,
491 X_prior_life_in_months ,
492 X_prior_basic_rate ,
493 X_prior_adjusted_rate ,
494 X_period_full_reserve ,
495 X_period_extd_deprn
496 -- -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
497 ,X_invoice_distribution_id,
498 X_invoice_line_number,
499 X_po_distribution_id,
500 X_warranty_number
501 );
502
503 OPEN C;
504 FETCH C INTO X_Rowid;
505 if (C%NOTFOUND) then
506 CLOSE C;
507 Raise NO_DATA_FOUND;
508 end if;
509 CLOSE C;
510
511 END Insert_Row;
512
513
514 ----
515
516 END FA_MASS_ADDITIONS_PKG3;