[Home] [Help]
PACKAGE: APPS.CSI_TXN_HISTORY_PURGE_PVT
Source
1 PACKAGE CSI_TXN_HISTORY_PURGE_PVT AS
2 /* $Header: csivthps.pls 120.3 2005/06/17 17:37:54 appldev $ */
3 --
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_TXN_HISTORY_PURGE_PVT';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivthps.pls';
6 --
7 TYPE T_DATE is TABLE OF DATE INDEX BY BINARY_INTEGER;
8 TYPE T_NUM is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
9 TYPE T_V1 is TABLE OF VARCHAR(01) INDEX BY BINARY_INTEGER;
10 TYPE T_V3 is TABLE OF VARCHAR(03) INDEX BY BINARY_INTEGER;
11 TYPE T_V6 is TABLE OF VARCHAR(06) INDEX BY BINARY_INTEGER;
12 TYPE T_V10 is TABLE OF VARCHAR(10) INDEX BY BINARY_INTEGER;
13 TYPE T_V15 is TABLE OF VARCHAR(15) INDEX BY BINARY_INTEGER;
14 TYPE T_V20 is TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER;
15 TYPE T_V25 is TABLE OF VARCHAR(25) INDEX BY BINARY_INTEGER;
16 TYPE T_V30 is TABLE OF VARCHAR(30) INDEX BY BINARY_INTEGER;
17 TYPE T_V35 is TABLE OF VARCHAR(35) INDEX BY BINARY_INTEGER;
18 TYPE T_V40 is TABLE OF VARCHAR(40) INDEX BY BINARY_INTEGER;
19 TYPE T_V50 is TABLE OF VARCHAR(50) INDEX BY BINARY_INTEGER;
20 TYPE T_V60 is TABLE OF VARCHAR(60) INDEX BY BINARY_INTEGER;
21 TYPE T_V80 is TABLE OF VARCHAR(80) INDEX BY BINARY_INTEGER;
22 TYPE T_V85 is TABLE OF VARCHAR(85) INDEX BY BINARY_INTEGER;
23 TYPE T_V150 is TABLE OF VARCHAR(150) INDEX BY BINARY_INTEGER;
24 TYPE T_V240 is TABLE OF VARCHAR(240) INDEX BY BINARY_INTEGER;
25 TYPE T_V360 is TABLE OF VARCHAR(360) INDEX BY BINARY_INTEGER;
26 TYPE T_V1000 is TABLE OF VARCHAR(1000) INDEX BY BINARY_INTEGER;
27 TYPE T_V2000 is TABLE OF VARCHAR(2000) INDEX BY BINARY_INTEGER;
28 --
29 --
30 TYPE INSTANCE_HISTORY_REC_TAB IS RECORD
31 (
32 INSTANCE_ID T_NUM
33 ,OLD_INSTANCE_NUMBER T_V30
34 ,NEW_INSTANCE_NUMBER T_V30
35 ,OLD_EXTERNAL_REFERENCE T_V30
36 ,NEW_EXTERNAL_REFERENCE T_V30
37 ,OLD_INVENTORY_ITEM_ID T_NUM
38 ,NEW_INVENTORY_ITEM_ID T_NUM
39 ,OLD_INVENTORY_REVISION T_V3
40 ,NEW_INVENTORY_REVISION T_V3
41 ,OLD_INV_MASTER_ORG_ID T_NUM
42 ,NEW_INV_MASTER_ORG_ID T_NUM
43 ,OLD_SERIAL_NUMBER T_V30
44 ,NEW_SERIAL_NUMBER T_V30
45 ,OLD_MFG_SERIAL_NUMBER_FLAG T_V1
46 ,NEW_MFG_SERIAL_NUMBER_FLAG T_V1
47 ,OLD_LOT_NUMBER T_V80
48 ,NEW_LOT_NUMBER T_V80
49 ,OLD_QUANTITY T_NUM
50 ,NEW_QUANTITY T_NUM
51 ,OLD_UNIT_OF_MEASURE_NAME T_V30
52 ,NEW_UNIT_OF_MEASURE_NAME T_V30
53 ,OLD_UNIT_OF_MEASURE T_V3
54 ,NEW_UNIT_OF_MEASURE T_V3
55 ,OLD_ACCOUNTING_CLASS T_V30
56 ,NEW_ACCOUNTING_CLASS T_V30
57 ,OLD_ACCOUNTING_CLASS_CODE T_V10
58 ,NEW_ACCOUNTING_CLASS_CODE T_V10
59 ,OLD_INSTANCE_CONDITION T_V80
60 ,NEW_INSTANCE_CONDITION T_V80
61 ,OLD_INSTANCE_CONDITION_ID T_NUM
62 ,NEW_INSTANCE_CONDITION_ID T_NUM
63 ,OLD_INSTANCE_STATUS T_V50
64 ,NEW_INSTANCE_STATUS T_V50
65 ,OLD_INSTANCE_STATUS_ID T_NUM
66 ,NEW_INSTANCE_STATUS_ID T_NUM
67 ,OLD_CUSTOMER_VIEW_FLAG T_V1
68 ,NEW_CUSTOMER_VIEW_FLAG T_V1
69 ,OLD_MERCHANT_VIEW_FLAG T_V1
70 ,NEW_MERCHANT_VIEW_FLAG T_V1
71 ,OLD_SELLABLE_FLAG T_V1
72 ,NEW_SELLABLE_FLAG T_V1
73 ,OLD_SYSTEM_ID T_NUM
74 ,NEW_SYSTEM_ID T_NUM
75 ,OLD_SYSTEM_NAME T_V30
76 ,NEW_SYSTEM_NAME T_V30
77 ,OLD_INSTANCE_TYPE_CODE T_V30
78 ,NEW_INSTANCE_TYPE_CODE T_V30
79 ,OLD_INSTANCE_TYPE_NAME T_V240
80 ,NEW_INSTANCE_TYPE_NAME T_V240
81 ,OLD_ACTIVE_START_DATE T_DATE
82 ,NEW_ACTIVE_START_DATE T_DATE
83 ,OLD_ACTIVE_END_DATE T_DATE
84 ,NEW_ACTIVE_END_DATE T_DATE
85 ,OLD_LOCATION_TYPE_CODE T_V30
86 ,NEW_LOCATION_TYPE_CODE T_V30
87 ,OLD_LOCATION_ID T_NUM
88 ,NEW_LOCATION_ID T_NUM
89 ,OLD_INV_ORGANIZATION_ID T_NUM
90 ,NEW_INV_ORGANIZATION_ID T_NUM
91 ,OLD_INV_ORGANIZATION_NAME T_V60
92 ,NEW_INV_ORGANIZATION_NAME T_V60
93 ,OLD_INV_SUBINVENTORY_NAME T_V10
94 ,NEW_INV_SUBINVENTORY_NAME T_V10
95 ,OLD_INV_LOCATOR_ID T_NUM
96 ,NEW_INV_LOCATOR_ID T_NUM
97 ,OLD_PA_PROJECT_ID T_NUM
98 ,NEW_PA_PROJECT_ID T_NUM
99 ,OLD_PA_PROJECT_TASK_ID T_NUM
100 ,NEW_PA_PROJECT_TASK_ID T_NUM
101 ,OLD_PA_PROJECT_NAME T_V30
102 ,NEW_PA_PROJECT_NAME T_V30
103 ,OLD_PA_PROJECT_NUMBER T_V25
104 ,NEW_PA_PROJECT_NUMBER T_V25
105 ,OLD_PA_TASK_NAME T_V20
106 ,NEW_PA_TASK_NAME T_V20
107 ,OLD_PA_TASK_NUMBER T_V25
108 ,NEW_PA_TASK_NUMBER T_V25
109 ,OLD_IN_TRANSIT_ORDER_LINE_ID T_NUM
110 ,NEW_IN_TRANSIT_ORDER_LINE_ID T_NUM
111 ,OLD_IN_TRANSIT_ORDER_LINE_NUM T_NUM
112 ,NEW_IN_TRANSIT_ORDER_LINE_NUM T_NUM
113 ,OLD_IN_TRANSIT_ORDER_NUMBER T_NUM
114 ,NEW_IN_TRANSIT_ORDER_NUMBER T_NUM
115 ,OLD_WIP_JOB_ID T_NUM
116 ,NEW_WIP_JOB_ID T_NUM
117 ,OLD_WIP_ENTITY_NAME T_V240
118 ,NEW_WIP_ENTITY_NAME T_V240
119 ,OLD_PO_ORDER_LINE_ID T_NUM
120 ,NEW_PO_ORDER_LINE_ID T_NUM
121 ,OLD_LAST_OE_ORDER_LINE_ID T_NUM
122 ,NEW_LAST_OE_ORDER_LINE_ID T_NUM
123 ,OLD_LAST_OE_RMA_LINE_ID T_NUM
124 ,NEW_LAST_OE_RMA_LINE_ID T_NUM
125 ,OLD_LAST_PO_PO_LINE_ID T_NUM
126 ,NEW_LAST_PO_PO_LINE_ID T_NUM
127 ,OLD_LAST_OE_PO_NUMBER T_V50
128 ,NEW_LAST_OE_PO_NUMBER T_V50
129 ,OLD_LAST_WIP_JOB_ID T_NUM
130 ,NEW_LAST_WIP_JOB_ID T_NUM
131 ,OLD_LAST_PA_PROJECT_ID T_NUM
132 ,NEW_LAST_PA_PROJECT_ID T_NUM
133 ,OLD_LAST_PA_TASK_ID T_NUM
134 ,NEW_LAST_PA_TASK_ID T_NUM
135 ,OLD_LAST_OE_AGREEMENT_ID T_NUM
136 ,NEW_LAST_OE_AGREEMENT_ID T_NUM
137 ,OLD_INSTALL_DATE T_DATE
138 ,NEW_INSTALL_DATE T_DATE
139 ,OLD_MANUALLY_CREATED_FLAG T_V1
140 ,NEW_MANUALLY_CREATED_FLAG T_V1
141 ,OLD_RETURN_BY_DATE T_DATE
142 ,NEW_RETURN_BY_DATE T_DATE
143 ,OLD_ACTUAL_RETURN_DATE T_DATE
144 ,NEW_ACTUAL_RETURN_DATE T_DATE
145 ,OLD_CREATION_COMPLETE_FLAG T_V1
146 ,NEW_CREATION_COMPLETE_FLAG T_V1
147 ,OLD_COMPLETENESS_FLAG T_V1
148 ,NEW_COMPLETENESS_FLAG T_V1
149 ,OLD_INST_CONTEXT T_V30
150 ,NEW_INST_CONTEXT T_V30
151 ,OLD_INST_ATTRIBUTE1 T_V240
152 ,NEW_INST_ATTRIBUTE1 T_V240
153 ,OLD_INST_ATTRIBUTE2 T_V240
154 ,NEW_INST_ATTRIBUTE2 T_V240
155 ,OLD_INST_ATTRIBUTE3 T_V240
156 ,NEW_INST_ATTRIBUTE3 T_V240
157 ,OLD_INST_ATTRIBUTE4 T_V240
158 ,NEW_INST_ATTRIBUTE4 T_V240
159 ,OLD_INST_ATTRIBUTE5 T_V240
160 ,NEW_INST_ATTRIBUTE5 T_V240
161 ,OLD_INST_ATTRIBUTE6 T_V240
162 ,NEW_INST_ATTRIBUTE6 T_V240
163 ,OLD_INST_ATTRIBUTE7 T_V240
164 ,NEW_INST_ATTRIBUTE7 T_V240
165 ,OLD_INST_ATTRIBUTE8 T_V240
166 ,NEW_INST_ATTRIBUTE8 T_V240
167 ,OLD_INST_ATTRIBUTE9 T_V240
168 ,NEW_INST_ATTRIBUTE9 T_V240
169 ,OLD_INST_ATTRIBUTE10 T_V240
170 ,NEW_INST_ATTRIBUTE10 T_V240
171 ,OLD_INST_ATTRIBUTE11 T_V240
172 ,NEW_INST_ATTRIBUTE11 T_V240
173 ,OLD_INST_ATTRIBUTE12 T_V240
174 ,NEW_INST_ATTRIBUTE12 T_V240
175 ,OLD_INST_ATTRIBUTE13 T_V240
176 ,NEW_INST_ATTRIBUTE13 T_V240
177 ,OLD_INST_ATTRIBUTE14 T_V240
178 ,NEW_INST_ATTRIBUTE14 T_V240
179 ,OLD_INST_ATTRIBUTE15 T_V240
180 ,NEW_INST_ATTRIBUTE15 T_V240
181 ,OLD_LAST_TXN_LINE_DETAIL_ID T_NUM
182 ,NEW_LAST_TXN_LINE_DETAIL_ID T_NUM
183 ,OLD_INSTALL_LOCATION_TYPE_CODE T_V30
184 ,NEW_INSTALL_LOCATION_TYPE_CODE T_V30
185 ,OLD_INSTALL_LOCATION_ID T_NUM
186 ,NEW_INSTALL_LOCATION_ID T_NUM
187 ,OLD_INSTANCE_USAGE_CODE T_V30
188 ,NEW_INSTANCE_USAGE_CODE T_V30
189 ,OLD_CONFIG_INST_REV_NUM T_NUM
190 ,NEW_CONFIG_INST_REV_NUM T_NUM
191 ,OLD_CONFIG_VALID_STATUS T_V30
192 ,NEW_CONFIG_VALID_STATUS T_V30
193 ,OLD_INSTANCE_DESCRIPTION T_V240
194 ,NEW_INSTANCE_DESCRIPTION T_V240
195 ,INSTANCE_HISTORY_ID T_NUM
196 ,TRANSACTION_ID T_NUM
197 ,OLD_LAST_VLD_ORGANIZATION_ID T_NUM
198 ,NEW_LAST_VLD_ORGANIZATION_ID T_NUM
199 ,INST_FULL_DUMP_FLAG T_V1
200 ,INST_CREATED_BY T_NUM
201 ,INST_CREATION_DATE T_DATE
202 ,INST_LAST_UPDATED_BY T_NUM
203 ,INST_LAST_UPDATE_DATE T_DATE
204 ,INST_LAST_UPDATE_LOGIN T_NUM
205 ,INST_OBJECT_VERSION_NUMBER T_NUM
206 ,INST_SECURITY_GROUP_ID T_NUM
207 ,INST_MIGRATED_FLAG T_V1
208 -- Added for the following as new columns were added to csi_item_instances
209 -- and csi_item_instances_h tables
210 ,OLD_NETWORK_ASSET_FLAG T_V1
211 ,NEW_NETWORK_ASSET_FLAG T_V1
212 ,OLD_MAINTAINABLE_FLAG T_V1
213 ,NEW_MAINTAINABLE_FLAG T_V1
214 ,OLD_PN_LOCATION_ID T_NUM
215 ,NEW_PN_LOCATION_ID T_NUM
216 ,OLD_ASSET_CRITICALITY_CODE T_V30
217 ,NEW_ASSET_CRITICALITY_CODE T_V30
218 ,OLD_CATEGORY_ID T_NUM
219 ,NEW_CATEGORY_ID T_NUM
220 ,OLD_EQUIPMENT_GEN_OBJECT_ID T_NUM
221 ,NEW_EQUIPMENT_GEN_OBJECT_ID T_NUM
222 ,OLD_INSTANTIATION_FLAG T_V1
223 ,NEW_INSTANTIATION_FLAG T_V1
224 ,OLD_LINEAR_LOCATION_ID T_NUM
225 ,NEW_LINEAR_LOCATION_ID T_NUM
226 ,OLD_OPERATIONAL_LOG_FLAG T_V1
227 ,NEW_OPERATIONAL_LOG_FLAG T_V1
228 ,OLD_CHECKIN_STATUS T_NUM
229 ,NEW_CHECKIN_STATUS T_NUM
230 ,OLD_SUPPLIER_WARRANTY_EXP_DATE T_DATE
231 ,NEW_SUPPLIER_WARRANTY_EXP_DATE T_DATE
232 ,OLD_INST_ATTRIBUTE16 T_V240
233 ,NEW_INST_ATTRIBUTE16 T_V240
234 ,OLD_INST_ATTRIBUTE17 T_V240
235 ,NEW_INST_ATTRIBUTE17 T_V240
236 ,OLD_INST_ATTRIBUTE18 T_V240
237 ,NEW_INST_ATTRIBUTE18 T_V240
238 ,OLD_INST_ATTRIBUTE19 T_V240
239 ,NEW_INST_ATTRIBUTE19 T_V240
240 ,OLD_INST_ATTRIBUTE20 T_V240
241 ,NEW_INST_ATTRIBUTE20 T_V240
242 ,OLD_INST_ATTRIBUTE21 T_V240
243 ,NEW_INST_ATTRIBUTE21 T_V240
244 ,OLD_INST_ATTRIBUTE22 T_V240
245 ,NEW_INST_ATTRIBUTE22 T_V240
246 ,OLD_INST_ATTRIBUTE23 T_V240
247 ,NEW_INST_ATTRIBUTE23 T_V240
248 ,OLD_INST_ATTRIBUTE24 T_V240
249 ,NEW_INST_ATTRIBUTE24 T_V240
250 ,OLD_INST_ATTRIBUTE25 T_V240
251 ,NEW_INST_ATTRIBUTE25 T_V240
252 ,OLD_INST_ATTRIBUTE26 T_V240
253 ,NEW_INST_ATTRIBUTE26 T_V240
254 ,OLD_INST_ATTRIBUTE27 T_V240
255 ,NEW_INST_ATTRIBUTE27 T_V240
256 ,OLD_INST_ATTRIBUTE28 T_V240
257 ,NEW_INST_ATTRIBUTE28 T_V240
258 ,OLD_INST_ATTRIBUTE29 T_V240
259 ,NEW_INST_ATTRIBUTE29 T_V240
260 ,OLD_INST_ATTRIBUTE30 T_V240
261 ,NEW_INST_ATTRIBUTE30 T_V240
262 );
263 --
264 TYPE VER_LABEL_HISTORY_REC_TAB IS RECORD
265 (
266 VERSION_LABEL_HISTORY_ID T_NUM
267 ,VERSION_LABEL_ID T_NUM
268 ,TRANSACTION_ID T_NUM
272 ,NEW_VER_DESCRIPTION T_V240
269 ,OLD_VERSION_LABEL T_V30
270 ,NEW_VERSION_LABEL T_V30
271 ,OLD_VER_DESCRIPTION T_V240
273 ,OLD_DATE_TIME_STAMP T_DATE
274 ,NEW_DATE_TIME_STAMP T_DATE
275 ,OLD_VER_ACTIVE_START_DATE T_DATE
276 ,NEW_VER_ACTIVE_START_DATE T_DATE
277 ,OLD_VER_ACTIVE_END_DATE T_DATE
278 ,NEW_VER_ACTIVE_END_DATE T_DATE
279 ,OLD_VER_CONTEXT T_V30
280 ,NEW_VER_CONTEXT T_V30
281 ,OLD_VER_ATTRIBUTE1 T_V150
282 ,NEW_VER_ATTRIBUTE1 T_V150
283 ,OLD_VER_ATTRIBUTE2 T_V150
284 ,NEW_VER_ATTRIBUTE2 T_V150
285 ,OLD_VER_ATTRIBUTE3 T_V150
286 ,NEW_VER_ATTRIBUTE3 T_V150
287 ,OLD_VER_ATTRIBUTE4 T_V150
288 ,NEW_VER_ATTRIBUTE4 T_V150
289 ,OLD_VER_ATTRIBUTE5 T_V150
290 ,NEW_VER_ATTRIBUTE5 T_V150
291 ,OLD_VER_ATTRIBUTE6 T_V150
292 ,NEW_VER_ATTRIBUTE6 T_V150
293 ,OLD_VER_ATTRIBUTE7 T_V150
294 ,NEW_VER_ATTRIBUTE7 T_V150
295 ,OLD_VER_ATTRIBUTE8 T_V150
296 ,NEW_VER_ATTRIBUTE8 T_V150
297 ,OLD_VER_ATTRIBUTE9 T_V150
298 ,NEW_VER_ATTRIBUTE9 T_V150
299 ,OLD_VER_ATTRIBUTE10 T_V150
300 ,NEW_VER_ATTRIBUTE10 T_V150
301 ,OLD_VER_ATTRIBUTE11 T_V150
302 ,NEW_VER_ATTRIBUTE11 T_V150
303 ,OLD_VER_ATTRIBUTE12 T_V150
304 ,NEW_VER_ATTRIBUTE12 T_V150
305 ,OLD_VER_ATTRIBUTE13 T_V150
306 ,NEW_VER_ATTRIBUTE13 T_V150
307 ,OLD_VER_ATTRIBUTE14 T_V150
308 ,NEW_VER_ATTRIBUTE14 T_V150
309 ,OLD_VER_ATTRIBUTE15 T_V150
310 ,NEW_VER_ATTRIBUTE15 T_V150
311 ,VER_FULL_DUMP_FLAG T_V1
312 ,VER_CREATED_BY T_NUM
313 ,VER_CREATION_DATE T_DATE
314 ,VER_LAST_UPDATED_BY T_NUM
315 ,VER_LAST_UPDATE_DATE T_DATE
316 ,VER_LAST_UPDATE_LOGIN T_NUM
317 ,VER_OBJECT_VERSION_NUMBER T_NUM
318 ,VER_SECURITY_GROUP_ID T_NUM
319 ,VER_MIGRATED_FLAG T_V1
320
321 );
322 --
323
324 TYPE PARTY_HISTORY_REC_TAB IS RECORD
325 (
326 INSTANCE_PARTY_HISTORY_ID T_NUM
327 ,INSTANCE_PARTY_ID T_NUM
328 ,TRANSACTION_ID T_NUM
329 ,OLD_PARTY_SOURCE_TABLE T_V30
330 ,NEW_PARTY_SOURCE_TABLE T_V30
331 ,OLD_PARTY_ID T_NUM
332 ,NEW_PARTY_ID T_NUM
333 ,OLD_RELATIONSHIP_TYPE_CODE T_V30
334 ,NEW_RELATIONSHIP_TYPE_CODE T_V30
335 ,OLD_CONTACT_FLAG T_V1
336 ,NEW_CONTACT_FLAG T_V1
337 ,OLD_CONTACT_IP_ID T_NUM
338 ,NEW_CONTACT_IP_ID T_NUM
339 ,OLD_ACTIVE_START_DATE T_DATE
340 ,NEW_ACTIVE_START_DATE T_DATE
341 ,OLD_ACTIVE_END_DATE T_DATE
342 ,NEW_ACTIVE_END_DATE T_DATE
343 ,OLD_CONTEXT T_V30
344 ,NEW_CONTEXT T_V30
345 ,OLD_ATTRIBUTE1 T_V150
346 ,NEW_ATTRIBUTE1 T_V150
347 ,OLD_ATTRIBUTE2 T_V150
348 ,NEW_ATTRIBUTE2 T_V150
349 ,OLD_ATTRIBUTE3 T_V150
350 ,NEW_ATTRIBUTE3 T_V150
351 ,OLD_ATTRIBUTE4 T_V150
352 ,NEW_ATTRIBUTE4 T_V150
353 ,OLD_ATTRIBUTE5 T_V150
354 ,NEW_ATTRIBUTE5 T_V150
355 ,OLD_ATTRIBUTE6 T_V150
356 ,NEW_ATTRIBUTE6 T_V150
357 ,OLD_ATTRIBUTE7 T_V150
358 ,NEW_ATTRIBUTE7 T_V150
359 ,OLD_ATTRIBUTE8 T_V150
360 ,NEW_ATTRIBUTE8 T_V150
361 ,OLD_ATTRIBUTE9 T_V150
362 ,NEW_ATTRIBUTE9 T_V150
363 ,OLD_ATTRIBUTE10 T_V150
364 ,NEW_ATTRIBUTE10 T_V150
365 ,OLD_ATTRIBUTE11 T_V150
366 ,NEW_ATTRIBUTE11 T_V150
367 ,OLD_ATTRIBUTE12 T_V150
368 ,NEW_ATTRIBUTE12 T_V150
369 ,OLD_ATTRIBUTE13 T_V150
370 ,NEW_ATTRIBUTE13 T_V150
371 ,OLD_ATTRIBUTE14 T_V150
372 ,NEW_ATTRIBUTE14 T_V150
373 ,OLD_ATTRIBUTE15 T_V150
374 ,NEW_ATTRIBUTE15 T_V150
375 ,OLD_PREFERRED_FLAG T_V1
376 ,NEW_PREFERRED_FLAG T_V1
377 ,OLD_PRIMARY_FLAG T_V1
381 ,PTY_CREATION_DATE T_DATE
378 ,NEW_PRIMARY_FLAG T_V1
379 ,PTY_FULL_DUMP_FLAG T_V1
380 ,PTY_CREATED_BY T_NUM
382 ,PTY_LAST_UPDATED_BY T_NUM
383 ,PTY_LAST_UPDATE_DATE T_DATE
384 ,PTY_LAST_UPDATE_LOGIN T_NUM
385 ,PTY_OBJECT_VERSION_NUMBER T_NUM
386 ,PTY_SECURITY_GROUP_ID T_NUM
387 ,PTY_MIGRATED_FLAG T_V1
388
389 );
390 --
391 TYPE ACCOUNT_HISTORY_REC_TAB IS RECORD
392 (
393 IP_ACCOUNT_HISTORY_ID T_NUM
394 ,IP_ACCOUNT_ID T_NUM
395 ,TRANSACTION_ID T_NUM
396 ,OLD_PARTY_ACCOUNT_ID T_NUM
397 ,NEW_PARTY_ACCOUNT_ID T_NUM
398 ,OLD_RELATIONSHIP_TYPE_CODE T_V30
399 ,NEW_RELATIONSHIP_TYPE_CODE T_V30
400 ,OLD_BILL_TO_ADDRESS T_NUM
401 ,NEW_BILL_TO_ADDRESS T_NUM
402 ,OLD_SHIP_TO_ADDRESS T_NUM
403 ,NEW_SHIP_TO_ADDRESS T_NUM
404 ,OLD_ACTIVE_START_DATE T_DATE
405 ,NEW_ACTIVE_START_DATE T_DATE
406 ,OLD_ACTIVE_END_DATE T_DATE
407 ,NEW_ACTIVE_END_DATE T_DATE
408 ,OLD_CONTEXT T_V30
409 ,NEW_CONTEXT T_V30
410 ,OLD_ATTRIBUTE1 T_V150
411 ,NEW_ATTRIBUTE1 T_V150
412 ,OLD_ATTRIBUTE2 T_V150
413 ,NEW_ATTRIBUTE2 T_V150
414 ,OLD_ATTRIBUTE3 T_V150
415 ,NEW_ATTRIBUTE3 T_V150
416 ,OLD_ATTRIBUTE4 T_V150
417 ,NEW_ATTRIBUTE4 T_V150
418 ,OLD_ATTRIBUTE5 T_V150
419 ,NEW_ATTRIBUTE5 T_V150
420 ,OLD_ATTRIBUTE6 T_V150
421 ,NEW_ATTRIBUTE6 T_V150
422 ,OLD_ATTRIBUTE7 T_V150
423 ,NEW_ATTRIBUTE7 T_V150
424 ,OLD_ATTRIBUTE8 T_V150
425 ,NEW_ATTRIBUTE8 T_V150
426 ,OLD_ATTRIBUTE9 T_V150
427 ,NEW_ATTRIBUTE9 T_V150
428 ,OLD_ATTRIBUTE10 T_V150
429 ,NEW_ATTRIBUTE10 T_V150
430 ,OLD_ATTRIBUTE11 T_V150
431 ,NEW_ATTRIBUTE11 T_V150
432 ,OLD_ATTRIBUTE12 T_V150
433 ,NEW_ATTRIBUTE12 T_V150
434 ,OLD_ATTRIBUTE13 T_V150
435 ,NEW_ATTRIBUTE13 T_V150
436 ,OLD_ATTRIBUTE14 T_V150
437 ,NEW_ATTRIBUTE14 T_V150
438 ,OLD_ATTRIBUTE15 T_V150
439 ,NEW_ATTRIBUTE15 T_V150
440 ,ACCT_FULL_DUMP_FLAG T_V1
441 ,ACCT_CREATED_BY T_NUM
442 ,ACCT_CREATION_DATE T_DATE
443 ,ACCT_LAST_UPDATED_BY T_NUM
444 ,ACCT_LAST_UPDATE_DATE T_DATE
445 ,ACCT_LAST_UPDATE_LOGIN T_NUM
446 ,ACCT_OBJECT_VERSION_NUMBER T_NUM
447 ,ACCT_SECURITY_GROUP_ID T_NUM
448 ,ACCT_MIGRATED_FLAG T_V1
449 ,OLD_INSTANCE_PARTY_ID T_NUM
450 ,NEW_INSTANCE_PARTY_ID T_NUM
451 );
452 --
453 TYPE ORG_UNITS_HISTORY_REC_TAB IS RECORD
454 (
455 INSTANCE_OU_HISTORY_ID T_NUM
456 ,INSTANCE_OU_ID T_NUM
457 ,TRANSACTION_ID T_NUM
458 ,OLD_OPERATING_UNIT_ID T_NUM
459 ,NEW_OPERATING_UNIT_ID T_NUM
460 ,OLD_OU_RELNSHIP_TYPE_CODE T_V30
461 ,NEW_OU_RELNSHIP_TYPE_CODE T_V30
462 ,OLD_OU_ACTIVE_START_DATE T_DATE
463 ,NEW_OU_ACTIVE_START_DATE T_DATE
464 ,OLD_OU_ACTIVE_END_DATE T_DATE
465 ,NEW_OU_ACTIVE_END_DATE T_DATE
466 ,OLD_OU_CONTEXT T_V30
467 ,NEW_OU_CONTEXT T_V30
468 ,OLD_OU_ATTRIBUTE1 T_V150
469 ,NEW_OU_ATTRIBUTE1 T_V150
470 ,OLD_OU_ATTRIBUTE2 T_V150
471 ,NEW_OU_ATTRIBUTE2 T_V150
472 ,OLD_OU_ATTRIBUTE3 T_V150
473 ,NEW_OU_ATTRIBUTE3 T_V150
474 ,OLD_OU_ATTRIBUTE4 T_V150
475 ,NEW_OU_ATTRIBUTE4 T_V150
476 ,OLD_OU_ATTRIBUTE5 T_V150
477 ,NEW_OU_ATTRIBUTE5 T_V150
478 ,OLD_OU_ATTRIBUTE6 T_V150
479 ,NEW_OU_ATTRIBUTE6 T_V150
480 ,OLD_OU_ATTRIBUTE7 T_V150
481 ,NEW_OU_ATTRIBUTE7 T_V150
482 ,OLD_OU_ATTRIBUTE8 T_V150
483 ,NEW_OU_ATTRIBUTE8 T_V150
484 ,OLD_OU_ATTRIBUTE9 T_V150
485 ,NEW_OU_ATTRIBUTE9 T_V150
486 ,OLD_OU_ATTRIBUTE10 T_V150
487 ,NEW_OU_ATTRIBUTE10 T_V150
491 ,NEW_OU_ATTRIBUTE12 T_V150
488 ,OLD_OU_ATTRIBUTE11 T_V150
489 ,NEW_OU_ATTRIBUTE11 T_V150
490 ,OLD_OU_ATTRIBUTE12 T_V150
492 ,OLD_OU_ATTRIBUTE13 T_V150
493 ,NEW_OU_ATTRIBUTE13 T_V150
494 ,OLD_OU_ATTRIBUTE14 T_V150
495 ,NEW_OU_ATTRIBUTE14 T_V150
496 ,OLD_OU_ATTRIBUTE15 T_V150
497 ,NEW_OU_ATTRIBUTE15 T_V150
498 ,OU_FULL_DUMP_FLAG T_V1
499 ,OU_CREATED_BY T_NUM
500 ,OU_CREATION_DATE T_DATE
501 ,OU_LAST_UPDATED_BY T_NUM
502 ,OU_LAST_UPDATE_DATE T_DATE
503 ,OU_LAST_UPDATE_LOGIN T_NUM
504 ,OU_OBJECT_VERSION_NUMBER T_NUM
505 ,OU_SECURITY_GROUP_ID T_NUM
506 ,OU_MIGRATED_FLAG T_V1
507
508 );
509 --
510 TYPE EXT_ATTRIB_HISTORY_REC_TAB IS RECORD
511 (
512 ATTRIBUTE_VALUE_HISTORY_ID T_NUM
513 ,ATTRIBUTE_VALUE_ID T_NUM
514 ,TRANSACTION_ID T_NUM
515 ,OLD_ATTRIBUTE_VALUE T_V240
516 ,NEW_ATTRIBUTE_VALUE T_V240
517 ,OLD_EXT_ACTIVE_START_DATE T_DATE
518 ,NEW_EXT_ACTIVE_START_DATE T_DATE
519 ,OLD_EXT_ACTIVE_END_DATE T_DATE
520 ,NEW_EXT_ACTIVE_END_DATE T_DATE
521 ,OLD_EXT_CONTEXT T_V30
522 ,NEW_EXT_CONTEXT T_V30
523 ,OLD_EXT_ATTRIBUTE1 T_V150
524 ,NEW_EXT_ATTRIBUTE1 T_V150
525 ,OLD_EXT_ATTRIBUTE2 T_V150
526 ,NEW_EXT_ATTRIBUTE2 T_V150
527 ,OLD_EXT_ATTRIBUTE3 T_V150
528 ,NEW_EXT_ATTRIBUTE3 T_V150
529 ,OLD_EXT_ATTRIBUTE4 T_V150
530 ,NEW_EXT_ATTRIBUTE4 T_V150
531 ,OLD_EXT_ATTRIBUTE5 T_V150
532 ,NEW_EXT_ATTRIBUTE5 T_V150
533 ,OLD_EXT_ATTRIBUTE6 T_V150
534 ,NEW_EXT_ATTRIBUTE6 T_V150
535 ,OLD_EXT_ATTRIBUTE7 T_V150
536 ,NEW_EXT_ATTRIBUTE7 T_V150
537 ,OLD_EXT_ATTRIBUTE8 T_V150
538 ,NEW_EXT_ATTRIBUTE8 T_V150
539 ,OLD_EXT_ATTRIBUTE9 T_V150
540 ,NEW_EXT_ATTRIBUTE9 T_V150
541 ,OLD_EXT_ATTRIBUTE10 T_V150
542 ,NEW_EXT_ATTRIBUTE10 T_V150
543 ,OLD_EXT_ATTRIBUTE11 T_V150
544 ,NEW_EXT_ATTRIBUTE11 T_V150
545 ,OLD_EXT_ATTRIBUTE12 T_V150
546 ,NEW_EXT_ATTRIBUTE12 T_V150
547 ,OLD_EXT_ATTRIBUTE13 T_V150
548 ,NEW_EXT_ATTRIBUTE13 T_V150
549 ,OLD_EXT_ATTRIBUTE14 T_V150
550 ,NEW_EXT_ATTRIBUTE14 T_V150
551 ,OLD_EXT_ATTRIBUTE15 T_V150
552 ,NEW_EXT_ATTRIBUTE15 T_V150
553 ,EXT_FULL_DUMP_FLAG T_V1
554 ,EXT_CREATED_BY T_NUM
555 ,EXT_CREATION_DATE T_DATE
556 ,EXT_LAST_UPDATED_BY T_NUM
557 ,EXT_LAST_UPDATE_DATE T_DATE
558 ,EXT_LAST_UPDATE_LOGIN T_NUM
559 ,EXT_OBJECT_VERSION_NUMBER T_NUM
560 ,EXT_SECURITY_GROUP_ID T_NUM
561 ,EXT_MIGRATED_FLAG T_V1
562 );
563 --
564 TYPE INS_ASSET_HISTORY_REC_TAB IS RECORD
565 (
566 INSTANCE_ASSET_HISTORY_ID T_NUM
567 ,TRANSACTION_ID T_NUM
568 ,INSTANCE_ASSET_ID T_NUM
569 ,OLD_INSTANCE_ID T_NUM
570 ,NEW_INSTANCE_ID T_NUM
571 ,OLD_FA_ASSET_ID T_NUM
572 ,NEW_FA_ASSET_ID T_NUM
573 ,OLD_FA_BOOK_TYPE_CODE T_V15
574 ,NEW_FA_BOOK_TYPE_CODE T_V15
575 ,OLD_FA_LOCATION_ID T_NUM
576 ,NEW_FA_LOCATION_ID T_NUM
577 ,OLD_ASSET_QUANTITY T_NUM
578 ,NEW_ASSET_QUANTITY T_NUM
579 ,OLD_UPDATE_STATUS T_V30
580 ,NEW_UPDATE_STATUS T_V30
581 ,OLD_AST_ACTIVE_START_DATE T_DATE
582 ,NEW_AST_ACTIVE_START_DATE T_DATE
583 ,OLD_AST_ACTIVE_END_DATE T_DATE
584 ,NEW_AST_ACTIVE_END_DATE T_DATE
585 ,AST_FULL_DUMP_FLAG T_V1
586 ,AST_CREATED_BY T_NUM
587 ,AST_CREATION_DATE T_DATE
588 ,AST_LAST_UPDATED_BY T_NUM
589 ,AST_LAST_UPDATE_DATE T_DATE
590 ,AST_LAST_UPDATE_LOGIN T_NUM
591 ,AST_OBJECT_VERSION_NUMBER T_NUM
592 ,AST_SECURITY_GROUP_ID T_NUM
593 ,AST_MIGRATED_FLAG T_V1
594 );
595 --
596 TYPE PRICING_ATTRIBS_HIST_REC_TAB IS RECORD
597 (
598 PRICE_ATTRIB_HISTORY_ID T_NUM
599 ,PRICING_ATTRIBUTE_ID T_NUM
600 ,TRANSACTION_ID T_NUM
604 ,NEW_PRICING_ATTRIBUTE1 T_V150
601 ,OLD_PRICING_CONTEXT T_V30
602 ,NEW_PRICING_CONTEXT T_V30
603 ,OLD_PRICING_ATTRIBUTE1 T_V150
605 ,OLD_PRICING_ATTRIBUTE2 T_V150
606 ,NEW_PRICING_ATTRIBUTE2 T_V150
607 ,OLD_PRICING_ATTRIBUTE3 T_V150
608 ,NEW_PRICING_ATTRIBUTE3 T_V150
609 ,OLD_PRICING_ATTRIBUTE4 T_V150
610 ,NEW_PRICING_ATTRIBUTE4 T_V150
611 ,OLD_PRICING_ATTRIBUTE5 T_V150
612 ,NEW_PRICING_ATTRIBUTE5 T_V150
613 ,OLD_PRICING_ATTRIBUTE6 T_V150
614 ,NEW_PRICING_ATTRIBUTE6 T_V150
615 ,OLD_PRICING_ATTRIBUTE7 T_V150
616 ,NEW_PRICING_ATTRIBUTE7 T_V150
617 ,OLD_PRICING_ATTRIBUTE8 T_V150
618 ,NEW_PRICING_ATTRIBUTE8 T_V150
619 ,OLD_PRICING_ATTRIBUTE9 T_V150
620 ,NEW_PRICING_ATTRIBUTE9 T_V150
621 ,OLD_PRICING_ATTRIBUTE10 T_V150
622 ,NEW_PRICING_ATTRIBUTE10 T_V150
623 ,OLD_PRICING_ATTRIBUTE11 T_V150
624 ,NEW_PRICING_ATTRIBUTE11 T_V150
625 ,OLD_PRICING_ATTRIBUTE12 T_V150
626 ,NEW_PRICING_ATTRIBUTE12 T_V150
627 ,OLD_PRICING_ATTRIBUTE13 T_V150
628 ,NEW_PRICING_ATTRIBUTE13 T_V150
629 ,OLD_PRICING_ATTRIBUTE14 T_V150
630 ,NEW_PRICING_ATTRIBUTE14 T_V150
631 ,OLD_PRICING_ATTRIBUTE15 T_V150
632 ,NEW_PRICING_ATTRIBUTE15 T_V150
633 ,OLD_PRICING_ATTRIBUTE16 T_V150
634 ,NEW_PRICING_ATTRIBUTE16 T_V150
635 ,OLD_PRICING_ATTRIBUTE17 T_V150
636 ,NEW_PRICING_ATTRIBUTE17 T_V150
637 ,OLD_PRICING_ATTRIBUTE18 T_V150
638 ,NEW_PRICING_ATTRIBUTE18 T_V150
639 ,OLD_PRICING_ATTRIBUTE19 T_V150
640 ,NEW_PRICING_ATTRIBUTE19 T_V150
641 ,OLD_PRICING_ATTRIBUTE20 T_V150
642 ,NEW_PRICING_ATTRIBUTE20 T_V150
643 ,OLD_PRICING_ATTRIBUTE21 T_V150
644 ,NEW_PRICING_ATTRIBUTE21 T_V150
645 ,OLD_PRICING_ATTRIBUTE22 T_V150
646 ,NEW_PRICING_ATTRIBUTE22 T_V150
647 ,OLD_PRICING_ATTRIBUTE23 T_V150
648 ,NEW_PRICING_ATTRIBUTE23 T_V150
649 ,OLD_PRICING_ATTRIBUTE24 T_V150
650 ,NEW_PRICING_ATTRIBUTE24 T_V150
651 ,OLD_PRICING_ATTRIBUTE25 T_V150
652 ,NEW_PRICING_ATTRIBUTE25 T_V150
653 ,OLD_PRICING_ATTRIBUTE26 T_V150
654 ,NEW_PRICING_ATTRIBUTE26 T_V150
655 ,OLD_PRICING_ATTRIBUTE27 T_V150
656 ,NEW_PRICING_ATTRIBUTE27 T_V150
657 ,OLD_PRICING_ATTRIBUTE28 T_V150
658 ,NEW_PRICING_ATTRIBUTE28 T_V150
659 ,OLD_PRICING_ATTRIBUTE29 T_V150
660 ,NEW_PRICING_ATTRIBUTE29 T_V150
661 ,OLD_PRICING_ATTRIBUTE30 T_V150
662 ,NEW_PRICING_ATTRIBUTE30 T_V150
663 ,OLD_PRICING_ATTRIBUTE31 T_V150
664 ,NEW_PRICING_ATTRIBUTE31 T_V150
665 ,OLD_PRICING_ATTRIBUTE32 T_V150
666 ,NEW_PRICING_ATTRIBUTE32 T_V150
667 ,OLD_PRICING_ATTRIBUTE33 T_V150
668 ,NEW_PRICING_ATTRIBUTE33 T_V150
669 ,OLD_PRICING_ATTRIBUTE34 T_V150
670 ,NEW_PRICING_ATTRIBUTE34 T_V150
671 ,OLD_PRICING_ATTRIBUTE35 T_V150
672 ,NEW_PRICING_ATTRIBUTE35 T_V150
673 ,OLD_PRICING_ATTRIBUTE36 T_V150
674 ,NEW_PRICING_ATTRIBUTE36 T_V150
675 ,OLD_PRICING_ATTRIBUTE37 T_V150
676 ,NEW_PRICING_ATTRIBUTE37 T_V150
677 ,OLD_PRICING_ATTRIBUTE38 T_V150
678 ,NEW_PRICING_ATTRIBUTE38 T_V150
679 ,OLD_PRICING_ATTRIBUTE39 T_V150
680 ,NEW_PRICING_ATTRIBUTE39 T_V150
681 ,OLD_PRICING_ATTRIBUTE40 T_V150
682 ,NEW_PRICING_ATTRIBUTE40 T_V150
683 ,OLD_PRICING_ATTRIBUTE41 T_V150
684 ,NEW_PRICING_ATTRIBUTE41 T_V150
685 ,OLD_PRICING_ATTRIBUTE42 T_V150
686 ,NEW_PRICING_ATTRIBUTE42 T_V150
687 ,OLD_PRICING_ATTRIBUTE43 T_V150
688 ,NEW_PRICING_ATTRIBUTE43 T_V150
689 ,OLD_PRICING_ATTRIBUTE44 T_V150
690 ,NEW_PRICING_ATTRIBUTE44 T_V150
691 ,OLD_PRICING_ATTRIBUTE45 T_V150
692 ,NEW_PRICING_ATTRIBUTE45 T_V150
693 ,OLD_PRICING_ATTRIBUTE46 T_V150
694 ,NEW_PRICING_ATTRIBUTE46 T_V150
695 ,OLD_PRICING_ATTRIBUTE47 T_V150
696 ,NEW_PRICING_ATTRIBUTE47 T_V150
697 ,OLD_PRICING_ATTRIBUTE48 T_V150
698 ,NEW_PRICING_ATTRIBUTE48 T_V150
699 ,OLD_PRICING_ATTRIBUTE49 T_V150
700 ,NEW_PRICING_ATTRIBUTE49 T_V150
701 ,OLD_PRICING_ATTRIBUTE50 T_V150
702 ,NEW_PRICING_ATTRIBUTE50 T_V150
703 ,OLD_PRICING_ATTRIBUTE51 T_V150
704 ,NEW_PRICING_ATTRIBUTE51 T_V150
705 ,OLD_PRICING_ATTRIBUTE52 T_V150
709 ,OLD_PRICING_ATTRIBUTE54 T_V150
706 ,NEW_PRICING_ATTRIBUTE52 T_V150
707 ,OLD_PRICING_ATTRIBUTE53 T_V150
708 ,NEW_PRICING_ATTRIBUTE53 T_V150
710 ,NEW_PRICING_ATTRIBUTE54 T_V150
711 ,OLD_PRICING_ATTRIBUTE55 T_V150
712 ,NEW_PRICING_ATTRIBUTE55 T_V150
713 ,OLD_PRICING_ATTRIBUTE56 T_V150
714 ,NEW_PRICING_ATTRIBUTE56 T_V150
715 ,OLD_PRICING_ATTRIBUTE57 T_V150
716 ,NEW_PRICING_ATTRIBUTE57 T_V150
717 ,OLD_PRICING_ATTRIBUTE58 T_V150
718 ,NEW_PRICING_ATTRIBUTE58 T_V150
719 ,OLD_PRICING_ATTRIBUTE59 T_V150
720 ,NEW_PRICING_ATTRIBUTE59 T_V150
721 ,OLD_PRICING_ATTRIBUTE60 T_V150
722 ,NEW_PRICING_ATTRIBUTE60 T_V150
723 ,OLD_PRICING_ATTRIBUTE61 T_V150
724 ,NEW_PRICING_ATTRIBUTE61 T_V150
725 ,OLD_PRICING_ATTRIBUTE62 T_V150
726 ,NEW_PRICING_ATTRIBUTE62 T_V150
727 ,OLD_PRICING_ATTRIBUTE63 T_V150
728 ,NEW_PRICING_ATTRIBUTE63 T_V150
729 ,OLD_PRICING_ATTRIBUTE64 T_V150
730 ,NEW_PRICING_ATTRIBUTE64 T_V150
731 ,OLD_PRICING_ATTRIBUTE65 T_V150
732 ,NEW_PRICING_ATTRIBUTE65 T_V150
733 ,OLD_PRICING_ATTRIBUTE66 T_V150
734 ,NEW_PRICING_ATTRIBUTE66 T_V150
735 ,OLD_PRICING_ATTRIBUTE67 T_V150
736 ,NEW_PRICING_ATTRIBUTE67 T_V150
737 ,OLD_PRICING_ATTRIBUTE68 T_V150
738 ,NEW_PRICING_ATTRIBUTE68 T_V150
739 ,OLD_PRICING_ATTRIBUTE69 T_V150
740 ,NEW_PRICING_ATTRIBUTE69 T_V150
741 ,OLD_PRICING_ATTRIBUTE70 T_V150
742 ,NEW_PRICING_ATTRIBUTE70 T_V150
743 ,OLD_PRICING_ATTRIBUTE71 T_V150
744 ,NEW_PRICING_ATTRIBUTE71 T_V150
745 ,OLD_PRICING_ATTRIBUTE72 T_V150
746 ,NEW_PRICING_ATTRIBUTE72 T_V150
747 ,OLD_PRICING_ATTRIBUTE73 T_V150
748 ,NEW_PRICING_ATTRIBUTE73 T_V150
749 ,OLD_PRICING_ATTRIBUTE74 T_V150
750 ,NEW_PRICING_ATTRIBUTE74 T_V150
751 ,OLD_PRICING_ATTRIBUTE75 T_V150
752 ,NEW_PRICING_ATTRIBUTE75 T_V150
753 ,OLD_PRICING_ATTRIBUTE76 T_V150
754 ,NEW_PRICING_ATTRIBUTE76 T_V150
755 ,OLD_PRICING_ATTRIBUTE77 T_V150
756 ,NEW_PRICING_ATTRIBUTE77 T_V150
757 ,OLD_PRICING_ATTRIBUTE78 T_V150
758 ,NEW_PRICING_ATTRIBUTE78 T_V150
759 ,OLD_PRICING_ATTRIBUTE79 T_V150
760 ,NEW_PRICING_ATTRIBUTE79 T_V150
761 ,OLD_PRICING_ATTRIBUTE80 T_V150
762 ,NEW_PRICING_ATTRIBUTE80 T_V150
763 ,OLD_PRICING_ATTRIBUTE81 T_V150
764 ,NEW_PRICING_ATTRIBUTE81 T_V150
765 ,OLD_PRICING_ATTRIBUTE82 T_V150
766 ,NEW_PRICING_ATTRIBUTE82 T_V150
767 ,OLD_PRICING_ATTRIBUTE83 T_V150
768 ,NEW_PRICING_ATTRIBUTE83 T_V150
769 ,OLD_PRICING_ATTRIBUTE84 T_V150
770 ,NEW_PRICING_ATTRIBUTE84 T_V150
771 ,OLD_PRICING_ATTRIBUTE85 T_V150
772 ,NEW_PRICING_ATTRIBUTE85 T_V150
773 ,OLD_PRICING_ATTRIBUTE86 T_V150
774 ,NEW_PRICING_ATTRIBUTE86 T_V150
775 ,OLD_PRICING_ATTRIBUTE87 T_V150
776 ,NEW_PRICING_ATTRIBUTE87 T_V150
777 ,OLD_PRICING_ATTRIBUTE88 T_V150
778 ,NEW_PRICING_ATTRIBUTE88 T_V150
779 ,OLD_PRICING_ATTRIBUTE89 T_V150
780 ,NEW_PRICING_ATTRIBUTE89 T_V150
781 ,OLD_PRICING_ATTRIBUTE90 T_V150
782 ,NEW_PRICING_ATTRIBUTE90 T_V150
783 ,OLD_PRICING_ATTRIBUTE91 T_V150
784 ,NEW_PRICING_ATTRIBUTE91 T_V150
785 ,OLD_PRICING_ATTRIBUTE92 T_V150
786 ,NEW_PRICING_ATTRIBUTE92 T_V150
787 ,OLD_PRICING_ATTRIBUTE93 T_V150
788 ,NEW_PRICING_ATTRIBUTE93 T_V150
789 ,OLD_PRICING_ATTRIBUTE94 T_V150
790 ,NEW_PRICING_ATTRIBUTE94 T_V150
791 ,OLD_PRICING_ATTRIBUTE95 T_V150
792 ,NEW_PRICING_ATTRIBUTE95 T_V150
793 ,OLD_PRICING_ATTRIBUTE96 T_V150
794 ,NEW_PRICING_ATTRIBUTE96 T_V150
795 ,OLD_PRICING_ATTRIBUTE97 T_V150
796 ,NEW_PRICING_ATTRIBUTE97 T_V150
797 ,OLD_PRICING_ATTRIBUTE98 T_V150
798 ,NEW_PRICING_ATTRIBUTE98 T_V150
799 ,OLD_PRICING_ATTRIBUTE99 T_V150
800 ,NEW_PRICING_ATTRIBUTE99 T_V150
801 ,OLD_PRICING_ATTRIBUTE100 T_V150
802 ,NEW_PRICING_ATTRIBUTE100 T_V150
803 ,OLD_PRI_ACTIVE_START_DATE T_DATE
804 ,NEW_PRI_ACTIVE_START_DATE T_DATE
805 ,OLD_PRI_ACTIVE_END_DATE T_DATE
806 ,NEW_PRI_ACTIVE_END_DATE T_DATE
807 ,OLD_PRI_CONTEXT T_V30
808 ,NEW_PRI_CONTEXT T_V30
809 ,OLD_PRI_ATTRIBUTE1 T_V150
813 ,OLD_PRI_ATTRIBUTE3 T_V150
810 ,NEW_PRI_ATTRIBUTE1 T_V150
811 ,OLD_PRI_ATTRIBUTE2 T_V150
812 ,NEW_PRI_ATTRIBUTE2 T_V150
814 ,NEW_PRI_ATTRIBUTE3 T_V150
815 ,OLD_PRI_ATTRIBUTE4 T_V150
816 ,NEW_PRI_ATTRIBUTE4 T_V150
817 ,OLD_PRI_ATTRIBUTE5 T_V150
818 ,NEW_PRI_ATTRIBUTE5 T_V150
819 ,OLD_PRI_ATTRIBUTE6 T_V150
820 ,NEW_PRI_ATTRIBUTE6 T_V150
821 ,OLD_PRI_ATTRIBUTE7 T_V150
822 ,NEW_PRI_ATTRIBUTE7 T_V150
823 ,OLD_PRI_ATTRIBUTE8 T_V150
824 ,NEW_PRI_ATTRIBUTE8 T_V150
825 ,OLD_PRI_ATTRIBUTE9 T_V150
826 ,NEW_PRI_ATTRIBUTE9 T_V150
827 ,OLD_PRI_ATTRIBUTE10 T_V150
828 ,NEW_PRI_ATTRIBUTE10 T_V150
829 ,OLD_PRI_ATTRIBUTE11 T_V150
830 ,NEW_PRI_ATTRIBUTE11 T_V150
831 ,OLD_PRI_ATTRIBUTE12 T_V150
832 ,NEW_PRI_ATTRIBUTE12 T_V150
833 ,OLD_PRI_ATTRIBUTE13 T_V150
834 ,NEW_PRI_ATTRIBUTE13 T_V150
835 ,OLD_PRI_ATTRIBUTE14 T_V150
836 ,NEW_PRI_ATTRIBUTE14 T_V150
837 ,OLD_PRI_ATTRIBUTE15 T_V150
838 ,NEW_PRI_ATTRIBUTE15 T_V150
839 ,PRI_FULL_DUMP_FLAG T_V1
840 ,PRI_CREATED_BY T_NUM
841 ,PRI_CREATION_DATE T_DATE
842 ,PRI_LAST_UPDATED_BY T_NUM
843 ,PRI_LAST_UPDATE_DATE T_DATE
844 ,PRI_LAST_UPDATE_LOGIN T_NUM
845 ,PRI_OBJECT_VERSION_NUMBER T_NUM
846 ,PRI_SECURITY_GROUP_ID T_NUM
847 ,PRI_MIGRATED_FLAG T_V1
848 );
849 --
850
851 TYPE RELATIONSHIP_HISTORY_REC_TAB IS RECORD
852 (
853 RELATIONSHIP_HISTORY_ID T_NUM
854 ,RELATIONSHIP_ID T_NUM
855 ,TRANSACTION_ID T_NUM
856 ,OLD_SUBJECT_ID T_NUM
857 ,NEW_SUBJECT_ID T_NUM
858 ,OLD_POSITION_REFERENCE T_V30
859 ,NEW_POSITION_REFERENCE T_V30
860 ,OLD_REL_ACTIVE_START_DATE T_DATE
861 ,NEW_REL_ACTIVE_START_DATE T_DATE
862 ,OLD_REL_ACTIVE_END_DATE T_DATE
863 ,NEW_REL_ACTIVE_END_DATE T_DATE
864 ,OLD_MANDATORY_FLAG T_V1
865 ,NEW_MANDATORY_FLAG T_V1
866 ,OLD_REL_CONTEXT T_V30
867 ,NEW_REL_CONTEXT T_V30
868 ,OLD_REL_ATTRIBUTE1 T_V150
869 ,NEW_REL_ATTRIBUTE1 T_V150
870 ,OLD_REL_ATTRIBUTE2 T_V150
871 ,NEW_REL_ATTRIBUTE2 T_V150
872 ,OLD_REL_ATTRIBUTE3 T_V150
873 ,NEW_REL_ATTRIBUTE3 T_V150
874 ,OLD_REL_ATTRIBUTE4 T_V150
875 ,NEW_REL_ATTRIBUTE4 T_V150
876 ,OLD_REL_ATTRIBUTE5 T_V150
877 ,NEW_REL_ATTRIBUTE5 T_V150
878 ,OLD_REL_ATTRIBUTE6 T_V150
879 ,NEW_REL_ATTRIBUTE6 T_V150
880 ,OLD_REL_ATTRIBUTE7 T_V150
881 ,NEW_REL_ATTRIBUTE7 T_V150
882 ,OLD_REL_ATTRIBUTE8 T_V150
883 ,NEW_REL_ATTRIBUTE8 T_V150
884 ,OLD_REL_ATTRIBUTE9 T_V150
885 ,NEW_REL_ATTRIBUTE9 T_V150
886 ,OLD_REL_ATTRIBUTE10 T_V150
887 ,NEW_REL_ATTRIBUTE10 T_V150
888 ,OLD_REL_ATTRIBUTE11 T_V150
889 ,NEW_REL_ATTRIBUTE11 T_V150
890 ,OLD_REL_ATTRIBUTE12 T_V150
891 ,NEW_REL_ATTRIBUTE12 T_V150
892 ,OLD_REL_ATTRIBUTE13 T_V150
893 ,NEW_REL_ATTRIBUTE13 T_V150
894 ,OLD_REL_ATTRIBUTE14 T_V150
895 ,NEW_REL_ATTRIBUTE14 T_V150
896 ,OLD_REL_ATTRIBUTE15 T_V150
897 ,NEW_REL_ATTRIBUTE15 T_V150
898 ,REL_FULL_DUMP_FLAG T_V1
899 ,REL_CREATED_BY T_NUM
900 ,REL_CREATION_DATE T_DATE
901 ,REL_LAST_UPDATED_BY T_NUM
902 ,REL_LAST_UPDATE_DATE T_DATE
903 ,REL_LAST_UPDATE_LOGIN T_NUM
904 ,REL_OBJECT_VERSION_NUMBER T_NUM
905 ,REL_SECURITY_GROUP_ID T_NUM
906 ,REL_MIGRATED_FLAG T_V1
907 );
908 --
909 TYPE SYSTEM_HISTORY_REC_TAB IS RECORD
910 (
911 TRANSACTION_ID T_NUM
912 ,SYSTEM_HISTORY_ID T_NUM
913 ,SYSTEM_ID T_NUM
914 ,OLD_CUSTOMER_ID T_NUM
915 ,NEW_CUSTOMER_ID T_NUM
916 ,OLD_SYSTEM_TYPE_CODE T_V30
917 ,NEW_SYSTEM_TYPE_CODE T_V30
918 ,OLD_SYSTEM_NUMBER T_V30
919 ,NEW_SYSTEM_NUMBER T_V30
920 ,OLD_PARENT_SYSTEM_ID T_NUM
921 ,NEW_PARENT_SYSTEM_ID T_NUM
922 ,OLD_BILL_TO_CONTACT_ID T_NUM
923 ,NEW_BILL_TO_CONTACT_ID T_NUM
924 ,OLD_SHIP_TO_CONTACT_ID T_NUM
925 ,NEW_SHIP_TO_CONTACT_ID T_NUM
926 ,OLD_TECHNICAL_CONTACT_ID T_NUM
927 ,NEW_TECHNICAL_CONTACT_ID T_NUM
928 ,OLD_SERVICE_ADMIN_CONTACT_ID T_NUM
929 ,NEW_SERVICE_ADMIN_CONTACT_ID T_NUM
930 ,OLD_SHIP_TO_SITE_USE_ID T_NUM
931 ,NEW_SHIP_TO_SITE_USE_ID T_NUM
932 ,OLD_INSTALL_SITE_USE_ID T_NUM
933 ,NEW_INSTALL_SITE_USE_ID T_NUM
934 ,OLD_BILL_TO_SITE_USE_ID T_NUM
935 ,NEW_BILL_TO_SITE_USE_ID T_NUM
936 ,OLD_COTERMINATE_DAY_MONTH T_V6
937 ,NEW_COTERMINATE_DAY_MONTH T_V6
938 ,OLD_SYS_ACTIVE_START_DATE T_DATE
939 ,NEW_SYS_ACTIVE_START_DATE T_DATE
940 ,OLD_SYS_ACTIVE_END_DATE T_DATE
941 ,NEW_SYS_ACTIVE_END_DATE T_DATE
942 ,OLD_AUTOCREATED_FROM_SYSTEM T_NUM
943 ,NEW_AUTOCREATED_FROM_SYSTEM T_NUM
944 ,OLD_CONFIG_SYSTEM_TYPE T_V30
945 ,NEW_CONFIG_SYSTEM_TYPE T_V30
946 ,OLD_NAME T_V50
947 ,NEW_NAME T_V50
948 ,OLD_SYS_DESCRIPTION T_V240
949 ,NEW_SYS_DESCRIPTION T_V240
950 ,OLD_SYS_CONTEXT T_V30
951 ,NEW_SYS_CONTEXT T_V30
952 ,OLD_SYS_ATTRIBUTE1 T_V240
953 ,NEW_SYS_ATTRIBUTE1 T_V240
954 ,OLD_SYS_ATTRIBUTE2 T_V240
955 ,NEW_SYS_ATTRIBUTE2 T_V240
956 ,OLD_SYS_ATTRIBUTE3 T_V240
957 ,NEW_SYS_ATTRIBUTE3 T_V240
958 ,OLD_SYS_ATTRIBUTE4 T_V240
959 ,NEW_SYS_ATTRIBUTE4 T_V240
960 ,OLD_SYS_ATTRIBUTE5 T_V240
961 ,NEW_SYS_ATTRIBUTE5 T_V240
962 ,OLD_SYS_ATTRIBUTE6 T_V240
963 ,NEW_SYS_ATTRIBUTE6 T_V240
964 ,OLD_SYS_ATTRIBUTE7 T_V240
965 ,NEW_SYS_ATTRIBUTE7 T_V240
966 ,OLD_SYS_ATTRIBUTE8 T_V240
967 ,NEW_SYS_ATTRIBUTE8 T_V240
968 ,OLD_SYS_ATTRIBUTE9 T_V240
969 ,NEW_SYS_ATTRIBUTE9 T_V240
970 ,OLD_SYS_ATTRIBUTE10 T_V240
971 ,NEW_SYS_ATTRIBUTE10 T_V240
972 ,OLD_SYS_ATTRIBUTE11 T_V240
973 ,NEW_SYS_ATTRIBUTE11 T_V240
974 ,OLD_SYS_ATTRIBUTE12 T_V240
975 ,NEW_SYS_ATTRIBUTE12 T_V240
976 ,OLD_SYS_ATTRIBUTE13 T_V240
977 ,NEW_SYS_ATTRIBUTE13 T_V240
978 ,OLD_SYS_ATTRIBUTE14 T_V240
979 ,NEW_SYS_ATTRIBUTE14 T_V240
980 ,OLD_SYS_ATTRIBUTE15 T_V240
981 ,NEW_SYS_ATTRIBUTE15 T_V240
982 ,SYS_FULL_DUMP_FLAG T_V1
983 ,SYS_CREATED_BY T_NUM
984 ,SYS_CREATION_DATE T_DATE
985 ,SYS_LAST_UPDATED_BY T_NUM
986 ,SYS_LAST_UPDATE_DATE T_DATE
987 ,SYS_LAST_UPDATE_LOGIN T_NUM
988 ,SYS_OBJECT_VERSION_NUMBER T_NUM
989 ,SYS_SECURITY_GROUP_ID T_NUM
990 ,SYS_MIGRATED_FLAG T_V1
991 ,OLD_SYS_OPERATING_UNIT_ID T_NUM
992 ,NEW_SYS_OPERATING_UNIT_ID T_NUM
993 );
994
995 --
996 -- This is the main archive program which internally calls each of the entity
997 -- archive programs concurrently. It accepts a date timestamp as an parameter.
998 --
999 PROCEDURE Archive
1000 (
1001 errbuf OUT NOCOPY VARCHAR2
1002 ,retcode OUT NOCOPY NUMBER
1006 -- This program archives the Instance history for the
1003 ,purge_to_date IN VARCHAR2 --DATE
1004 );
1005 --
1007 -- transaction range passed
1008 --
1009 PROCEDURE Instance_archive
1010 (
1011 errbuf OUT NOCOPY VARCHAR2
1012 ,retcode OUT NOCOPY NUMBER
1013 ,from_trans IN NUMBER
1014 ,to_trans IN NUMBER
1015 ,purge_to_date IN VARCHAR2
1016 );
1017 --
1018 -- This program archives the Party history for the
1019 -- transaction range passed
1020 --
1021 PROCEDURE Party_archive
1022 (
1023 errbuf OUT NOCOPY VARCHAR2
1024 ,retcode OUT NOCOPY NUMBER
1025 ,from_trans IN NUMBER
1026 ,to_trans IN NUMBER
1027 ,purge_to_date IN VARCHAR2
1028 );
1029 --
1030 -- This program archives the Account history for the
1031 -- transaction range passed
1032 --
1033 PROCEDURE Account_archive
1034 (
1035 errbuf OUT NOCOPY VARCHAR2
1036 ,retcode OUT NOCOPY NUMBER
1037 ,from_trans IN NUMBER
1038 ,to_trans IN NUMBER
1039 ,purge_to_date IN VARCHAR2
1040 );
1041 --
1042 -- This program archives the Operating unit history for the
1043 -- transaction range passed
1044 --
1045 PROCEDURE Org_Units_archive
1046 (
1047 errbuf OUT NOCOPY VARCHAR2
1048 ,retcode OUT NOCOPY NUMBER
1049 ,from_trans IN NUMBER
1050 ,to_trans IN NUMBER
1051 ,purge_to_date IN VARCHAR2
1052 );
1053 --
1054 -- This program archives the Extended Attribs history for the
1055 -- transaction range passed
1056 --
1057 PROCEDURE Ext_Attribs_archive
1058 (
1059 errbuf OUT NOCOPY VARCHAR2
1060 ,retcode OUT NOCOPY NUMBER
1061 ,from_trans IN NUMBER
1062 ,to_trans IN NUMBER
1063 ,purge_to_date IN VARCHAR2
1064 );
1065 --
1066 -- This program archives the Pricing Attribs history for the
1067 -- transaction range passed
1068 --
1069 PROCEDURE Pricing_archive
1070 (
1071 errbuf OUT NOCOPY VARCHAR2
1072 ,retcode OUT NOCOPY NUMBER
1073 ,from_trans IN NUMBER
1074 ,to_trans IN NUMBER
1075 ,purge_to_date IN VARCHAR2
1076 );
1077 --
1078 -- This program archives the Instance Asset history for the
1079 -- transaction range passed
1080 --
1081 PROCEDURE Assets_archive
1082 (
1083 errbuf OUT NOCOPY VARCHAR2
1084 ,retcode OUT NOCOPY NUMBER
1085 ,from_trans IN NUMBER
1086 ,to_trans IN NUMBER
1087 ,purge_to_date IN VARCHAR2
1088 );
1089 --
1090 -- This program archives the Version Label history for the
1091 -- transaction range passed
1092 --
1093 PROCEDURE Ver_Labels_archive
1094 (
1095 errbuf OUT NOCOPY VARCHAR2
1096 ,retcode OUT NOCOPY NUMBER
1097 ,from_trans IN NUMBER
1098 ,to_trans IN NUMBER
1099 ,purge_to_date IN VARCHAR2
1100 );
1101 --
1102 -- This program archives the Instance Rel. history for the
1103 -- transaction range passed
1104 --
1105 PROCEDURE Inst_Relnships_archive
1106 (
1107 errbuf OUT NOCOPY VARCHAR2
1108 ,retcode OUT NOCOPY NUMBER
1109 ,from_trans IN NUMBER
1110 ,to_trans IN NUMBER
1111 ,purge_to_date IN VARCHAR2
1112 );
1113 --
1114 -- This program archives the Systems history for the
1115 -- transaction range passed
1116 --
1117 PROCEDURE Systems_archive
1118 (
1119 errbuf OUT NOCOPY VARCHAR2
1120 ,retcode OUT NOCOPY NUMBER
1121 ,from_trans IN NUMBER
1122 ,to_trans IN NUMBER
1123 ,purge_to_date IN VARCHAR2
1124 );
1125 --
1126
1127 Procedure Record_count
1128 (
1129 From_trans IN NUMBER
1130 ,To_trans IN NUMBER
1131 ,purge_to_date IN VARCHAR2
1132 ,Recs_count OUT NOCOPY NUMBER
1133 );
1134
1135 END CSI_TXN_HISTORY_PURGE_PVT;
1136 --