DBA Data[Home] [Help]

APPS.GMI_RESERVATION_UTIL dependencies on IC_LOCT_INV

Line 2669: /* Lock rows in ic_loct_inv. */

2665: RAISE FND_API.G_EXC_ERROR;
2666: END IF;
2667:
2668: /* ============================================================================================= */
2669: /* Lock rows in ic_loct_inv. */
2670: /* ============================================================================================= */
2671: -- Bug 2749329 Do not lock. Lock_inventory call and return handling is commented.
2672: /*
2673: GMI_Locks.Lock_Inventory(

Line 3472: /* Lock rows in ic_loct_inv. */

3468: /* ============================================================================================= */
3469: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot. Need to create default lot');
3470:
3471: /* ============================================================================================= */
3472: /* Lock rows in ic_loct_inv. */
3473: /* ============================================================================================= */
3474: GMI_Locks.Lock_Inventory(
3475: i_item_id => p_ic_tran_rec.item_id
3476: , i_whse_code => p_ic_tran_rec.whse_code

Line 3980: From ic_loct_inv

3976: , p_location IN VARCHAR2
3977: , p_item_id IN NUMBER)
3978: IS
3979: Select lot_status
3980: From ic_loct_inv
3981: Where item_id = p_item_id
3982: and lot_id = p_lot_id
3983: and location = p_location
3984: and whse_code = p_whse_code;