1 PACKAGE WIP_MTL_TXNS_TEMP_CLEANUP AUTHID CURRENT_USER AS
2 /* $Header: wipmtcls.pls 115.7 2002/11/28 13:28:38 rmahidha ship $ */
3
4 TYPE TRANSACTION_HEADER_ID_T IS TABLE OF
5 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_HEADER_ID%TYPE
6 INDEX BY BINARY_INTEGER;
7
8 TYPE TRANSACTION_TEMP_ID_T IS TABLE OF
9 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID%TYPE
10 INDEX BY BINARY_INTEGER;
11
12 TYPE SOURCE_CODE_T IS TABLE OF
13 MTL_MATERIAL_TRANSACTIONS_TEMP.SOURCE_CODE%TYPE
14 INDEX BY BINARY_INTEGER;
15
16 TYPE SOURCE_LINE_ID_T IS TABLE OF
17 MTL_MATERIAL_TRANSACTIONS_TEMP.SOURCE_LINE_ID%TYPE
18 INDEX BY BINARY_INTEGER;
19
20 TYPE TRANSACTION_MODE_T IS TABLE OF
21 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_MODE%TYPE
22 INDEX BY BINARY_INTEGER;
23
24 TYPE LOCK_FLAG_T IS TABLE OF
25 MTL_MATERIAL_TRANSACTIONS_TEMP.LOCK_FLAG%TYPE
26 INDEX BY BINARY_INTEGER;
27
28 TYPE LAST_UPDATE_DATE_T IS TABLE OF
29 MTL_MATERIAL_TRANSACTIONS_TEMP.LAST_UPDATE_DATE%TYPE
30 INDEX BY BINARY_INTEGER;
31
32 TYPE LAST_UPDATED_BY_T IS TABLE OF
33 MTL_MATERIAL_TRANSACTIONS_TEMP.LAST_UPDATED_BY%TYPE
34 INDEX BY BINARY_INTEGER;
35
36 TYPE CREATION_DATE_T IS TABLE OF
37 MTL_MATERIAL_TRANSACTIONS_TEMP.CREATION_DATE%TYPE
38 INDEX BY BINARY_INTEGER;
39
40 TYPE CREATED_BY_T IS TABLE OF
41 MTL_MATERIAL_TRANSACTIONS_TEMP.CREATED_BY%TYPE
42 INDEX BY BINARY_INTEGER;
43
44 TYPE LAST_UPDATE_LOGIN_T IS TABLE OF
45 MTL_MATERIAL_TRANSACTIONS_TEMP.LAST_UPDATE_LOGIN%TYPE
46 INDEX BY BINARY_INTEGER;
47
48 TYPE REQUEST_ID_T IS TABLE OF
49 MTL_MATERIAL_TRANSACTIONS_TEMP.REQUEST_ID%TYPE
50 INDEX BY BINARY_INTEGER;
51
52 TYPE PROGRAM_APPLICATION_ID_T IS TABLE OF
53 MTL_MATERIAL_TRANSACTIONS_TEMP.PROGRAM_APPLICATION_ID%TYPE
54 INDEX BY BINARY_INTEGER;
55
56 TYPE PROGRAM_ID_T IS TABLE OF
57 MTL_MATERIAL_TRANSACTIONS_TEMP.PROGRAM_ID%TYPE
58 INDEX BY BINARY_INTEGER;
59
60 TYPE PROGRAM_UPDATE_DATE_T IS TABLE OF
61 MTL_MATERIAL_TRANSACTIONS_TEMP.PROGRAM_UPDATE_DATE%TYPE
62 INDEX BY BINARY_INTEGER;
63
64 TYPE INVENTORY_ITEM_ID_T IS TABLE OF
65 MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%TYPE
66 INDEX BY BINARY_INTEGER;
67
68 TYPE REVISION_T IS TABLE OF
69 MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE
70 INDEX BY BINARY_INTEGER;
71
72 TYPE ORGANIZATION_ID_T IS TABLE OF
73 MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID%TYPE
74 INDEX BY BINARY_INTEGER;
75
76 TYPE SUBINVENTORY_CODE_T IS TABLE OF
77 MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%TYPE
78 INDEX BY BINARY_INTEGER;
79
80 TYPE LOCATOR_ID_T IS TABLE OF
81 MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID%TYPE
82 INDEX BY BINARY_INTEGER;
83
84 TYPE TRANSACTION_QUANTITY_T IS TABLE OF
85 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE
86 INDEX BY BINARY_INTEGER;
87
88 TYPE PRIMARY_QUANTITY_T IS TABLE OF
89 MTL_MATERIAL_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE
90 INDEX BY BINARY_INTEGER;
91
92 TYPE TRANSACTION_UOM_T IS TABLE OF
93 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE
94 INDEX BY BINARY_INTEGER;
95
96 TYPE TRANSACTION_COST_T IS TABLE OF
97 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_COST%TYPE
98 INDEX BY BINARY_INTEGER;
99
100 TYPE TRANSACTION_TYPE_ID_T IS TABLE OF
101 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TYPE_ID%TYPE
102 INDEX BY BINARY_INTEGER;
103
104 TYPE TRANSACTION_ACTION_ID_T IS TABLE OF
105 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_ACTION_ID%TYPE
106 INDEX BY BINARY_INTEGER;
107
108 TYPE TRANSACTION_SOURCE_TYPE_ID_T IS TABLE OF
109 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID%TYPE
110 INDEX BY BINARY_INTEGER;
111
112 TYPE TRANSACTION_SOURCE_ID_T IS TABLE OF
113 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID%TYPE
114 INDEX BY BINARY_INTEGER;
115
116 TYPE TRANSACTION_SOURCE_NAME_T IS TABLE OF
117 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_NAME%TYPE
118 INDEX BY BINARY_INTEGER;
119
120 TYPE TRANSACTION_DATE_T IS TABLE OF
121 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_DATE%TYPE
122 INDEX BY BINARY_INTEGER;
123
124 TYPE ACCT_PERIOD_ID_T IS TABLE OF
125 MTL_MATERIAL_TRANSACTIONS_TEMP.ACCT_PERIOD_ID%TYPE
126 INDEX BY BINARY_INTEGER;
127
128 TYPE DISTRIBUTION_ACCOUNT_ID_T IS TABLE OF
129 MTL_MATERIAL_TRANSACTIONS_TEMP.DISTRIBUTION_ACCOUNT_ID%TYPE
130 INDEX BY BINARY_INTEGER;
131
132 TYPE TRANSACTION_REFERENCE_T IS TABLE OF
133 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_REFERENCE%TYPE
134 INDEX BY BINARY_INTEGER;
135
136 TYPE REASON_ID_T IS TABLE OF
137 MTL_MATERIAL_TRANSACTIONS_TEMP.REASON_ID%TYPE
138 INDEX BY BINARY_INTEGER;
139
140 TYPE LOT_NUMBER_T IS TABLE OF
141 MTL_MATERIAL_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE
142 INDEX BY BINARY_INTEGER;
143
144 TYPE LOT_EXPIRATION_DATE_T IS TABLE OF
145 MTL_MATERIAL_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE
146 INDEX BY BINARY_INTEGER;
147
148 TYPE SERIAL_NUMBER_T IS TABLE OF
149 MTL_MATERIAL_TRANSACTIONS_TEMP.SERIAL_NUMBER%TYPE
150 INDEX BY BINARY_INTEGER;
151
152 TYPE RECEIVING_DOCUMENT_T IS TABLE OF
153 MTL_MATERIAL_TRANSACTIONS_TEMP.RECEIVING_DOCUMENT%TYPE
154 INDEX BY BINARY_INTEGER;
155
156 TYPE RCV_TRANSACTION_ID_T IS TABLE OF
157 MTL_MATERIAL_TRANSACTIONS_TEMP.RCV_TRANSACTION_ID%TYPE
158 INDEX BY BINARY_INTEGER;
159
160 TYPE MOVE_TRANSACTION_ID_T IS TABLE OF
161 MTL_MATERIAL_TRANSACTIONS_TEMP.MOVE_TRANSACTION_ID%TYPE
162 INDEX BY BINARY_INTEGER;
163
164 TYPE COMPLETION_TRANSACTION_ID_T IS TABLE OF
165 MTL_MATERIAL_TRANSACTIONS_TEMP.COMPLETION_TRANSACTION_ID%TYPE
166 INDEX BY BINARY_INTEGER;
167
168 TYPE WIP_ENTITY_TYPE_T IS TABLE OF
169 MTL_MATERIAL_TRANSACTIONS_TEMP.WIP_ENTITY_TYPE%TYPE
170 INDEX BY BINARY_INTEGER;
171
172 TYPE SCHEDULE_ID_T IS TABLE OF
173 MTL_MATERIAL_TRANSACTIONS_TEMP.SCHEDULE_ID%TYPE
174 INDEX BY BINARY_INTEGER;
175
176 TYPE REPETITIVE_LINE_ID_T IS TABLE OF
177 MTL_MATERIAL_TRANSACTIONS_TEMP.REPETITIVE_LINE_ID%TYPE
178 INDEX BY BINARY_INTEGER;
179
180 TYPE EMPLOYEE_CODE_T IS TABLE OF
181 MTL_MATERIAL_TRANSACTIONS_TEMP.EMPLOYEE_CODE%TYPE
182 INDEX BY BINARY_INTEGER;
183
184 TYPE SCHEDULE_UPDATE_CODE_T IS TABLE OF
185 MTL_MATERIAL_TRANSACTIONS_TEMP.SCHEDULE_UPDATE_CODE%TYPE
186 INDEX BY BINARY_INTEGER;
187
188 TYPE SETUP_TEARDOWN_CODE_T IS TABLE OF
189 MTL_MATERIAL_TRANSACTIONS_TEMP.SETUP_TEARDOWN_CODE%TYPE
190 INDEX BY BINARY_INTEGER;
191
192 TYPE ITEM_ORDERING_T IS TABLE OF
193 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_ORDERING%TYPE
194 INDEX BY BINARY_INTEGER;
195
196 TYPE NEGATIVE_REQ_FLAG_T IS TABLE OF
197 MTL_MATERIAL_TRANSACTIONS_TEMP.NEGATIVE_REQ_FLAG%TYPE
198 INDEX BY BINARY_INTEGER;
199
200 TYPE OPERATION_SEQ_NUM_T IS TABLE OF
201 MTL_MATERIAL_TRANSACTIONS_TEMP.OPERATION_SEQ_NUM%TYPE
202 INDEX BY BINARY_INTEGER;
203
204 TYPE PICKING_LINE_ID_T IS TABLE OF
205 MTL_MATERIAL_TRANSACTIONS_TEMP.PICKING_LINE_ID%TYPE
206 INDEX BY BINARY_INTEGER;
207
208 TYPE TRX_SOURCE_LINE_ID_T IS TABLE OF
209 MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_LINE_ID%TYPE
210 INDEX BY BINARY_INTEGER;
211
212 TYPE TRX_SOURCE_DELIVERY_ID_T IS TABLE OF
213 MTL_MATERIAL_TRANSACTIONS_TEMP.TRX_SOURCE_DELIVERY_ID%TYPE
214 INDEX BY BINARY_INTEGER;
215
216 TYPE PHYSICAL_ADJUSTMENT_ID_T IS TABLE OF
217 MTL_MATERIAL_TRANSACTIONS_TEMP.PHYSICAL_ADJUSTMENT_ID%TYPE
218 INDEX BY BINARY_INTEGER;
219
220 TYPE CYCLE_COUNT_ID_T IS TABLE OF
221 MTL_MATERIAL_TRANSACTIONS_TEMP.CYCLE_COUNT_ID%TYPE
222 INDEX BY BINARY_INTEGER;
223
224 TYPE RMA_LINE_ID_T IS TABLE OF
225 MTL_MATERIAL_TRANSACTIONS_TEMP.RMA_LINE_ID%TYPE
226 INDEX BY BINARY_INTEGER;
227
228 TYPE CUSTOMER_SHIP_ID_T IS TABLE OF
229 MTL_MATERIAL_TRANSACTIONS_TEMP.CUSTOMER_SHIP_ID%TYPE
230 INDEX BY BINARY_INTEGER;
231
232 TYPE CURRENCY_CODE_T IS TABLE OF
233 MTL_MATERIAL_TRANSACTIONS_TEMP.CURRENCY_CODE%TYPE
234 INDEX BY BINARY_INTEGER;
235
236 TYPE CURRENCY_CONVERSION_RATE_T IS TABLE OF
237 MTL_MATERIAL_TRANSACTIONS_TEMP.CURRENCY_CONVERSION_RATE%TYPE
238 INDEX BY BINARY_INTEGER;
239
240 TYPE CURRENCY_CONVERSION_TYPE_T IS TABLE OF
241 MTL_MATERIAL_TRANSACTIONS_TEMP.CURRENCY_CONVERSION_TYPE%TYPE
242 INDEX BY BINARY_INTEGER;
243
244 TYPE CURRENCY_CONVERSION_DATE_T IS TABLE OF
245 MTL_MATERIAL_TRANSACTIONS_TEMP.CURRENCY_CONVERSION_DATE%TYPE
246 INDEX BY BINARY_INTEGER;
247
248 TYPE USSGL_TRANSACTION_CODE_T IS TABLE OF
249 MTL_MATERIAL_TRANSACTIONS_TEMP.USSGL_TRANSACTION_CODE%TYPE
250 INDEX BY BINARY_INTEGER;
251
252 TYPE VENDOR_LOT_NUMBER_T IS TABLE OF
253 MTL_MATERIAL_TRANSACTIONS_TEMP.VENDOR_LOT_NUMBER%TYPE
254 INDEX BY BINARY_INTEGER;
255
256 TYPE ENCUMBRANCE_ACCOUNT_T IS TABLE OF
257 MTL_MATERIAL_TRANSACTIONS_TEMP.ENCUMBRANCE_ACCOUNT%TYPE
258 INDEX BY BINARY_INTEGER;
259
260 TYPE ENCUMBRANCE_AMOUNT_T IS TABLE OF
261 MTL_MATERIAL_TRANSACTIONS_TEMP.ENCUMBRANCE_AMOUNT%TYPE
262 INDEX BY BINARY_INTEGER;
263
264 TYPE SHIP_TO_LOCATION_T IS TABLE OF
265 MTL_MATERIAL_TRANSACTIONS_TEMP.SHIP_TO_LOCATION%TYPE
266 INDEX BY BINARY_INTEGER;
267
268 TYPE SHIPMENT_NUMBER_T IS TABLE OF
269 MTL_MATERIAL_TRANSACTIONS_TEMP.SHIPMENT_NUMBER%TYPE
270 INDEX BY BINARY_INTEGER;
271
272 TYPE TRANSFER_COST_T IS TABLE OF
273 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_COST%TYPE
274 INDEX BY BINARY_INTEGER;
275
276 TYPE TRANSPORTATION_COST_T IS TABLE OF
277 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSPORTATION_COST%TYPE
278 INDEX BY BINARY_INTEGER;
279
280 TYPE TRANSPORTATION_ACCOUNT_T IS TABLE OF
281 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSPORTATION_ACCOUNT%TYPE
282 INDEX BY BINARY_INTEGER;
283
284 TYPE FREIGHT_CODE_T IS TABLE OF
285 MTL_MATERIAL_TRANSACTIONS_TEMP.FREIGHT_CODE%TYPE
286 INDEX BY BINARY_INTEGER;
287
288 TYPE CONTAINERS_T IS TABLE OF
289 MTL_MATERIAL_TRANSACTIONS_TEMP.CONTAINERS%TYPE
290 INDEX BY BINARY_INTEGER;
291
292 TYPE WAYBILL_AIRBILL_T IS TABLE OF
293 MTL_MATERIAL_TRANSACTIONS_TEMP.WAYBILL_AIRBILL%TYPE
294 INDEX BY BINARY_INTEGER;
295
296 TYPE EXPECTED_ARRIVAL_DATE_T IS TABLE OF
297 MTL_MATERIAL_TRANSACTIONS_TEMP.EXPECTED_ARRIVAL_DATE%TYPE
298 INDEX BY BINARY_INTEGER;
299
300 TYPE TRANSFER_SUBINVENTORY_T IS TABLE OF
301 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_SUBINVENTORY%TYPE
302 INDEX BY BINARY_INTEGER;
303
304 TYPE TRANSFER_ORGANIZATION_T IS TABLE OF
305 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION%TYPE
306 INDEX BY BINARY_INTEGER;
307
308 TYPE TRANSFER_TO_LOCATION_T IS TABLE OF
309 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_TO_LOCATION%TYPE
310 INDEX BY BINARY_INTEGER;
311
312 TYPE NEW_AVERAGE_COST_T IS TABLE OF
313 MTL_MATERIAL_TRANSACTIONS_TEMP.NEW_AVERAGE_COST%TYPE
314 INDEX BY BINARY_INTEGER;
315
316 TYPE VALUE_CHANGE_T IS TABLE OF
317 MTL_MATERIAL_TRANSACTIONS_TEMP.VALUE_CHANGE%TYPE
318 INDEX BY BINARY_INTEGER;
319
320 TYPE PERCENTAGE_CHANGE_T IS TABLE OF
321 MTL_MATERIAL_TRANSACTIONS_TEMP.PERCENTAGE_CHANGE%TYPE
322 INDEX BY BINARY_INTEGER;
323
324 TYPE MATERIAL_ALLOCATION_TEMP_ID_T IS TABLE OF
325 MTL_MATERIAL_TRANSACTIONS_TEMP.MATERIAL_ALLOCATION_TEMP_ID%TYPE
326 INDEX BY BINARY_INTEGER;
327
328 TYPE DEMAND_SOURCE_HEADER_ID_T IS TABLE OF
329 MTL_MATERIAL_TRANSACTIONS_TEMP.DEMAND_SOURCE_HEADER_ID%TYPE
330 INDEX BY BINARY_INTEGER;
331
332 TYPE DEMAND_SOURCE_LINE_T IS TABLE OF
333 MTL_MATERIAL_TRANSACTIONS_TEMP.DEMAND_SOURCE_LINE%TYPE
334 INDEX BY BINARY_INTEGER;
335
336 TYPE DEMAND_SOURCE_DELIVERY_T IS TABLE OF
337 MTL_MATERIAL_TRANSACTIONS_TEMP.DEMAND_SOURCE_DELIVERY%TYPE
338 INDEX BY BINARY_INTEGER;
339
340 TYPE ITEM_SEGMENTS_T IS TABLE OF
341 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_SEGMENTS%TYPE
342 INDEX BY BINARY_INTEGER;
343
344 TYPE ITEM_DESCRIPTION_T IS TABLE OF
345 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_DESCRIPTION%TYPE
346 INDEX BY BINARY_INTEGER;
347
348 TYPE ITEM_TRX_ENABLED_FLAG_T IS TABLE OF
349 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_TRX_ENABLED_FLAG%TYPE
350 INDEX BY BINARY_INTEGER;
351
352 TYPE ITEM_LOCATION_CONTROL_CODE_T IS TABLE OF
353 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_LOCATION_CONTROL_CODE%TYPE
354 INDEX BY BINARY_INTEGER;
355
356 TYPE ITEM_RESTRICT_SUBINV_CODE_T IS TABLE OF
357 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_RESTRICT_SUBINV_CODE%TYPE
358 INDEX BY BINARY_INTEGER;
359
360 TYPE ITEM_RESTRICT_LOCATORS_CODE_T IS TABLE OF
361 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_RESTRICT_LOCATORS_CODE%TYPE
362 INDEX BY BINARY_INTEGER;
363
364 TYPE ITEM_REV_QTY_CONTROL_CODE_T IS TABLE OF
365 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_REVISION_QTY_CONTROL_CODE%TYPE
366 INDEX BY BINARY_INTEGER;
367
368 TYPE ITEM_PRIMARY_UOM_CODE_T IS TABLE OF
369 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_PRIMARY_UOM_CODE%TYPE
370 INDEX BY BINARY_INTEGER;
371
372 TYPE ITEM_UOM_CLASS_T IS TABLE OF
373 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_UOM_CLASS%TYPE
374 INDEX BY BINARY_INTEGER;
375
376 TYPE ITEM_SHELF_LIFE_CODE_T IS TABLE OF
377 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_SHELF_LIFE_CODE%TYPE
378 INDEX BY BINARY_INTEGER;
379
380 TYPE ITEM_SHELF_LIFE_DAYS_T IS TABLE OF
381 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_SHELF_LIFE_DAYS%TYPE
382 INDEX BY BINARY_INTEGER;
383
384 TYPE ITEM_LOT_CONTROL_CODE_T IS TABLE OF
385 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_LOT_CONTROL_CODE%TYPE
386 INDEX BY BINARY_INTEGER;
387
388 TYPE ITEM_SERIAL_CONTROL_CODE_T IS TABLE OF
389 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_SERIAL_CONTROL_CODE%TYPE
390 INDEX BY BINARY_INTEGER;
391
392 TYPE ALLOWED_UNITS_LOOKUP_CODE_T IS TABLE OF
393 MTL_MATERIAL_TRANSACTIONS_TEMP.ALLOWED_UNITS_LOOKUP_CODE%TYPE
394 INDEX BY BINARY_INTEGER;
395
396 TYPE DEPARTMENT_ID_T IS TABLE OF
397 MTL_MATERIAL_TRANSACTIONS_TEMP.DEPARTMENT_ID%TYPE
398 INDEX BY BINARY_INTEGER;
399
400 TYPE WIP_SUPPLY_TYPE_T IS TABLE OF
401 MTL_MATERIAL_TRANSACTIONS_TEMP.WIP_SUPPLY_TYPE%TYPE
402 INDEX BY BINARY_INTEGER;
403
404 TYPE SUPPLY_SUBINVENTORY_T IS TABLE OF
405 MTL_MATERIAL_TRANSACTIONS_TEMP.SUPPLY_SUBINVENTORY%TYPE
406 INDEX BY BINARY_INTEGER;
407
408 TYPE SUPPLY_LOCATOR_ID_T IS TABLE OF
409 MTL_MATERIAL_TRANSACTIONS_TEMP.SUPPLY_LOCATOR_ID%TYPE
410 INDEX BY BINARY_INTEGER;
411
412 TYPE VALID_SUBINVENTORY_FLAG_T IS TABLE OF
413 MTL_MATERIAL_TRANSACTIONS_TEMP.VALID_SUBINVENTORY_FLAG%TYPE
414 INDEX BY BINARY_INTEGER;
415
416 TYPE VALID_LOCATOR_FLAG_T IS TABLE OF
417 MTL_MATERIAL_TRANSACTIONS_TEMP.VALID_LOCATOR_FLAG%TYPE
418 INDEX BY BINARY_INTEGER;
419
420 TYPE LOCATOR_SEGMENTS_T IS TABLE OF
421 MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_SEGMENTS%TYPE
422 INDEX BY BINARY_INTEGER;
423
424 TYPE CURRENT_LOCATOR_CONTROL_CODE_T IS TABLE OF
425 MTL_MATERIAL_TRANSACTIONS_TEMP.CURRENT_LOCATOR_CONTROL_CODE%TYPE
426 INDEX BY BINARY_INTEGER;
427
428 TYPE NUMBER_OF_LOTS_ENTERED_T IS TABLE OF
429 MTL_MATERIAL_TRANSACTIONS_TEMP.NUMBER_OF_LOTS_ENTERED%TYPE
430 INDEX BY BINARY_INTEGER;
431
432 TYPE WIP_COMMIT_FLAG_T IS TABLE OF
433 MTL_MATERIAL_TRANSACTIONS_TEMP.WIP_COMMIT_FLAG%TYPE
434 INDEX BY BINARY_INTEGER;
435
436 TYPE NEXT_LOT_NUMBER_T IS TABLE OF
437 MTL_MATERIAL_TRANSACTIONS_TEMP.NEXT_LOT_NUMBER%TYPE
438 INDEX BY BINARY_INTEGER;
439
440 TYPE LOT_ALPHA_PREFIX_T IS TABLE OF
441 MTL_MATERIAL_TRANSACTIONS_TEMP.LOT_ALPHA_PREFIX%TYPE
442 INDEX BY BINARY_INTEGER;
443
444 TYPE NEXT_SERIAL_NUMBER_T IS TABLE OF
445 MTL_MATERIAL_TRANSACTIONS_TEMP.NEXT_SERIAL_NUMBER%TYPE
446 INDEX BY BINARY_INTEGER;
447
448 TYPE SERIAL_ALPHA_PREFIX_T IS TABLE OF
449 MTL_MATERIAL_TRANSACTIONS_TEMP.SERIAL_ALPHA_PREFIX%TYPE
450 INDEX BY BINARY_INTEGER;
451
452 TYPE POSTING_FLAG_T IS TABLE OF
453 MTL_MATERIAL_TRANSACTIONS_TEMP.POSTING_FLAG%TYPE
454 INDEX BY BINARY_INTEGER;
455
456 TYPE REQUIRED_FLAG_T IS TABLE OF
457 MTL_MATERIAL_TRANSACTIONS_TEMP.REQUIRED_FLAG%TYPE
458 INDEX BY BINARY_INTEGER;
459
460 TYPE PROCESS_FLAG_T IS TABLE OF
461 MTL_MATERIAL_TRANSACTIONS_TEMP.PROCESS_FLAG%TYPE
462 INDEX BY BINARY_INTEGER;
463
464 TYPE ERROR_CODE_T IS TABLE OF
465 MTL_MATERIAL_TRANSACTIONS_TEMP.ERROR_CODE%TYPE
466 INDEX BY BINARY_INTEGER;
467
468 TYPE ATTRIBUTE_CATEGORY_T IS TABLE OF
469 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE_CATEGORY%TYPE
470 INDEX BY BINARY_INTEGER;
471
472 TYPE ATTRIBUTE1_T IS TABLE OF
473 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE1%TYPE
474 INDEX BY BINARY_INTEGER;
475
476 TYPE ATTRIBUTE2_T IS TABLE OF
477 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE2%TYPE
478 INDEX BY BINARY_INTEGER;
479
480 TYPE ATTRIBUTE3_T IS TABLE OF
481 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE3%TYPE
482 INDEX BY BINARY_INTEGER;
483
484 TYPE ATTRIBUTE4_T IS TABLE OF
485 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE4%TYPE
486 INDEX BY BINARY_INTEGER;
487
488 TYPE ATTRIBUTE5_T IS TABLE OF
489 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE5%TYPE
490 INDEX BY BINARY_INTEGER;
491
492 TYPE ATTRIBUTE6_T IS TABLE OF
493 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE6%TYPE
494 INDEX BY BINARY_INTEGER;
495
496 TYPE ATTRIBUTE7_T IS TABLE OF
497 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE7%TYPE
498 INDEX BY BINARY_INTEGER;
499
500 TYPE ATTRIBUTE8_T IS TABLE OF
501 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE8%TYPE
502 INDEX BY BINARY_INTEGER;
503
504 TYPE ATTRIBUTE9_T IS TABLE OF
505 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE9%TYPE
506 INDEX BY BINARY_INTEGER;
507
508 TYPE ATTRIBUTE10_T IS TABLE OF
509 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE10%TYPE
510 INDEX BY BINARY_INTEGER;
511
512 TYPE ATTRIBUTE11_T IS TABLE OF
513 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE11%TYPE
514 INDEX BY BINARY_INTEGER;
515
516 TYPE ATTRIBUTE12_T IS TABLE OF
517 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE12%TYPE
518 INDEX BY BINARY_INTEGER;
519
520 TYPE ATTRIBUTE13_T IS TABLE OF
521 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE13%TYPE
522 INDEX BY BINARY_INTEGER;
523
524 TYPE ATTRIBUTE14_T IS TABLE OF
525 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE14%TYPE
526 INDEX BY BINARY_INTEGER;
527
528 TYPE ATTRIBUTE15_T IS TABLE OF
529 MTL_MATERIAL_TRANSACTIONS_TEMP.ATTRIBUTE15%TYPE
530 INDEX BY BINARY_INTEGER;
531
532 TYPE PRIMARY_SWITCH_T IS TABLE OF
533 MTL_MATERIAL_TRANSACTIONS_TEMP.PRIMARY_SWITCH%TYPE
534 INDEX BY BINARY_INTEGER;
535
536 TYPE DEPARTMENT_CODE_T IS TABLE OF
537 MTL_MATERIAL_TRANSACTIONS_TEMP.DEPARTMENT_CODE%TYPE
538 INDEX BY BINARY_INTEGER;
539
540 TYPE ERROR_EXPLANATION_T IS TABLE OF
541 MTL_MATERIAL_TRANSACTIONS_TEMP.ERROR_EXPLANATION%TYPE
542 INDEX BY BINARY_INTEGER;
543
544 TYPE DEMAND_ID_T IS TABLE OF
545 MTL_MATERIAL_TRANSACTIONS_TEMP.DEMAND_ID%TYPE
546 INDEX BY BINARY_INTEGER;
547
548 TYPE ITEM_INVENTORY_ASSET_FLAG_T IS TABLE OF
549 MTL_MATERIAL_TRANSACTIONS_TEMP.ITEM_INVENTORY_ASSET_FLAG%TYPE
550 INDEX BY BINARY_INTEGER;
551
552 TYPE SHIPPABLE_FLAG_T IS TABLE OF
553 MTL_MATERIAL_TRANSACTIONS_TEMP.SHIPPABLE_FLAG%TYPE
554 INDEX BY BINARY_INTEGER;
555
556 TYPE REQUISITION_LINE_ID_T IS TABLE OF
557 MTL_MATERIAL_TRANSACTIONS_TEMP.REQUISITION_LINE_ID%TYPE
558 INDEX BY BINARY_INTEGER;
559
560 TYPE REQUISITION_DISTRIBUTION_ID_T IS TABLE OF
561 MTL_MATERIAL_TRANSACTIONS_TEMP.REQUISITION_DISTRIBUTION_ID%TYPE
562 INDEX BY BINARY_INTEGER;
563
564 TYPE MOVEMENT_ID_T IS TABLE OF
565 MTL_MATERIAL_TRANSACTIONS_TEMP.MOVEMENT_ID%TYPE
566 INDEX BY BINARY_INTEGER;
567
568 TYPE RESERVATION_QUANTITY_T IS TABLE OF
569 MTL_MATERIAL_TRANSACTIONS_TEMP.RESERVATION_QUANTITY%TYPE
570 INDEX BY BINARY_INTEGER;
571
572 TYPE SHIPPED_QUANTITY_T IS TABLE OF
573 MTL_MATERIAL_TRANSACTIONS_TEMP.SHIPPED_QUANTITY%TYPE
574 INDEX BY BINARY_INTEGER;
575
576 TYPE TRANSACTION_LINE_NUMBER_T IS TABLE OF
577 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_LINE_NUMBER%TYPE
578 INDEX BY BINARY_INTEGER;
579
580 TYPE EXPENDITURE_TYPE_T IS TABLE OF
581 MTL_MATERIAL_TRANSACTIONS_TEMP.EXPENDITURE_TYPE%TYPE
582 INDEX BY BINARY_INTEGER;
583
584 TYPE FINAL_COMPLETION_FLAG_T IS TABLE OF
585 MTL_MATERIAL_TRANSACTIONS_TEMP.FINAL_COMPLETION_FLAG%TYPE
586 INDEX BY BINARY_INTEGER;
587
588 TYPE MATERIAL_ACCOUNT_T IS TABLE OF
589 MTL_MATERIAL_TRANSACTIONS_TEMP.MATERIAL_ACCOUNT%TYPE
590 INDEX BY BINARY_INTEGER;
591
592 TYPE MATERIAL_OVERHEAD_ACCOUNT_T IS TABLE OF
593 MTL_MATERIAL_TRANSACTIONS_TEMP.MATERIAL_OVERHEAD_ACCOUNT%TYPE
594 INDEX BY BINARY_INTEGER;
595
596 TYPE OUTSIDE_PROCESSING_ACCOUNT_T IS TABLE OF
597 MTL_MATERIAL_TRANSACTIONS_TEMP.OUTSIDE_PROCESSING_ACCOUNT%TYPE
598 INDEX BY BINARY_INTEGER;
599
600 TYPE OVERHEAD_ACCOUNT_T IS TABLE OF
601 MTL_MATERIAL_TRANSACTIONS_TEMP.OVERHEAD_ACCOUNT%TYPE
602 INDEX BY BINARY_INTEGER;
603
604 TYPE PA_EXPENDITURE_ORG_ID_T IS TABLE OF
605 MTL_MATERIAL_TRANSACTIONS_TEMP.PA_EXPENDITURE_ORG_ID%TYPE
606 INDEX BY BINARY_INTEGER;
607
608 TYPE PROJECT_ID_T IS TABLE OF
609 MTL_MATERIAL_TRANSACTIONS_TEMP.PROJECT_ID%TYPE
610 INDEX BY BINARY_INTEGER;
611
612 TYPE RESOURCE_ACCOUNT_T IS TABLE OF
613 MTL_MATERIAL_TRANSACTIONS_TEMP.RESOURCE_ACCOUNT%TYPE
614 INDEX BY BINARY_INTEGER;
615
616 TYPE SOURCE_PROJECT_ID_T IS TABLE OF
617 MTL_MATERIAL_TRANSACTIONS_TEMP.SOURCE_PROJECT_ID%TYPE
618 INDEX BY BINARY_INTEGER;
619
620 TYPE SOURCE_TASK_ID_T IS TABLE OF
621 MTL_MATERIAL_TRANSACTIONS_TEMP.SOURCE_TASK_ID%TYPE
622 INDEX BY BINARY_INTEGER;
623
624 TYPE TASK_ID_T IS TABLE OF
625 MTL_MATERIAL_TRANSACTIONS_TEMP.TASK_ID%TYPE
626 INDEX BY BINARY_INTEGER;
627
628 TYPE TO_PROJECT_ID_T IS TABLE OF
629 MTL_MATERIAL_TRANSACTIONS_TEMP.TO_PROJECT_ID%TYPE
630 INDEX BY BINARY_INTEGER;
631
632 TYPE TO_TASK_ID_T IS TABLE OF
633 MTL_MATERIAL_TRANSACTIONS_TEMP.TO_TASK_ID%TYPE
634 INDEX BY BINARY_INTEGER;
635
636 TYPE TRANSACTION_SEQUENCE_ID_T IS TABLE OF
637 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SEQUENCE_ID%TYPE
638 INDEX BY BINARY_INTEGER;
639
640 TYPE TRANSFER_PERCENTAGE_T IS TABLE OF
641 MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_PERCENTAGE%TYPE
642 INDEX BY BINARY_INTEGER;
643
644 TYPE QA_COLLECTION_ID_T IS TABLE OF
645 MTL_MATERIAL_TRANSACTIONS_TEMP.QA_COLLECTION_ID%TYPE
646 INDEX BY BINARY_INTEGER;
647
648 TYPE OVERCOMPLETION_TXN_ID_T IS TABLE OF
649 MTL_MATERIAL_TRANSACTIONS_TEMP.OVERCOMPLETION_TRANSACTION_ID%TYPE
650 INDEX BY BINARY_INTEGER;
651
652 TYPE OVERCOMPLETION_TXN_QTY_T IS TABLE OF
653 MTL_MATERIAL_TRANSACTIONS_TEMP.OVERCOMPLETION_TRANSACTION_QTY%TYPE
654 INDEX BY BINARY_INTEGER;
655
656 TYPE OVERCOMPLETION_PRIMARY_QTY_T IS TABLE OF
657 MTL_MATERIAL_TRANSACTIONS_TEMP.OVERCOMPLETION_PRIMARY_QTY%TYPE
658 INDEX BY BINARY_INTEGER;
659
660 TYPE KANBAN_CARD_ID_T IS TABLE OF
661 MTL_MATERIAL_TRANSACTIONS_TEMP.KANBAN_CARD_ID%TYPE
662 INDEX BY BINARY_INTEGER;
663
664 TYPE MTL_TRANSACTIONS_TEMP_REC IS RECORD (
665 NUMRECS NUMBER,
666 TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID_T,
667 TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID_T,
668 SOURCE_CODE SOURCE_CODE_T,
669 SOURCE_LINE_ID SOURCE_LINE_ID_T,
670 TRANSACTION_MODE TRANSACTION_MODE_T,
671 LOCK_FLAG LOCK_FLAG_T,
672 LAST_UPDATE_DATE LAST_UPDATE_DATE_T,
673 LAST_UPDATED_BY LAST_UPDATED_BY_T,
674 CREATION_DATE CREATION_DATE_T,
675 CREATED_BY CREATED_BY_T,
676 LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_T,
677 REQUEST_ID REQUEST_ID_T,
678 PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID_T,
679 PROGRAM_ID PROGRAM_ID_T,
680 PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE_T,
681 INVENTORY_ITEM_ID INVENTORY_ITEM_ID_T,
682 REVISION REVISION_T,
683 ORGANIZATION_ID ORGANIZATION_ID_T,
684 SUBINVENTORY_CODE SUBINVENTORY_CODE_T,
685 LOCATOR_ID LOCATOR_ID_T,
686 TRANSACTION_QUANTITY TRANSACTION_QUANTITY_T,
687 PRIMARY_QUANTITY PRIMARY_QUANTITY_T,
688 TRANSACTION_UOM TRANSACTION_UOM_T,
689 TRANSACTION_COST TRANSACTION_COST_T,
690 TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID_T,
691 TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID_T,
692 TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID_T,
693 TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID_T,
694 TRANSACTION_SOURCE_NAME TRANSACTION_SOURCE_NAME_T,
695 TRANSACTION_DATE TRANSACTION_DATE_T,
696 ACCT_PERIOD_ID ACCT_PERIOD_ID_T,
697 DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID_T,
698 TRANSACTION_REFERENCE TRANSACTION_REFERENCE_T,
699 REASON_ID REASON_ID_T,
700 LOT_NUMBER LOT_NUMBER_T,
701 LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE_T,
702 SERIAL_NUMBER SERIAL_NUMBER_T,
703 RECEIVING_DOCUMENT RECEIVING_DOCUMENT_T,
704 RCV_TRANSACTION_ID RCV_TRANSACTION_ID_T,
705 MOVE_TRANSACTION_ID MOVE_TRANSACTION_ID_T,
706 COMPLETION_TRANSACTION_ID COMPLETION_TRANSACTION_ID_T,
707 WIP_ENTITY_TYPE WIP_ENTITY_TYPE_T,
708 SCHEDULE_ID SCHEDULE_ID_T,
709 REPETITIVE_LINE_ID REPETITIVE_LINE_ID_T,
710 EMPLOYEE_CODE EMPLOYEE_CODE_T,
711 SCHEDULE_UPDATE_CODE SCHEDULE_UPDATE_CODE_T,
712 SETUP_TEARDOWN_CODE SETUP_TEARDOWN_CODE_T,
713 ITEM_ORDERING ITEM_ORDERING_T,
714 NEGATIVE_REQ_FLAG NEGATIVE_REQ_FLAG_T,
715 OPERATION_SEQ_NUM OPERATION_SEQ_NUM_T,
716 PICKING_LINE_ID PICKING_LINE_ID_T,
717 TRX_SOURCE_LINE_ID TRX_SOURCE_LINE_ID_T,
718 TRX_SOURCE_DELIVERY_ID TRX_SOURCE_DELIVERY_ID_T,
719 PHYSICAL_ADJUSTMENT_ID PHYSICAL_ADJUSTMENT_ID_T,
720 CYCLE_COUNT_ID CYCLE_COUNT_ID_T,
721 RMA_LINE_ID RMA_LINE_ID_T,
722 CUSTOMER_SHIP_ID CUSTOMER_SHIP_ID_T,
723 CURRENCY_CODE CURRENCY_CODE_T,
724 CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE_T,
725 CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE_T,
726 CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE_T,
727 USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE_T,
728 VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER_T,
729 ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT_T,
730 ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT_T,
731 SHIP_TO_LOCATION SHIP_TO_LOCATION_T,
732 SHIPMENT_NUMBER SHIPMENT_NUMBER_T,
733 TRANSFER_COST TRANSFER_COST_T,
734 TRANSPORTATION_COST TRANSPORTATION_COST_T,
735 TRANSPORTATION_ACCOUNT TRANSPORTATION_ACCOUNT_T,
736 FREIGHT_CODE FREIGHT_CODE_T,
737 CONTAINERS CONTAINERS_T,
738 WAYBILL_AIRBILL WAYBILL_AIRBILL_T,
739 EXPECTED_ARRIVAL_DATE EXPECTED_ARRIVAL_DATE_T,
740 TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY_T,
741 TRANSFER_ORGANIZATION TRANSFER_ORGANIZATION_T,
742 TRANSFER_TO_LOCATION TRANSFER_TO_LOCATION_T,
743 NEW_AVERAGE_COST NEW_AVERAGE_COST_T,
744 VALUE_CHANGE VALUE_CHANGE_T,
745 PERCENTAGE_CHANGE PERCENTAGE_CHANGE_T,
746 MATERIAL_ALLOCATION_TEMP_ID MATERIAL_ALLOCATION_TEMP_ID_T,
747 DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID_T,
748 DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE_T,
749 DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY_T,
750 ITEM_SEGMENTS ITEM_SEGMENTS_T,
751 ITEM_DESCRIPTION ITEM_DESCRIPTION_T,
752 ITEM_TRX_ENABLED_FLAG ITEM_TRX_ENABLED_FLAG_T,
753 ITEM_LOCATION_CONTROL_CODE ITEM_LOCATION_CONTROL_CODE_T,
754 ITEM_RESTRICT_SUBINV_CODE ITEM_RESTRICT_SUBINV_CODE_T,
755 ITEM_RESTRICT_LOCATORS_CODE ITEM_RESTRICT_LOCATORS_CODE_T,
756 ITEM_REVISION_QTY_CONTROL_CODE ITEM_REV_QTY_CONTROL_CODE_T,
757 ITEM_PRIMARY_UOM_CODE ITEM_PRIMARY_UOM_CODE_T,
758 ITEM_UOM_CLASS ITEM_UOM_CLASS_T,
759 ITEM_SHELF_LIFE_CODE ITEM_SHELF_LIFE_CODE_T,
760 ITEM_SHELF_LIFE_DAYS ITEM_SHELF_LIFE_DAYS_T,
761 ITEM_LOT_CONTROL_CODE ITEM_LOT_CONTROL_CODE_T,
762 ITEM_SERIAL_CONTROL_CODE ITEM_SERIAL_CONTROL_CODE_T,
763 ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE_T,
764 DEPARTMENT_ID DEPARTMENT_ID_T,
765 WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE_T,
766 SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY_T,
767 SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID_T,
768 VALID_SUBINVENTORY_FLAG VALID_SUBINVENTORY_FLAG_T,
769 VALID_LOCATOR_FLAG VALID_LOCATOR_FLAG_T,
770 LOCATOR_SEGMENTS LOCATOR_SEGMENTS_T,
771 CURRENT_LOCATOR_CONTROL_CODE CURRENT_LOCATOR_CONTROL_CODE_T,
772 NUMBER_OF_LOTS_ENTERED NUMBER_OF_LOTS_ENTERED_T,
773 WIP_COMMIT_FLAG WIP_COMMIT_FLAG_T,
774 NEXT_LOT_NUMBER NEXT_LOT_NUMBER_T,
775 LOT_ALPHA_PREFIX LOT_ALPHA_PREFIX_T,
776 NEXT_SERIAL_NUMBER NEXT_SERIAL_NUMBER_T,
777 SERIAL_ALPHA_PREFIX SERIAL_ALPHA_PREFIX_T,
778 POSTING_FLAG POSTING_FLAG_T,
779 REQUIRED_FLAG REQUIRED_FLAG_T,
780 PROCESS_FLAG PROCESS_FLAG_T,
781 ERROR_CODE ERROR_CODE_T,
782 ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY_T,
783 ATTRIBUTE1 ATTRIBUTE1_T,
784 ATTRIBUTE2 ATTRIBUTE2_T,
785 ATTRIBUTE3 ATTRIBUTE3_T,
786 ATTRIBUTE4 ATTRIBUTE4_T,
787 ATTRIBUTE5 ATTRIBUTE5_T,
788 ATTRIBUTE6 ATTRIBUTE6_T,
789 ATTRIBUTE7 ATTRIBUTE7_T,
790 ATTRIBUTE8 ATTRIBUTE8_T,
791 ATTRIBUTE9 ATTRIBUTE9_T,
792 ATTRIBUTE10 ATTRIBUTE10_T,
793 ATTRIBUTE11 ATTRIBUTE11_T,
794 ATTRIBUTE12 ATTRIBUTE12_T,
795 ATTRIBUTE13 ATTRIBUTE13_T,
796 ATTRIBUTE14 ATTRIBUTE14_T,
797 ATTRIBUTE15 ATTRIBUTE15_T,
798 PRIMARY_SWITCH PRIMARY_SWITCH_T,
799 DEPARTMENT_CODE DEPARTMENT_CODE_T,
800 ERROR_EXPLANATION ERROR_EXPLANATION_T,
801 DEMAND_ID DEMAND_ID_T,
802 ITEM_INVENTORY_ASSET_FLAG ITEM_INVENTORY_ASSET_FLAG_T,
803 SHIPPABLE_FLAG SHIPPABLE_FLAG_T,
804 REQUISITION_LINE_ID REQUISITION_LINE_ID_T,
805 REQUISITION_DISTRIBUTION_ID REQUISITION_DISTRIBUTION_ID_T,
806 MOVEMENT_ID MOVEMENT_ID_T,
807 RESERVATION_QUANTITY RESERVATION_QUANTITY_T,
808 SHIPPED_QUANTITY SHIPPED_QUANTITY_T,
809 TRANSACTION_LINE_NUMBER TRANSACTION_LINE_NUMBER_T,
810 EXPENDITURE_TYPE EXPENDITURE_TYPE_T,
811 FINAL_COMPLETION_FLAG FINAL_COMPLETION_FLAG_T,
812 MATERIAL_ACCOUNT MATERIAL_ACCOUNT_T,
813 MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT_T,
814 OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT_T,
815 OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT_T,
816 PA_EXPENDITURE_ORG_ID PA_EXPENDITURE_ORG_ID_T,
817 PROJECT_ID PROJECT_ID_T,
818 RESOURCE_ACCOUNT RESOURCE_ACCOUNT_T,
819 SOURCE_PROJECT_ID SOURCE_PROJECT_ID_T,
820 SOURCE_TASK_ID SOURCE_TASK_ID_T,
821 TASK_ID TASK_ID_T,
822 TO_PROJECT_ID TO_PROJECT_ID_T,
823 TO_TASK_ID TO_TASK_ID_T,
824 TRANSACTION_SEQUENCE_ID TRANSACTION_SEQUENCE_ID_T,
825 TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE_T,
826 QA_COLLECTION_ID QA_COLLECTION_ID_T,
827 OVERCOMPLETION_TRANSACTION_ID OVERCOMPLETION_TXN_ID_T,
828 OVERCOMPLETION_TRANSACTION_QTY OVERCOMPLETION_TXN_QTY_T,
829 OVERCOMPLETION_PRIMARY_QTY OVERCOMPLETION_PRIMARY_QTY_T,
830 KANBAN_CARD_ID KANBAN_CARD_ID_T
831 );
832
833 procedure fetch_and_delete(
834 p_hdr_id in number,
835 p_act_id in number default NULL,
836 p_materials in out nocopy mtl_transactions_temp_rec,
837 p_lots in out nocopy wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
838 p_serials in out nocopy wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
839 p_dyn_serials in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_rec,
840 p_ser_marks in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_mark_rec);
841
842 procedure insert_rows(
843 p_materials in mtl_transactions_temp_rec,
844 p_lots in wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
845 p_serials in wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
846 p_dyn_serials in wip_serial_number_cleanup.mtl_serial_numbers_rec,
847 p_ser_marks in wip_serial_number_cleanup.mtl_serial_numbers_mark_rec,
848 p_retcode out nocopy number,
849 p_app out nocopy varchar2,
850 p_msg out nocopy varchar2);
851
852 procedure insert_rows(p_mtls in mtl_transactions_temp_rec);
853
854 END WIP_MTL_TXNS_TEMP_CLEANUP;