[Home] [Help]
PACKAGE: APPS.INV_EAM_ASSET_NUMBER_PVT
Source
1 PACKAGE INV_EAM_ASSET_NUMBER_PVT AUTHID CURRENT_USER as
2 /* $Header: INVEANDS.pls 115.11 2003/10/10 19:44:08 hkarmach ship $ */
3 -- Start of comments
4 -- API name : INV_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_ROWID IN OUT VARCHAR2 REQUIRED
17 -- P_INVENTORY_ITEM_ID IN NUMBER
18 -- P_SERIAL_NUMBER IN 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 -- P_EAM_LOCATION_ID IN NUMBER
25 -- P_FA_ASSET_ID IN NUMBER
26 -- P_ASSET_STATUS_CODE IN VARCHAR2
27 -- P_ASSET_CRITICALITY_CODE IN VARCHAR2
28 -- P_WIP_ACCOUNTING_CLASS_CODE IN VARCHAR2
29 -- P_MAINTAINABLE_FLAG IN VARCHAR2
30 -- P_NETWORK_ASSET_FLAG IN VARCHAR2
31 -- P_OWNING_DEPARTMENT_ID IN NUMBER
32 -- P_DEPENDENT_ASSET_FLAG IN VARCHAR2
33 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2 OPTIONAL
34 -- P_ATTRIBUTE1 IN VARCHAR2 OPTIONAL
35 -- P_ATTRIBUTE2 IN VARCHAR2 OPTIONAL
36 -- P_ATTRIBUTE3 IN VARCHAR2 OPTIONAL
37 -- P_ATTRIBUTE4 IN VARCHAR2 OPTIONAL
38 -- P_ATTRIBUTE5 IN VARCHAR2 OPTIONAL
39 -- P_ATTRIBUTE6 IN VARCHAR2 OPTIONAL
40 -- P_ATTRIBUTE7 IN VARCHAR2 OPTIONAL
41 -- P_ATTRIBUTE8 IN VARCHAR2 OPTIONAL
42 -- P_ATTRIBUTE9 IN VARCHAR2 OPTIONAL
43 -- P_ATTRIBUTE10 IN VARCHAR2 OPTIONAL
44 -- P_ATTRIBUTE11 IN VARCHAR2 OPTIONAL
45 -- P_ATTRIBUTE12 IN VARCHAR2 OPTIONAL
46 -- P_ATTRIBUTE13 IN VARCHAR2 OPTIONAL
47 -- P_ATTRIBUTE14 IN VARCHAR2 OPTIONAL
48 -- P_ATTRIBUTE15 IN VARCHAR2 OPTIONAL
49 -- P_LAST_UPDATE_DATE IN DATE REQUIRED
50 -- P_LAST_UPDATED_BY IN NUMBER REQUIRED
51 -- P_CREATION_DATE IN DATE REQUIRED
52 -- P_CREATED_BY IN NUMBER REQUIRED
53 -- P_LAST_UPDATE_LOGIN IN NUMBER REQUIRED
54 -- P_REQUEST_ID IN NUMBER DEFAULT NULL OPTIONAL
55 -- P_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL OPTIONAL
56 -- P_PROGRAM_ID IN NUMBER DEFAULT NULL OPTIONAL
57 -- P_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL
58 -- P_WIP_ENTITY_ID IN NUMBER DEFAULT NULL,
59 -- P_OPERATION_SEQ_NUM IN NUMBER DEFAULT NULL,
60 -- P_INTRAOPERATION_STEP_TYPE IN NUMBER DEFAULT NULL,
61
62 -- OUT X_OBJECT_ID OUT NUMBER
63 -- X_RETURN_STATUS OUT VARCHAR2(1)
64 -- X_MSG_COUNT OUT NUMBER
65 -- X_MSG_DATA OUT VARCHAR2(2000)
66 --
67 -- Version Current version 115.0
68 --
69 -- Notes : Note text
70 --
71 -- End of comments
72
73 PROCEDURE SERIAL_CHECK(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 x_errorcode OUT NOCOPY NUMBER,
82 x_ser_num_in_item_id out NOCOPY boolean,
83 p_INVENTORY_ITEM_ID IN NUMBER,
84 p_SERIAL_NUMBER IN VARCHAR2,
85 p_ORGANIZATION_ID IN NUMBER);
86
87 --Added the fields wip_entity_id, operation_seq_num and intraoperation_step_type as
88 -- input parameters to the procedures INSERT_ROW, UPDATE_ROW AND LOCK_ROW, as a part
89 -- of 'serial integration with wip' project
90
91 PROCEDURE INSERT_ROW(
92 P_API_VERSION IN NUMBER,
93 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
94 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
95 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 P_ROWID IN OUT NOCOPY VARCHAR2,
97 P_INVENTORY_ITEM_ID NUMBER,
98 P_SERIAL_NUMBER VARCHAR2,
99 P_INITIALIZATION_DATE DATE,
100 P_DESCRIPTIVE_TEXT VARCHAR2,
101 P_ORGANIZATION_ID NUMBER,
102 P_CATEGORY_ID NUMBER,
103 P_PROD_ORGANIZATION_ID NUMBER,
104 P_EQUIPMENT_ITEM_ID NUMBER,
105 P_EQP_SERIAL_NUMBER VARCHAR2,
106 P_PN_LOCATION_ID NUMBER,
107 P_EAM_LOCATION_ID NUMBER,
108 P_FA_ASSET_ID NUMBER,
109 P_ASSET_CRITICALITY_CODE VARCHAR2,
110 P_WIP_ACCOUNTING_CLASS_CODE VARCHAR2,
111 P_MAINTAINABLE_FLAG VARCHAR2,
112 P_NETWORK_ASSET_FLAG VARCHAR2,
113 P_OWNING_DEPARTMENT_ID NUMBER,
114 P_CURRENT_STATUS NUMBER,
115 P_ATTRIBUTE_CATEGORY VARCHAR2,
116 P_ATTRIBUTE1 VARCHAR2,
117 P_ATTRIBUTE2 VARCHAR2,
118 P_ATTRIBUTE3 VARCHAR2,
119 P_ATTRIBUTE4 VARCHAR2,
120 P_ATTRIBUTE5 VARCHAR2,
121 P_ATTRIBUTE6 VARCHAR2,
122 P_ATTRIBUTE7 VARCHAR2,
123 P_ATTRIBUTE8 VARCHAR2,
124 P_ATTRIBUTE9 VARCHAR2,
125 P_ATTRIBUTE10 VARCHAR2,
126 P_ATTRIBUTE11 VARCHAR2,
127 P_ATTRIBUTE12 VARCHAR2,
128 P_ATTRIBUTE13 VARCHAR2,
129 P_ATTRIBUTE14 VARCHAR2,
130 P_ATTRIBUTE15 VARCHAR2,
131 P_COMPLETION_DATE DATE DEFAULT NULL,
132 P_SHIP_DATE DATE DEFAULT NULL,
133 P_REVISION VARCHAR2 DEFAULT NULL,
134 P_LOT_NUMBER VARCHAR2 DEFAULT NULL,
135 P_FIXED_ASSET_TAG VARCHAR2 DEFAULT NULL,
136 P_RESERVED_ORDER_ID NUMBER DEFAULT NULL,
137 P_PARENT_ITEM_ID NUMBER DEFAULT NULL,
138 P_PARENT_SERIAL_NUMBER VARCHAR2 DEFAULT NULL,
139 P_ORIGINAL_WIP_ENTITY_ID NUMBER DEFAULT NULL,
140 P_ORIGINAL_UNIT_VENDOR_ID NUMBER DEFAULT NULL,
141 P_VENDOR_SERIAL_NUMBER VARCHAR2 DEFAULT NULL,
142 P_VENDOR_LOT_NUMBER VARCHAR2 DEFAULT NULL,
143 P_LAST_TXN_SOURCE_TYPE_ID NUMBER DEFAULT NULL,
144 P_LAST_TRANSACTION_ID NUMBER DEFAULT NULL,
145 P_LAST_RECEIPT_ISSUE_TYPE NUMBER DEFAULT NULL,
146 P_LAST_TXN_SOURCE_NAME VARCHAR2 DEFAULT NULL,
147 P_LAST_TXN_SOURCE_ID NUMBER DEFAULT NULL,
148 P_CURRENT_SUBINVENTORY_CODE VARCHAR2 DEFAULT NULL,
149 P_CURRENT_LOCATOR_ID NUMBER DEFAULT NULL,
150 P_GROUP_MARK_ID NUMBER DEFAULT NULL,
151 P_LINE_MARK_ID NUMBER DEFAULT NULL,
152 P_LOT_LINE_MARK_ID NUMBER DEFAULT NULL,
153 P_END_ITEM_UNIT_NUMBER VARCHAR2 DEFAULT NULL,
154 P_SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
155 P_ORIGINATION_DATE DATE DEFAULT NULL,
156 P_C_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
157 P_C_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
158 P_C_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
159 P_C_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
160 P_C_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
161 P_C_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
162 P_C_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
163 P_C_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
164 P_C_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
165 P_C_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
166 P_C_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
167 P_C_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
168 P_C_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
169 P_C_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
170 P_C_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
171 P_C_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
172 P_C_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
173 P_C_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
174 P_C_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
175 P_C_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
176 P_D_ATTRIBUTE1 DATE DEFAULT NULL,
177 P_D_ATTRIBUTE2 DATE DEFAULT NULL,
178 P_D_ATTRIBUTE3 DATE DEFAULT NULL,
179 P_D_ATTRIBUTE4 DATE DEFAULT NULL,
180 P_D_ATTRIBUTE5 DATE DEFAULT NULL,
181 P_D_ATTRIBUTE6 DATE DEFAULT NULL,
182 P_D_ATTRIBUTE7 DATE DEFAULT NULL,
183 P_D_ATTRIBUTE8 DATE DEFAULT NULL,
184 P_D_ATTRIBUTE9 DATE DEFAULT NULL,
185 P_D_ATTRIBUTE10 DATE DEFAULT NULL,
186 P_N_ATTRIBUTE1 NUMBER DEFAULT NULL,
187 P_N_ATTRIBUTE2 NUMBER DEFAULT NULL,
188 P_N_ATTRIBUTE3 NUMBER DEFAULT NULL,
189 P_N_ATTRIBUTE4 NUMBER DEFAULT NULL,
190 P_N_ATTRIBUTE5 NUMBER DEFAULT NULL,
191 P_N_ATTRIBUTE6 NUMBER DEFAULT NULL,
192 P_N_ATTRIBUTE7 NUMBER DEFAULT NULL,
193 P_N_ATTRIBUTE8 NUMBER DEFAULT NULL,
194 P_N_ATTRIBUTE9 NUMBER DEFAULT NULL,
195 P_N_ATTRIBUTE10 NUMBER DEFAULT NULL,
196 P_STATUS_ID NUMBER DEFAULT NULL,
197 P_TERRITORY_CODE VARCHAR2 DEFAULT NULL,
198 P_COST_GROUP_ID NUMBER DEFAULT NULL,
199 P_TIME_SINCE_NEW NUMBER DEFAULT NULL,
200 P_CYCLES_SINCE_NEW NUMBER DEFAULT NULL,
201 P_TIME_SINCE_OVERHAUL NUMBER DEFAULT NULL,
202 P_CYCLES_SINCE_OVERHAUL NUMBER DEFAULT NULL,
203 P_TIME_SINCE_REPAIR NUMBER DEFAULT NULL,
204 P_CYCLES_SINCE_REPAIR NUMBER DEFAULT NULL,
205 P_TIME_SINCE_VISIT NUMBER DEFAULT NULL,
206 P_CYCLES_SINCE_VISIT NUMBER DEFAULT NULL,
207 P_TIME_SINCE_MARK NUMBER DEFAULT NULL,
208 P_CYCLES_SINCE_MARK NUMBER DEFAULT NULL,
209 P_LPN_ID NUMBER DEFAULT NULL,
210 P_INSPECTION_STATUS NUMBER DEFAULT NULL,
211 P_PREVIOUS_STATUS NUMBER DEFAULT NULL,
212 P_LPN_TXN_ERROR_FLAG VARCHAR2 DEFAULT NULL,
213 P_REQUEST_ID NUMBER DEFAULT NULL,
214 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
215 P_PROGRAM_ID NUMBER DEFAULT NULL,
216 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
217 P_LAST_UPDATE_DATE DATE,
218 P_LAST_UPDATED_BY NUMBER,
219 P_CREATION_DATE DATE,
220 P_CREATED_BY NUMBER,
221 P_LAST_UPDATE_LOGIN NUMBER,
222 P_OWNING_ORGANIZATION_ID NUMBER DEFAULT NULL,
223 P_OWNING_ORGANIZATION_TYPE NUMBER DEFAULT NULL,
224 P_PLANNING_ORGANIZATION_ID NUMBER DEFAULT NULL,
225 P_PLANNING_ORGANIZATION_TYPE NUMBER DEFAULT NULL,
226 X_OBJECT_ID OUT NOCOPY NUMBER,
227 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
228 X_MSG_COUNT OUT NOCOPY NUMBER,
229 X_MSG_DATA OUT NOCOPY VARCHAR2,
230 P_WIP_ENTITY_ID NUMBER DEFAULT NULL,
231 P_OPERATION_SEQ_NUM NUMBER DEFAULT NULL,
232 P_INTRAOPERATION_STEP_TYPE NUMBER DEFAULT NULL);
233
234
235
236 PROCEDURE UPDATE_ROW(
237 P_API_VERSION IN NUMBER,
238 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
239 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
240 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241 P_ROWID VARCHAR2,
242 P_DESCRIPTIVE_TEXT VARCHAR2,
243 P_CATEGORY_ID NUMBER,
244 P_PROD_ORGANIZATION_ID NUMBER,
245 P_EQUIPMENT_ITEM_ID NUMBER,
246 P_EQP_SERIAL_NUMBER VARCHAR2,
247 P_PN_LOCATION_ID NUMBER,
248 P_EAM_LOCATION_ID NUMBER,
249 P_FA_ASSET_ID NUMBER,
250 P_ASSET_CRITICALITY_CODE VARCHAR2,
251 P_WIP_ACCOUNTING_CLASS_CODE VARCHAR2,
252 P_MAINTAINABLE_FLAG VARCHAR2,
253 P_NETWORK_ASSET_FLAG VARCHAR2,
254 P_OWNING_DEPARTMENT_ID NUMBER,
255 P_ATTRIBUTE_CATEGORY VARCHAR2,
256 P_ATTRIBUTE1 VARCHAR2,
257 P_ATTRIBUTE2 VARCHAR2,
258 P_ATTRIBUTE3 VARCHAR2,
259 P_ATTRIBUTE4 VARCHAR2,
260 P_ATTRIBUTE5 VARCHAR2,
261 P_ATTRIBUTE6 VARCHAR2,
262 P_ATTRIBUTE7 VARCHAR2,
263 P_ATTRIBUTE8 VARCHAR2,
264 P_ATTRIBUTE9 VARCHAR2,
265 P_ATTRIBUTE10 VARCHAR2,
266 P_ATTRIBUTE11 VARCHAR2,
267 P_ATTRIBUTE12 VARCHAR2,
268 P_ATTRIBUTE13 VARCHAR2,
269 P_ATTRIBUTE14 VARCHAR2,
270 P_ATTRIBUTE15 VARCHAR2,
271 P_CURRENT_STATUS NUMBER DEFAULT NULL,
272 P_INITIALIZATION_DATE DATE DEFAULT NULL,
273 P_COMPLETION_DATE DATE DEFAULT NULL,
274 P_SHIP_DATE DATE DEFAULT NULL,
275 P_REVISION VARCHAR2 DEFAULT NULL,
276 P_LOT_NUMBER VARCHAR2 DEFAULT NULL,
277 P_FIXED_ASSET_TAG VARCHAR2 DEFAULT NULL,
278 P_RESERVED_ORDER_ID NUMBER DEFAULT NULL,
279 P_PARENT_ITEM_ID NUMBER DEFAULT NULL,
280 P_PARENT_SERIAL_NUMBER VARCHAR2 DEFAULT NULL,
281 P_ORIGINAL_WIP_ENTITY_ID NUMBER DEFAULT NULL,
282 P_ORIGINAL_UNIT_VENDOR_ID NUMBER DEFAULT NULL,
283 P_VENDOR_SERIAL_NUMBER VARCHAR2 DEFAULT NULL,
284 P_VENDOR_LOT_NUMBER VARCHAR2 DEFAULT NULL,
285 P_LAST_TXN_SOURCE_TYPE_ID NUMBER DEFAULT NULL,
286 P_LAST_TRANSACTION_ID NUMBER DEFAULT NULL,
287 P_LAST_RECEIPT_ISSUE_TYPE NUMBER DEFAULT NULL,
288 P_LAST_TXN_SOURCE_NAME VARCHAR2 DEFAULT NULL,
289 P_LAST_TXN_SOURCE_ID NUMBER DEFAULT NULL,
290 P_CURRENT_SUBINVENTORY_CODE VARCHAR2 DEFAULT NULL,
291 P_CURRENT_LOCATOR_ID NUMBER DEFAULT NULL,
292 P_GROUP_MARK_ID NUMBER DEFAULT NULL,
293 P_LINE_MARK_ID NUMBER DEFAULT NULL,
294 P_LOT_LINE_MARK_ID NUMBER DEFAULT NULL,
295 P_END_ITEM_UNIT_NUMBER VARCHAR2 DEFAULT NULL,
296 P_SERIAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
297 P_ORIGINATION_DATE DATE DEFAULT NULL,
298 P_C_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
299 P_C_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
300 P_C_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
301 P_C_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
302 P_C_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
303 P_C_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
304 P_C_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
305 P_C_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
309 P_C_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
306 P_C_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
307 P_C_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
308 P_C_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
310 P_C_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
311 P_C_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
312 P_C_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
313 P_C_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
314 P_C_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
315 P_C_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
316 P_C_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
317 P_C_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
318 P_D_ATTRIBUTE1 DATE DEFAULT NULL,
319 P_D_ATTRIBUTE2 DATE DEFAULT NULL,
320 P_D_ATTRIBUTE3 DATE DEFAULT NULL,
321 P_D_ATTRIBUTE4 DATE DEFAULT NULL,
322 P_D_ATTRIBUTE5 DATE DEFAULT NULL,
323 P_D_ATTRIBUTE6 DATE DEFAULT NULL,
324 P_D_ATTRIBUTE7 DATE DEFAULT NULL,
325 P_D_ATTRIBUTE8 DATE DEFAULT NULL,
326 P_D_ATTRIBUTE9 DATE DEFAULT NULL,
327 P_D_ATTRIBUTE10 DATE DEFAULT NULL,
328 P_N_ATTRIBUTE1 NUMBER DEFAULT NULL,
329 P_N_ATTRIBUTE2 NUMBER DEFAULT NULL,
330 P_N_ATTRIBUTE3 NUMBER DEFAULT NULL,
331 P_N_ATTRIBUTE4 NUMBER DEFAULT NULL,
332 P_N_ATTRIBUTE5 NUMBER DEFAULT NULL,
333 P_N_ATTRIBUTE6 NUMBER DEFAULT NULL,
334 P_N_ATTRIBUTE7 NUMBER DEFAULT NULL,
335 P_N_ATTRIBUTE8 NUMBER DEFAULT NULL,
336 P_N_ATTRIBUTE9 NUMBER DEFAULT NULL,
337 P_N_ATTRIBUTE10 NUMBER DEFAULT NULL,
338 P_STATUS_ID NUMBER DEFAULT NULL,
339 P_TERRITORY_CODE VARCHAR2 DEFAULT NULL,
340 P_COST_GROUP_ID NUMBER DEFAULT NULL,
341 P_TIME_SINCE_NEW NUMBER DEFAULT NULL,
342 P_CYCLES_SINCE_NEW NUMBER DEFAULT NULL,
343 P_TIME_SINCE_OVERHAUL NUMBER DEFAULT NULL,
344 P_CYCLES_SINCE_OVERHAUL NUMBER DEFAULT NULL,
345 P_TIME_SINCE_REPAIR NUMBER DEFAULT NULL,
346 P_CYCLES_SINCE_REPAIR NUMBER DEFAULT NULL,
347 P_TIME_SINCE_VISIT NUMBER DEFAULT NULL,
348 P_CYCLES_SINCE_VISIT NUMBER DEFAULT NULL,
349 P_TIME_SINCE_MARK NUMBER DEFAULT NULL,
350 P_CYCLES_SINCE_MARK NUMBER DEFAULT NULL,
351 P_LPN_ID NUMBER DEFAULT NULL,
352 P_INSPECTION_STATUS NUMBER DEFAULT NULL,
353 P_PREVIOUS_STATUS NUMBER DEFAULT NULL,
354 P_LPN_TXN_ERROR_FLAG VARCHAR2 DEFAULT NULL,
355 P_REQUEST_ID NUMBER DEFAULT NULL,
356 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
357 P_PROGRAM_ID NUMBER DEFAULT NULL,
358 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
359 P_LAST_UPDATE_DATE DATE,
360 P_LAST_UPDATED_BY NUMBER,
361 P_LAST_UPDATE_LOGIN NUMBER,
362 P_FROM_PUBLIC_API VARCHAR2 DEFAULT 'Y',
363 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
364 X_MSG_COUNT OUT NOCOPY NUMBER,
365 X_MSG_DATA OUT NOCOPY VARCHAR2,
366 P_WIP_ENTITY_ID NUMBER DEFAULT NULL,
367 P_OPERATION_SEQ_NUM NUMBER DEFAULT NULL,
368 P_INTRAOPERATION_STEP_TYPE NUMBER DEFAULT NULL);
369
370
371 PROCEDURE LOCK_ROW(
372 P_API_VERSION IN NUMBER,
373 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
374 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
375 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
376 P_ROWID VARCHAR2,
377 P_INVENTORY_ITEM_ID NUMBER,
378 P_SERIAL_NUMBER VARCHAR2,
379 P_START_DATE_ACTIVE DATE,
380 P_DESCRIPTIVE_TEXT VARCHAR2,
381 P_ORGANIZATION_ID NUMBER,
382 P_CATEGORY_ID NUMBER,
383 P_PROD_ORGANIZATION_ID NUMBER,
384 P_EQUIPMENT_ITEM_ID NUMBER,
385 P_EQP_SERIAL_NUMBER VARCHAR2,
386 P_PN_LOCATION_ID NUMBER,
387 P_EAM_LOCATION_ID NUMBER,
388 P_FA_ASSET_ID NUMBER,
389 P_ASSET_CRITICALITY_CODE VARCHAR2,
390 P_WIP_ACCOUNTING_CLASS_CODE VARCHAR2,
391 P_MAINTAINABLE_FLAG VARCHAR2,
392 P_NETWORK_ASSET_FLAG VARCHAR2,
393 P_OWNING_DEPARTMENT_ID NUMBER,
394 P_ATTRIBUTE_CATEGORY VARCHAR2,
395 P_ATTRIBUTE1 VARCHAR2,
396 P_ATTRIBUTE2 VARCHAR2,
397 P_ATTRIBUTE3 VARCHAR2,
398 P_ATTRIBUTE4 VARCHAR2,
399 P_ATTRIBUTE5 VARCHAR2,
400 P_ATTRIBUTE6 VARCHAR2,
401 P_ATTRIBUTE7 VARCHAR2,
402 P_ATTRIBUTE8 VARCHAR2,
403 P_ATTRIBUTE9 VARCHAR2,
404 P_ATTRIBUTE10 VARCHAR2,
405 P_ATTRIBUTE11 VARCHAR2,
406 P_ATTRIBUTE12 VARCHAR2,
407 P_ATTRIBUTE13 VARCHAR2,
408 P_ATTRIBUTE14 VARCHAR2,
409 P_ATTRIBUTE15 VARCHAR2,
410 P_REQUEST_ID NUMBER DEFAULT NULL,
411 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
417 P_WIP_ENTITY_ID NUMBER DEFAULT NULL,
412 P_PROGRAM_ID NUMBER DEFAULT NULL,
413 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
414 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
415 X_MSG_COUNT OUT NOCOPY NUMBER,
416 X_MSG_DATA OUT NOCOPY VARCHAR2,
418 P_OPERATION_SEQ_NUM NUMBER DEFAULT NULL,
419 P_INTRAOPERATION_STEP_TYPE NUMBER DEFAULT NULL);
420
421
422
423 END INV_EAM_ASSET_NUMBER_PVT;