[Home] [Help]
PACKAGE BODY: APPS.CSP_MTL_TRANSACTIONS_PKG
Source
1 PACKAGE BODY CSP_MTL_TRANSACTIONS_PKG AS
2 /* $Header: csptmmtb.pls 120.0 2005/05/30 05:28:02 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSP_MTL_TRANSACTIONS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_MTL_TRANSACTIONS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptmmtb.pls';
13
14 PROCEDURE Insert_Row(
15 p_TRANSACTION_HEADER_ID NUMBER,
16 px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
17 p_SOURCE_CODE VARCHAR2,
18 p_SOURCE_LINE_ID NUMBER,
19 p_TRANSACTION_MODE NUMBER,
20 p_LOCK_FLAG VARCHAR2,
21 p_LAST_UPDATE_DATE DATE,
22 p_LAST_UPDATED_BY NUMBER,
23 p_CREATION_DATE DATE,
24 p_CREATED_BY NUMBER,
25 p_LAST_UPDATE_LOGIN NUMBER,
26 p_REQUEST_ID NUMBER,
27 p_PROGRAM_APPLICATION_ID NUMBER,
28 p_PROGRAM_ID NUMBER,
29 p_PROGRAM_UPDATE_DATE DATE,
30 p_INVENTORY_ITEM_ID NUMBER,
31 p_REVISION VARCHAR2,
32 p_ORGANIZATION_ID NUMBER,
33 p_SUBINVENTORY_CODE VARCHAR2,
34 p_LOCATOR_ID NUMBER,
35 p_TRANSACTION_QUANTITY NUMBER,
36 p_PRIMARY_QUANTITY NUMBER,
37 p_TRANSACTION_UOM VARCHAR2,
38 p_TRANSACTION_COST NUMBER,
39 p_TRANSACTION_TYPE_ID NUMBER,
40 p_TRANSACTION_ACTION_ID NUMBER,
41 p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
42 p_TRANSACTION_SOURCE_ID NUMBER,
43 p_TRANSACTION_SOURCE_NAME VARCHAR2,
44 p_TRANSACTION_DATE DATE,
45 p_ACCT_PERIOD_ID NUMBER,
46 p_DISTRIBUTION_ACCOUNT_ID NUMBER,
47 p_TRANSACTION_REFERENCE VARCHAR2,
48 p_REQUISITION_LINE_ID NUMBER,
49 p_REQUISITION_DISTRIBUTION_ID NUMBER,
50 p_REASON_ID NUMBER,
51 p_LOT_NUMBER VARCHAR2,
52 p_LOT_EXPIRATION_DATE DATE,
53 p_SERIAL_NUMBER VARCHAR2,
54 p_RECEIVING_DOCUMENT VARCHAR2,
55 p_DEMAND_ID NUMBER,
56 p_RCV_TRANSACTION_ID NUMBER,
57 p_MOVE_TRANSACTION_ID NUMBER,
58 p_COMPLETION_TRANSACTION_ID NUMBER,
59 p_WIP_ENTITY_TYPE NUMBER,
60 p_SCHEDULE_ID NUMBER,
61 p_REPETITIVE_LINE_ID NUMBER,
62 p_EMPLOYEE_CODE VARCHAR2,
63 p_PRIMARY_SWITCH NUMBER,
64 p_SCHEDULE_UPDATE_CODE NUMBER,
65 p_SETUP_TEARDOWN_CODE NUMBER,
66 p_ITEM_ORDERING NUMBER,
67 p_NEGATIVE_REQ_FLAG NUMBER,
68 p_OPERATION_SEQ_NUM NUMBER,
69 p_PICKING_LINE_ID NUMBER,
70 p_TRX_SOURCE_LINE_ID NUMBER,
71 p_TRX_SOURCE_DELIVERY_ID NUMBER,
72 p_PHYSICAL_ADJUSTMENT_ID NUMBER,
73 p_CYCLE_COUNT_ID NUMBER,
74 p_RMA_LINE_ID NUMBER,
75 p_CUSTOMER_SHIP_ID NUMBER,
76 p_CURRENCY_CODE VARCHAR2,
77 p_CURRENCY_CONVERSION_RATE NUMBER,
78 p_CURRENCY_CONVERSION_TYPE VARCHAR2,
79 p_CURRENCY_CONVERSION_DATE DATE,
80 p_USSGL_TRANSACTION_CODE VARCHAR2,
81 p_VENDOR_LOT_NUMBER VARCHAR2,
82 p_ENCUMBRANCE_ACCOUNT NUMBER,
83 p_ENCUMBRANCE_AMOUNT NUMBER,
84 p_SHIP_TO_LOCATION NUMBER,
85 p_SHIPMENT_NUMBER VARCHAR2,
86 p_TRANSFER_COST NUMBER,
87 p_TRANSPORTATION_COST NUMBER,
88 p_TRANSPORTATION_ACCOUNT NUMBER,
89 p_FREIGHT_CODE VARCHAR2,
90 p_CONTAINERS NUMBER,
91 p_WAYBILL_AIRBILL VARCHAR2,
92 p_EXPECTED_ARRIVAL_DATE DATE,
93 p_TRANSFER_SUBINVENTORY VARCHAR2,
94 p_TRANSFER_ORGANIZATION NUMBER,
95 p_TRANSFER_TO_LOCATION NUMBER,
96 p_NEW_AVERAGE_COST NUMBER,
97 p_VALUE_CHANGE NUMBER,
98 p_PERCENTAGE_CHANGE NUMBER,
99 p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
100 p_DEMAND_SOURCE_HEADER_ID NUMBER,
101 p_DEMAND_SOURCE_LINE VARCHAR2,
102 p_DEMAND_SOURCE_DELIVERY VARCHAR2,
103 p_ITEM_SEGMENTS VARCHAR2,
104 p_ITEM_DESCRIPTION VARCHAR2,
105 p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
106 p_ITEM_LOCATION_CONTROL_CODE NUMBER,
107 p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
108 p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
109 p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
110 p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
111 p_ITEM_UOM_CLASS VARCHAR2,
112 p_ITEM_SHELF_LIFE_CODE NUMBER,
113 p_ITEM_SHELF_LIFE_DAYS NUMBER,
114 p_ITEM_LOT_CONTROL_CODE NUMBER,
115 p_ITEM_SERIAL_CONTROL_CODE NUMBER,
116 p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
117 p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
118 p_DEPARTMENT_ID NUMBER,
119 p_DEPARTMENT_CODE VARCHAR2,
120 p_WIP_SUPPLY_TYPE NUMBER,
121 p_SUPPLY_SUBINVENTORY VARCHAR2,
122 p_SUPPLY_LOCATOR_ID NUMBER,
123 p_VALID_SUBINVENTORY_FLAG VARCHAR2,
124 p_VALID_LOCATOR_FLAG VARCHAR2,
125 p_LOCATOR_SEGMENTS VARCHAR2,
126 p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
127 p_NUMBER_OF_LOTS_ENTERED NUMBER,
128 p_WIP_COMMIT_FLAG VARCHAR2,
129 p_NEXT_LOT_NUMBER VARCHAR2,
130 p_LOT_ALPHA_PREFIX VARCHAR2,
131 p_NEXT_SERIAL_NUMBER VARCHAR2,
132 p_SERIAL_ALPHA_PREFIX VARCHAR2,
133 p_SHIPPABLE_FLAG VARCHAR2,
134 p_POSTING_FLAG VARCHAR2,
135 p_REQUIRED_FLAG VARCHAR2,
136 p_PROCESS_FLAG VARCHAR2,
137 p_ERROR_CODE VARCHAR2,
138 p_ERROR_EXPLANATION VARCHAR2,
139 p_ATTRIBUTE_CATEGORY VARCHAR2,
140 p_ATTRIBUTE1 VARCHAR2,
141 p_ATTRIBUTE2 VARCHAR2,
142 p_ATTRIBUTE3 VARCHAR2,
143 p_ATTRIBUTE4 VARCHAR2,
144 p_ATTRIBUTE5 VARCHAR2,
145 p_ATTRIBUTE6 VARCHAR2,
146 p_ATTRIBUTE7 VARCHAR2,
147 p_ATTRIBUTE8 VARCHAR2,
148 p_ATTRIBUTE9 VARCHAR2,
149 p_ATTRIBUTE10 VARCHAR2,
150 p_ATTRIBUTE11 VARCHAR2,
151 p_ATTRIBUTE12 VARCHAR2,
152 p_ATTRIBUTE13 VARCHAR2,
153 p_ATTRIBUTE14 VARCHAR2,
154 p_ATTRIBUTE15 VARCHAR2,
155 p_MOVEMENT_ID NUMBER,
156 p_RESERVATION_QUANTITY NUMBER,
157 p_SHIPPED_QUANTITY NUMBER,
158 p_TRANSACTION_LINE_NUMBER NUMBER,
159 p_TASK_ID NUMBER,
160 p_TO_TASK_ID NUMBER,
161 p_SOURCE_TASK_ID NUMBER,
162 p_PROJECT_ID NUMBER,
163 p_SOURCE_PROJECT_ID NUMBER,
164 p_PA_EXPENDITURE_ORG_ID NUMBER,
165 p_TO_PROJECT_ID NUMBER,
166 p_EXPENDITURE_TYPE VARCHAR2,
167 p_FINAL_COMPLETION_FLAG VARCHAR2,
168 p_TRANSFER_PERCENTAGE NUMBER,
169 p_TRANSACTION_SEQUENCE_ID NUMBER,
170 p_MATERIAL_ACCOUNT NUMBER,
171 p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
172 p_RESOURCE_ACCOUNT NUMBER,
173 p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
174 p_OVERHEAD_ACCOUNT NUMBER,
175 p_FLOW_SCHEDULE VARCHAR2,
176 p_COST_GROUP_ID NUMBER,
177 p_DEMAND_CLASS VARCHAR2,
178 p_QA_COLLECTION_ID NUMBER,
179 p_KANBAN_CARD_ID NUMBER,
180 p_OVERCOMPLETION_TXN_ID NUMBER,
181 p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
182 p_OVERCOMPLETION_TXN_QTY NUMBER,
183 --p_PROCESS_TYPE NUMBER,
184 p_END_ITEM_UNIT_NUMBER VARCHAR2,
185 p_SCHEDULED_PAYBACK_DATE DATE,
186 p_LINE_TYPE_CODE NUMBER,
187 p_PARENT_TRANSACTION_TEMP_ID NUMBER,
188 p_PUT_AWAY_STRATEGY_ID NUMBER,
189 p_PUT_AWAY_RULE_ID NUMBER,
190 p_PICK_STRATEGY_ID NUMBER,
191 p_PICK_RULE_ID NUMBER,
192 p_COMMON_BOM_SEQ_ID NUMBER,
193 p_COMMON_ROUTING_SEQ_ID NUMBER,
194 p_COST_TYPE_ID NUMBER,
195 p_ORG_COST_GROUP_ID NUMBER,
196 p_MOVE_ORDER_LINE_ID NUMBER,
197 p_TASK_GROUP_ID NUMBER,
198 p_PICK_SLIP_NUMBER NUMBER,
199 p_RESERVATION_ID NUMBER,
200 p_TRANSACTION_STATUS NUMBER,
201 p_STANDARD_OPERATION_ID NUMBER,
202 p_TASK_PRIORITY NUMBER,
203 p_WMS_TASK_TYPE NUMBER,
204 p_PARENT_LINE_ID NUMBER)
205 -- P_SOURCE_LOT_NUMBER NUMBER)
206
207 IS
208 CURSOR C2 IS SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM sys.dual;
209 BEGIN
210 If (px_TRANSACTION_TEMP_ID IS NULL) OR (px_TRANSACTION_TEMP_ID = FND_API.G_MISS_NUM) then
211 OPEN C2;
212 FETCH C2 INTO px_TRANSACTION_TEMP_ID;
213 CLOSE C2;
214 End If;
215 INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP(
216 TRANSACTION_HEADER_ID,
217 TRANSACTION_TEMP_ID,
218 SOURCE_CODE,
219 SOURCE_LINE_ID,
220 TRANSACTION_MODE,
221 LOCK_FLAG,
222 LAST_UPDATE_DATE,
223 LAST_UPDATED_BY,
224 CREATION_DATE,
225 CREATED_BY,
226 LAST_UPDATE_LOGIN,
227 REQUEST_ID,
228 PROGRAM_APPLICATION_ID,
229 PROGRAM_ID,
230 PROGRAM_UPDATE_DATE,
231 INVENTORY_ITEM_ID,
232 REVISION,
233 ORGANIZATION_ID,
234 SUBINVENTORY_CODE,
235 LOCATOR_ID,
236 TRANSACTION_QUANTITY,
237 PRIMARY_QUANTITY,
238 TRANSACTION_UOM,
239 TRANSACTION_COST,
240 TRANSACTION_TYPE_ID,
241 TRANSACTION_ACTION_ID,
242 TRANSACTION_SOURCE_TYPE_ID,
243 TRANSACTION_SOURCE_ID,
244 TRANSACTION_SOURCE_NAME,
245 TRANSACTION_DATE,
246 ACCT_PERIOD_ID,
247 DISTRIBUTION_ACCOUNT_ID,
248 TRANSACTION_REFERENCE,
249 REQUISITION_LINE_ID,
250 REQUISITION_DISTRIBUTION_ID,
251 REASON_ID,
252 LOT_NUMBER,
253 LOT_EXPIRATION_DATE,
254 SERIAL_NUMBER,
255 RECEIVING_DOCUMENT,
256 DEMAND_ID,
257 RCV_TRANSACTION_ID,
258 MOVE_TRANSACTION_ID,
259 COMPLETION_TRANSACTION_ID,
260 WIP_ENTITY_TYPE,
261 SCHEDULE_ID,
262 REPETITIVE_LINE_ID,
263 EMPLOYEE_CODE,
264 PRIMARY_SWITCH,
265 SCHEDULE_UPDATE_CODE,
266 SETUP_TEARDOWN_CODE,
267 ITEM_ORDERING,
268 NEGATIVE_REQ_FLAG,
269 OPERATION_SEQ_NUM,
270 PICKING_LINE_ID,
271 TRX_SOURCE_LINE_ID,
272 TRX_SOURCE_DELIVERY_ID,
273 PHYSICAL_ADJUSTMENT_ID,
274 CYCLE_COUNT_ID,
275 RMA_LINE_ID,
276 CUSTOMER_SHIP_ID,
277 CURRENCY_CODE,
278 CURRENCY_CONVERSION_RATE,
279 CURRENCY_CONVERSION_TYPE,
280 CURRENCY_CONVERSION_DATE,
281 USSGL_TRANSACTION_CODE,
282 VENDOR_LOT_NUMBER,
283 ENCUMBRANCE_ACCOUNT,
284 ENCUMBRANCE_AMOUNT,
285 SHIP_TO_LOCATION,
286 SHIPMENT_NUMBER,
287 TRANSFER_COST,
288 TRANSPORTATION_COST,
289 TRANSPORTATION_ACCOUNT,
290 FREIGHT_CODE,
291 CONTAINERS,
292 WAYBILL_AIRBILL,
293 EXPECTED_ARRIVAL_DATE,
294 TRANSFER_SUBINVENTORY,
295 TRANSFER_ORGANIZATION,
296 TRANSFER_TO_LOCATION,
297 NEW_AVERAGE_COST,
298 VALUE_CHANGE,
299 PERCENTAGE_CHANGE,
300 MATERIAL_ALLOCATION_TEMP_ID,
301 DEMAND_SOURCE_HEADER_ID,
302 DEMAND_SOURCE_LINE,
303 DEMAND_SOURCE_DELIVERY,
304 ITEM_SEGMENTS,
305 ITEM_DESCRIPTION,
306 ITEM_TRX_ENABLED_FLAG,
307 ITEM_LOCATION_CONTROL_CODE,
308 ITEM_RESTRICT_SUBINV_CODE,
309 ITEM_RESTRICT_LOCATORS_CODE,
310 ITEM_REVISION_QTY_CONTROL_CODE,
311 ITEM_PRIMARY_UOM_CODE,
312 ITEM_UOM_CLASS,
313 ITEM_SHELF_LIFE_CODE,
314 ITEM_SHELF_LIFE_DAYS,
315 ITEM_LOT_CONTROL_CODE,
316 ITEM_SERIAL_CONTROL_CODE,
317 ITEM_INVENTORY_ASSET_FLAG,
318 ALLOWED_UNITS_LOOKUP_CODE,
319 DEPARTMENT_ID,
320 DEPARTMENT_CODE,
321 WIP_SUPPLY_TYPE,
322 SUPPLY_SUBINVENTORY,
323 SUPPLY_LOCATOR_ID,
324 VALID_SUBINVENTORY_FLAG,
325 VALID_LOCATOR_FLAG,
326 LOCATOR_SEGMENTS,
327 CURRENT_LOCATOR_CONTROL_CODE,
328 NUMBER_OF_LOTS_ENTERED,
329 WIP_COMMIT_FLAG,
330 NEXT_LOT_NUMBER,
331 LOT_ALPHA_PREFIX,
332 NEXT_SERIAL_NUMBER,
333 SERIAL_ALPHA_PREFIX,
334 SHIPPABLE_FLAG,
335 POSTING_FLAG,
336 REQUIRED_FLAG,
337 PROCESS_FLAG,
338 ERROR_CODE,
339 ERROR_EXPLANATION,
340 ATTRIBUTE_CATEGORY,
341 ATTRIBUTE1,
342 ATTRIBUTE2,
343 ATTRIBUTE3,
344 ATTRIBUTE4,
345 ATTRIBUTE5,
346 ATTRIBUTE6,
347 ATTRIBUTE7,
348 ATTRIBUTE8,
349 ATTRIBUTE9,
350 ATTRIBUTE10,
351 ATTRIBUTE11,
352 ATTRIBUTE12,
353 ATTRIBUTE13,
354 ATTRIBUTE14,
355 ATTRIBUTE15,
356 MOVEMENT_ID,
357 RESERVATION_QUANTITY,
358 SHIPPED_QUANTITY,
362 SOURCE_TASK_ID,
359 TRANSACTION_LINE_NUMBER,
360 TASK_ID,
361 TO_TASK_ID,
363 PROJECT_ID,
364 SOURCE_PROJECT_ID,
365 PA_EXPENDITURE_ORG_ID,
366 TO_PROJECT_ID,
367 EXPENDITURE_TYPE,
368 FINAL_COMPLETION_FLAG,
369 TRANSFER_PERCENTAGE,
370 TRANSACTION_SEQUENCE_ID,
371 MATERIAL_ACCOUNT,
372 MATERIAL_OVERHEAD_ACCOUNT,
373 RESOURCE_ACCOUNT,
374 OUTSIDE_PROCESSING_ACCOUNT,
375 OVERHEAD_ACCOUNT,
376 FLOW_SCHEDULE,
377 COST_GROUP_ID,
378 DEMAND_CLASS,
379 QA_COLLECTION_ID,
380 KANBAN_CARD_ID,
381 OVERCOMPLETION_TRANSACTION_ID,
382 OVERCOMPLETION_PRIMARY_QTY,
383 OVERCOMPLETION_TRANSACTION_QTY,
384 --PROCESS_TYPE,
385 END_ITEM_UNIT_NUMBER,
386 SCHEDULED_PAYBACK_DATE,
387 LINE_TYPE_CODE,
388 PARENT_TRANSACTION_TEMP_ID,
389 PUT_AWAY_STRATEGY_ID,
390 PUT_AWAY_RULE_ID,
391 PICK_STRATEGY_ID,
392 PICK_RULE_ID,
393 COMMON_BOM_SEQ_ID,
394 COMMON_ROUTING_SEQ_ID,
395 COST_TYPE_ID,
396 ORG_COST_GROUP_ID,
397 MOVE_ORDER_LINE_ID,
398 TASK_GROUP_ID,
399 PICK_SLIP_NUMBER,
400 RESERVATION_ID,
401 TRANSACTION_STATUS,
402 STANDARD_OPERATION_ID,
403 TASK_PRIORITY,
404 WMS_TASK_TYPE,
405 PARENT_LINE_ID
406 --SOURCE_LOT_NUMBER
407 ) VALUES (
408 decode( p_TRANSACTION_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_HEADER_ID),
409 px_TRANSACTION_TEMP_ID,
410 decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE),
411 decode( p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID),
412 decode( p_TRANSACTION_MODE, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_MODE),
413 decode( p_LOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_LOCK_FLAG),
414 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_CHAR, to_date(NULL), p_last_update_date),
415 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
416 decode( p_creation_date, FND_API.G_MISS_CHAR, to_date(NULL), p_creation_date),
417 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
418 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
419 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
420 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
421 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
422 decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_PROGRAM_UPDATE_DATE),
423 decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
424 decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
425 decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
426 decode( p_SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, p_SUBINVENTORY_CODE),
427 decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID),
428 decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY),
429 decode( p_PRIMARY_QUANTITY, FND_API.G_MISS_NUM, NULL, p_PRIMARY_QUANTITY),
430 decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM),
431 decode( p_TRANSACTION_COST, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_COST),
432 decode( p_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_TYPE_ID),
433 decode( p_TRANSACTION_ACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ACTION_ID),
434 decode( p_TRANSACTION_SOURCE_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SOURCE_TYPE_ID),
435 decode( p_TRANSACTION_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SOURCE_ID),
436 decode( p_TRANSACTION_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_SOURCE_NAME),
437 decode( p_TRANSACTION_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_TRANSACTION_DATE),
438 decode( p_ACCT_PERIOD_ID, FND_API.G_MISS_NUM, NULL, p_ACCT_PERIOD_ID),
439 decode( p_DISTRIBUTION_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_DISTRIBUTION_ACCOUNT_ID),
440 decode( p_TRANSACTION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_REFERENCE),
441 decode( p_REQUISITION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REQUISITION_LINE_ID),
442 decode( p_REQUISITION_DISTRIBUTION_ID, FND_API.G_MISS_NUM, NULL, p_REQUISITION_DISTRIBUTION_ID),
443 decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID),
444 decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
445 decode( p_LOT_EXPIRATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_LOT_EXPIRATION_DATE),
446 decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
447 decode( p_RECEIVING_DOCUMENT, FND_API.G_MISS_CHAR, NULL, p_RECEIVING_DOCUMENT),
448 decode( p_DEMAND_ID, FND_API.G_MISS_NUM, NULL, p_DEMAND_ID),
449 decode( p_RCV_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_RCV_TRANSACTION_ID),
450 decode( p_MOVE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_MOVE_TRANSACTION_ID),
451 decode( p_COMPLETION_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_COMPLETION_TRANSACTION_ID),
452 decode( p_WIP_ENTITY_TYPE, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_TYPE),
453 decode( p_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULE_ID),
454 decode( p_REPETITIVE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPETITIVE_LINE_ID),
455 decode( p_EMPLOYEE_CODE, FND_API.G_MISS_CHAR, NULL, p_EMPLOYEE_CODE),
456 decode( p_PRIMARY_SWITCH, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SWITCH),
460 decode( p_NEGATIVE_REQ_FLAG, FND_API.G_MISS_NUM, NULL, p_NEGATIVE_REQ_FLAG),
457 decode( p_SCHEDULE_UPDATE_CODE, FND_API.G_MISS_NUM, NULL, p_SCHEDULE_UPDATE_CODE),
458 decode( p_SETUP_TEARDOWN_CODE, FND_API.G_MISS_NUM, NULL, p_SETUP_TEARDOWN_CODE),
459 decode( p_ITEM_ORDERING, FND_API.G_MISS_NUM, NULL, p_ITEM_ORDERING),
461 decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM),
462 decode( p_PICKING_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PICKING_LINE_ID),
463 decode( p_TRX_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRX_SOURCE_LINE_ID),
464 decode( p_TRX_SOURCE_DELIVERY_ID, FND_API.G_MISS_NUM, NULL, p_TRX_SOURCE_DELIVERY_ID),
465 decode( p_PHYSICAL_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL, p_PHYSICAL_ADJUSTMENT_ID),
466 decode( p_CYCLE_COUNT_ID, FND_API.G_MISS_NUM, NULL, p_CYCLE_COUNT_ID),
467 decode( p_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_RMA_LINE_ID),
468 decode( p_CUSTOMER_SHIP_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SHIP_ID),
469 decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
470 decode( p_CURRENCY_CONVERSION_RATE, FND_API.G_MISS_NUM, NULL, p_CURRENCY_CONVERSION_RATE),
471 decode( p_CURRENCY_CONVERSION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CONVERSION_TYPE),
472 decode( p_CURRENCY_CONVERSION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CURRENCY_CONVERSION_DATE),
473 decode( p_USSGL_TRANSACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_USSGL_TRANSACTION_CODE),
474 decode( p_VENDOR_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_VENDOR_LOT_NUMBER),
475 decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
476 decode( p_ENCUMBRANCE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_AMOUNT),
477 decode( p_SHIP_TO_LOCATION, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_LOCATION),
478 decode( p_SHIPMENT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_NUMBER),
479 decode( p_TRANSFER_COST, FND_API.G_MISS_NUM, NULL, p_TRANSFER_COST),
480 decode( p_TRANSPORTATION_COST, FND_API.G_MISS_NUM, NULL, p_TRANSPORTATION_COST),
481 decode( p_TRANSPORTATION_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_TRANSPORTATION_ACCOUNT),
482 decode( p_FREIGHT_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CODE),
483 decode( p_CONTAINERS, FND_API.G_MISS_NUM, NULL, p_CONTAINERS),
484 decode( p_WAYBILL_AIRBILL, FND_API.G_MISS_CHAR, NULL, p_WAYBILL_AIRBILL),
485 decode( p_EXPECTED_ARRIVAL_DATE, FND_API.G_MISS_DATE, to_date(null), p_EXPECTED_ARRIVAL_DATE),
486 decode( p_TRANSFER_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_SUBINVENTORY),
487 decode( p_TRANSFER_ORGANIZATION, FND_API.G_MISS_NUM, NULL, p_TRANSFER_ORGANIZATION),
488 decode( p_TRANSFER_TO_LOCATION, FND_API.G_MISS_NUM, NULL, p_TRANSFER_TO_LOCATION),
489 decode( p_NEW_AVERAGE_COST, FND_API.G_MISS_NUM, NULL, p_NEW_AVERAGE_COST),
490 decode( p_VALUE_CHANGE, FND_API.G_MISS_NUM, NULL, p_VALUE_CHANGE),
491 decode( p_PERCENTAGE_CHANGE, FND_API.G_MISS_NUM, NULL, p_PERCENTAGE_CHANGE),
492 decode( p_MATERIAL_ALLOCATION_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_MATERIAL_ALLOCATION_TEMP_ID),
493 decode( p_DEMAND_SOURCE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DEMAND_SOURCE_HEADER_ID),
494 decode( p_DEMAND_SOURCE_LINE, FND_API.G_MISS_CHAR, NULL, p_DEMAND_SOURCE_LINE),
495 decode( p_DEMAND_SOURCE_DELIVERY, FND_API.G_MISS_CHAR, NULL, p_DEMAND_SOURCE_DELIVERY),
496 decode( p_ITEM_SEGMENTS, FND_API.G_MISS_CHAR, NULL, p_ITEM_SEGMENTS),
497 decode( p_ITEM_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_ITEM_DESCRIPTION),
498 decode( p_ITEM_TRX_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ITEM_TRX_ENABLED_FLAG),
499 decode( p_ITEM_LOCATION_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_LOCATION_CONTROL_CODE),
500 decode( p_ITEM_RESTRICT_SUBINV_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_RESTRICT_SUBINV_CODE),
501 decode( p_ITEM_RESTRICT_LOCATORS_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_RESTRICT_LOCATORS_CODE),
502 decode( p_ITEM_REV_QTY_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_REV_QTY_CONTROL_CODE),
503 decode( p_ITEM_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_ITEM_PRIMARY_UOM_CODE),
504 decode( p_ITEM_UOM_CLASS, FND_API.G_MISS_CHAR, NULL, p_ITEM_UOM_CLASS),
505 decode( p_ITEM_SHELF_LIFE_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_SHELF_LIFE_CODE),
506 decode( p_ITEM_SHELF_LIFE_DAYS, FND_API.G_MISS_NUM, NULL, p_ITEM_SHELF_LIFE_DAYS),
507 decode( p_ITEM_LOT_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_LOT_CONTROL_CODE),
508 decode( p_ITEM_SERIAL_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_SERIAL_CONTROL_CODE),
509 decode( p_ITEM_INVENTORY_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_ITEM_INVENTORY_ASSET_FLAG),
510 decode( p_ALLOWED_UNITS_LOOKUP_CODE, FND_API.G_MISS_NUM, NULL, p_ALLOWED_UNITS_LOOKUP_CODE),
511 decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID),
512 decode( p_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, p_DEPARTMENT_CODE),
513 decode( p_WIP_SUPPLY_TYPE, FND_API.G_MISS_NUM, NULL, p_WIP_SUPPLY_TYPE),
514 decode( p_SUPPLY_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUPPLY_SUBINVENTORY),
515 decode( p_SUPPLY_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_SUPPLY_LOCATOR_ID),
516 decode( p_VALID_SUBINVENTORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_SUBINVENTORY_FLAG),
517 decode( p_VALID_LOCATOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_LOCATOR_FLAG),
518 decode( p_LOCATOR_SEGMENTS, FND_API.G_MISS_CHAR, NULL, p_LOCATOR_SEGMENTS),
519 decode( p_CURRENT_LOCATOR_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_CURRENT_LOCATOR_CONTROL_CODE),
520 decode( p_NUMBER_OF_LOTS_ENTERED, FND_API.G_MISS_NUM, NULL, p_NUMBER_OF_LOTS_ENTERED),
521 decode( p_WIP_COMMIT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WIP_COMMIT_FLAG),
522 decode( p_NEXT_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEXT_LOT_NUMBER),
523 decode( p_LOT_ALPHA_PREFIX, FND_API.G_MISS_CHAR, NULL, p_LOT_ALPHA_PREFIX),
524 decode( p_NEXT_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEXT_SERIAL_NUMBER),
528 decode( p_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_REQUIRED_FLAG),
525 decode( p_SERIAL_ALPHA_PREFIX, FND_API.G_MISS_CHAR, NULL, p_SERIAL_ALPHA_PREFIX),
526 decode( p_SHIPPABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIPPABLE_FLAG),
527 decode( p_POSTING_FLAG, FND_API.G_MISS_CHAR, NULL, p_POSTING_FLAG),
529 decode( p_PROCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_PROCESS_FLAG),
530 decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
531 decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
532 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
533 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
534 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
535 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
536 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
537 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
538 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
539 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
540 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
541 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
542 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
543 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
544 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
545 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
546 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
547 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
548 decode( p_MOVEMENT_ID, FND_API.G_MISS_NUM, NULL, p_MOVEMENT_ID),
549 decode( p_RESERVATION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RESERVATION_QUANTITY),
550 decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY),
551 decode( p_TRANSACTION_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_NUMBER),
552 decode( p_TASK_ID, FND_API.G_MISS_NUM, NULL, p_TASK_ID),
553 decode( p_TO_TASK_ID, FND_API.G_MISS_NUM, NULL, p_TO_TASK_ID),
554 decode( p_SOURCE_TASK_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TASK_ID),
555 decode( p_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PROJECT_ID),
556 decode( p_SOURCE_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROJECT_ID),
557 decode( p_PA_EXPENDITURE_ORG_ID, FND_API.G_MISS_NUM, NULL, p_PA_EXPENDITURE_ORG_ID),
558 decode( p_TO_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_TO_PROJECT_ID),
559 decode( p_EXPENDITURE_TYPE, FND_API.G_MISS_CHAR, NULL, p_EXPENDITURE_TYPE),
560 decode( p_FINAL_COMPLETION_FLAG, FND_API.G_MISS_CHAR, NULL, p_FINAL_COMPLETION_FLAG),
561 decode( p_TRANSFER_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_TRANSFER_PERCENTAGE),
562 decode( p_TRANSACTION_SEQUENCE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SEQUENCE_ID),
563 decode( p_MATERIAL_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_MATERIAL_ACCOUNT),
564 decode( p_MATERIAL_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_MATERIAL_OVERHEAD_ACCOUNT),
565 decode( p_RESOURCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ACCOUNT),
566 decode( p_OUTSIDE_PROCESSING_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_OUTSIDE_PROCESSING_ACCOUNT),
567 decode( p_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_OVERHEAD_ACCOUNT),
568 decode( p_FLOW_SCHEDULE, FND_API.G_MISS_CHAR, NULL, p_FLOW_SCHEDULE),
569 decode( p_COST_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_COST_GROUP_ID),
570 decode( p_DEMAND_CLASS, FND_API.G_MISS_CHAR, NULL, p_DEMAND_CLASS),
571 decode( p_QA_COLLECTION_ID, FND_API.G_MISS_NUM, NULL, p_QA_COLLECTION_ID),
572 decode( p_KANBAN_CARD_ID, FND_API.G_MISS_NUM, NULL, p_KANBAN_CARD_ID),
573 decode( p_OVERCOMPLETION_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERCOMPLETION_TXN_ID),
574 decode( p_OVERCOMPLETION_PRIMARY_QTY, FND_API.G_MISS_NUM, NULL, p_OVERCOMPLETION_PRIMARY_QTY),
575 decode( p_OVERCOMPLETION_TXN_QTY, FND_API.G_MISS_NUM, NULL, p_OVERCOMPLETION_TXN_QTY),
576 --decode( p_PROCESS_TYPE, FND_API.G_MISS_NUM, NULL, p_PROCESS_TYPE),
577 decode( p_END_ITEM_UNIT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_END_ITEM_UNIT_NUMBER),
578 decode( p_SCHEDULED_PAYBACK_DATE, FND_API.G_MISS_DATE, to_date(null), p_SCHEDULED_PAYBACK_DATE),
579 decode( p_LINE_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_LINE_TYPE_CODE),
580 decode( p_PARENT_TRANSACTION_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TRANSACTION_TEMP_ID),
581 decode( p_PUT_AWAY_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_PUT_AWAY_STRATEGY_ID),
582 decode( p_PUT_AWAY_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PUT_AWAY_RULE_ID),
583 decode( p_PICK_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_PICK_STRATEGY_ID),
584 decode( p_PICK_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PICK_RULE_ID),
585 decode( p_COMMON_BOM_SEQ_ID, FND_API.G_MISS_NUM, NULL, p_COMMON_BOM_SEQ_ID),
586 decode( p_COMMON_ROUTING_SEQ_ID, FND_API.G_MISS_NUM, NULL, p_COMMON_ROUTING_SEQ_ID),
587 decode( p_COST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_COST_TYPE_ID),
588 decode( p_ORG_COST_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_ORG_COST_GROUP_ID),
589 decode( p_MOVE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_MOVE_ORDER_LINE_ID),
590 decode( p_TASK_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_TASK_GROUP_ID),
591 decode( p_PICK_SLIP_NUMBER, FND_API.G_MISS_NUM, NULL, p_PICK_SLIP_NUMBER),
592 decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
593 decode( p_TRANSACTION_STATUS, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_STATUS),
594 decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID),
595 decode( p_TASK_PRIORITY, FND_API.G_MISS_NUM, NULL, p_TASK_PRIORITY),
596 decode( p_WMS_TASK_TYPE, FND_API.G_MISS_NUM, NULL, p_WMS_TASK_TYPE),
600 End Insert_Row;
597 decode( p_PARENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_LINE_ID)
598 -- decode( P_SOURCE_LOT_NUMBER, FND_API.G_MISS_NUM, NULL, p_SOURCE_LOT_NUMBER)
599 );
601
602 PROCEDURE Update_Row(
603 p_TRANSACTION_HEADER_ID NUMBER,
604 p_TRANSACTION_TEMP_ID NUMBER,
605 p_SOURCE_CODE VARCHAR2,
606 p_SOURCE_LINE_ID NUMBER,
607 p_TRANSACTION_MODE NUMBER,
608 p_LOCK_FLAG VARCHAR2,
609 p_LAST_UPDATE_DATE DATE,
610 p_LAST_UPDATED_BY NUMBER,
611 p_CREATION_DATE DATE,
612 p_CREATED_BY NUMBER,
613 p_LAST_UPDATE_LOGIN NUMBER,
614 p_REQUEST_ID NUMBER,
615 p_PROGRAM_APPLICATION_ID NUMBER,
616 p_PROGRAM_ID NUMBER,
617 p_PROGRAM_UPDATE_DATE DATE,
618 p_INVENTORY_ITEM_ID NUMBER,
619 p_REVISION VARCHAR2,
620 p_ORGANIZATION_ID NUMBER,
621 p_SUBINVENTORY_CODE VARCHAR2,
622 p_LOCATOR_ID NUMBER,
623 p_TRANSACTION_QUANTITY NUMBER,
624 p_PRIMARY_QUANTITY NUMBER,
625 p_TRANSACTION_UOM VARCHAR2,
626 p_TRANSACTION_COST NUMBER,
627 p_TRANSACTION_TYPE_ID NUMBER,
628 p_TRANSACTION_ACTION_ID NUMBER,
629 p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
630 p_TRANSACTION_SOURCE_ID NUMBER,
631 p_TRANSACTION_SOURCE_NAME VARCHAR2,
632 p_TRANSACTION_DATE DATE,
633 p_ACCT_PERIOD_ID NUMBER,
634 p_DISTRIBUTION_ACCOUNT_ID NUMBER,
635 p_TRANSACTION_REFERENCE VARCHAR2,
636 p_REQUISITION_LINE_ID NUMBER,
637 p_REQUISITION_DISTRIBUTION_ID NUMBER,
638 p_REASON_ID NUMBER,
639 p_LOT_NUMBER VARCHAR2,
640 p_LOT_EXPIRATION_DATE DATE,
641 p_SERIAL_NUMBER VARCHAR2,
642 p_RECEIVING_DOCUMENT VARCHAR2,
643 p_DEMAND_ID NUMBER,
644 p_RCV_TRANSACTION_ID NUMBER,
645 p_MOVE_TRANSACTION_ID NUMBER,
646 p_COMPLETION_TRANSACTION_ID NUMBER,
647 p_WIP_ENTITY_TYPE NUMBER,
648 p_SCHEDULE_ID NUMBER,
649 p_REPETITIVE_LINE_ID NUMBER,
650 p_EMPLOYEE_CODE VARCHAR2,
651 p_PRIMARY_SWITCH NUMBER,
652 p_SCHEDULE_UPDATE_CODE NUMBER,
653 p_SETUP_TEARDOWN_CODE NUMBER,
654 p_ITEM_ORDERING NUMBER,
655 p_NEGATIVE_REQ_FLAG NUMBER,
656 p_OPERATION_SEQ_NUM NUMBER,
657 p_PICKING_LINE_ID NUMBER,
658 p_TRX_SOURCE_LINE_ID NUMBER,
659 p_TRX_SOURCE_DELIVERY_ID NUMBER,
660 p_PHYSICAL_ADJUSTMENT_ID NUMBER,
661 p_CYCLE_COUNT_ID NUMBER,
662 p_RMA_LINE_ID NUMBER,
663 p_CUSTOMER_SHIP_ID NUMBER,
664 p_CURRENCY_CODE VARCHAR2,
665 p_CURRENCY_CONVERSION_RATE NUMBER,
666 p_CURRENCY_CONVERSION_TYPE VARCHAR2,
667 p_CURRENCY_CONVERSION_DATE DATE,
668 p_USSGL_TRANSACTION_CODE VARCHAR2,
669 p_VENDOR_LOT_NUMBER VARCHAR2,
670 p_ENCUMBRANCE_ACCOUNT NUMBER,
671 p_ENCUMBRANCE_AMOUNT NUMBER,
672 p_SHIP_TO_LOCATION NUMBER,
673 p_SHIPMENT_NUMBER VARCHAR2,
674 p_TRANSFER_COST NUMBER,
675 p_TRANSPORTATION_COST NUMBER,
676 p_TRANSPORTATION_ACCOUNT NUMBER,
677 p_FREIGHT_CODE VARCHAR2,
678 p_CONTAINERS NUMBER,
679 p_WAYBILL_AIRBILL VARCHAR2,
680 p_EXPECTED_ARRIVAL_DATE DATE,
681 p_TRANSFER_SUBINVENTORY VARCHAR2,
682 p_TRANSFER_ORGANIZATION NUMBER,
683 p_TRANSFER_TO_LOCATION NUMBER,
684 p_NEW_AVERAGE_COST NUMBER,
685 p_VALUE_CHANGE NUMBER,
686 p_PERCENTAGE_CHANGE NUMBER,
687 p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
688 p_DEMAND_SOURCE_HEADER_ID NUMBER,
689 p_DEMAND_SOURCE_LINE VARCHAR2,
690 p_DEMAND_SOURCE_DELIVERY VARCHAR2,
691 p_ITEM_SEGMENTS VARCHAR2,
692 p_ITEM_DESCRIPTION VARCHAR2,
693 p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
694 p_ITEM_LOCATION_CONTROL_CODE NUMBER,
695 p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
696 p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
697 p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
698 p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
699 p_ITEM_UOM_CLASS VARCHAR2,
700 p_ITEM_SHELF_LIFE_CODE NUMBER,
701 p_ITEM_SHELF_LIFE_DAYS NUMBER,
702 p_ITEM_LOT_CONTROL_CODE NUMBER,
703 p_ITEM_SERIAL_CONTROL_CODE NUMBER,
704 p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
705 p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
706 p_DEPARTMENT_ID NUMBER,
707 p_DEPARTMENT_CODE VARCHAR2,
708 p_WIP_SUPPLY_TYPE NUMBER,
709 p_SUPPLY_SUBINVENTORY VARCHAR2,
710 p_SUPPLY_LOCATOR_ID NUMBER,
711 p_VALID_SUBINVENTORY_FLAG VARCHAR2,
712 p_VALID_LOCATOR_FLAG VARCHAR2,
713 p_LOCATOR_SEGMENTS VARCHAR2,
714 p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
715 p_NUMBER_OF_LOTS_ENTERED NUMBER,
716 p_WIP_COMMIT_FLAG VARCHAR2,
717 p_NEXT_LOT_NUMBER VARCHAR2,
718 p_LOT_ALPHA_PREFIX VARCHAR2,
719 p_NEXT_SERIAL_NUMBER VARCHAR2,
720 p_SERIAL_ALPHA_PREFIX VARCHAR2,
721 p_SHIPPABLE_FLAG VARCHAR2,
722 p_POSTING_FLAG VARCHAR2,
723 p_REQUIRED_FLAG VARCHAR2,
724 p_PROCESS_FLAG VARCHAR2,
728 p_ATTRIBUTE1 VARCHAR2,
725 p_ERROR_CODE VARCHAR2,
726 p_ERROR_EXPLANATION VARCHAR2,
727 p_ATTRIBUTE_CATEGORY VARCHAR2,
729 p_ATTRIBUTE2 VARCHAR2,
730 p_ATTRIBUTE3 VARCHAR2,
731 p_ATTRIBUTE4 VARCHAR2,
732 p_ATTRIBUTE5 VARCHAR2,
733 p_ATTRIBUTE6 VARCHAR2,
734 p_ATTRIBUTE7 VARCHAR2,
735 p_ATTRIBUTE8 VARCHAR2,
736 p_ATTRIBUTE9 VARCHAR2,
737 p_ATTRIBUTE10 VARCHAR2,
738 p_ATTRIBUTE11 VARCHAR2,
739 p_ATTRIBUTE12 VARCHAR2,
740 p_ATTRIBUTE13 VARCHAR2,
741 p_ATTRIBUTE14 VARCHAR2,
742 p_ATTRIBUTE15 VARCHAR2,
743 p_MOVEMENT_ID NUMBER,
744 p_RESERVATION_QUANTITY NUMBER,
745 p_SHIPPED_QUANTITY NUMBER,
746 p_TRANSACTION_LINE_NUMBER NUMBER,
747 p_TASK_ID NUMBER,
748 p_TO_TASK_ID NUMBER,
749 p_SOURCE_TASK_ID NUMBER,
750 p_PROJECT_ID NUMBER,
751 p_SOURCE_PROJECT_ID NUMBER,
752 p_PA_EXPENDITURE_ORG_ID NUMBER,
753 p_TO_PROJECT_ID NUMBER,
754 p_EXPENDITURE_TYPE VARCHAR2,
755 p_FINAL_COMPLETION_FLAG VARCHAR2,
756 p_TRANSFER_PERCENTAGE NUMBER,
757 p_TRANSACTION_SEQUENCE_ID NUMBER,
758 p_MATERIAL_ACCOUNT NUMBER,
759 p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
760 p_RESOURCE_ACCOUNT NUMBER,
761 p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
762 p_OVERHEAD_ACCOUNT NUMBER,
763 p_FLOW_SCHEDULE VARCHAR2,
764 p_COST_GROUP_ID NUMBER,
765 p_DEMAND_CLASS VARCHAR2,
766 p_QA_COLLECTION_ID NUMBER,
767 p_KANBAN_CARD_ID NUMBER,
768 p_OVERCOMPLETION_TXN_ID NUMBER,
769 p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
770 p_OVERCOMPLETION_TXN_QTY NUMBER,
771 --p_PROCESS_TYPE NUMBER,
772 p_END_ITEM_UNIT_NUMBER VARCHAR2,
773 p_SCHEDULED_PAYBACK_DATE DATE,
774 p_LINE_TYPE_CODE NUMBER,
775 p_PARENT_TRANSACTION_TEMP_ID NUMBER,
776 p_PUT_AWAY_STRATEGY_ID NUMBER,
777 p_PUT_AWAY_RULE_ID NUMBER,
778 p_PICK_STRATEGY_ID NUMBER,
779 p_PICK_RULE_ID NUMBER,
780 p_COMMON_BOM_SEQ_ID NUMBER,
781 p_COMMON_ROUTING_SEQ_ID NUMBER,
782 p_COST_TYPE_ID NUMBER,
783 p_ORG_COST_GROUP_ID NUMBER,
784 p_MOVE_ORDER_LINE_ID NUMBER,
785 p_TASK_GROUP_ID NUMBER,
786 p_PICK_SLIP_NUMBER NUMBER,
787 p_RESERVATION_ID NUMBER,
788 p_TRANSACTION_STATUS NUMBER,
789 p_STANDARD_OPERATION_ID NUMBER,
790 P_TASK_PRIORITY NUMBER,
791 p_WMS_TASK_TYPE NUMBER,
792 p_PARENT_LINE_ID NUMBER)
793 -- P_SOURCE_LOT_NUMBER NUMBER)
794
795 IS
796 BEGIN
797 Update MTL_MATERIAL_TRANSACTIONS_TEMP
798 SET
799 TRANSACTION_HEADER_ID = decode( p_TRANSACTION_HEADER_ID, FND_API.G_MISS_NUM, TRANSACTION_HEADER_ID, p_TRANSACTION_HEADER_ID),
800 SOURCE_CODE = decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, SOURCE_CODE, p_SOURCE_CODE),
801 SOURCE_LINE_ID = decode( p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, SOURCE_LINE_ID, p_SOURCE_LINE_ID),
802 TRANSACTION_MODE = decode( p_TRANSACTION_MODE, FND_API.G_MISS_NUM, TRANSACTION_MODE, p_TRANSACTION_MODE),
803 LOCK_FLAG = decode( p_LOCK_FLAG, FND_API.G_MISS_CHAR, LOCK_FLAG, p_LOCK_FLAG),
804 LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,last_update_date,p_last_update_date),
805 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
806 CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
807 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
808 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
809 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
810 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
811 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
812 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
813 INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
814 REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
815 ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
816 SUBINVENTORY_CODE = decode( p_SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, p_SUBINVENTORY_CODE),
817 LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, p_LOCATOR_ID),
818 TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY),
819 PRIMARY_QUANTITY = decode( p_PRIMARY_QUANTITY, FND_API.G_MISS_NUM, PRIMARY_QUANTITY, p_PRIMARY_QUANTITY),
820 TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, TRANSACTION_UOM, p_TRANSACTION_UOM),
821 TRANSACTION_COST = decode( p_TRANSACTION_COST, FND_API.G_MISS_NUM, TRANSACTION_COST, p_TRANSACTION_COST),
822 TRANSACTION_TYPE_ID = decode( p_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, p_TRANSACTION_TYPE_ID),
823 TRANSACTION_ACTION_ID = decode( p_TRANSACTION_ACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ACTION_ID, p_TRANSACTION_ACTION_ID),
827 TRANSACTION_DATE = decode( p_TRANSACTION_DATE, FND_API.G_MISS_DATE, TRANSACTION_DATE, p_TRANSACTION_DATE),
824 TRANSACTION_SOURCE_TYPE_ID = decode( p_TRANSACTION_SOURCE_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_SOURCE_TYPE_ID, p_TRANSACTION_SOURCE_TYPE_ID),
825 TRANSACTION_SOURCE_ID = decode( p_TRANSACTION_SOURCE_ID, FND_API.G_MISS_NUM, TRANSACTION_SOURCE_ID, p_TRANSACTION_SOURCE_ID),
826 TRANSACTION_SOURCE_NAME = decode( p_TRANSACTION_SOURCE_NAME, FND_API.G_MISS_CHAR, TRANSACTION_SOURCE_NAME, p_TRANSACTION_SOURCE_NAME),
828 ACCT_PERIOD_ID = decode( p_ACCT_PERIOD_ID, FND_API.G_MISS_NUM, ACCT_PERIOD_ID, p_ACCT_PERIOD_ID),
829 DISTRIBUTION_ACCOUNT_ID = decode( p_DISTRIBUTION_ACCOUNT_ID, FND_API.G_MISS_NUM, DISTRIBUTION_ACCOUNT_ID, p_DISTRIBUTION_ACCOUNT_ID),
830 TRANSACTION_REFERENCE = decode( p_TRANSACTION_REFERENCE, FND_API.G_MISS_CHAR, TRANSACTION_REFERENCE, p_TRANSACTION_REFERENCE),
831 REQUISITION_LINE_ID = decode( p_REQUISITION_LINE_ID, FND_API.G_MISS_NUM, REQUISITION_LINE_ID, p_REQUISITION_LINE_ID),
832 REQUISITION_DISTRIBUTION_ID = decode( p_REQUISITION_DISTRIBUTION_ID, FND_API.G_MISS_NUM, REQUISITION_DISTRIBUTION_ID, p_REQUISITION_DISTRIBUTION_ID),
833 REASON_ID = decode( p_REASON_ID, FND_API.G_MISS_NUM, REASON_ID, p_REASON_ID),
834 LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
835 LOT_EXPIRATION_DATE = decode( p_LOT_EXPIRATION_DATE, FND_API.G_MISS_DATE, LOT_EXPIRATION_DATE, p_LOT_EXPIRATION_DATE),
836 SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
837 RECEIVING_DOCUMENT = decode( p_RECEIVING_DOCUMENT, FND_API.G_MISS_CHAR, RECEIVING_DOCUMENT, p_RECEIVING_DOCUMENT),
838 DEMAND_ID = decode( p_DEMAND_ID, FND_API.G_MISS_NUM, DEMAND_ID, p_DEMAND_ID),
839 RCV_TRANSACTION_ID = decode( p_RCV_TRANSACTION_ID, FND_API.G_MISS_NUM, RCV_TRANSACTION_ID, p_RCV_TRANSACTION_ID),
840 MOVE_TRANSACTION_ID = decode( p_MOVE_TRANSACTION_ID, FND_API.G_MISS_NUM, MOVE_TRANSACTION_ID, p_MOVE_TRANSACTION_ID),
841 COMPLETION_TRANSACTION_ID = decode( p_COMPLETION_TRANSACTION_ID, FND_API.G_MISS_NUM, COMPLETION_TRANSACTION_ID, p_COMPLETION_TRANSACTION_ID),
842 WIP_ENTITY_TYPE = decode( p_WIP_ENTITY_TYPE, FND_API.G_MISS_NUM, WIP_ENTITY_TYPE, p_WIP_ENTITY_TYPE),
843 SCHEDULE_ID = decode( p_SCHEDULE_ID, FND_API.G_MISS_NUM, SCHEDULE_ID, p_SCHEDULE_ID),
844 REPETITIVE_LINE_ID = decode( p_REPETITIVE_LINE_ID, FND_API.G_MISS_NUM, REPETITIVE_LINE_ID, p_REPETITIVE_LINE_ID),
845 EMPLOYEE_CODE = decode( p_EMPLOYEE_CODE, FND_API.G_MISS_CHAR, EMPLOYEE_CODE, p_EMPLOYEE_CODE),
846 PRIMARY_SWITCH = decode( p_PRIMARY_SWITCH, FND_API.G_MISS_NUM, PRIMARY_SWITCH, p_PRIMARY_SWITCH),
847 SCHEDULE_UPDATE_CODE = decode( p_SCHEDULE_UPDATE_CODE, FND_API.G_MISS_NUM, SCHEDULE_UPDATE_CODE, p_SCHEDULE_UPDATE_CODE),
848 SETUP_TEARDOWN_CODE = decode( p_SETUP_TEARDOWN_CODE, FND_API.G_MISS_NUM, SETUP_TEARDOWN_CODE, p_SETUP_TEARDOWN_CODE),
849 ITEM_ORDERING = decode( p_ITEM_ORDERING, FND_API.G_MISS_NUM, ITEM_ORDERING, p_ITEM_ORDERING),
850 NEGATIVE_REQ_FLAG = decode( p_NEGATIVE_REQ_FLAG, FND_API.G_MISS_NUM, NEGATIVE_REQ_FLAG, p_NEGATIVE_REQ_FLAG),
851 OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM),
852 PICKING_LINE_ID = decode( p_PICKING_LINE_ID, FND_API.G_MISS_NUM, PICKING_LINE_ID, p_PICKING_LINE_ID),
853 TRX_SOURCE_LINE_ID = decode( p_TRX_SOURCE_LINE_ID, FND_API.G_MISS_NUM, TRX_SOURCE_LINE_ID, p_TRX_SOURCE_LINE_ID),
854 TRX_SOURCE_DELIVERY_ID = decode( p_TRX_SOURCE_DELIVERY_ID, FND_API.G_MISS_NUM, TRX_SOURCE_DELIVERY_ID, p_TRX_SOURCE_DELIVERY_ID),
855 PHYSICAL_ADJUSTMENT_ID = decode( p_PHYSICAL_ADJUSTMENT_ID, FND_API.G_MISS_NUM, PHYSICAL_ADJUSTMENT_ID, p_PHYSICAL_ADJUSTMENT_ID),
856 CYCLE_COUNT_ID = decode( p_CYCLE_COUNT_ID, FND_API.G_MISS_NUM, CYCLE_COUNT_ID, p_CYCLE_COUNT_ID),
857 RMA_LINE_ID = decode( p_RMA_LINE_ID, FND_API.G_MISS_NUM, RMA_LINE_ID, p_RMA_LINE_ID),
858 CUSTOMER_SHIP_ID = decode( p_CUSTOMER_SHIP_ID, FND_API.G_MISS_NUM, CUSTOMER_SHIP_ID, p_CUSTOMER_SHIP_ID),
859 CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
860 CURRENCY_CONVERSION_RATE = decode( p_CURRENCY_CONVERSION_RATE, FND_API.G_MISS_NUM, CURRENCY_CONVERSION_RATE, p_CURRENCY_CONVERSION_RATE),
861 CURRENCY_CONVERSION_TYPE = decode( p_CURRENCY_CONVERSION_TYPE, FND_API.G_MISS_CHAR, CURRENCY_CONVERSION_TYPE, p_CURRENCY_CONVERSION_TYPE),
862 CURRENCY_CONVERSION_DATE = decode( p_CURRENCY_CONVERSION_DATE, FND_API.G_MISS_DATE, CURRENCY_CONVERSION_DATE, p_CURRENCY_CONVERSION_DATE),
863 USSGL_TRANSACTION_CODE = decode( p_USSGL_TRANSACTION_CODE, FND_API.G_MISS_CHAR, USSGL_TRANSACTION_CODE, p_USSGL_TRANSACTION_CODE),
864 VENDOR_LOT_NUMBER = decode( p_VENDOR_LOT_NUMBER, FND_API.G_MISS_CHAR, VENDOR_LOT_NUMBER, p_VENDOR_LOT_NUMBER),
865 ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
866 ENCUMBRANCE_AMOUNT = decode( p_ENCUMBRANCE_AMOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_AMOUNT, p_ENCUMBRANCE_AMOUNT),
867 SHIP_TO_LOCATION = decode( p_SHIP_TO_LOCATION, FND_API.G_MISS_NUM, SHIP_TO_LOCATION, p_SHIP_TO_LOCATION),
868 SHIPMENT_NUMBER = decode( p_SHIPMENT_NUMBER, FND_API.G_MISS_CHAR, SHIPMENT_NUMBER, p_SHIPMENT_NUMBER),
869 TRANSFER_COST = decode( p_TRANSFER_COST, FND_API.G_MISS_NUM, TRANSFER_COST, p_TRANSFER_COST),
870 TRANSPORTATION_COST = decode( p_TRANSPORTATION_COST, FND_API.G_MISS_NUM, TRANSPORTATION_COST, p_TRANSPORTATION_COST),
871 TRANSPORTATION_ACCOUNT = decode( p_TRANSPORTATION_ACCOUNT, FND_API.G_MISS_NUM, TRANSPORTATION_ACCOUNT, p_TRANSPORTATION_ACCOUNT),
872 FREIGHT_CODE = decode( p_FREIGHT_CODE, FND_API.G_MISS_CHAR, FREIGHT_CODE, p_FREIGHT_CODE),
873 CONTAINERS = decode( p_CONTAINERS, FND_API.G_MISS_NUM, CONTAINERS, p_CONTAINERS),
874 WAYBILL_AIRBILL = decode( p_WAYBILL_AIRBILL, FND_API.G_MISS_CHAR, WAYBILL_AIRBILL, p_WAYBILL_AIRBILL),
878 TRANSFER_TO_LOCATION = decode( p_TRANSFER_TO_LOCATION, FND_API.G_MISS_NUM, TRANSFER_TO_LOCATION, p_TRANSFER_TO_LOCATION),
875 EXPECTED_ARRIVAL_DATE = decode( p_EXPECTED_ARRIVAL_DATE, FND_API.G_MISS_DATE, EXPECTED_ARRIVAL_DATE, p_EXPECTED_ARRIVAL_DATE),
876 TRANSFER_SUBINVENTORY = decode( p_TRANSFER_SUBINVENTORY, FND_API.G_MISS_CHAR, TRANSFER_SUBINVENTORY, p_TRANSFER_SUBINVENTORY),
877 TRANSFER_ORGANIZATION = decode( p_TRANSFER_ORGANIZATION, FND_API.G_MISS_NUM, TRANSFER_ORGANIZATION, p_TRANSFER_ORGANIZATION),
879 NEW_AVERAGE_COST = decode( p_NEW_AVERAGE_COST, FND_API.G_MISS_NUM, NEW_AVERAGE_COST, p_NEW_AVERAGE_COST),
880 VALUE_CHANGE = decode( p_VALUE_CHANGE, FND_API.G_MISS_NUM, VALUE_CHANGE, p_VALUE_CHANGE),
881 PERCENTAGE_CHANGE = decode( p_PERCENTAGE_CHANGE, FND_API.G_MISS_NUM, PERCENTAGE_CHANGE, p_PERCENTAGE_CHANGE),
882 MATERIAL_ALLOCATION_TEMP_ID = decode( p_MATERIAL_ALLOCATION_TEMP_ID, FND_API.G_MISS_NUM, MATERIAL_ALLOCATION_TEMP_ID, p_MATERIAL_ALLOCATION_TEMP_ID),
883 DEMAND_SOURCE_HEADER_ID = decode( p_DEMAND_SOURCE_HEADER_ID, FND_API.G_MISS_NUM, DEMAND_SOURCE_HEADER_ID, p_DEMAND_SOURCE_HEADER_ID),
884 DEMAND_SOURCE_LINE = decode( p_DEMAND_SOURCE_LINE, FND_API.G_MISS_CHAR, DEMAND_SOURCE_LINE, p_DEMAND_SOURCE_LINE),
885 DEMAND_SOURCE_DELIVERY = decode( p_DEMAND_SOURCE_DELIVERY, FND_API.G_MISS_CHAR, DEMAND_SOURCE_DELIVERY, p_DEMAND_SOURCE_DELIVERY),
886 ITEM_SEGMENTS = decode( p_ITEM_SEGMENTS, FND_API.G_MISS_CHAR, ITEM_SEGMENTS, p_ITEM_SEGMENTS),
887 ITEM_DESCRIPTION = decode( p_ITEM_DESCRIPTION, FND_API.G_MISS_CHAR, ITEM_DESCRIPTION, p_ITEM_DESCRIPTION),
888 ITEM_TRX_ENABLED_FLAG = decode( p_ITEM_TRX_ENABLED_FLAG, FND_API.G_MISS_CHAR, ITEM_TRX_ENABLED_FLAG, p_ITEM_TRX_ENABLED_FLAG),
889 ITEM_LOCATION_CONTROL_CODE = decode( p_ITEM_LOCATION_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_LOCATION_CONTROL_CODE, p_ITEM_LOCATION_CONTROL_CODE),
890 ITEM_RESTRICT_SUBINV_CODE = decode( p_ITEM_RESTRICT_SUBINV_CODE, FND_API.G_MISS_NUM, ITEM_RESTRICT_SUBINV_CODE, p_ITEM_RESTRICT_SUBINV_CODE),
891 ITEM_RESTRICT_LOCATORS_CODE = decode( p_ITEM_RESTRICT_LOCATORS_CODE, FND_API.G_MISS_NUM, ITEM_RESTRICT_LOCATORS_CODE, p_ITEM_RESTRICT_LOCATORS_CODE),
892 ITEM_REVISION_QTY_CONTROL_CODE = decode( p_ITEM_REV_QTY_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_REVISION_QTY_CONTROL_CODE, p_ITEM_REV_QTY_CONTROL_CODE),
893 ITEM_PRIMARY_UOM_CODE = decode( p_ITEM_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, ITEM_PRIMARY_UOM_CODE, p_ITEM_PRIMARY_UOM_CODE),
894 ITEM_UOM_CLASS = decode( p_ITEM_UOM_CLASS, FND_API.G_MISS_CHAR, ITEM_UOM_CLASS, p_ITEM_UOM_CLASS),
895 ITEM_SHELF_LIFE_CODE = decode( p_ITEM_SHELF_LIFE_CODE, FND_API.G_MISS_NUM, ITEM_SHELF_LIFE_CODE, p_ITEM_SHELF_LIFE_CODE),
896 ITEM_SHELF_LIFE_DAYS = decode( p_ITEM_SHELF_LIFE_DAYS, FND_API.G_MISS_NUM, ITEM_SHELF_LIFE_DAYS, p_ITEM_SHELF_LIFE_DAYS),
897 ITEM_LOT_CONTROL_CODE = decode( p_ITEM_LOT_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_LOT_CONTROL_CODE, p_ITEM_LOT_CONTROL_CODE),
898 ITEM_SERIAL_CONTROL_CODE = decode( p_ITEM_SERIAL_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_SERIAL_CONTROL_CODE, p_ITEM_SERIAL_CONTROL_CODE),
899 ITEM_INVENTORY_ASSET_FLAG = decode( p_ITEM_INVENTORY_ASSET_FLAG, FND_API.G_MISS_CHAR, ITEM_INVENTORY_ASSET_FLAG, p_ITEM_INVENTORY_ASSET_FLAG),
900 ALLOWED_UNITS_LOOKUP_CODE = decode( p_ALLOWED_UNITS_LOOKUP_CODE, FND_API.G_MISS_NUM, ALLOWED_UNITS_LOOKUP_CODE, p_ALLOWED_UNITS_LOOKUP_CODE),
901 DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, DEPARTMENT_ID, p_DEPARTMENT_ID),
902 DEPARTMENT_CODE = decode( p_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, DEPARTMENT_CODE, p_DEPARTMENT_CODE),
903 WIP_SUPPLY_TYPE = decode( p_WIP_SUPPLY_TYPE, FND_API.G_MISS_NUM, WIP_SUPPLY_TYPE, p_WIP_SUPPLY_TYPE),
904 SUPPLY_SUBINVENTORY = decode( p_SUPPLY_SUBINVENTORY, FND_API.G_MISS_CHAR, SUPPLY_SUBINVENTORY, p_SUPPLY_SUBINVENTORY),
905 SUPPLY_LOCATOR_ID = decode( p_SUPPLY_LOCATOR_ID, FND_API.G_MISS_NUM, SUPPLY_LOCATOR_ID, p_SUPPLY_LOCATOR_ID),
906 VALID_SUBINVENTORY_FLAG = decode( p_VALID_SUBINVENTORY_FLAG, FND_API.G_MISS_CHAR, VALID_SUBINVENTORY_FLAG, p_VALID_SUBINVENTORY_FLAG),
907 VALID_LOCATOR_FLAG = decode( p_VALID_LOCATOR_FLAG, FND_API.G_MISS_CHAR, VALID_LOCATOR_FLAG, p_VALID_LOCATOR_FLAG),
908 LOCATOR_SEGMENTS = decode( p_LOCATOR_SEGMENTS, FND_API.G_MISS_CHAR, LOCATOR_SEGMENTS, p_LOCATOR_SEGMENTS),
909 CURRENT_LOCATOR_CONTROL_CODE = decode( p_CURRENT_LOCATOR_CONTROL_CODE, FND_API.G_MISS_NUM, CURRENT_LOCATOR_CONTROL_CODE, p_CURRENT_LOCATOR_CONTROL_CODE),
910 NUMBER_OF_LOTS_ENTERED = decode( p_NUMBER_OF_LOTS_ENTERED, FND_API.G_MISS_NUM, NUMBER_OF_LOTS_ENTERED, p_NUMBER_OF_LOTS_ENTERED),
911 WIP_COMMIT_FLAG = decode( p_WIP_COMMIT_FLAG, FND_API.G_MISS_CHAR, WIP_COMMIT_FLAG, p_WIP_COMMIT_FLAG),
912 NEXT_LOT_NUMBER = decode( p_NEXT_LOT_NUMBER, FND_API.G_MISS_CHAR, NEXT_LOT_NUMBER, p_NEXT_LOT_NUMBER),
913 LOT_ALPHA_PREFIX = decode( p_LOT_ALPHA_PREFIX, FND_API.G_MISS_CHAR, LOT_ALPHA_PREFIX, p_LOT_ALPHA_PREFIX),
914 NEXT_SERIAL_NUMBER = decode( p_NEXT_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NEXT_SERIAL_NUMBER, p_NEXT_SERIAL_NUMBER),
915 SERIAL_ALPHA_PREFIX = decode( p_SERIAL_ALPHA_PREFIX, FND_API.G_MISS_CHAR, SERIAL_ALPHA_PREFIX, p_SERIAL_ALPHA_PREFIX),
916 SHIPPABLE_FLAG = decode( p_SHIPPABLE_FLAG, FND_API.G_MISS_CHAR, SHIPPABLE_FLAG, p_SHIPPABLE_FLAG),
917 POSTING_FLAG = decode( p_POSTING_FLAG, FND_API.G_MISS_CHAR, POSTING_FLAG, p_POSTING_FLAG),
918 REQUIRED_FLAG = decode( p_REQUIRED_FLAG, FND_API.G_MISS_CHAR, REQUIRED_FLAG, p_REQUIRED_FLAG),
919 PROCESS_FLAG = decode( p_PROCESS_FLAG, FND_API.G_MISS_CHAR, PROCESS_FLAG, p_PROCESS_FLAG),
920 ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
921 ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
922 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
923 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
924 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
928 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
925 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
926 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
927 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
929 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
930 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
931 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
932 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
933 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
934 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
935 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
936 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
937 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
938 MOVEMENT_ID = decode( p_MOVEMENT_ID, FND_API.G_MISS_NUM, MOVEMENT_ID, p_MOVEMENT_ID),
939 RESERVATION_QUANTITY = decode( p_RESERVATION_QUANTITY, FND_API.G_MISS_NUM, RESERVATION_QUANTITY, p_RESERVATION_QUANTITY),
940 SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY),
941 TRANSACTION_LINE_NUMBER = decode( p_TRANSACTION_LINE_NUMBER, FND_API.G_MISS_NUM, TRANSACTION_LINE_NUMBER, p_TRANSACTION_LINE_NUMBER),
942 TASK_ID = decode( p_TASK_ID, FND_API.G_MISS_NUM, TASK_ID, p_TASK_ID),
943 TO_TASK_ID = decode( p_TO_TASK_ID, FND_API.G_MISS_NUM, TO_TASK_ID, p_TO_TASK_ID),
944 SOURCE_TASK_ID = decode( p_SOURCE_TASK_ID, FND_API.G_MISS_NUM, SOURCE_TASK_ID, p_SOURCE_TASK_ID),
945 PROJECT_ID = decode( p_PROJECT_ID, FND_API.G_MISS_NUM, PROJECT_ID, p_PROJECT_ID),
946 SOURCE_PROJECT_ID = decode( p_SOURCE_PROJECT_ID, FND_API.G_MISS_NUM, SOURCE_PROJECT_ID, p_SOURCE_PROJECT_ID),
947 PA_EXPENDITURE_ORG_ID = decode( p_PA_EXPENDITURE_ORG_ID, FND_API.G_MISS_NUM, PA_EXPENDITURE_ORG_ID, p_PA_EXPENDITURE_ORG_ID),
948 TO_PROJECT_ID = decode( p_TO_PROJECT_ID, FND_API.G_MISS_NUM, TO_PROJECT_ID, p_TO_PROJECT_ID),
949 EXPENDITURE_TYPE = decode( p_EXPENDITURE_TYPE, FND_API.G_MISS_CHAR, EXPENDITURE_TYPE, p_EXPENDITURE_TYPE),
950 FINAL_COMPLETION_FLAG = decode( p_FINAL_COMPLETION_FLAG, FND_API.G_MISS_CHAR, FINAL_COMPLETION_FLAG, p_FINAL_COMPLETION_FLAG),
951 TRANSFER_PERCENTAGE = decode( p_TRANSFER_PERCENTAGE, FND_API.G_MISS_NUM, TRANSFER_PERCENTAGE, p_TRANSFER_PERCENTAGE),
952 TRANSACTION_SEQUENCE_ID = decode( p_TRANSACTION_SEQUENCE_ID, FND_API.G_MISS_NUM, TRANSACTION_SEQUENCE_ID, p_TRANSACTION_SEQUENCE_ID),
953 MATERIAL_ACCOUNT = decode( p_MATERIAL_ACCOUNT, FND_API.G_MISS_NUM, MATERIAL_ACCOUNT, p_MATERIAL_ACCOUNT),
954 MATERIAL_OVERHEAD_ACCOUNT = decode( p_MATERIAL_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, MATERIAL_OVERHEAD_ACCOUNT, p_MATERIAL_OVERHEAD_ACCOUNT),
955 RESOURCE_ACCOUNT = decode( p_RESOURCE_ACCOUNT, FND_API.G_MISS_NUM, RESOURCE_ACCOUNT, p_RESOURCE_ACCOUNT),
956 OUTSIDE_PROCESSING_ACCOUNT = decode( p_OUTSIDE_PROCESSING_ACCOUNT, FND_API.G_MISS_NUM, OUTSIDE_PROCESSING_ACCOUNT, p_OUTSIDE_PROCESSING_ACCOUNT),
957 OVERHEAD_ACCOUNT = decode( p_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, OVERHEAD_ACCOUNT, p_OVERHEAD_ACCOUNT),
958 FLOW_SCHEDULE = decode( p_FLOW_SCHEDULE, FND_API.G_MISS_CHAR, FLOW_SCHEDULE, p_FLOW_SCHEDULE),
959 COST_GROUP_ID = decode( p_COST_GROUP_ID, FND_API.G_MISS_NUM, COST_GROUP_ID, p_COST_GROUP_ID),
960 DEMAND_CLASS = decode( p_DEMAND_CLASS, FND_API.G_MISS_CHAR, DEMAND_CLASS, p_DEMAND_CLASS),
961 QA_COLLECTION_ID = decode( p_QA_COLLECTION_ID, FND_API.G_MISS_NUM, QA_COLLECTION_ID, p_QA_COLLECTION_ID),
962 KANBAN_CARD_ID = decode( p_KANBAN_CARD_ID, FND_API.G_MISS_NUM, KANBAN_CARD_ID, p_KANBAN_CARD_ID),
963 OVERCOMPLETION_TRANSACTION_ID = decode( p_OVERCOMPLETION_TXN_ID, FND_API.G_MISS_NUM, OVERCOMPLETION_TRANSACTION_ID, p_OVERCOMPLETION_TXN_ID),
964 OVERCOMPLETION_PRIMARY_QTY = decode( p_OVERCOMPLETION_PRIMARY_QTY, FND_API.G_MISS_NUM, OVERCOMPLETION_PRIMARY_QTY, p_OVERCOMPLETION_PRIMARY_QTY),
965 OVERCOMPLETION_TRANSACTION_QTY = decode( p_OVERCOMPLETION_TXN_QTY, FND_API.G_MISS_NUM, OVERCOMPLETION_TRANSACTION_QTY, p_OVERCOMPLETION_TXN_QTY),
966 -- PROCESS_TYPE = decode( p_PROCESS_TYPE, FND_API.G_MISS_NUM, PROCESS_TYPE, p_PROCESS_TYPE),
967 END_ITEM_UNIT_NUMBER = decode( p_END_ITEM_UNIT_NUMBER, FND_API.G_MISS_CHAR, END_ITEM_UNIT_NUMBER, p_END_ITEM_UNIT_NUMBER),
968 SCHEDULED_PAYBACK_DATE = decode( p_SCHEDULED_PAYBACK_DATE, FND_API.G_MISS_DATE, SCHEDULED_PAYBACK_DATE, p_SCHEDULED_PAYBACK_DATE),
969 LINE_TYPE_CODE = decode( p_LINE_TYPE_CODE, FND_API.G_MISS_NUM, LINE_TYPE_CODE, p_LINE_TYPE_CODE),
970 PARENT_TRANSACTION_TEMP_ID = decode( p_PARENT_TRANSACTION_TEMP_ID, FND_API.G_MISS_NUM, PARENT_TRANSACTION_TEMP_ID, p_PARENT_TRANSACTION_TEMP_ID),
971 PUT_AWAY_STRATEGY_ID = decode( p_PUT_AWAY_STRATEGY_ID, FND_API.G_MISS_NUM, PUT_AWAY_STRATEGY_ID, p_PUT_AWAY_STRATEGY_ID),
972 PUT_AWAY_RULE_ID = decode( p_PUT_AWAY_RULE_ID, FND_API.G_MISS_NUM, PUT_AWAY_RULE_ID, p_PUT_AWAY_RULE_ID),
973 PICK_STRATEGY_ID = decode( p_PICK_STRATEGY_ID, FND_API.G_MISS_NUM, PICK_STRATEGY_ID, p_PICK_STRATEGY_ID),
974 PICK_RULE_ID = decode( p_PICK_RULE_ID, FND_API.G_MISS_NUM, PICK_RULE_ID, p_PICK_RULE_ID),
975 COMMON_BOM_SEQ_ID = decode( p_COMMON_BOM_SEQ_ID, FND_API.G_MISS_NUM, COMMON_BOM_SEQ_ID, p_COMMON_BOM_SEQ_ID),
976 COMMON_ROUTING_SEQ_ID = decode( p_COMMON_ROUTING_SEQ_ID, FND_API.G_MISS_NUM, COMMON_ROUTING_SEQ_ID, p_COMMON_ROUTING_SEQ_ID),
977 COST_TYPE_ID = decode( p_COST_TYPE_ID, FND_API.G_MISS_NUM, COST_TYPE_ID, p_COST_TYPE_ID),
978 ORG_COST_GROUP_ID = decode( p_ORG_COST_GROUP_ID, FND_API.G_MISS_NUM, ORG_COST_GROUP_ID, p_ORG_COST_GROUP_ID),
982 RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
979 MOVE_ORDER_LINE_ID = decode( p_MOVE_ORDER_LINE_ID, FND_API.G_MISS_NUM, MOVE_ORDER_LINE_ID, p_MOVE_ORDER_LINE_ID),
980 TASK_GROUP_ID = decode( p_TASK_GROUP_ID, FND_API.G_MISS_NUM, TASK_GROUP_ID, p_TASK_GROUP_ID),
981 PICK_SLIP_NUMBER = decode( p_PICK_SLIP_NUMBER, FND_API.G_MISS_NUM, PICK_SLIP_NUMBER, p_PICK_SLIP_NUMBER),
983 TRANSACTION_STATUS = decode( p_TRANSACTION_STATUS, FND_API.G_MISS_NUM, TRANSACTION_STATUS, p_TRANSACTION_STATUS),
984 STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID),
985 TASK_PRIORITY = decode( p_TASK_PRIORITY, FND_API.G_MISS_NUM, TASK_PRIORITY, p_TASK_PRIORITY),
986 WMS_TASK_TYPE = decode( p_WMS_TASK_TYPE, FND_API.G_MISS_NUM, WMS_TASK_TYPE, p_WMS_TASK_TYPE),
987 PARENT_LINE_ID = decode( p_PARENT_LINE_ID, FND_API.G_MISS_NUM, PARENT_LINE_ID, p_PARENT_LINE_ID)
988 -- SOURCE_LOT_NUMBER = decode( P_SOURCE_LOT_NUMBER, FND_API.G_MISS_NUM, SOURCE_LOT_NUMBER, p_SOURCE_LOT_NUMBER)
989 where TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID;
990
991 If (SQL%NOTFOUND) then
992 RAISE NO_DATA_FOUND;
993 End If;
994 END Update_Row;
995
996 PROCEDURE Delete_Row(
997 p_TRANSACTION_TEMP_ID NUMBER)
998 IS
999 BEGIN
1000 DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1001 WHERE TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID;
1002 If (SQL%NOTFOUND) then
1003 RAISE NO_DATA_FOUND;
1004 End If;
1005 END Delete_Row;
1006
1007 PROCEDURE Lock_Row(
1008 p_TRANSACTION_HEADER_ID NUMBER,
1009 p_TRANSACTION_TEMP_ID NUMBER,
1010 p_SOURCE_CODE VARCHAR2,
1011 p_SOURCE_LINE_ID NUMBER,
1012 p_TRANSACTION_MODE NUMBER,
1013 p_LOCK_FLAG VARCHAR2,
1014 p_LAST_UPDATE_DATE DATE,
1015 p_LAST_UPDATED_BY NUMBER,
1016 p_CREATION_DATE DATE,
1017 p_CREATED_BY NUMBER,
1018 p_LAST_UPDATE_LOGIN NUMBER,
1019 p_REQUEST_ID NUMBER,
1020 p_PROGRAM_APPLICATION_ID NUMBER,
1021 p_PROGRAM_ID NUMBER,
1022 p_PROGRAM_UPDATE_DATE DATE,
1023 p_INVENTORY_ITEM_ID NUMBER,
1024 p_REVISION VARCHAR2,
1025 p_ORGANIZATION_ID NUMBER,
1026 p_SUBINVENTORY_CODE VARCHAR2,
1027 p_LOCATOR_ID NUMBER,
1028 p_TRANSACTION_QUANTITY NUMBER,
1029 p_PRIMARY_QUANTITY NUMBER,
1030 p_TRANSACTION_UOM VARCHAR2,
1031 p_TRANSACTION_COST NUMBER,
1032 p_TRANSACTION_TYPE_ID NUMBER,
1033 p_TRANSACTION_ACTION_ID NUMBER,
1034 p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
1035 p_TRANSACTION_SOURCE_ID NUMBER,
1036 p_TRANSACTION_SOURCE_NAME VARCHAR2,
1037 p_TRANSACTION_DATE DATE,
1038 p_ACCT_PERIOD_ID NUMBER,
1039 p_DISTRIBUTION_ACCOUNT_ID NUMBER,
1040 p_TRANSACTION_REFERENCE VARCHAR2,
1041 p_REQUISITION_LINE_ID NUMBER,
1042 p_REQUISITION_DISTRIBUTION_ID NUMBER,
1043 p_REASON_ID NUMBER,
1044 p_LOT_NUMBER VARCHAR2,
1045 p_LOT_EXPIRATION_DATE DATE,
1046 p_SERIAL_NUMBER VARCHAR2,
1047 p_RECEIVING_DOCUMENT VARCHAR2,
1048 p_DEMAND_ID NUMBER,
1049 p_RCV_TRANSACTION_ID NUMBER,
1050 p_MOVE_TRANSACTION_ID NUMBER,
1051 p_COMPLETION_TRANSACTION_ID NUMBER,
1052 p_WIP_ENTITY_TYPE NUMBER,
1053 p_SCHEDULE_ID NUMBER,
1054 p_REPETITIVE_LINE_ID NUMBER,
1055 p_EMPLOYEE_CODE VARCHAR2,
1056 p_PRIMARY_SWITCH NUMBER,
1057 p_SCHEDULE_UPDATE_CODE NUMBER,
1058 p_SETUP_TEARDOWN_CODE NUMBER,
1059 p_ITEM_ORDERING NUMBER,
1060 p_NEGATIVE_REQ_FLAG NUMBER,
1061 p_OPERATION_SEQ_NUM NUMBER,
1062 p_PICKING_LINE_ID NUMBER,
1063 p_TRX_SOURCE_LINE_ID NUMBER,
1064 p_TRX_SOURCE_DELIVERY_ID NUMBER,
1065 p_PHYSICAL_ADJUSTMENT_ID NUMBER,
1066 p_CYCLE_COUNT_ID NUMBER,
1067 p_RMA_LINE_ID NUMBER,
1068 p_CUSTOMER_SHIP_ID NUMBER,
1069 p_CURRENCY_CODE VARCHAR2,
1070 p_CURRENCY_CONVERSION_RATE NUMBER,
1071 p_CURRENCY_CONVERSION_TYPE VARCHAR2,
1072 p_CURRENCY_CONVERSION_DATE DATE,
1073 p_USSGL_TRANSACTION_CODE VARCHAR2,
1074 p_VENDOR_LOT_NUMBER VARCHAR2,
1075 p_ENCUMBRANCE_ACCOUNT NUMBER,
1076 p_ENCUMBRANCE_AMOUNT NUMBER,
1077 p_SHIP_TO_LOCATION NUMBER,
1078 p_SHIPMENT_NUMBER VARCHAR2,
1079 p_TRANSFER_COST NUMBER,
1080 p_TRANSPORTATION_COST NUMBER,
1081 p_TRANSPORTATION_ACCOUNT NUMBER,
1082 p_FREIGHT_CODE VARCHAR2,
1083 p_CONTAINERS NUMBER,
1084 p_WAYBILL_AIRBILL VARCHAR2,
1085 p_EXPECTED_ARRIVAL_DATE DATE,
1086 p_TRANSFER_SUBINVENTORY VARCHAR2,
1087 p_TRANSFER_ORGANIZATION NUMBER,
1088 p_TRANSFER_TO_LOCATION NUMBER,
1089 p_NEW_AVERAGE_COST NUMBER,
1090 p_VALUE_CHANGE NUMBER,
1091 p_PERCENTAGE_CHANGE NUMBER,
1092 p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
1093 p_DEMAND_SOURCE_HEADER_ID NUMBER,
1094 p_DEMAND_SOURCE_LINE VARCHAR2,
1095 p_DEMAND_SOURCE_DELIVERY VARCHAR2,
1096 p_ITEM_SEGMENTS VARCHAR2,
1097 p_ITEM_DESCRIPTION VARCHAR2,
1098 p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
1099 p_ITEM_LOCATION_CONTROL_CODE NUMBER,
1103 p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
1100 p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
1101 p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
1102 p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
1104 p_ITEM_UOM_CLASS VARCHAR2,
1105 p_ITEM_SHELF_LIFE_CODE NUMBER,
1106 p_ITEM_SHELF_LIFE_DAYS NUMBER,
1107 p_ITEM_LOT_CONTROL_CODE NUMBER,
1108 p_ITEM_SERIAL_CONTROL_CODE NUMBER,
1109 p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
1110 p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
1111 p_DEPARTMENT_ID NUMBER,
1112 p_DEPARTMENT_CODE VARCHAR2,
1113 p_WIP_SUPPLY_TYPE NUMBER,
1114 p_SUPPLY_SUBINVENTORY VARCHAR2,
1115 p_SUPPLY_LOCATOR_ID NUMBER,
1116 p_VALID_SUBINVENTORY_FLAG VARCHAR2,
1117 p_VALID_LOCATOR_FLAG VARCHAR2,
1118 p_LOCATOR_SEGMENTS VARCHAR2,
1119 p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
1120 p_NUMBER_OF_LOTS_ENTERED NUMBER,
1121 p_WIP_COMMIT_FLAG VARCHAR2,
1122 p_NEXT_LOT_NUMBER VARCHAR2,
1123 p_LOT_ALPHA_PREFIX VARCHAR2,
1124 p_NEXT_SERIAL_NUMBER VARCHAR2,
1125 p_SERIAL_ALPHA_PREFIX VARCHAR2,
1126 p_SHIPPABLE_FLAG VARCHAR2,
1127 p_POSTING_FLAG VARCHAR2,
1128 p_REQUIRED_FLAG VARCHAR2,
1129 p_PROCESS_FLAG VARCHAR2,
1130 p_ERROR_CODE VARCHAR2,
1131 p_ERROR_EXPLANATION VARCHAR2,
1132 p_ATTRIBUTE_CATEGORY VARCHAR2,
1133 p_ATTRIBUTE1 VARCHAR2,
1134 p_ATTRIBUTE2 VARCHAR2,
1135 p_ATTRIBUTE3 VARCHAR2,
1136 p_ATTRIBUTE4 VARCHAR2,
1137 p_ATTRIBUTE5 VARCHAR2,
1138 p_ATTRIBUTE6 VARCHAR2,
1139 p_ATTRIBUTE7 VARCHAR2,
1140 p_ATTRIBUTE8 VARCHAR2,
1141 p_ATTRIBUTE9 VARCHAR2,
1142 p_ATTRIBUTE10 VARCHAR2,
1143 p_ATTRIBUTE11 VARCHAR2,
1144 p_ATTRIBUTE12 VARCHAR2,
1145 p_ATTRIBUTE13 VARCHAR2,
1146 p_ATTRIBUTE14 VARCHAR2,
1147 p_ATTRIBUTE15 VARCHAR2,
1148 p_MOVEMENT_ID NUMBER,
1149 p_RESERVATION_QUANTITY NUMBER,
1150 p_SHIPPED_QUANTITY NUMBER,
1151 p_TRANSACTION_LINE_NUMBER NUMBER,
1152 p_TASK_ID NUMBER,
1153 p_TO_TASK_ID NUMBER,
1154 p_SOURCE_TASK_ID NUMBER,
1155 p_PROJECT_ID NUMBER,
1156 p_SOURCE_PROJECT_ID NUMBER,
1157 p_PA_EXPENDITURE_ORG_ID NUMBER,
1158 p_TO_PROJECT_ID NUMBER,
1159 p_EXPENDITURE_TYPE VARCHAR2,
1160 p_FINAL_COMPLETION_FLAG VARCHAR2,
1161 p_TRANSFER_PERCENTAGE NUMBER,
1162 p_TRANSACTION_SEQUENCE_ID NUMBER,
1163 p_MATERIAL_ACCOUNT NUMBER,
1164 p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
1165 p_RESOURCE_ACCOUNT NUMBER,
1166 p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
1167 p_OVERHEAD_ACCOUNT NUMBER,
1168 p_FLOW_SCHEDULE VARCHAR2,
1169 p_COST_GROUP_ID NUMBER,
1170 p_DEMAND_CLASS VARCHAR2,
1171 p_QA_COLLECTION_ID NUMBER,
1172 p_KANBAN_CARD_ID NUMBER,
1173 p_OVERCOMPLETION_TXN_ID NUMBER,
1174 p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
1175 p_OVERCOMPLETION_TXN_QTY NUMBER,
1176 -- p_PROCESS_TYPE NUMBER,
1177 p_END_ITEM_UNIT_NUMBER VARCHAR2,
1178 p_SCHEDULED_PAYBACK_DATE DATE,
1179 p_LINE_TYPE_CODE NUMBER,
1180 p_PARENT_TRANSACTION_TEMP_ID NUMBER,
1181 p_PUT_AWAY_STRATEGY_ID NUMBER,
1182 p_PUT_AWAY_RULE_ID NUMBER,
1183 p_PICK_STRATEGY_ID NUMBER,
1184 p_PICK_RULE_ID NUMBER,
1185 p_COMMON_BOM_SEQ_ID NUMBER,
1186 p_COMMON_ROUTING_SEQ_ID NUMBER,
1187 p_COST_TYPE_ID NUMBER,
1188 p_ORG_COST_GROUP_ID NUMBER,
1189 p_MOVE_ORDER_LINE_ID NUMBER,
1190 p_TASK_GROUP_ID NUMBER,
1191 p_PICK_SLIP_NUMBER NUMBER,
1192 p_RESERVATION_ID NUMBER,
1193 p_TRANSACTION_STATUS NUMBER,
1194 P_STANDARD_OPERATION_ID NUMBER,
1195 P_TASK_PRIORITY NUMBER,
1196 p_WMS_TASK_TYPE NUMBER,
1197 p_PARENT_LINE_ID NUMBER)
1198 -- P_SOURCE_LOT_NUMBER NUMBER)
1199
1200 IS
1201 CURSOR C IS
1202 SELECT *
1203 FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1204 WHERE TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID
1205 FOR UPDATE of TRANSACTION_TEMP_ID NOWAIT;
1206 Recinfo C%ROWTYPE;
1207 BEGIN
1208 OPEN C;
1209 FETCH C INTO Recinfo;
1210 If (C%NOTFOUND) then
1211 CLOSE C;
1212 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1213 APP_EXCEPTION.RAISE_EXCEPTION;
1214 End If;
1215 CLOSE C;
1216
1217 if (
1218 ( ( Recinfo.TRANSACTION_HEADER_ID = p_TRANSACTION_HEADER_ID)
1219 OR ( ( Recinfo.TRANSACTION_HEADER_ID IS NULL )
1220 AND ( p_TRANSACTION_HEADER_ID IS NULL )))
1221 AND
1222 ( ( Recinfo.TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID)
1223 OR ( ( Recinfo.TRANSACTION_TEMP_ID IS NULL )
1224 AND ( p_TRANSACTION_TEMP_ID IS NULL )))
1225 AND ( ( Recinfo.SOURCE_CODE = p_SOURCE_CODE)
1226 OR ( ( Recinfo.SOURCE_CODE IS NULL )
1227 AND ( p_SOURCE_CODE IS NULL )))
1228 AND ( ( Recinfo.SOURCE_LINE_ID = p_SOURCE_LINE_ID)
1229 OR ( ( Recinfo.SOURCE_LINE_ID IS NULL )
1230 AND ( p_SOURCE_LINE_ID IS NULL )))
1231 AND ( ( Recinfo.TRANSACTION_MODE = p_TRANSACTION_MODE)
1235 OR ( ( Recinfo.LOCK_FLAG IS NULL )
1232 OR ( ( Recinfo.TRANSACTION_MODE IS NULL )
1233 AND ( p_TRANSACTION_MODE IS NULL )))
1234 AND ( ( Recinfo.LOCK_FLAG = p_LOCK_FLAG)
1236 AND ( p_LOCK_FLAG IS NULL )))
1237 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
1238 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
1239 AND ( p_LAST_UPDATE_DATE IS NULL )))
1240 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
1241 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
1242 AND ( p_LAST_UPDATED_BY IS NULL )))
1243 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
1244 OR ( ( Recinfo.CREATION_DATE IS NULL )
1245 AND ( p_CREATION_DATE IS NULL )))
1246 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
1247 OR ( ( Recinfo.CREATED_BY IS NULL )
1248 AND ( p_CREATED_BY IS NULL )))
1249 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
1250 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
1251 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
1252 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
1253 OR ( ( Recinfo.REQUEST_ID IS NULL )
1254 AND ( p_REQUEST_ID IS NULL )))
1255 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
1256 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
1257 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
1258 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
1259 OR ( ( Recinfo.PROGRAM_ID IS NULL )
1260 AND ( p_PROGRAM_ID IS NULL )))
1261 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
1262 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
1263 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
1264 AND ( ( Recinfo.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID)
1265 OR ( ( Recinfo.INVENTORY_ITEM_ID IS NULL )
1266 AND ( p_INVENTORY_ITEM_ID IS NULL )))
1267 AND ( ( Recinfo.REVISION = p_REVISION)
1268 OR ( ( Recinfo.REVISION IS NULL )
1269 AND ( p_REVISION IS NULL )))
1270 AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
1271 OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
1272 AND ( p_ORGANIZATION_ID IS NULL )))
1273 AND ( ( Recinfo.SUBINVENTORY_CODE = p_SUBINVENTORY_CODE)
1274 OR ( ( Recinfo.SUBINVENTORY_CODE IS NULL )
1275 AND ( p_SUBINVENTORY_CODE IS NULL )))
1276 AND ( ( Recinfo.LOCATOR_ID = p_LOCATOR_ID)
1277 OR ( ( Recinfo.LOCATOR_ID IS NULL )
1278 AND ( p_LOCATOR_ID IS NULL )))
1279 AND ( ( Recinfo.TRANSACTION_QUANTITY = p_TRANSACTION_QUANTITY)
1280 OR ( ( Recinfo.TRANSACTION_QUANTITY IS NULL )
1281 AND ( p_TRANSACTION_QUANTITY IS NULL )))
1282 AND ( ( Recinfo.PRIMARY_QUANTITY = p_PRIMARY_QUANTITY)
1283 OR ( ( Recinfo.PRIMARY_QUANTITY IS NULL )
1284 AND ( p_PRIMARY_QUANTITY IS NULL )))
1285 AND ( ( Recinfo.TRANSACTION_UOM = p_TRANSACTION_UOM)
1286 OR ( ( Recinfo.TRANSACTION_UOM IS NULL )
1287 AND ( p_TRANSACTION_UOM IS NULL )))
1288 AND ( ( Recinfo.TRANSACTION_COST = p_TRANSACTION_COST)
1289 OR ( ( Recinfo.TRANSACTION_COST IS NULL )
1290 AND ( p_TRANSACTION_COST IS NULL )))
1291 AND ( ( Recinfo.TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID)
1292 OR ( ( Recinfo.TRANSACTION_TYPE_ID IS NULL )
1293 AND ( p_TRANSACTION_TYPE_ID IS NULL )))
1294 AND ( ( Recinfo.TRANSACTION_ACTION_ID = p_TRANSACTION_ACTION_ID)
1295 OR ( ( Recinfo.TRANSACTION_ACTION_ID IS NULL )
1296 AND ( p_TRANSACTION_ACTION_ID IS NULL )))
1297 AND ( ( Recinfo.TRANSACTION_SOURCE_TYPE_ID = p_TRANSACTION_SOURCE_TYPE_ID)
1298 OR ( ( Recinfo.TRANSACTION_SOURCE_TYPE_ID IS NULL )
1299 AND ( p_TRANSACTION_SOURCE_TYPE_ID IS NULL )))
1300 AND ( ( Recinfo.TRANSACTION_SOURCE_ID = p_TRANSACTION_SOURCE_ID)
1301 OR ( ( Recinfo.TRANSACTION_SOURCE_ID IS NULL )
1302 AND ( p_TRANSACTION_SOURCE_ID IS NULL )))
1303 AND ( ( Recinfo.TRANSACTION_SOURCE_NAME = p_TRANSACTION_SOURCE_NAME)
1304 OR ( ( Recinfo.TRANSACTION_SOURCE_NAME IS NULL )
1305 AND ( p_TRANSACTION_SOURCE_NAME IS NULL )))
1306 AND ( ( Recinfo.TRANSACTION_DATE = p_TRANSACTION_DATE)
1307 OR ( ( Recinfo.TRANSACTION_DATE IS NULL )
1308 AND ( p_TRANSACTION_DATE IS NULL )))
1309 AND ( ( Recinfo.ACCT_PERIOD_ID = p_ACCT_PERIOD_ID)
1310 OR ( ( Recinfo.ACCT_PERIOD_ID IS NULL )
1311 AND ( p_ACCT_PERIOD_ID IS NULL )))
1312 AND ( ( Recinfo.DISTRIBUTION_ACCOUNT_ID = p_DISTRIBUTION_ACCOUNT_ID)
1313 OR ( ( Recinfo.DISTRIBUTION_ACCOUNT_ID IS NULL )
1314 AND ( p_DISTRIBUTION_ACCOUNT_ID IS NULL )))
1315 AND ( ( Recinfo.TRANSACTION_REFERENCE = p_TRANSACTION_REFERENCE)
1316 OR ( ( Recinfo.TRANSACTION_REFERENCE IS NULL )
1317 AND ( p_TRANSACTION_REFERENCE IS NULL )))
1318 AND ( ( Recinfo.REQUISITION_LINE_ID = p_REQUISITION_LINE_ID)
1319 OR ( ( Recinfo.REQUISITION_LINE_ID IS NULL )
1320 AND ( p_REQUISITION_LINE_ID IS NULL )))
1321 AND ( ( Recinfo.REQUISITION_DISTRIBUTION_ID = p_REQUISITION_DISTRIBUTION_ID)
1322 OR ( ( Recinfo.REQUISITION_DISTRIBUTION_ID IS NULL )
1323 AND ( p_REQUISITION_DISTRIBUTION_ID IS NULL )))
1324 AND ( ( Recinfo.REASON_ID = p_REASON_ID)
1325 OR ( ( Recinfo.REASON_ID IS NULL )
1326 AND ( p_REASON_ID IS NULL )))
1327 AND ( ( Recinfo.LOT_NUMBER = p_LOT_NUMBER)
1328 OR ( ( Recinfo.LOT_NUMBER IS NULL )
1329 AND ( p_LOT_NUMBER IS NULL )))
1333 AND ( ( Recinfo.SERIAL_NUMBER = p_SERIAL_NUMBER)
1330 AND ( ( Recinfo.LOT_EXPIRATION_DATE = p_LOT_EXPIRATION_DATE)
1331 OR ( ( Recinfo.LOT_EXPIRATION_DATE IS NULL )
1332 AND ( p_LOT_EXPIRATION_DATE IS NULL )))
1334 OR ( ( Recinfo.SERIAL_NUMBER IS NULL )
1335 AND ( p_SERIAL_NUMBER IS NULL )))
1336 AND ( ( Recinfo.RECEIVING_DOCUMENT = p_RECEIVING_DOCUMENT)
1337 OR ( ( Recinfo.RECEIVING_DOCUMENT IS NULL )
1338 AND ( p_RECEIVING_DOCUMENT IS NULL )))
1339 AND ( ( Recinfo.DEMAND_ID = p_DEMAND_ID)
1340 OR ( ( Recinfo.DEMAND_ID IS NULL )
1341 AND ( p_DEMAND_ID IS NULL )))
1342 AND ( ( Recinfo.RCV_TRANSACTION_ID = p_RCV_TRANSACTION_ID)
1343 OR ( ( Recinfo.RCV_TRANSACTION_ID IS NULL )
1344 AND ( p_RCV_TRANSACTION_ID IS NULL )))
1345 AND ( ( Recinfo.MOVE_TRANSACTION_ID = p_MOVE_TRANSACTION_ID)
1346 OR ( ( Recinfo.MOVE_TRANSACTION_ID IS NULL )
1347 AND ( p_MOVE_TRANSACTION_ID IS NULL )))
1348 AND ( ( Recinfo.COMPLETION_TRANSACTION_ID = p_COMPLETION_TRANSACTION_ID)
1349 OR ( ( Recinfo.COMPLETION_TRANSACTION_ID IS NULL )
1350 AND ( p_COMPLETION_TRANSACTION_ID IS NULL )))
1351 AND ( ( Recinfo.WIP_ENTITY_TYPE = p_WIP_ENTITY_TYPE)
1352 OR ( ( Recinfo.WIP_ENTITY_TYPE IS NULL )
1353 AND ( p_WIP_ENTITY_TYPE IS NULL )))
1354 AND ( ( Recinfo.SCHEDULE_ID = p_SCHEDULE_ID)
1355 OR ( ( Recinfo.SCHEDULE_ID IS NULL )
1356 AND ( p_SCHEDULE_ID IS NULL )))
1357 AND ( ( Recinfo.REPETITIVE_LINE_ID = p_REPETITIVE_LINE_ID)
1358 OR ( ( Recinfo.REPETITIVE_LINE_ID IS NULL )
1359 AND ( p_REPETITIVE_LINE_ID IS NULL )))
1360 AND ( ( Recinfo.EMPLOYEE_CODE = p_EMPLOYEE_CODE)
1361 OR ( ( Recinfo.EMPLOYEE_CODE IS NULL )
1362 AND ( p_EMPLOYEE_CODE IS NULL )))
1363 AND ( ( Recinfo.PRIMARY_SWITCH = p_PRIMARY_SWITCH)
1364 OR ( ( Recinfo.PRIMARY_SWITCH IS NULL )
1365 AND ( p_PRIMARY_SWITCH IS NULL )))
1366 AND ( ( Recinfo.SCHEDULE_UPDATE_CODE = p_SCHEDULE_UPDATE_CODE)
1367 OR ( ( Recinfo.SCHEDULE_UPDATE_CODE IS NULL )
1368 AND ( p_SCHEDULE_UPDATE_CODE IS NULL )))
1369 AND ( ( Recinfo.SETUP_TEARDOWN_CODE = p_SETUP_TEARDOWN_CODE)
1370 OR ( ( Recinfo.SETUP_TEARDOWN_CODE IS NULL )
1371 AND ( p_SETUP_TEARDOWN_CODE IS NULL )))
1372 AND ( ( Recinfo.ITEM_ORDERING = p_ITEM_ORDERING)
1373 OR ( ( Recinfo.ITEM_ORDERING IS NULL )
1374 AND ( p_ITEM_ORDERING IS NULL )))
1375 AND ( ( Recinfo.NEGATIVE_REQ_FLAG = p_NEGATIVE_REQ_FLAG)
1376 OR ( ( Recinfo.NEGATIVE_REQ_FLAG IS NULL )
1377 AND ( p_NEGATIVE_REQ_FLAG IS NULL )))
1378 AND ( ( Recinfo.OPERATION_SEQ_NUM = p_OPERATION_SEQ_NUM)
1379 OR ( ( Recinfo.OPERATION_SEQ_NUM IS NULL )
1380 AND ( p_OPERATION_SEQ_NUM IS NULL )))
1381 AND ( ( Recinfo.PICKING_LINE_ID = p_PICKING_LINE_ID)
1382 OR ( ( Recinfo.PICKING_LINE_ID IS NULL )
1383 AND ( p_PICKING_LINE_ID IS NULL )))
1384 AND ( ( Recinfo.TRX_SOURCE_LINE_ID = p_TRX_SOURCE_LINE_ID)
1385 OR ( ( Recinfo.TRX_SOURCE_LINE_ID IS NULL )
1386 AND ( p_TRX_SOURCE_LINE_ID IS NULL )))
1387 AND ( ( Recinfo.TRX_SOURCE_DELIVERY_ID = p_TRX_SOURCE_DELIVERY_ID)
1388 OR ( ( Recinfo.TRX_SOURCE_DELIVERY_ID IS NULL )
1389 AND ( p_TRX_SOURCE_DELIVERY_ID IS NULL )))
1390 AND ( ( Recinfo.PHYSICAL_ADJUSTMENT_ID = p_PHYSICAL_ADJUSTMENT_ID)
1391 OR ( ( Recinfo.PHYSICAL_ADJUSTMENT_ID IS NULL )
1392 AND ( p_PHYSICAL_ADJUSTMENT_ID IS NULL )))
1393 AND ( ( Recinfo.CYCLE_COUNT_ID = p_CYCLE_COUNT_ID)
1394 OR ( ( Recinfo.CYCLE_COUNT_ID IS NULL )
1395 AND ( p_CYCLE_COUNT_ID IS NULL )))
1396 AND ( ( Recinfo.RMA_LINE_ID = p_RMA_LINE_ID)
1397 OR ( ( Recinfo.RMA_LINE_ID IS NULL )
1398 AND ( p_RMA_LINE_ID IS NULL )))
1399 AND ( ( Recinfo.CUSTOMER_SHIP_ID = p_CUSTOMER_SHIP_ID)
1400 OR ( ( Recinfo.CUSTOMER_SHIP_ID IS NULL )
1401 AND ( p_CUSTOMER_SHIP_ID IS NULL )))
1402 AND ( ( Recinfo.CURRENCY_CODE = p_CURRENCY_CODE)
1403 OR ( ( Recinfo.CURRENCY_CODE IS NULL )
1404 AND ( p_CURRENCY_CODE IS NULL )))
1405 AND ( ( Recinfo.CURRENCY_CONVERSION_RATE = p_CURRENCY_CONVERSION_RATE)
1406 OR ( ( Recinfo.CURRENCY_CONVERSION_RATE IS NULL )
1407 AND ( p_CURRENCY_CONVERSION_RATE IS NULL )))
1408 AND ( ( Recinfo.CURRENCY_CONVERSION_TYPE = p_CURRENCY_CONVERSION_TYPE)
1409 OR ( ( Recinfo.CURRENCY_CONVERSION_TYPE IS NULL )
1410 AND ( p_CURRENCY_CONVERSION_TYPE IS NULL )))
1411 AND ( ( Recinfo.CURRENCY_CONVERSION_DATE = p_CURRENCY_CONVERSION_DATE)
1412 OR ( ( Recinfo.CURRENCY_CONVERSION_DATE IS NULL )
1413 AND ( p_CURRENCY_CONVERSION_DATE IS NULL )))
1414 AND ( ( Recinfo.USSGL_TRANSACTION_CODE = p_USSGL_TRANSACTION_CODE)
1415 OR ( ( Recinfo.USSGL_TRANSACTION_CODE IS NULL )
1416 AND ( p_USSGL_TRANSACTION_CODE IS NULL )))
1417 AND ( ( Recinfo.VENDOR_LOT_NUMBER = p_VENDOR_LOT_NUMBER)
1418 OR ( ( Recinfo.VENDOR_LOT_NUMBER IS NULL )
1419 AND ( p_VENDOR_LOT_NUMBER IS NULL )))
1420 AND ( ( Recinfo.ENCUMBRANCE_ACCOUNT = p_ENCUMBRANCE_ACCOUNT)
1421 OR ( ( Recinfo.ENCUMBRANCE_ACCOUNT IS NULL )
1422 AND ( p_ENCUMBRANCE_ACCOUNT IS NULL )))
1423 AND ( ( Recinfo.ENCUMBRANCE_AMOUNT = p_ENCUMBRANCE_AMOUNT)
1424 OR ( ( Recinfo.ENCUMBRANCE_AMOUNT IS NULL )
1425 AND ( p_ENCUMBRANCE_AMOUNT IS NULL )))
1429 AND ( ( Recinfo.SHIPMENT_NUMBER = p_SHIPMENT_NUMBER)
1426 AND ( ( Recinfo.SHIP_TO_LOCATION = p_SHIP_TO_LOCATION)
1427 OR ( ( Recinfo.SHIP_TO_LOCATION IS NULL )
1428 AND ( p_SHIP_TO_LOCATION IS NULL )))
1430 OR ( ( Recinfo.SHIPMENT_NUMBER IS NULL )
1431 AND ( p_SHIPMENT_NUMBER IS NULL )))
1432 AND ( ( Recinfo.TRANSFER_COST = p_TRANSFER_COST)
1433 OR ( ( Recinfo.TRANSFER_COST IS NULL )
1434 AND ( p_TRANSFER_COST IS NULL )))
1435 AND ( ( Recinfo.TRANSPORTATION_COST = p_TRANSPORTATION_COST)
1436 OR ( ( Recinfo.TRANSPORTATION_COST IS NULL )
1437 AND ( p_TRANSPORTATION_COST IS NULL )))
1438 AND ( ( Recinfo.TRANSPORTATION_ACCOUNT = p_TRANSPORTATION_ACCOUNT)
1439 OR ( ( Recinfo.TRANSPORTATION_ACCOUNT IS NULL )
1440 AND ( p_TRANSPORTATION_ACCOUNT IS NULL )))
1441 AND ( ( Recinfo.FREIGHT_CODE = p_FREIGHT_CODE)
1442 OR ( ( Recinfo.FREIGHT_CODE IS NULL )
1443 AND ( p_FREIGHT_CODE IS NULL )))
1444 AND ( ( Recinfo.CONTAINERS = p_CONTAINERS)
1445 OR ( ( Recinfo.CONTAINERS IS NULL )
1446 AND ( p_CONTAINERS IS NULL )))
1447 AND ( ( Recinfo.WAYBILL_AIRBILL = p_WAYBILL_AIRBILL)
1448 OR ( ( Recinfo.WAYBILL_AIRBILL IS NULL )
1449 AND ( p_WAYBILL_AIRBILL IS NULL )))
1450 AND ( ( Recinfo.EXPECTED_ARRIVAL_DATE = p_EXPECTED_ARRIVAL_DATE)
1451 OR ( ( Recinfo.EXPECTED_ARRIVAL_DATE IS NULL )
1452 AND ( p_EXPECTED_ARRIVAL_DATE IS NULL )))
1453 AND ( ( Recinfo.TRANSFER_SUBINVENTORY = p_TRANSFER_SUBINVENTORY)
1454 OR ( ( Recinfo.TRANSFER_SUBINVENTORY IS NULL )
1455 AND ( p_TRANSFER_SUBINVENTORY IS NULL )))
1456 AND ( ( Recinfo.TRANSFER_ORGANIZATION = p_TRANSFER_ORGANIZATION)
1457 OR ( ( Recinfo.TRANSFER_ORGANIZATION IS NULL )
1458 AND ( p_TRANSFER_ORGANIZATION IS NULL )))
1459 AND ( ( Recinfo.TRANSFER_TO_LOCATION = p_TRANSFER_TO_LOCATION)
1460 OR ( ( Recinfo.TRANSFER_TO_LOCATION IS NULL )
1461 AND ( p_TRANSFER_TO_LOCATION IS NULL )))
1462 AND ( ( Recinfo.NEW_AVERAGE_COST = p_NEW_AVERAGE_COST)
1463 OR ( ( Recinfo.NEW_AVERAGE_COST IS NULL )
1464 AND ( p_NEW_AVERAGE_COST IS NULL )))
1465 AND ( ( Recinfo.VALUE_CHANGE = p_VALUE_CHANGE)
1466 OR ( ( Recinfo.VALUE_CHANGE IS NULL )
1467 AND ( p_VALUE_CHANGE IS NULL )))
1468 AND ( ( Recinfo.PERCENTAGE_CHANGE = p_PERCENTAGE_CHANGE)
1469 OR ( ( Recinfo.PERCENTAGE_CHANGE IS NULL )
1470 AND ( p_PERCENTAGE_CHANGE IS NULL )))
1471 AND ( ( Recinfo.MATERIAL_ALLOCATION_TEMP_ID = p_MATERIAL_ALLOCATION_TEMP_ID)
1472 OR ( ( Recinfo.MATERIAL_ALLOCATION_TEMP_ID IS NULL )
1473 AND ( p_MATERIAL_ALLOCATION_TEMP_ID IS NULL )))
1474 AND ( ( Recinfo.DEMAND_SOURCE_HEADER_ID = p_DEMAND_SOURCE_HEADER_ID)
1475 OR ( ( Recinfo.DEMAND_SOURCE_HEADER_ID IS NULL )
1476 AND ( p_DEMAND_SOURCE_HEADER_ID IS NULL )))
1477 AND ( ( Recinfo.DEMAND_SOURCE_LINE = p_DEMAND_SOURCE_LINE)
1478 OR ( ( Recinfo.DEMAND_SOURCE_LINE IS NULL )
1479 AND ( p_DEMAND_SOURCE_LINE IS NULL )))
1480 AND ( ( Recinfo.DEMAND_SOURCE_DELIVERY = p_DEMAND_SOURCE_DELIVERY)
1481 OR ( ( Recinfo.DEMAND_SOURCE_DELIVERY IS NULL )
1482 AND ( p_DEMAND_SOURCE_DELIVERY IS NULL )))
1483 AND ( ( Recinfo.ITEM_SEGMENTS = p_ITEM_SEGMENTS)
1484 OR ( ( Recinfo.ITEM_SEGMENTS IS NULL )
1485 AND ( p_ITEM_SEGMENTS IS NULL )))
1486 AND ( ( Recinfo.ITEM_DESCRIPTION = p_ITEM_DESCRIPTION)
1487 OR ( ( Recinfo.ITEM_DESCRIPTION IS NULL )
1488 AND ( p_ITEM_DESCRIPTION IS NULL )))
1489 AND ( ( Recinfo.ITEM_TRX_ENABLED_FLAG = p_ITEM_TRX_ENABLED_FLAG)
1490 OR ( ( Recinfo.ITEM_TRX_ENABLED_FLAG IS NULL )
1491 AND ( p_ITEM_TRX_ENABLED_FLAG IS NULL )))
1492 AND ( ( Recinfo.ITEM_LOCATION_CONTROL_CODE = p_ITEM_LOCATION_CONTROL_CODE)
1493 OR ( ( Recinfo.ITEM_LOCATION_CONTROL_CODE IS NULL )
1494 AND ( p_ITEM_LOCATION_CONTROL_CODE IS NULL )))
1495 AND ( ( Recinfo.ITEM_RESTRICT_SUBINV_CODE = p_ITEM_RESTRICT_SUBINV_CODE)
1496 OR ( ( Recinfo.ITEM_RESTRICT_SUBINV_CODE IS NULL )
1497 AND ( p_ITEM_RESTRICT_SUBINV_CODE IS NULL )))
1498 AND ( ( Recinfo.ITEM_RESTRICT_LOCATORS_CODE = p_ITEM_RESTRICT_LOCATORS_CODE)
1499 OR ( ( Recinfo.ITEM_RESTRICT_LOCATORS_CODE IS NULL )
1500 AND ( p_ITEM_RESTRICT_LOCATORS_CODE IS NULL )))
1501 AND ( ( Recinfo.ITEM_REVISION_QTY_CONTROL_CODE = p_ITEM_REV_QTY_CONTROL_CODE)
1502 OR ( ( Recinfo.ITEM_REVISION_QTY_CONTROL_CODE IS NULL )
1503 AND ( p_ITEM_REV_QTY_CONTROL_CODE IS NULL )))
1504 AND ( ( Recinfo.ITEM_PRIMARY_UOM_CODE = p_ITEM_PRIMARY_UOM_CODE)
1505 OR ( ( Recinfo.ITEM_PRIMARY_UOM_CODE IS NULL )
1506 AND ( p_ITEM_PRIMARY_UOM_CODE IS NULL )))
1507 AND ( ( Recinfo.ITEM_UOM_CLASS = p_ITEM_UOM_CLASS)
1508 OR ( ( Recinfo.ITEM_UOM_CLASS IS NULL )
1509 AND ( p_ITEM_UOM_CLASS IS NULL )))
1510 AND ( ( Recinfo.ITEM_SHELF_LIFE_CODE = p_ITEM_SHELF_LIFE_CODE)
1511 OR ( ( Recinfo.ITEM_SHELF_LIFE_CODE IS NULL )
1512 AND ( p_ITEM_SHELF_LIFE_CODE IS NULL )))
1513 AND ( ( Recinfo.ITEM_SHELF_LIFE_DAYS = p_ITEM_SHELF_LIFE_DAYS)
1514 OR ( ( Recinfo.ITEM_SHELF_LIFE_DAYS IS NULL )
1515 AND ( p_ITEM_SHELF_LIFE_DAYS IS NULL )))
1516 AND ( ( Recinfo.ITEM_LOT_CONTROL_CODE = p_ITEM_LOT_CONTROL_CODE)
1517 OR ( ( Recinfo.ITEM_LOT_CONTROL_CODE IS NULL )
1518 AND ( p_ITEM_LOT_CONTROL_CODE IS NULL )))
1522 AND ( ( Recinfo.ITEM_INVENTORY_ASSET_FLAG = p_ITEM_INVENTORY_ASSET_FLAG)
1519 AND ( ( Recinfo.ITEM_SERIAL_CONTROL_CODE = p_ITEM_SERIAL_CONTROL_CODE)
1520 OR ( ( Recinfo.ITEM_SERIAL_CONTROL_CODE IS NULL )
1521 AND ( p_ITEM_SERIAL_CONTROL_CODE IS NULL )))
1523 OR ( ( Recinfo.ITEM_INVENTORY_ASSET_FLAG IS NULL )
1524 AND ( p_ITEM_INVENTORY_ASSET_FLAG IS NULL )))
1525 AND ( ( Recinfo.ALLOWED_UNITS_LOOKUP_CODE = p_ALLOWED_UNITS_LOOKUP_CODE)
1526 OR ( ( Recinfo.ALLOWED_UNITS_LOOKUP_CODE IS NULL )
1527 AND ( p_ALLOWED_UNITS_LOOKUP_CODE IS NULL )))
1528 AND ( ( Recinfo.DEPARTMENT_ID = p_DEPARTMENT_ID)
1529 OR ( ( Recinfo.DEPARTMENT_ID IS NULL )
1530 AND ( p_DEPARTMENT_ID IS NULL )))
1531 AND ( ( Recinfo.DEPARTMENT_CODE = p_DEPARTMENT_CODE)
1532 OR ( ( Recinfo.DEPARTMENT_CODE IS NULL )
1533 AND ( p_DEPARTMENT_CODE IS NULL )))
1534 AND ( ( Recinfo.WIP_SUPPLY_TYPE = p_WIP_SUPPLY_TYPE)
1535 OR ( ( Recinfo.WIP_SUPPLY_TYPE IS NULL )
1536 AND ( p_WIP_SUPPLY_TYPE IS NULL )))
1537 AND ( ( Recinfo.SUPPLY_SUBINVENTORY = p_SUPPLY_SUBINVENTORY)
1538 OR ( ( Recinfo.SUPPLY_SUBINVENTORY IS NULL )
1539 AND ( p_SUPPLY_SUBINVENTORY IS NULL )))
1540 AND ( ( Recinfo.SUPPLY_LOCATOR_ID = p_SUPPLY_LOCATOR_ID)
1541 OR ( ( Recinfo.SUPPLY_LOCATOR_ID IS NULL )
1542 AND ( p_SUPPLY_LOCATOR_ID IS NULL )))
1543 AND ( ( Recinfo.VALID_SUBINVENTORY_FLAG = p_VALID_SUBINVENTORY_FLAG)
1544 OR ( ( Recinfo.VALID_SUBINVENTORY_FLAG IS NULL )
1545 AND ( p_VALID_SUBINVENTORY_FLAG IS NULL )))
1546 AND ( ( Recinfo.VALID_LOCATOR_FLAG = p_VALID_LOCATOR_FLAG)
1547 OR ( ( Recinfo.VALID_LOCATOR_FLAG IS NULL )
1548 AND ( p_VALID_LOCATOR_FLAG IS NULL )))
1549 AND ( ( Recinfo.LOCATOR_SEGMENTS = p_LOCATOR_SEGMENTS)
1550 OR ( ( Recinfo.LOCATOR_SEGMENTS IS NULL )
1551 AND ( p_LOCATOR_SEGMENTS IS NULL )))
1552 AND ( ( Recinfo.CURRENT_LOCATOR_CONTROL_CODE = p_CURRENT_LOCATOR_CONTROL_CODE)
1553 OR ( ( Recinfo.CURRENT_LOCATOR_CONTROL_CODE IS NULL )
1554 AND ( p_CURRENT_LOCATOR_CONTROL_CODE IS NULL )))
1555 AND ( ( Recinfo.NUMBER_OF_LOTS_ENTERED = p_NUMBER_OF_LOTS_ENTERED)
1556 OR ( ( Recinfo.NUMBER_OF_LOTS_ENTERED IS NULL )
1557 AND ( p_NUMBER_OF_LOTS_ENTERED IS NULL )))
1558 AND ( ( Recinfo.WIP_COMMIT_FLAG = p_WIP_COMMIT_FLAG)
1559 OR ( ( Recinfo.WIP_COMMIT_FLAG IS NULL )
1560 AND ( p_WIP_COMMIT_FLAG IS NULL )))
1561 AND ( ( Recinfo.NEXT_LOT_NUMBER = p_NEXT_LOT_NUMBER)
1562 OR ( ( Recinfo.NEXT_LOT_NUMBER IS NULL )
1563 AND ( p_NEXT_LOT_NUMBER IS NULL )))
1564 AND ( ( Recinfo.LOT_ALPHA_PREFIX = p_LOT_ALPHA_PREFIX)
1565 OR ( ( Recinfo.LOT_ALPHA_PREFIX IS NULL )
1566 AND ( p_LOT_ALPHA_PREFIX IS NULL )))
1567 AND ( ( Recinfo.NEXT_SERIAL_NUMBER = p_NEXT_SERIAL_NUMBER)
1568 OR ( ( Recinfo.NEXT_SERIAL_NUMBER IS NULL )
1569 AND ( p_NEXT_SERIAL_NUMBER IS NULL )))
1570 AND ( ( Recinfo.SERIAL_ALPHA_PREFIX = p_SERIAL_ALPHA_PREFIX)
1571 OR ( ( Recinfo.SERIAL_ALPHA_PREFIX IS NULL )
1572 AND ( p_SERIAL_ALPHA_PREFIX IS NULL )))
1573 AND ( ( Recinfo.SHIPPABLE_FLAG = p_SHIPPABLE_FLAG)
1574 OR ( ( Recinfo.SHIPPABLE_FLAG IS NULL )
1575 AND ( p_SHIPPABLE_FLAG IS NULL )))
1576 AND ( ( Recinfo.POSTING_FLAG = p_POSTING_FLAG)
1577 OR ( ( Recinfo.POSTING_FLAG IS NULL )
1578 AND ( p_POSTING_FLAG IS NULL )))
1579 AND ( ( Recinfo.REQUIRED_FLAG = p_REQUIRED_FLAG)
1580 OR ( ( Recinfo.REQUIRED_FLAG IS NULL )
1581 AND ( p_REQUIRED_FLAG IS NULL )))
1582 AND ( ( Recinfo.PROCESS_FLAG = p_PROCESS_FLAG)
1583 OR ( ( Recinfo.PROCESS_FLAG IS NULL )
1584 AND ( p_PROCESS_FLAG IS NULL )))
1585 AND ( ( Recinfo.ERROR_CODE = p_ERROR_CODE)
1586 OR ( ( Recinfo.ERROR_CODE IS NULL )
1587 AND ( p_ERROR_CODE IS NULL )))
1588 AND ( ( Recinfo.ERROR_EXPLANATION = p_ERROR_EXPLANATION)
1589 OR ( ( Recinfo.ERROR_EXPLANATION IS NULL )
1590 AND ( p_ERROR_EXPLANATION IS NULL )))
1591 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
1592 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
1593 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
1594 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
1595 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
1596 AND ( p_ATTRIBUTE1 IS NULL )))
1597 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
1598 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
1599 AND ( p_ATTRIBUTE2 IS NULL )))
1600 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
1601 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
1602 AND ( p_ATTRIBUTE3 IS NULL )))
1603 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
1604 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
1605 AND ( p_ATTRIBUTE4 IS NULL )))
1606 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
1607 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
1608 AND ( p_ATTRIBUTE5 IS NULL )))
1609 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
1610 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
1611 AND ( p_ATTRIBUTE6 IS NULL )))
1612 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
1613 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
1614 AND ( p_ATTRIBUTE7 IS NULL )))
1615 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
1616 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
1617 AND ( p_ATTRIBUTE8 IS NULL )))
1621 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
1618 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
1619 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
1620 AND ( p_ATTRIBUTE9 IS NULL )))
1622 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
1623 AND ( p_ATTRIBUTE10 IS NULL )))
1624 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
1625 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
1626 AND ( p_ATTRIBUTE11 IS NULL )))
1627 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
1628 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
1629 AND ( p_ATTRIBUTE12 IS NULL )))
1630 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
1631 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
1632 AND ( p_ATTRIBUTE13 IS NULL )))
1633 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
1634 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
1635 AND ( p_ATTRIBUTE14 IS NULL )))
1636 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
1637 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
1638 AND ( p_ATTRIBUTE15 IS NULL )))
1639 AND ( ( Recinfo.MOVEMENT_ID = p_MOVEMENT_ID)
1640 OR ( ( Recinfo.MOVEMENT_ID IS NULL )
1641 AND ( p_MOVEMENT_ID IS NULL )))
1642 AND ( ( Recinfo.RESERVATION_QUANTITY = p_RESERVATION_QUANTITY)
1643 OR ( ( Recinfo.RESERVATION_QUANTITY IS NULL )
1644 AND ( p_RESERVATION_QUANTITY IS NULL )))
1645 AND ( ( Recinfo.SHIPPED_QUANTITY = p_SHIPPED_QUANTITY)
1646 OR ( ( Recinfo.SHIPPED_QUANTITY IS NULL )
1647 AND ( p_SHIPPED_QUANTITY IS NULL )))
1648 AND ( ( Recinfo.TRANSACTION_LINE_NUMBER = p_TRANSACTION_LINE_NUMBER)
1649 OR ( ( Recinfo.TRANSACTION_LINE_NUMBER IS NULL )
1650 AND ( p_TRANSACTION_LINE_NUMBER IS NULL )))
1651 AND ( ( Recinfo.TASK_ID = p_TASK_ID)
1652 OR ( ( Recinfo.TASK_ID IS NULL )
1653 AND ( p_TASK_ID IS NULL )))
1654 AND ( ( Recinfo.TO_TASK_ID = p_TO_TASK_ID)
1655 OR ( ( Recinfo.TO_TASK_ID IS NULL )
1656 AND ( p_TO_TASK_ID IS NULL )))
1657 AND ( ( Recinfo.SOURCE_TASK_ID = p_SOURCE_TASK_ID)
1658 OR ( ( Recinfo.SOURCE_TASK_ID IS NULL )
1659 AND ( p_SOURCE_TASK_ID IS NULL )))
1660 AND ( ( Recinfo.PROJECT_ID = p_PROJECT_ID)
1661 OR ( ( Recinfo.PROJECT_ID IS NULL )
1662 AND ( p_PROJECT_ID IS NULL )))
1663 AND ( ( Recinfo.SOURCE_PROJECT_ID = p_SOURCE_PROJECT_ID)
1664 OR ( ( Recinfo.SOURCE_PROJECT_ID IS NULL )
1665 AND ( p_SOURCE_PROJECT_ID IS NULL )))
1666 AND ( ( Recinfo.PA_EXPENDITURE_ORG_ID = p_PA_EXPENDITURE_ORG_ID)
1667 OR ( ( Recinfo.PA_EXPENDITURE_ORG_ID IS NULL )
1668 AND ( p_PA_EXPENDITURE_ORG_ID IS NULL )))
1669 AND ( ( Recinfo.TO_PROJECT_ID = p_TO_PROJECT_ID)
1670 OR ( ( Recinfo.TO_PROJECT_ID IS NULL )
1671 AND ( p_TO_PROJECT_ID IS NULL )))
1672 AND ( ( Recinfo.EXPENDITURE_TYPE = p_EXPENDITURE_TYPE)
1673 OR ( ( Recinfo.EXPENDITURE_TYPE IS NULL )
1674 AND ( p_EXPENDITURE_TYPE IS NULL )))
1675 AND ( ( Recinfo.FINAL_COMPLETION_FLAG = p_FINAL_COMPLETION_FLAG)
1676 OR ( ( Recinfo.FINAL_COMPLETION_FLAG IS NULL )
1677 AND ( p_FINAL_COMPLETION_FLAG IS NULL )))
1678 AND ( ( Recinfo.TRANSFER_PERCENTAGE = p_TRANSFER_PERCENTAGE)
1679 OR ( ( Recinfo.TRANSFER_PERCENTAGE IS NULL )
1680 AND ( p_TRANSFER_PERCENTAGE IS NULL )))
1681 AND ( ( Recinfo.TRANSACTION_SEQUENCE_ID = p_TRANSACTION_SEQUENCE_ID)
1682 OR ( ( Recinfo.TRANSACTION_SEQUENCE_ID IS NULL )
1683 AND ( p_TRANSACTION_SEQUENCE_ID IS NULL )))
1684 AND ( ( Recinfo.MATERIAL_ACCOUNT = p_MATERIAL_ACCOUNT)
1685 OR ( ( Recinfo.MATERIAL_ACCOUNT IS NULL )
1686 AND ( p_MATERIAL_ACCOUNT IS NULL )))
1687 AND ( ( Recinfo.MATERIAL_OVERHEAD_ACCOUNT = p_MATERIAL_OVERHEAD_ACCOUNT)
1688 OR ( ( Recinfo.MATERIAL_OVERHEAD_ACCOUNT IS NULL )
1689 AND ( p_MATERIAL_OVERHEAD_ACCOUNT IS NULL )))
1690 AND ( ( Recinfo.RESOURCE_ACCOUNT = p_RESOURCE_ACCOUNT)
1691 OR ( ( Recinfo.RESOURCE_ACCOUNT IS NULL )
1692 AND ( p_RESOURCE_ACCOUNT IS NULL )))
1693 AND ( ( Recinfo.OUTSIDE_PROCESSING_ACCOUNT = p_OUTSIDE_PROCESSING_ACCOUNT)
1694 OR ( ( Recinfo.OUTSIDE_PROCESSING_ACCOUNT IS NULL )
1695 AND ( p_OUTSIDE_PROCESSING_ACCOUNT IS NULL )))
1696 AND ( ( Recinfo.OVERHEAD_ACCOUNT = p_OVERHEAD_ACCOUNT)
1697 OR ( ( Recinfo.OVERHEAD_ACCOUNT IS NULL )
1698 AND ( p_OVERHEAD_ACCOUNT IS NULL )))
1699 AND ( ( Recinfo.FLOW_SCHEDULE = p_FLOW_SCHEDULE)
1700 OR ( ( Recinfo.FLOW_SCHEDULE IS NULL )
1701 AND ( p_FLOW_SCHEDULE IS NULL )))
1702 AND ( ( Recinfo.COST_GROUP_ID = p_COST_GROUP_ID)
1703 OR ( ( Recinfo.COST_GROUP_ID IS NULL )
1704 AND ( p_COST_GROUP_ID IS NULL )))
1705 AND ( ( Recinfo.DEMAND_CLASS = p_DEMAND_CLASS)
1706 OR ( ( Recinfo.DEMAND_CLASS IS NULL )
1707 AND ( p_DEMAND_CLASS IS NULL )))
1708 AND ( ( Recinfo.QA_COLLECTION_ID = p_QA_COLLECTION_ID)
1709 OR ( ( Recinfo.QA_COLLECTION_ID IS NULL )
1710 AND ( p_QA_COLLECTION_ID IS NULL )))
1711 AND ( ( Recinfo.KANBAN_CARD_ID = p_KANBAN_CARD_ID)
1712 OR ( ( Recinfo.KANBAN_CARD_ID IS NULL )
1713 AND ( p_KANBAN_CARD_ID IS NULL )))
1714 AND ( ( Recinfo.OVERCOMPLETION_TRANSACTION_ID = p_OVERCOMPLETION_TXN_ID)
1715 OR ( ( Recinfo.OVERCOMPLETION_TRANSACTION_ID IS NULL )
1716 AND ( p_OVERCOMPLETION_TXN_ID IS NULL )))
1717 AND ( ( Recinfo.OVERCOMPLETION_PRIMARY_QTY = p_OVERCOMPLETION_PRIMARY_QTY)
1718 OR ( ( Recinfo.OVERCOMPLETION_PRIMARY_QTY IS NULL )
1719 AND ( p_OVERCOMPLETION_PRIMARY_QTY IS NULL )))
1720 AND ( ( Recinfo.OVERCOMPLETION_TRANSACTION_QTY = p_OVERCOMPLETION_TXN_QTY)
1721 OR ( ( Recinfo.OVERCOMPLETION_TRANSACTION_QTY IS NULL )
1722 AND ( p_OVERCOMPLETION_TXN_QTY IS NULL )))
1723 /*AND ( ( Recinfo.PROCESS_TYPE = p_PROCESS_TYPE)
1724 OR ( ( Recinfo.PROCESS_TYPE IS NULL )
1725 AND ( p_PROCESS_TYPE IS NULL )))*/
1726 AND ( ( Recinfo.END_ITEM_UNIT_NUMBER = p_END_ITEM_UNIT_NUMBER)
1727 OR ( ( Recinfo.END_ITEM_UNIT_NUMBER IS NULL )
1728 AND ( p_END_ITEM_UNIT_NUMBER IS NULL )))
1729 AND ( ( Recinfo.SCHEDULED_PAYBACK_DATE = p_SCHEDULED_PAYBACK_DATE)
1730 OR ( ( Recinfo.SCHEDULED_PAYBACK_DATE IS NULL )
1731 AND ( p_SCHEDULED_PAYBACK_DATE IS NULL )))
1732 AND ( ( Recinfo.LINE_TYPE_CODE = p_LINE_TYPE_CODE)
1733 OR ( ( Recinfo.LINE_TYPE_CODE IS NULL )
1734 AND ( p_LINE_TYPE_CODE IS NULL )))
1735 AND ( ( Recinfo.PARENT_TRANSACTION_TEMP_ID = p_PARENT_TRANSACTION_TEMP_ID)
1736 OR ( ( Recinfo.PARENT_TRANSACTION_TEMP_ID IS NULL )
1737 AND ( p_PARENT_TRANSACTION_TEMP_ID IS NULL )))
1738 AND ( ( Recinfo.PUT_AWAY_STRATEGY_ID = p_PUT_AWAY_STRATEGY_ID)
1739 OR ( ( Recinfo.PUT_AWAY_STRATEGY_ID IS NULL )
1740 AND ( p_PUT_AWAY_STRATEGY_ID IS NULL )))
1741 AND ( ( Recinfo.PUT_AWAY_RULE_ID = p_PUT_AWAY_RULE_ID)
1742 OR ( ( Recinfo.PUT_AWAY_RULE_ID IS NULL )
1743 AND ( p_PUT_AWAY_RULE_ID IS NULL )))
1744 AND ( ( Recinfo.PICK_STRATEGY_ID = p_PICK_STRATEGY_ID)
1745 OR ( ( Recinfo.PICK_STRATEGY_ID IS NULL )
1746 AND ( p_PICK_STRATEGY_ID IS NULL )))
1747 AND ( ( Recinfo.PICK_RULE_ID = p_PICK_RULE_ID)
1748 OR ( ( Recinfo.PICK_RULE_ID IS NULL )
1749 AND ( p_PICK_RULE_ID IS NULL )))
1750 AND ( ( Recinfo.COMMON_BOM_SEQ_ID = p_COMMON_BOM_SEQ_ID)
1751 OR ( ( Recinfo.COMMON_BOM_SEQ_ID IS NULL )
1752 AND ( p_COMMON_BOM_SEQ_ID IS NULL )))
1753 AND ( ( Recinfo.COMMON_ROUTING_SEQ_ID = p_COMMON_ROUTING_SEQ_ID)
1754 OR ( ( Recinfo.COMMON_ROUTING_SEQ_ID IS NULL )
1755 AND ( p_COMMON_ROUTING_SEQ_ID IS NULL )))
1756 AND ( ( Recinfo.COST_TYPE_ID = p_COST_TYPE_ID)
1757 OR ( ( Recinfo.COST_TYPE_ID IS NULL )
1758 AND ( p_COST_TYPE_ID IS NULL )))
1759 AND ( ( Recinfo.ORG_COST_GROUP_ID = p_ORG_COST_GROUP_ID)
1760 OR ( ( Recinfo.ORG_COST_GROUP_ID IS NULL )
1761 AND ( p_ORG_COST_GROUP_ID IS NULL )))
1762 AND ( ( Recinfo.MOVE_ORDER_LINE_ID = p_MOVE_ORDER_LINE_ID)
1763 OR ( ( Recinfo.MOVE_ORDER_LINE_ID IS NULL )
1764 AND ( p_MOVE_ORDER_LINE_ID IS NULL )))
1765 AND ( ( Recinfo.TASK_GROUP_ID = p_TASK_GROUP_ID)
1766 OR ( ( Recinfo.TASK_GROUP_ID IS NULL )
1767 AND ( p_TASK_GROUP_ID IS NULL )))
1768 AND ( ( Recinfo.PICK_SLIP_NUMBER = p_PICK_SLIP_NUMBER)
1769 OR ( ( Recinfo.PICK_SLIP_NUMBER IS NULL )
1770 AND ( p_PICK_SLIP_NUMBER IS NULL )))
1771 AND ( ( Recinfo.RESERVATION_ID = p_RESERVATION_ID)
1772 OR ( ( Recinfo.RESERVATION_ID IS NULL )
1773 AND ( p_RESERVATION_ID IS NULL )))
1774 AND ( ( Recinfo.TRANSACTION_STATUS = p_TRANSACTION_STATUS)
1775 OR ( ( Recinfo.TRANSACTION_STATUS IS NULL )
1776 AND ( p_TRANSACTION_STATUS IS NULL )))
1777 AND ( ( Recinfo.STANDARD_OPERATION_ID = p_STANDARD_OPERATION_ID)
1778 OR ( ( Recinfo.STANDARD_OPERATION_ID IS NULL )
1779 AND ( p_STANDARD_OPERATION_ID IS NULL )))
1780 AND ( ( Recinfo.TASK_PRIORITY = p_TASK_PRIORITY)
1781 OR ( ( Recinfo.TASK_PRIORITY IS NULL )
1782 AND ( p_TASK_PRIORITY IS NULL )))
1783 AND ( ( Recinfo.WMS_TASK_TYPE = p_WMS_TASK_TYPE)
1784 OR ( ( Recinfo.WMS_TASK_TYPE IS NULL )
1785 AND ( p_WMS_TASK_TYPE IS NULL )))
1786 AND ( ( Recinfo.PARENT_LINE_ID = p_PARENT_LINE_ID)
1787 OR ( ( Recinfo.PARENT_LINE_ID IS NULL )
1788 AND ( p_PARENT_LINE_ID IS NULL )))
1789 /*AND ( ( Recinfo.SOURCE_LOT_NUMBER = p_SOURCE_LOT_NUMBER)
1790 OR ( ( Recinfo.SOURCE_LOT_NUMBER IS NULL )
1791 AND ( p_SOURCE_LOT_NUMBER IS NULL ))) */
1792 ) then
1793 return;
1794 else
1795 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1796 APP_EXCEPTION.RAISE_EXCEPTION;
1797 End If;
1798 END Lock_Row;
1799
1800 End CSP_MTL_TRANSACTIONS_PKG;