APPS.WIP_TRANSACTIONS_PKG dependencies on WIP_MTL_TXNS_TEMP_CLEANUP

Line 19: mtl_temp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;

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;
23: sn_marks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;

Line 88: wip_mtl_txns_temp_cleanup.fetch_and_delete(

84: wip_move_alloc_cleanup.fetch_and_delete(
85: p_mov_grp_id => mov_group_id,
86: p_mov_allocs => alloc_recs);
87:
88: wip_mtl_txns_temp_cleanup.fetch_and_delete(
89: p_hdr_id => mtl_header_id,
90: p_act_id => NULL,
91: p_materials => mtl_temp_recs,
92: p_lots => lt_temp_recs,

Line 109: wip_mtl_txns_temp_cleanup.insert_rows(

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,
111: p_lots => lt_temp_recs,
112: p_serials => sn_temp_recs,
113: p_dyn_serials => sn_recs,

Line 146: mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;

142: entry_sp in varchar2,
143: err_code out NOCOPY number,
144: err_app out NOCOPY varchar2,
145: err_msg out NOCOPY varchar2) is
146: mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
147: mtl_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
148: mtl_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
149: mtl_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
150: mtl_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;

Line 157: wip_mtl_txns_temp_cleanup.fetch_and_delete(

153: x_app varchar2(3);
154: x_msg varchar2(30);
155: begin
156: -- get material records
157: wip_mtl_txns_temp_cleanup.fetch_and_delete(
158: p_hdr_id => mtl_header_id,
159: p_act_id => NULL,
160: p_materials => mtl_tmp_recs,
161: p_lots => mtl_lt_tmp_recs,

Line 171: wip_mtl_txns_temp_cleanup.insert_rows(

167:
168: wip_utilities.do_sql('SAVEPOINT ' || entry_sp);
169:
170: -- insert material records
171: wip_mtl_txns_temp_cleanup.insert_rows(
172: p_materials => mtl_tmp_recs,
173: p_lots => mtl_lt_tmp_recs,
174: p_serials => mtl_sn_tmp_recs,
175: p_dyn_serials => mtl_dyn_sn_recs,

Line 209: cmp_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;

205: err_code OUT NOCOPY NUMBER,
206: err_app OUT NOCOPY VARCHAR2,
207: err_msg OUT NOCOPY VARCHAR2) IS
208:
209: cmp_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
210: cmp_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
211: cmp_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
212: cmp_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
213: cmp_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;

Line 215: bf_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;

211: cmp_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
212: cmp_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
213: cmp_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
214:
215: bf_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
216: bf_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
217: bf_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_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;

Line 260: wip_mtl_txns_temp_cleanup.fetch_and_delete(

256: p_moves => oc_move_recs);
257: end if;
258:
259: -- get completion records
260: wip_mtl_txns_temp_cleanup.fetch_and_delete(
261: p_hdr_id => mtl_header_id,
262: p_act_id => action_id,
263: p_materials => cmp_mtl_tmp_recs,
264: p_lots => cmp_lt_tmp_recs,

Line 270: wip_mtl_txns_temp_cleanup.fetch_and_delete(

266: p_dyn_serials => cmp_dyn_sn_recs,
267: p_ser_marks => cmp_sn_mrks);
268:
269: -- get rest of material records
270: wip_mtl_txns_temp_cleanup.fetch_and_delete(
271: p_hdr_id => mtl_header_id,
272: p_act_id => NULL,
273: p_materials => bf_mtl_tmp_recs,
274: p_lots => bf_lt_tmp_recs,

Line 301: wip_mtl_txns_temp_cleanup.insert_rows(p_mtls => cmp_mtl_tmp_recs);

297:
298: wip_utilities.do_sql('SAVEPOINT ' || entry_sp);
299:
300: -- post completion records
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);

Line 312: wip_mtl_txns_temp_cleanup.insert_rows(

308: wip_utilities.do_sql('SAVEPOINT ' || insert_sp);
309:
310: if (bf_page = 2) then
311: -- insert backflush records
312: wip_mtl_txns_temp_cleanup.insert_rows(
313: p_materials => bf_mtl_tmp_recs,
314: p_lots => bf_lt_tmp_recs,
315: p_serials => bf_sn_tmp_recs,
316: p_dyn_serials => bf_dyn_sn_recs,