APPS.GMI_SHIPPING_UTIL dependencies on IC_LOCT_INV

Line 251: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.

247: THEN
248: /* We have the transaction we need. */
249: /* Before Completing any transactions lets Lock The Rows. */
250: /* Calling OPM Lock Inventory Routine. */
251: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
252:
253: IF ABS(l_old_transaction_rec.trans_qty) = p_shipping_line.cycle_count_quantity
254: THEN
255: GMI_RESERVATION_UTIL.println('BackOrder Full Staged Qty');

Line 578: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.

574: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
575: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
576: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
577:
578: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
579:
580: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
581: ( 1
582: , FND_API.G_FALSE

Line 2148: -- PK Bug 3527599 No need to lock IC_LOCT_INV when updating / creating pending txn.

2144: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
2145: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_old_transaction_rec, l_old_transaction_rec )
2146: THEN
2147: GMI_reservation_Util.printLn('OPM Transaction found in OPM_UPDATE_TRXS');
2148: -- PK Bug 3527599 No need to lock IC_LOCT_INV when updating / creating pending txn.
2149:
2150: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
2151:
2152: PRINT_DEBUG (l_old_transaction_rec,'FETCH RECORD');

Line 4283: FROM ic_loct_inv

4279: WHERE item_id = p_tran_rec.item_id;
4280:
4281: CURSOR Cur_get_onhand_qty(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) IS
4282: SELECT loct_onhand as qty
4283: FROM ic_loct_inv
4284: WHERE item_id = p_tran_rec.item_id
4285: AND whse_code = p_tran_rec.whse_code
4286: AND lot_id = p_tran_rec.lot_id
4287: AND location = p_tran_rec.location;