[Home] [Help]
Skip to content
PACKAGE BODY: APPS.FA_MASS_ADDITIONS_PKG
Source
1 PACKAGE BODY FA_MASS_ADDITIONS_PKG as
2 /* $Header: faximab.pls 120.10 2010/05/19 12:04:55 anujain ship $ */
3
4
5
6 ----
7 PROCEDURE Update_Row(X_Rowid VARCHAR2,
8 X_Mass_Addition_Id NUMBER DEFAULT NULL,
9 X_Asset_Number VARCHAR2 DEFAULT NULL,
10 X_Tag_Number VARCHAR2 DEFAULT NULL,
11 X_Description VARCHAR2 DEFAULT NULL,
12 X_Asset_Category_Id NUMBER DEFAULT NULL,
13 X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
14 X_Serial_Number VARCHAR2 DEFAULT NULL,
15 X_Model_Number VARCHAR2 DEFAULT NULL,
16 X_Book_Type_Code VARCHAR2 DEFAULT NULL,
17 X_Date_Placed_In_Service DATE DEFAULT NULL,
18 X_Fixed_Assets_Cost NUMBER DEFAULT NULL,
19 X_Payables_Units NUMBER DEFAULT NULL,
20 X_Fixed_Assets_Units NUMBER DEFAULT NULL,
21 X_Payables_Code_Combination_Id NUMBER DEFAULT NULL,
22 X_Expense_Code_Combination_Id NUMBER DEFAULT NULL,
23 X_Location_Id NUMBER DEFAULT NULL,
24 X_Assigned_To NUMBER DEFAULT NULL,
25 X_Feeder_System_Name VARCHAR2 DEFAULT NULL,
26 X_Create_Batch_Date DATE DEFAULT NULL,
27 X_Create_Batch_Id NUMBER DEFAULT NULL,
28 X_Last_Update_Date DATE DEFAULT NULL,
29 X_Last_Updated_By NUMBER DEFAULT NULL,
30 X_Reviewer_Comments VARCHAR2 DEFAULT NULL,
31 X_Invoice_Number VARCHAR2 DEFAULT NULL,
32 X_Vendor_Number VARCHAR2 DEFAULT NULL,
33 X_Po_Vendor_Id NUMBER DEFAULT NULL,
34 X_Po_Number VARCHAR2 DEFAULT NULL,
35 X_Posting_Status VARCHAR2 DEFAULT NULL,
36 X_Queue_Name VARCHAR2 DEFAULT NULL,
37 X_Invoice_Date DATE DEFAULT NULL,
38 X_Invoice_Created_By NUMBER DEFAULT NULL,
39 X_Invoice_Updated_By NUMBER DEFAULT NULL,
40 X_Payables_Cost NUMBER DEFAULT NULL,
41 X_Invoice_Id NUMBER DEFAULT NULL,
42 X_Payables_Batch_Name VARCHAR2 DEFAULT NULL,
43 X_Depreciate_Flag VARCHAR2 DEFAULT NULL,
44 X_Parent_Mass_Addition_Id NUMBER DEFAULT NULL,
45 X_Parent_Asset_Id NUMBER DEFAULT NULL,
46 X_Split_Merged_Code VARCHAR2 DEFAULT NULL,
47 X_Ap_Distribution_Line_Number NUMBER DEFAULT NULL,
48 X_Post_Batch_Id NUMBER DEFAULT NULL,
49 X_Add_To_Asset_Id NUMBER DEFAULT NULL,
50 X_Amortize_Flag VARCHAR2 DEFAULT NULL,
51 X_New_Master_Flag VARCHAR2 DEFAULT NULL,
52 X_Asset_Key_Ccid NUMBER DEFAULT NULL,
53 X_Asset_Type VARCHAR2 DEFAULT NULL,
54 X_Deprn_Reserve NUMBER DEFAULT NULL,
55 X_Ytd_Deprn NUMBER DEFAULT NULL,
56 X_Beginning_Nbv NUMBER DEFAULT NULL,
57 X_Last_Update_Login NUMBER DEFAULT NULL,
58 X_Salvage_Value NUMBER DEFAULT NULL,
59 X_Accounting_Date DATE DEFAULT NULL,
60 X_Attribute1 VARCHAR2 DEFAULT NULL,
61 X_Attribute2 VARCHAR2 DEFAULT NULL,
62 X_Attribute3 VARCHAR2 DEFAULT NULL,
63 X_Attribute4 VARCHAR2 DEFAULT NULL,
64 X_Attribute5 VARCHAR2 DEFAULT NULL,
65 X_Attribute6 VARCHAR2 DEFAULT NULL,
66 X_Attribute7 VARCHAR2 DEFAULT NULL,
67 X_Attribute8 VARCHAR2 DEFAULT NULL,
68 X_Attribute9 VARCHAR2 DEFAULT NULL,
69 X_Attribute10 VARCHAR2 DEFAULT NULL,
70 X_Attribute11 VARCHAR2 DEFAULT NULL,
71 X_Attribute12 VARCHAR2 DEFAULT NULL,
72 X_Attribute13 VARCHAR2 DEFAULT NULL,
73 X_Attribute14 VARCHAR2 DEFAULT NULL,
74 X_Attribute15 VARCHAR2 DEFAULT NULL,
75 X_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
76 X_Fully_Rsvd_Revals_Counter NUMBER DEFAULT NULL,
77 X_Merge_Invoice_Number VARCHAR2 DEFAULT NULL,
78 X_Merge_Vendor_Number VARCHAR2 DEFAULT NULL,
79 X_Production_Capacity NUMBER DEFAULT NULL,
80 X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
81 X_Reval_Reserve NUMBER DEFAULT NULL,
82 X_Unit_Of_Measure VARCHAR2 DEFAULT NULL,
83 X_Unrevalued_Cost NUMBER DEFAULT NULL,
84 X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
85 X_Attribute16 VARCHAR2 DEFAULT NULL,
86 X_Attribute17 VARCHAR2 DEFAULT NULL,
87 X_Attribute18 VARCHAR2 DEFAULT NULL,
88 X_Attribute19 VARCHAR2 DEFAULT NULL,
89 X_Attribute20 VARCHAR2 DEFAULT NULL,
90 X_Attribute21 VARCHAR2 DEFAULT NULL,
91 X_Attribute22 VARCHAR2 DEFAULT NULL,
92 X_Attribute23 VARCHAR2 DEFAULT NULL,
93 X_Attribute24 VARCHAR2 DEFAULT NULL,
94 X_Attribute25 VARCHAR2 DEFAULT NULL,
95 X_Attribute26 VARCHAR2 DEFAULT NULL,
96 X_Attribute27 VARCHAR2 DEFAULT NULL,
97 X_Attribute28 VARCHAR2 DEFAULT NULL,
98 X_Attribute29 VARCHAR2 DEFAULT NULL,
99 X_Attribute30 VARCHAR2 DEFAULT NULL,
100 X_Merged_Code VARCHAR2 DEFAULT NULL,
101 X_Split_Code VARCHAR2 DEFAULT NULL,
102 X_Merge_parent_Mass_Add_ID NUMBER DEFAULT NULL,
103 X_Split_PArent_MAss_Add_ID NUMBER DEFAULT NULL,
104 X_Sum_Units VARCHAR2 DEFAULT NULL,
105 X_Context VARCHAR2 DEFAULT NULL,
106 X_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
107 X_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
108 X_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
109 X_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
110 X_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
111 X_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
112 X_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
113 X_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
114 X_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
115 X_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
116 X_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
117 X_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
118 X_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
119 X_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
120 X_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
121 X_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
122 X_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
123 X_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
124 X_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
125 X_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
126 X_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
127 X_INVENTORIAL VARCHAR2 DEFAULT NULL,
128 X_Transaction_type_code VARCHAR2 DEFAULT NULL,
129 X_transaction_date DATE DEFAULT NULL,
130 X_warranty_id NUMBER DEFAULT NULL,
131 X_lease_id NUMBER DEFAULT NULL,
132 X_lessor_id NUMBER DEFAULT NULL,
133 X_property_type_code VARCHAR2 DEFAULT NULL,
134 X_property_1245_1250_code VARCHAR2 DEFAULT NULL,
135 X_in_use_flag VARCHAR2 DEFAULT NULL,
136 X_owned_leased VARCHAR2 DEFAULT NULL,
137 X_new_used VARCHAR2 DEFAULT NULL,
138 X_asset_id NUMBER DEFAULT NULL,
139 X_group_asset_id NUMBER DEFAULT NULL,
140 X_deprn_method_code VARCHAR2 DEFAULT NULL,
141 X_life_in_months VARCHAR2 DEFAULT NULL,
142 X_basic_rate NUMBER DEFAULT NULL,
143 X_adjusted_rate NUMBER DEFAULT NULL,
144 X_bonus_rule VARCHAR2 DEFAULT NULL,-- Added for bug 8675206
145 X_prorate_convention_code VARCHAR2 DEFAULT NULL, -- Added for bug 8675206
146 X_deprn_limit_type VARCHAR2 DEFAULT NULL,
147 X_allowed_deprn_limit_amount NUMBER DEFAULT NULL,
148 X_allowed_deprn_limit NUMBER DEFAULT NULL,
149 X_salvage_type VARCHAR2 DEFAULT NULL,
150 X_percent_salvage_value NUMBER DEFAULT NULL,
151 X_nbv_at_switch NUMBER DEFAULT NULL, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
152 X_prior_deprn_limit_type VARCHAR2 DEFAULT NULL,
153 X_prior_deprn_limit_amount NUMBER DEFAULT NULL,
154 X_prior_deprn_limit NUMBER DEFAULT NULL,
155 X_prior_deprn_method VARCHAR2 DEFAULT NULL,
156 X_prior_life_in_months NUMBER DEFAULT NULL,
157 X_prior_basic_rate NUMBER DEFAULT NULL,
158 X_prior_adjusted_rate NUMBER DEFAULT NULL,
159 X_period_full_reserve VARCHAR2 DEFAULT NULL,
160 X_period_extd_deprn VARCHAR2 DEFAULT NULL,
161 -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
162 X_invoice_distribution_id NUMBER DEFAULT NULL,
163 X_invoice_line_number NUMBER DEFAULT NULL,
164 X_po_distribution_id NUMBER DEFAULT NULL,
165 X_warranty_number VARCHAR2 DEFAULT NULL,
166 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
167 BEGIN
168 UPDATE fa_mass_additions
169 SET
170 mass_addition_id = X_Mass_Addition_Id,
171 asset_number = X_Asset_Number,
172 tag_number = X_Tag_Number,
173 description = X_Description,
174 asset_category_id = X_Asset_Category_Id,
175 manufacturer_name = X_Manufacturer_Name,
176 serial_number = X_Serial_Number,
177 model_number = X_Model_Number,
178 book_type_code = X_Book_Type_Code,
179 date_placed_in_service = X_Date_Placed_In_Service,
180 fixed_assets_cost = X_Fixed_Assets_Cost,
181 payables_units = X_Payables_Units,
182 fixed_assets_units = X_Fixed_Assets_Units,
183 payables_code_combination_id = X_Payables_Code_Combination_Id,
184 expense_code_combination_id = X_Expense_Code_Combination_Id,
185 location_id = X_Location_Id,
186 assigned_to = X_Assigned_To,
187 feeder_system_name = X_Feeder_System_Name,
188 create_batch_date = X_Create_Batch_Date,
189 create_batch_id = X_Create_Batch_Id,
190 last_update_date = X_Last_Update_Date,
191 last_updated_by = X_Last_Updated_By,
192 reviewer_comments = X_Reviewer_Comments,
193 invoice_number = X_Invoice_Number,
194 vendor_number = X_Vendor_Number,
195 po_vendor_id = X_Po_Vendor_Id,
196 po_number = X_Po_Number,
197 posting_status = X_Posting_Status,
198 queue_name = X_Queue_Name,
199 invoice_date = X_Invoice_Date,
200 invoice_created_by = X_Invoice_Created_By,
201 invoice_updated_by = X_Invoice_Updated_By,
202 payables_cost = X_Payables_Cost,
203 invoice_id = X_Invoice_Id,
204 payables_batch_name = X_Payables_Batch_Name,
205 depreciate_flag = X_Depreciate_Flag,
206 parent_mass_addition_id = X_Parent_Mass_Addition_Id,
207 parent_asset_id = X_Parent_Asset_Id,
208 split_merged_code = X_Split_Merged_Code,
209 ap_distribution_line_number = X_Ap_Distribution_Line_Number,
210 post_batch_id = X_Post_Batch_Id,
211 add_to_asset_id = X_Add_To_Asset_Id,
212 amortize_flag = X_Amortize_Flag,
213 new_master_flag = X_New_Master_Flag,
214 asset_key_ccid = X_Asset_Key_Ccid,
215 asset_type = X_Asset_Type,
216 deprn_reserve = X_Deprn_Reserve,
217 ytd_deprn = X_Ytd_Deprn,
218 beginning_nbv = X_Beginning_Nbv,
219 last_update_login = X_Last_Update_Login,
220 salvage_value = X_Salvage_Value,
221 accounting_date = X_Accounting_Date,
222 attribute1 = X_Attribute1,
223 attribute2 = X_Attribute2,
224 attribute3 = X_Attribute3,
225 attribute4 = X_Attribute4,
226 attribute5 = X_Attribute5,
227 attribute6 = X_Attribute6,
228 attribute7 = X_Attribute7,
229 attribute8 = X_Attribute8,
230 attribute9 = X_Attribute9,
231 attribute10 = X_Attribute10,
232 attribute11 = X_Attribute11,
233 attribute12 = X_Attribute12,
234 attribute13 = X_Attribute13,
235 attribute14 = X_Attribute14,
236 attribute15 = X_Attribute15,
237 attribute_category_code = X_Attribute_Category_Code,
238 fully_rsvd_revals_counter = X_Fully_Rsvd_Revals_Counter,
239 merge_invoice_number = X_Merge_Invoice_Number,
240 merge_vendor_number = X_Merge_Vendor_Number,
241 production_capacity = X_Production_Capacity,
242 reval_amortization_basis = X_Reval_Amortization_Basis,
243 reval_reserve = X_Reval_Reserve,
244 unit_of_measure = X_Unit_Of_Measure,
245 unrevalued_cost = X_Unrevalued_Cost,
246 ytd_reval_deprn_expense = X_Ytd_Reval_Deprn_Expense,
247 attribute16 = X_Attribute16,
248 attribute17 = X_Attribute17,
249 attribute18 = X_Attribute18,
250 attribute19 = X_Attribute19,
251 attribute20 = X_Attribute20,
252 attribute21 = X_Attribute21,
253 attribute22 = X_Attribute22,
254 attribute23 = X_Attribute23,
255 attribute24 = X_Attribute24,
256 attribute25 = X_Attribute25,
257 attribute26 = X_Attribute26,
258 attribute27 = X_Attribute27,
259 attribute28 = X_Attribute28,
260 attribute29 = X_Attribute29,
261 attribute30 = X_Attribute30,
262 merged_code = X_Merged_Code,
263 split_code = X_Split_Code,
264 merge_parent_mass_additions_id = X_Merge_parent_Mass_Add_ID,
265 split_parent_mass_additions_id = X_Split_PArent_MAss_Add_ID,
266 sum_units = X_Sum_Units,
267 context = X_Context,
268 global_attribute1 = X_GLOBAL_ATTRIBUTE1,
269 global_attribute10 = X_GLOBAL_ATTRIBUTE10,
270 global_attribute11 = X_GLOBAL_ATTRIBUTE11,
271 global_attribute12 = X_GLOBAL_ATTRIBUTE12,
272 global_attribute13 = X_GLOBAL_ATTRIBUTE13,
273 global_attribute14 = X_GLOBAL_ATTRIBUTE14,
274 global_attribute15 = X_GLOBAL_ATTRIBUTE15,
275 global_attribute16 = X_GLOBAL_ATTRIBUTE16,
276 global_attribute17 = X_GLOBAL_ATTRIBUTE17,
277 global_attribute18 = X_GLOBAL_ATTRIBUTE18,
278 global_attribute19 = X_GLOBAL_ATTRIBUTE19,
279 global_attribute2 = X_GLOBAL_ATTRIBUTE2 ,
280 global_attribute20 = X_GLOBAL_ATTRIBUTE20,
281 global_attribute3 = X_GLOBAL_ATTRIBUTE3 ,
282 global_attribute4 = X_GLOBAL_ATTRIBUTE4 ,
283 global_attribute5 = X_GLOBAL_ATTRIBUTE5 ,
284 global_attribute6 = X_GLOBAL_ATTRIBUTE6 ,
285 global_attribute7 = X_GLOBAL_ATTRIBUTE7 ,
286 global_attribute8 = X_GLOBAL_ATTRIBUTE8 ,
287 global_attribute9 = X_GLOBAL_ATTRIBUTE9 ,
288 global_attribute_category = X_GLOBAL_ATTRIBUTE_CATEGORY ,
289 inventorial = X_INVENTORIAL,
290 transaction_type_code = X_transaction_type_code,
291 transaction_date = X_transaction_date,
292 warranty_id = X_warranty_id,
293 warranty_number = X_warranty_number,
294 lease_id = X_lease_id,
295 lessor_id = X_lessor_id,
296 property_type_code = X_property_type_code,
297 property_1245_1250_code = X_property_1245_1250_code,
298 in_use_flag = X_in_use_flag,
299 owned_leased = X_owned_leased,
300 new_used = X_new_used,
301 asset_id = X_asset_id,
302 group_asset_id = X_group_asset_id,
303 deprn_method_code = X_deprn_method_code ,
304 life_in_months = X_life_in_months ,
305 basic_rate = X_basic_rate ,
306 adjusted_rate = X_adjusted_rate
307 -- Added for bug 8675206
308 ,bonus_rule = X_bonus_rule
309 ,prorate_convention_code = X_prorate_convention_code
310 , deprn_limit_type = X_deprn_limit_type -- -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
311 , allowed_deprn_limit_amount = X_allowed_deprn_limit_amount
312 , allowed_deprn_limit = X_allowed_deprn_limit
313 , salvage_type = X_salvage_type
314 , percent_salvage_value = X_percent_salvage_value
315 , nbv_at_switch = X_nbv_at_switch
316 , prior_deprn_limit_type = X_prior_deprn_limit_type
317 , prior_deprn_limit_amount = X_prior_deprn_limit_amount
318 , prior_deprn_limit = X_prior_deprn_limit
319 , prior_deprn_method = X_prior_deprn_method
320 , prior_life_in_months = X_prior_life_in_months
321 , prior_basic_rate = X_prior_basic_rate
322 , prior_adjusted_rate = X_prior_adjusted_rate
323 , period_full_reserve = X_period_full_reserve
324 , period_extd_deprn = X_period_extd_deprn
325 -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy end
326 WHERE rowid = X_Rowid;
327
328
329 if (SQL%NOTFOUND) then
330 Raise NO_DATA_FOUND;
331 end if;
332
333 END Update_Row;
334
335 END FA_MASS_ADDITIONS_PKG;