[Home] [Help]
PACKAGE: APPS.EAM_ASSET_NUMBER_PVT
Source
1 PACKAGE EAM_ASSET_NUMBER_PVT as
2 /* $Header: EAMVASNS.pls 120.8.12010000.1 2008/07/24 11:49:38 appldev ship $ */
3 -- Start of comments
4 -- API name : EAM_ASSET_NUMBER_PVT
5 -- Type : Private
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN P_API_VERSION IN NUMBER REQUIRED
10 -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11 -- DEFAULT = FND_API.G_FALSE
12 -- P_COMMIT IN VARCHAR2 OPTIONAL
13 -- DEFAULT = FND_API.G_FALSE
14 -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16 -- P_INVENTORY_ITEM_ID IN NUMBER
17 -- P_SERIAL_NUMBER IN VARCHAR2
18 -- P_INSTANCE_NUMBER VARCHAR2,
19 -- P_START_DATE_ACTIVE IN DATE
20 -- P_DESCRIPTIVE_TEXT IN VARCHAR2
21 -- P_ORGANIZATION_ID IN NUMBER
22 -- P_CATEGORY_ID IN NUMBER
23 -- P_PN_LOCATION_ID IN NUMBER
24 --
25 -- P_FA_ASSET_ID IN NUMBER
26 -- P_ASSET_CRITICALITY_CODE IN VARCHAR2
27 -- P_MAINTAINABLE_FLAG IN VARCHAR2
28 -- P_NETWORK_ASSET_FLAG IN VARCHAR2
29 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2 OPTIONAL
30 -- P_ATTRIBUTE1 IN VARCHAR2 OPTIONAL
31 -- P_ATTRIBUTE2 IN VARCHAR2 OPTIONAL
32 -- P_ATTRIBUTE3 IN VARCHAR2 OPTIONAL
33 -- P_ATTRIBUTE4 IN VARCHAR2 OPTIONAL
34 -- P_ATTRIBUTE5 IN VARCHAR2 OPTIONAL
35 -- P_ATTRIBUTE6 IN VARCHAR2 OPTIONAL
36 -- P_ATTRIBUTE7 IN VARCHAR2 OPTIONAL
37 -- P_ATTRIBUTE8 IN VARCHAR2 OPTIONAL
38 -- P_ATTRIBUTE9 IN VARCHAR2 OPTIONAL
39 -- P_ATTRIBUTE10 IN VARCHAR2 OPTIONAL
40 -- P_ATTRIBUTE11 IN VARCHAR2 OPTIONAL
41 -- P_ATTRIBUTE12 IN VARCHAR2 OPTIONAL
42 -- P_ATTRIBUTE13 IN VARCHAR2 OPTIONAL
43 -- P_ATTRIBUTE14 IN VARCHAR2 OPTIONAL
44 -- P_ATTRIBUTE15 IN VARCHAR2 OPTIONAL
45 -- P_LAST_UPDATE_DATE IN DATE REQUIRED
46 -- P_LAST_UPDATED_BY IN NUMBER REQUIRED
47 -- P_CREATION_DATE IN DATE REQUIRED
48 -- P_CREATED_BY IN NUMBER REQUIRED
49 -- P_LAST_UPDATE_LOGIN IN NUMBER REQUIRED
50 -- P_REQUEST_ID IN NUMBER DEFAULT NULL OPTIONAL
51 -- P_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL OPTIONAL
52 -- P_PROGRAM_ID IN NUMBER DEFAULT NULL OPTIONAL
53 -- P_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL
54 -- OUT X_OBJECT_ID OUT NUMBER
55 -- X_RETURN_STATUS OUT VARCHAR2(1)
56 -- X_MSG_COUNT OUT NUMBER
57 -- X_MSG_DATA OUT VARCHAR2(2000)
58 --
59 -- Version Current version 1.0
60 --
61 -- Notes : Note text
62 --
63 -- End of comments
64
65
66 /* Create a Row for an Asset Number in CSI_ITEM_INSTANCES */
67
68 PROCEDURE INSERT_ROW(
69 P_API_VERSION IN NUMBER,
70 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
71 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
72 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 P_INVENTORY_ITEM_ID NUMBER,
74 P_SERIAL_NUMBER VARCHAR2,
75 P_INSTANCE_NUMBER VARCHAR2,
76 P_INSTANCE_DESCRIPTION VARCHAR2,
77 P_ORGANIZATION_ID NUMBER,
78 P_CATEGORY_ID NUMBER,
79 P_PN_LOCATION_ID NUMBER,
80 P_FA_ASSET_ID NUMBER,
81 P_FA_SYNC_FLAG VARCHAR2,
82 P_ASSET_CRITICALITY_CODE VARCHAR2,
83 P_MAINTAINABLE_FLAG VARCHAR2,
84 P_NETWORK_ASSET_FLAG VARCHAR2,
85 P_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
86 P_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
87 P_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
88 P_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
89 P_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
90 P_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
91 P_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
92 P_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
93 P_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
94 P_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
95 P_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
96 P_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
97 P_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
98 P_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
99 P_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
100 P_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
101 P_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
102 P_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
103 P_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
104 P_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
105 P_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
106 P_ATTRIBUTE21 VARCHAR2 DEFAULT NULL,
107 P_ATTRIBUTE22 VARCHAR2 DEFAULT NULL,
108 P_ATTRIBUTE23 VARCHAR2 DEFAULT NULL,
109 P_ATTRIBUTE24 VARCHAR2 DEFAULT NULL,
110 P_ATTRIBUTE25 VARCHAR2 DEFAULT NULL,
111 P_ATTRIBUTE26 VARCHAR2 DEFAULT NULL,
112 P_ATTRIBUTE27 VARCHAR2 DEFAULT NULL,
113 P_ATTRIBUTE28 VARCHAR2 DEFAULT NULL,
114 P_ATTRIBUTE29 VARCHAR2 DEFAULT NULL,
115 P_ATTRIBUTE30 VARCHAR2 DEFAULT NULL,
116 P_REQUEST_ID NUMBER DEFAULT NULL,
117 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
118 P_PROGRAM_ID NUMBER DEFAULT NULL,
119 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
120 P_LAST_UPDATE_DATE DATE,
121 P_LAST_UPDATED_BY NUMBER,
122 P_CREATION_DATE DATE,
123 P_CREATED_BY NUMBER,
124 P_LAST_UPDATE_LOGIN NUMBER,
125 p_active_start_date DATE DEFAULT NULL,
126 p_active_end_date DATE DEFAULT NULL,
127 p_location NUMBER DEFAULT NULL,
128 p_linear_location_id NUMBER DEFAULT NULL,
129 p_operational_log_flag VARCHAR2 DEFAULT NULL,
130 p_checkin_status NUMBER DEFAULT NULL,
131 p_supplier_warranty_exp_date DATE DEFAULT NULL,
132 p_equipment_gen_object_id NUMBER DEFAULT NULL,
133 p_mfg_serial_number_flag VARCHAR2 DEFAULT 'N',
134 X_OBJECT_ID OUT NOCOPY NUMBER,
135 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
136 X_MSG_COUNT OUT NOCOPY NUMBER,
137 X_MSG_DATA OUT NOCOPY VARCHAR2
138 );
139
140
141 /* Update an Asset Row in CSI_ITEM_INSTANCES */
142 PROCEDURE UPDATE_ROW(
143 P_API_VERSION IN NUMBER,
144 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
145 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
146 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147 p_instance_id IN NUMBER,
148 P_INSTANCE_DESCRIPTION VARCHAR2,
149 P_CATEGORY_ID NUMBER,
150 P_PN_LOCATION_ID NUMBER,
151 P_FA_ASSET_ID NUMBER,
152 P_FA_SYNC_FLAG VARCHAR2 DEFAULT NULL,
153 P_ASSET_CRITICALITY_CODE VARCHAR2,
154 P_MAINTAINABLE_FLAG VARCHAR2,
155 P_NETWORK_ASSET_FLAG VARCHAR2,
156 P_ATTRIBUTE_CATEGORY VARCHAR2,
157 P_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
158 P_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
159 P_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
160 P_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
161 P_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
162 P_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
163 P_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
164 P_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
165 P_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
166 P_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
167 P_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
168 P_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
169 P_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
170 P_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
171 P_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
172 P_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
173 P_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
174 P_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
175 P_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
176 P_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
177 P_ATTRIBUTE21 VARCHAR2 DEFAULT NULL,
178 P_ATTRIBUTE22 VARCHAR2 DEFAULT NULL,
179 P_ATTRIBUTE23 VARCHAR2 DEFAULT NULL,
180 P_ATTRIBUTE24 VARCHAR2 DEFAULT NULL,
181 P_ATTRIBUTE25 VARCHAR2 DEFAULT NULL,
182 P_ATTRIBUTE26 VARCHAR2 DEFAULT NULL,
183 P_ATTRIBUTE27 VARCHAR2 DEFAULT NULL,
184 P_ATTRIBUTE28 VARCHAR2 DEFAULT NULL,
185 P_ATTRIBUTE29 VARCHAR2 DEFAULT NULL,
186 P_ATTRIBUTE30 VARCHAR2 DEFAULT NULL,
187 P_REQUEST_ID NUMBER DEFAULT NULL,
188 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
189 P_PROGRAM_ID NUMBER DEFAULT NULL,
190 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
191 P_LAST_UPDATE_DATE DATE,
192 P_LAST_UPDATED_BY NUMBER,
193 P_LAST_UPDATE_LOGIN NUMBER,
194 P_FROM_PUBLIC_API VARCHAR2 DEFAULT 'Y',
195 P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,
196 P_LOCATION_TYPE_CODE VARCHAR2 DEFAULT NULL,
197 P_LOCATION_ID NUMBER DEFAULT NULL,
198 p_active_end_date DATE DEFAULT NULL,
199 p_linear_location_id NUMBER DEFAULT NULL,
200 p_operational_log_flag VARCHAR2 DEFAULT NULL,
201 p_checkin_status NUMBER DEFAULT NULL,
202 p_supplier_warranty_exp_date DATE DEFAULT NULL,
203 p_equipment_gen_object_id NUMBER DEFAULT NULL
204 ,p_reactivate_asset VARCHAR2 DEFAULT 'N'
205 ,p_disassociate_fa_flag VARCHAR2 DEFAULT 'N', --5474749
206 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
207 X_MSG_COUNT OUT NOCOPY NUMBER,
208 X_MSG_DATA OUT NOCOPY VARCHAR2
209 );
210
211
212 PROCEDURE LOCK_ROW(
213
214 P_API_VERSION IN NUMBER,
215 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
216 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
217 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218 P_ROWID VARCHAR2,
219 P_INSTANCE_ID IN NUMBER,
220 P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,
221 P_INSTANCE_DESCRIPTION VARCHAR2,
222 P_CATEGORY_ID NUMBER,
223 P_PN_LOCATION_ID NUMBER,
224 P_FA_ASSET_ID NUMBER,
225 P_ASSET_CRITICALITY_CODE VARCHAR2,
226 P_MAINTAINABLE_FLAG VARCHAR2,
227 P_NETWORK_ASSET_FLAG VARCHAR2,
228 P_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
229 P_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
230 P_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
231 P_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
232 P_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
233 P_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
234 P_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
235 P_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
236 P_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
237 P_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
238 P_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
239 P_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
240 P_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
241 P_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
242 P_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
243 P_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
244 P_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
245 P_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
246 P_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
247 P_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
248 P_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
249 P_ATTRIBUTE21 VARCHAR2 DEFAULT NULL,
250 P_ATTRIBUTE22 VARCHAR2 DEFAULT NULL,
251 P_ATTRIBUTE23 VARCHAR2 DEFAULT NULL,
252 P_ATTRIBUTE24 VARCHAR2 DEFAULT NULL,
253 P_ATTRIBUTE25 VARCHAR2 DEFAULT NULL,
254 P_ATTRIBUTE26 VARCHAR2 DEFAULT NULL,
255 P_ATTRIBUTE27 VARCHAR2 DEFAULT NULL,
256 P_ATTRIBUTE28 VARCHAR2 DEFAULT NULL,
257 P_ATTRIBUTE29 VARCHAR2 DEFAULT NULL,
258 P_ATTRIBUTE30 VARCHAR2 DEFAULT NULL,
259 P_REQUEST_ID NUMBER DEFAULT NULL,
260 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
261 P_PROGRAM_ID NUMBER DEFAULT NULL,
262 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
263 P_LAST_UPDATE_DATE DATE,
264 P_LAST_UPDATED_BY NUMBER,
265 P_LAST_UPDATE_LOGIN NUMBER,
266 P_LOCATION_TYPE_CODE VARCHAR2 DEFAULT NULL,
267 P_LOCATION_ID NUMBER DEFAULT NULL,
268 p_linear_location_id NUMBER DEFAULT NULL,
272 p_equipment_gen_object_id NUMBER DEFAULT NULL,
269 p_operational_log_flag VARCHAR2 DEFAULT NULL,
270 P_checkin_status NUMBER DEFAULT NULL,
271 p_supplier_warranty_exp_date DATE DEFAULT NULL,
273 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
274 X_MSG_COUNT OUT NOCOPY NUMBER,
275 X_MSG_DATA OUT NOCOPY VARCHAR2
276 );
277
278 /* Create an Asset Number along with its maintenance Attributes */
279 PROCEDURE CREATE_ASSET(
280 P_API_VERSION IN NUMBER
281 ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
282 ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
283 ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284 ,P_INVENTORY_ITEM_ID NUMBER
285 ,P_SERIAL_NUMBER VARCHAR2
286 ,P_INSTANCE_NUMBER VARCHAR2
287 ,P_INSTANCE_DESCRIPTION VARCHAR2
288 ,P_ORGANIZATION_ID NUMBER
289 ,P_CATEGORY_ID NUMBER DEFAULT NULL
290 ,P_PN_LOCATION_ID NUMBER DEFAULT NULL
291 ,P_FA_ASSET_ID NUMBER DEFAULT NULL
292 ,P_FA_SYNC_FLAG VARCHAR2 DEFAULT NULL
293 ,P_ASSET_CRITICALITY_CODE VARCHAR2 DEFAULT NULL
294 ,P_MAINTAINABLE_FLAG VARCHAR2 DEFAULT NULL
295 ,P_NETWORK_ASSET_FLAG VARCHAR2 DEFAULT NULL
296 ,P_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL
297 ,P_ATTRIBUTE1 VARCHAR2 DEFAULT NULL
298 ,P_ATTRIBUTE2 VARCHAR2 DEFAULT NULL
299 ,P_ATTRIBUTE3 VARCHAR2 DEFAULT NULL
300 ,P_ATTRIBUTE4 VARCHAR2 DEFAULT NULL
301 ,P_ATTRIBUTE5 VARCHAR2 DEFAULT NULL
302 ,P_ATTRIBUTE6 VARCHAR2 DEFAULT NULL
303 ,P_ATTRIBUTE7 VARCHAR2 DEFAULT NULL
304 ,P_ATTRIBUTE8 VARCHAR2 DEFAULT NULL
305 ,P_ATTRIBUTE9 VARCHAR2 DEFAULT NULL
306 ,P_ATTRIBUTE10 VARCHAR2 DEFAULT NULL
307 ,P_ATTRIBUTE11 VARCHAR2 DEFAULT NULL
308 ,P_ATTRIBUTE12 VARCHAR2 DEFAULT NULL
309 ,P_ATTRIBUTE13 VARCHAR2 DEFAULT NULL
310 ,P_ATTRIBUTE14 VARCHAR2 DEFAULT NULL
311 ,P_ATTRIBUTE15 VARCHAR2 DEFAULT NULL
312 ,P_ATTRIBUTE16 VARCHAR2 DEFAULT NULL
313 ,P_ATTRIBUTE17 VARCHAR2 DEFAULT NULL
314 ,P_ATTRIBUTE18 VARCHAR2 DEFAULT NULL
315 ,P_ATTRIBUTE19 VARCHAR2 DEFAULT NULL
316 ,P_ATTRIBUTE20 VARCHAR2 DEFAULT NULL
317 ,P_ATTRIBUTE21 VARCHAR2 DEFAULT NULL
318 ,P_ATTRIBUTE22 VARCHAR2 DEFAULT NULL
319 ,P_ATTRIBUTE23 VARCHAR2 DEFAULT NULL
320 ,P_ATTRIBUTE24 VARCHAR2 DEFAULT NULL
321 ,P_ATTRIBUTE25 VARCHAR2 DEFAULT NULL
322 ,P_ATTRIBUTE26 VARCHAR2 DEFAULT NULL
323 ,P_ATTRIBUTE27 VARCHAR2 DEFAULT NULL
324 ,P_ATTRIBUTE28 VARCHAR2 DEFAULT NULL
325 ,P_ATTRIBUTE29 VARCHAR2 DEFAULT NULL
326 ,P_ATTRIBUTE30 VARCHAR2 DEFAULT NULL
327 ,P_REQUEST_ID NUMBER DEFAULT NULL
328 ,P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
329 ,P_PROGRAM_ID NUMBER DEFAULT NULL
330 ,P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
331 ,P_LAST_UPDATE_DATE DATE
332 ,P_LAST_UPDATED_BY NUMBER
333 ,P_CREATION_DATE DATE
334 ,P_CREATED_BY NUMBER
335 ,P_LAST_UPDATE_LOGIN NUMBER
336 ,p_active_start_date DATE DEFAULT NULL
337 ,p_active_end_date DATE DEFAULT NULL
338 ,p_location NUMBER DEFAULT NULL
339 ,p_linear_location_id NUMBER DEFAULT NULL
340 ,p_operational_log_flag VARCHAR2 DEFAULT NULL
341 ,p_checkin_status NUMBER DEFAULT NULL
342 ,p_supplier_warranty_exp_date DATE DEFAULT NULL
343 ,p_equipment_gen_object_id NUMBER DEFAULT NULL
344 ,p_owning_department_id NUMBER DEFAULT NULL
345 ,p_accounting_class_code VARCHAR2 DEFAULT NULL
346 ,p_area_id NUMBER DEFAULT NULL
347 ,X_OBJECT_ID OUT NOCOPY NUMBER
348 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
349 ,X_MSG_COUNT OUT NOCOPY NUMBER
350 ,X_MSG_DATA OUT NOCOPY VARCHAR2
351
352 );
353
354 /* Update an Asset Number along with its maintenance Attributes */
355 procedure update_asset(
356 P_API_VERSION IN NUMBER
357 ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
358 ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
359 ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360 ,p_instance_id IN NUMBER DEFAULT NULL
361 ,P_INSTANCE_DESCRIPTION VARCHAR2 DEFAULT NULL
362 ,P_INVENTORY_ITEM_ID NUMBER
363 ,P_SERIAL_NUMBER VARCHAR2
364 ,P_ORGANIZATION_ID NUMBER
365 ,P_CATEGORY_ID NUMBER DEFAULT NULL
366 ,P_PN_LOCATION_ID NUMBER DEFAULT NULL
367 ,P_FA_ASSET_ID NUMBER DEFAULT NULL
368 ,P_FA_SYNC_FLAG VARCHAR2 DEFAULT NULL
369 ,P_ASSET_CRITICALITY_CODE VARCHAR2 DEFAULT NULL
370 ,P_MAINTAINABLE_FLAG VARCHAR2 DEFAULT NULL
371 ,P_NETWORK_ASSET_FLAG VARCHAR2 DEFAULT NULL
372 ,P_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL
373 ,P_ATTRIBUTE1 VARCHAR2 DEFAULT NULL
377 ,P_ATTRIBUTE5 VARCHAR2 DEFAULT NULL
374 ,P_ATTRIBUTE2 VARCHAR2 DEFAULT NULL
375 ,P_ATTRIBUTE3 VARCHAR2 DEFAULT NULL
376 ,P_ATTRIBUTE4 VARCHAR2 DEFAULT NULL
378 ,P_ATTRIBUTE6 VARCHAR2 DEFAULT NULL
379 ,P_ATTRIBUTE7 VARCHAR2 DEFAULT NULL
380 ,P_ATTRIBUTE8 VARCHAR2 DEFAULT NULL
381 ,P_ATTRIBUTE9 VARCHAR2 DEFAULT NULL
382 ,P_ATTRIBUTE10 VARCHAR2 DEFAULT NULL
383 ,P_ATTRIBUTE11 VARCHAR2 DEFAULT NULL
384 ,P_ATTRIBUTE12 VARCHAR2 DEFAULT NULL
385 ,P_ATTRIBUTE13 VARCHAR2 DEFAULT NULL
386 ,P_ATTRIBUTE14 VARCHAR2 DEFAULT NULL
387 ,P_ATTRIBUTE15 VARCHAR2 DEFAULT NULL
388 ,P_ATTRIBUTE16 VARCHAR2 DEFAULT NULL
389 ,P_ATTRIBUTE17 VARCHAR2 DEFAULT NULL
390 ,P_ATTRIBUTE18 VARCHAR2 DEFAULT NULL
391 ,P_ATTRIBUTE19 VARCHAR2 DEFAULT NULL
392 ,P_ATTRIBUTE20 VARCHAR2 DEFAULT NULL
393 ,P_ATTRIBUTE21 VARCHAR2 DEFAULT NULL
394 ,P_ATTRIBUTE22 VARCHAR2 DEFAULT NULL
395 ,P_ATTRIBUTE23 VARCHAR2 DEFAULT NULL
396 ,P_ATTRIBUTE24 VARCHAR2 DEFAULT NULL
397 ,P_ATTRIBUTE25 VARCHAR2 DEFAULT NULL
398 ,P_ATTRIBUTE26 VARCHAR2 DEFAULT NULL
399 ,P_ATTRIBUTE27 VARCHAR2 DEFAULT NULL
400 ,P_ATTRIBUTE28 VARCHAR2 DEFAULT NULL
401 ,P_ATTRIBUTE29 VARCHAR2 DEFAULT NULL
402 ,P_ATTRIBUTE30 VARCHAR2 DEFAULT NULL
403 ,P_REQUEST_ID NUMBER DEFAULT NULL
404 ,P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
405 ,P_PROGRAM_ID NUMBER DEFAULT NULL
406 ,P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
407 ,P_LAST_UPDATE_DATE DATE DEFAULT NULL
408 ,P_LAST_UPDATED_BY NUMBER DEFAULT NULL
409 ,P_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL
410 ,P_FROM_PUBLIC_API VARCHAR2 DEFAULT 'Y'
411 ,P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL
412 ,P_LOCATION_TYPE_CODE VARCHAR2 DEFAULT NULL
413 ,P_LOCATION_ID NUMBER DEFAULT NULL
414 ,p_active_end_date DATE DEFAULT NULL
415 ,p_linear_location_id NUMBER DEFAULT NULL
416 ,p_operational_log_flag VARCHAR2 DEFAULT NULL
417 ,p_checkin_status NUMBER DEFAULT NULL
418 ,p_supplier_warranty_exp_date DATE DEFAULT NULL
419 ,p_equipment_gen_object_id NUMBER DEFAULT NULL
420 ,p_owning_department_id NUMBER DEFAULT NULL
421 ,p_accounting_class_code VARCHAR2 DEFAULT NULL
422 ,p_area_id NUMBER DEFAULT NULL
423 ,p_reactivate_asset VARCHAR2 DEFAULT 'N'
424 ,p_disassociate_fa_flag VARCHAR2 DEFAULT 'N' --5474749
425 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
426 ,X_MSG_COUNT OUT NOCOPY NUMBER
427 ,X_MSG_DATA OUT NOCOPY VARCHAR2
428 );
429
430 PROCEDURE SERIAL_CHECK(
431 p_api_version IN NUMBER,
432 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
433 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
435 x_return_status OUT NOCOPY VARCHAR2,
436 x_msg_count OUT NOCOPY NUMBER,
437 x_msg_data OUT NOCOPY VARCHAR2,
438 x_errorcode OUT NOCOPY NUMBER,
439 x_ser_num_in_item_id out NOCOPY boolean,
440 p_INVENTORY_ITEM_ID IN NUMBER,
441 p_SERIAL_NUMBER IN VARCHAR2,
442 p_ORGANIZATION_ID IN NUMBER);
443
444 procedure find_assets(
445 p_organization_id number
446 ,p_inventory_item_id number
447 ,p_instance_id number
448 ,p_category_id number
449 ,P_PN_LOCATION_ID NUMBER,
450 P_EAM_LOCATION_ID NUMBER,
451 P_FA_ASSET_ID NUMBER,
452 P_ASSET_CRITICALITY_CODE VARCHAR2,
453 P_WIP_ACCOUNTING_CLASS_CODE VARCHAR2,
454 P_MAINTAINABLE_FLAG VARCHAR2,
455 P_OWNING_DEPARTMENT_ID NUMBER,
456 P_PROD_ORGANIZATION_ID NUMBER,
457 P_EQUIPMENT_ITEM_ID NUMBER,
458 P_EQP_SERIAL_NUMBER VARCHAR2
459 ,p_eam_item_type NUMBER
460 ,p_asset_category_id NUMBER
461 );
462
463 END EAM_ASSET_NUMBER_PVT;