[Home] [Help]
PACKAGE BODY: APPS.CSI_ITEM_INSTANCES_H_PKG
Source
1 PACKAGE BODY CSI_ITEM_INSTANCES_H_PKG AS
2 /* $Header: csitiihb.pls 120.5 2007/10/19 23:50:11 fli ship $ */
3 -- Start of Comments
4 -- Package name : CSI_ITEM_INSTANCES_H_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCES_H_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitihsb.pls';
13
14 PROCEDURE Insert_Row(
15 px_INSTANCE_HISTORY_ID IN OUT NOCOPY NUMBER,
16 p_INSTANCE_ID NUMBER,
17 p_TRANSACTION_ID NUMBER,
18 p_OLD_INSTANCE_NUMBER VARCHAR2,
19 p_NEW_INSTANCE_NUMBER VARCHAR2,
20 p_OLD_EXTERNAL_REFERENCE VARCHAR2,
21 p_NEW_EXTERNAL_REFERENCE VARCHAR2,
22 p_OLD_INVENTORY_ITEM_ID NUMBER,
23 p_NEW_INVENTORY_ITEM_ID NUMBER,
24 p_OLD_INVENTORY_REVISION VARCHAR2,
25 p_NEW_INVENTORY_REVISION VARCHAR2,
26 p_OLD_INV_MASTER_ORGZN_ID NUMBER,
27 p_NEW_INV_MASTER_ORGZN_ID NUMBER,
28 p_OLD_SERIAL_NUMBER VARCHAR2,
29 p_NEW_SERIAL_NUMBER VARCHAR2 ,
30 p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
31 p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
32 p_OLD_LOT_NUMBER VARCHAR2,
33 p_NEW_LOT_NUMBER VARCHAR2,
34 p_OLD_QUANTITY NUMBER,
35 p_NEW_QUANTITY NUMBER,
36 p_OLD_UNIT_OF_MEASURE VARCHAR2,
37 p_NEW_UNIT_OF_MEASURE VARCHAR2,
38 p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
39 p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
40 p_OLD_INSTANCE_CONDITION_ID NUMBER,
41 p_NEW_INSTANCE_CONDITION_ID NUMBER,
42 p_OLD_INSTANCE_STATUS_ID NUMBER,
43 p_NEW_INSTANCE_STATUS_ID NUMBER,
44 p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
45 p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
46 p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
47 p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
48 p_OLD_SELLABLE_FLAG VARCHAR2,
49 p_NEW_SELLABLE_FLAG VARCHAR2,
50 p_OLD_SYSTEM_ID NUMBER,
51 p_NEW_SYSTEM_ID NUMBER,
52 p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
53 p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
54 p_OLD_ACTIVE_START_DATE DATE,
55 p_NEW_ACTIVE_START_DATE DATE,
56 p_OLD_ACTIVE_END_DATE DATE,
57 p_NEW_ACTIVE_END_DATE DATE,
58 p_OLD_LOCATION_TYPE_CODE VARCHAR2,
59 p_NEW_LOCATION_TYPE_CODE VARCHAR2,
60 p_OLD_LOCATION_ID NUMBER,
61 p_NEW_LOCATION_ID NUMBER,
62 p_OLD_INV_ORGANIZATION_ID NUMBER,
63 p_NEW_INV_ORGANIZATION_ID NUMBER,
64 p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
65 p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
66 p_OLD_INV_LOCATOR_ID NUMBER,
67 p_NEW_INV_LOCATOR_ID NUMBER,
68 p_OLD_PA_PROJECT_ID NUMBER,
69 p_NEW_PA_PROJECT_ID NUMBER,
70 p_OLD_PA_PROJECT_TASK_ID NUMBER,
71 p_NEW_PA_PROJECT_TASK_ID NUMBER,
72 p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
73 p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
74 p_OLD_WIP_JOB_ID NUMBER,
75 p_NEW_WIP_JOB_ID NUMBER,
76 p_OLD_PO_ORDER_LINE_ID NUMBER,
77 p_NEW_PO_ORDER_LINE_ID NUMBER,
78 p_OLD_COMPLETENESS_FLAG VARCHAR2,
79 p_NEW_COMPLETENESS_FLAG VARCHAR2,
80 p_FULL_DUMP_FLAG VARCHAR2,
81 p_OLD_CONTEXT VARCHAR2,
82 p_NEW_CONTEXT VARCHAR2,
83 p_OLD_ATTRIBUTE1 VARCHAR2,
84 p_NEW_ATTRIBUTE1 VARCHAR2,
85 p_OLD_ATTRIBUTE2 VARCHAR2,
86 p_NEW_ATTRIBUTE2 VARCHAR2,
87 p_OLD_ATTRIBUTE3 VARCHAR2,
88 p_NEW_ATTRIBUTE3 VARCHAR2,
89 p_OLD_ATTRIBUTE4 VARCHAR2,
90 p_NEW_ATTRIBUTE4 VARCHAR2,
91 p_OLD_ATTRIBUTE5 VARCHAR2,
92 p_NEW_ATTRIBUTE5 VARCHAR2,
93 p_OLD_ATTRIBUTE6 VARCHAR2,
94 p_NEW_ATTRIBUTE6 VARCHAR2,
95 p_OLD_ATTRIBUTE7 VARCHAR2,
96 p_NEW_ATTRIBUTE7 VARCHAR2,
97 p_OLD_ATTRIBUTE8 VARCHAR2,
98 p_NEW_ATTRIBUTE8 VARCHAR2,
99 p_OLD_ATTRIBUTE9 VARCHAR2,
100 p_NEW_ATTRIBUTE9 VARCHAR2,
101 p_OLD_ATTRIBUTE10 VARCHAR2,
102 p_NEW_ATTRIBUTE10 VARCHAR2,
103 p_OLD_ATTRIBUTE11 VARCHAR2,
104 p_NEW_ATTRIBUTE11 VARCHAR2,
105 p_OLD_ATTRIBUTE12 VARCHAR2,
106 p_NEW_ATTRIBUTE12 VARCHAR2,
107 p_OLD_ATTRIBUTE13 VARCHAR2,
108 p_NEW_ATTRIBUTE13 VARCHAR2,
109 p_OLD_ATTRIBUTE14 VARCHAR2,
110 p_NEW_ATTRIBUTE14 VARCHAR2,
111 p_OLD_ATTRIBUTE15 VARCHAR2,
112 p_NEW_ATTRIBUTE15 VARCHAR2,
113 p_CREATED_BY NUMBER,
114 p_CREATION_DATE DATE,
115 p_LAST_UPDATED_BY NUMBER,
116 p_LAST_UPDATE_DATE DATE,
117 p_LAST_UPDATE_LOGIN NUMBER,
118 p_OBJECT_VERSION_NUMBER NUMBER,
119 p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
120 p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
121 p_OLD_INST_LOC_ID NUMBER,
122 p_NEW_INST_LOC_ID NUMBER,
123 p_OLD_INST_USAGE_CODE VARCHAR2,
124 p_NEW_INST_USAGE_CODE VARCHAR2,
125 p_OLD_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
126 p_NEW_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
127 p_OLD_CONFIG_INST_REV_NUM NUMBER,
128 p_NEW_CONFIG_INST_REV_NUM NUMBER,
129 p_OLD_CONFIG_VALID_STATUS VARCHAR2,
130 p_NEW_CONFIG_VALID_STATUS VARCHAR2,
131 p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
132 p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
133 p_OLD_INSTALL_DATE DATE,
134 p_NEW_INSTALL_DATE DATE,
135 p_OLD_RETURN_BY_DATE DATE,
136 p_NEW_RETURN_BY_DATE DATE,
137 p_OLD_ACTUAL_RETURN_DATE DATE,
138 p_NEW_ACTUAL_RETURN_DATE DATE,
139 p_OLD_LAST_OE_AGREEMENT_ID NUMBER,
140 p_NEW_LAST_OE_AGREEMENT_ID NUMBER,
141 p_OLD_LAST_OE_ORDER_LINE_ID NUMBER ,
142 p_NEW_LAST_OE_ORDER_LINE_ID NUMBER ,
143 p_OLD_LAST_OE_RMA_LINE_ID NUMBER ,
144 p_NEW_LAST_OE_RMA_LINE_ID NUMBER ,
145 p_OLD_LAST_WIP_JOB_ID NUMBER ,
146 p_NEW_LAST_WIP_JOB_ID NUMBER ,
147 p_OLD_LAST_PO_PO_LINE_ID NUMBER ,
148 p_NEW_LAST_PO_PO_LINE_ID NUMBER ,
149 p_OLD_LAST_PA_PROJECT_ID NUMBER ,
150 p_NEW_LAST_PA_PROJECT_ID NUMBER ,
151 p_OLD_LAST_PA_TASK_ID NUMBER ,
152 p_NEW_LAST_PA_TASK_ID NUMBER ,
153 p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER ,
154 p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER ,
155 p_OLD_LAST_OE_PO_NUMBER VARCHAR2,
156 p_NEW_LAST_OE_PO_NUMBER VARCHAR2,
157 --start of eam integration changes--
158 p_OLD_NETWORK_ASSET_FLAG VARCHAR2,
159 p_NEW_NETWORK_ASSET_FLAG VARCHAR2,
160 p_OLD_MAINTAINABLE_FLAG VARCHAR2,
161 p_NEW_MAINTAINABLE_FLAG VARCHAR2,
162 p_OLD_PN_LOCATION_ID NUMBER,
163 p_NEW_PN_LOCATION_ID NUMBER,
164 p_OLD_ASSET_CRITICALITY_CODE VARCHAR2,
165 p_NEW_ASSET_CRITICALITY_CODE VARCHAR2,
166 p_OLD_CATEGORY_ID NUMBER,
167 p_NEW_CATEGORY_ID NUMBER,
168 p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER,
169 p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER,
170 p_OLD_INSTANTIATION_FLAG VARCHAR2,
171 p_NEW_INSTANTIATION_FLAG VARCHAR2,
172 p_OLD_LINEAR_LOCATION_ID NUMBER,
173 p_NEW_LINEAR_LOCATION_ID NUMBER,
174 p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2,
175 p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2,
176 p_OLD_CHECKIN_STATUS NUMBER,
177 p_NEW_CHECKIN_STATUS NUMBER,
178 p_OLD_SUP_WARRANTY_EXP_DATE DATE,
179 p_NEW_SUP_WARRANTY_EXP_DATE DATE,
180 p_OLD_ATTRIBUTE16 VARCHAR2,
181 p_NEW_ATTRIBUTE16 VARCHAR2,
182 p_OLD_ATTRIBUTE17 VARCHAR2,
183 p_NEW_ATTRIBUTE17 VARCHAR2,
184 p_OLD_ATTRIBUTE18 VARCHAR2,
185 p_NEW_ATTRIBUTE18 VARCHAR2,
186 p_OLD_ATTRIBUTE19 VARCHAR2,
187 p_NEW_ATTRIBUTE19 VARCHAR2,
188 p_OLD_ATTRIBUTE20 VARCHAR2,
189 p_NEW_ATTRIBUTE20 VARCHAR2,
190 p_OLD_ATTRIBUTE21 VARCHAR2,
191 p_NEW_ATTRIBUTE21 VARCHAR2,
192 p_OLD_ATTRIBUTE22 VARCHAR2,
193 p_NEW_ATTRIBUTE22 VARCHAR2,
194 p_OLD_ATTRIBUTE23 VARCHAR2,
195 p_NEW_ATTRIBUTE23 VARCHAR2,
196 p_OLD_ATTRIBUTE24 VARCHAR2,
197 p_NEW_ATTRIBUTE24 VARCHAR2,
198 p_OLD_ATTRIBUTE25 VARCHAR2,
199 p_NEW_ATTRIBUTE25 VARCHAR2,
200 p_OLD_ATTRIBUTE26 VARCHAR2,
201 p_NEW_ATTRIBUTE26 VARCHAR2,
202 p_OLD_ATTRIBUTE27 VARCHAR2,
203 p_NEW_ATTRIBUTE27 VARCHAR2,
204 p_OLD_ATTRIBUTE28 VARCHAR2,
205 p_NEW_ATTRIBUTE28 VARCHAR2,
206 p_OLD_ATTRIBUTE29 VARCHAR2,
207 p_NEW_ATTRIBUTE29 VARCHAR2,
208 p_OLD_ATTRIBUTE30 VARCHAR2,
209 p_NEW_ATTRIBUTE30 VARCHAR2,
210 --end of eam integration changes--
211 -- Addition of columns for FA Integration
212 p_OLD_PAYABLES_UNIT_PRICE NUMBER,
213 p_NEW_PAYABLES_UNIT_PRICE NUMBER,
214 p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2,
215 p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2,
216 p_OLD_PURCHASE_UNIT_PRICE NUMBER,
217 p_NEW_PURCHASE_UNIT_PRICE NUMBER,
218 p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2,
219 p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2,
220 p_OLD_SALES_UNIT_PRICE NUMBER,
221 p_NEW_SALES_UNIT_PRICE NUMBER,
222 p_OLD_SALES_CURRENCY_CODE VARCHAR2,
223 p_NEW_SALES_CURRENCY_CODE VARCHAR2,
224 p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2,
225 p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2,
226 -- End addition of columns for FA Integration
227 -- Begin Add Code for Siebel Genesis Project
228 p_OLD_SOURCE_CODE VARCHAR2,
229 p_NEW_SOURCE_CODE VARCHAR2
230 -- End Add Code for Siebel Genesis Project
231 )
232 IS
233 CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_H_S.NEXTVAL FROM sys.dual;
234 BEGIN
235 IF (px_INSTANCE_HISTORY_ID IS NULL) OR (px_INSTANCE_HISTORY_ID = FND_API.G_MISS_NUM) THEN
236 OPEN C2;
237 FETCH C2 INTO px_INSTANCE_HISTORY_ID;
238 CLOSE C2;
239 END IF;
240 INSERT INTO CSI_ITEM_INSTANCES_H(
241 INSTANCE_HISTORY_ID,
242 INSTANCE_ID,
243 TRANSACTION_ID,
244 OLD_INSTANCE_NUMBER,
245 NEW_INSTANCE_NUMBER,
246 OLD_EXTERNAL_REFERENCE,
247 NEW_EXTERNAL_REFERENCE,
248 OLD_INVENTORY_ITEM_ID,
249 NEW_INVENTORY_ITEM_ID,
250 OLD_INVENTORY_REVISION,
251 NEW_INVENTORY_REVISION,
252 OLD_INV_MASTER_ORGANIZATION_ID,
253 NEW_INV_MASTER_ORGANIZATION_ID,
254 OLD_SERIAL_NUMBER,
255 NEW_SERIAL_NUMBER ,
256 OLD_MFG_SERIAL_NUMBER_FLAG,
257 NEW_MFG_SERIAL_NUMBER_FLAG,
258 OLD_LOT_NUMBER,
259 NEW_LOT_NUMBER,
260 OLD_QUANTITY,
261 NEW_QUANTITY,
262 OLD_UNIT_OF_MEASURE,
263 NEW_UNIT_OF_MEASURE,
264 OLD_ACCOUNTING_CLASS_CODE,
265 NEW_ACCOUNTING_CLASS_CODE,
266 OLD_INSTANCE_CONDITION_ID,
267 NEW_INSTANCE_CONDITION_ID,
268 OLD_INSTANCE_STATUS_ID,
269 NEW_INSTANCE_STATUS_ID,
270 OLD_CUSTOMER_VIEW_FLAG,
271 NEW_CUSTOMER_VIEW_FLAG,
272 OLD_MERCHANT_VIEW_FLAG,
273 NEW_MERCHANT_VIEW_FLAG,
274 OLD_SELLABLE_FLAG,
275 NEW_SELLABLE_FLAG,
276 OLD_SYSTEM_ID,
277 NEW_SYSTEM_ID,
278 OLD_INSTANCE_TYPE_CODE,
279 NEW_INSTANCE_TYPE_CODE,
280 OLD_ACTIVE_START_DATE,
281 NEW_ACTIVE_START_DATE,
282 OLD_ACTIVE_END_DATE,
283 NEW_ACTIVE_END_DATE,
284 OLD_LOCATION_TYPE_CODE,
285 NEW_LOCATION_TYPE_CODE,
286 OLD_LOCATION_ID,
287 NEW_LOCATION_ID,
288 OLD_INV_ORGANIZATION_ID,
289 NEW_INV_ORGANIZATION_ID,
290 OLD_INV_SUBINVENTORY_NAME,
291 NEW_INV_SUBINVENTORY_NAME,
292 OLD_INV_LOCATOR_ID,
293 NEW_INV_LOCATOR_ID,
294 OLD_PA_PROJECT_ID,
295 NEW_PA_PROJECT_ID,
296 OLD_PA_PROJECT_TASK_ID,
297 NEW_PA_PROJECT_TASK_ID,
298 OLD_IN_TRANSIT_ORDER_LINE_ID,
299 NEW_IN_TRANSIT_ORDER_LINE_ID,
300 OLD_WIP_JOB_ID,
301 NEW_WIP_JOB_ID,
302 OLD_PO_ORDER_LINE_ID,
303 NEW_PO_ORDER_LINE_ID,
304 OLD_COMPLETENESS_FLAG,
305 NEW_COMPLETENESS_FLAG,
306 FULL_DUMP_FLAG,
307 OLD_CONTEXT,
308 NEW_CONTEXT,
309 OLD_ATTRIBUTE1,
310 NEW_ATTRIBUTE1,
311 OLD_ATTRIBUTE2,
312 NEW_ATTRIBUTE2,
313 OLD_ATTRIBUTE3,
314 NEW_ATTRIBUTE3,
315 OLD_ATTRIBUTE4,
316 NEW_ATTRIBUTE4,
317 OLD_ATTRIBUTE5,
318 NEW_ATTRIBUTE5,
319 OLD_ATTRIBUTE6,
320 NEW_ATTRIBUTE6,
321 OLD_ATTRIBUTE7,
322 NEW_ATTRIBUTE7,
323 OLD_ATTRIBUTE8,
324 NEW_ATTRIBUTE8,
325 OLD_ATTRIBUTE9,
326 NEW_ATTRIBUTE9,
327 OLD_ATTRIBUTE10,
328 NEW_ATTRIBUTE10,
329 OLD_ATTRIBUTE11,
330 NEW_ATTRIBUTE11,
331 OLD_ATTRIBUTE12,
332 NEW_ATTRIBUTE12,
333 OLD_ATTRIBUTE13,
334 NEW_ATTRIBUTE13,
335 OLD_ATTRIBUTE14,
336 NEW_ATTRIBUTE14,
337 OLD_ATTRIBUTE15,
338 NEW_ATTRIBUTE15,
339 CREATED_BY,
340 CREATION_DATE,
341 LAST_UPDATED_BY,
342 LAST_UPDATE_DATE,
343 LAST_UPDATE_LOGIN,
344 OBJECT_VERSION_NUMBER,
345 OLD_INST_LOC_TYPE_CODE,
346 NEW_INST_LOC_TYPE_CODE,
347 OLD_INST_LOC_ID,
348 NEW_INST_LOC_ID,
349 OLD_INST_USAGE_CODE,
350 NEW_INST_USAGE_CODE,
351 OLD_last_vld_organization_id,
352 NEW_last_vld_organization_id,
353 OLD_CONFIG_INST_REV_NUM ,
354 NEW_CONFIG_INST_REV_NUM ,
355 OLD_CONFIG_VALID_STATUS ,
356 NEW_CONFIG_VALID_STATUS ,
357 OLD_INSTANCE_DESCRIPTION ,
358 NEW_INSTANCE_DESCRIPTION ,
359 OLD_INSTALL_DATE ,
360 NEW_INSTALL_DATE ,
361 OLD_RETURN_BY_DATE ,
362 NEW_RETURN_BY_DATE ,
363 OLD_ACTUAL_RETURN_DATE ,
364 NEW_ACTUAL_RETURN_DATE ,
365 OLD_OE_AGREEMENT_ID ,
366 NEW_OE_AGREEMENT_ID ,
367 OLD_LAST_OE_ORDER_LINE_ID,
368 NEW_LAST_OE_ORDER_LINE_ID,
369 OLD_LAST_OE_RMA_LINE_ID,
370 NEW_LAST_OE_RMA_LINE_ID,
371 OLD_LAST_WIP_JOB_ID,
372 NEW_LAST_WIP_JOB_ID,
373 OLD_LAST_PO_PO_LINE_ID,
374 NEW_LAST_PO_PO_LINE_ID,
375 OLD_LAST_PA_PROJECT_ID,
376 NEW_LAST_PA_PROJECT_ID,
377 OLD_LAST_PA_TASK_ID,
378 NEW_LAST_PA_TASK_ID,
379 OLD_LAST_TXN_LINE_DETAIL_ID,
380 NEW_LAST_TXN_LINE_DETAIL_ID,
381 OLD_LAST_OE_PO_NUMBER,
382 NEW_LAST_OE_PO_NUMBER,
383 --start of eam integration changes--
387 NEW_MAINTAINABLE_FLAG,
384 OLD_NETWORK_ASSET_FLAG,
385 NEW_NETWORK_ASSET_FLAG,
386 OLD_MAINTAINABLE_FLAG,
388 OLD_PN_LOCATION_ID,
389 NEW_PN_LOCATION_ID,
390 OLD_ASSET_CRITICALITY_CODE,
391 NEW_ASSET_CRITICALITY_CODE,
392 OLD_CATEGORY_ID,
393 NEW_CATEGORY_ID,
394 OLD_EQUIPMENT_GEN_OBJECT_ID,
395 NEW_EQUIPMENT_GEN_OBJECT_ID,
396 OLD_INSTANTIATION_FLAG,
397 NEW_INSTANTIATION_FLAG,
398 OLD_LINEAR_LOCATION_ID,
399 NEW_LINEAR_LOCATION_ID,
400 OLD_OPERATIONAL_LOG_FLAG,
401 NEW_OPERATIONAL_LOG_FLAG,
402 OLD_CHECKIN_STATUS,
403 NEW_CHECKIN_STATUS,
404 OLD_SUPPLIER_WARRANTY_EXP_DATE,
405 NEW_SUPPLIER_WARRANTY_EXP_DATE,
406 OLD_ATTRIBUTE16,
407 NEW_ATTRIBUTE16,
408 OLD_ATTRIBUTE17,
409 NEW_ATTRIBUTE17,
410 OLD_ATTRIBUTE18,
411 NEW_ATTRIBUTE18,
412 OLD_ATTRIBUTE19,
413 NEW_ATTRIBUTE19,
414 OLD_ATTRIBUTE20,
415 NEW_ATTRIBUTE20,
416 OLD_ATTRIBUTE21,
417 NEW_ATTRIBUTE21,
418 OLD_ATTRIBUTE22,
419 NEW_ATTRIBUTE22,
420 OLD_ATTRIBUTE23,
421 NEW_ATTRIBUTE23,
422 OLD_ATTRIBUTE24,
423 NEW_ATTRIBUTE24,
424 OLD_ATTRIBUTE25,
425 NEW_ATTRIBUTE25,
426 OLD_ATTRIBUTE26,
427 NEW_ATTRIBUTE26,
428 OLD_ATTRIBUTE27,
429 NEW_ATTRIBUTE27,
430 OLD_ATTRIBUTE28,
431 NEW_ATTRIBUTE28,
432 OLD_ATTRIBUTE29,
433 NEW_ATTRIBUTE29,
434 OLD_ATTRIBUTE30,
435 NEW_ATTRIBUTE30,
436 --end of eam integration changes--
437 -- Addition of columns for FA Integration
438 OLD_PAYABLES_UNIT_PRICE,
439 NEW_PAYABLES_UNIT_PRICE,
440 OLD_PAYABLES_CURRENCY_CODE,
441 NEW_PAYABLES_CURRENCY_CODE,
442 OLD_PURCHASE_UNIT_PRICE,
443 NEW_PURCHASE_UNIT_PRICE,
444 OLD_PURCHASE_CURRENCY_CODE,
445 NEW_PURCHASE_CURRENCY_CODE,
446 OLD_SALES_UNIT_PRICE,
447 NEW_SALES_UNIT_PRICE,
448 OLD_SALES_CURRENCY_CODE,
449 NEW_SALES_CURRENCY_CODE,
450 OLD_OPERATIONAL_STATUS_CODE,
451 NEW_OPERATIONAL_STATUS_CODE,
452 -- End addition of columns for FA Integration
453 -- Begin Add Code for Siebel Genesis Project
454 OLD_SOURCE_CODE,
455 NEW_SOURCE_CODE
456 -- End Add Code for Siebel Genesis Project
457 )
458 VALUES (
459 px_INSTANCE_HISTORY_ID,
460 decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
461 decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
462 decode( p_OLD_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANCE_NUMBER),
463 decode( p_NEW_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANCE_NUMBER),
464 decode( p_OLD_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_OLD_EXTERNAL_REFERENCE),
465 decode( p_NEW_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_NEW_EXTERNAL_REFERENCE),
466 decode( p_OLD_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INVENTORY_ITEM_ID),
467 decode( p_NEW_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INVENTORY_ITEM_ID),
468 decode( p_OLD_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_OLD_INVENTORY_REVISION),
469 decode( p_NEW_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_NEW_INVENTORY_REVISION),
470 decode( p_OLD_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INV_MASTER_ORGZN_ID),
471 decode( p_NEW_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INV_MASTER_ORGZN_ID),
472 decode( p_OLD_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_OLD_SERIAL_NUMBER),
473 decode( p_NEW_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEW_SERIAL_NUMBER) ,
474 decode( p_OLD_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_MFG_SERIAL_NUMBER_FLAG),
475 decode( p_NEW_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_MFG_SERIAL_NUMBER_FLAG),
476 decode( p_OLD_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_OLD_LOT_NUMBER),
477 decode( p_NEW_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEW_LOT_NUMBER),
478 decode( p_OLD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_QUANTITY),
479 decode( p_NEW_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_QUANTITY),
480 decode( p_OLD_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_OLD_UNIT_OF_MEASURE),
481 decode( p_NEW_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_NEW_UNIT_OF_MEASURE),
482 decode( p_OLD_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_ACCOUNTING_CLASS_CODE),
483 decode( p_NEW_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_ACCOUNTING_CLASS_CODE),
484 decode( p_OLD_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_CONDITION_ID),
485 decode( p_NEW_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_CONDITION_ID),
486 decode( p_OLD_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_STATUS_ID),
487 decode( p_NEW_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_STATUS_ID),
488 decode( p_OLD_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_CUSTOMER_VIEW_FLAG),
489 decode( p_NEW_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_CUSTOMER_VIEW_FLAG),
490 decode( p_OLD_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_MERCHANT_VIEW_FLAG),
491 decode( p_NEW_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_MERCHANT_VIEW_FLAG),
492 decode( p_OLD_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_SELLABLE_FLAG),
493 decode( p_NEW_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_SELLABLE_FLAG),
494 decode( p_OLD_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_OLD_SYSTEM_ID),
495 decode( p_NEW_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_NEW_SYSTEM_ID),
499 decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
496 decode( p_OLD_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANCE_TYPE_CODE),
497 decode( p_NEW_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANCE_TYPE_CODE),
498 decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
500 decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
501 decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE),
502 decode( p_OLD_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_LOCATION_TYPE_CODE),
503 decode( p_NEW_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_LOCATION_TYPE_CODE),
504 decode( p_OLD_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_LOCATION_ID),
505 decode( p_NEW_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_LOCATION_ID),
506 decode( p_OLD_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INV_ORGANIZATION_ID),
507 decode( p_NEW_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INV_ORGANIZATION_ID),
508 decode( p_OLD_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_OLD_INV_SUBINVENTORY_NAME),
509 decode( p_NEW_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_NEW_INV_SUBINVENTORY_NAME),
510 decode( p_OLD_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INV_LOCATOR_ID),
511 decode( p_NEW_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INV_LOCATOR_ID),
512 decode( p_OLD_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PA_PROJECT_ID),
513 decode( p_NEW_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PA_PROJECT_ID),
514 decode( p_OLD_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PA_PROJECT_TASK_ID),
515 decode( p_NEW_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PA_PROJECT_TASK_ID),
516 decode( p_OLD_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_IN_TRANSIT_ORDER_LINE_ID),
517 decode( p_NEW_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_IN_TRANSIT_ORDER_LINE_ID),
518 decode( p_OLD_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_OLD_WIP_JOB_ID),
519 decode( p_NEW_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_NEW_WIP_JOB_ID),
520 decode( p_OLD_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PO_ORDER_LINE_ID),
521 decode( p_NEW_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PO_ORDER_LINE_ID),
522 decode( p_OLD_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_COMPLETENESS_FLAG),
523 decode( p_NEW_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_COMPLETENESS_FLAG),
524 decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
525 decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_OLD_CONTEXT),
526 decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_NEW_CONTEXT),
527 decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE1),
528 decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE1),
529 decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE2),
530 decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE2),
531 decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE3),
532 decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE3),
533 decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE4),
534 decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE4),
535 decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE5),
536 decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE5),
537 decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE6),
538 decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE6),
539 decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE7),
540 decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE7),
541 decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE8),
542 decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE8),
543 decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE9),
544 decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE9),
545 decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE10),
546 decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE10),
547 decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE11),
548 decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE11),
549 decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE12),
550 decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE12),
551 decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE13),
552 decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE13),
553 decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE14),
554 decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE14),
555 decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE15),
556 decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE15),
557 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
558 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
559 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
560 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
561 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
562 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
563 decode( p_OLD_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_INST_LOC_TYPE_CODE),
564 decode( p_NEW_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_INST_LOC_TYPE_CODE),
568 decode( p_NEW_INST_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_INST_USAGE_CODE),
565 decode( p_OLD_INST_LOC_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INST_LOC_ID),
566 decode( p_NEW_INST_LOC_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INST_LOC_ID),
567 decode( p_OLD_INST_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_INST_USAGE_CODE),
569 decode( p_OLD_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_OLD_last_vld_organization_id),
570 decode( p_NEW_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_new_last_vld_organization_id),
571 decode( p_OLD_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OLD_CONFIG_INST_REV_NUM),
572 decode( p_NEW_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_NEW_CONFIG_INST_REV_NUM),
573 decode( p_OLD_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_CONFIG_VALID_STATUS),
574 decode( p_NEW_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_CONFIG_VALID_STATUS),
575 decode( p_OLD_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANCE_DESCRIPTION),
576 decode( p_NEW_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANCE_DESCRIPTION),
577 decode( p_OLD_INSTALL_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_INSTALL_DATE),
578 decode( p_NEW_INSTALL_DATE ,FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_INSTALL_DATE),
579 decode( p_OLD_RETURN_BY_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_RETURN_BY_DATE),
580 decode( p_NEW_RETURN_BY_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_RETURN_BY_DATE),
581 decode( p_OLD_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTUAL_RETURN_DATE),
582 decode( p_NEW_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTUAL_RETURN_DATE),
583 decode( p_OLD_LAST_OE_AGREEMENT_ID,FND_API.G_MISS_NUM, NULL,p_OLD_LAST_OE_AGREEMENT_ID),
584 decode( p_NEW_LAST_OE_AGREEMENT_ID,FND_API.G_MISS_NUM, NULL,p_NEW_LAST_OE_AGREEMENT_ID),
585 decode(p_OLD_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_OE_ORDER_LINE_ID),
586 decode(p_NEW_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_OE_ORDER_LINE_ID),
587 decode(p_OLD_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_OE_RMA_LINE_ID),
588 decode(p_NEW_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_OE_RMA_LINE_ID),
589 decode(p_OLD_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_WIP_JOB_ID),
590 decode(p_NEW_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_WIP_JOB_ID),
591 decode(p_OLD_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_PO_PO_LINE_ID),
592 decode(p_NEW_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_PO_PO_LINE_ID),
593 decode(p_OLD_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_PA_PROJECT_ID),
594 decode(p_NEW_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_PA_PROJECT_ID),
595 decode(p_OLD_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_PA_TASK_ID),
596 decode(p_NEW_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_PA_TASK_ID),
597 decode(p_OLD_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_TXN_LINE_DETAIL_ID),
598 decode(p_NEW_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_TXN_LINE_DETAIL_ID),
599 decode(p_OLD_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR, NULL,p_OLD_LAST_OE_PO_NUMBER),
600 decode(p_NEW_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR, NULL,p_NEW_LAST_OE_PO_NUMBER),
601 --start of eam integration changes--
602 decode( p_OLD_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_NETWORK_ASSET_FLAG),
603 decode( p_NEW_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_NETWORK_ASSET_FLAG),
604 decode( p_OLD_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_MAINTAINABLE_FLAG),
605 decode( p_NEW_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_MAINTAINABLE_FLAG),
606 decode( p_OLD_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PN_LOCATION_ID),
607 decode( p_NEW_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PN_LOCATION_ID),
608 decode( p_OLD_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_ASSET_CRITICALITY_CODE),
609 decode( p_NEW_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_ASSET_CRITICALITY_CODE),
610 decode( p_OLD_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_OLD_CATEGORY_ID),
611 decode( p_NEW_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_NEW_CATEGORY_ID),
612 decode( p_OLD_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OLD_EQUIPMENT_GEN_OBJECT_ID),
613 decode( p_NEW_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_NEW_EQUIPMENT_GEN_OBJECT_ID),
614 decode( p_OLD_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANTIATION_FLAG),
615 decode( p_NEW_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANTIATION_FLAG),
616 decode( p_OLD_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_LINEAR_LOCATION_ID),
617 decode( p_NEW_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_LINEAR_LOCATION_ID),
618 decode( p_OLD_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_OPERATIONAL_LOG_FLAG),
619 decode( p_NEW_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_OPERATIONAL_LOG_FLAG),
620 decode( p_OLD_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_OLD_CHECKIN_STATUS),
621 decode( p_NEW_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_NEW_CHECKIN_STATUS),
622 decode( p_OLD_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_SUP_WARRANTY_EXP_DATE),
623 decode( p_NEW_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_SUP_WARRANTY_EXP_DATE),
624 decode( p_OLD_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE16),
625 decode( p_NEW_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE16),
626 decode( p_OLD_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE17),
627 decode( p_NEW_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE17),
628 decode( p_OLD_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE18),
629 decode( p_NEW_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE18),
630 decode( p_OLD_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE19),
631 decode( p_NEW_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE19),
632 decode( p_OLD_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE20),
636 decode( p_OLD_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE22),
633 decode( p_NEW_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE20),
634 decode( p_OLD_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE21),
635 decode( p_NEW_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE21),
637 decode( p_NEW_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE22),
638 decode( p_OLD_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE23),
639 decode( p_NEW_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE23),
640 decode( p_OLD_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE24),
641 decode( p_NEW_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE24),
642 decode( p_OLD_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE25),
643 decode( p_NEW_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE25),
644 decode( p_OLD_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE26),
645 decode( p_NEW_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE26),
646 decode( p_OLD_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE27),
647 decode( p_NEW_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE27),
648 decode( p_OLD_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE28),
649 decode( p_NEW_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE28),
650 decode( p_OLD_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE29),
651 decode( p_NEW_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE29),
652 decode( p_OLD_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE30),
653 decode( p_NEW_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE30),
654 --end of eam integration changes--
655 -- Addition of columns for FA Integration
656 decode( p_OLD_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_OLD_PAYABLES_UNIT_PRICE),
657 decode( p_NEW_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_NEW_PAYABLES_UNIT_PRICE),
658 decode( p_OLD_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_PAYABLES_CURRENCY_CODE),
659 decode( p_NEW_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_PAYABLES_CURRENCY_CODE),
660 decode( p_OLD_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_OLD_PURCHASE_UNIT_PRICE),
661 decode( p_NEW_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_NEW_PURCHASE_UNIT_PRICE),
662 decode( p_OLD_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_PURCHASE_CURRENCY_CODE),
663 decode( p_NEW_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_PURCHASE_CURRENCY_CODE),
664 decode( p_OLD_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_OLD_SALES_UNIT_PRICE),
665 decode( p_NEW_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_NEW_SALES_UNIT_PRICE),
666 decode( p_OLD_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_SALES_CURRENCY_CODE),
667 decode( p_NEW_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_SALES_CURRENCY_CODE),
668 decode( p_OLD_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_OPERATIONAL_STATUS_CODE),
669 decode( p_NEW_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_OPERATIONAL_STATUS_CODE),
670 -- End addition of columns for FA Integration
671 -- Begin Add Code for Siebel Genesis Project
672 decode( p_OLD_SOURCE_CODE,FND_API.G_MISS_CHAR,NULL,p_OLD_SOURCE_CODE),
673 decode( p_NEW_SOURCE_CODE,FND_API.G_MISS_CHAR,NULL,p_NEW_SOURCE_CODE)
674 -- End Add Code for Siebel Genesis Project
675 );
676 End Insert_Row;
677
678 PROCEDURE Update_Row(
679 p_INSTANCE_HISTORY_ID NUMBER,
680 p_INSTANCE_ID NUMBER,
681 p_TRANSACTION_ID NUMBER,
682 p_OLD_INSTANCE_NUMBER VARCHAR2,
683 p_NEW_INSTANCE_NUMBER VARCHAR2,
684 p_OLD_EXTERNAL_REFERENCE VARCHAR2,
685 p_NEW_EXTERNAL_REFERENCE VARCHAR2,
686 p_OLD_INVENTORY_ITEM_ID NUMBER,
687 p_NEW_INVENTORY_ITEM_ID NUMBER,
688 p_OLD_INVENTORY_REVISION VARCHAR2,
689 p_NEW_INVENTORY_REVISION VARCHAR2,
690 p_OLD_INV_MASTER_ORGZN_ID NUMBER,
691 p_NEW_INV_MASTER_ORGZN_ID NUMBER,
692 p_OLD_SERIAL_NUMBER VARCHAR2,
693 p_NEW_SERIAL_NUMBER VARCHAR2,
694 p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
695 p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
696 p_OLD_LOT_NUMBER VARCHAR2,
697 p_NEW_LOT_NUMBER VARCHAR2,
698 p_OLD_QUANTITY NUMBER,
699 p_NEW_QUANTITY NUMBER,
700 p_OLD_UNIT_OF_MEASURE VARCHAR2,
701 p_NEW_UNIT_OF_MEASURE VARCHAR2,
702 p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
703 p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
704 p_OLD_INSTANCE_CONDITION_ID NUMBER,
705 p_NEW_INSTANCE_CONDITION_ID NUMBER,
706 p_OLD_INSTANCE_STATUS_ID NUMBER,
707 p_NEW_INSTANCE_STATUS_ID NUMBER,
708 p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
709 p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
710 p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
711 p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
712 p_OLD_SELLABLE_FLAG VARCHAR2,
713 p_NEW_SELLABLE_FLAG VARCHAR2,
714 p_OLD_SYSTEM_ID NUMBER,
715 p_NEW_SYSTEM_ID NUMBER,
716 p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
717 p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
718 p_OLD_ACTIVE_START_DATE DATE,
719 p_NEW_ACTIVE_START_DATE DATE,
720 p_OLD_ACTIVE_END_DATE DATE,
721 p_NEW_ACTIVE_END_DATE DATE,
722 p_OLD_LOCATION_TYPE_CODE VARCHAR2,
723 p_NEW_LOCATION_TYPE_CODE VARCHAR2,
724 p_OLD_LOCATION_ID NUMBER,
725 p_NEW_LOCATION_ID NUMBER,
726 p_OLD_INV_ORGANIZATION_ID NUMBER,
727 p_NEW_INV_ORGANIZATION_ID NUMBER,
731 p_NEW_INV_LOCATOR_ID NUMBER,
728 p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
729 p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
730 p_OLD_INV_LOCATOR_ID NUMBER,
732 p_OLD_PA_PROJECT_ID NUMBER,
733 p_NEW_PA_PROJECT_ID NUMBER,
734 p_OLD_PA_PROJECT_TASK_ID NUMBER,
735 p_NEW_PA_PROJECT_TASK_ID NUMBER,
736 p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
737 p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
738 p_OLD_WIP_JOB_ID NUMBER,
739 p_NEW_WIP_JOB_ID NUMBER,
740 p_OLD_PO_ORDER_LINE_ID NUMBER,
741 p_NEW_PO_ORDER_LINE_ID NUMBER,
742 p_OLD_COMPLETENESS_FLAG VARCHAR2,
743 p_NEW_COMPLETENESS_FLAG VARCHAR2,
744 p_FULL_DUMP_FLAG VARCHAR2,
745 p_OLD_CONTEXT VARCHAR2,
746 p_NEW_CONTEXT VARCHAR2,
747 p_OLD_ATTRIBUTE1 VARCHAR2,
748 p_NEW_ATTRIBUTE1 VARCHAR2,
749 p_OLD_ATTRIBUTE2 VARCHAR2,
750 p_NEW_ATTRIBUTE2 VARCHAR2,
751 p_OLD_ATTRIBUTE3 VARCHAR2,
752 p_NEW_ATTRIBUTE3 VARCHAR2,
753 p_OLD_ATTRIBUTE4 VARCHAR2,
754 p_NEW_ATTRIBUTE4 VARCHAR2,
755 p_OLD_ATTRIBUTE5 VARCHAR2,
756 p_NEW_ATTRIBUTE5 VARCHAR2,
757 p_OLD_ATTRIBUTE6 VARCHAR2,
758 p_NEW_ATTRIBUTE6 VARCHAR2,
759 p_OLD_ATTRIBUTE7 VARCHAR2,
760 p_NEW_ATTRIBUTE7 VARCHAR2,
761 p_OLD_ATTRIBUTE8 VARCHAR2,
762 p_NEW_ATTRIBUTE8 VARCHAR2,
763 p_OLD_ATTRIBUTE9 VARCHAR2,
764 p_NEW_ATTRIBUTE9 VARCHAR2,
765 p_OLD_ATTRIBUTE10 VARCHAR2,
766 p_NEW_ATTRIBUTE10 VARCHAR2,
767 p_OLD_ATTRIBUTE11 VARCHAR2,
768 p_NEW_ATTRIBUTE11 VARCHAR2,
769 p_OLD_ATTRIBUTE12 VARCHAR2,
770 p_NEW_ATTRIBUTE12 VARCHAR2,
771 p_OLD_ATTRIBUTE13 VARCHAR2,
772 p_NEW_ATTRIBUTE13 VARCHAR2,
773 p_OLD_ATTRIBUTE14 VARCHAR2,
774 p_NEW_ATTRIBUTE14 VARCHAR2,
775 p_OLD_ATTRIBUTE15 VARCHAR2,
776 p_NEW_ATTRIBUTE15 VARCHAR2,
777 p_CREATED_BY NUMBER,
778 p_CREATION_DATE DATE,
779 p_LAST_UPDATED_BY NUMBER,
780 p_LAST_UPDATE_DATE DATE,
781 p_LAST_UPDATE_LOGIN NUMBER,
782 p_OBJECT_VERSION_NUMBER NUMBER,
783 p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
784 p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
785 p_OLD_INST_LOC_ID NUMBER,
786 p_NEW_INST_LOC_ID NUMBER,
787 p_OLD_INST_USAGE_CODE VARCHAR2,
788 p_NEW_INST_USAGE_CODE VARCHAR2,
789 p_OLD_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
790 p_NEW_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
791 p_OLD_CONFIG_INST_REV_NUM NUMBER,
792 p_NEW_CONFIG_INST_REV_NUM NUMBER,
793 p_OLD_CONFIG_VALID_STATUS VARCHAR2,
794 p_NEW_CONFIG_VALID_STATUS VARCHAR2,
795 p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
796 p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
797 p_OLD_INSTALL_DATE DATE,
798 p_NEW_INSTALL_DATE DATE,
799 p_OLD_RETURN_BY_DATE DATE,
800 p_NEW_RETURN_BY_DATE DATE,
801 p_OLD_ACTUAL_RETURN_DATE DATE,
802 p_NEW_ACTUAL_RETURN_DATE DATE,
803 p_OLD_LAST_OE_AGREEMENT_ID NUMBER,
804 p_NEW_LAST_OE_AGREEMENT_ID NUMBER,
805 p_OLD_LAST_OE_ORDER_LINE_ID NUMBER ,
806 p_NEW_LAST_OE_ORDER_LINE_ID NUMBER ,
807 p_OLD_LAST_OE_RMA_LINE_ID NUMBER ,
808 p_NEW_LAST_OE_RMA_LINE_ID NUMBER ,
809 p_OLD_LAST_WIP_JOB_ID NUMBER ,
810 p_NEW_LAST_WIP_JOB_ID NUMBER ,
811 p_OLD_LAST_PO_PO_LINE_ID NUMBER ,
812 p_NEW_LAST_PO_PO_LINE_ID NUMBER ,
813 p_OLD_LAST_PA_PROJECT_ID NUMBER ,
814 p_NEW_LAST_PA_PROJECT_ID NUMBER ,
815 p_OLD_LAST_PA_TASK_ID NUMBER ,
816 p_NEW_LAST_PA_TASK_ID NUMBER ,
817 p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER ,
818 p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER ,
819 p_OLD_LAST_OE_PO_NUMBER VARCHAR2,
820 p_NEW_LAST_OE_PO_NUMBER VARCHAR2,
821 --start of eam integration changes--
822 p_OLD_NETWORK_ASSET_FLAG VARCHAR2,
823 p_NEW_NETWORK_ASSET_FLAG VARCHAR2,
824 p_OLD_MAINTAINABLE_FLAG VARCHAR2,
825 p_NEW_MAINTAINABLE_FLAG VARCHAR2,
826 p_OLD_PN_LOCATION_ID NUMBER,
827 p_NEW_PN_LOCATION_ID NUMBER,
828 p_OLD_ASSET_CRITICALITY_CODE VARCHAR2,
829 p_NEW_ASSET_CRITICALITY_CODE VARCHAR2,
830 p_OLD_CATEGORY_ID NUMBER,
831 p_NEW_CATEGORY_ID NUMBER,
832 p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER,
833 p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER,
834 p_OLD_INSTANTIATION_FLAG VARCHAR2,
835 p_NEW_INSTANTIATION_FLAG VARCHAR2,
836 p_OLD_LINEAR_LOCATION_ID NUMBER,
837 p_NEW_LINEAR_LOCATION_ID NUMBER,
838 p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2,
839 p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2,
840 p_OLD_CHECKIN_STATUS NUMBER,
841 p_NEW_CHECKIN_STATUS NUMBER,
842 p_OLD_SUP_WARRANTY_EXP_DATE DATE,
843 p_NEW_SUP_WARRANTY_EXP_DATE DATE,
844 p_OLD_ATTRIBUTE16 VARCHAR2,
845 p_NEW_ATTRIBUTE16 VARCHAR2,
846 p_OLD_ATTRIBUTE17 VARCHAR2,
847 p_NEW_ATTRIBUTE17 VARCHAR2,
848 p_OLD_ATTRIBUTE18 VARCHAR2,
852 p_OLD_ATTRIBUTE20 VARCHAR2,
849 p_NEW_ATTRIBUTE18 VARCHAR2,
850 p_OLD_ATTRIBUTE19 VARCHAR2,
851 p_NEW_ATTRIBUTE19 VARCHAR2,
853 p_NEW_ATTRIBUTE20 VARCHAR2,
854 p_OLD_ATTRIBUTE21 VARCHAR2,
855 p_NEW_ATTRIBUTE21 VARCHAR2,
856 p_OLD_ATTRIBUTE22 VARCHAR2,
857 p_NEW_ATTRIBUTE22 VARCHAR2,
858 p_OLD_ATTRIBUTE23 VARCHAR2,
859 p_NEW_ATTRIBUTE23 VARCHAR2,
860 p_OLD_ATTRIBUTE24 VARCHAR2,
861 p_NEW_ATTRIBUTE24 VARCHAR2,
862 p_OLD_ATTRIBUTE25 VARCHAR2,
863 p_NEW_ATTRIBUTE25 VARCHAR2,
864 p_OLD_ATTRIBUTE26 VARCHAR2,
865 p_NEW_ATTRIBUTE26 VARCHAR2,
866 p_OLD_ATTRIBUTE27 VARCHAR2,
867 p_NEW_ATTRIBUTE27 VARCHAR2,
868 p_OLD_ATTRIBUTE28 VARCHAR2,
869 p_NEW_ATTRIBUTE28 VARCHAR2,
870 p_OLD_ATTRIBUTE29 VARCHAR2,
871 p_NEW_ATTRIBUTE29 VARCHAR2,
872 p_OLD_ATTRIBUTE30 VARCHAR2,
873 p_NEW_ATTRIBUTE30 VARCHAR2,
874 --end of eam integration changes--
875 -- Addition of columns for FA Integration
876 p_OLD_PAYABLES_UNIT_PRICE NUMBER,
877 p_NEW_PAYABLES_UNIT_PRICE NUMBER,
878 p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2,
879 p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2,
880 p_OLD_PURCHASE_UNIT_PRICE NUMBER,
881 p_NEW_PURCHASE_UNIT_PRICE NUMBER,
882 p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2,
883 p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2,
884 p_OLD_SALES_UNIT_PRICE NUMBER,
885 p_NEW_SALES_UNIT_PRICE NUMBER,
886 p_OLD_SALES_CURRENCY_CODE VARCHAR2,
887 p_NEW_SALES_CURRENCY_CODE VARCHAR2,
888 p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2,
889 p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2,
890 -- End addition of columns for FA Integration
891 -- Begin Add Code for Siebel Genesis Project
892 p_OLD_SOURCE_CODE VARCHAR2,
893 p_NEW_SOURCE_CODE VARCHAR2
894 -- End Add Code for Siebel Genesis Project
895 )
896
897 IS
898 BEGIN
899 Update CSI_ITEM_INSTANCES_H
900 SET
901 INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
902 TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
903 OLD_INSTANCE_NUMBER = decode( p_OLD_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, OLD_INSTANCE_NUMBER, p_OLD_INSTANCE_NUMBER),
904 NEW_INSTANCE_NUMBER = decode( p_NEW_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NEW_INSTANCE_NUMBER, p_NEW_INSTANCE_NUMBER),
905 OLD_EXTERNAL_REFERENCE = decode( p_OLD_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, OLD_EXTERNAL_REFERENCE, p_OLD_EXTERNAL_REFERENCE),
906 NEW_EXTERNAL_REFERENCE = decode( p_NEW_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NEW_EXTERNAL_REFERENCE, p_NEW_EXTERNAL_REFERENCE),
907 OLD_INVENTORY_ITEM_ID = decode( p_OLD_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, OLD_INVENTORY_ITEM_ID, p_OLD_INVENTORY_ITEM_ID),
908 NEW_INVENTORY_ITEM_ID = decode( p_NEW_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NEW_INVENTORY_ITEM_ID, p_NEW_INVENTORY_ITEM_ID),
909 OLD_INVENTORY_REVISION = decode( p_OLD_INVENTORY_REVISION, FND_API.G_MISS_CHAR, OLD_INVENTORY_REVISION, p_OLD_INVENTORY_REVISION),
910 NEW_INVENTORY_REVISION = decode( p_NEW_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NEW_INVENTORY_REVISION, p_NEW_INVENTORY_REVISION),
911 OLD_INV_MASTER_ORGANIZATION_ID = decode( p_OLD_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, OLD_INV_MASTER_ORGANIZATION_ID, p_OLD_INV_MASTER_ORGZN_ID),
912 NEW_INV_MASTER_ORGANIZATION_ID = decode( p_NEW_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, NEW_INV_MASTER_ORGANIZATION_ID, p_NEW_INV_MASTER_ORGZN_ID),
913 OLD_SERIAL_NUMBER = decode( p_OLD_SERIAL_NUMBER, FND_API.G_MISS_CHAR, OLD_SERIAL_NUMBER, p_OLD_SERIAL_NUMBER),
914 NEW_SERIAL_NUMBER = decode( p_NEW_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NEW_SERIAL_NUMBER, p_NEW_SERIAL_NUMBER),
915 OLD_MFG_SERIAL_NUMBER_FLAG = decode( p_OLD_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, OLD_MFG_SERIAL_NUMBER_FLAG, p_OLD_MFG_SERIAL_NUMBER_FLAG),
916 NEW_MFG_SERIAL_NUMBER_FLAG = decode( p_NEW_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NEW_MFG_SERIAL_NUMBER_FLAG, p_NEW_MFG_SERIAL_NUMBER_FLAG),
917 OLD_LOT_NUMBER = decode( p_OLD_LOT_NUMBER, FND_API.G_MISS_CHAR, OLD_LOT_NUMBER, p_OLD_LOT_NUMBER),
918 NEW_LOT_NUMBER = decode( p_NEW_LOT_NUMBER, FND_API.G_MISS_CHAR, NEW_LOT_NUMBER, p_NEW_LOT_NUMBER),
919 OLD_QUANTITY = decode( p_OLD_QUANTITY, FND_API.G_MISS_NUM, OLD_QUANTITY, p_OLD_QUANTITY),
920 NEW_QUANTITY = decode( p_NEW_QUANTITY, FND_API.G_MISS_NUM, NEW_QUANTITY, p_NEW_QUANTITY),
921 OLD_UNIT_OF_MEASURE = decode( p_OLD_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, OLD_UNIT_OF_MEASURE, p_OLD_UNIT_OF_MEASURE),
922 NEW_UNIT_OF_MEASURE = decode( p_NEW_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NEW_UNIT_OF_MEASURE, p_NEW_UNIT_OF_MEASURE),
923 OLD_ACCOUNTING_CLASS_CODE = decode( p_OLD_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, OLD_ACCOUNTING_CLASS_CODE, p_OLD_ACCOUNTING_CLASS_CODE),
924 NEW_ACCOUNTING_CLASS_CODE = decode( p_NEW_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NEW_ACCOUNTING_CLASS_CODE, p_NEW_ACCOUNTING_CLASS_CODE),
925 OLD_INSTANCE_CONDITION_ID = decode( p_OLD_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_CONDITION_ID, p_OLD_INSTANCE_CONDITION_ID),
926 NEW_INSTANCE_CONDITION_ID = decode( p_NEW_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_CONDITION_ID, p_NEW_INSTANCE_CONDITION_ID),
927 OLD_INSTANCE_STATUS_ID = decode( p_OLD_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_STATUS_ID, p_OLD_INSTANCE_STATUS_ID),
928 NEW_INSTANCE_STATUS_ID = decode( p_NEW_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_STATUS_ID, p_NEW_INSTANCE_STATUS_ID),
932 NEW_MERCHANT_VIEW_FLAG = decode( p_NEW_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NEW_MERCHANT_VIEW_FLAG, p_NEW_MERCHANT_VIEW_FLAG),
929 OLD_CUSTOMER_VIEW_FLAG = decode( p_OLD_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, OLD_CUSTOMER_VIEW_FLAG, p_OLD_CUSTOMER_VIEW_FLAG),
930 NEW_CUSTOMER_VIEW_FLAG = decode( p_NEW_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NEW_CUSTOMER_VIEW_FLAG, p_NEW_CUSTOMER_VIEW_FLAG),
931 OLD_MERCHANT_VIEW_FLAG = decode( p_OLD_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, OLD_MERCHANT_VIEW_FLAG, p_OLD_MERCHANT_VIEW_FLAG),
933 OLD_SELLABLE_FLAG = decode( p_OLD_SELLABLE_FLAG, FND_API.G_MISS_CHAR, OLD_SELLABLE_FLAG, p_OLD_SELLABLE_FLAG),
934 NEW_SELLABLE_FLAG = decode( p_NEW_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NEW_SELLABLE_FLAG, p_NEW_SELLABLE_FLAG),
935 OLD_SYSTEM_ID = decode( p_OLD_SYSTEM_ID, FND_API.G_MISS_NUM, OLD_SYSTEM_ID, p_OLD_SYSTEM_ID),
936 NEW_SYSTEM_ID = decode( p_NEW_SYSTEM_ID, FND_API.G_MISS_NUM, NEW_SYSTEM_ID, p_NEW_SYSTEM_ID),
937 OLD_INSTANCE_TYPE_CODE = decode( p_OLD_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, OLD_INSTANCE_TYPE_CODE, p_OLD_INSTANCE_TYPE_CODE),
938 NEW_INSTANCE_TYPE_CODE = decode( p_NEW_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_INSTANCE_TYPE_CODE, p_NEW_INSTANCE_TYPE_CODE),
939 OLD_ACTIVE_START_DATE = decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
940 NEW_ACTIVE_START_DATE = decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
941 OLD_ACTIVE_END_DATE = decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
942 NEW_ACTIVE_END_DATE = decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE),
943 OLD_LOCATION_TYPE_CODE = decode( p_OLD_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, OLD_LOCATION_TYPE_CODE, p_OLD_LOCATION_TYPE_CODE),
944 NEW_LOCATION_TYPE_CODE = decode( p_NEW_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_LOCATION_TYPE_CODE, p_NEW_LOCATION_TYPE_CODE),
945 OLD_LOCATION_ID = decode( p_OLD_LOCATION_ID, FND_API.G_MISS_NUM, OLD_LOCATION_ID, p_OLD_LOCATION_ID),
946 NEW_LOCATION_ID = decode( p_NEW_LOCATION_ID, FND_API.G_MISS_NUM, NEW_LOCATION_ID, p_NEW_LOCATION_ID),
947 OLD_INV_ORGANIZATION_ID = decode( p_OLD_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, OLD_INV_ORGANIZATION_ID, p_OLD_INV_ORGANIZATION_ID),
948 NEW_INV_ORGANIZATION_ID = decode( p_NEW_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NEW_INV_ORGANIZATION_ID, p_NEW_INV_ORGANIZATION_ID),
949 OLD_INV_SUBINVENTORY_NAME = decode( p_OLD_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, OLD_INV_SUBINVENTORY_NAME, p_OLD_INV_SUBINVENTORY_NAME),
950 NEW_INV_SUBINVENTORY_NAME = decode( p_NEW_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NEW_INV_SUBINVENTORY_NAME, p_NEW_INV_SUBINVENTORY_NAME),
951 OLD_INV_LOCATOR_ID = decode( p_OLD_INV_LOCATOR_ID, FND_API.G_MISS_NUM, OLD_INV_LOCATOR_ID, p_OLD_INV_LOCATOR_ID),
952 NEW_INV_LOCATOR_ID = decode( p_NEW_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NEW_INV_LOCATOR_ID, p_NEW_INV_LOCATOR_ID),
953 OLD_PA_PROJECT_ID = decode( p_OLD_PA_PROJECT_ID, FND_API.G_MISS_NUM, OLD_PA_PROJECT_ID, p_OLD_PA_PROJECT_ID),
954 NEW_PA_PROJECT_ID = decode( p_NEW_PA_PROJECT_ID, FND_API.G_MISS_NUM, NEW_PA_PROJECT_ID, p_NEW_PA_PROJECT_ID),
955 OLD_PA_PROJECT_TASK_ID = decode( p_OLD_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, OLD_PA_PROJECT_TASK_ID, p_OLD_PA_PROJECT_TASK_ID),
956 NEW_PA_PROJECT_TASK_ID = decode( p_NEW_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NEW_PA_PROJECT_TASK_ID, p_NEW_PA_PROJECT_TASK_ID),
957 OLD_IN_TRANSIT_ORDER_LINE_ID = decode( p_OLD_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, OLD_IN_TRANSIT_ORDER_LINE_ID, p_OLD_IN_TRANSIT_ORDER_LINE_ID),
958 NEW_IN_TRANSIT_ORDER_LINE_ID = decode( p_NEW_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NEW_IN_TRANSIT_ORDER_LINE_ID, p_NEW_IN_TRANSIT_ORDER_LINE_ID),
959 OLD_WIP_JOB_ID = decode( p_OLD_WIP_JOB_ID, FND_API.G_MISS_NUM, OLD_WIP_JOB_ID, p_OLD_WIP_JOB_ID),
960 NEW_WIP_JOB_ID = decode( p_NEW_WIP_JOB_ID, FND_API.G_MISS_NUM, NEW_WIP_JOB_ID, p_NEW_WIP_JOB_ID),
961 OLD_PO_ORDER_LINE_ID = decode( p_OLD_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, OLD_PO_ORDER_LINE_ID, p_OLD_PO_ORDER_LINE_ID),
962 NEW_PO_ORDER_LINE_ID = decode( p_NEW_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NEW_PO_ORDER_LINE_ID, p_NEW_PO_ORDER_LINE_ID),
963 OLD_COMPLETENESS_FLAG = decode( p_OLD_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, OLD_COMPLETENESS_FLAG, p_OLD_COMPLETENESS_FLAG),
964 NEW_COMPLETENESS_FLAG = decode( p_NEW_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NEW_COMPLETENESS_FLAG, p_NEW_COMPLETENESS_FLAG),
965 FULL_DUMP_FLAG = decode(p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
966 OLD_CONTEXT = decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, OLD_CONTEXT, p_OLD_CONTEXT),
967 NEW_CONTEXT = decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NEW_CONTEXT, p_NEW_CONTEXT),
968 OLD_ATTRIBUTE1 = decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE1, p_OLD_ATTRIBUTE1),
969 NEW_ATTRIBUTE1 = decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE1, p_NEW_ATTRIBUTE1),
970 OLD_ATTRIBUTE2 = decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE2, p_OLD_ATTRIBUTE2),
971 NEW_ATTRIBUTE2 = decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE2, p_NEW_ATTRIBUTE2),
972 OLD_ATTRIBUTE3 = decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE3, p_OLD_ATTRIBUTE3),
973 NEW_ATTRIBUTE3 = decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE3, p_NEW_ATTRIBUTE3),
974 OLD_ATTRIBUTE4 = decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE4, p_OLD_ATTRIBUTE4),
975 NEW_ATTRIBUTE4 = decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE4, p_NEW_ATTRIBUTE4),
976 OLD_ATTRIBUTE5 = decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE5, p_OLD_ATTRIBUTE5),
977 NEW_ATTRIBUTE5 = decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE5, p_NEW_ATTRIBUTE5),
978 OLD_ATTRIBUTE6 = decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE6, p_OLD_ATTRIBUTE6),
982 OLD_ATTRIBUTE8 = decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE8, p_OLD_ATTRIBUTE8),
979 NEW_ATTRIBUTE6 = decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE6, p_NEW_ATTRIBUTE6),
980 OLD_ATTRIBUTE7 = decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE7, p_OLD_ATTRIBUTE7),
981 NEW_ATTRIBUTE7 = decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE7, p_NEW_ATTRIBUTE7),
983 NEW_ATTRIBUTE8 = decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE8, p_NEW_ATTRIBUTE8),
984 OLD_ATTRIBUTE9 = decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE9, p_OLD_ATTRIBUTE9),
985 NEW_ATTRIBUTE9 = decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE9, p_NEW_ATTRIBUTE9),
986 OLD_ATTRIBUTE10 = decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE10, p_OLD_ATTRIBUTE10),
987 NEW_ATTRIBUTE10 = decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE10, p_NEW_ATTRIBUTE10),
988 OLD_ATTRIBUTE11 = decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE11, p_OLD_ATTRIBUTE11),
989 NEW_ATTRIBUTE11 = decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE11, p_NEW_ATTRIBUTE11),
990 OLD_ATTRIBUTE12 = decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE12, p_OLD_ATTRIBUTE12),
991 NEW_ATTRIBUTE12 = decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE12, p_NEW_ATTRIBUTE12),
992 OLD_ATTRIBUTE13 = decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE13, p_OLD_ATTRIBUTE13),
993 NEW_ATTRIBUTE13 = decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE13, p_NEW_ATTRIBUTE13),
994 OLD_ATTRIBUTE14 = decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE14, p_OLD_ATTRIBUTE14),
995 NEW_ATTRIBUTE14 = decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE14, p_NEW_ATTRIBUTE14),
996 OLD_ATTRIBUTE15 = decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE15, p_OLD_ATTRIBUTE15),
997 NEW_ATTRIBUTE15 = decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE15, p_NEW_ATTRIBUTE15),
998 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
999 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
1000 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
1001 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
1002 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
1003 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
1004 OLD_INST_LOC_TYPE_CODE = decode( p_OLD_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, OLD_INST_LOC_TYPE_CODE, p_OLD_INST_LOC_TYPE_CODE),
1005 NEW_INST_LOC_TYPE_CODE = decode( p_NEW_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_INST_LOC_TYPE_CODE, p_NEW_INST_LOC_TYPE_CODE),
1006 OLD_INST_LOC_ID = decode( p_OLD_INST_LOC_ID, FND_API.G_MISS_NUM, OLD_INST_LOC_ID, p_OLD_INST_LOC_ID),
1007 NEW_INST_LOC_ID = decode( p_NEW_INST_LOC_ID, FND_API.G_MISS_NUM, NEW_INST_LOC_ID, p_NEW_INST_LOC_ID),
1008 OLD_INST_USAGE_CODE = decode( p_OLD_INST_USAGE_CODE, FND_API.G_MISS_CHAR, OLD_INST_USAGE_CODE, p_OLD_INST_USAGE_CODE),
1009 NEW_INST_USAGE_CODE = decode( p_NEW_INST_USAGE_CODE, FND_API.G_MISS_CHAR, NEW_INST_USAGE_CODE, p_NEW_INST_USAGE_CODE),
1010 OLD_last_vld_organization_id = decode( p_OLD_last_vld_organization_id, FND_API.G_MISS_NUM, OLD_last_vld_organization_id, p_OLD_last_vld_organization_id),
1011 NEW_last_vld_organization_id = decode( p_NEW_last_vld_organization_id, FND_API.G_MISS_NUM, NEW_last_vld_organization_id, p_NEW_last_vld_organization_id),
1012 OLD_CONFIG_INST_REV_NUM = decode( p_OLD_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OLD_CONFIG_INST_REV_NUM, p_OLD_CONFIG_INST_REV_NUM),
1013 NEW_CONFIG_INST_REV_NUM = decode( p_NEW_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NEW_CONFIG_INST_REV_NUM, p_NEW_CONFIG_INST_REV_NUM),
1014 OLD_CONFIG_VALID_STATUS = decode( p_OLD_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, OLD_CONFIG_VALID_STATUS, p_OLD_CONFIG_VALID_STATUS),
1015 NEW_CONFIG_VALID_STATUS = decode( p_NEW_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NEW_CONFIG_VALID_STATUS, p_NEW_CONFIG_VALID_STATUS),
1016 OLD_INSTANCE_DESCRIPTION = decode( p_OLD_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, OLD_INSTANCE_DESCRIPTION, p_OLD_INSTANCE_DESCRIPTION),
1017 NEW_INSTANCE_DESCRIPTION = decode( p_NEW_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NEW_INSTANCE_DESCRIPTION, p_NEW_INSTANCE_DESCRIPTION),
1018 OLD_INSTALL_DATE = decode( p_OLD_INSTALL_DATE,FND_API.G_MISS_DATE, OLD_INSTALL_DATE, p_OLD_INSTALL_DATE),
1019 NEW_INSTALL_DATE = decode( p_NEW_INSTALL_DATE ,FND_API.G_MISS_DATE, NEW_INSTALL_DATE, p_NEW_INSTALL_DATE),
1020 OLD_RETURN_BY_DATE = decode( p_OLD_RETURN_BY_DATE,FND_API.G_MISS_DATE, OLD_RETURN_BY_DATE, p_OLD_RETURN_BY_DATE),
1021 NEW_RETURN_BY_DATE = decode( p_NEW_RETURN_BY_DATE,FND_API.G_MISS_DATE, NEW_RETURN_BY_DATE, p_NEW_RETURN_BY_DATE),
1022 OLD_ACTUAL_RETURN_DATE = decode( p_OLD_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, OLD_ACTUAL_RETURN_DATE, p_OLD_ACTUAL_RETURN_DATE),
1023 NEW_ACTUAL_RETURN_DATE = decode( p_NEW_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, NEW_ACTUAL_RETURN_DATE, p_NEW_ACTUAL_RETURN_DATE),
1024 OLD_OE_AGREEMENT_ID = decode(p_OLD_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM,OLD_OE_AGREEMENT_ID,p_OLD_LAST_OE_AGREEMENT_ID),
1025 NEW_OE_AGREEMENT_ID = decode(p_NEW_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM,NEW_OE_AGREEMENT_ID,p_NEW_LAST_OE_AGREEMENT_ID),
1026 OLD_LAST_OE_ORDER_LINE_ID = decode(p_OLD_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,OLD_LAST_OE_ORDER_LINE_ID,p_OLD_LAST_OE_ORDER_LINE_ID),
1027 NEW_LAST_OE_ORDER_LINE_ID = decode(p_NEW_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,NEW_LAST_OE_ORDER_LINE_ID,p_NEW_LAST_OE_ORDER_LINE_ID),
1028 OLD_LAST_OE_RMA_LINE_ID = decode(p_OLD_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,OLD_LAST_OE_RMA_LINE_ID,p_OLD_LAST_OE_RMA_LINE_ID),
1032 OLD_LAST_PO_PO_LINE_ID = decode(p_OLD_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,OLD_LAST_PO_PO_LINE_ID,p_OLD_LAST_PO_PO_LINE_ID),
1029 NEW_LAST_OE_RMA_LINE_ID = decode(p_NEW_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,NEW_LAST_OE_RMA_LINE_ID,p_NEW_LAST_OE_RMA_LINE_ID),
1030 OLD_LAST_WIP_JOB_ID = decode(p_OLD_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,OLD_LAST_WIP_JOB_ID,p_OLD_LAST_WIP_JOB_ID),
1031 NEW_LAST_WIP_JOB_ID = decode(p_NEW_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,NEW_LAST_WIP_JOB_ID,p_NEW_LAST_WIP_JOB_ID),
1033 NEW_LAST_PO_PO_LINE_ID = decode(p_NEW_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,NEW_LAST_PO_PO_LINE_ID,p_NEW_LAST_PO_PO_LINE_ID),
1034 OLD_LAST_PA_PROJECT_ID = decode(p_OLD_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,OLD_LAST_PA_PROJECT_ID,p_OLD_LAST_PA_PROJECT_ID),
1035 NEW_LAST_PA_PROJECT_ID = decode(p_NEW_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,NEW_LAST_PA_PROJECT_ID,p_NEW_LAST_PA_PROJECT_ID),
1036 OLD_LAST_PA_TASK_ID = decode(p_OLD_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,OLD_LAST_PA_TASK_ID,p_OLD_LAST_PA_TASK_ID),
1037 NEW_LAST_PA_TASK_ID = decode(p_NEW_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,NEW_LAST_PA_TASK_ID,p_NEW_LAST_PA_TASK_ID),
1038 OLD_LAST_TXN_LINE_DETAIL_ID = decode(p_OLD_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,OLD_LAST_TXN_LINE_DETAIL_ID,p_OLD_LAST_TXN_LINE_DETAIL_ID),
1039 NEW_LAST_TXN_LINE_DETAIL_ID = decode(p_NEW_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,NEW_LAST_TXN_LINE_DETAIL_ID,p_NEW_LAST_TXN_LINE_DETAIL_ID),
1040 OLD_LAST_OE_PO_NUMBER = decode(p_OLD_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR,OLD_LAST_OE_PO_NUMBER,p_OLD_LAST_OE_PO_NUMBER),
1041 NEW_LAST_OE_PO_NUMBER = decode(p_NEW_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR,NEW_LAST_OE_PO_NUMBER,p_NEW_LAST_OE_PO_NUMBER),
1042 --start of eam integration changes--
1043 OLD_NETWORK_ASSET_FLAG = decode( p_OLD_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, OLD_NETWORK_ASSET_FLAG, p_OLD_NETWORK_ASSET_FLAG),
1044 NEW_NETWORK_ASSET_FLAG = decode( p_NEW_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NEW_NETWORK_ASSET_FLAG, p_NEW_NETWORK_ASSET_FLAG),
1045 OLD_MAINTAINABLE_FLAG = decode( p_OLD_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, OLD_MAINTAINABLE_FLAG, p_OLD_MAINTAINABLE_FLAG),
1046 NEW_MAINTAINABLE_FLAG = decode( p_NEW_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NEW_MAINTAINABLE_FLAG, p_NEW_MAINTAINABLE_FLAG),
1047 OLD_PN_LOCATION_ID = decode( p_OLD_PN_LOCATION_ID, FND_API.G_MISS_NUM, OLD_PN_LOCATION_ID, p_OLD_PN_LOCATION_ID),
1048 NEW_PN_LOCATION_ID = decode( p_NEW_PN_LOCATION_ID, FND_API.G_MISS_NUM, NEW_PN_LOCATION_ID, p_NEW_PN_LOCATION_ID),
1049 OLD_ASSET_CRITICALITY_CODE = decode( p_OLD_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, OLD_ASSET_CRITICALITY_CODE, p_OLD_ASSET_CRITICALITY_CODE),
1050 NEW_ASSET_CRITICALITY_CODE = decode( p_NEW_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NEW_ASSET_CRITICALITY_CODE, p_NEW_ASSET_CRITICALITY_CODE),
1051 OLD_CATEGORY_ID = decode( p_OLD_CATEGORY_ID, FND_API.G_MISS_NUM, OLD_CATEGORY_ID, p_OLD_CATEGORY_ID),
1052 NEW_CATEGORY_ID = decode( p_NEW_CATEGORY_ID, FND_API.G_MISS_NUM, NEW_CATEGORY_ID, p_NEW_CATEGORY_ID),
1053 OLD_EQUIPMENT_GEN_OBJECT_ID = decode( p_OLD_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, OLD_EQUIPMENT_GEN_OBJECT_ID, p_OLD_EQUIPMENT_GEN_OBJECT_ID),
1054 NEW_EQUIPMENT_GEN_OBJECT_ID = decode( p_NEW_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NEW_EQUIPMENT_GEN_OBJECT_ID, p_NEW_EQUIPMENT_GEN_OBJECT_ID),
1055 OLD_INSTANTIATION_FLAG = decode( p_OLD_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, OLD_INSTANTIATION_FLAG, p_OLD_INSTANTIATION_FLAG),
1056 NEW_INSTANTIATION_FLAG = decode( p_NEW_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NEW_INSTANTIATION_FLAG, p_NEW_INSTANTIATION_FLAG),
1057 OLD_LINEAR_LOCATION_ID = decode( p_OLD_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, OLD_LINEAR_LOCATION_ID, p_OLD_LINEAR_LOCATION_ID),
1058 NEW_LINEAR_LOCATION_ID = decode( p_NEW_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NEW_LINEAR_LOCATION_ID, p_NEW_LINEAR_LOCATION_ID),
1059 OLD_OPERATIONAL_LOG_FLAG = decode( p_OLD_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OLD_OPERATIONAL_LOG_FLAG, p_OLD_OPERATIONAL_LOG_FLAG),
1060 NEW_OPERATIONAL_LOG_FLAG = decode( p_NEW_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NEW_OPERATIONAL_LOG_FLAG, p_NEW_OPERATIONAL_LOG_FLAG),
1061 OLD_CHECKIN_STATUS = decode( p_OLD_CHECKIN_STATUS, FND_API.G_MISS_NUM, OLD_CHECKIN_STATUS, p_OLD_CHECKIN_STATUS),
1062 NEW_CHECKIN_STATUS = decode( p_NEW_CHECKIN_STATUS, FND_API.G_MISS_NUM, NEW_CHECKIN_STATUS, p_NEW_CHECKIN_STATUS),
1063 OLD_SUPPLIER_WARRANTY_EXP_DATE = decode( p_OLD_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, OLD_SUPPLIER_WARRANTY_EXP_DATE, p_OLD_SUP_WARRANTY_EXP_DATE),
1064 NEW_SUPPLIER_WARRANTY_EXP_DATE = decode( p_NEW_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, NEW_SUPPLIER_WARRANTY_EXP_DATE, p_NEW_SUP_WARRANTY_EXP_DATE),
1065 OLD_ATTRIBUTE16 = decode( p_OLD_ATTRIBUTE16, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE16, p_OLD_ATTRIBUTE16),
1066 NEW_ATTRIBUTE16 = decode( p_NEW_ATTRIBUTE16, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE16, p_NEW_ATTRIBUTE16),
1067 OLD_ATTRIBUTE17 = decode( p_OLD_ATTRIBUTE17, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE17, p_OLD_ATTRIBUTE17),
1068 NEW_ATTRIBUTE17 = decode( p_NEW_ATTRIBUTE17, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE17, p_NEW_ATTRIBUTE17),
1069 OLD_ATTRIBUTE18 = decode( p_OLD_ATTRIBUTE18, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE18, p_OLD_ATTRIBUTE18),
1070 NEW_ATTRIBUTE18 = decode( p_NEW_ATTRIBUTE18, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE18, p_NEW_ATTRIBUTE18),
1071 OLD_ATTRIBUTE19 = decode( p_OLD_ATTRIBUTE19, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE19, p_OLD_ATTRIBUTE19),
1072 NEW_ATTRIBUTE19 = decode( p_NEW_ATTRIBUTE19, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE19, p_NEW_ATTRIBUTE19),
1073 OLD_ATTRIBUTE20 = decode( p_OLD_ATTRIBUTE20, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE20, p_OLD_ATTRIBUTE20),
1074 NEW_ATTRIBUTE20 = decode( p_NEW_ATTRIBUTE20, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE20, p_NEW_ATTRIBUTE20),
1075 OLD_ATTRIBUTE21 = decode( p_OLD_ATTRIBUTE21, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE21, p_OLD_ATTRIBUTE21),
1076 NEW_ATTRIBUTE21 = decode( p_NEW_ATTRIBUTE21, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE21, p_NEW_ATTRIBUTE21),
1077 OLD_ATTRIBUTE22 = decode( p_OLD_ATTRIBUTE22, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE22, p_OLD_ATTRIBUTE22),
1078 NEW_ATTRIBUTE22 = decode( p_NEW_ATTRIBUTE22, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE22, p_NEW_ATTRIBUTE22),
1082 NEW_ATTRIBUTE24 = decode( p_NEW_ATTRIBUTE24, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE24, p_NEW_ATTRIBUTE24),
1079 OLD_ATTRIBUTE23 = decode( p_OLD_ATTRIBUTE23, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE23, p_OLD_ATTRIBUTE23),
1080 NEW_ATTRIBUTE23 = decode( p_NEW_ATTRIBUTE23, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE23, p_NEW_ATTRIBUTE23),
1081 OLD_ATTRIBUTE24 = decode( p_OLD_ATTRIBUTE24, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE24, p_OLD_ATTRIBUTE24),
1083 OLD_ATTRIBUTE25 = decode( p_OLD_ATTRIBUTE25, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE25, p_OLD_ATTRIBUTE25),
1084 NEW_ATTRIBUTE25 = decode( p_NEW_ATTRIBUTE25, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE25, p_NEW_ATTRIBUTE25),
1085 OLD_ATTRIBUTE26 = decode( p_OLD_ATTRIBUTE26, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE26, p_OLD_ATTRIBUTE26),
1086 NEW_ATTRIBUTE26 = decode( p_NEW_ATTRIBUTE26, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE26, p_NEW_ATTRIBUTE26),
1087 OLD_ATTRIBUTE27 = decode( p_OLD_ATTRIBUTE27, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE27, p_OLD_ATTRIBUTE27),
1088 NEW_ATTRIBUTE27 = decode( p_NEW_ATTRIBUTE27, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE27, p_NEW_ATTRIBUTE27),
1089 OLD_ATTRIBUTE28 = decode( p_OLD_ATTRIBUTE28, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE28, p_OLD_ATTRIBUTE28),
1090 NEW_ATTRIBUTE28 = decode( p_NEW_ATTRIBUTE28, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE28, p_NEW_ATTRIBUTE28),
1091 OLD_ATTRIBUTE29 = decode( p_OLD_ATTRIBUTE29, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE29, p_OLD_ATTRIBUTE29),
1092 NEW_ATTRIBUTE29 = decode( p_NEW_ATTRIBUTE29, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE29, p_NEW_ATTRIBUTE29),
1093 OLD_ATTRIBUTE30 = decode( p_OLD_ATTRIBUTE30, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE30, p_OLD_ATTRIBUTE30),
1094 NEW_ATTRIBUTE30 = decode( p_NEW_ATTRIBUTE30, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE30, p_NEW_ATTRIBUTE30),
1095 --end of eam integration changes--
1096 -- Addition of columns for FA Integration
1097 OLD_PAYABLES_UNIT_PRICE = decode( p_OLD_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, OLD_PAYABLES_UNIT_PRICE, p_OLD_PAYABLES_UNIT_PRICE),
1098 NEW_PAYABLES_UNIT_PRICE = decode( p_NEW_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NEW_PAYABLES_UNIT_PRICE, p_NEW_PAYABLES_UNIT_PRICE),
1099 OLD_PAYABLES_CURRENCY_CODE = decode( p_OLD_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_PAYABLES_CURRENCY_CODE, p_OLD_PAYABLES_CURRENCY_CODE),
1100 NEW_PAYABLES_CURRENCY_CODE = decode( p_NEW_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_PAYABLES_CURRENCY_CODE, p_NEW_PAYABLES_CURRENCY_CODE),
1101 OLD_PURCHASE_UNIT_PRICE = decode( p_OLD_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, OLD_PURCHASE_UNIT_PRICE, p_OLD_PURCHASE_UNIT_PRICE),
1102 NEW_PURCHASE_UNIT_PRICE = decode( p_NEW_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NEW_PURCHASE_UNIT_PRICE, p_NEW_PURCHASE_UNIT_PRICE),
1103 OLD_PURCHASE_CURRENCY_CODE = decode( p_OLD_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_PURCHASE_CURRENCY_CODE, p_OLD_PURCHASE_CURRENCY_CODE),
1104 NEW_PURCHASE_CURRENCY_CODE = decode( p_NEW_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_PURCHASE_CURRENCY_CODE, p_NEW_PURCHASE_CURRENCY_CODE),
1105 OLD_SALES_UNIT_PRICE = decode( p_OLD_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, OLD_SALES_UNIT_PRICE, p_OLD_SALES_UNIT_PRICE),
1106 NEW_SALES_UNIT_PRICE = decode( p_NEW_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NEW_SALES_UNIT_PRICE, p_NEW_SALES_UNIT_PRICE),
1107 OLD_SALES_CURRENCY_CODE = decode( p_OLD_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_SALES_CURRENCY_CODE, p_OLD_SALES_CURRENCY_CODE),
1108 NEW_SALES_CURRENCY_CODE = decode( p_NEW_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_SALES_CURRENCY_CODE, p_NEW_SALES_CURRENCY_CODE),
1109 OLD_OPERATIONAL_STATUS_CODE = decode( p_OLD_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OLD_OPERATIONAL_STATUS_CODE, p_OLD_OPERATIONAL_STATUS_CODE),
1110 NEW_OPERATIONAL_STATUS_CODE = decode( p_NEW_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NEW_OPERATIONAL_STATUS_CODE, p_NEW_OPERATIONAL_STATUS_CODE),
1111 -- End addition of columns for FA Integration
1112 -- Begin Add Code for Siebel Genesis Project
1113 OLD_SOURCE_CODE = decode(p_OLD_SOURCE_CODE,FND_API.G_MISS_CHAR,OLD_SOURCE_CODE,p_OLD_SOURCE_CODE),
1114 NEW_SOURCE_CODE = decode(p_NEW_SOURCE_CODE,FND_API.G_MISS_CHAR,NEW_SOURCE_CODE,p_NEW_SOURCE_CODE)
1115 -- End Add Code for Siebel Genesis Project
1116 WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID;
1117
1118 IF (SQL%NOTFOUND) THEN
1119 RAISE NO_DATA_FOUND;
1120 END IF;
1121 END Update_Row;
1122
1123 PROCEDURE Delete_Row(
1124 p_INSTANCE_HISTORY_ID NUMBER)
1125 IS
1126 BEGIN
1127 DELETE FROM CSI_ITEM_INSTANCES_H
1128 WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID;
1129 If (SQL%NOTFOUND) then
1130 RAISE NO_DATA_FOUND;
1131 End If;
1132 END Delete_Row;
1133
1134 PROCEDURE Lock_Row(
1135 p_INSTANCE_HISTORY_ID NUMBER,
1136 p_INSTANCE_ID NUMBER,
1137 p_TRANSACTION_ID NUMBER,
1138 p_OLD_INSTANCE_NUMBER VARCHAR2,
1139 p_NEW_INSTANCE_NUMBER VARCHAR2,
1140 p_OLD_EXTERNAL_REFERENCE VARCHAR2,
1141 p_NEW_EXTERNAL_REFERENCE VARCHAR2,
1142 p_OLD_INVENTORY_ITEM_ID NUMBER,
1143 p_NEW_INVENTORY_ITEM_ID NUMBER,
1144 p_OLD_INVENTORY_REVISION VARCHAR2,
1145 p_NEW_INVENTORY_REVISION VARCHAR2,
1146 p_OLD_INV_MASTER_ORGZN_ID NUMBER,
1147 p_NEW_INV_MASTER_ORGZN_ID NUMBER,
1148 p_OLD_SERIAL_NUMBER VARCHAR2,
1149 p_NEW_SERIAL_NUMBER VARCHAR2,
1150 p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
1151 p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
1152 p_OLD_LOT_NUMBER VARCHAR2,
1153 p_NEW_LOT_NUMBER VARCHAR2,
1154 p_OLD_QUANTITY NUMBER,
1155 p_NEW_QUANTITY NUMBER,
1156 p_OLD_UNIT_OF_MEASURE VARCHAR2,
1157 p_NEW_UNIT_OF_MEASURE VARCHAR2,
1158 p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
1159 p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
1160 p_OLD_INSTANCE_CONDITION_ID NUMBER,
1164 p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
1161 p_NEW_INSTANCE_CONDITION_ID NUMBER,
1162 p_OLD_INSTANCE_STATUS_ID NUMBER,
1163 p_NEW_INSTANCE_STATUS_ID NUMBER,
1165 p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
1166 p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
1167 p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
1168 p_OLD_SELLABLE_FLAG VARCHAR2,
1169 p_NEW_SELLABLE_FLAG VARCHAR2,
1170 p_OLD_SYSTEM_ID NUMBER,
1171 p_NEW_SYSTEM_ID NUMBER,
1172 p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
1173 p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
1174 p_OLD_ACTIVE_START_DATE DATE,
1175 p_NEW_ACTIVE_START_DATE DATE,
1176 p_OLD_ACTIVE_END_DATE DATE,
1177 p_NEW_ACTIVE_END_DATE DATE,
1178 p_OLD_LOCATION_TYPE_CODE VARCHAR2,
1179 p_NEW_LOCATION_TYPE_CODE VARCHAR2,
1180 p_OLD_LOCATION_ID NUMBER,
1181 p_NEW_LOCATION_ID NUMBER,
1182 p_OLD_INV_ORGANIZATION_ID NUMBER,
1183 p_NEW_INV_ORGANIZATION_ID NUMBER,
1184 p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
1185 p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
1186 p_OLD_INV_LOCATOR_ID NUMBER,
1187 p_NEW_INV_LOCATOR_ID NUMBER,
1188 p_OLD_PA_PROJECT_ID NUMBER,
1189 p_NEW_PA_PROJECT_ID NUMBER,
1190 p_OLD_PA_PROJECT_TASK_ID NUMBER,
1191 p_NEW_PA_PROJECT_TASK_ID NUMBER,
1192 p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
1193 p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
1194 p_OLD_WIP_JOB_ID NUMBER,
1195 p_NEW_WIP_JOB_ID NUMBER,
1196 p_OLD_PO_ORDER_LINE_ID NUMBER,
1197 p_NEW_PO_ORDER_LINE_ID NUMBER,
1198 p_OLD_COMPLETENESS_FLAG VARCHAR2,
1199 p_NEW_COMPLETENESS_FLAG VARCHAR2,
1200 p_FULL_DUMP_FLAG VARCHAR2,
1201 p_OLD_CONTEXT VARCHAR2,
1202 p_NEW_CONTEXT VARCHAR2,
1203 p_OLD_ATTRIBUTE1 VARCHAR2,
1204 p_NEW_ATTRIBUTE1 VARCHAR2,
1205 p_OLD_ATTRIBUTE2 VARCHAR2,
1206 p_NEW_ATTRIBUTE2 VARCHAR2,
1207 p_OLD_ATTRIBUTE3 VARCHAR2,
1208 p_NEW_ATTRIBUTE3 VARCHAR2,
1209 p_OLD_ATTRIBUTE4 VARCHAR2,
1210 p_NEW_ATTRIBUTE4 VARCHAR2,
1211 p_OLD_ATTRIBUTE5 VARCHAR2,
1212 p_NEW_ATTRIBUTE5 VARCHAR2,
1213 p_OLD_ATTRIBUTE6 VARCHAR2,
1214 p_NEW_ATTRIBUTE6 VARCHAR2,
1215 p_OLD_ATTRIBUTE7 VARCHAR2,
1216 p_NEW_ATTRIBUTE7 VARCHAR2,
1217 p_OLD_ATTRIBUTE8 VARCHAR2,
1218 p_NEW_ATTRIBUTE8 VARCHAR2,
1219 p_OLD_ATTRIBUTE9 VARCHAR2,
1220 p_NEW_ATTRIBUTE9 VARCHAR2,
1221 p_OLD_ATTRIBUTE10 VARCHAR2,
1222 p_NEW_ATTRIBUTE10 VARCHAR2,
1223 p_OLD_ATTRIBUTE11 VARCHAR2,
1224 p_NEW_ATTRIBUTE11 VARCHAR2,
1225 p_OLD_ATTRIBUTE12 VARCHAR2,
1226 p_NEW_ATTRIBUTE12 VARCHAR2,
1227 p_OLD_ATTRIBUTE13 VARCHAR2,
1228 p_NEW_ATTRIBUTE13 VARCHAR2,
1229 p_OLD_ATTRIBUTE14 VARCHAR2,
1230 p_NEW_ATTRIBUTE14 VARCHAR2,
1231 p_OLD_ATTRIBUTE15 VARCHAR2,
1232 p_NEW_ATTRIBUTE15 VARCHAR2,
1233 p_CREATED_BY NUMBER,
1234 p_CREATION_DATE DATE,
1235 p_LAST_UPDATED_BY NUMBER,
1236 p_LAST_UPDATE_DATE DATE,
1237 p_LAST_UPDATE_LOGIN NUMBER,
1238 p_OBJECT_VERSION_NUMBER NUMBER,
1239 p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
1240 p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
1241 p_OLD_INST_LOC_ID NUMBER,
1242 p_NEW_INST_LOC_ID NUMBER,
1243 p_OLD_INST_USAGE_CODE VARCHAR2,
1244 p_NEW_INST_USAGE_CODE VARCHAR2,
1245 p_OLD_CONFIG_INST_REV_NUM NUMBER,
1246 p_NEW_CONFIG_INST_REV_NUM NUMBER,
1247 p_OLD_CONFIG_VALID_STATUS VARCHAR2,
1248 p_NEW_CONFIG_VALID_STATUS VARCHAR2,
1249 p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
1250 p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
1251 p_OLD_LAST_OE_AGREEMENT_ID NUMBER,
1252 p_NEW_LAST_OE_AGREEMENT_ID NUMBER,
1253 p_OLD_LAST_OE_ORDER_LINE_ID NUMBER ,
1254 p_NEW_LAST_OE_ORDER_LINE_ID NUMBER ,
1255 p_OLD_LAST_OE_RMA_LINE_ID NUMBER ,
1256 p_NEW_LAST_OE_RMA_LINE_ID NUMBER ,
1257 p_OLD_LAST_WIP_JOB_ID NUMBER ,
1258 p_NEW_LAST_WIP_JOB_ID NUMBER ,
1259 p_OLD_LAST_PO_PO_LINE_ID NUMBER ,
1260 p_NEW_LAST_PO_PO_LINE_ID NUMBER ,
1261 p_OLD_LAST_PA_PROJECT_ID NUMBER ,
1262 p_NEW_LAST_PA_PROJECT_ID NUMBER ,
1263 p_OLD_LAST_PA_TASK_ID NUMBER ,
1264 p_NEW_LAST_PA_TASK_ID NUMBER ,
1265 p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER ,
1266 p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER ,
1267 p_OLD_LAST_OE_PO_NUMBER VARCHAR2,
1268 p_NEW_LAST_OE_PO_NUMBER VARCHAR2,
1269 --start of eam integration changes--
1270 p_OLD_NETWORK_ASSET_FLAG VARCHAR2,
1271 p_NEW_NETWORK_ASSET_FLAG VARCHAR2,
1272 p_OLD_MAINTAINABLE_FLAG VARCHAR2,
1273 p_NEW_MAINTAINABLE_FLAG VARCHAR2,
1274 p_OLD_PN_LOCATION_ID NUMBER,
1275 p_NEW_PN_LOCATION_ID NUMBER,
1276 p_OLD_ASSET_CRITICALITY_CODE VARCHAR2,
1277 p_NEW_ASSET_CRITICALITY_CODE VARCHAR2,
1278 p_OLD_CATEGORY_ID NUMBER,
1279 p_NEW_CATEGORY_ID NUMBER,
1280 p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER,
1281 p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER,
1282 p_OLD_INSTANTIATION_FLAG VARCHAR2,
1286 p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2,
1283 p_NEW_INSTANTIATION_FLAG VARCHAR2,
1284 p_OLD_LINEAR_LOCATION_ID NUMBER,
1285 p_NEW_LINEAR_LOCATION_ID NUMBER,
1287 p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2,
1288 p_OLD_CHECKIN_STATUS NUMBER,
1289 p_NEW_CHECKIN_STATUS NUMBER,
1290 p_OLD_SUP_WARRANTY_EXP_DATE DATE,
1291 p_NEW_SUP_WARRANTY_EXP_DATE DATE,
1292 p_OLD_ATTRIBUTE16 VARCHAR2,
1293 p_NEW_ATTRIBUTE16 VARCHAR2,
1294 p_OLD_ATTRIBUTE17 VARCHAR2,
1295 p_NEW_ATTRIBUTE17 VARCHAR2,
1296 p_OLD_ATTRIBUTE18 VARCHAR2,
1297 p_NEW_ATTRIBUTE18 VARCHAR2,
1298 p_OLD_ATTRIBUTE19 VARCHAR2,
1299 p_NEW_ATTRIBUTE19 VARCHAR2,
1300 p_OLD_ATTRIBUTE20 VARCHAR2,
1301 p_NEW_ATTRIBUTE20 VARCHAR2,
1302 p_OLD_ATTRIBUTE21 VARCHAR2,
1303 p_NEW_ATTRIBUTE21 VARCHAR2,
1304 p_OLD_ATTRIBUTE22 VARCHAR2,
1305 p_NEW_ATTRIBUTE22 VARCHAR2,
1306 p_OLD_ATTRIBUTE23 VARCHAR2,
1307 p_NEW_ATTRIBUTE23 VARCHAR2,
1308 p_OLD_ATTRIBUTE24 VARCHAR2,
1309 p_NEW_ATTRIBUTE24 VARCHAR2,
1310 p_OLD_ATTRIBUTE25 VARCHAR2,
1311 p_NEW_ATTRIBUTE25 VARCHAR2,
1312 p_OLD_ATTRIBUTE26 VARCHAR2,
1313 p_NEW_ATTRIBUTE26 VARCHAR2,
1314 p_OLD_ATTRIBUTE27 VARCHAR2,
1315 p_NEW_ATTRIBUTE27 VARCHAR2,
1316 p_OLD_ATTRIBUTE28 VARCHAR2,
1317 p_NEW_ATTRIBUTE28 VARCHAR2,
1318 p_OLD_ATTRIBUTE29 VARCHAR2,
1319 p_NEW_ATTRIBUTE29 VARCHAR2,
1320 p_OLD_ATTRIBUTE30 VARCHAR2,
1321 p_NEW_ATTRIBUTE30 VARCHAR2,
1322 --end of eam integration changes--
1323 -- Addition of columns for FA Integration
1324 p_OLD_PAYABLES_UNIT_PRICE NUMBER,
1325 p_NEW_PAYABLES_UNIT_PRICE NUMBER,
1326 p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2,
1327 p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2,
1328 p_OLD_PURCHASE_UNIT_PRICE NUMBER,
1329 p_NEW_PURCHASE_UNIT_PRICE NUMBER,
1330 p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2,
1331 p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2,
1332 p_OLD_SALES_UNIT_PRICE NUMBER,
1333 p_NEW_SALES_UNIT_PRICE NUMBER,
1334 p_OLD_SALES_CURRENCY_CODE VARCHAR2,
1335 p_NEW_SALES_CURRENCY_CODE VARCHAR2,
1336 p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2,
1337 p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2,
1338 -- End addition of columns for FA Integration
1339 -- Begin Add Code for Siebel Genesis Project
1340 p_OLD_SOURCE_CODE VARCHAR2,
1341 p_NEW_SOURCE_CODE VARCHAR2
1342 -- End Add Code for Siebel Genesis Project
1343 )
1344
1345 IS
1346 CURSOR C IS
1347 SELECT *
1348 FROM CSI_ITEM_INSTANCES_H
1349 WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID
1350 FOR UPDATE of INSTANCE_HISTORY_ID NOWAIT;
1351 Recinfo C%ROWTYPE;
1352 BEGIN
1353 OPEN C;
1354 FETCH C INTO Recinfo;
1355 IF (C%NOTFOUND) THEN
1356 CLOSE C;
1357 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1358 APP_EXCEPTION.RAISE_EXCEPTION;
1359 END IF;
1360 CLOSE C;
1361 IF (
1362 ( Recinfo.INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID)
1363 AND ( ( Recinfo.INSTANCE_ID = p_INSTANCE_ID)
1364 OR ( ( Recinfo.INSTANCE_ID IS NULL )
1365 AND ( p_INSTANCE_ID IS NULL )))
1366 AND ( ( Recinfo.TRANSACTION_ID = p_TRANSACTION_ID)
1367 OR ( ( Recinfo.TRANSACTION_ID IS NULL )
1368 AND ( p_TRANSACTION_ID IS NULL )))
1369 AND ( ( Recinfo.OLD_INSTANCE_NUMBER = p_OLD_INSTANCE_NUMBER)
1370 OR ( ( Recinfo.OLD_INSTANCE_NUMBER IS NULL )
1371 AND ( p_OLD_INSTANCE_NUMBER IS NULL )))
1372 AND ( ( Recinfo.NEW_INSTANCE_NUMBER = p_NEW_INSTANCE_NUMBER)
1373 OR ( ( Recinfo.NEW_INSTANCE_NUMBER IS NULL )
1374 AND ( p_NEW_INSTANCE_NUMBER IS NULL )))
1375 AND ( ( Recinfo.OLD_EXTERNAL_REFERENCE = p_OLD_EXTERNAL_REFERENCE)
1376 OR ( ( Recinfo.OLD_EXTERNAL_REFERENCE IS NULL )
1377 AND ( p_OLD_EXTERNAL_REFERENCE IS NULL )))
1378 AND ( ( Recinfo.NEW_EXTERNAL_REFERENCE = p_NEW_EXTERNAL_REFERENCE)
1379 OR ( ( Recinfo.NEW_EXTERNAL_REFERENCE IS NULL )
1380 AND ( p_NEW_EXTERNAL_REFERENCE IS NULL )))
1381 AND ( ( Recinfo.OLD_INVENTORY_ITEM_ID = p_OLD_INVENTORY_ITEM_ID)
1382 OR ( ( Recinfo.OLD_INVENTORY_ITEM_ID IS NULL )
1383 AND ( p_OLD_INVENTORY_ITEM_ID IS NULL )))
1384 AND ( ( Recinfo.NEW_INVENTORY_ITEM_ID = p_NEW_INVENTORY_ITEM_ID)
1385 OR ( ( Recinfo.NEW_INVENTORY_ITEM_ID IS NULL )
1386 AND ( p_NEW_INVENTORY_ITEM_ID IS NULL )))
1387 AND ( ( Recinfo.OLD_INVENTORY_REVISION = p_OLD_INVENTORY_REVISION)
1388 OR ( ( Recinfo.OLD_INVENTORY_REVISION IS NULL )
1389 AND ( p_OLD_INVENTORY_REVISION IS NULL )))
1390 AND ( ( Recinfo.NEW_INVENTORY_REVISION = p_NEW_INVENTORY_REVISION)
1391 OR ( ( Recinfo.NEW_INVENTORY_REVISION IS NULL )
1392 AND ( p_NEW_INVENTORY_REVISION IS NULL )))
1393 AND ( ( Recinfo.OLD_INV_MASTER_ORGANIZATION_ID = p_OLD_INV_MASTER_ORGZN_ID)
1394 OR ( ( Recinfo.OLD_INV_MASTER_ORGANIZATION_ID IS NULL )
1395 AND ( p_OLD_INV_MASTER_ORGZN_ID IS NULL )))
1396 AND ( ( Recinfo.NEW_INV_MASTER_ORGANIZATION_ID = p_NEW_INV_MASTER_ORGZN_ID)
1397 OR ( ( Recinfo.NEW_INV_MASTER_ORGANIZATION_ID IS NULL )
1398 AND ( p_NEW_INV_MASTER_ORGZN_ID IS NULL )))
1402 AND ( ( Recinfo.NEW_SERIAL_NUMBER = p_NEW_SERIAL_NUMBER)
1399 AND ( ( Recinfo.OLD_SERIAL_NUMBER = p_OLD_SERIAL_NUMBER)
1400 OR ( ( Recinfo.OLD_SERIAL_NUMBER IS NULL )
1401 AND ( p_OLD_SERIAL_NUMBER IS NULL )))
1403 OR ( ( Recinfo.NEW_SERIAL_NUMBER IS NULL )
1404 AND ( p_NEW_SERIAL_NUMBER IS NULL )))
1405 AND ( ( Recinfo.OLD_MFG_SERIAL_NUMBER_FLAG = p_OLD_MFG_SERIAL_NUMBER_FLAG)
1406 OR ( ( Recinfo.OLD_MFG_SERIAL_NUMBER_FLAG IS NULL )
1407 AND ( p_OLD_MFG_SERIAL_NUMBER_FLAG IS NULL )))
1408 AND ( ( Recinfo.NEW_MFG_SERIAL_NUMBER_FLAG = p_NEW_MFG_SERIAL_NUMBER_FLAG)
1409 OR ( ( Recinfo.NEW_MFG_SERIAL_NUMBER_FLAG IS NULL )
1410 AND ( p_NEW_MFG_SERIAL_NUMBER_FLAG IS NULL )))
1411 AND ( ( Recinfo.OLD_LOT_NUMBER = p_OLD_LOT_NUMBER)
1412 OR ( ( Recinfo.OLD_LOT_NUMBER IS NULL )
1413 AND ( p_OLD_LOT_NUMBER IS NULL )))
1414 AND ( ( Recinfo.NEW_LOT_NUMBER = p_NEW_LOT_NUMBER)
1415 OR ( ( Recinfo.NEW_LOT_NUMBER IS NULL )
1416 AND ( p_NEW_LOT_NUMBER IS NULL )))
1417 AND ( ( Recinfo.OLD_QUANTITY = p_OLD_QUANTITY)
1418 OR ( ( Recinfo.OLD_QUANTITY IS NULL )
1419 AND ( p_OLD_QUANTITY IS NULL )))
1420 AND ( ( Recinfo.NEW_QUANTITY = p_NEW_QUANTITY)
1421 OR ( ( Recinfo.NEW_QUANTITY IS NULL )
1422 AND ( p_NEW_QUANTITY IS NULL )))
1423 AND ( ( Recinfo.OLD_UNIT_OF_MEASURE = p_OLD_UNIT_OF_MEASURE)
1424 OR ( ( Recinfo.OLD_UNIT_OF_MEASURE IS NULL )
1425 AND ( p_OLD_UNIT_OF_MEASURE IS NULL )))
1426 AND ( ( Recinfo.NEW_UNIT_OF_MEASURE = p_NEW_UNIT_OF_MEASURE)
1427 OR ( ( Recinfo.NEW_UNIT_OF_MEASURE IS NULL )
1428 AND ( p_NEW_UNIT_OF_MEASURE IS NULL )))
1429 AND ( ( Recinfo.OLD_ACCOUNTING_CLASS_CODE = p_OLD_ACCOUNTING_CLASS_CODE)
1430 OR ( ( Recinfo.OLD_ACCOUNTING_CLASS_CODE IS NULL )
1431 AND ( p_OLD_ACCOUNTING_CLASS_CODE IS NULL )))
1432 AND ( ( Recinfo.NEW_ACCOUNTING_CLASS_CODE = p_NEW_ACCOUNTING_CLASS_CODE)
1433 OR ( ( Recinfo.NEW_ACCOUNTING_CLASS_CODE IS NULL )
1434 AND ( p_NEW_ACCOUNTING_CLASS_CODE IS NULL )))
1435 AND ( ( Recinfo.OLD_INSTANCE_CONDITION_ID = p_OLD_INSTANCE_CONDITION_ID)
1436 OR ( ( Recinfo.OLD_INSTANCE_CONDITION_ID IS NULL )
1437 AND ( p_OLD_INSTANCE_CONDITION_ID IS NULL )))
1438 AND ( ( Recinfo.NEW_INSTANCE_CONDITION_ID = p_NEW_INSTANCE_CONDITION_ID)
1439 OR ( ( Recinfo.NEW_INSTANCE_CONDITION_ID IS NULL )
1440 AND ( p_NEW_INSTANCE_CONDITION_ID IS NULL )))
1441 AND ( ( Recinfo.OLD_INSTANCE_STATUS_ID = p_OLD_INSTANCE_STATUS_ID)
1442 OR ( ( Recinfo.OLD_INSTANCE_STATUS_ID IS NULL )
1443 AND ( p_OLD_INSTANCE_STATUS_ID IS NULL )))
1444 AND ( ( Recinfo.NEW_INSTANCE_STATUS_ID = p_NEW_INSTANCE_STATUS_ID)
1445 OR ( ( Recinfo.NEW_INSTANCE_STATUS_ID IS NULL )
1446 AND ( p_NEW_INSTANCE_STATUS_ID IS NULL )))
1447 AND ( ( Recinfo.OLD_CUSTOMER_VIEW_FLAG = p_OLD_CUSTOMER_VIEW_FLAG)
1448 OR ( ( Recinfo.OLD_CUSTOMER_VIEW_FLAG IS NULL )
1449 AND ( p_OLD_CUSTOMER_VIEW_FLAG IS NULL )))
1450 AND ( ( Recinfo.NEW_CUSTOMER_VIEW_FLAG = p_NEW_CUSTOMER_VIEW_FLAG)
1451 OR ( ( Recinfo.NEW_CUSTOMER_VIEW_FLAG IS NULL )
1452 AND ( p_NEW_CUSTOMER_VIEW_FLAG IS NULL )))
1453 AND ( ( Recinfo.OLD_MERCHANT_VIEW_FLAG = p_OLD_MERCHANT_VIEW_FLAG)
1454 OR ( ( Recinfo.OLD_MERCHANT_VIEW_FLAG IS NULL )
1455 AND ( p_OLD_MERCHANT_VIEW_FLAG IS NULL )))
1456 AND ( ( Recinfo.NEW_MERCHANT_VIEW_FLAG = p_NEW_MERCHANT_VIEW_FLAG)
1457 OR ( ( Recinfo.NEW_MERCHANT_VIEW_FLAG IS NULL )
1458 AND ( p_NEW_MERCHANT_VIEW_FLAG IS NULL )))
1459 AND ( ( Recinfo.OLD_SELLABLE_FLAG = p_OLD_SELLABLE_FLAG)
1460 OR ( ( Recinfo.OLD_SELLABLE_FLAG IS NULL )
1461 AND ( p_OLD_SELLABLE_FLAG IS NULL )))
1462 AND ( ( Recinfo.NEW_SELLABLE_FLAG = p_NEW_SELLABLE_FLAG)
1463 OR ( ( Recinfo.NEW_SELLABLE_FLAG IS NULL )
1464 AND ( p_NEW_SELLABLE_FLAG IS NULL )))
1465 AND ( ( Recinfo.OLD_SYSTEM_ID = p_OLD_SYSTEM_ID)
1466 OR ( ( Recinfo.OLD_SYSTEM_ID IS NULL )
1467 AND ( p_OLD_SYSTEM_ID IS NULL )))
1468 AND ( ( Recinfo.NEW_SYSTEM_ID = p_NEW_SYSTEM_ID)
1469 OR ( ( Recinfo.NEW_SYSTEM_ID IS NULL )
1470 AND ( p_NEW_SYSTEM_ID IS NULL )))
1471 AND ( ( Recinfo.OLD_INSTANCE_TYPE_CODE = p_OLD_INSTANCE_TYPE_CODE)
1472 OR ( ( Recinfo.OLD_INSTANCE_TYPE_CODE IS NULL )
1473 AND ( p_OLD_INSTANCE_TYPE_CODE IS NULL )))
1474 AND ( ( Recinfo.NEW_INSTANCE_TYPE_CODE = p_NEW_INSTANCE_TYPE_CODE)
1475 OR ( ( Recinfo.NEW_INSTANCE_TYPE_CODE IS NULL )
1476 AND ( p_NEW_INSTANCE_TYPE_CODE IS NULL )))
1477 AND ( ( Recinfo.OLD_ACTIVE_START_DATE = p_OLD_ACTIVE_START_DATE)
1478 OR ( ( Recinfo.OLD_ACTIVE_START_DATE IS NULL )
1479 AND ( p_OLD_ACTIVE_START_DATE IS NULL )))
1480 AND ( ( Recinfo.NEW_ACTIVE_START_DATE = p_NEW_ACTIVE_START_DATE)
1481 OR ( ( Recinfo.NEW_ACTIVE_START_DATE IS NULL )
1482 AND ( p_NEW_ACTIVE_START_DATE IS NULL )))
1483 AND ( ( Recinfo.OLD_ACTIVE_END_DATE = p_OLD_ACTIVE_END_DATE)
1484 OR ( ( Recinfo.OLD_ACTIVE_END_DATE IS NULL )
1485 AND ( p_OLD_ACTIVE_END_DATE IS NULL )))
1486 AND ( ( Recinfo.NEW_ACTIVE_END_DATE = p_NEW_ACTIVE_END_DATE)
1487 OR ( ( Recinfo.NEW_ACTIVE_END_DATE IS NULL )
1488 AND ( p_NEW_ACTIVE_END_DATE IS NULL )))
1489 AND ( ( Recinfo.OLD_LOCATION_TYPE_CODE = p_OLD_LOCATION_TYPE_CODE)
1490 OR ( ( Recinfo.OLD_LOCATION_TYPE_CODE IS NULL )
1494 AND ( p_NEW_LOCATION_TYPE_CODE IS NULL )))
1491 AND ( p_OLD_LOCATION_TYPE_CODE IS NULL )))
1492 AND ( ( Recinfo.NEW_LOCATION_TYPE_CODE = p_NEW_LOCATION_TYPE_CODE)
1493 OR ( ( Recinfo.NEW_LOCATION_TYPE_CODE IS NULL )
1495 AND ( ( Recinfo.OLD_LOCATION_ID = p_OLD_LOCATION_ID)
1496 OR ( ( Recinfo.OLD_LOCATION_ID IS NULL )
1497 AND ( p_OLD_LOCATION_ID IS NULL )))
1498 AND ( ( Recinfo.NEW_LOCATION_ID = p_NEW_LOCATION_ID)
1499 OR ( ( Recinfo.NEW_LOCATION_ID IS NULL )
1500 AND ( p_NEW_LOCATION_ID IS NULL )))
1501 AND ( ( Recinfo.OLD_INV_ORGANIZATION_ID = p_OLD_INV_ORGANIZATION_ID)
1502 OR ( ( Recinfo.OLD_INV_ORGANIZATION_ID IS NULL )
1503 AND ( p_OLD_INV_ORGANIZATION_ID IS NULL )))
1504 AND ( ( Recinfo.NEW_INV_ORGANIZATION_ID = p_NEW_INV_ORGANIZATION_ID)
1505 OR ( ( Recinfo.NEW_INV_ORGANIZATION_ID IS NULL )
1506 AND ( p_NEW_INV_ORGANIZATION_ID IS NULL )))
1507 AND ( ( Recinfo.OLD_INV_SUBINVENTORY_NAME = p_OLD_INV_SUBINVENTORY_NAME)
1508 OR ( ( Recinfo.OLD_INV_SUBINVENTORY_NAME IS NULL )
1509 AND ( p_OLD_INV_SUBINVENTORY_NAME IS NULL )))
1510 AND ( ( Recinfo.NEW_INV_SUBINVENTORY_NAME = p_NEW_INV_SUBINVENTORY_NAME)
1511 OR ( ( Recinfo.NEW_INV_SUBINVENTORY_NAME IS NULL )
1512 AND ( p_NEW_INV_SUBINVENTORY_NAME IS NULL )))
1513 AND ( ( Recinfo.OLD_INV_LOCATOR_ID = p_OLD_INV_LOCATOR_ID)
1514 OR ( ( Recinfo.OLD_INV_LOCATOR_ID IS NULL )
1515 AND ( p_OLD_INV_LOCATOR_ID IS NULL )))
1516 AND ( ( Recinfo.NEW_INV_LOCATOR_ID = p_NEW_INV_LOCATOR_ID)
1517 OR ( ( Recinfo.NEW_INV_LOCATOR_ID IS NULL )
1518 AND ( p_NEW_INV_LOCATOR_ID IS NULL )))
1519 AND ( ( Recinfo.OLD_PA_PROJECT_ID = p_OLD_PA_PROJECT_ID)
1520 OR ( ( Recinfo.OLD_PA_PROJECT_ID IS NULL )
1521 AND ( p_OLD_PA_PROJECT_ID IS NULL )))
1522 AND ( ( Recinfo.NEW_PA_PROJECT_ID = p_NEW_PA_PROJECT_ID)
1523 OR ( ( Recinfo.NEW_PA_PROJECT_ID IS NULL )
1524 AND ( p_NEW_PA_PROJECT_ID IS NULL )))
1525 AND ( ( Recinfo.OLD_PA_PROJECT_TASK_ID = p_OLD_PA_PROJECT_TASK_ID)
1526 OR ( ( Recinfo.OLD_PA_PROJECT_TASK_ID IS NULL )
1527 AND ( p_OLD_PA_PROJECT_TASK_ID IS NULL )))
1528 AND ( ( Recinfo.NEW_PA_PROJECT_TASK_ID = p_NEW_PA_PROJECT_TASK_ID)
1529 OR ( ( Recinfo.NEW_PA_PROJECT_TASK_ID IS NULL )
1530 AND ( p_NEW_PA_PROJECT_TASK_ID IS NULL )))
1531 AND ( ( Recinfo.OLD_IN_TRANSIT_ORDER_LINE_ID = p_OLD_IN_TRANSIT_ORDER_LINE_ID)
1532 OR ( ( Recinfo.OLD_IN_TRANSIT_ORDER_LINE_ID IS NULL )
1533 AND ( p_OLD_IN_TRANSIT_ORDER_LINE_ID IS NULL )))
1534 AND ( ( Recinfo.NEW_IN_TRANSIT_ORDER_LINE_ID = p_NEW_IN_TRANSIT_ORDER_LINE_ID)
1535 OR ( ( Recinfo.NEW_IN_TRANSIT_ORDER_LINE_ID IS NULL )
1536 AND ( p_NEW_IN_TRANSIT_ORDER_LINE_ID IS NULL )))
1537 AND ( ( Recinfo.OLD_WIP_JOB_ID = p_OLD_WIP_JOB_ID)
1538 OR ( ( Recinfo.OLD_WIP_JOB_ID IS NULL )
1539 AND ( p_OLD_WIP_JOB_ID IS NULL )))
1540 AND ( ( Recinfo.NEW_WIP_JOB_ID = p_NEW_WIP_JOB_ID)
1541 OR ( ( Recinfo.NEW_WIP_JOB_ID IS NULL )
1542 AND ( p_NEW_WIP_JOB_ID IS NULL )))
1543 AND ( ( Recinfo.OLD_PO_ORDER_LINE_ID = p_OLD_PO_ORDER_LINE_ID)
1544 OR ( ( Recinfo.OLD_PO_ORDER_LINE_ID IS NULL )
1545 AND ( p_OLD_PO_ORDER_LINE_ID IS NULL )))
1546 AND ( ( Recinfo.NEW_PO_ORDER_LINE_ID = p_NEW_PO_ORDER_LINE_ID)
1547 OR ( ( Recinfo.NEW_PO_ORDER_LINE_ID IS NULL )
1548 AND ( p_NEW_PO_ORDER_LINE_ID IS NULL )))
1549 AND ( ( Recinfo.OLD_COMPLETENESS_FLAG = p_OLD_COMPLETENESS_FLAG)
1550 OR ( ( Recinfo.OLD_COMPLETENESS_FLAG IS NULL )
1551 AND ( p_OLD_COMPLETENESS_FLAG IS NULL )))
1552 AND ( ( Recinfo.NEW_COMPLETENESS_FLAG = p_NEW_COMPLETENESS_FLAG)
1553 OR ( ( Recinfo.NEW_COMPLETENESS_FLAG IS NULL )
1554 AND ( p_NEW_COMPLETENESS_FLAG IS NULL )))
1555 AND ( ( Recinfo.FULL_DUMP_FLAG = p_FULL_DUMP_FLAG)
1556 OR ( ( Recinfo.FULL_DUMP_FLAG IS NULL )
1557 AND ( p_FULL_DUMP_FLAG IS NULL )))
1558 AND ( ( Recinfo.OLD_CONTEXT = p_OLD_CONTEXT)
1559 OR ( ( Recinfo.OLD_CONTEXT IS NULL )
1560 AND ( p_OLD_CONTEXT IS NULL )))
1561 AND ( ( Recinfo.NEW_CONTEXT = p_NEW_CONTEXT)
1562 OR ( ( Recinfo.NEW_CONTEXT IS NULL )
1563 AND ( p_NEW_CONTEXT IS NULL )))
1564 AND ( ( Recinfo.OLD_ATTRIBUTE1 = p_OLD_ATTRIBUTE1)
1565 OR ( ( Recinfo.OLD_ATTRIBUTE1 IS NULL )
1566 AND ( p_OLD_ATTRIBUTE1 IS NULL )))
1567 AND ( ( Recinfo.NEW_ATTRIBUTE1 = p_NEW_ATTRIBUTE1)
1568 OR ( ( Recinfo.NEW_ATTRIBUTE1 IS NULL )
1569 AND ( p_NEW_ATTRIBUTE1 IS NULL )))
1570 AND ( ( Recinfo.OLD_ATTRIBUTE2 = p_OLD_ATTRIBUTE2)
1571 OR ( ( Recinfo.OLD_ATTRIBUTE2 IS NULL )
1572 AND ( p_OLD_ATTRIBUTE2 IS NULL )))
1573 AND ( ( Recinfo.NEW_ATTRIBUTE2 = p_NEW_ATTRIBUTE2)
1574 OR ( ( Recinfo.NEW_ATTRIBUTE2 IS NULL )
1575 AND ( p_NEW_ATTRIBUTE2 IS NULL )))
1576 AND ( ( Recinfo.OLD_ATTRIBUTE3 = p_OLD_ATTRIBUTE3)
1577 OR ( ( Recinfo.OLD_ATTRIBUTE3 IS NULL )
1578 AND ( p_OLD_ATTRIBUTE3 IS NULL )))
1579 AND ( ( Recinfo.NEW_ATTRIBUTE3 = p_NEW_ATTRIBUTE3)
1580 OR ( ( Recinfo.NEW_ATTRIBUTE3 IS NULL )
1581 AND ( p_NEW_ATTRIBUTE3 IS NULL )))
1582 AND ( ( Recinfo.OLD_ATTRIBUTE4 = p_OLD_ATTRIBUTE4)
1583 OR ( ( Recinfo.OLD_ATTRIBUTE4 IS NULL )
1584 AND ( p_OLD_ATTRIBUTE4 IS NULL )))
1585 AND ( ( Recinfo.NEW_ATTRIBUTE4 = p_NEW_ATTRIBUTE4)
1589 OR ( ( Recinfo.OLD_ATTRIBUTE5 IS NULL )
1586 OR ( ( Recinfo.NEW_ATTRIBUTE4 IS NULL )
1587 AND ( p_NEW_ATTRIBUTE4 IS NULL )))
1588 AND ( ( Recinfo.OLD_ATTRIBUTE5 = p_OLD_ATTRIBUTE5)
1590 AND ( p_OLD_ATTRIBUTE5 IS NULL )))
1591 AND ( ( Recinfo.NEW_ATTRIBUTE5 = p_NEW_ATTRIBUTE5)
1592 OR ( ( Recinfo.NEW_ATTRIBUTE5 IS NULL )
1593 AND ( p_NEW_ATTRIBUTE5 IS NULL )))
1594 AND ( ( Recinfo.OLD_ATTRIBUTE6 = p_OLD_ATTRIBUTE6)
1595 OR ( ( Recinfo.OLD_ATTRIBUTE6 IS NULL )
1596 AND ( p_OLD_ATTRIBUTE6 IS NULL )))
1597 AND ( ( Recinfo.NEW_ATTRIBUTE6 = p_NEW_ATTRIBUTE6)
1598 OR ( ( Recinfo.NEW_ATTRIBUTE6 IS NULL )
1599 AND ( p_NEW_ATTRIBUTE6 IS NULL )))
1600 AND ( ( Recinfo.OLD_ATTRIBUTE7 = p_OLD_ATTRIBUTE7)
1601 OR ( ( Recinfo.OLD_ATTRIBUTE7 IS NULL )
1602 AND ( p_OLD_ATTRIBUTE7 IS NULL )))
1603 AND ( ( Recinfo.NEW_ATTRIBUTE7 = p_NEW_ATTRIBUTE7)
1604 OR ( ( Recinfo.NEW_ATTRIBUTE7 IS NULL )
1605 AND ( p_NEW_ATTRIBUTE7 IS NULL )))
1606 AND ( ( Recinfo.OLD_ATTRIBUTE8 = p_OLD_ATTRIBUTE8)
1607 OR ( ( Recinfo.OLD_ATTRIBUTE8 IS NULL )
1608 AND ( p_OLD_ATTRIBUTE8 IS NULL )))
1609 AND ( ( Recinfo.NEW_ATTRIBUTE8 = p_NEW_ATTRIBUTE8)
1610 OR ( ( Recinfo.NEW_ATTRIBUTE8 IS NULL )
1611 AND ( p_NEW_ATTRIBUTE8 IS NULL )))
1612 AND ( ( Recinfo.OLD_ATTRIBUTE9 = p_OLD_ATTRIBUTE9)
1613 OR ( ( Recinfo.OLD_ATTRIBUTE9 IS NULL )
1614 AND ( p_OLD_ATTRIBUTE9 IS NULL )))
1615 AND ( ( Recinfo.NEW_ATTRIBUTE9 = p_NEW_ATTRIBUTE9)
1616 OR ( ( Recinfo.NEW_ATTRIBUTE9 IS NULL )
1617 AND ( p_NEW_ATTRIBUTE9 IS NULL )))
1618 AND ( ( Recinfo.OLD_ATTRIBUTE10 = p_OLD_ATTRIBUTE10)
1619 OR ( ( Recinfo.OLD_ATTRIBUTE10 IS NULL )
1620 AND ( p_OLD_ATTRIBUTE10 IS NULL )))
1621 AND ( ( Recinfo.NEW_ATTRIBUTE10 = p_NEW_ATTRIBUTE10)
1622 OR ( ( Recinfo.NEW_ATTRIBUTE10 IS NULL )
1623 AND ( p_NEW_ATTRIBUTE10 IS NULL )))
1624 AND ( ( Recinfo.OLD_ATTRIBUTE11 = p_OLD_ATTRIBUTE11)
1625 OR ( ( Recinfo.OLD_ATTRIBUTE11 IS NULL )
1626 AND ( p_OLD_ATTRIBUTE11 IS NULL )))
1627 AND ( ( Recinfo.NEW_ATTRIBUTE11 = p_NEW_ATTRIBUTE11)
1628 OR ( ( Recinfo.NEW_ATTRIBUTE11 IS NULL )
1629 AND ( p_NEW_ATTRIBUTE11 IS NULL )))
1630 AND ( ( Recinfo.OLD_ATTRIBUTE12 = p_OLD_ATTRIBUTE12)
1631 OR ( ( Recinfo.OLD_ATTRIBUTE12 IS NULL )
1632 AND ( p_OLD_ATTRIBUTE12 IS NULL )))
1633 AND ( ( Recinfo.NEW_ATTRIBUTE12 = p_NEW_ATTRIBUTE12)
1634 OR ( ( Recinfo.NEW_ATTRIBUTE12 IS NULL )
1635 AND ( p_NEW_ATTRIBUTE12 IS NULL )))
1636 AND ( ( Recinfo.OLD_ATTRIBUTE13 = p_OLD_ATTRIBUTE13)
1637 OR ( ( Recinfo.OLD_ATTRIBUTE13 IS NULL )
1638 AND ( p_OLD_ATTRIBUTE13 IS NULL )))
1639 AND ( ( Recinfo.NEW_ATTRIBUTE13 = p_NEW_ATTRIBUTE13)
1640 OR ( ( Recinfo.NEW_ATTRIBUTE13 IS NULL )
1641 AND ( p_NEW_ATTRIBUTE13 IS NULL )))
1642 AND ( ( Recinfo.OLD_ATTRIBUTE14 = p_OLD_ATTRIBUTE14)
1643 OR ( ( Recinfo.OLD_ATTRIBUTE14 IS NULL )
1644 AND ( p_OLD_ATTRIBUTE14 IS NULL )))
1645 AND ( ( Recinfo.NEW_ATTRIBUTE14 = p_NEW_ATTRIBUTE14)
1646 OR ( ( Recinfo.NEW_ATTRIBUTE14 IS NULL )
1647 AND ( p_NEW_ATTRIBUTE14 IS NULL )))
1648 AND ( ( Recinfo.OLD_ATTRIBUTE15 = p_OLD_ATTRIBUTE15)
1649 OR ( ( Recinfo.OLD_ATTRIBUTE15 IS NULL )
1650 AND ( p_OLD_ATTRIBUTE15 IS NULL )))
1651 AND ( ( Recinfo.NEW_ATTRIBUTE15 = p_NEW_ATTRIBUTE15)
1652 OR ( ( Recinfo.NEW_ATTRIBUTE15 IS NULL )
1653 AND ( p_NEW_ATTRIBUTE15 IS NULL )))
1654 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
1655 OR ( ( Recinfo.CREATED_BY IS NULL )
1656 AND ( p_CREATED_BY IS NULL )))
1657 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
1658 OR ( ( Recinfo.CREATION_DATE IS NULL )
1659 AND ( p_CREATION_DATE IS NULL )))
1660 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
1661 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
1662 AND ( p_LAST_UPDATED_BY IS NULL )))
1663 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
1664 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
1665 AND ( p_LAST_UPDATE_DATE IS NULL )))
1666 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
1667 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
1668 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
1669 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
1670 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
1671 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
1672 AND ( ( Recinfo.OLD_INST_LOC_TYPE_CODE = p_OLD_INST_LOC_TYPE_CODE)
1673 OR ( ( Recinfo.OLD_INST_LOC_TYPE_CODE IS NULL )
1674 AND ( p_OLD_INST_LOC_TYPE_CODE IS NULL )))
1675 AND ( ( Recinfo.NEW_INST_LOC_TYPE_CODE = p_NEW_INST_LOC_TYPE_CODE)
1676 OR ( ( Recinfo.NEW_INST_LOC_TYPE_CODE IS NULL )
1677 AND ( p_NEW_INST_LOC_TYPE_CODE IS NULL )))
1678 AND ( ( Recinfo.OLD_INST_LOC_ID = p_OLD_INST_LOC_ID)
1679 OR ( ( Recinfo.OLD_INST_LOC_ID IS NULL )
1680 AND ( p_OLD_INST_LOC_ID IS NULL )))
1681 AND ( ( Recinfo.NEW_INST_LOC_ID = p_NEW_INST_LOC_ID)
1682 OR ( ( Recinfo.NEW_INST_LOC_ID IS NULL )
1683 AND ( p_NEW_INST_LOC_ID IS NULL )))
1684 AND ( ( Recinfo.OLD_INST_USAGE_CODE = p_OLD_INST_USAGE_CODE)
1685 OR ( ( Recinfo.OLD_INST_USAGE_CODE IS NULL )
1689 AND ( p_NEW_INST_USAGE_CODE IS NULL )))
1686 AND ( p_OLD_INST_USAGE_CODE IS NULL )))
1687 AND ( ( Recinfo.NEW_INST_USAGE_CODE = p_NEW_INST_USAGE_CODE)
1688 OR ( ( Recinfo.NEW_INST_USAGE_CODE IS NULL )
1690 AND ( ( Recinfo.OLD_CONFIG_INST_REV_NUM = p_OLD_CONFIG_INST_REV_NUM)
1691 OR ( ( Recinfo.OLD_CONFIG_INST_REV_NUM IS NULL )
1692 AND ( p_OLD_CONFIG_INST_REV_NUM IS NULL )))
1693 AND ( ( Recinfo.NEW_CONFIG_INST_REV_NUM = p_NEW_CONFIG_INST_REV_NUM)
1694 OR ( ( Recinfo.NEW_CONFIG_INST_REV_NUM IS NULL )
1695 AND ( p_NEW_CONFIG_INST_REV_NUM IS NULL )))
1696 AND ( ( Recinfo.OLD_CONFIG_VALID_STATUS = p_OLD_CONFIG_VALID_STATUS)
1697 OR ( ( Recinfo.OLD_CONFIG_VALID_STATUS IS NULL )
1698 AND ( p_OLD_CONFIG_VALID_STATUS IS NULL )))
1699 AND ( ( Recinfo.NEW_CONFIG_VALID_STATUS = p_NEW_CONFIG_VALID_STATUS)
1700 OR ( ( Recinfo.NEW_CONFIG_VALID_STATUS IS NULL )
1701 AND ( p_NEW_CONFIG_VALID_STATUS IS NULL )))
1702 AND ( ( Recinfo.OLD_INSTANCE_DESCRIPTION = p_OLD_INSTANCE_DESCRIPTION)
1703 OR ( ( Recinfo.OLD_INSTANCE_DESCRIPTION IS NULL )
1704 AND ( p_OLD_INSTANCE_DESCRIPTION IS NULL )))
1705 AND ( ( Recinfo.NEW_INSTANCE_DESCRIPTION = p_NEW_INSTANCE_DESCRIPTION)
1706 OR ( ( Recinfo.NEW_INSTANCE_DESCRIPTION IS NULL )
1707 AND ( p_NEW_INSTANCE_DESCRIPTION IS NULL )))
1708 AND ( ( Recinfo.OLD_OE_AGREEMENT_ID = p_OLD_LAST_OE_AGREEMENT_ID)
1709 OR ( ( Recinfo.OLD_OE_AGREEMENT_ID IS NULL )
1710 AND ( p_OLD_LAST_OE_AGREEMENT_ID IS NULL )))
1711 AND ( ( Recinfo.NEW_OE_AGREEMENT_ID = p_NEW_LAST_OE_AGREEMENT_ID)
1712 OR ( ( Recinfo.NEW_OE_AGREEMENT_ID IS NULL )
1713 AND ( p_NEW_LAST_OE_AGREEMENT_ID IS NULL )))
1714 AND ( ( Recinfo.OLD_LAST_OE_ORDER_LINE_ID = p_OLD_LAST_OE_ORDER_LINE_ID)
1715 OR ( ( Recinfo.OLD_LAST_OE_ORDER_LINE_ID IS NULL )
1716 AND ( p_OLD_LAST_OE_ORDER_LINE_ID IS NULL )))
1717 AND ( ( Recinfo.NEW_LAST_OE_ORDER_LINE_ID = p_NEW_LAST_OE_ORDER_LINE_ID)
1718 OR ( ( Recinfo.NEW_LAST_OE_ORDER_LINE_ID IS NULL )
1719 AND ( p_NEW_LAST_OE_ORDER_LINE_ID IS NULL )))
1720 AND ( ( Recinfo.OLD_LAST_OE_RMA_LINE_ID = p_OLD_LAST_OE_RMA_LINE_ID)
1721 OR ( ( Recinfo.OLD_LAST_OE_RMA_LINE_ID IS NULL )
1722 AND ( p_OLD_LAST_OE_RMA_LINE_ID IS NULL )))
1723 AND ( ( Recinfo.NEW_LAST_OE_RMA_LINE_ID = p_NEW_LAST_OE_RMA_LINE_ID)
1724 OR ( ( Recinfo.NEW_LAST_OE_RMA_LINE_ID IS NULL )
1725 AND ( p_NEW_LAST_OE_RMA_LINE_ID IS NULL )))
1726 AND ( ( Recinfo.OLD_LAST_WIP_JOB_ID = p_OLD_LAST_WIP_JOB_ID)
1727 OR ( ( Recinfo.OLD_LAST_WIP_JOB_ID IS NULL )
1728 AND ( p_OLD_LAST_WIP_JOB_ID IS NULL )))
1729 AND ( ( Recinfo.NEW_LAST_WIP_JOB_ID = p_NEW_LAST_WIP_JOB_ID)
1730 OR ( ( Recinfo.NEW_LAST_WIP_JOB_ID IS NULL )
1731 AND ( p_NEW_LAST_WIP_JOB_ID IS NULL )))
1732 AND ( ( Recinfo.OLD_LAST_PO_PO_LINE_ID = p_OLD_LAST_PO_PO_LINE_ID)
1733 OR ( ( Recinfo.OLD_LAST_PO_PO_LINE_ID IS NULL )
1734 AND ( p_OLD_LAST_PO_PO_LINE_ID IS NULL )))
1735 AND ( ( Recinfo.NEW_LAST_PO_PO_LINE_ID = p_NEW_LAST_PO_PO_LINE_ID)
1736 OR ( ( Recinfo.NEW_LAST_PO_PO_LINE_ID IS NULL )
1737 AND ( p_NEW_LAST_PO_PO_LINE_ID IS NULL )))
1738 AND ( ( Recinfo.OLD_LAST_PA_PROJECT_ID = p_OLD_LAST_PA_PROJECT_ID)
1739 OR ( ( Recinfo.OLD_LAST_PA_PROJECT_ID IS NULL )
1740 AND ( p_OLD_LAST_PA_PROJECT_ID IS NULL )))
1741 AND ( ( Recinfo.NEW_LAST_PA_PROJECT_ID = p_NEW_LAST_PA_PROJECT_ID)
1742 OR ( ( Recinfo.NEW_LAST_PA_PROJECT_ID IS NULL )
1743 AND ( p_NEW_LAST_PA_PROJECT_ID IS NULL )))
1744 AND ( ( Recinfo.OLD_LAST_PA_TASK_ID = p_OLD_LAST_PA_TASK_ID)
1745 OR ( ( Recinfo.OLD_LAST_PA_TASK_ID IS NULL )
1746 AND ( p_OLD_LAST_PA_TASK_ID IS NULL )))
1747 AND ( ( Recinfo.NEW_LAST_PA_TASK_ID = p_NEW_LAST_PA_TASK_ID)
1748 OR ( ( Recinfo.NEW_LAST_PA_TASK_ID IS NULL )
1749 AND ( p_NEW_LAST_PA_TASK_ID IS NULL )))
1750 AND ( ( Recinfo.OLD_LAST_TXN_LINE_DETAIL_ID = p_OLD_LAST_TXN_LINE_DETAIL_ID)
1751 OR ( ( Recinfo.OLD_LAST_TXN_LINE_DETAIL_ID IS NULL )
1752 AND ( p_OLD_LAST_TXN_LINE_DETAIL_ID IS NULL )))
1753 AND ( ( Recinfo.NEW_LAST_TXN_LINE_DETAIL_ID = p_NEW_LAST_TXN_LINE_DETAIL_ID)
1754 OR ( ( Recinfo.NEW_LAST_TXN_LINE_DETAIL_ID IS NULL )
1755 AND ( p_NEW_LAST_TXN_LINE_DETAIL_ID IS NULL )))
1756 AND ( ( Recinfo.OLD_LAST_OE_PO_NUMBER = p_OLD_LAST_OE_PO_NUMBER)
1757 OR ( ( Recinfo.OLD_LAST_OE_PO_NUMBER IS NULL )
1758 AND ( p_OLD_LAST_OE_PO_NUMBER IS NULL )))
1759 AND ( ( Recinfo.NEW_LAST_OE_PO_NUMBER = p_NEW_LAST_OE_PO_NUMBER)
1760 OR ( ( Recinfo.NEW_LAST_OE_PO_NUMBER IS NULL )
1761 AND ( p_NEW_LAST_OE_PO_NUMBER IS NULL )))
1762 --start of eam integration changes--
1763 AND ( ( Recinfo.OLD_NETWORK_ASSET_FLAG = p_OLD_NETWORK_ASSET_FLAG)
1764 OR ( ( Recinfo.OLD_NETWORK_ASSET_FLAG IS NULL )
1765 AND ( p_OLD_NETWORK_ASSET_FLAG IS NULL )))
1766 AND ( ( Recinfo.NEW_NETWORK_ASSET_FLAG = p_NEW_NETWORK_ASSET_FLAG)
1767 OR ( ( Recinfo.NEW_NETWORK_ASSET_FLAG IS NULL )
1768 AND ( p_NEW_NETWORK_ASSET_FLAG IS NULL )))
1769 AND ( ( Recinfo.OLD_MAINTAINABLE_FLAG = p_OLD_MAINTAINABLE_FLAG)
1770 OR ( ( Recinfo.OLD_MAINTAINABLE_FLAG IS NULL )
1771 AND ( p_OLD_MAINTAINABLE_FLAG IS NULL )))
1772 AND ( ( Recinfo.NEW_MAINTAINABLE_FLAG = p_NEW_MAINTAINABLE_FLAG)
1773 OR ( ( Recinfo.NEW_MAINTAINABLE_FLAG IS NULL )
1774 AND ( p_NEW_MAINTAINABLE_FLAG IS NULL )))
1778 AND ( ( Recinfo.NEW_PN_LOCATION_ID = p_NEW_PN_LOCATION_ID)
1775 AND ( ( Recinfo.OLD_PN_LOCATION_ID = p_OLD_PN_LOCATION_ID)
1776 OR ( ( Recinfo.OLD_PN_LOCATION_ID IS NULL )
1777 AND ( p_OLD_PN_LOCATION_ID IS NULL )))
1779 OR ( ( Recinfo.NEW_PN_LOCATION_ID IS NULL )
1780 AND ( p_NEW_PN_LOCATION_ID IS NULL )))
1781 AND ( ( Recinfo.OLD_ASSET_CRITICALITY_CODE = p_OLD_ASSET_CRITICALITY_CODE)
1782 OR ( ( Recinfo.OLD_ASSET_CRITICALITY_CODE IS NULL )
1783 AND ( p_OLD_ASSET_CRITICALITY_CODE IS NULL )))
1784 AND ( ( Recinfo.NEW_ASSET_CRITICALITY_CODE = p_NEW_ASSET_CRITICALITY_CODE)
1785 OR ( ( Recinfo.NEW_ASSET_CRITICALITY_CODE IS NULL )
1786 AND ( p_NEW_ASSET_CRITICALITY_CODE IS NULL )))
1787 AND ( ( Recinfo.OLD_CATEGORY_ID = p_OLD_CATEGORY_ID)
1788 OR ( ( Recinfo.OLD_CATEGORY_ID IS NULL )
1789 AND ( p_OLD_CATEGORY_ID IS NULL )))
1790 AND ( ( Recinfo.NEW_CATEGORY_ID = p_NEW_CATEGORY_ID)
1791 OR ( ( Recinfo.NEW_CATEGORY_ID IS NULL )
1792 AND ( p_NEW_CATEGORY_ID IS NULL )))
1793 AND ( ( Recinfo.OLD_EQUIPMENT_GEN_OBJECT_ID = p_OLD_EQUIPMENT_GEN_OBJECT_ID)
1794 OR ( ( Recinfo.OLD_EQUIPMENT_GEN_OBJECT_ID IS NULL )
1795 AND ( p_OLD_EQUIPMENT_GEN_OBJECT_ID IS NULL )))
1796 AND ( ( Recinfo.NEW_EQUIPMENT_GEN_OBJECT_ID = p_NEW_EQUIPMENT_GEN_OBJECT_ID)
1797 OR ( ( Recinfo.NEW_EQUIPMENT_GEN_OBJECT_ID IS NULL )
1798 AND ( p_NEW_EQUIPMENT_GEN_OBJECT_ID IS NULL )))
1799 AND ( ( Recinfo.OLD_INSTANTIATION_FLAG = p_OLD_INSTANTIATION_FLAG)
1800 OR ( ( Recinfo.OLD_INSTANTIATION_FLAG IS NULL )
1801 AND ( p_OLD_INSTANTIATION_FLAG IS NULL )))
1802 AND ( ( Recinfo.NEW_INSTANTIATION_FLAG = p_NEW_INSTANTIATION_FLAG)
1803 OR ( ( Recinfo.NEW_INSTANTIATION_FLAG IS NULL )
1804 AND ( p_NEW_INSTANTIATION_FLAG IS NULL )))
1805 AND ( ( Recinfo.OLD_LINEAR_LOCATION_ID = p_OLD_LINEAR_LOCATION_ID)
1806 OR ( ( Recinfo.OLD_LINEAR_LOCATION_ID IS NULL )
1807 AND ( p_OLD_LINEAR_LOCATION_ID IS NULL )))
1808 AND ( ( Recinfo.NEW_LINEAR_LOCATION_ID = p_NEW_LINEAR_LOCATION_ID)
1809 OR ( ( Recinfo.NEW_LINEAR_LOCATION_ID IS NULL )
1810 AND ( p_NEW_LINEAR_LOCATION_ID IS NULL )))
1811 AND ( ( Recinfo.OLD_OPERATIONAL_LOG_FLAG = p_OLD_OPERATIONAL_LOG_FLAG)
1812 OR ( ( Recinfo.OLD_OPERATIONAL_LOG_FLAG IS NULL )
1813 AND ( p_OLD_OPERATIONAL_LOG_FLAG IS NULL )))
1814 AND ( ( Recinfo.NEW_OPERATIONAL_LOG_FLAG = p_NEW_OPERATIONAL_LOG_FLAG)
1815 OR ( ( Recinfo.NEW_OPERATIONAL_LOG_FLAG IS NULL )
1816 AND ( p_NEW_OPERATIONAL_LOG_FLAG IS NULL )))
1817 AND ( ( Recinfo.OLD_CHECKIN_STATUS = p_OLD_CHECKIN_STATUS)
1818 OR ( ( Recinfo.OLD_CHECKIN_STATUS IS NULL )
1819 AND ( p_OLD_CHECKIN_STATUS IS NULL )))
1820 AND ( ( Recinfo.NEW_CHECKIN_STATUS = p_NEW_CHECKIN_STATUS)
1821 OR ( ( Recinfo.NEW_CHECKIN_STATUS IS NULL )
1822 AND ( p_NEW_CHECKIN_STATUS IS NULL )))
1823 AND ( ( Recinfo.OLD_SUPPLIER_WARRANTY_EXP_DATE = p_OLD_SUP_WARRANTY_EXP_DATE)
1824 OR ( ( Recinfo.OLD_SUPPLIER_WARRANTY_EXP_DATE IS NULL )
1825 AND ( p_OLD_SUP_WARRANTY_EXP_DATE IS NULL )))
1826 AND ( ( Recinfo.NEW_SUPPLIER_WARRANTY_EXP_DATE = p_NEW_SUP_WARRANTY_EXP_DATE)
1827 OR ( ( Recinfo.NEW_SUPPLIER_WARRANTY_EXP_DATE IS NULL )
1828 AND ( p_NEW_SUP_WARRANTY_EXP_DATE IS NULL )))
1829 AND ( ( Recinfo.OLD_ATTRIBUTE16 = p_OLD_ATTRIBUTE16)
1830 OR ( ( Recinfo.OLD_ATTRIBUTE16 IS NULL )
1831 AND ( p_OLD_ATTRIBUTE16 IS NULL )))
1832 AND ( ( Recinfo.NEW_ATTRIBUTE16 = p_NEW_ATTRIBUTE16)
1833 OR ( ( Recinfo.NEW_ATTRIBUTE16 IS NULL )
1834 AND ( p_NEW_ATTRIBUTE16 IS NULL )))
1835 AND ( ( Recinfo.OLD_ATTRIBUTE17 = p_OLD_ATTRIBUTE17)
1836 OR ( ( Recinfo.OLD_ATTRIBUTE17 IS NULL )
1837 AND ( p_OLD_ATTRIBUTE17 IS NULL )))
1838 AND ( ( Recinfo.NEW_ATTRIBUTE17 = p_NEW_ATTRIBUTE17)
1839 OR ( ( Recinfo.NEW_ATTRIBUTE17 IS NULL )
1840 AND ( p_NEW_ATTRIBUTE17 IS NULL )))
1841 AND ( ( Recinfo.OLD_ATTRIBUTE18 = p_OLD_ATTRIBUTE18)
1842 OR ( ( Recinfo.OLD_ATTRIBUTE18 IS NULL )
1843 AND ( p_OLD_ATTRIBUTE18 IS NULL )))
1844 AND ( ( Recinfo.NEW_ATTRIBUTE18 = p_NEW_ATTRIBUTE18)
1845 OR ( ( Recinfo.NEW_ATTRIBUTE18 IS NULL )
1846 AND ( p_NEW_ATTRIBUTE18 IS NULL )))
1847 AND ( ( Recinfo.OLD_ATTRIBUTE19 = p_OLD_ATTRIBUTE19)
1848 OR ( ( Recinfo.OLD_ATTRIBUTE19 IS NULL )
1849 AND ( p_OLD_ATTRIBUTE19 IS NULL )))
1850 AND ( ( Recinfo.NEW_ATTRIBUTE19 = p_NEW_ATTRIBUTE19)
1851 OR ( ( Recinfo.NEW_ATTRIBUTE19 IS NULL )
1852 AND ( p_NEW_ATTRIBUTE19 IS NULL )))
1853 AND ( ( Recinfo.OLD_ATTRIBUTE20 = p_OLD_ATTRIBUTE20)
1854 OR ( ( Recinfo.OLD_ATTRIBUTE20 IS NULL )
1855 AND ( p_OLD_ATTRIBUTE20 IS NULL )))
1856 AND ( ( Recinfo.NEW_ATTRIBUTE20 = p_NEW_ATTRIBUTE20)
1857 OR ( ( Recinfo.NEW_ATTRIBUTE20 IS NULL )
1858 AND ( p_NEW_ATTRIBUTE20 IS NULL )))
1859 AND ( ( Recinfo.OLD_ATTRIBUTE21 = p_OLD_ATTRIBUTE21)
1860 OR ( ( Recinfo.OLD_ATTRIBUTE21 IS NULL )
1861 AND ( p_OLD_ATTRIBUTE21 IS NULL )))
1862 AND ( ( Recinfo.NEW_ATTRIBUTE21 = p_NEW_ATTRIBUTE21)
1863 OR ( ( Recinfo.NEW_ATTRIBUTE21 IS NULL )
1864 AND ( p_NEW_ATTRIBUTE21 IS NULL )))
1865 AND ( ( Recinfo.OLD_ATTRIBUTE22 = p_OLD_ATTRIBUTE22)
1866 OR ( ( Recinfo.OLD_ATTRIBUTE22 IS NULL )
1867 AND ( p_OLD_ATTRIBUTE22 IS NULL )))
1871 AND ( ( Recinfo.OLD_ATTRIBUTE23 = p_OLD_ATTRIBUTE23)
1868 AND ( ( Recinfo.NEW_ATTRIBUTE22 = p_NEW_ATTRIBUTE22)
1869 OR ( ( Recinfo.NEW_ATTRIBUTE22 IS NULL )
1870 AND ( p_NEW_ATTRIBUTE22 IS NULL )))
1872 OR ( ( Recinfo.OLD_ATTRIBUTE23 IS NULL )
1873 AND ( p_OLD_ATTRIBUTE23 IS NULL )))
1874 AND ( ( Recinfo.NEW_ATTRIBUTE23 = p_NEW_ATTRIBUTE23)
1875 OR ( ( Recinfo.NEW_ATTRIBUTE23 IS NULL )
1876 AND ( p_NEW_ATTRIBUTE23 IS NULL )))
1877 AND ( ( Recinfo.OLD_ATTRIBUTE24 = p_OLD_ATTRIBUTE24)
1878 OR ( ( Recinfo.OLD_ATTRIBUTE24 IS NULL )
1879 AND ( p_OLD_ATTRIBUTE24 IS NULL )))
1880 AND ( ( Recinfo.NEW_ATTRIBUTE24 = p_NEW_ATTRIBUTE24)
1881 OR ( ( Recinfo.NEW_ATTRIBUTE24 IS NULL )
1882 AND ( p_NEW_ATTRIBUTE24 IS NULL )))
1883 AND ( ( Recinfo.OLD_ATTRIBUTE25 = p_OLD_ATTRIBUTE25)
1884 OR ( ( Recinfo.OLD_ATTRIBUTE25 IS NULL )
1885 AND ( p_OLD_ATTRIBUTE25 IS NULL )))
1886 AND ( ( Recinfo.NEW_ATTRIBUTE25 = p_NEW_ATTRIBUTE25)
1887 OR ( ( Recinfo.NEW_ATTRIBUTE25 IS NULL )
1888 AND ( p_NEW_ATTRIBUTE25 IS NULL )))
1889 AND ( ( Recinfo.OLD_ATTRIBUTE26 = p_OLD_ATTRIBUTE26)
1890 OR ( ( Recinfo.OLD_ATTRIBUTE26 IS NULL )
1891 AND ( p_OLD_ATTRIBUTE26 IS NULL )))
1892 AND ( ( Recinfo.NEW_ATTRIBUTE26 = p_NEW_ATTRIBUTE26)
1893 OR ( ( Recinfo.NEW_ATTRIBUTE26 IS NULL )
1894 AND ( p_NEW_ATTRIBUTE26 IS NULL )))
1895 AND ( ( Recinfo.OLD_ATTRIBUTE27 = p_OLD_ATTRIBUTE27)
1896 OR ( ( Recinfo.OLD_ATTRIBUTE27 IS NULL )
1897 AND ( p_OLD_ATTRIBUTE27 IS NULL )))
1898 AND ( ( Recinfo.NEW_ATTRIBUTE27 = p_NEW_ATTRIBUTE27)
1899 OR ( ( Recinfo.NEW_ATTRIBUTE27 IS NULL )
1900 AND ( p_NEW_ATTRIBUTE27 IS NULL )))
1901 AND ( ( Recinfo.OLD_ATTRIBUTE28 = p_OLD_ATTRIBUTE28)
1902 OR ( ( Recinfo.OLD_ATTRIBUTE28 IS NULL )
1903 AND ( p_OLD_ATTRIBUTE28 IS NULL )))
1904 AND ( ( Recinfo.NEW_ATTRIBUTE28 = p_NEW_ATTRIBUTE28)
1905 OR ( ( Recinfo.NEW_ATTRIBUTE28 IS NULL )
1906 AND ( p_NEW_ATTRIBUTE28 IS NULL )))
1907 AND ( ( Recinfo.OLD_ATTRIBUTE29 = p_OLD_ATTRIBUTE29)
1908 OR ( ( Recinfo.OLD_ATTRIBUTE29 IS NULL )
1909 AND ( p_OLD_ATTRIBUTE29 IS NULL )))
1910 AND ( ( Recinfo.NEW_ATTRIBUTE29 = p_NEW_ATTRIBUTE29)
1911 OR ( ( Recinfo.NEW_ATTRIBUTE29 IS NULL )
1912 AND ( p_NEW_ATTRIBUTE29 IS NULL )))
1913 AND ( ( Recinfo.OLD_ATTRIBUTE30 = p_OLD_ATTRIBUTE30)
1914 OR ( ( Recinfo.OLD_ATTRIBUTE30 IS NULL )
1915 AND ( p_OLD_ATTRIBUTE30 IS NULL )))
1916 AND ( ( Recinfo.NEW_ATTRIBUTE30 = p_NEW_ATTRIBUTE30)
1917 OR ( ( Recinfo.NEW_ATTRIBUTE30 IS NULL )
1918 AND ( p_NEW_ATTRIBUTE30 IS NULL )))
1919 --end of eam integration changes--
1920 -- Addition of columns for FA Integration
1921 AND ( ( Recinfo.OLD_PAYABLES_UNIT_PRICE = p_OLD_PAYABLES_UNIT_PRICE)
1922 OR ( ( Recinfo.OLD_PAYABLES_UNIT_PRICE IS NULL )
1923 AND ( p_OLD_PAYABLES_UNIT_PRICE IS NULL )))
1924 AND ( ( Recinfo.NEW_PAYABLES_UNIT_PRICE = p_NEW_PAYABLES_UNIT_PRICE)
1925 OR ( ( Recinfo.NEW_PAYABLES_UNIT_PRICE IS NULL )
1926 AND ( p_NEW_PAYABLES_UNIT_PRICE IS NULL )))
1927 AND ( ( Recinfo.OLD_PAYABLES_CURRENCY_CODE = p_OLD_PAYABLES_CURRENCY_CODE)
1928 OR ( ( Recinfo.OLD_PAYABLES_CURRENCY_CODE IS NULL )
1929 AND ( p_OLD_PAYABLES_CURRENCY_CODE IS NULL )))
1930 AND ( ( Recinfo.NEW_PAYABLES_CURRENCY_CODE = p_NEW_PAYABLES_CURRENCY_CODE)
1931 OR ( ( Recinfo.NEW_PAYABLES_CURRENCY_CODE IS NULL )
1932 AND ( p_NEW_PAYABLES_CURRENCY_CODE IS NULL )))
1933 AND ( ( Recinfo.OLD_PURCHASE_UNIT_PRICE = p_OLD_PURCHASE_UNIT_PRICE)
1934 OR ( ( Recinfo.OLD_PURCHASE_UNIT_PRICE IS NULL )
1935 AND ( p_OLD_PURCHASE_UNIT_PRICE IS NULL )))
1936 AND ( ( Recinfo.NEW_PURCHASE_UNIT_PRICE = p_NEW_PURCHASE_UNIT_PRICE)
1937 OR ( ( Recinfo.NEW_PURCHASE_UNIT_PRICE IS NULL )
1938 AND ( p_NEW_PURCHASE_UNIT_PRICE IS NULL )))
1939 AND ( ( Recinfo.OLD_PURCHASE_CURRENCY_CODE = p_OLD_PURCHASE_CURRENCY_CODE)
1940 OR ( ( Recinfo.OLD_PURCHASE_CURRENCY_CODE IS NULL )
1941 AND ( p_OLD_PURCHASE_CURRENCY_CODE IS NULL )))
1942 AND ( ( Recinfo.NEW_PURCHASE_CURRENCY_CODE = p_NEW_PURCHASE_CURRENCY_CODE)
1943 OR ( ( Recinfo.NEW_PURCHASE_CURRENCY_CODE IS NULL )
1944 AND ( p_NEW_PURCHASE_CURRENCY_CODE IS NULL )))
1945 AND ( ( Recinfo.OLD_SALES_UNIT_PRICE = p_OLD_SALES_UNIT_PRICE)
1946 OR ( ( Recinfo.OLD_SALES_UNIT_PRICE IS NULL )
1947 AND ( p_OLD_SALES_UNIT_PRICE IS NULL )))
1948 AND ( ( Recinfo.NEW_SALES_UNIT_PRICE = p_NEW_SALES_UNIT_PRICE)
1949 OR ( ( Recinfo.NEW_SALES_UNIT_PRICE IS NULL )
1950 AND ( p_NEW_SALES_UNIT_PRICE IS NULL )))
1951 AND ( ( Recinfo.OLD_SALES_CURRENCY_CODE = p_OLD_SALES_CURRENCY_CODE)
1952 OR ( ( Recinfo.OLD_SALES_CURRENCY_CODE IS NULL )
1953 AND ( p_OLD_SALES_CURRENCY_CODE IS NULL )))
1954 AND ( ( Recinfo.NEW_SALES_CURRENCY_CODE = p_NEW_SALES_CURRENCY_CODE)
1955 OR ( ( Recinfo.NEW_SALES_CURRENCY_CODE IS NULL )
1956 AND ( p_NEW_SALES_CURRENCY_CODE IS NULL )))
1957 AND ( ( Recinfo.OLD_OPERATIONAL_STATUS_CODE = p_OLD_OPERATIONAL_STATUS_CODE)
1958 OR ( ( Recinfo.OLD_OPERATIONAL_STATUS_CODE IS NULL )
1959 AND ( p_OLD_OPERATIONAL_STATUS_CODE IS NULL )))
1960 AND ( ( Recinfo.NEW_OPERATIONAL_STATUS_CODE = p_NEW_OPERATIONAL_STATUS_CODE)
1961 OR ( ( Recinfo.NEW_OPERATIONAL_STATUS_CODE IS NULL )
1965 AND ( ( Recinfo.OLD_SOURCE_CODE = p_OLD_SOURCE_CODE)
1962 AND ( p_NEW_OPERATIONAL_STATUS_CODE IS NULL )))
1963 -- End addition of columns for FA Integration
1964 -- Begin Add Code for Siebel Genesis Project
1966 OR ( ( Recinfo.OLD_SOURCE_CODE IS NULL )
1967 AND ( p_OLD_SOURCE_CODE IS NULL )))
1968 AND ( ( Recinfo.NEW_SOURCE_CODE = p_NEW_SOURCE_CODE)
1969 OR ( ( Recinfo.NEW_SOURCE_CODE IS NULL )
1970 AND ( p_NEW_SOURCE_CODE IS NULL )))
1971 -- End Add Code for Siebel Genesis Project
1972 ) THEN
1973 RETURN;
1974 ELSE
1975 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1976 APP_EXCEPTION.RAISE_EXCEPTION;
1977 END IF;
1978 END Lock_Row;
1979
1980 END CSI_ITEM_INSTANCES_H_PKG;