[Home] [Help]
PACKAGE: APPS.CSI_ITEM_INSTANCES_H_PKG
Source
1 PACKAGE CSI_ITEM_INSTANCES_H_PKG AUTHID CURRENT_USER AS
2 /* $Header: csitiihs.pls 120.4 2007/10/19 23:46:08 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 PROCEDURE Insert_Row(
11 px_INSTANCE_HISTORY_ID IN OUT NOCOPY NUMBER,
12 p_INSTANCE_ID NUMBER,
13 p_TRANSACTION_ID NUMBER,
14 p_OLD_INSTANCE_NUMBER VARCHAR2,
15 p_NEW_INSTANCE_NUMBER VARCHAR2,
16 p_OLD_EXTERNAL_REFERENCE VARCHAR2,
17 p_NEW_EXTERNAL_REFERENCE VARCHAR2,
18 p_OLD_INVENTORY_ITEM_ID NUMBER,
19 p_NEW_INVENTORY_ITEM_ID NUMBER,
20 p_OLD_INVENTORY_REVISION VARCHAR2,
21 p_NEW_INVENTORY_REVISION VARCHAR2,
22 p_OLD_INV_MASTER_ORGZN_ID NUMBER,
23 p_NEW_INV_MASTER_ORGZN_ID NUMBER,
24 p_OLD_SERIAL_NUMBER VARCHAR2,
25 p_NEW_SERIAL_NUMBER VARCHAR2,
26 p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
27 p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
28 p_OLD_LOT_NUMBER VARCHAR2,
29 p_NEW_LOT_NUMBER VARCHAR2,
30 p_OLD_QUANTITY NUMBER,
31 p_NEW_QUANTITY NUMBER,
32 p_OLD_UNIT_OF_MEASURE VARCHAR2,
33 p_NEW_UNIT_OF_MEASURE VARCHAR2,
34 p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
35 p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
36 p_OLD_INSTANCE_CONDITION_ID NUMBER,
37 p_NEW_INSTANCE_CONDITION_ID NUMBER,
38 p_OLD_INSTANCE_STATUS_ID NUMBER,
39 p_NEW_INSTANCE_STATUS_ID NUMBER,
40 p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
41 p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
42 p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
43 p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
44 p_OLD_SELLABLE_FLAG VARCHAR2,
45 p_NEW_SELLABLE_FLAG VARCHAR2,
46 p_OLD_SYSTEM_ID NUMBER,
47 p_NEW_SYSTEM_ID NUMBER,
48 p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
49 p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
50 p_OLD_ACTIVE_START_DATE DATE,
51 p_NEW_ACTIVE_START_DATE DATE,
52 p_OLD_ACTIVE_END_DATE DATE,
53 p_NEW_ACTIVE_END_DATE DATE,
54 p_OLD_LOCATION_TYPE_CODE VARCHAR2,
55 p_NEW_LOCATION_TYPE_CODE VARCHAR2,
56 p_OLD_LOCATION_ID NUMBER,
57 p_NEW_LOCATION_ID NUMBER,
58 p_OLD_INV_ORGANIZATION_ID NUMBER,
59 p_NEW_INV_ORGANIZATION_ID NUMBER,
60 p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
61 p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
62 p_OLD_INV_LOCATOR_ID NUMBER,
63 p_NEW_INV_LOCATOR_ID NUMBER,
64 p_OLD_PA_PROJECT_ID NUMBER,
65 p_NEW_PA_PROJECT_ID NUMBER,
66 p_OLD_PA_PROJECT_TASK_ID NUMBER,
67 p_NEW_PA_PROJECT_TASK_ID NUMBER,
68 p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
69 p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
70 p_OLD_WIP_JOB_ID NUMBER,
71 p_NEW_WIP_JOB_ID NUMBER,
72 p_OLD_PO_ORDER_LINE_ID NUMBER,
73 p_NEW_PO_ORDER_LINE_ID NUMBER,
74 p_OLD_COMPLETENESS_FLAG VARCHAR2,
75 p_NEW_COMPLETENESS_FLAG VARCHAR2,
76 p_FULL_DUMP_FLAG VARCHAR2,
77 p_OLD_CONTEXT VARCHAR2,
78 p_NEW_CONTEXT VARCHAR2,
79 p_OLD_ATTRIBUTE1 VARCHAR2,
80 p_NEW_ATTRIBUTE1 VARCHAR2,
81 p_OLD_ATTRIBUTE2 VARCHAR2,
82 p_NEW_ATTRIBUTE2 VARCHAR2,
83 p_OLD_ATTRIBUTE3 VARCHAR2,
84 p_NEW_ATTRIBUTE3 VARCHAR2,
85 p_OLD_ATTRIBUTE4 VARCHAR2,
86 p_NEW_ATTRIBUTE4 VARCHAR2,
87 p_OLD_ATTRIBUTE5 VARCHAR2,
88 p_NEW_ATTRIBUTE5 VARCHAR2,
89 p_OLD_ATTRIBUTE6 VARCHAR2,
90 p_NEW_ATTRIBUTE6 VARCHAR2,
91 p_OLD_ATTRIBUTE7 VARCHAR2,
92 p_NEW_ATTRIBUTE7 VARCHAR2,
93 p_OLD_ATTRIBUTE8 VARCHAR2,
94 p_NEW_ATTRIBUTE8 VARCHAR2,
95 p_OLD_ATTRIBUTE9 VARCHAR2,
96 p_NEW_ATTRIBUTE9 VARCHAR2,
97 p_OLD_ATTRIBUTE10 VARCHAR2,
98 p_NEW_ATTRIBUTE10 VARCHAR2,
99 p_OLD_ATTRIBUTE11 VARCHAR2,
100 p_NEW_ATTRIBUTE11 VARCHAR2,
101 p_OLD_ATTRIBUTE12 VARCHAR2,
102 p_NEW_ATTRIBUTE12 VARCHAR2,
103 p_OLD_ATTRIBUTE13 VARCHAR2,
104 p_NEW_ATTRIBUTE13 VARCHAR2,
105 p_OLD_ATTRIBUTE14 VARCHAR2,
106 p_NEW_ATTRIBUTE14 VARCHAR2,
107 p_OLD_ATTRIBUTE15 VARCHAR2,
108 p_NEW_ATTRIBUTE15 VARCHAR2,
109 p_CREATED_BY NUMBER,
110 p_CREATION_DATE DATE,
111 p_LAST_UPDATED_BY NUMBER,
112 p_LAST_UPDATE_DATE DATE,
113 p_LAST_UPDATE_LOGIN NUMBER,
114 p_OBJECT_VERSION_NUMBER NUMBER,
115 p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
116 p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
117 p_OLD_INST_LOC_ID NUMBER,
118 p_NEW_INST_LOC_ID NUMBER,
119 p_OLD_INST_USAGE_CODE VARCHAR2,
120 p_NEW_INST_USAGE_CODE VARCHAR2,
121 p_OLD_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
122 p_NEW_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
123 p_OLD_CONFIG_INST_REV_NUM NUMBER,
124 p_NEW_CONFIG_INST_REV_NUM NUMBER,
125 p_OLD_CONFIG_VALID_STATUS VARCHAR2,
126 p_NEW_CONFIG_VALID_STATUS VARCHAR2,
127 p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
128 p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
129 p_OLD_INSTALL_DATE DATE,
130 p_NEW_INSTALL_DATE DATE,
131 p_OLD_RETURN_BY_DATE DATE,
132 p_NEW_RETURN_BY_DATE DATE,
133 p_OLD_ACTUAL_RETURN_DATE DATE,
134 p_NEW_ACTUAL_RETURN_DATE DATE,
135 p_OLD_LAST_OE_AGREEMENT_ID NUMBER := fnd_api.g_miss_num,
136 p_NEW_LAST_OE_AGREEMENT_ID NUMBER := fnd_api.g_miss_num,
137 p_OLD_LAST_OE_ORDER_LINE_ID NUMBER := fnd_api.g_miss_num,
138 p_NEW_LAST_OE_ORDER_LINE_ID NUMBER := fnd_api.g_miss_num,
139 p_OLD_LAST_OE_RMA_LINE_ID NUMBER := fnd_api.g_miss_num,
140 p_NEW_LAST_OE_RMA_LINE_ID NUMBER := fnd_api.g_miss_num,
141 p_OLD_LAST_WIP_JOB_ID NUMBER := fnd_api.g_miss_num,
142 p_NEW_LAST_WIP_JOB_ID NUMBER := fnd_api.g_miss_num,
143 p_OLD_LAST_PO_PO_LINE_ID NUMBER := fnd_api.g_miss_num,
144 p_NEW_LAST_PO_PO_LINE_ID NUMBER := fnd_api.g_miss_num,
145 p_OLD_LAST_PA_PROJECT_ID NUMBER := fnd_api.g_miss_num,
146 p_NEW_LAST_PA_PROJECT_ID NUMBER := fnd_api.g_miss_num,
147 p_OLD_LAST_PA_TASK_ID NUMBER := fnd_api.g_miss_num,
148 p_NEW_LAST_PA_TASK_ID NUMBER := fnd_api.g_miss_num,
149 p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num,
150 p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num,
151 p_OLD_LAST_OE_PO_NUMBER VARCHAR2 := fnd_api.g_miss_char,
152 p_NEW_LAST_OE_PO_NUMBER VARCHAR2 := fnd_api.g_miss_char,
153 --start of eam integration changes--
154 p_OLD_NETWORK_ASSET_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
155 p_NEW_NETWORK_ASSET_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_OLD_MAINTAINABLE_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_NEW_MAINTAINABLE_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
158 p_OLD_PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
159 p_NEW_PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
160 p_OLD_ASSET_CRITICALITY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
161 p_NEW_ASSET_CRITICALITY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
162 p_OLD_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
163 p_NEW_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
164 p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
165 p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
166 p_OLD_INSTANTIATION_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
167 p_NEW_INSTANTIATION_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
168 p_OLD_LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
169 p_NEW_LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
170 p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
171 p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
172 p_OLD_CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
173 p_NEW_CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
174 p_OLD_SUP_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
175 p_NEW_SUP_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
176 p_OLD_ATTRIBUTE16 VARCHAR2 := FND_API.G_MISS_CHAR,
177 p_NEW_ATTRIBUTE16 VARCHAR2 := FND_API.G_MISS_CHAR,
178 p_OLD_ATTRIBUTE17 VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_NEW_ATTRIBUTE17 VARCHAR2 := FND_API.G_MISS_CHAR,
180 p_OLD_ATTRIBUTE18 VARCHAR2 := FND_API.G_MISS_CHAR,
181 p_NEW_ATTRIBUTE18 VARCHAR2 := FND_API.G_MISS_CHAR,
182 p_OLD_ATTRIBUTE19 VARCHAR2 := FND_API.G_MISS_CHAR,
183 p_NEW_ATTRIBUTE19 VARCHAR2 := FND_API.G_MISS_CHAR,
184 p_OLD_ATTRIBUTE20 VARCHAR2 := FND_API.G_MISS_CHAR,
185 p_NEW_ATTRIBUTE20 VARCHAR2 := FND_API.G_MISS_CHAR,
186 p_OLD_ATTRIBUTE21 VARCHAR2 := FND_API.G_MISS_CHAR,
187 p_NEW_ATTRIBUTE21 VARCHAR2 := FND_API.G_MISS_CHAR,
188 p_OLD_ATTRIBUTE22 VARCHAR2 := FND_API.G_MISS_CHAR,
189 p_NEW_ATTRIBUTE22 VARCHAR2 := FND_API.G_MISS_CHAR,
190 p_OLD_ATTRIBUTE23 VARCHAR2 := FND_API.G_MISS_CHAR,
191 p_NEW_ATTRIBUTE23 VARCHAR2 := FND_API.G_MISS_CHAR,
192 p_OLD_ATTRIBUTE24 VARCHAR2 := FND_API.G_MISS_CHAR,
193 p_NEW_ATTRIBUTE24 VARCHAR2 := FND_API.G_MISS_CHAR,
194 p_OLD_ATTRIBUTE25 VARCHAR2 := FND_API.G_MISS_CHAR,
195 p_NEW_ATTRIBUTE25 VARCHAR2 := FND_API.G_MISS_CHAR,
196 p_OLD_ATTRIBUTE26 VARCHAR2 := FND_API.G_MISS_CHAR,
197 p_NEW_ATTRIBUTE26 VARCHAR2 := FND_API.G_MISS_CHAR,
198 p_OLD_ATTRIBUTE27 VARCHAR2 := FND_API.G_MISS_CHAR,
199 p_NEW_ATTRIBUTE27 VARCHAR2 := FND_API.G_MISS_CHAR,
200 p_OLD_ATTRIBUTE28 VARCHAR2 := FND_API.G_MISS_CHAR,
201 p_NEW_ATTRIBUTE28 VARCHAR2 := FND_API.G_MISS_CHAR,
202 p_OLD_ATTRIBUTE29 VARCHAR2 := FND_API.G_MISS_CHAR,
203 p_NEW_ATTRIBUTE29 VARCHAR2 := FND_API.G_MISS_CHAR,
204 p_OLD_ATTRIBUTE30 VARCHAR2 := FND_API.G_MISS_CHAR,
205 p_NEW_ATTRIBUTE30 VARCHAR2 := FND_API.G_MISS_CHAR,
206 --end of eam integration changes--
207 -- Addition of columns for FA Integration
208 p_OLD_PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
209 p_NEW_PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
210 p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
211 p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
212 p_OLD_PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
213 p_NEW_PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
214 p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
215 p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
216 p_OLD_SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
217 p_NEW_SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
218 p_OLD_SALES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
219 p_NEW_SALES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
220 p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
221 p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
222 -- End addition of columns for FA Integration
223 -- Begin Add Code for Siebel Genesis Project
224 p_OLD_SOURCE_CODE VARCHAR2,
225 p_NEW_SOURCE_CODE VARCHAR2
226 -- End Add Code for Siebel Genesis Project
227 );
228
229 PROCEDURE Update_Row(
230 p_INSTANCE_HISTORY_ID NUMBER,
231 p_INSTANCE_ID NUMBER,
232 p_TRANSACTION_ID NUMBER,
233 p_OLD_INSTANCE_NUMBER VARCHAR2,
234 p_NEW_INSTANCE_NUMBER VARCHAR2,
235 p_OLD_EXTERNAL_REFERENCE VARCHAR2,
236 p_NEW_EXTERNAL_REFERENCE VARCHAR2,
237 p_OLD_INVENTORY_ITEM_ID NUMBER,
238 p_NEW_INVENTORY_ITEM_ID NUMBER,
239 p_OLD_INVENTORY_REVISION VARCHAR2,
240 p_NEW_INVENTORY_REVISION VARCHAR2,
241 p_OLD_INV_MASTER_ORGZN_ID NUMBER,
242 p_NEW_INV_MASTER_ORGZN_ID NUMBER,
243 p_OLD_SERIAL_NUMBER VARCHAR2,
244 p_NEW_SERIAL_NUMBER VARCHAR2,
245 p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
246 p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
247 p_OLD_LOT_NUMBER VARCHAR2,
248 p_NEW_LOT_NUMBER VARCHAR2,
249 p_OLD_QUANTITY NUMBER,
250 p_NEW_QUANTITY NUMBER,
251 p_OLD_UNIT_OF_MEASURE VARCHAR2,
252 p_NEW_UNIT_OF_MEASURE VARCHAR2,
253 p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
254 p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
255 p_OLD_INSTANCE_CONDITION_ID NUMBER,
256 p_NEW_INSTANCE_CONDITION_ID NUMBER,
257 p_OLD_INSTANCE_STATUS_ID NUMBER,
258 p_NEW_INSTANCE_STATUS_ID NUMBER,
259 p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
260 p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
261 p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
262 p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
263 p_OLD_SELLABLE_FLAG VARCHAR2,
264 p_NEW_SELLABLE_FLAG VARCHAR2,
265 p_OLD_SYSTEM_ID NUMBER,
266 p_NEW_SYSTEM_ID NUMBER,
267 p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
268 p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
269 p_OLD_ACTIVE_START_DATE DATE,
270 p_NEW_ACTIVE_START_DATE DATE,
271 p_OLD_ACTIVE_END_DATE DATE,
272 p_NEW_ACTIVE_END_DATE DATE,
273 p_OLD_LOCATION_TYPE_CODE VARCHAR2,
274 p_NEW_LOCATION_TYPE_CODE VARCHAR2,
275 p_OLD_LOCATION_ID NUMBER,
276 p_NEW_LOCATION_ID NUMBER,
277 p_OLD_INV_ORGANIZATION_ID NUMBER,
278 p_NEW_INV_ORGANIZATION_ID NUMBER,
279 p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
280 p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
281 p_OLD_INV_LOCATOR_ID NUMBER,
282 p_NEW_INV_LOCATOR_ID NUMBER,
283 p_OLD_PA_PROJECT_ID NUMBER,
284 p_NEW_PA_PROJECT_ID NUMBER,
285 p_OLD_PA_PROJECT_TASK_ID NUMBER,
286 p_NEW_PA_PROJECT_TASK_ID NUMBER,
287 p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
288 p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
289 p_OLD_WIP_JOB_ID NUMBER,
290 p_NEW_WIP_JOB_ID NUMBER,
291 p_OLD_PO_ORDER_LINE_ID NUMBER,
292 p_NEW_PO_ORDER_LINE_ID NUMBER,
293 p_OLD_COMPLETENESS_FLAG VARCHAR2,
294 p_NEW_COMPLETENESS_FLAG VARCHAR2,
295 p_FULL_DUMP_FLAG VARCHAR2,
296 p_OLD_CONTEXT VARCHAR2,
297 p_NEW_CONTEXT VARCHAR2,
298 p_OLD_ATTRIBUTE1 VARCHAR2,
299 p_NEW_ATTRIBUTE1 VARCHAR2,
300 p_OLD_ATTRIBUTE2 VARCHAR2,
301 p_NEW_ATTRIBUTE2 VARCHAR2,
302 p_OLD_ATTRIBUTE3 VARCHAR2,
303 p_NEW_ATTRIBUTE3 VARCHAR2,
304 p_OLD_ATTRIBUTE4 VARCHAR2,
305 p_NEW_ATTRIBUTE4 VARCHAR2,
306 p_OLD_ATTRIBUTE5 VARCHAR2,
307 p_NEW_ATTRIBUTE5 VARCHAR2,
311 p_NEW_ATTRIBUTE7 VARCHAR2,
308 p_OLD_ATTRIBUTE6 VARCHAR2,
309 p_NEW_ATTRIBUTE6 VARCHAR2,
310 p_OLD_ATTRIBUTE7 VARCHAR2,
312 p_OLD_ATTRIBUTE8 VARCHAR2,
313 p_NEW_ATTRIBUTE8 VARCHAR2,
314 p_OLD_ATTRIBUTE9 VARCHAR2,
315 p_NEW_ATTRIBUTE9 VARCHAR2,
316 p_OLD_ATTRIBUTE10 VARCHAR2,
317 p_NEW_ATTRIBUTE10 VARCHAR2,
318 p_OLD_ATTRIBUTE11 VARCHAR2,
319 p_NEW_ATTRIBUTE11 VARCHAR2,
320 p_OLD_ATTRIBUTE12 VARCHAR2,
321 p_NEW_ATTRIBUTE12 VARCHAR2,
322 p_OLD_ATTRIBUTE13 VARCHAR2,
323 p_NEW_ATTRIBUTE13 VARCHAR2,
324 p_OLD_ATTRIBUTE14 VARCHAR2,
325 p_NEW_ATTRIBUTE14 VARCHAR2,
326 p_OLD_ATTRIBUTE15 VARCHAR2,
327 p_NEW_ATTRIBUTE15 VARCHAR2,
328 p_CREATED_BY NUMBER,
329 p_CREATION_DATE DATE,
330 p_LAST_UPDATED_BY NUMBER,
331 p_LAST_UPDATE_DATE DATE,
332 p_LAST_UPDATE_LOGIN NUMBER,
333 p_OBJECT_VERSION_NUMBER NUMBER,
334 p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
335 p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
336 p_OLD_INST_LOC_ID NUMBER,
337 p_NEW_INST_LOC_ID NUMBER,
338 p_OLD_INST_USAGE_CODE VARCHAR2,
339 p_NEW_INST_USAGE_CODE VARCHAR2,
340 p_OLD_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
341 p_NEW_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
342 p_OLD_CONFIG_INST_REV_NUM NUMBER,
343 p_NEW_CONFIG_INST_REV_NUM NUMBER,
344 p_OLD_CONFIG_VALID_STATUS VARCHAR2,
345 p_NEW_CONFIG_VALID_STATUS VARCHAR2,
346 p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
347 p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
348 p_OLD_INSTALL_DATE DATE,
349 p_NEW_INSTALL_DATE DATE,
350 p_OLD_RETURN_BY_DATE DATE,
351 p_NEW_RETURN_BY_DATE DATE,
352 p_OLD_ACTUAL_RETURN_DATE DATE,
353 p_NEW_ACTUAL_RETURN_DATE DATE,
354 p_OLD_LAST_OE_AGREEMENT_ID NUMBER := fnd_api.g_miss_num,
355 p_NEW_LAST_OE_AGREEMENT_ID NUMBER := fnd_api.g_miss_num,
356 p_OLD_LAST_OE_ORDER_LINE_ID NUMBER := fnd_api.g_miss_num,
357 p_NEW_LAST_OE_ORDER_LINE_ID NUMBER := fnd_api.g_miss_num,
358 p_OLD_LAST_OE_RMA_LINE_ID NUMBER := fnd_api.g_miss_num,
359 p_NEW_LAST_OE_RMA_LINE_ID NUMBER := fnd_api.g_miss_num,
360 p_OLD_LAST_WIP_JOB_ID NUMBER := fnd_api.g_miss_num,
361 p_NEW_LAST_WIP_JOB_ID NUMBER := fnd_api.g_miss_num,
362 p_OLD_LAST_PO_PO_LINE_ID NUMBER := fnd_api.g_miss_num,
363 p_NEW_LAST_PO_PO_LINE_ID NUMBER := fnd_api.g_miss_num,
364 p_OLD_LAST_PA_PROJECT_ID NUMBER := fnd_api.g_miss_num,
365 p_NEW_LAST_PA_PROJECT_ID NUMBER := fnd_api.g_miss_num,
366 p_OLD_LAST_PA_TASK_ID NUMBER := fnd_api.g_miss_num,
367 p_NEW_LAST_PA_TASK_ID NUMBER := fnd_api.g_miss_num,
368 p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num,
369 p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num,
370 p_OLD_LAST_OE_PO_NUMBER VARCHAR2 := fnd_api.g_miss_char,
371 p_NEW_LAST_OE_PO_NUMBER VARCHAR2 := fnd_api.g_miss_char,
372 --start of eam integration changes--
373 p_OLD_NETWORK_ASSET_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
374 p_NEW_NETWORK_ASSET_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
375 p_OLD_MAINTAINABLE_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
376 p_NEW_MAINTAINABLE_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
377 p_OLD_PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
378 p_NEW_PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
379 p_OLD_ASSET_CRITICALITY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
380 p_NEW_ASSET_CRITICALITY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
381 p_OLD_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
382 p_NEW_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
383 p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
384 p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
385 p_OLD_INSTANTIATION_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
386 p_NEW_INSTANTIATION_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
387 p_OLD_LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
388 p_NEW_LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
389 p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
390 p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
391 p_OLD_CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
392 p_NEW_CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
393 p_OLD_SUP_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
394 p_NEW_SUP_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
395 p_OLD_ATTRIBUTE16 VARCHAR2 := FND_API.G_MISS_CHAR,
396 p_NEW_ATTRIBUTE16 VARCHAR2 := FND_API.G_MISS_CHAR,
397 p_OLD_ATTRIBUTE17 VARCHAR2 := FND_API.G_MISS_CHAR,
398 p_NEW_ATTRIBUTE17 VARCHAR2 := FND_API.G_MISS_CHAR,
399 p_OLD_ATTRIBUTE18 VARCHAR2 := FND_API.G_MISS_CHAR,
400 p_NEW_ATTRIBUTE18 VARCHAR2 := FND_API.G_MISS_CHAR,
404 p_NEW_ATTRIBUTE20 VARCHAR2 := FND_API.G_MISS_CHAR,
401 p_OLD_ATTRIBUTE19 VARCHAR2 := FND_API.G_MISS_CHAR,
402 p_NEW_ATTRIBUTE19 VARCHAR2 := FND_API.G_MISS_CHAR,
403 p_OLD_ATTRIBUTE20 VARCHAR2 := FND_API.G_MISS_CHAR,
405 p_OLD_ATTRIBUTE21 VARCHAR2 := FND_API.G_MISS_CHAR,
406 p_NEW_ATTRIBUTE21 VARCHAR2 := FND_API.G_MISS_CHAR,
407 p_OLD_ATTRIBUTE22 VARCHAR2 := FND_API.G_MISS_CHAR,
408 p_NEW_ATTRIBUTE22 VARCHAR2 := FND_API.G_MISS_CHAR,
409 p_OLD_ATTRIBUTE23 VARCHAR2 := FND_API.G_MISS_CHAR,
410 p_NEW_ATTRIBUTE23 VARCHAR2 := FND_API.G_MISS_CHAR,
411 p_OLD_ATTRIBUTE24 VARCHAR2 := FND_API.G_MISS_CHAR,
412 p_NEW_ATTRIBUTE24 VARCHAR2 := FND_API.G_MISS_CHAR,
413 p_OLD_ATTRIBUTE25 VARCHAR2 := FND_API.G_MISS_CHAR,
414 p_NEW_ATTRIBUTE25 VARCHAR2 := FND_API.G_MISS_CHAR,
415 p_OLD_ATTRIBUTE26 VARCHAR2 := FND_API.G_MISS_CHAR,
416 p_NEW_ATTRIBUTE26 VARCHAR2 := FND_API.G_MISS_CHAR,
417 p_OLD_ATTRIBUTE27 VARCHAR2 := FND_API.G_MISS_CHAR,
418 p_NEW_ATTRIBUTE27 VARCHAR2 := FND_API.G_MISS_CHAR,
419 p_OLD_ATTRIBUTE28 VARCHAR2 := FND_API.G_MISS_CHAR,
420 p_NEW_ATTRIBUTE28 VARCHAR2 := FND_API.G_MISS_CHAR,
421 p_OLD_ATTRIBUTE29 VARCHAR2 := FND_API.G_MISS_CHAR,
422 p_NEW_ATTRIBUTE29 VARCHAR2 := FND_API.G_MISS_CHAR,
423 p_OLD_ATTRIBUTE30 VARCHAR2 := FND_API.G_MISS_CHAR,
424 p_NEW_ATTRIBUTE30 VARCHAR2 := FND_API.G_MISS_CHAR,
425 --end of eam integration changes--
426 -- Addition of columns for FA Integration
427 p_OLD_PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
428 p_NEW_PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
429 p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
430 p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
431 p_OLD_PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
432 p_NEW_PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
433 p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
434 p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
435 p_OLD_SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
436 p_NEW_SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
437 p_OLD_SALES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
438 p_NEW_SALES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
439 p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
440 p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
441 -- End addition of columns for FA Integration
442 -- Begin Add Code for Siebel Genesis Project
443 p_OLD_SOURCE_CODE VARCHAR2,
444 p_NEW_SOURCE_CODE VARCHAR2
445 -- End Add Code for Siebel Genesis Project
446 );
447
448 PROCEDURE Lock_Row(
449 p_INSTANCE_HISTORY_ID NUMBER,
450 p_INSTANCE_ID NUMBER,
451 p_TRANSACTION_ID NUMBER,
452 p_OLD_INSTANCE_NUMBER VARCHAR2,
453 p_NEW_INSTANCE_NUMBER VARCHAR2,
454 p_OLD_EXTERNAL_REFERENCE VARCHAR2,
455 p_NEW_EXTERNAL_REFERENCE VARCHAR2,
456 p_OLD_INVENTORY_ITEM_ID NUMBER,
457 p_NEW_INVENTORY_ITEM_ID NUMBER,
458 p_OLD_INVENTORY_REVISION VARCHAR2,
459 p_NEW_INVENTORY_REVISION VARCHAR2,
460 p_OLD_INV_MASTER_ORGZN_ID NUMBER,
461 p_NEW_INV_MASTER_ORGZN_ID NUMBER,
462 p_OLD_SERIAL_NUMBER VARCHAR2,
463 p_NEW_SERIAL_NUMBER VARCHAR2,
464 p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
465 p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
466 p_OLD_LOT_NUMBER VARCHAR2,
467 p_NEW_LOT_NUMBER VARCHAR2,
468 p_OLD_QUANTITY NUMBER,
469 p_NEW_QUANTITY NUMBER,
470 p_OLD_UNIT_OF_MEASURE VARCHAR2,
471 p_NEW_UNIT_OF_MEASURE VARCHAR2,
472 p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
473 p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
474 p_OLD_INSTANCE_CONDITION_ID NUMBER,
475 p_NEW_INSTANCE_CONDITION_ID NUMBER,
476 p_OLD_INSTANCE_STATUS_ID NUMBER,
477 p_NEW_INSTANCE_STATUS_ID NUMBER,
478 p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
479 p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
480 p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
481 p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
482 p_OLD_SELLABLE_FLAG VARCHAR2,
483 p_NEW_SELLABLE_FLAG VARCHAR2,
484 p_OLD_SYSTEM_ID NUMBER,
485 p_NEW_SYSTEM_ID NUMBER,
486 p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
487 p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
488 p_OLD_ACTIVE_START_DATE DATE,
489 p_NEW_ACTIVE_START_DATE DATE,
490 p_OLD_ACTIVE_END_DATE DATE,
491 p_NEW_ACTIVE_END_DATE DATE,
492 p_OLD_LOCATION_TYPE_CODE VARCHAR2,
493 p_NEW_LOCATION_TYPE_CODE VARCHAR2,
494 p_OLD_LOCATION_ID NUMBER,
495 p_NEW_LOCATION_ID NUMBER,
496 p_OLD_INV_ORGANIZATION_ID NUMBER,
497 p_NEW_INV_ORGANIZATION_ID NUMBER,
498 p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
499 p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
500 p_OLD_INV_LOCATOR_ID NUMBER,
501 p_NEW_INV_LOCATOR_ID NUMBER,
502 p_OLD_PA_PROJECT_ID NUMBER,
503 p_NEW_PA_PROJECT_ID NUMBER,
507 p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
504 p_OLD_PA_PROJECT_TASK_ID NUMBER,
505 p_NEW_PA_PROJECT_TASK_ID NUMBER,
506 p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
508 p_OLD_WIP_JOB_ID NUMBER,
509 p_NEW_WIP_JOB_ID NUMBER,
510 p_OLD_PO_ORDER_LINE_ID NUMBER,
511 p_NEW_PO_ORDER_LINE_ID NUMBER,
512 p_OLD_COMPLETENESS_FLAG VARCHAR2,
513 p_NEW_COMPLETENESS_FLAG VARCHAR2,
514 p_FULL_DUMP_FLAG VARCHAR2,
515 p_OLD_CONTEXT VARCHAR2,
516 p_NEW_CONTEXT VARCHAR2,
517 p_OLD_ATTRIBUTE1 VARCHAR2,
518 p_NEW_ATTRIBUTE1 VARCHAR2,
519 p_OLD_ATTRIBUTE2 VARCHAR2,
520 p_NEW_ATTRIBUTE2 VARCHAR2,
521 p_OLD_ATTRIBUTE3 VARCHAR2,
522 p_NEW_ATTRIBUTE3 VARCHAR2,
523 p_OLD_ATTRIBUTE4 VARCHAR2,
524 p_NEW_ATTRIBUTE4 VARCHAR2,
525 p_OLD_ATTRIBUTE5 VARCHAR2,
526 p_NEW_ATTRIBUTE5 VARCHAR2,
527 p_OLD_ATTRIBUTE6 VARCHAR2,
528 p_NEW_ATTRIBUTE6 VARCHAR2,
529 p_OLD_ATTRIBUTE7 VARCHAR2,
530 p_NEW_ATTRIBUTE7 VARCHAR2,
531 p_OLD_ATTRIBUTE8 VARCHAR2,
532 p_NEW_ATTRIBUTE8 VARCHAR2,
533 p_OLD_ATTRIBUTE9 VARCHAR2,
534 p_NEW_ATTRIBUTE9 VARCHAR2,
535 p_OLD_ATTRIBUTE10 VARCHAR2,
536 p_NEW_ATTRIBUTE10 VARCHAR2,
537 p_OLD_ATTRIBUTE11 VARCHAR2,
538 p_NEW_ATTRIBUTE11 VARCHAR2,
539 p_OLD_ATTRIBUTE12 VARCHAR2,
540 p_NEW_ATTRIBUTE12 VARCHAR2,
541 p_OLD_ATTRIBUTE13 VARCHAR2,
542 p_NEW_ATTRIBUTE13 VARCHAR2,
543 p_OLD_ATTRIBUTE14 VARCHAR2,
544 p_NEW_ATTRIBUTE14 VARCHAR2,
545 p_OLD_ATTRIBUTE15 VARCHAR2,
546 p_NEW_ATTRIBUTE15 VARCHAR2,
547 p_CREATED_BY NUMBER,
548 p_CREATION_DATE DATE,
549 p_LAST_UPDATED_BY NUMBER,
550 p_LAST_UPDATE_DATE DATE,
551 p_LAST_UPDATE_LOGIN NUMBER,
552 p_OBJECT_VERSION_NUMBER NUMBER,
553 p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
554 p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
555 p_OLD_INST_LOC_ID NUMBER,
556 p_NEW_INST_LOC_ID NUMBER,
557 p_OLD_INST_USAGE_CODE VARCHAR2 ,
558 p_NEW_INST_USAGE_CODE VARCHAR2,
559 p_OLD_CONFIG_INST_REV_NUM NUMBER,
560 p_NEW_CONFIG_INST_REV_NUM NUMBER,
561 p_OLD_CONFIG_VALID_STATUS VARCHAR2,
562 p_NEW_CONFIG_VALID_STATUS VARCHAR2,
563 p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
564 p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
565 p_OLD_LAST_OE_AGREEMENT_ID NUMBER,
566 p_NEW_LAST_OE_AGREEMENT_ID NUMBER,
567 p_OLD_LAST_OE_ORDER_LINE_ID NUMBER ,
568 p_NEW_LAST_OE_ORDER_LINE_ID NUMBER ,
569 p_OLD_LAST_OE_RMA_LINE_ID NUMBER ,
570 p_NEW_LAST_OE_RMA_LINE_ID NUMBER ,
571 p_OLD_LAST_WIP_JOB_ID NUMBER ,
572 p_NEW_LAST_WIP_JOB_ID NUMBER ,
573 p_OLD_LAST_PO_PO_LINE_ID NUMBER ,
574 p_NEW_LAST_PO_PO_LINE_ID NUMBER ,
575 p_OLD_LAST_PA_PROJECT_ID NUMBER ,
576 p_NEW_LAST_PA_PROJECT_ID NUMBER ,
577 p_OLD_LAST_PA_TASK_ID NUMBER ,
578 p_NEW_LAST_PA_TASK_ID NUMBER ,
579 p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER ,
580 p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER ,
581 p_OLD_LAST_OE_PO_NUMBER VARCHAR2,
582 p_NEW_LAST_OE_PO_NUMBER VARCHAR2,
583 --start of eam integration changes--
584 p_OLD_NETWORK_ASSET_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
585 p_NEW_NETWORK_ASSET_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
586 p_OLD_MAINTAINABLE_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
587 p_NEW_MAINTAINABLE_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
588 p_OLD_PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
589 p_NEW_PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
590 p_OLD_ASSET_CRITICALITY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
591 p_NEW_ASSET_CRITICALITY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
592 p_OLD_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
593 p_NEW_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
594 p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
595 p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
596 p_OLD_INSTANTIATION_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
597 p_NEW_INSTANTIATION_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
598 p_OLD_LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
599 p_NEW_LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
600 p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
601 p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2 := FND_API.G_MISS_CHAR,
602 p_OLD_CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
603 p_NEW_CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
604 p_OLD_SUP_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
605 p_NEW_SUP_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
606 p_OLD_ATTRIBUTE16 VARCHAR2 := FND_API.G_MISS_CHAR,
607 p_NEW_ATTRIBUTE16 VARCHAR2 := FND_API.G_MISS_CHAR,
611 p_NEW_ATTRIBUTE18 VARCHAR2 := FND_API.G_MISS_CHAR,
608 p_OLD_ATTRIBUTE17 VARCHAR2 := FND_API.G_MISS_CHAR,
609 p_NEW_ATTRIBUTE17 VARCHAR2 := FND_API.G_MISS_CHAR,
610 p_OLD_ATTRIBUTE18 VARCHAR2 := FND_API.G_MISS_CHAR,
612 p_OLD_ATTRIBUTE19 VARCHAR2 := FND_API.G_MISS_CHAR,
613 p_NEW_ATTRIBUTE19 VARCHAR2 := FND_API.G_MISS_CHAR,
614 p_OLD_ATTRIBUTE20 VARCHAR2 := FND_API.G_MISS_CHAR,
615 p_NEW_ATTRIBUTE20 VARCHAR2 := FND_API.G_MISS_CHAR,
616 p_OLD_ATTRIBUTE21 VARCHAR2 := FND_API.G_MISS_CHAR,
617 p_NEW_ATTRIBUTE21 VARCHAR2 := FND_API.G_MISS_CHAR,
618 p_OLD_ATTRIBUTE22 VARCHAR2 := FND_API.G_MISS_CHAR,
619 p_NEW_ATTRIBUTE22 VARCHAR2 := FND_API.G_MISS_CHAR,
620 p_OLD_ATTRIBUTE23 VARCHAR2 := FND_API.G_MISS_CHAR,
621 p_NEW_ATTRIBUTE23 VARCHAR2 := FND_API.G_MISS_CHAR,
622 p_OLD_ATTRIBUTE24 VARCHAR2 := FND_API.G_MISS_CHAR,
623 p_NEW_ATTRIBUTE24 VARCHAR2 := FND_API.G_MISS_CHAR,
624 p_OLD_ATTRIBUTE25 VARCHAR2 := FND_API.G_MISS_CHAR,
625 p_NEW_ATTRIBUTE25 VARCHAR2 := FND_API.G_MISS_CHAR,
626 p_OLD_ATTRIBUTE26 VARCHAR2 := FND_API.G_MISS_CHAR,
627 p_NEW_ATTRIBUTE26 VARCHAR2 := FND_API.G_MISS_CHAR,
628 p_OLD_ATTRIBUTE27 VARCHAR2 := FND_API.G_MISS_CHAR,
629 p_NEW_ATTRIBUTE27 VARCHAR2 := FND_API.G_MISS_CHAR,
630 p_OLD_ATTRIBUTE28 VARCHAR2 := FND_API.G_MISS_CHAR,
631 p_NEW_ATTRIBUTE28 VARCHAR2 := FND_API.G_MISS_CHAR,
632 p_OLD_ATTRIBUTE29 VARCHAR2 := FND_API.G_MISS_CHAR,
633 p_NEW_ATTRIBUTE29 VARCHAR2 := FND_API.G_MISS_CHAR,
634 p_OLD_ATTRIBUTE30 VARCHAR2 := FND_API.G_MISS_CHAR,
635 p_NEW_ATTRIBUTE30 VARCHAR2 := FND_API.G_MISS_CHAR,
636 --end of eam integration changes--
637 -- Addition of columns for FA Integration
638 p_OLD_PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
639 p_NEW_PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
640 p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
641 p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
642 p_OLD_PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
643 p_NEW_PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
644 p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
645 p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
646 p_OLD_SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
647 p_NEW_SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
648 p_OLD_SALES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
649 p_NEW_SALES_CURRENCY_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
650 p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
651 p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR,
652 -- End addition of columns for FA Integration
653 -- Begin Add Code for Siebel Genesis Project
654 p_OLD_SOURCE_CODE VARCHAR2,
655 p_NEW_SOURCE_CODE VARCHAR2
656 -- End Add Code for Siebel Genesis Project
657 );
658
659 PROCEDURE Delete_Row(
660 p_INSTANCE_HISTORY_ID NUMBER);
661 End CSI_ITEM_INSTANCES_H_PKG;