[Home] [Help]
PACKAGE BODY: APPS.CSI_ITEM_INSTANCES_PKG
Source
1 PACKAGE BODY CSI_ITEM_INSTANCES_PKG AS
2 /* $Header: csitiisb.pls 120.5 2007/10/19 23:41:04 fli ship $ */
3 -- Start of Comments
4 -- Package name : CSI_ITEM_INSTANCES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCES_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitiisb.pls';
13
14 PROCEDURE Insert_Row(
15 px_INSTANCE_ID IN OUT NOCOPY NUMBER,
16 p_INSTANCE_NUMBER VARCHAR2,
17 p_EXTERNAL_REFERENCE VARCHAR2,
18 p_INVENTORY_ITEM_ID NUMBER,
19 p_INVENTORY_REVISION VARCHAR2,
20 p_INV_MASTER_ORGANIZATION_ID NUMBER,
21 p_SERIAL_NUMBER VARCHAR2,
22 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
23 p_LOT_NUMBER VARCHAR2,
24 p_QUANTITY NUMBER,
25 p_UNIT_OF_MEASURE VARCHAR2,
26 p_ACCOUNTING_CLASS_CODE VARCHAR2,
27 p_INSTANCE_CONDITION_ID NUMBER,
28 p_INSTANCE_STATUS_ID NUMBER,
29 p_CUSTOMER_VIEW_FLAG VARCHAR2,
30 p_MERCHANT_VIEW_FLAG VARCHAR2,
31 p_SELLABLE_FLAG VARCHAR2,
32 p_SYSTEM_ID NUMBER,
33 p_INSTANCE_TYPE_CODE VARCHAR2,
34 p_ACTIVE_START_DATE DATE,
35 p_ACTIVE_END_DATE DATE,
36 p_LOCATION_TYPE_CODE VARCHAR2,
37 p_LOCATION_ID NUMBER,
38 p_INV_ORGANIZATION_ID NUMBER,
39 p_INV_SUBINVENTORY_NAME VARCHAR2,
40 p_INV_LOCATOR_ID NUMBER,
41 p_PA_PROJECT_ID NUMBER,
42 p_PA_PROJECT_TASK_ID NUMBER,
43 p_IN_TRANSIT_ORDER_LINE_ID NUMBER,
44 p_WIP_JOB_ID NUMBER,
45 p_PO_ORDER_LINE_ID NUMBER,
46 p_LAST_OE_ORDER_LINE_ID NUMBER,
47 p_LAST_OE_RMA_LINE_ID NUMBER,
48 p_LAST_PO_PO_LINE_ID NUMBER,
49 p_LAST_OE_PO_NUMBER VARCHAR2,
50 p_LAST_WIP_JOB_ID NUMBER,
51 p_LAST_PA_PROJECT_ID NUMBER,
52 p_LAST_PA_TASK_ID NUMBER,
53 p_LAST_OE_AGREEMENT_ID NUMBER,
54 p_INSTALL_DATE DATE,
55 p_MANUALLY_CREATED_FLAG VARCHAR2,
56 p_RETURN_BY_DATE DATE,
57 p_ACTUAL_RETURN_DATE DATE,
58 p_CREATION_COMPLETE_FLAG VARCHAR2,
59 p_COMPLETENESS_FLAG VARCHAR2,
60 p_CONTEXT VARCHAR2,
61 p_ATTRIBUTE1 VARCHAR2,
62 p_ATTRIBUTE2 VARCHAR2,
63 p_ATTRIBUTE3 VARCHAR2,
64 p_ATTRIBUTE4 VARCHAR2,
65 p_ATTRIBUTE5 VARCHAR2,
66 p_ATTRIBUTE6 VARCHAR2,
67 p_ATTRIBUTE7 VARCHAR2,
68 p_ATTRIBUTE8 VARCHAR2,
69 p_ATTRIBUTE9 VARCHAR2,
70 p_ATTRIBUTE10 VARCHAR2,
71 p_ATTRIBUTE11 VARCHAR2,
72 p_ATTRIBUTE12 VARCHAR2,
73 p_ATTRIBUTE13 VARCHAR2,
74 p_ATTRIBUTE14 VARCHAR2,
75 p_ATTRIBUTE15 VARCHAR2,
76 p_CREATED_BY NUMBER,
77 p_CREATION_DATE DATE,
78 p_LAST_UPDATED_BY NUMBER,
79 p_LAST_UPDATE_DATE DATE,
80 p_LAST_UPDATE_LOGIN NUMBER,
81 p_OBJECT_VERSION_NUMBER NUMBER,
82 p_LAST_TXN_LINE_DETAIL_ID NUMBER,
83 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
84 p_INSTALL_LOCATION_ID NUMBER,
85 P_INSTANCE_USAGE_CODE VARCHAR2,
86 p_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
87 p_CONFIG_INST_HDR_ID NUMBER,
88 p_CONFIG_INST_REV_NUM NUMBER,
89 p_CONFIG_INST_ITEM_ID NUMBER,
90 p_CONFIG_VALID_STATUS VARCHAR2,
91 p_INSTANCE_DESCRIPTION VARCHAR2,
92 p_request_id NUMBER,
93 p_program_application_id NUMBER,
94 p_program_id NUMBER,
95 p_program_update_date DATE,
96 --start of eam integration changes--
97 p_NETWORK_ASSET_FLAG VARCHAR2,
98 p_MAINTAINABLE_FLAG VARCHAR2,
99 p_PN_LOCATION_ID NUMBER,
100 p_ASSET_CRITICALITY_CODE VARCHAR2,
101 p_CATEGORY_ID NUMBER,
102 p_EQUIPMENT_GEN_OBJECT_ID NUMBER,
103 p_INSTANTIATION_FLAG VARCHAR2,
104 p_LINEAR_LOCATION_ID NUMBER,
105 p_OPERATIONAL_LOG_FLAG VARCHAR2,
106 p_CHECKIN_STATUS NUMBER,
107 p_SUPPLIER_WARRANTY_EXP_DATE DATE,
108 p_ATTRIBUTE16 VARCHAR2,
109 p_ATTRIBUTE17 VARCHAR2,
110 p_ATTRIBUTE18 VARCHAR2,
111 p_ATTRIBUTE19 VARCHAR2,
112 p_ATTRIBUTE20 VARCHAR2,
113 p_ATTRIBUTE21 VARCHAR2,
114 p_ATTRIBUTE22 VARCHAR2,
115 p_ATTRIBUTE23 VARCHAR2,
116 p_ATTRIBUTE24 VARCHAR2,
117 p_ATTRIBUTE25 VARCHAR2,
118 p_ATTRIBUTE26 VARCHAR2,
119 p_ATTRIBUTE27 VARCHAR2,
120 p_ATTRIBUTE28 VARCHAR2,
121 p_ATTRIBUTE29 VARCHAR2,
122 p_ATTRIBUTE30 VARCHAR2,
123 --end of eam integration changes--
124 -- Addition of columns for FA Integration
125 p_PURCHASE_UNIT_PRICE NUMBER,
126 p_PURCHASE_CURRENCY_CODE VARCHAR2,
127 p_PAYABLES_UNIT_PRICE NUMBER,
128 p_PAYABLES_CURRENCY_CODE VARCHAR2,
129 p_SALES_UNIT_PRICE NUMBER,
130 p_SALES_CURRENCY_CODE VARCHAR2,
131 p_OPERATIONAL_STATUS_CODE VARCHAR2,
132 -- End addition of columns for FA Integration
133 p_SOURCE_CODE VARCHAR2 -- Added Code for Siebel Genesis Project
134 )
135
136 IS
137 CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_S.NEXTVAL FROM sys.dual;
138 BEGIN
139 IF (px_INSTANCE_ID IS NULL) OR (px_INSTANCE_ID = FND_API.G_MISS_NUM) THEN
140 OPEN C2;
141 FETCH C2 INTO px_INSTANCE_ID;
142 CLOSE C2;
143 END IF;
144 INSERT INTO CSI_ITEM_INSTANCES(
145 INSTANCE_ID,
146 INSTANCE_NUMBER,
147 EXTERNAL_REFERENCE,
148 INVENTORY_ITEM_ID,
149 INVENTORY_REVISION,
150 INV_MASTER_ORGANIZATION_ID,
151 SERIAL_NUMBER,
152 MFG_SERIAL_NUMBER_FLAG,
153 LOT_NUMBER,
154 QUANTITY,
155 UNIT_OF_MEASURE,
156 ACCOUNTING_CLASS_CODE,
157 INSTANCE_CONDITION_ID,
158 INSTANCE_STATUS_ID,
159 CUSTOMER_VIEW_FLAG,
160 MERCHANT_VIEW_FLAG,
161 SELLABLE_FLAG,
162 SYSTEM_ID,
163 INSTANCE_TYPE_CODE,
164 ACTIVE_START_DATE,
165 ACTIVE_END_DATE,
166 LOCATION_TYPE_CODE,
167 LOCATION_ID,
168 INV_ORGANIZATION_ID,
169 INV_SUBINVENTORY_NAME,
170 INV_LOCATOR_ID,
171 PA_PROJECT_ID,
172 PA_PROJECT_TASK_ID,
173 IN_TRANSIT_ORDER_LINE_ID,
174 WIP_JOB_ID,
175 PO_ORDER_LINE_ID,
176 LAST_OE_ORDER_LINE_ID,
177 LAST_OE_RMA_LINE_ID,
178 LAST_PO_PO_LINE_ID,
179 LAST_OE_PO_NUMBER,
180 LAST_WIP_JOB_ID,
181 LAST_PA_PROJECT_ID,
182 LAST_PA_TASK_ID,
183 LAST_OE_AGREEMENT_ID,
184 INSTALL_DATE,
185 MANUALLY_CREATED_FLAG,
186 RETURN_BY_DATE,
187 ACTUAL_RETURN_DATE,
188 CREATION_COMPLETE_FLAG,
189 COMPLETENESS_FLAG,
190 CONTEXT,
191 ATTRIBUTE1,
192 ATTRIBUTE2,
193 ATTRIBUTE3,
194 ATTRIBUTE4,
195 ATTRIBUTE5,
196 ATTRIBUTE6,
197 ATTRIBUTE7,
198 ATTRIBUTE8,
199 ATTRIBUTE9,
200 ATTRIBUTE10,
201 ATTRIBUTE11,
202 ATTRIBUTE12,
203 ATTRIBUTE13,
204 ATTRIBUTE14,
205 ATTRIBUTE15,
206 CREATED_BY,
207 CREATION_DATE,
208 LAST_UPDATED_BY,
209 LAST_UPDATE_DATE,
210 LAST_UPDATE_LOGIN,
211 OBJECT_VERSION_NUMBER,
212 LAST_TXN_LINE_DETAIL_ID,
213 INSTALL_LOCATION_TYPE_CODE,
214 INSTALL_LOCATION_ID,
215 INSTANCE_USAGE_CODE,
216 last_vld_organization_id,
217 CONFIG_INST_HDR_ID ,
218 CONFIG_INST_REV_NUM,
219 CONFIG_INST_ITEM_ID,
220 CONFIG_VALID_STATUS,
221 INSTANCE_DESCRIPTION,
222 request_id ,
223 program_application_id ,
224 program_id ,
225 program_update_date,
226 --start of eam integration changes--
227 NETWORK_ASSET_FLAG,
228 MAINTAINABLE_FLAG,
229 PN_LOCATION_ID,
230 ASSET_CRITICALITY_CODE,
231 CATEGORY_ID,
232 EQUIPMENT_GEN_OBJECT_ID,
233 INSTANTIATION_FLAG,
234 LINEAR_LOCATION_ID,
235 OPERATIONAL_LOG_FLAG,
236 CHECKIN_STATUS,
237 SUPPLIER_WARRANTY_EXP_DATE,
238 ATTRIBUTE16,
239 ATTRIBUTE17,
240 ATTRIBUTE18,
241 ATTRIBUTE19,
242 ATTRIBUTE20,
243 ATTRIBUTE21,
244 ATTRIBUTE22,
245 ATTRIBUTE23,
246 ATTRIBUTE24,
247 ATTRIBUTE25,
248 ATTRIBUTE26,
249 ATTRIBUTE27,
250 ATTRIBUTE28,
251 ATTRIBUTE29,
252 ATTRIBUTE30,
253 --end of eam integration changes--
254 -- Addition of columns for FA Integration
255 PURCHASE_UNIT_PRICE,
256 PURCHASE_CURRENCY_CODE,
257 PAYABLES_UNIT_PRICE,
258 PAYABLES_CURRENCY_CODE,
259 SALES_UNIT_PRICE,
260 SALES_CURRENCY_CODE,
261 OPERATIONAL_STATUS_CODE,
262 -- End addition of columns for FA Integration
263 SOURCE_CODE -- Added Code for Siebel Genesis Project
264 )
265 VALUES (
266 px_INSTANCE_ID,
267 decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),
268 decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
269 decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270 decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271 decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272 decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273 decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274 decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275 decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276 decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277 decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278 decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279 decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280 decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281 decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282 decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283 decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284 decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285 decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286 decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287 decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288 decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289 decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290 decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291 decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292 decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293 decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294 decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295 decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296 decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297 decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298 decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299 decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300 decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301 decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302 decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303 decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304 decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305 decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306 decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307 decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308 decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309 decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310 decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311 decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333 decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334 decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335 decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336 decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337 decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338 decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339 decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340 decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341 decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342 decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343 decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
347 --start of eam integration changes--
344 decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345 decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346 decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
348 decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349 decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350 decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351 decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352 decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353 decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354 decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355 decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356 decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357 decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358 decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364 decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365 decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366 decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367 decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368 decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369 decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370 decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371 decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
372 decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
373 decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
374 --end of eam integration changes--
375 -- Addition of columns for FA Integration
376 decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
377 decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
378 decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379 decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380 decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381 decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
382 decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),
383 -- End addition of columns for FA Integration
384 decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
385 );
386 END Insert_Row;
387
388 PROCEDURE Update_Row(
389 p_INSTANCE_ID NUMBER,
390 p_INSTANCE_NUMBER VARCHAR2,
391 p_EXTERNAL_REFERENCE VARCHAR2,
392 p_INVENTORY_ITEM_ID NUMBER,
393 p_INVENTORY_REVISION VARCHAR2,
394 p_INV_MASTER_ORGANIZATION_ID NUMBER,
395 p_SERIAL_NUMBER VARCHAR2,
396 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
397 p_LOT_NUMBER VARCHAR2,
398 p_QUANTITY NUMBER,
399 p_UNIT_OF_MEASURE VARCHAR2,
400 p_ACCOUNTING_CLASS_CODE VARCHAR2,
401 p_INSTANCE_CONDITION_ID NUMBER,
402 p_INSTANCE_STATUS_ID NUMBER,
403 p_CUSTOMER_VIEW_FLAG VARCHAR2,
404 p_MERCHANT_VIEW_FLAG VARCHAR2,
405 p_SELLABLE_FLAG VARCHAR2,
406 p_SYSTEM_ID NUMBER,
407 p_INSTANCE_TYPE_CODE VARCHAR2,
408 p_ACTIVE_START_DATE DATE,
409 p_ACTIVE_END_DATE DATE,
410 P_LOCATION_TYPE_CODE VARCHAR2,
411 p_LOCATION_ID NUMBER,
412 p_INV_ORGANIZATION_ID NUMBER,
413 p_INV_SUBINVENTORY_NAME VARCHAR2,
414 p_INV_LOCATOR_ID NUMBER,
415 p_PA_PROJECT_ID NUMBER,
416 p_PA_PROJECT_TASK_ID NUMBER,
417 p_IN_TRANSIT_ORDER_LINE_ID NUMBER,
418 p_WIP_JOB_ID NUMBER,
419 p_PO_ORDER_LINE_ID NUMBER,
420 p_LAST_OE_ORDER_LINE_ID NUMBER,
421 p_LAST_OE_RMA_LINE_ID NUMBER,
422 p_LAST_PO_PO_LINE_ID NUMBER,
423 p_LAST_OE_PO_NUMBER VARCHAR2,
424 p_LAST_WIP_JOB_ID NUMBER,
425 p_LAST_PA_PROJECT_ID NUMBER,
426 p_LAST_PA_TASK_ID NUMBER,
427 p_LAST_OE_AGREEMENT_ID NUMBER,
428 p_INSTALL_DATE DATE,
429 p_MANUALLY_CREATED_FLAG VARCHAR2,
430 p_RETURN_BY_DATE DATE,
431 p_ACTUAL_RETURN_DATE DATE,
432 p_CREATION_COMPLETE_FLAG VARCHAR2,
433 p_COMPLETENESS_FLAG VARCHAR2,
434 p_CONTEXT VARCHAR2,
435 p_ATTRIBUTE1 VARCHAR2,
436 p_ATTRIBUTE2 VARCHAR2,
437 p_ATTRIBUTE3 VARCHAR2,
438 p_ATTRIBUTE4 VARCHAR2,
439 p_ATTRIBUTE5 VARCHAR2,
440 p_ATTRIBUTE6 VARCHAR2,
441 p_ATTRIBUTE7 VARCHAR2,
442 p_ATTRIBUTE8 VARCHAR2,
443 p_ATTRIBUTE9 VARCHAR2,
444 p_ATTRIBUTE10 VARCHAR2,
445 p_ATTRIBUTE11 VARCHAR2,
449 p_ATTRIBUTE15 VARCHAR2,
446 p_ATTRIBUTE12 VARCHAR2,
447 p_ATTRIBUTE13 VARCHAR2,
448 p_ATTRIBUTE14 VARCHAR2,
450 p_CREATED_BY NUMBER,
451 p_CREATION_DATE DATE,
452 p_LAST_UPDATED_BY NUMBER,
453 p_LAST_UPDATE_DATE DATE,
454 p_LAST_UPDATE_LOGIN NUMBER,
455 p_OBJECT_VERSION_NUMBER NUMBER,
456 p_LAST_TXN_LINE_DETAIL_ID NUMBER,
457 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
458 p_INSTALL_LOCATION_ID NUMBER,
459 P_INSTANCE_USAGE_CODE VARCHAR2,
460 P_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
461 p_CONFIG_INST_HDR_ID NUMBER ,
462 p_CONFIG_INST_REV_NUM NUMBER ,
463 p_CONFIG_INST_ITEM_ID NUMBER ,
464 p_CONFIG_VALID_STATUS VARCHAR2 ,
465 p_INSTANCE_DESCRIPTION VARCHAR2 ,
466 p_request_id NUMBER ,
467 p_program_application_id NUMBER ,
468 p_program_id NUMBER ,
469 p_program_update_date DATE,
470 --start of eam integration changes--
471 p_NETWORK_ASSET_FLAG VARCHAR2,
472 p_MAINTAINABLE_FLAG VARCHAR2,
473 p_PN_LOCATION_ID NUMBER,
474 p_ASSET_CRITICALITY_CODE VARCHAR2,
475 p_CATEGORY_ID NUMBER,
476 p_EQUIPMENT_GEN_OBJECT_ID NUMBER,
477 p_INSTANTIATION_FLAG VARCHAR2,
478 p_LINEAR_LOCATION_ID NUMBER,
479 p_OPERATIONAL_LOG_FLAG VARCHAR2,
480 p_CHECKIN_STATUS NUMBER,
481 p_SUPPLIER_WARRANTY_EXP_DATE DATE,
482 p_ATTRIBUTE16 VARCHAR2,
483 p_ATTRIBUTE17 VARCHAR2,
484 p_ATTRIBUTE18 VARCHAR2,
485 p_ATTRIBUTE19 VARCHAR2,
486 p_ATTRIBUTE20 VARCHAR2,
487 p_ATTRIBUTE21 VARCHAR2,
488 p_ATTRIBUTE22 VARCHAR2,
489 p_ATTRIBUTE23 VARCHAR2,
490 p_ATTRIBUTE24 VARCHAR2,
491 p_ATTRIBUTE25 VARCHAR2,
492 p_ATTRIBUTE26 VARCHAR2,
493 p_ATTRIBUTE27 VARCHAR2,
494 p_ATTRIBUTE28 VARCHAR2,
495 p_ATTRIBUTE29 VARCHAR2,
496 p_ATTRIBUTE30 VARCHAR2,
497 --end of eam integration changes--
498 -- Addition of columns for FA Integration
499 p_PURCHASE_UNIT_PRICE NUMBER,
500 p_PURCHASE_CURRENCY_CODE VARCHAR2,
501 p_PAYABLES_UNIT_PRICE NUMBER,
502 p_PAYABLES_CURRENCY_CODE VARCHAR2,
503 p_SALES_UNIT_PRICE NUMBER,
504 p_SALES_CURRENCY_CODE VARCHAR2,
505 p_OPERATIONAL_STATUS_CODE VARCHAR2,
506 -- End addition of columns for FA Integration
507 p_SOURCE_CODE VARCHAR2 -- Added Code for Siebel Genesis Project
508 )
509 IS
510 BEGIN
511
512 UPDATE CSI_ITEM_INSTANCES
513 SET
514 INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
515 EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516 INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517 INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518 INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519 SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520 MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521 LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522 QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523 UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524 ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525 INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526 INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527 CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528 MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529 SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530 SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531 INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532 ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533 ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534 LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535 LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536 INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537 INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
541 IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
538 INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539 PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540 PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
542 WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543 PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544 LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545 LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546 LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547 LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548 LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549 LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550 LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551 LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552 INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553 MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554 RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555 ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556 CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557 COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558 CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580 LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581 INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582 INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583 INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584 last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585 CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586 CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587 CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588 CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589 INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590 request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591 program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
595 NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
592 program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593 program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594 --start of eam integration changes--
596 MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597 PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598 ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599 CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600 EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601 INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602 LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603 OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604 CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605 SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611 ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612 ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613 ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614 ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615 ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616 ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617 ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618 ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
619 ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
620 ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
621 --end of eam integration changes--
622 -- Addition of columns for FA Integration
623 PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
624 PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
625 PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626 PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627 SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628 SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
629 OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),
630 -- End addition of columns for FA Integration
631 SOURCE_CODE = decode(p_SOURCE_CODE,fnd_api.g_miss_char,SOURCE_CODE,p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
632 where INSTANCE_ID = p_INSTANCE_ID;
633
634 IF (SQL%NOTFOUND) THEN
635 RAISE NO_DATA_FOUND;
636 END IF;
637 END Update_Row;
638
639 PROCEDURE Delete_Row(
640 p_INSTANCE_ID NUMBER)
641 IS
642 BEGIN
643 DELETE FROM CSI_ITEM_INSTANCES
644 WHERE INSTANCE_ID = p_INSTANCE_ID;
645 IF (SQL%NOTFOUND) THEN
646 RAISE NO_DATA_FOUND;
647 END IF;
648 END Delete_Row;
649
650 PROCEDURE Lock_Row(
651 p_INSTANCE_ID NUMBER,
652 p_INSTANCE_NUMBER VARCHAR2,
653 p_EXTERNAL_REFERENCE VARCHAR2,
654 p_INVENTORY_ITEM_ID NUMBER,
655 p_INVENTORY_REVISION VARCHAR2,
656 p_INV_MASTER_ORGANIZATION_ID NUMBER,
657 p_SERIAL_NUMBER VARCHAR2,
658 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
659 p_LOT_NUMBER VARCHAR2,
660 p_QUANTITY NUMBER,
661 p_UNIT_OF_MEASURE VARCHAR2,
662 p_ACCOUNTING_CLASS_CODE VARCHAR2,
663 p_INSTANCE_CONDITION_ID NUMBER,
664 p_INSTANCE_STATUS_ID NUMBER,
665 p_CUSTOMER_VIEW_FLAG VARCHAR2,
666 p_MERCHANT_VIEW_FLAG VARCHAR2,
667 p_SELLABLE_FLAG VARCHAR2,
668 p_SYSTEM_ID NUMBER,
669 p_INSTANCE_TYPE_CODE VARCHAR2,
670 p_ACTIVE_START_DATE DATE,
671 p_ACTIVE_END_DATE DATE,
672 p_LOCATION_TYPE_CODE VARCHAR2,
673 p_LOCATION_ID NUMBER,
674 p_INV_ORGANIZATION_ID NUMBER,
675 p_INV_SUBINVENTORY_NAME VARCHAR2,
676 p_INV_LOCATOR_ID NUMBER,
677 p_PA_PROJECT_ID NUMBER,
678 p_PA_PROJECT_TASK_ID NUMBER,
682 p_LAST_OE_ORDER_LINE_ID NUMBER,
679 p_IN_TRANSIT_ORDER_LINE_ID NUMBER,
680 p_WIP_JOB_ID NUMBER,
681 p_PO_ORDER_LINE_ID NUMBER,
683 p_LAST_OE_RMA_LINE_ID NUMBER,
684 p_LAST_PO_PO_LINE_ID NUMBER,
685 p_LAST_OE_PO_NUMBER VARCHAR2,
686 p_LAST_WIP_JOB_ID NUMBER,
687 p_LAST_PA_PROJECT_ID NUMBER,
688 p_LAST_PA_TASK_ID NUMBER,
689 p_LAST_OE_AGREEMENT_ID NUMBER,
690 p_INSTALL_DATE DATE,
691 p_MANUALLY_CREATED_FLAG VARCHAR2,
692 p_RETURN_BY_DATE DATE,
693 p_ACTUAL_RETURN_DATE DATE,
694 p_CREATION_COMPLETE_FLAG VARCHAR2,
695 p_COMPLETENESS_FLAG VARCHAR2,
696 p_CONTEXT VARCHAR2,
697 p_ATTRIBUTE1 VARCHAR2,
698 p_ATTRIBUTE2 VARCHAR2,
699 p_ATTRIBUTE3 VARCHAR2,
700 p_ATTRIBUTE4 VARCHAR2,
701 p_ATTRIBUTE5 VARCHAR2,
702 p_ATTRIBUTE6 VARCHAR2,
703 p_ATTRIBUTE7 VARCHAR2,
704 p_ATTRIBUTE8 VARCHAR2,
705 p_ATTRIBUTE9 VARCHAR2,
706 p_ATTRIBUTE10 VARCHAR2,
707 p_ATTRIBUTE11 VARCHAR2,
708 p_ATTRIBUTE12 VARCHAR2,
709 p_ATTRIBUTE13 VARCHAR2,
710 p_ATTRIBUTE14 VARCHAR2,
711 p_ATTRIBUTE15 VARCHAR2,
712 p_CREATED_BY NUMBER,
713 p_CREATION_DATE DATE,
714 p_LAST_UPDATED_BY NUMBER,
715 p_LAST_UPDATE_DATE DATE,
716 p_LAST_UPDATE_LOGIN NUMBER,
717 p_OBJECT_VERSION_NUMBER NUMBER,
718 p_LAST_TXN_LINE_DETAIL_ID NUMBER,
719 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
720 p_INSTALL_LOCATION_ID NUMBER,
721 p_INSTANCE_USAGE_CODE VARCHAR2,
722 p_CONFIG_INST_HDR_ID NUMBER,
723 p_CONFIG_INST_REV_NUM NUMBER,
724 p_CONFIG_INST_ITEM_ID NUMBER,
725 p_CONFIG_VALID_STATUS VARCHAR2,
726 p_INSTANCE_DESCRIPTION VARCHAR2,
727 --start of eam integration changes--
728 p_NETWORK_ASSET_FLAG VARCHAR2,
729 p_MAINTAINABLE_FLAG VARCHAR2,
730 p_PN_LOCATION_ID NUMBER,
731 p_ASSET_CRITICALITY_CODE VARCHAR2,
732 p_CATEGORY_ID NUMBER,
733 p_EQUIPMENT_GEN_OBJECT_ID NUMBER,
734 p_INSTANTIATION_FLAG VARCHAR2,
735 p_LINEAR_LOCATION_ID NUMBER,
736 p_OPERATIONAL_LOG_FLAG VARCHAR2,
737 p_CHECKIN_STATUS NUMBER,
738 p_SUPPLIER_WARRANTY_EXP_DATE DATE,
739 p_ATTRIBUTE16 VARCHAR2,
740 p_ATTRIBUTE17 VARCHAR2,
741 p_ATTRIBUTE18 VARCHAR2,
742 p_ATTRIBUTE19 VARCHAR2,
743 p_ATTRIBUTE20 VARCHAR2,
744 p_ATTRIBUTE21 VARCHAR2,
745 p_ATTRIBUTE22 VARCHAR2,
746 p_ATTRIBUTE23 VARCHAR2,
747 p_ATTRIBUTE24 VARCHAR2,
748 p_ATTRIBUTE25 VARCHAR2,
749 p_ATTRIBUTE26 VARCHAR2,
750 p_ATTRIBUTE27 VARCHAR2,
751 p_ATTRIBUTE28 VARCHAR2,
752 p_ATTRIBUTE29 VARCHAR2,
753 p_ATTRIBUTE30 VARCHAR2,
754 --end of eam integration changes--
755 -- Addition of columns for FA Integration
756 p_PURCHASE_UNIT_PRICE NUMBER,
757 p_PURCHASE_CURRENCY_CODE VARCHAR2,
758 p_PAYABLES_UNIT_PRICE NUMBER,
759 p_PAYABLES_CURRENCY_CODE VARCHAR2,
760 p_SALES_UNIT_PRICE NUMBER,
761 p_SALES_CURRENCY_CODE VARCHAR2,
762 p_OPERATIONAL_STATUS_CODE VARCHAR2,
763 -- End addition of columns for FA Integration
764 p_SOURCE_CODE VARCHAR2 -- Added Code for Siebel Genesis Project
765 )
766
767 IS
768 CURSOR C IS
769 SELECT *
770 FROM CSI_ITEM_INSTANCES
771 WHERE INSTANCE_ID = p_INSTANCE_ID
772 FOR UPDATE of INSTANCE_ID NOWAIT;
773 Recinfo C%ROWTYPE;
774 BEGIN
775 OPEN C;
776 FETCH C INTO Recinfo;
777 IF (C%NOTFOUND) THEN
778 CLOSE C;
779 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
780 APP_EXCEPTION.RAISE_EXCEPTION;
781 END IF;
782 CLOSE C;
783 IF (
784 ( Recinfo.INSTANCE_ID = p_INSTANCE_ID)
785 AND ( ( Recinfo.INSTANCE_NUMBER = p_INSTANCE_NUMBER)
786 OR ( ( Recinfo.INSTANCE_NUMBER IS NULL )
787 AND ( p_INSTANCE_NUMBER IS NULL )))
788 AND ( ( Recinfo.EXTERNAL_REFERENCE = p_EXTERNAL_REFERENCE)
789 OR ( ( Recinfo.EXTERNAL_REFERENCE IS NULL )
790 AND ( p_EXTERNAL_REFERENCE IS NULL )))
791 AND ( ( Recinfo.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID)
792 OR ( ( Recinfo.INVENTORY_ITEM_ID IS NULL )
793 AND ( p_INVENTORY_ITEM_ID IS NULL )))
794 AND ( ( Recinfo.INVENTORY_REVISION = p_INVENTORY_REVISION)
795 OR ( ( Recinfo.INVENTORY_REVISION IS NULL )
796 AND ( p_INVENTORY_REVISION IS NULL )))
797 AND ( ( Recinfo.INV_MASTER_ORGANIZATION_ID = p_INV_MASTER_ORGANIZATION_ID)
798 OR ( ( Recinfo.INV_MASTER_ORGANIZATION_ID IS NULL )
799 AND ( p_INV_MASTER_ORGANIZATION_ID IS NULL )))
800 AND ( ( Recinfo.SERIAL_NUMBER = p_SERIAL_NUMBER)
801 OR ( ( Recinfo.SERIAL_NUMBER IS NULL )
802 AND ( p_SERIAL_NUMBER IS NULL )))
803 AND ( ( Recinfo.MFG_SERIAL_NUMBER_FLAG = p_MFG_SERIAL_NUMBER_FLAG)
804 OR ( ( Recinfo.MFG_SERIAL_NUMBER_FLAG IS NULL )
808 AND ( p_LOT_NUMBER IS NULL )))
805 AND ( p_MFG_SERIAL_NUMBER_FLAG IS NULL )))
806 AND ( ( Recinfo.LOT_NUMBER = p_LOT_NUMBER)
807 OR ( ( Recinfo.LOT_NUMBER IS NULL )
809 AND ( ( Recinfo.QUANTITY = p_QUANTITY)
810 OR ( ( Recinfo.QUANTITY IS NULL )
811 AND ( p_QUANTITY IS NULL )))
812 AND ( ( Recinfo.UNIT_OF_MEASURE = p_UNIT_OF_MEASURE)
813 OR ( ( Recinfo.UNIT_OF_MEASURE IS NULL )
814 AND ( p_UNIT_OF_MEASURE IS NULL )))
815 AND ( ( Recinfo.ACCOUNTING_CLASS_CODE = p_ACCOUNTING_CLASS_CODE)
816 OR ( ( Recinfo.ACCOUNTING_CLASS_CODE IS NULL )
817 AND ( p_ACCOUNTING_CLASS_CODE IS NULL )))
818 AND ( ( Recinfo.INSTANCE_CONDITION_ID = p_INSTANCE_CONDITION_ID)
819 OR ( ( Recinfo.INSTANCE_CONDITION_ID IS NULL )
820 AND ( p_INSTANCE_CONDITION_ID IS NULL )))
821 AND ( ( Recinfo.INSTANCE_STATUS_ID = p_INSTANCE_STATUS_ID)
822 OR ( ( Recinfo.INSTANCE_STATUS_ID IS NULL )
823 AND ( p_INSTANCE_STATUS_ID IS NULL )))
824 AND ( ( Recinfo.CUSTOMER_VIEW_FLAG = p_CUSTOMER_VIEW_FLAG)
825 OR ( ( Recinfo.CUSTOMER_VIEW_FLAG IS NULL )
826 AND ( p_CUSTOMER_VIEW_FLAG IS NULL )))
827 AND ( ( Recinfo.MERCHANT_VIEW_FLAG = p_MERCHANT_VIEW_FLAG)
828 OR ( ( Recinfo.MERCHANT_VIEW_FLAG IS NULL )
829 AND ( p_MERCHANT_VIEW_FLAG IS NULL )))
830 AND ( ( Recinfo.SELLABLE_FLAG = p_SELLABLE_FLAG)
831 OR ( ( Recinfo.SELLABLE_FLAG IS NULL )
832 AND ( p_SELLABLE_FLAG IS NULL )))
833 AND ( ( Recinfo.SYSTEM_ID = p_SYSTEM_ID)
834 OR ( ( Recinfo.SYSTEM_ID IS NULL )
835 AND ( p_SYSTEM_ID IS NULL )))
836 AND ( ( Recinfo.INSTANCE_TYPE_CODE = p_INSTANCE_TYPE_CODE)
837 OR ( ( Recinfo.INSTANCE_TYPE_CODE IS NULL )
838 AND ( p_INSTANCE_TYPE_CODE IS NULL )))
839 AND ( ( Recinfo.ACTIVE_START_DATE = p_ACTIVE_START_DATE)
840 OR ( ( Recinfo.ACTIVE_START_DATE IS NULL )
841 AND ( p_ACTIVE_START_DATE IS NULL )))
842 AND ( ( Recinfo.ACTIVE_END_DATE = p_ACTIVE_END_DATE)
843 OR ( ( Recinfo.ACTIVE_END_DATE IS NULL )
844 AND ( p_ACTIVE_END_DATE IS NULL )))
845 AND ( ( Recinfo.LOCATION_TYPE_CODE = p_LOCATION_TYPE_CODE)
846 OR ( ( Recinfo.LOCATION_TYPE_CODE IS NULL )
847 AND ( p_LOCATION_TYPE_CODE IS NULL )))
848 AND ( ( Recinfo.LOCATION_ID = p_LOCATION_ID)
849 OR ( ( Recinfo.LOCATION_ID IS NULL )
850 AND ( p_LOCATION_ID IS NULL )))
851 AND ( ( Recinfo.INV_ORGANIZATION_ID = p_INV_ORGANIZATION_ID)
852 OR ( ( Recinfo.INV_ORGANIZATION_ID IS NULL )
853 AND ( p_INV_ORGANIZATION_ID IS NULL )))
854 AND ( ( Recinfo.INV_SUBINVENTORY_NAME = p_INV_SUBINVENTORY_NAME)
855 OR ( ( Recinfo.INV_SUBINVENTORY_NAME IS NULL )
856 AND ( p_INV_SUBINVENTORY_NAME IS NULL )))
857 AND ( ( Recinfo.INV_LOCATOR_ID = p_INV_LOCATOR_ID)
858 OR ( ( Recinfo.INV_LOCATOR_ID IS NULL )
859 AND ( p_INV_LOCATOR_ID IS NULL )))
860 AND ( ( Recinfo.PA_PROJECT_ID = p_PA_PROJECT_ID)
861 OR ( ( Recinfo.PA_PROJECT_ID IS NULL )
862 AND ( p_PA_PROJECT_ID IS NULL )))
863 AND ( ( Recinfo.PA_PROJECT_TASK_ID = p_PA_PROJECT_TASK_ID)
864 OR ( ( Recinfo.PA_PROJECT_TASK_ID IS NULL )
865 AND ( p_PA_PROJECT_TASK_ID IS NULL )))
866 AND ( ( Recinfo.IN_TRANSIT_ORDER_LINE_ID = p_IN_TRANSIT_ORDER_LINE_ID)
867 OR ( ( Recinfo.IN_TRANSIT_ORDER_LINE_ID IS NULL )
868 AND ( p_IN_TRANSIT_ORDER_LINE_ID IS NULL )))
869 AND ( ( Recinfo.WIP_JOB_ID = p_WIP_JOB_ID)
870 OR ( ( Recinfo.WIP_JOB_ID IS NULL )
871 AND ( p_WIP_JOB_ID IS NULL )))
872 AND ( ( Recinfo.PO_ORDER_LINE_ID = p_PO_ORDER_LINE_ID)
873 OR ( ( Recinfo.PO_ORDER_LINE_ID IS NULL )
874 AND ( p_PO_ORDER_LINE_ID IS NULL )))
875 AND ( ( Recinfo.LAST_OE_ORDER_LINE_ID = p_LAST_OE_ORDER_LINE_ID)
876 OR ( ( Recinfo.LAST_OE_ORDER_LINE_ID IS NULL )
877 AND ( p_LAST_OE_ORDER_LINE_ID IS NULL )))
878 AND ( ( Recinfo.LAST_OE_RMA_LINE_ID = p_LAST_OE_RMA_LINE_ID)
879 OR ( ( Recinfo.LAST_OE_RMA_LINE_ID IS NULL )
880 AND ( p_LAST_OE_RMA_LINE_ID IS NULL )))
881 AND ( ( Recinfo.LAST_PO_PO_LINE_ID = p_LAST_PO_PO_LINE_ID)
882 OR ( ( Recinfo.LAST_PO_PO_LINE_ID IS NULL )
883 AND ( p_LAST_PO_PO_LINE_ID IS NULL )))
884 AND ( ( Recinfo.LAST_OE_PO_NUMBER = p_LAST_OE_PO_NUMBER)
885 OR ( ( Recinfo.LAST_OE_PO_NUMBER IS NULL )
886 AND ( p_LAST_OE_PO_NUMBER IS NULL )))
887 AND ( ( Recinfo.LAST_WIP_JOB_ID = p_LAST_WIP_JOB_ID)
888 OR ( ( Recinfo.LAST_WIP_JOB_ID IS NULL )
889 AND ( p_LAST_WIP_JOB_ID IS NULL )))
890 AND ( ( Recinfo.LAST_PA_PROJECT_ID = p_LAST_PA_PROJECT_ID)
891 OR ( ( Recinfo.LAST_PA_PROJECT_ID IS NULL )
892 AND ( p_LAST_PA_PROJECT_ID IS NULL )))
893 AND ( ( Recinfo.LAST_PA_TASK_ID = p_LAST_PA_TASK_ID)
894 OR ( ( Recinfo.LAST_PA_TASK_ID IS NULL )
895 AND ( p_LAST_PA_TASK_ID IS NULL )))
896 AND ( ( Recinfo.LAST_OE_AGREEMENT_ID = p_LAST_OE_AGREEMENT_ID)
897 OR ( ( Recinfo.LAST_OE_AGREEMENT_ID IS NULL )
898 AND ( p_LAST_OE_AGREEMENT_ID IS NULL )))
899 AND ( ( Recinfo.INSTALL_DATE = p_INSTALL_DATE)
900 OR ( ( Recinfo.INSTALL_DATE IS NULL )
901 AND ( p_INSTALL_DATE IS NULL )))
902 AND ( ( Recinfo.MANUALLY_CREATED_FLAG = p_MANUALLY_CREATED_FLAG)
906 OR ( ( Recinfo.RETURN_BY_DATE IS NULL )
903 OR ( ( Recinfo.MANUALLY_CREATED_FLAG IS NULL )
904 AND ( p_MANUALLY_CREATED_FLAG IS NULL )))
905 AND ( ( Recinfo.RETURN_BY_DATE = p_RETURN_BY_DATE)
907 AND ( p_RETURN_BY_DATE IS NULL )))
908 AND ( ( Recinfo.ACTUAL_RETURN_DATE = p_ACTUAL_RETURN_DATE)
909 OR ( ( Recinfo.ACTUAL_RETURN_DATE IS NULL )
910 AND ( p_ACTUAL_RETURN_DATE IS NULL )))
911 AND ( ( Recinfo.CREATION_COMPLETE_FLAG = p_CREATION_COMPLETE_FLAG)
912 OR ( ( Recinfo.CREATION_COMPLETE_FLAG IS NULL )
913 AND ( p_CREATION_COMPLETE_FLAG IS NULL )))
914 AND ( ( Recinfo.COMPLETENESS_FLAG = p_COMPLETENESS_FLAG)
915 OR ( ( Recinfo.COMPLETENESS_FLAG IS NULL )
916 AND ( p_COMPLETENESS_FLAG IS NULL )))
917 AND ( ( Recinfo.CONTEXT = p_CONTEXT)
918 OR ( ( Recinfo.CONTEXT IS NULL )
919 AND ( p_CONTEXT IS NULL )))
920 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
921 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
922 AND ( p_ATTRIBUTE1 IS NULL )))
923 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
924 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
925 AND ( p_ATTRIBUTE2 IS NULL )))
926 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
927 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
928 AND ( p_ATTRIBUTE3 IS NULL )))
929 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
930 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
931 AND ( p_ATTRIBUTE4 IS NULL )))
932 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
933 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
934 AND ( p_ATTRIBUTE5 IS NULL )))
935 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
936 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
937 AND ( p_ATTRIBUTE6 IS NULL )))
938 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
939 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
940 AND ( p_ATTRIBUTE7 IS NULL )))
941 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
942 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
943 AND ( p_ATTRIBUTE8 IS NULL )))
944 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
945 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
946 AND ( p_ATTRIBUTE9 IS NULL )))
947 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
948 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
949 AND ( p_ATTRIBUTE10 IS NULL )))
950 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
951 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
952 AND ( p_ATTRIBUTE11 IS NULL )))
953 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
954 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
955 AND ( p_ATTRIBUTE12 IS NULL )))
956 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
957 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
958 AND ( p_ATTRIBUTE13 IS NULL )))
959 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
960 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
961 AND ( p_ATTRIBUTE14 IS NULL )))
962 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
963 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
964 AND ( p_ATTRIBUTE15 IS NULL )))
965 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
966 OR ( ( Recinfo.CREATED_BY IS NULL )
967 AND ( p_CREATED_BY IS NULL )))
968 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
969 OR ( ( Recinfo.CREATION_DATE IS NULL )
970 AND ( p_CREATION_DATE IS NULL )))
971 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
972 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
973 AND ( p_LAST_UPDATED_BY IS NULL )))
974 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
975 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
976 AND ( p_LAST_UPDATE_DATE IS NULL )))
977 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
978 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
979 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
980 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
981 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
982 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
983 AND ( ( Recinfo.LAST_TXN_LINE_DETAIL_ID = p_LAST_TXN_LINE_DETAIL_ID)
984 OR ( ( Recinfo.LAST_TXN_LINE_DETAIL_ID IS NULL )
985 AND ( p_LAST_TXN_LINE_DETAIL_ID IS NULL )))
986 AND ( ( Recinfo.INSTALL_LOCATION_TYPE_CODE = p_INSTALL_LOCATION_TYPE_CODE)
987 OR ( ( Recinfo.INSTALL_LOCATION_TYPE_CODE IS NULL )
988 AND ( p_INSTALL_LOCATION_TYPE_CODE IS NULL )))
989 AND ( ( Recinfo.INSTALL_LOCATION_ID = p_INSTALL_LOCATION_ID)
990 OR ( ( Recinfo.INSTALL_LOCATION_ID IS NULL )
991 AND ( p_INSTALL_LOCATION_ID IS NULL )))
992 AND ( ( Recinfo.INSTANCE_USAGE_CODE = p_INSTANCE_USAGE_CODE)
993 OR ( ( Recinfo.INSTANCE_USAGE_CODE IS NULL )
994 AND ( p_INSTANCE_USAGE_CODE IS NULL )))
995 AND ( ( Recinfo.CONFIG_INST_HDR_ID = p_CONFIG_INST_HDR_ID)
996 OR ( ( Recinfo.CONFIG_INST_HDR_ID IS NULL )
997 AND ( p_CONFIG_INST_HDR_ID IS NULL )))
998 AND ( ( Recinfo.CONFIG_INST_REV_NUM = p_CONFIG_INST_REV_NUM)
999 OR ( ( Recinfo.CONFIG_INST_REV_NUM IS NULL )
1000 AND ( p_CONFIG_INST_REV_NUM IS NULL )))
1001 AND ( ( Recinfo.CONFIG_INST_ITEM_ID = p_CONFIG_INST_ITEM_ID)
1002 OR ( ( Recinfo.CONFIG_INST_ITEM_ID IS NULL )
1003 AND ( p_CONFIG_INST_ITEM_ID IS NULL )))
1007 AND ( ( Recinfo.INSTANCE_DESCRIPTION = p_INSTANCE_DESCRIPTION)
1004 AND ( ( Recinfo.CONFIG_VALID_STATUS = p_CONFIG_VALID_STATUS)
1005 OR ( ( Recinfo.CONFIG_VALID_STATUS IS NULL )
1006 AND ( p_CONFIG_VALID_STATUS IS NULL )))
1008 OR ( ( Recinfo.INSTANCE_DESCRIPTION IS NULL )
1009 AND ( p_INSTANCE_DESCRIPTION IS NULL )))
1010 --start of eam integration changes--
1011 AND ( ( Recinfo.NETWORK_ASSET_FLAG = p_NETWORK_ASSET_FLAG)
1012 OR ( ( Recinfo.NETWORK_ASSET_FLAG IS NULL )
1013 AND ( p_NETWORK_ASSET_FLAG IS NULL )))
1014 AND ( ( Recinfo.MAINTAINABLE_FLAG = p_MAINTAINABLE_FLAG)
1015 OR ( ( Recinfo.MAINTAINABLE_FLAG IS NULL )
1016 AND ( p_MAINTAINABLE_FLAG IS NULL )))
1017 AND ( ( Recinfo.PN_LOCATION_ID = p_PN_LOCATION_ID)
1018 OR ( ( Recinfo.PN_LOCATION_ID IS NULL )
1019 AND ( p_PN_LOCATION_ID IS NULL )))
1020 AND ( ( Recinfo.ASSET_CRITICALITY_CODE = p_ASSET_CRITICALITY_CODE)
1021 OR ( ( Recinfo.ASSET_CRITICALITY_CODE IS NULL )
1022 AND ( p_ASSET_CRITICALITY_CODE IS NULL )))
1023 AND ( ( Recinfo.CATEGORY_ID = p_CATEGORY_ID)
1024 OR ( ( Recinfo.CATEGORY_ID IS NULL )
1025 AND ( p_CATEGORY_ID IS NULL )))
1026 AND ( ( Recinfo.EQUIPMENT_GEN_OBJECT_ID = p_EQUIPMENT_GEN_OBJECT_ID)
1027 OR ( ( Recinfo.EQUIPMENT_GEN_OBJECT_ID IS NULL )
1028 AND ( p_EQUIPMENT_GEN_OBJECT_ID IS NULL )))
1029 AND ( ( Recinfo.INSTANTIATION_FLAG = p_INSTANTIATION_FLAG)
1030 OR ( ( Recinfo.INSTANTIATION_FLAG IS NULL )
1031 AND ( p_INSTANTIATION_FLAG IS NULL )))
1032 AND ( ( Recinfo.LINEAR_LOCATION_ID = p_LINEAR_LOCATION_ID)
1033 OR ( ( Recinfo.LINEAR_LOCATION_ID IS NULL )
1034 AND ( p_LINEAR_LOCATION_ID IS NULL )))
1035 AND ( ( Recinfo.OPERATIONAL_LOG_FLAG = p_OPERATIONAL_LOG_FLAG)
1036 OR ( ( Recinfo.OPERATIONAL_LOG_FLAG IS NULL )
1037 AND ( p_OPERATIONAL_LOG_FLAG IS NULL )))
1038 AND ( ( Recinfo.CHECKIN_STATUS = p_CHECKIN_STATUS)
1039 OR ( ( Recinfo.CHECKIN_STATUS IS NULL )
1040 AND ( p_CHECKIN_STATUS IS NULL )))
1041 AND ( ( Recinfo.SUPPLIER_WARRANTY_EXP_DATE = p_SUPPLIER_WARRANTY_EXP_DATE)
1042 OR ( ( Recinfo.SUPPLIER_WARRANTY_EXP_DATE IS NULL )
1043 AND ( p_SUPPLIER_WARRANTY_EXP_DATE IS NULL )))
1044 AND ( ( Recinfo.ATTRIBUTE16 = p_ATTRIBUTE16)
1045 OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
1046 AND ( p_ATTRIBUTE16 IS NULL )))
1047 AND ( ( Recinfo.ATTRIBUTE17 = p_ATTRIBUTE17)
1048 OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
1049 AND ( p_ATTRIBUTE17 IS NULL )))
1050 AND ( ( Recinfo.ATTRIBUTE18 = p_ATTRIBUTE18)
1051 OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
1052 AND ( p_ATTRIBUTE18 IS NULL )))
1053 AND ( ( Recinfo.ATTRIBUTE19 = p_ATTRIBUTE19)
1054 OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
1055 AND ( p_ATTRIBUTE19 IS NULL )))
1056 AND ( ( Recinfo.ATTRIBUTE20 = p_ATTRIBUTE20)
1057 OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
1058 AND ( p_ATTRIBUTE20 IS NULL )))
1059 AND ( ( Recinfo.ATTRIBUTE21 = p_ATTRIBUTE21)
1060 OR ( ( Recinfo.ATTRIBUTE21 IS NULL )
1061 AND ( p_ATTRIBUTE21 IS NULL )))
1062 AND ( ( Recinfo.ATTRIBUTE22 = p_ATTRIBUTE22)
1063 OR ( ( Recinfo.ATTRIBUTE22 IS NULL )
1064 AND ( p_ATTRIBUTE22 IS NULL )))
1065 AND ( ( Recinfo.ATTRIBUTE23 = p_ATTRIBUTE23)
1066 OR ( ( Recinfo.ATTRIBUTE23 IS NULL )
1067 AND ( p_ATTRIBUTE23 IS NULL )))
1068 AND ( ( Recinfo.ATTRIBUTE24 = p_ATTRIBUTE24)
1069 OR ( ( Recinfo.ATTRIBUTE24 IS NULL )
1070 AND ( p_ATTRIBUTE24 IS NULL )))
1071 AND ( ( Recinfo.ATTRIBUTE25 = p_ATTRIBUTE25)
1072 OR ( ( Recinfo.ATTRIBUTE25 IS NULL )
1073 AND ( p_ATTRIBUTE25 IS NULL )))
1074 AND ( ( Recinfo.ATTRIBUTE26 = p_ATTRIBUTE26)
1075 OR ( ( Recinfo.ATTRIBUTE26 IS NULL )
1076 AND ( p_ATTRIBUTE26 IS NULL )))
1077 AND ( ( Recinfo.ATTRIBUTE27 = p_ATTRIBUTE27)
1078 OR ( ( Recinfo.ATTRIBUTE27 IS NULL )
1079 AND ( p_ATTRIBUTE27 IS NULL )))
1080 AND ( ( Recinfo.ATTRIBUTE28 = p_ATTRIBUTE28)
1081 OR ( ( Recinfo.ATTRIBUTE28 IS NULL )
1082 AND ( p_ATTRIBUTE28 IS NULL )))
1083 AND ( ( Recinfo.ATTRIBUTE29 = p_ATTRIBUTE29)
1084 OR ( ( Recinfo.ATTRIBUTE29 IS NULL )
1085 AND ( p_ATTRIBUTE29 IS NULL )))
1086 AND ( ( Recinfo.ATTRIBUTE30 = p_ATTRIBUTE30)
1087 OR ( ( Recinfo.ATTRIBUTE30 IS NULL )
1088 AND ( p_ATTRIBUTE30 IS NULL )))
1089 --end of eam integration changes--
1090 -- Addition of columns for FA Integration
1091 AND ( ( Recinfo.PURCHASE_UNIT_PRICE = p_PURCHASE_UNIT_PRICE)
1092 OR ( ( Recinfo.PURCHASE_UNIT_PRICE IS NULL )
1093 AND ( p_PURCHASE_UNIT_PRICE IS NULL )))
1094 AND ( ( Recinfo.PURCHASE_CURRENCY_CODE = p_PURCHASE_CURRENCY_CODE)
1095 OR ( ( Recinfo.PURCHASE_CURRENCY_CODE IS NULL )
1096 AND ( p_PURCHASE_CURRENCY_CODE IS NULL )))
1097 AND ( ( Recinfo.PAYABLES_UNIT_PRICE = p_PAYABLES_UNIT_PRICE)
1098 OR ( ( Recinfo.PAYABLES_UNIT_PRICE IS NULL )
1099 AND ( p_PAYABLES_UNIT_PRICE IS NULL )))
1100 AND ( ( Recinfo.PAYABLES_CURRENCY_CODE = p_PAYABLES_CURRENCY_CODE)
1101 OR ( ( Recinfo.PAYABLES_CURRENCY_CODE IS NULL )
1102 AND ( p_PAYABLES_CURRENCY_CODE IS NULL )))
1103 AND ( ( Recinfo.SALES_UNIT_PRICE = p_SALES_UNIT_PRICE)
1104 OR ( ( Recinfo.SALES_UNIT_PRICE IS NULL )
1108 AND ( p_SALES_CURRENCY_CODE IS NULL )))
1105 AND ( p_SALES_UNIT_PRICE IS NULL )))
1106 AND ( ( Recinfo.SALES_CURRENCY_CODE = p_SALES_CURRENCY_CODE)
1107 OR ( ( Recinfo.SALES_CURRENCY_CODE IS NULL )
1109 AND ( ( Recinfo.OPERATIONAL_STATUS_CODE = p_OPERATIONAL_STATUS_CODE)
1110 OR ( ( Recinfo.OPERATIONAL_STATUS_CODE IS NULL )
1111 AND ( p_OPERATIONAL_STATUS_CODE IS NULL )))
1112 -- End addition of columns for FA Integration
1113 -- Begin Add Code for Siebel Genesis Project
1114 AND ( ( Recinfo.SOURCE_CODE = p_SOURCE_CODE)
1115 OR ( ( Recinfo.SOURCE_CODE IS NULL )
1116 AND ( p_SOURCE_CODE IS NULL )))
1117 -- End Add Code for Siebel Genesis Project
1118 ) THEN
1119 RETURN;
1120 ELSE
1121 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1122 APP_EXCEPTION.RAISE_EXCEPTION;
1123 END IF;
1124 END Lock_Row;
1125
1126 END CSI_ITEM_INSTANCES_PKG;