[Home] [Help]
PACKAGE: APPS.FA_ADDITIONS_PKG
Source
1 PACKAGE FA_ADDITIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: faxiads.pls 120.8 2009/04/10 06:26:08 deemitta ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Asset_Id IN OUT NOCOPY NUMBER,
7 X_Asset_Number IN OUT NOCOPY VARCHAR2,
8 X_Asset_Key_Ccid NUMBER DEFAULT NULL,
9 X_Current_Units NUMBER,
10 X_Asset_Type VARCHAR2,
11 X_Tag_Number VARCHAR2 DEFAULT NULL,
12 X_Description VARCHAR2,
13 X_Asset_Category_Id NUMBER,
14 X_Parent_Asset_Id NUMBER DEFAULT NULL,
15 X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
16 X_Serial_Number VARCHAR2 DEFAULT NULL,
17 X_Model_Number VARCHAR2 DEFAULT NULL,
18 X_Property_Type_Code VARCHAR2 DEFAULT NULL,
19 X_Property_1245_1250_Code VARCHAR2 DEFAULT NULL,
20 X_In_Use_Flag VARCHAR2,
21 X_Owned_Leased VARCHAR2,
22 X_New_Used VARCHAR2,
23 X_Unit_Adjustment_Flag VARCHAR2,
24 X_Add_Cost_Je_Flag VARCHAR2,
25 X_Attribute1 VARCHAR2 DEFAULT NULL,
26 X_Attribute2 VARCHAR2 DEFAULT NULL,
27 X_Attribute3 VARCHAR2 DEFAULT NULL,
28 X_Attribute4 VARCHAR2 DEFAULT NULL,
29 X_Attribute5 VARCHAR2 DEFAULT NULL,
30 X_Attribute6 VARCHAR2 DEFAULT NULL,
31 X_Attribute7 VARCHAR2 DEFAULT NULL,
32 X_Attribute8 VARCHAR2 DEFAULT NULL,
33 X_Attribute9 VARCHAR2 DEFAULT NULL,
34 X_Attribute10 VARCHAR2 DEFAULT NULL,
35 X_Attribute11 VARCHAR2 DEFAULT NULL,
36 X_Attribute12 VARCHAR2 DEFAULT NULL,
37 X_Attribute13 VARCHAR2 DEFAULT NULL,
38 X_Attribute14 VARCHAR2 DEFAULT NULL,
39 X_Attribute15 VARCHAR2 DEFAULT NULL,
40 X_Attribute16 VARCHAR2 DEFAULT NULL,
41 X_Attribute17 VARCHAR2 DEFAULT NULL,
42 X_Attribute18 VARCHAR2 DEFAULT NULL,
43 X_Attribute19 VARCHAR2 DEFAULT NULL,
44 X_Attribute20 VARCHAR2 DEFAULT NULL,
45 X_Attribute21 VARCHAR2 DEFAULT NULL,
46 X_Attribute22 VARCHAR2 DEFAULT NULL,
47 X_Attribute23 VARCHAR2 DEFAULT NULL,
48 X_Attribute24 VARCHAR2 DEFAULT NULL,
49 X_Attribute25 VARCHAR2 DEFAULT NULL,
50 X_Attribute26 VARCHAR2 DEFAULT NULL,
51 X_Attribute27 VARCHAR2 DEFAULT NULL,
52 X_Attribute28 VARCHAR2 DEFAULT NULL,
53 X_Attribute29 VARCHAR2 DEFAULT NULL,
54 X_Attribute30 VARCHAR2 DEFAULT NULL,
55 X_Attribute_Category_Code VARCHAR2,
56 X_gf_Attribute1 VARCHAR2 DEFAULT NULL,
57 X_gf_Attribute2 VARCHAR2 DEFAULT NULL,
58 X_gf_Attribute3 VARCHAR2 DEFAULT NULL,
59 X_gf_Attribute4 VARCHAR2 DEFAULT NULL,
60 X_gf_Attribute5 VARCHAR2 DEFAULT NULL,
61 X_gf_Attribute6 VARCHAR2 DEFAULT NULL,
62 X_gf_Attribute7 VARCHAR2 DEFAULT NULL,
63 X_gf_Attribute8 VARCHAR2 DEFAULT NULL,
64 X_gf_Attribute9 VARCHAR2 DEFAULT NULL,
65 X_gf_Attribute10 VARCHAR2 DEFAULT NULL,
66 X_gf_Attribute11 VARCHAR2 DEFAULT NULL,
67 X_gf_Attribute12 VARCHAR2 DEFAULT NULL,
68 X_gf_Attribute13 VARCHAR2 DEFAULT NULL,
69 X_gf_Attribute14 VARCHAR2 DEFAULT NULL,
70 X_gf_Attribute15 VARCHAR2 DEFAULT NULL,
71 X_gf_Attribute16 VARCHAR2 DEFAULT NULL,
72 X_gf_Attribute17 VARCHAR2 DEFAULT NULL,
73 X_gf_Attribute18 VARCHAR2 DEFAULT NULL,
74 X_gf_Attribute19 VARCHAR2 DEFAULT NULL,
75 X_gf_Attribute20 VARCHAR2 DEFAULT NULL,
76 X_gf_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
77 X_Context VARCHAR2 DEFAULT NULL,
78 X_Lease_Id NUMBER DEFAULT NULL,
79 X_Inventorial VARCHAR2,
80 X_Commitment VARCHAR2 DEFAULT NULL,
81 X_Investment_Law VARCHAR2 DEFAULT NULL,
82 X_Status VARCHAR2 DEFAULT NULL,
83 X_Last_Update_Date DATE,
84 X_Last_Updated_By NUMBER,
85 X_Created_By NUMBER DEFAULT NULL,
86 X_Creation_Date DATE DEFAULT NULL,
87 X_Last_Update_Login NUMBER DEFAULT NULL,
88 X_Calling_Fn VARCHAR2
89 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
90
91 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
92 X_Asset_Id NUMBER,
93 X_Asset_Number VARCHAR2,
94 X_Asset_Key_Ccid NUMBER DEFAULT NULL,
95 X_Current_Units NUMBER,
96 X_Asset_Type VARCHAR2,
97 X_Tag_Number VARCHAR2 DEFAULT NULL,
98 X_Description VARCHAR2,
99 X_Asset_Category_Id NUMBER,
100 X_Parent_Asset_Id NUMBER DEFAULT NULL,
101 X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
102 X_Serial_Number VARCHAR2 DEFAULT NULL,
103 X_Model_Number VARCHAR2 DEFAULT NULL,
104 X_Property_Type_Code VARCHAR2 DEFAULT NULL,
105 X_Property_1245_1250_Code VARCHAR2 DEFAULT NULL,
106 X_In_Use_Flag VARCHAR2,
107 X_Owned_Leased VARCHAR2,
108 X_New_Used VARCHAR2,
109 X_Unit_Adjustment_Flag VARCHAR2,
110 X_Add_Cost_Je_Flag VARCHAR2,
111 X_Attribute1 VARCHAR2 DEFAULT NULL,
112 X_Attribute2 VARCHAR2 DEFAULT NULL,
113 X_Attribute3 VARCHAR2 DEFAULT NULL,
114 X_Attribute4 VARCHAR2 DEFAULT NULL,
115 X_Attribute5 VARCHAR2 DEFAULT NULL,
116 X_Attribute6 VARCHAR2 DEFAULT NULL,
117 X_Attribute7 VARCHAR2 DEFAULT NULL,
118 X_Attribute8 VARCHAR2 DEFAULT NULL,
119 X_Attribute9 VARCHAR2 DEFAULT NULL,
120 X_Attribute10 VARCHAR2 DEFAULT NULL,
121 X_Attribute11 VARCHAR2 DEFAULT NULL,
122 X_Attribute12 VARCHAR2 DEFAULT NULL,
123 X_Attribute13 VARCHAR2 DEFAULT NULL,
124 X_Attribute14 VARCHAR2 DEFAULT NULL,
125 X_Attribute15 VARCHAR2 DEFAULT NULL,
126 X_Attribute16 VARCHAR2 DEFAULT NULL,
127 X_Attribute17 VARCHAR2 DEFAULT NULL,
128 X_Attribute18 VARCHAR2 DEFAULT NULL,
129 X_Attribute19 VARCHAR2 DEFAULT NULL,
130 X_Attribute20 VARCHAR2 DEFAULT NULL,
131 X_Attribute21 VARCHAR2 DEFAULT NULL,
132 X_Attribute22 VARCHAR2 DEFAULT NULL,
133 X_Attribute23 VARCHAR2 DEFAULT NULL,
134 X_Attribute24 VARCHAR2 DEFAULT NULL,
135 X_Attribute25 VARCHAR2 DEFAULT NULL,
136 X_Attribute26 VARCHAR2 DEFAULT NULL,
137 X_Attribute27 VARCHAR2 DEFAULT NULL,
138 X_Attribute28 VARCHAR2 DEFAULT NULL,
139 X_Attribute29 VARCHAR2 DEFAULT NULL,
140 X_Attribute30 VARCHAR2 DEFAULT NULL,
141 X_Attribute_Category_Code VARCHAR2,
142 X_Context VARCHAR2 DEFAULT NULL,
143 X_Lease_Id NUMBER DEFAULT NULL,
144 X_Inventorial VARCHAR2,
145 X_Commitment VARCHAR2 DEFAULT NULL,
146 X_Investment_Law VARCHAR2 DEFAULT NULL,
147 X_Calling_Fn VARCHAR2
148 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
149
150
151 -- syoung: added x_return_status.
152 PROCEDURE Update_Row(X_Rowid VARCHAR2 DEFAULT NULL,
153 X_Asset_Id NUMBER DEFAULT NULL,
154 X_Asset_Number VARCHAR2 DEFAULT NULL,
155 X_Asset_Key_Ccid NUMBER DEFAULT NULL,
156 X_Current_Units NUMBER DEFAULT NULL,
157 X_Asset_Type VARCHAR2 DEFAULT NULL,
158 X_Tag_Number VARCHAR2 DEFAULT NULL,
159 X_Description VARCHAR2 DEFAULT NULL,
160 X_Asset_Category_Id NUMBER DEFAULT NULL,
161 X_Parent_Asset_Id NUMBER DEFAULT NULL,
162 X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
163 X_Serial_Number VARCHAR2 DEFAULT NULL,
164 X_Model_Number VARCHAR2 DEFAULT NULL,
165 X_Property_Type_Code VARCHAR2 DEFAULT NULL,
166 X_Property_1245_1250_Code VARCHAR2 DEFAULT NULL,
167 X_In_Use_Flag VARCHAR2 DEFAULT NULL,
168 X_Owned_Leased VARCHAR2 DEFAULT NULL,
169 X_New_Used VARCHAR2 DEFAULT NULL,
170 X_Unit_Adjustment_Flag VARCHAR2 DEFAULT NULL,
171 X_Add_Cost_Je_Flag VARCHAR2 DEFAULT NULL,
172 X_Attribute1 VARCHAR2 DEFAULT NULL,
173 X_Attribute2 VARCHAR2 DEFAULT NULL,
174 X_Attribute3 VARCHAR2 DEFAULT NULL,
175 X_Attribute4 VARCHAR2 DEFAULT NULL,
176 X_Attribute5 VARCHAR2 DEFAULT NULL,
177 X_Attribute6 VARCHAR2 DEFAULT NULL,
178 X_Attribute7 VARCHAR2 DEFAULT NULL,
179 X_Attribute8 VARCHAR2 DEFAULT NULL,
183 X_Attribute12 VARCHAR2 DEFAULT NULL,
180 X_Attribute9 VARCHAR2 DEFAULT NULL,
181 X_Attribute10 VARCHAR2 DEFAULT NULL,
182 X_Attribute11 VARCHAR2 DEFAULT NULL,
184 X_Attribute13 VARCHAR2 DEFAULT NULL,
185 X_Attribute14 VARCHAR2 DEFAULT NULL,
186 X_Attribute15 VARCHAR2 DEFAULT NULL,
187 X_Attribute16 VARCHAR2 DEFAULT NULL,
188 X_Attribute17 VARCHAR2 DEFAULT NULL,
189 X_Attribute18 VARCHAR2 DEFAULT NULL,
190 X_Attribute19 VARCHAR2 DEFAULT NULL,
191 X_Attribute20 VARCHAR2 DEFAULT NULL,
192 X_Attribute21 VARCHAR2 DEFAULT NULL,
193 X_Attribute22 VARCHAR2 DEFAULT NULL,
194 X_Attribute23 VARCHAR2 DEFAULT NULL,
195 X_Attribute24 VARCHAR2 DEFAULT NULL,
196 X_Attribute25 VARCHAR2 DEFAULT NULL,
197 X_Attribute26 VARCHAR2 DEFAULT NULL,
198 X_Attribute27 VARCHAR2 DEFAULT NULL,
199 X_Attribute28 VARCHAR2 DEFAULT NULL,
200 X_Attribute29 VARCHAR2 DEFAULT NULL,
201 X_Attribute30 VARCHAR2 DEFAULT NULL,
202 X_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
203 X_gf_Attribute1 VARCHAR2 DEFAULT NULL,
204 X_gf_Attribute2 VARCHAR2 DEFAULT NULL,
205 X_gf_Attribute3 VARCHAR2 DEFAULT NULL,
206 X_gf_Attribute4 VARCHAR2 DEFAULT NULL,
207 X_gf_Attribute5 VARCHAR2 DEFAULT NULL,
208 X_gf_Attribute6 VARCHAR2 DEFAULT NULL,
209 X_gf_Attribute7 VARCHAR2 DEFAULT NULL,
210 X_gf_Attribute8 VARCHAR2 DEFAULT NULL,
211 X_gf_Attribute9 VARCHAR2 DEFAULT NULL,
212 X_gf_Attribute10 VARCHAR2 DEFAULT NULL,
213 X_gf_Attribute11 VARCHAR2 DEFAULT NULL,
214 X_gf_Attribute12 VARCHAR2 DEFAULT NULL,
215 X_gf_Attribute13 VARCHAR2 DEFAULT NULL,
216 X_gf_Attribute14 VARCHAR2 DEFAULT NULL,
217 X_gf_Attribute15 VARCHAR2 DEFAULT NULL,
218 X_gf_Attribute16 VARCHAR2 DEFAULT NULL,
219 X_gf_Attribute17 VARCHAR2 DEFAULT NULL,
220 X_gf_Attribute18 VARCHAR2 DEFAULT NULL,
221 X_gf_Attribute19 VARCHAR2 DEFAULT NULL,
222 X_gf_Attribute20 VARCHAR2 DEFAULT NULL,
223 X_gf_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
224 X_Context VARCHAR2 DEFAULT NULL,
225 X_Lease_Id NUMBER DEFAULT NULL,
226 X_Inventorial VARCHAR2 DEFAULT NULL,
227 X_Commitment VARCHAR2 DEFAULT NULL,
228 X_Investment_Law VARCHAR2 DEFAULT NULL,
229 X_Status VARCHAR2 DEFAULT NULL,
230 X_Last_Update_Date DATE DEFAULT NULL,
231 X_Last_Updated_By NUMBER DEFAULT NULL,
232 X_Last_Update_Login NUMBER DEFAULT NULL,
233 X_Return_Status OUT NOCOPY BOOLEAN,
234 X_Calling_Fn VARCHAR2
235 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
236
237 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
238 X_Asset_Id number,
239 X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
240
241 PROCEDURE Update_Units(X_Asset_Id NUMBER,
242 X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
243
244 PROCEDURE ADD_LANGUAGE;
245
246 PROCEDURE LOAD_ROW (X_Asset_Id IN NUMBER,
247 X_Asset_Number IN VARCHAR2,
248 X_Asset_Key_Ccid IN NUMBER DEFAULT NULL,
249 X_Current_Units IN NUMBER,
250 X_Asset_Type IN VARCHAR2,
251 X_Tag_Number IN VARCHAR2 DEFAULT NULL,
252 X_Description IN VARCHAR2,
253 X_Asset_Category_Id IN NUMBER,
254 X_Parent_Asset_Id IN NUMBER DEFAULT NULL,
255 X_Manufacturer_Name IN VARCHAR2 DEFAULT NULL,
256 X_Serial_Number IN VARCHAR2 DEFAULT NULL,
257 X_Model_Number IN VARCHAR2 DEFAULT NULL,
258 X_Property_Type_Code IN VARCHAR2 DEFAULT NULL,
259 X_Property_1245_1250_Code IN VARCHAR2 DEFAULT NULL,
260 X_In_Use_Flag IN VARCHAR2,
261 X_Owned_Leased IN VARCHAR2,
265 X_Attribute1 IN VARCHAR2 DEFAULT NULL,
262 X_New_Used IN VARCHAR2,
263 X_Unit_Adjustment_Flag IN VARCHAR2,
264 X_Add_Cost_Je_Flag IN VARCHAR2,
266 X_Attribute2 IN VARCHAR2 DEFAULT NULL,
267 X_Attribute3 IN VARCHAR2 DEFAULT NULL,
268 X_Attribute4 IN VARCHAR2 DEFAULT NULL,
269 X_Attribute5 IN VARCHAR2 DEFAULT NULL,
270 X_Attribute6 IN VARCHAR2 DEFAULT NULL,
271 X_Attribute7 IN VARCHAR2 DEFAULT NULL,
272 X_Attribute8 IN VARCHAR2 DEFAULT NULL,
273 X_Attribute9 IN VARCHAR2 DEFAULT NULL,
274 X_Attribute10 IN VARCHAR2 DEFAULT NULL,
275 X_Attribute11 IN VARCHAR2 DEFAULT NULL,
276 X_Attribute12 IN VARCHAR2 DEFAULT NULL,
277 X_Attribute13 IN VARCHAR2 DEFAULT NULL,
278 X_Attribute14 IN VARCHAR2 DEFAULT NULL,
279 X_Attribute15 IN VARCHAR2 DEFAULT NULL,
280 X_Attribute16 IN VARCHAR2 DEFAULT NULL,
281 X_Attribute17 IN VARCHAR2 DEFAULT NULL,
282 X_Attribute18 IN VARCHAR2 DEFAULT NULL,
283 X_Attribute19 IN VARCHAR2 DEFAULT NULL,
284 X_Attribute20 IN VARCHAR2 DEFAULT NULL,
285 X_Attribute21 IN VARCHAR2 DEFAULT NULL,
286 X_Attribute22 IN VARCHAR2 DEFAULT NULL,
287 X_Attribute23 IN VARCHAR2 DEFAULT NULL,
288 X_Attribute24 IN VARCHAR2 DEFAULT NULL,
289 X_Attribute25 IN VARCHAR2 DEFAULT NULL,
290 X_Attribute26 IN VARCHAR2 DEFAULT NULL,
291 X_Attribute27 IN VARCHAR2 DEFAULT NULL,
292 X_Attribute28 IN VARCHAR2 DEFAULT NULL,
293 X_Attribute29 IN VARCHAR2 DEFAULT NULL,
294 X_Attribute30 IN VARCHAR2 DEFAULT NULL,
295 X_Attribute_Category_Code IN VARCHAR2,
296 X_Context IN VARCHAR2 DEFAULT NULL,
297 X_Lease_Id IN NUMBER DEFAULT NULL,
298 X_Inventorial IN VARCHAR2,
299 X_Commitment VARCHAR2 DEFAULT NULL,
300 X_Investment_Law VARCHAR2 DEFAULT NULL,
301 X_Status IN VARCHAR2 DEFAULT NULL,
302 X_gf_Attribute1 IN VARCHAR2 DEFAULT NULL,
303 X_gf_Attribute2 IN VARCHAR2 DEFAULT NULL,
304 X_gf_Attribute3 IN VARCHAR2 DEFAULT NULL,
305 X_gf_Attribute4 IN VARCHAR2 DEFAULT NULL,
306 X_gf_Attribute5 IN VARCHAR2 DEFAULT NULL,
307 X_gf_Attribute6 IN VARCHAR2 DEFAULT NULL,
308 X_gf_Attribute7 IN VARCHAR2 DEFAULT NULL,
309 X_gf_Attribute8 IN VARCHAR2 DEFAULT NULL,
310 X_gf_Attribute9 IN VARCHAR2 DEFAULT NULL,
311 X_gf_Attribute10 IN VARCHAR2 DEFAULT NULL,
312 X_gf_Attribute11 IN VARCHAR2 DEFAULT NULL,
313 X_gf_Attribute12 IN VARCHAR2 DEFAULT NULL,
314 X_gf_Attribute13 IN VARCHAR2 DEFAULT NULL,
315 X_gf_Attribute14 IN VARCHAR2 DEFAULT NULL,
316 X_gf_Attribute15 IN VARCHAR2 DEFAULT NULL,
317 X_gf_Attribute16 IN VARCHAR2 DEFAULT NULL,
318 X_gf_Attribute17 IN VARCHAR2 DEFAULT NULL,
319 X_gf_Attribute18 IN VARCHAR2 DEFAULT NULL,
320 X_gf_Attribute19 IN VARCHAR2 DEFAULT NULL,
321 X_gf_Attribute20 IN VARCHAR2 DEFAULT NULL,
322 X_gf_Attribute_Category IN VARCHAR2 DEFAULT NULL
323 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
324
325 /*Bug 8355119 overloading function for release specific signatures*/
326
327 PROCEDURE LOAD_ROW (
328 X_Custom_Mode IN VARCHAR2,
329 X_Asset_Id IN NUMBER,
330 X_Owner IN VARCHAR2,
331 X_Last_Update_Date IN DATE,
332 X_Asset_Number IN VARCHAR2,
333 X_Asset_Key_Ccid IN NUMBER DEFAULT NULL,
334 X_Current_Units IN NUMBER,
335 X_Asset_Type IN VARCHAR2,
336 X_Tag_Number IN VARCHAR2 DEFAULT NULL,
337 X_Description IN VARCHAR2,
338 X_Asset_Category_Id IN NUMBER,
339 X_Parent_Asset_Id IN NUMBER DEFAULT NULL,
340 X_Manufacturer_Name IN VARCHAR2 DEFAULT NULL,
341 X_Serial_Number IN VARCHAR2 DEFAULT NULL,
342 X_Model_Number IN VARCHAR2 DEFAULT NULL,
343 X_Property_Type_Code IN VARCHAR2 DEFAULT NULL,
344 X_Property_1245_1250_Code IN VARCHAR2 DEFAULT NULL,
348 X_Unit_Adjustment_Flag IN VARCHAR2,
345 X_In_Use_Flag IN VARCHAR2,
346 X_Owned_Leased IN VARCHAR2,
347 X_New_Used IN VARCHAR2,
349 X_Add_Cost_Je_Flag IN VARCHAR2,
350 X_Attribute1 IN VARCHAR2 DEFAULT NULL,
351 X_Attribute2 IN VARCHAR2 DEFAULT NULL,
352 X_Attribute3 IN VARCHAR2 DEFAULT NULL,
353 X_Attribute4 IN VARCHAR2 DEFAULT NULL,
354 X_Attribute5 IN VARCHAR2 DEFAULT NULL,
355 X_Attribute6 IN VARCHAR2 DEFAULT NULL,
356 X_Attribute7 IN VARCHAR2 DEFAULT NULL,
357 X_Attribute8 IN VARCHAR2 DEFAULT NULL,
358 X_Attribute9 IN VARCHAR2 DEFAULT NULL,
359 X_Attribute10 IN VARCHAR2 DEFAULT NULL,
360 X_Attribute11 IN VARCHAR2 DEFAULT NULL,
361 X_Attribute12 IN VARCHAR2 DEFAULT NULL,
362 X_Attribute13 IN VARCHAR2 DEFAULT NULL,
363 X_Attribute14 IN VARCHAR2 DEFAULT NULL,
364 X_Attribute15 IN VARCHAR2 DEFAULT NULL,
365 X_Attribute16 IN VARCHAR2 DEFAULT NULL,
366 X_Attribute17 IN VARCHAR2 DEFAULT NULL,
367 X_Attribute18 IN VARCHAR2 DEFAULT NULL,
368 X_Attribute19 IN VARCHAR2 DEFAULT NULL,
369 X_Attribute20 IN VARCHAR2 DEFAULT NULL,
370 X_Attribute21 IN VARCHAR2 DEFAULT NULL,
371 X_Attribute22 IN VARCHAR2 DEFAULT NULL,
372 X_Attribute23 IN VARCHAR2 DEFAULT NULL,
373 X_Attribute24 IN VARCHAR2 DEFAULT NULL,
374 X_Attribute25 IN VARCHAR2 DEFAULT NULL,
375 X_Attribute26 IN VARCHAR2 DEFAULT NULL,
376 X_Attribute27 IN VARCHAR2 DEFAULT NULL,
377 X_Attribute28 IN VARCHAR2 DEFAULT NULL,
378 X_Attribute29 IN VARCHAR2 DEFAULT NULL,
379 X_Attribute30 IN VARCHAR2 DEFAULT NULL,
380 X_Attribute_Category_Code IN VARCHAR2,
381 X_Context IN VARCHAR2 DEFAULT NULL,
382 X_Lease_Id IN NUMBER DEFAULT NULL,
383 X_Inventorial IN VARCHAR2,
384 X_Commitment IN VARCHAR2 DEFAULT NULL,
385 X_Investment_Law IN VARCHAR2 DEFAULT NULL,
386 X_Status IN VARCHAR2 DEFAULT NULL,
387 X_gf_Attribute1 IN VARCHAR2 DEFAULT NULL,
388 X_gf_Attribute2 IN VARCHAR2 DEFAULT NULL,
389 X_gf_Attribute3 IN VARCHAR2 DEFAULT NULL,
390 X_gf_Attribute4 IN VARCHAR2 DEFAULT NULL,
391 X_gf_Attribute5 IN VARCHAR2 DEFAULT NULL,
392 X_gf_Attribute6 IN VARCHAR2 DEFAULT NULL,
393 X_gf_Attribute7 IN VARCHAR2 DEFAULT NULL,
394 X_gf_Attribute8 IN VARCHAR2 DEFAULT NULL,
395 X_gf_Attribute9 IN VARCHAR2 DEFAULT NULL,
396 X_gf_Attribute10 IN VARCHAR2 DEFAULT NULL,
397 X_gf_Attribute11 IN VARCHAR2 DEFAULT NULL,
398 X_gf_Attribute12 IN VARCHAR2 DEFAULT NULL,
399 X_gf_Attribute13 IN VARCHAR2 DEFAULT NULL,
400 X_gf_Attribute14 IN VARCHAR2 DEFAULT NULL,
401 X_gf_Attribute15 IN VARCHAR2 DEFAULT NULL,
402 X_gf_Attribute16 IN VARCHAR2 DEFAULT NULL,
403 X_gf_Attribute17 IN VARCHAR2 DEFAULT NULL,
404 X_gf_Attribute18 IN VARCHAR2 DEFAULT NULL,
405 X_gf_Attribute19 IN VARCHAR2 DEFAULT NULL,
406 X_gf_Attribute20 IN VARCHAR2 DEFAULT NULL,
407 X_gf_Attribute_Category IN VARCHAR2 DEFAULT NULL,
408 p_log_level_rec IN fa_api_types.log_level_rec_type
409 DEFAULT NULL);
410
411 PROCEDURE TRANSLATE_ROW(X_Asset_Id IN NUMBER,
412 X_Description IN VARCHAR2
413 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
414
415 /*Bug 8355119 overloading function for release specific signatures*/
416 PROCEDURE TRANSLATE_ROW(X_Custom_Mode IN VARCHAR2,
417 X_Asset_Id IN NUMBER,
418 X_Owner IN VARCHAR2,
419 X_Last_Update_Date IN DATE,
420 X_Description IN VARCHAR2,
421 p_log_level_rec in fa_api_types.log_level_rec_type default null
422 );
423 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
424 PROCEDURE LOAD_SEED_ROW (
425 x_upload_mode IN VARCHAR2,
426 x_custom_mode IN VARCHAR2,
427 x_asset_id IN NUMBER,
428 x_owner IN VARCHAR2,
429 x_last_update_date IN DATE,
430 x_asset_number IN VARCHAR2,
431 x_asset_key_ccid IN NUMBER,
432 x_current_units IN NUMBER,
433 x_asset_type IN VARCHAR2,
434 x_tag_number IN VARCHAR2,
435 x_description IN VARCHAR2,
436 x_asset_category_id IN NUMBER,
437 x_parent_asset_id IN NUMBER,
438 x_manufacturer_name IN VARCHAR2,
439 x_serial_number IN VARCHAR2,
440 x_model_number IN VARCHAR2,
444 x_owned_leased IN VARCHAR2,
441 x_property_type_code IN VARCHAR2,
442 x_property_1245_1250_code IN VARCHAR2,
443 x_in_use_flag IN VARCHAR2,
445 x_new_used IN VARCHAR2,
446 x_unit_adjustment_flag IN VARCHAR2,
447 x_add_cost_je_flag IN VARCHAR2,
448 x_attribute1 IN VARCHAR2,
449 x_attribute2 IN VARCHAR2,
450 x_attribute3 IN VARCHAR2,
451 x_attribute4 IN VARCHAR2,
452 x_attribute5 IN VARCHAR2,
453 x_attribute6 IN VARCHAR2,
454 x_attribute7 IN VARCHAR2,
455 x_attribute8 IN VARCHAR2,
456 x_attribute9 IN VARCHAR2,
457 x_attribute10 IN VARCHAR2,
458 x_attribute11 IN VARCHAR2,
459 x_attribute12 IN VARCHAR2,
460 x_attribute13 IN VARCHAR2,
461 x_attribute14 IN VARCHAR2,
462 x_attribute15 IN VARCHAR2,
463 x_attribute16 IN VARCHAR2,
464 x_attribute17 IN VARCHAR2,
465 x_attribute18 IN VARCHAR2,
466 x_attribute19 IN VARCHAR2,
467 x_attribute20 IN VARCHAR2,
468 x_attribute21 IN VARCHAR2,
469 x_attribute22 IN VARCHAR2,
470 x_attribute23 IN VARCHAR2,
471 x_attribute24 IN VARCHAR2,
472 x_attribute25 IN VARCHAR2,
473 x_attribute26 IN VARCHAR2,
474 x_attribute27 IN VARCHAR2,
475 x_attribute28 IN VARCHAR2,
476 x_attribute29 IN VARCHAR2,
477 x_attribute30 IN VARCHAR2,
478 x_attribute_category_code IN VARCHAR2,
479 x_context IN VARCHAR2,
480 x_lease_id IN NUMBER,
481 x_inventorial IN VARCHAR2,
482 x_commitment IN VARCHAR2,
483 x_investment_law IN VARCHAR2,
484 x_gf_attribute1 IN VARCHAR2,
485 x_gf_attribute2 IN VARCHAR2,
486 x_gf_attribute3 IN VARCHAR2,
487 x_gf_attribute4 IN VARCHAR2,
488 x_gf_attribute5 IN VARCHAR2,
489 x_gf_attribute6 IN VARCHAR2,
490 x_gf_attribute7 IN VARCHAR2,
491 x_gf_attribute8 IN VARCHAR2,
492 x_gf_attribute9 IN VARCHAR2,
493 x_gf_attribute10 IN VARCHAR2,
494 x_gf_attribute11 IN VARCHAR2,
495 x_gf_attribute12 IN VARCHAR2,
496 x_gf_attribute13 IN VARCHAR2,
497 x_gf_attribute14 IN VARCHAR2,
498 x_gf_attribute15 IN VARCHAR2,
499 x_gf_attribute16 IN VARCHAR2,
500 x_gf_attribute17 IN VARCHAR2,
501 x_gf_attribute18 IN VARCHAR2,
502 x_gf_attribute19 IN VARCHAR2,
503 x_gf_attribute20 IN VARCHAR2,
504 x_gf_attribute_category IN VARCHAR2,
505 p_log_level_rec in fa_api_types.log_level_rec_type default null);
506
507 END FA_ADDITIONS_PKG;