APPS.WIP_TRANSACTIONS_PKG dependencies on WIP_MOVE_TXN_INTERFACE

Line 17: move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;

13: err_code out NOCOPY number,
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;

Line 27: from wip_move_txn_interface wmti,

23: sn_marks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
24:
25: cursor overcpl_move_id is
26: select wmti1.transaction_id
27: from wip_move_txn_interface wmti,
28: wip_move_txn_interface wmti1
29: where wmti.group_id = mov_group_id
30: and wmti.overcompletion_transaction_id is not NULL
31: AND wmti.overcompletion_transaction_qty > 0

Line 28: wip_move_txn_interface wmti1

24:
25: cursor overcpl_move_id is
26: select wmti1.transaction_id
27: from wip_move_txn_interface wmti,
28: wip_move_txn_interface wmti1
29: where wmti.group_id = mov_group_id
30: and wmti.overcompletion_transaction_id is not NULL
31: AND wmti.overcompletion_transaction_qty > 0
32: and wmti1.overcompletion_transaction_id = wmti.overcompletion_transaction_id;

Line 35: oc_move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;

31: AND wmti.overcompletion_transaction_qty > 0
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);

Line 71: wip_move_txn_interface_cleanup.fetch_and_delete

67: wip_move_alloc_cleanup.fetch_and_delete
68: (p_mov_grp_id => oc_mov_group_id,
69: p_mov_allocs => oc_alloc_recs);
70:
71: wip_move_txn_interface_cleanup.fetch_and_delete
72: (p_grp_id => oc_mov_group_id,
73: p_moves => oc_move_recs);
74:
75: end if;

Line 98: wip_move_txn_interface_cleanup.fetch_and_delete(

94: p_dyn_serials => sn_recs,
95: p_ser_marks => sn_marks);
96: end if;
97:
98: wip_move_txn_interface_cleanup.fetch_and_delete(
99: p_grp_id => mov_group_id,
100: p_moves => move_recs);
101:
102: commit;

Line 106: wip_move_txn_interface_cleanup.insert_rows(move_recs);

102: commit;
103:
104: if (bf_page = 2) then
105: wip_utilities.do_sql('SAVEPOINT ' || save_point);
106: wip_move_txn_interface_cleanup.insert_rows(move_recs);
107:
108: if (mtl_header_id > 0) then
109: wip_mtl_txns_temp_cleanup.insert_rows(
110: p_materials => mtl_temp_recs,

Line 222: oc_move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;

218: bf_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
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

Line 228: wip_move_txn_interface wmti

224:
225: cursor overcpl_move_id is
226: select wmti.transaction_id
227: from mtl_material_transactions_temp mmtt,
228: wip_move_txn_interface wmti
229: where mmtt.TRANSACTION_HEADER_ID = mtl_header_id
230: and mmtt.overcompletion_transaction_id is not null
231: and wmti.overcompletion_transaction_id = mmtt.overcompletion_transaction_id;
232:

Line 254: wip_move_txn_interface_cleanup.fetch_and_delete

250: wip_move_alloc_cleanup.fetch_and_delete
251: (p_mov_grp_id => oc_mov_group_id,
252: p_mov_allocs => oc_alloc_recs);
253:
254: wip_move_txn_interface_cleanup.fetch_and_delete
255: (p_grp_id => oc_mov_group_id,
256: p_moves => oc_move_recs);
257: end if;
258:

Line 305: wip_move_txn_interface_cleanup.insert_rows(oc_move_recs);

301: wip_mtl_txns_temp_cleanup.insert_rows(p_mtls => cmp_mtl_tmp_recs);
302:
303: IF ( oc_move_recs.numrecs > 0 ) THEN
304: -- Overcompletion
305: wip_move_txn_interface_cleanup.insert_rows(oc_move_recs);
306: END IF;
307:
308: wip_utilities.do_sql('SAVEPOINT ' || insert_sp);
309:

Line 356: from wip_move_txn_interface

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);
358:
359: delete wip_move_txn_interface
360: where group_id = mov_group_id;

Line 359: delete wip_move_txn_interface

355: (select transaction_id
356: from wip_move_txn_interface
357: where group_id = mov_group_id);
358:
359: delete wip_move_txn_interface
360: where group_id = mov_group_id;
361:
362: end if;
363: