[Home] [Help]
PACKAGE BODY: APPS.FA_MASS_ADDITIONS_PKG
Source
1 PACKAGE BODY FA_MASS_ADDITIONS_PKG as
2 /* $Header: faximab.pls 120.7 2005/07/28 00:17:20 tkawamur 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_invoice_distribution_id NUMBER DEFAULT NULL,
141 X_invoice_line_number NUMBER DEFAULT NULL,
142 X_po_distribution_id NUMBER DEFAULT NULL,
143 X_warranty_number VARCHAR2 DEFAULT NULL,
144 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
145 BEGIN
146 UPDATE fa_mass_additions
147 SET
148 mass_addition_id = X_Mass_Addition_Id,
149 asset_number = X_Asset_Number,
150 tag_number = X_Tag_Number,
151 description = X_Description,
152 asset_category_id = X_Asset_Category_Id,
153 Manufacturer_name = X_Manufacturer_Name,
154 serial_number = X_Serial_Number,
155 model_number = X_Model_Number,
156 book_type_code = X_Book_Type_Code,
157 date_placed_in_service = X_Date_Placed_In_Service,
158 fixed_assets_cost = X_Fixed_Assets_Cost,
159 payables_units = X_Payables_Units,
160 fixed_assets_units = X_Fixed_Assets_Units,
161 payables_code_combination_id = X_Payables_Code_Combination_Id,
162 expense_code_combination_id = X_Expense_Code_Combination_Id,
163 location_id = X_Location_Id,
164 assigned_to = X_Assigned_To,
165 feeder_system_name = X_Feeder_System_Name,
166 create_batch_date = X_Create_Batch_Date,
167 create_batch_id = X_Create_Batch_Id,
168 last_update_date = X_Last_Update_Date,
169 last_updated_by = X_Last_Updated_By,
170 reviewer_comments = X_Reviewer_Comments,
171 invoice_number = X_Invoice_Number,
172 vendor_number = X_Vendor_Number,
173 po_vendor_id = X_Po_Vendor_Id,
174 po_number = X_Po_Number,
175 posting_status = X_Posting_Status,
176 queue_name = X_Queue_Name,
177 invoice_date = X_Invoice_Date,
178 invoice_created_by = X_Invoice_Created_By,
179 invoice_updated_by = X_Invoice_Updated_By,
180 payables_cost = X_Payables_Cost,
181 invoice_id = X_Invoice_Id,
182 payables_batch_name = X_Payables_Batch_Name,
183 depreciate_flag = X_Depreciate_Flag,
184 parent_Mass_addition_id = X_Parent_Mass_Addition_Id,
185 parent_asset_id = X_Parent_Asset_Id,
186 split_merged_code = X_Split_Merged_Code,
187 ap_distribution_line_number = X_Ap_Distribution_Line_Number,
188 post_batch_id = X_Post_Batch_Id,
189 add_to_asset_id = X_Add_To_Asset_Id,
190 amortize_flag = X_Amortize_Flag,
191 new_Master_flag = X_New_Master_Flag,
192 asset_key_ccid = X_Asset_Key_Ccid,
193 asset_type = X_Asset_Type,
194 deprn_reserve = X_Deprn_Reserve,
195 ytd_deprn = X_Ytd_Deprn,
196 beginning_nbv = X_Beginning_Nbv,
197 last_update_login = X_Last_Update_Login,
198 salvage_value = X_Salvage_Value,
199 accounting_date = X_Accounting_Date,
200 attribute1 = X_Attribute1,
201 attribute2 = X_Attribute2,
202 attribute3 = X_Attribute3,
203 attribute4 = X_Attribute4,
204 attribute5 = X_Attribute5,
205 attribute6 = X_Attribute6,
206 attribute7 = X_Attribute7,
207 attribute8 = X_Attribute8,
208 attribute9 = X_Attribute9,
209 attribute10 = X_Attribute10,
210 attribute11 = X_Attribute11,
211 attribute12 = X_Attribute12,
212 attribute13 = X_Attribute13,
213 attribute14 = X_Attribute14,
214 attribute15 = X_Attribute15,
215 attribute_category_code = X_Attribute_Category_Code,
216 fully_rsvd_revals_counter = X_Fully_Rsvd_Revals_Counter,
217 merge_invoice_number = X_Merge_Invoice_Number,
218 merge_vendor_number = X_Merge_Vendor_Number,
219 production_capacity = X_Production_Capacity,
220 reval_amortization_basis = X_Reval_Amortization_Basis,
221 reval_reserve = X_Reval_Reserve,
222 unit_of_measure = X_Unit_Of_Measure,
223 unrevalued_cost = X_Unrevalued_Cost,
224 ytd_reval_deprn_expense = X_Ytd_Reval_Deprn_Expense,
225 attribute16 = X_Attribute16,
226 attribute17 = X_Attribute17,
227 attribute18 = X_Attribute18,
228 attribute19 = X_Attribute19,
229 attribute20 = X_Attribute20,
230 attribute21 = X_Attribute21,
231 attribute22 = X_Attribute22,
232 attribute23 = X_Attribute23,
233 attribute24 = X_Attribute24,
234 attribute25 = X_Attribute25,
235 attribute26 = X_Attribute26,
236 attribute27 = X_Attribute27,
237 attribute28 = X_Attribute28,
238 attribute29 = X_Attribute29,
239 attribute30 = X_Attribute30,
240 merged_code = X_Merged_Code,
241 split_code = X_Split_Code,
242 merge_parent_Mass_additions_id = X_Merge_parent_Mass_Add_ID,
243 split_parent_Mass_additions_id = X_Split_PArent_Mass_Add_ID,
244 sum_units = X_Sum_Units,
245 context = X_Context,
246 global_attribute1 = X_GLOBAL_ATTRIBUTE1,
247 global_attribute10 = X_GLOBAL_ATTRIBUTE10,
248 global_attribute11 = X_GLOBAL_ATTRIBUTE11,
249 global_attribute12 = X_GLOBAL_ATTRIBUTE12,
250 global_attribute13 = X_GLOBAL_ATTRIBUTE13,
251 global_attribute14 = X_GLOBAL_ATTRIBUTE14,
252 global_attribute15 = X_GLOBAL_ATTRIBUTE15,
253 global_attribute16 = X_GLOBAL_ATTRIBUTE16,
254 global_attribute17 = X_GLOBAL_ATTRIBUTE17,
255 global_attribute18 = X_GLOBAL_ATTRIBUTE18,
256 global_attribute19 = X_GLOBAL_ATTRIBUTE19,
257 global_attribute2 = X_GLOBAL_ATTRIBUTE2 ,
258 global_attribute20 = X_GLOBAL_ATTRIBUTE20,
259 global_attribute3 = X_GLOBAL_ATTRIBUTE3 ,
260 global_attribute4 = X_GLOBAL_ATTRIBUTE4 ,
261 global_attribute5 = X_GLOBAL_ATTRIBUTE5 ,
262 global_attribute6 = X_GLOBAL_ATTRIBUTE6 ,
263 global_attribute7 = X_GLOBAL_ATTRIBUTE7 ,
264 global_attribute8 = X_GLOBAL_ATTRIBUTE8 ,
265 global_attribute9 = X_GLOBAL_ATTRIBUTE9 ,
266 global_attribute_category = X_GLOBAL_ATTRIBUTE_CATEGORY ,
267 inventorial = X_INVENTORIAL,
268 transaction_type_code = X_transaction_type_code,
269 transaction_date = X_transaction_date,
270 warranty_id = X_warranty_id,
271 lease_id = X_lease_id,
272 lessor_id = X_lessor_id,
273 property_type_code = X_property_type_code,
274 property_1245_1250_code = X_property_1245_1250_code,
275 in_use_flag = X_in_use_flag,
276 owned_leased = X_owned_leased,
277 new_used = X_new_used,
278 asset_id = X_asset_id,
279 group_asset_id = X_group_asset_id,
280 invoice_distribution_id = X_invoice_distribution_id,
281 invoice_line_number = X_invoice_line_number,
282 po_distribution_id = X_po_distribution_id,
283 warranty_number = X_warranty_number
284 WHERE rowid = X_Rowid;
285
286 if (SQL%NOTFOUND) then
287 Raise NO_DATA_FOUND;
288 end if;
289
290 END Update_Row;
291
292
293 END FA_MASS_ADDITIONS_PKG;