DBA Data[Home] [Help]

APPS.WIP_TRANSACTIONS_PKG dependencies on WIP_UTILITIES

Line 105: wip_utilities.do_sql('SAVEPOINT ' || save_point);

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

Line 168: wip_utilities.do_sql('SAVEPOINT ' || entry_sp);

164: p_ser_marks => mtl_sn_mrks);
165:
166: commit;
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,

Line 281: wip_utilities.do_sql('SAVEPOINT ' || criteria_sp);

277: p_ser_marks => bf_sn_mrks);
278:
279: commit;
280:
281: wip_utilities.do_sql('SAVEPOINT ' || criteria_sp);
282:
283: -- post lot and serial records
284: wip_lot_temp_cleanup.insert_rows(p_lots => cmp_lt_tmp_recs);
285: wip_serial_temp_cleanup.insert_rows(p_serials => cmp_sn_tmp_recs);

Line 298: wip_utilities.do_sql('SAVEPOINT ' || entry_sp);

294: err_msg := 'INV_RPC_CLEANUP_ERROR';
295: return;
296: end if;
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:

Line 308: wip_utilities.do_sql('SAVEPOINT ' || insert_sp);

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:
310: if (bf_page = 2) then
311: -- insert backflush records
312: wip_mtl_txns_temp_cleanup.insert_rows(