[Home] [Help]
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,