[Home] [Help]
PACKAGE: APPS.CSP_MTL_TRANSACTIONS_PKG
Source
1 PACKAGE CSP_MTL_TRANSACTIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: csptmmts.pls 120.0 2005/05/25 11:28:34 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 PROCEDURE Insert_Row(
11 p_TRANSACTION_HEADER_ID NUMBER,
12 px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
13 p_SOURCE_CODE VARCHAR2,
14 p_SOURCE_LINE_ID NUMBER,
15 p_TRANSACTION_MODE NUMBER,
16 p_LOCK_FLAG VARCHAR2,
17 p_LAST_UPDATE_DATE DATE,
18 p_LAST_UPDATED_BY NUMBER,
19 p_CREATION_DATE DATE,
20 p_CREATED_BY NUMBER,
21 p_LAST_UPDATE_LOGIN NUMBER,
22 p_REQUEST_ID NUMBER,
23 p_PROGRAM_APPLICATION_ID NUMBER,
24 p_PROGRAM_ID NUMBER,
25 p_PROGRAM_UPDATE_DATE DATE,
26 p_INVENTORY_ITEM_ID NUMBER,
27 p_REVISION VARCHAR2,
28 p_ORGANIZATION_ID NUMBER,
29 p_SUBINVENTORY_CODE VARCHAR2,
30 p_LOCATOR_ID NUMBER,
31 p_TRANSACTION_QUANTITY NUMBER,
32 p_PRIMARY_QUANTITY NUMBER,
33 p_TRANSACTION_UOM VARCHAR2,
34 p_TRANSACTION_COST NUMBER,
35 p_TRANSACTION_TYPE_ID NUMBER,
36 p_TRANSACTION_ACTION_ID NUMBER,
37 p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
38 p_TRANSACTION_SOURCE_ID NUMBER,
39 p_TRANSACTION_SOURCE_NAME VARCHAR2,
40 p_TRANSACTION_DATE DATE,
41 p_ACCT_PERIOD_ID NUMBER,
42 p_DISTRIBUTION_ACCOUNT_ID NUMBER,
43 p_TRANSACTION_REFERENCE VARCHAR2,
44 p_REQUISITION_LINE_ID NUMBER,
45 p_REQUISITION_DISTRIBUTION_ID NUMBER,
46 p_REASON_ID NUMBER,
47 p_LOT_NUMBER VARCHAR2,
48 p_LOT_EXPIRATION_DATE DATE,
49 p_SERIAL_NUMBER VARCHAR2,
50 p_RECEIVING_DOCUMENT VARCHAR2,
51 p_DEMAND_ID NUMBER,
52 p_RCV_TRANSACTION_ID NUMBER,
53 p_MOVE_TRANSACTION_ID NUMBER,
54 p_COMPLETION_TRANSACTION_ID NUMBER,
55 p_WIP_ENTITY_TYPE NUMBER,
56 p_SCHEDULE_ID NUMBER,
57 p_REPETITIVE_LINE_ID NUMBER,
58 p_EMPLOYEE_CODE VARCHAR2,
59 p_PRIMARY_SWITCH NUMBER,
60 p_SCHEDULE_UPDATE_CODE NUMBER,
61 p_SETUP_TEARDOWN_CODE NUMBER,
62 p_ITEM_ORDERING NUMBER,
63 p_NEGATIVE_REQ_FLAG NUMBER,
64 p_OPERATION_SEQ_NUM NUMBER,
65 p_PICKING_LINE_ID NUMBER,
66 p_TRX_SOURCE_LINE_ID NUMBER,
67 p_TRX_SOURCE_DELIVERY_ID NUMBER,
68 p_PHYSICAL_ADJUSTMENT_ID NUMBER,
69 p_CYCLE_COUNT_ID NUMBER,
70 p_RMA_LINE_ID NUMBER,
71 p_CUSTOMER_SHIP_ID NUMBER,
72 p_CURRENCY_CODE VARCHAR2,
73 p_CURRENCY_CONVERSION_RATE NUMBER,
74 p_CURRENCY_CONVERSION_TYPE VARCHAR2,
75 p_CURRENCY_CONVERSION_DATE DATE,
76 p_USSGL_TRANSACTION_CODE VARCHAR2,
77 p_VENDOR_LOT_NUMBER VARCHAR2,
78 p_ENCUMBRANCE_ACCOUNT NUMBER,
79 p_ENCUMBRANCE_AMOUNT NUMBER,
80 p_SHIP_TO_LOCATION NUMBER,
81 p_SHIPMENT_NUMBER VARCHAR2,
82 p_TRANSFER_COST NUMBER,
83 p_TRANSPORTATION_COST NUMBER,
84 p_TRANSPORTATION_ACCOUNT NUMBER,
85 p_FREIGHT_CODE VARCHAR2,
86 p_CONTAINERS NUMBER,
87 p_WAYBILL_AIRBILL VARCHAR2,
88 p_EXPECTED_ARRIVAL_DATE DATE,
89 p_TRANSFER_SUBINVENTORY VARCHAR2,
90 p_TRANSFER_ORGANIZATION NUMBER,
91 p_TRANSFER_TO_LOCATION NUMBER,
92 p_NEW_AVERAGE_COST NUMBER,
93 p_VALUE_CHANGE NUMBER,
94 p_PERCENTAGE_CHANGE NUMBER,
95 p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
96 p_DEMAND_SOURCE_HEADER_ID NUMBER,
97 p_DEMAND_SOURCE_LINE VARCHAR2,
98 p_DEMAND_SOURCE_DELIVERY VARCHAR2,
99 p_ITEM_SEGMENTS VARCHAR2,
100 p_ITEM_DESCRIPTION VARCHAR2,
101 p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
102 p_ITEM_LOCATION_CONTROL_CODE NUMBER,
103 p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
104 p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
105 p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
106 p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
107 p_ITEM_UOM_CLASS VARCHAR2,
108 p_ITEM_SHELF_LIFE_CODE NUMBER,
109 p_ITEM_SHELF_LIFE_DAYS NUMBER,
110 p_ITEM_LOT_CONTROL_CODE NUMBER,
111 p_ITEM_SERIAL_CONTROL_CODE NUMBER,
112 p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
113 p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
114 p_DEPARTMENT_ID NUMBER,
115 p_DEPARTMENT_CODE VARCHAR2,
116 p_WIP_SUPPLY_TYPE NUMBER,
117 p_SUPPLY_SUBINVENTORY VARCHAR2,
118 p_SUPPLY_LOCATOR_ID NUMBER,
119 p_VALID_SUBINVENTORY_FLAG VARCHAR2,
120 p_VALID_LOCATOR_FLAG VARCHAR2,
121 p_LOCATOR_SEGMENTS VARCHAR2,
122 p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
123 p_NUMBER_OF_LOTS_ENTERED NUMBER,
124 p_WIP_COMMIT_FLAG VARCHAR2,
125 p_NEXT_LOT_NUMBER VARCHAR2,
126 p_LOT_ALPHA_PREFIX VARCHAR2,
127 p_NEXT_SERIAL_NUMBER VARCHAR2,
128 p_SERIAL_ALPHA_PREFIX VARCHAR2,
129 p_SHIPPABLE_FLAG VARCHAR2,
130 p_POSTING_FLAG VARCHAR2,
131 p_REQUIRED_FLAG VARCHAR2,
132 p_PROCESS_FLAG VARCHAR2,
133 p_ERROR_CODE VARCHAR2,
134 p_ERROR_EXPLANATION VARCHAR2,
135 p_ATTRIBUTE_CATEGORY VARCHAR2,
136 p_ATTRIBUTE1 VARCHAR2,
137 p_ATTRIBUTE2 VARCHAR2,
138 p_ATTRIBUTE3 VARCHAR2,
139 p_ATTRIBUTE4 VARCHAR2,
140 p_ATTRIBUTE5 VARCHAR2,
141 p_ATTRIBUTE6 VARCHAR2,
142 p_ATTRIBUTE7 VARCHAR2,
143 p_ATTRIBUTE8 VARCHAR2,
144 p_ATTRIBUTE9 VARCHAR2,
145 p_ATTRIBUTE10 VARCHAR2,
146 p_ATTRIBUTE11 VARCHAR2,
147 p_ATTRIBUTE12 VARCHAR2,
148 p_ATTRIBUTE13 VARCHAR2,
149 p_ATTRIBUTE14 VARCHAR2,
150 p_ATTRIBUTE15 VARCHAR2,
151 p_MOVEMENT_ID NUMBER,
152 p_RESERVATION_QUANTITY NUMBER,
153 p_SHIPPED_QUANTITY NUMBER,
154 p_TRANSACTION_LINE_NUMBER NUMBER,
155 p_TASK_ID NUMBER,
156 p_TO_TASK_ID NUMBER,
157 p_SOURCE_TASK_ID NUMBER,
158 p_PROJECT_ID NUMBER,
159 p_SOURCE_PROJECT_ID NUMBER,
160 p_PA_EXPENDITURE_ORG_ID NUMBER,
161 p_TO_PROJECT_ID NUMBER,
162 p_EXPENDITURE_TYPE VARCHAR2,
163 p_FINAL_COMPLETION_FLAG VARCHAR2,
164 p_TRANSFER_PERCENTAGE NUMBER,
165 p_TRANSACTION_SEQUENCE_ID NUMBER,
166 p_MATERIAL_ACCOUNT NUMBER,
167 p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
168 p_RESOURCE_ACCOUNT NUMBER,
169 p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
170 p_OVERHEAD_ACCOUNT NUMBER,
171 p_FLOW_SCHEDULE VARCHAR2,
172 p_COST_GROUP_ID NUMBER,
173 p_DEMAND_CLASS VARCHAR2,
174 p_QA_COLLECTION_ID NUMBER,
175 p_KANBAN_CARD_ID NUMBER,
176 p_OVERCOMPLETION_TXN_ID NUMBER,
177 p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
178 p_OVERCOMPLETION_TXN_QTY NUMBER,
179 --p_PROCESS_TYPE NUMBER,
180 p_END_ITEM_UNIT_NUMBER VARCHAR2,
181 p_SCHEDULED_PAYBACK_DATE DATE,
182 p_LINE_TYPE_CODE NUMBER,
183 p_PARENT_TRANSACTION_TEMP_ID NUMBER,
184 p_PUT_AWAY_STRATEGY_ID NUMBER,
185 p_PUT_AWAY_RULE_ID NUMBER,
186 p_PICK_STRATEGY_ID NUMBER,
187 p_PICK_RULE_ID NUMBER,
188 p_COMMON_BOM_SEQ_ID NUMBER,
189 p_COMMON_ROUTING_SEQ_ID NUMBER,
190 p_COST_TYPE_ID NUMBER,
191 p_ORG_COST_GROUP_ID NUMBER,
192 p_MOVE_ORDER_LINE_ID NUMBER,
193 p_TASK_GROUP_ID NUMBER,
194 p_PICK_SLIP_NUMBER NUMBER,
195 p_RESERVATION_ID NUMBER,
196 p_TRANSACTION_STATUS NUMBER,
197 p_STANDARD_OPERATION_ID NUMBER,
198 p_TASK_PRIORITY NUMBER,
199 p_WMS_TASK_TYPE NUMBER,
200 p_PARENT_LINE_ID NUMBER);
201 -- P_SOURCE_LOT_NUMBER NUMBER);
202
203 PROCEDURE Update_Row(
204 p_TRANSACTION_HEADER_ID NUMBER,
205 p_TRANSACTION_TEMP_ID NUMBER,
206 p_SOURCE_CODE VARCHAR2,
207 p_SOURCE_LINE_ID NUMBER,
208 p_TRANSACTION_MODE NUMBER,
209 p_LOCK_FLAG VARCHAR2,
210 p_LAST_UPDATE_DATE DATE,
211 p_LAST_UPDATED_BY NUMBER,
212 p_CREATION_DATE DATE,
213 p_CREATED_BY NUMBER,
214 p_LAST_UPDATE_LOGIN NUMBER,
215 p_REQUEST_ID NUMBER,
216 p_PROGRAM_APPLICATION_ID NUMBER,
217 p_PROGRAM_ID NUMBER,
218 p_PROGRAM_UPDATE_DATE DATE,
219 p_INVENTORY_ITEM_ID NUMBER,
220 p_REVISION VARCHAR2,
221 p_ORGANIZATION_ID NUMBER,
222 p_SUBINVENTORY_CODE VARCHAR2,
223 p_LOCATOR_ID NUMBER,
224 p_TRANSACTION_QUANTITY NUMBER,
225 p_PRIMARY_QUANTITY NUMBER,
226 p_TRANSACTION_UOM VARCHAR2,
227 p_TRANSACTION_COST NUMBER,
228 p_TRANSACTION_TYPE_ID NUMBER,
229 p_TRANSACTION_ACTION_ID NUMBER,
230 p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
231 p_TRANSACTION_SOURCE_ID NUMBER,
232 p_TRANSACTION_SOURCE_NAME VARCHAR2,
233 p_TRANSACTION_DATE DATE,
234 p_ACCT_PERIOD_ID NUMBER,
235 p_DISTRIBUTION_ACCOUNT_ID NUMBER,
236 p_TRANSACTION_REFERENCE VARCHAR2,
237 p_REQUISITION_LINE_ID NUMBER,
238 p_REQUISITION_DISTRIBUTION_ID NUMBER,
239 p_REASON_ID NUMBER,
240 p_LOT_NUMBER VARCHAR2,
241 p_LOT_EXPIRATION_DATE DATE,
242 p_SERIAL_NUMBER VARCHAR2,
243 p_RECEIVING_DOCUMENT VARCHAR2,
244 p_DEMAND_ID NUMBER,
245 p_RCV_TRANSACTION_ID NUMBER,
246 p_MOVE_TRANSACTION_ID NUMBER,
247 p_COMPLETION_TRANSACTION_ID NUMBER,
248 p_WIP_ENTITY_TYPE NUMBER,
249 p_SCHEDULE_ID NUMBER,
250 p_REPETITIVE_LINE_ID NUMBER,
251 p_EMPLOYEE_CODE VARCHAR2,
252 p_PRIMARY_SWITCH NUMBER,
253 p_SCHEDULE_UPDATE_CODE NUMBER,
254 p_SETUP_TEARDOWN_CODE NUMBER,
255 p_ITEM_ORDERING NUMBER,
256 p_NEGATIVE_REQ_FLAG NUMBER,
257 p_OPERATION_SEQ_NUM NUMBER,
258 p_PICKING_LINE_ID NUMBER,
259 p_TRX_SOURCE_LINE_ID NUMBER,
260 p_TRX_SOURCE_DELIVERY_ID NUMBER,
261 p_PHYSICAL_ADJUSTMENT_ID NUMBER,
262 p_CYCLE_COUNT_ID NUMBER,
263 p_RMA_LINE_ID NUMBER,
264 p_CUSTOMER_SHIP_ID NUMBER,
265 p_CURRENCY_CODE VARCHAR2,
266 p_CURRENCY_CONVERSION_RATE NUMBER,
267 p_CURRENCY_CONVERSION_TYPE VARCHAR2,
268 p_CURRENCY_CONVERSION_DATE DATE,
269 p_USSGL_TRANSACTION_CODE VARCHAR2,
270 p_VENDOR_LOT_NUMBER VARCHAR2,
271 p_ENCUMBRANCE_ACCOUNT NUMBER,
272 p_ENCUMBRANCE_AMOUNT NUMBER,
273 p_SHIP_TO_LOCATION NUMBER,
274 p_SHIPMENT_NUMBER VARCHAR2,
275 p_TRANSFER_COST NUMBER,
276 p_TRANSPORTATION_COST NUMBER,
277 p_TRANSPORTATION_ACCOUNT NUMBER,
278 p_FREIGHT_CODE VARCHAR2,
279 p_CONTAINERS NUMBER,
280 p_WAYBILL_AIRBILL VARCHAR2,
281 p_EXPECTED_ARRIVAL_DATE DATE,
282 p_TRANSFER_SUBINVENTORY VARCHAR2,
283 p_TRANSFER_ORGANIZATION NUMBER,
284 p_TRANSFER_TO_LOCATION NUMBER,
285 p_NEW_AVERAGE_COST NUMBER,
286 p_VALUE_CHANGE NUMBER,
287 p_PERCENTAGE_CHANGE NUMBER,
288 p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
289 p_DEMAND_SOURCE_HEADER_ID NUMBER,
290 p_DEMAND_SOURCE_LINE VARCHAR2,
291 p_DEMAND_SOURCE_DELIVERY VARCHAR2,
292 p_ITEM_SEGMENTS VARCHAR2,
293 p_ITEM_DESCRIPTION VARCHAR2,
294 p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
295 p_ITEM_LOCATION_CONTROL_CODE NUMBER,
296 p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
297 p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
298 p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
299 p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
300 p_ITEM_UOM_CLASS VARCHAR2,
301 p_ITEM_SHELF_LIFE_CODE NUMBER,
302 p_ITEM_SHELF_LIFE_DAYS NUMBER,
303 p_ITEM_LOT_CONTROL_CODE NUMBER,
304 p_ITEM_SERIAL_CONTROL_CODE NUMBER,
305 p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
306 p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
307 p_DEPARTMENT_ID NUMBER,
308 p_DEPARTMENT_CODE VARCHAR2,
309 p_WIP_SUPPLY_TYPE NUMBER,
310 p_SUPPLY_SUBINVENTORY VARCHAR2,
311 p_SUPPLY_LOCATOR_ID NUMBER,
312 p_VALID_SUBINVENTORY_FLAG VARCHAR2,
313 p_VALID_LOCATOR_FLAG VARCHAR2,
314 p_LOCATOR_SEGMENTS VARCHAR2,
315 p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
316 p_NUMBER_OF_LOTS_ENTERED NUMBER,
317 p_WIP_COMMIT_FLAG VARCHAR2,
318 p_NEXT_LOT_NUMBER VARCHAR2,
319 p_LOT_ALPHA_PREFIX VARCHAR2,
320 p_NEXT_SERIAL_NUMBER VARCHAR2,
321 p_SERIAL_ALPHA_PREFIX VARCHAR2,
322 p_SHIPPABLE_FLAG VARCHAR2,
323 p_POSTING_FLAG VARCHAR2,
324 p_REQUIRED_FLAG VARCHAR2,
325 p_PROCESS_FLAG VARCHAR2,
326 p_ERROR_CODE VARCHAR2,
327 p_ERROR_EXPLANATION VARCHAR2,
328 p_ATTRIBUTE_CATEGORY VARCHAR2,
329 p_ATTRIBUTE1 VARCHAR2,
330 p_ATTRIBUTE2 VARCHAR2,
331 p_ATTRIBUTE3 VARCHAR2,
332 p_ATTRIBUTE4 VARCHAR2,
333 p_ATTRIBUTE5 VARCHAR2,
334 p_ATTRIBUTE6 VARCHAR2,
335 p_ATTRIBUTE7 VARCHAR2,
336 p_ATTRIBUTE8 VARCHAR2,
337 p_ATTRIBUTE9 VARCHAR2,
338 p_ATTRIBUTE10 VARCHAR2,
339 p_ATTRIBUTE11 VARCHAR2,
340 p_ATTRIBUTE12 VARCHAR2,
341 p_ATTRIBUTE13 VARCHAR2,
342 p_ATTRIBUTE14 VARCHAR2,
343 p_ATTRIBUTE15 VARCHAR2,
344 p_MOVEMENT_ID NUMBER,
345 p_RESERVATION_QUANTITY NUMBER,
346 p_SHIPPED_QUANTITY NUMBER,
347 p_TRANSACTION_LINE_NUMBER NUMBER,
348 p_TASK_ID NUMBER,
349 p_TO_TASK_ID NUMBER,
350 p_SOURCE_TASK_ID NUMBER,
351 p_PROJECT_ID NUMBER,
352 p_SOURCE_PROJECT_ID NUMBER,
353 p_PA_EXPENDITURE_ORG_ID NUMBER,
354 p_TO_PROJECT_ID NUMBER,
355 p_EXPENDITURE_TYPE VARCHAR2,
356 p_FINAL_COMPLETION_FLAG VARCHAR2,
357 p_TRANSFER_PERCENTAGE NUMBER,
358 p_TRANSACTION_SEQUENCE_ID NUMBER,
362 p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
359 p_MATERIAL_ACCOUNT NUMBER,
360 p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
361 p_RESOURCE_ACCOUNT NUMBER,
363 p_OVERHEAD_ACCOUNT NUMBER,
364 p_FLOW_SCHEDULE VARCHAR2,
365 p_COST_GROUP_ID NUMBER,
366 p_DEMAND_CLASS VARCHAR2,
367 p_QA_COLLECTION_ID NUMBER,
368 p_KANBAN_CARD_ID NUMBER,
369 p_OVERCOMPLETION_TXN_ID NUMBER,
370 p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
371 p_OVERCOMPLETION_TXN_QTY NUMBER,
372 -- p_PROCESS_TYPE NUMBER,
373 p_END_ITEM_UNIT_NUMBER VARCHAR2,
374 p_SCHEDULED_PAYBACK_DATE DATE,
375 p_LINE_TYPE_CODE NUMBER,
376 p_PARENT_TRANSACTION_TEMP_ID NUMBER,
377 p_PUT_AWAY_STRATEGY_ID NUMBER,
378 p_PUT_AWAY_RULE_ID NUMBER,
379 p_PICK_STRATEGY_ID NUMBER,
380 p_PICK_RULE_ID NUMBER,
381 p_COMMON_BOM_SEQ_ID NUMBER,
382 p_COMMON_ROUTING_SEQ_ID NUMBER,
383 p_COST_TYPE_ID NUMBER,
384 p_ORG_COST_GROUP_ID NUMBER,
385 p_MOVE_ORDER_LINE_ID NUMBER,
386 p_TASK_GROUP_ID NUMBER,
387 p_PICK_SLIP_NUMBER NUMBER,
388 p_RESERVATION_ID NUMBER,
389 p_TRANSACTION_STATUS NUMBER,
390 p_STANDARD_OPERATION_ID NUMBER,
391 p_TASK_PRIORITY NUMBER,
392 p_WMS_TASK_TYPE NUMBER,
393 p_PARENT_LINE_ID NUMBER);
394 -- P_SOURCE_LOT_NUMBER NUMBER);
395
396 PROCEDURE Lock_Row(
397 p_TRANSACTION_HEADER_ID NUMBER,
398 p_TRANSACTION_TEMP_ID NUMBER,
399 p_SOURCE_CODE VARCHAR2,
400 p_SOURCE_LINE_ID NUMBER,
401 p_TRANSACTION_MODE NUMBER,
402 p_LOCK_FLAG VARCHAR2,
403 p_LAST_UPDATE_DATE DATE,
404 p_LAST_UPDATED_BY NUMBER,
405 p_CREATION_DATE DATE,
406 p_CREATED_BY NUMBER,
407 p_LAST_UPDATE_LOGIN NUMBER,
408 p_REQUEST_ID NUMBER,
409 p_PROGRAM_APPLICATION_ID NUMBER,
410 p_PROGRAM_ID NUMBER,
411 p_PROGRAM_UPDATE_DATE DATE,
412 p_INVENTORY_ITEM_ID NUMBER,
413 p_REVISION VARCHAR2,
414 p_ORGANIZATION_ID NUMBER,
415 p_SUBINVENTORY_CODE VARCHAR2,
416 p_LOCATOR_ID NUMBER,
417 p_TRANSACTION_QUANTITY NUMBER,
418 p_PRIMARY_QUANTITY NUMBER,
419 p_TRANSACTION_UOM VARCHAR2,
420 p_TRANSACTION_COST NUMBER,
421 p_TRANSACTION_TYPE_ID NUMBER,
422 p_TRANSACTION_ACTION_ID NUMBER,
423 p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
424 p_TRANSACTION_SOURCE_ID NUMBER,
425 p_TRANSACTION_SOURCE_NAME VARCHAR2,
426 p_TRANSACTION_DATE DATE,
427 p_ACCT_PERIOD_ID NUMBER,
428 p_DISTRIBUTION_ACCOUNT_ID NUMBER,
429 p_TRANSACTION_REFERENCE VARCHAR2,
430 p_REQUISITION_LINE_ID NUMBER,
431 p_REQUISITION_DISTRIBUTION_ID NUMBER,
432 p_REASON_ID NUMBER,
433 p_LOT_NUMBER VARCHAR2,
434 p_LOT_EXPIRATION_DATE DATE,
435 p_SERIAL_NUMBER VARCHAR2,
436 p_RECEIVING_DOCUMENT VARCHAR2,
437 p_DEMAND_ID NUMBER,
438 p_RCV_TRANSACTION_ID NUMBER,
439 p_MOVE_TRANSACTION_ID NUMBER,
440 p_COMPLETION_TRANSACTION_ID NUMBER,
441 p_WIP_ENTITY_TYPE NUMBER,
442 p_SCHEDULE_ID NUMBER,
443 p_REPETITIVE_LINE_ID NUMBER,
444 p_EMPLOYEE_CODE VARCHAR2,
445 p_PRIMARY_SWITCH NUMBER,
446 p_SCHEDULE_UPDATE_CODE NUMBER,
447 p_SETUP_TEARDOWN_CODE NUMBER,
448 p_ITEM_ORDERING NUMBER,
449 p_NEGATIVE_REQ_FLAG NUMBER,
450 p_OPERATION_SEQ_NUM NUMBER,
451 p_PICKING_LINE_ID NUMBER,
452 p_TRX_SOURCE_LINE_ID NUMBER,
453 p_TRX_SOURCE_DELIVERY_ID NUMBER,
454 p_PHYSICAL_ADJUSTMENT_ID NUMBER,
455 p_CYCLE_COUNT_ID NUMBER,
456 p_RMA_LINE_ID NUMBER,
457 p_CUSTOMER_SHIP_ID NUMBER,
458 p_CURRENCY_CODE VARCHAR2,
459 p_CURRENCY_CONVERSION_RATE NUMBER,
460 p_CURRENCY_CONVERSION_TYPE VARCHAR2,
461 p_CURRENCY_CONVERSION_DATE DATE,
462 p_USSGL_TRANSACTION_CODE VARCHAR2,
463 p_VENDOR_LOT_NUMBER VARCHAR2,
464 p_ENCUMBRANCE_ACCOUNT NUMBER,
465 p_ENCUMBRANCE_AMOUNT NUMBER,
466 p_SHIP_TO_LOCATION NUMBER,
467 p_SHIPMENT_NUMBER VARCHAR2,
468 p_TRANSFER_COST NUMBER,
469 p_TRANSPORTATION_COST NUMBER,
470 p_TRANSPORTATION_ACCOUNT NUMBER,
471 p_FREIGHT_CODE VARCHAR2,
472 p_CONTAINERS NUMBER,
473 p_WAYBILL_AIRBILL VARCHAR2,
474 p_EXPECTED_ARRIVAL_DATE DATE,
475 p_TRANSFER_SUBINVENTORY VARCHAR2,
476 p_TRANSFER_ORGANIZATION NUMBER,
477 p_TRANSFER_TO_LOCATION NUMBER,
478 p_NEW_AVERAGE_COST NUMBER,
479 p_VALUE_CHANGE NUMBER,
480 p_PERCENTAGE_CHANGE NUMBER,
484 p_DEMAND_SOURCE_DELIVERY VARCHAR2,
481 p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
482 p_DEMAND_SOURCE_HEADER_ID NUMBER,
483 p_DEMAND_SOURCE_LINE VARCHAR2,
485 p_ITEM_SEGMENTS VARCHAR2,
486 p_ITEM_DESCRIPTION VARCHAR2,
487 p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
488 p_ITEM_LOCATION_CONTROL_CODE NUMBER,
489 p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
490 p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
491 p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
492 p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
493 p_ITEM_UOM_CLASS VARCHAR2,
494 p_ITEM_SHELF_LIFE_CODE NUMBER,
495 p_ITEM_SHELF_LIFE_DAYS NUMBER,
496 p_ITEM_LOT_CONTROL_CODE NUMBER,
497 p_ITEM_SERIAL_CONTROL_CODE NUMBER,
498 p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
499 p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
500 p_DEPARTMENT_ID NUMBER,
501 p_DEPARTMENT_CODE VARCHAR2,
502 p_WIP_SUPPLY_TYPE NUMBER,
503 p_SUPPLY_SUBINVENTORY VARCHAR2,
504 p_SUPPLY_LOCATOR_ID NUMBER,
505 p_VALID_SUBINVENTORY_FLAG VARCHAR2,
506 p_VALID_LOCATOR_FLAG VARCHAR2,
507 p_LOCATOR_SEGMENTS VARCHAR2,
508 p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
509 p_NUMBER_OF_LOTS_ENTERED NUMBER,
510 p_WIP_COMMIT_FLAG VARCHAR2,
511 p_NEXT_LOT_NUMBER VARCHAR2,
512 p_LOT_ALPHA_PREFIX VARCHAR2,
513 p_NEXT_SERIAL_NUMBER VARCHAR2,
514 p_SERIAL_ALPHA_PREFIX VARCHAR2,
515 p_SHIPPABLE_FLAG VARCHAR2,
516 p_POSTING_FLAG VARCHAR2,
517 p_REQUIRED_FLAG VARCHAR2,
518 p_PROCESS_FLAG VARCHAR2,
519 p_ERROR_CODE VARCHAR2,
520 p_ERROR_EXPLANATION VARCHAR2,
521 p_ATTRIBUTE_CATEGORY VARCHAR2,
522 p_ATTRIBUTE1 VARCHAR2,
523 p_ATTRIBUTE2 VARCHAR2,
524 p_ATTRIBUTE3 VARCHAR2,
525 p_ATTRIBUTE4 VARCHAR2,
526 p_ATTRIBUTE5 VARCHAR2,
527 p_ATTRIBUTE6 VARCHAR2,
528 p_ATTRIBUTE7 VARCHAR2,
529 p_ATTRIBUTE8 VARCHAR2,
530 p_ATTRIBUTE9 VARCHAR2,
531 p_ATTRIBUTE10 VARCHAR2,
532 p_ATTRIBUTE11 VARCHAR2,
533 p_ATTRIBUTE12 VARCHAR2,
534 p_ATTRIBUTE13 VARCHAR2,
535 p_ATTRIBUTE14 VARCHAR2,
536 p_ATTRIBUTE15 VARCHAR2,
537 p_MOVEMENT_ID NUMBER,
538 p_RESERVATION_QUANTITY NUMBER,
539 p_SHIPPED_QUANTITY NUMBER,
540 p_TRANSACTION_LINE_NUMBER NUMBER,
541 p_TASK_ID NUMBER,
542 p_TO_TASK_ID NUMBER,
543 p_SOURCE_TASK_ID NUMBER,
544 p_PROJECT_ID NUMBER,
545 p_SOURCE_PROJECT_ID NUMBER,
546 p_PA_EXPENDITURE_ORG_ID NUMBER,
547 p_TO_PROJECT_ID NUMBER,
548 p_EXPENDITURE_TYPE VARCHAR2,
549 p_FINAL_COMPLETION_FLAG VARCHAR2,
550 p_TRANSFER_PERCENTAGE NUMBER,
551 p_TRANSACTION_SEQUENCE_ID NUMBER,
552 p_MATERIAL_ACCOUNT NUMBER,
553 p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
554 p_RESOURCE_ACCOUNT NUMBER,
555 p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
556 p_OVERHEAD_ACCOUNT NUMBER,
557 p_FLOW_SCHEDULE VARCHAR2,
558 p_COST_GROUP_ID NUMBER,
559 p_DEMAND_CLASS VARCHAR2,
560 p_QA_COLLECTION_ID NUMBER,
561 p_KANBAN_CARD_ID NUMBER,
562 p_OVERCOMPLETION_TXN_ID NUMBER,
563 p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
564 p_OVERCOMPLETION_TXN_QTY NUMBER,
565 -- p_PROCESS_TYPE NUMBER,
566 p_END_ITEM_UNIT_NUMBER VARCHAR2,
567 p_SCHEDULED_PAYBACK_DATE DATE,
568 p_LINE_TYPE_CODE NUMBER,
569 p_PARENT_TRANSACTION_TEMP_ID NUMBER,
570 p_PUT_AWAY_STRATEGY_ID NUMBER,
571 p_PUT_AWAY_RULE_ID NUMBER,
572 p_PICK_STRATEGY_ID NUMBER,
573 p_PICK_RULE_ID NUMBER,
574 p_COMMON_BOM_SEQ_ID NUMBER,
575 p_COMMON_ROUTING_SEQ_ID NUMBER,
576 p_COST_TYPE_ID NUMBER,
577 p_ORG_COST_GROUP_ID NUMBER,
578 p_MOVE_ORDER_LINE_ID NUMBER,
579 p_TASK_GROUP_ID NUMBER,
580 p_PICK_SLIP_NUMBER NUMBER,
581 p_RESERVATION_ID NUMBER,
582 p_TRANSACTION_STATUS NUMBER,
583 p_STANDARD_OPERATION_ID NUMBER,
584 p_TASK_PRIORITY NUMBER,
585 p_WMS_TASK_TYPE NUMBER,
586 p_PARENT_LINE_ID NUMBER);
587 -- P_SOURCE_LOT_NUMBER NUMBER);
588
589 PROCEDURE Delete_Row(
590 p_TRANSACTION_TEMP_ID NUMBER);
591 End CSP_MTL_TRANSACTIONS_PKG;