APPS.WIP_TRANSACTIONS_PKG dependencies on WIP_MOVE_TXN_INTERFACE_CLEANUP

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 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 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: