[Home] [Help]
14: err_app out NOCOPY varchar2,
15: err_msg out NOCOPY varchar2) is
16:
17: move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;
18: alloc_recs wip_move_alloc_cleanup.WIP_MOVE_TXN_ALLOCATIONS_REC;
19: mtl_temp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
20: sn_temp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
21: lt_temp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
22: sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
32: and wmti1.overcompletion_transaction_id = wmti.overcompletion_transaction_id;
33:
34: oc_mov_group_id NUMBER;
35: oc_move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;
36: oc_alloc_recs wip_move_alloc_cleanup.WIP_MOVE_TXN_ALLOCATIONS_REC;
37:
38: x_retcode number;
39: x_app varchar2(3);
40: x_msg varchar2(30);
219: bf_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
220:
221: -- Overcompletion
222: oc_move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;
223: oc_alloc_recs wip_move_alloc_cleanup.WIP_MOVE_TXN_ALLOCATIONS_REC;
224:
225: cursor overcpl_move_id is
226: select wmti.transaction_id
227: from mtl_material_transactions_temp mmtt,
349: begin
350:
351: if (mov_group_id > 0) then
352:
353: delete wip_move_txn_allocations
354: where transaction_id in
355: (select transaction_id
356: from wip_move_txn_interface
357: where group_id = mov_group_id);