eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_LOCKS dependencies on IC_LOCT_INV

Line 6: * locks rows in ic_loct_inv. It is intended to be used by the allocation

2: /* $Header: GMIULCKB.pls 115.9 2004/01/08 21:14:44 adeshmuk ship $ */
3:
4: /* ========================================================================
5: * This file contains the body of a package which
6: * locks rows in ic_loct_inv. It is intended to be used by the allocation
7: * logic in the OM/OPM integration. At the start of an allocation session
8: * for a particular item/whse/lot/location, the procedures in this package
9: * prevent users from accessing the inventory simultaneously whilst it is
10: * being allocated. This prevents multiple allocation of the same stock and

Line 80: i_item_id IN ic_loct_inv.item_id%TYPE,

76: /* This procedure is private to the package. */
77:
78: PROCEDURE lock_rows
79: (
80: i_item_id IN ic_loct_inv.item_id%TYPE,
81: i_whse_code IN ic_loct_inv.whse_code%TYPE,
82: i_lot_id IN ic_loct_inv.lot_id%TYPE,
83: i_lot_status IN ic_loct_inv.lot_status%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,

Line 81: i_whse_code IN ic_loct_inv.whse_code%TYPE,

77:
78: PROCEDURE lock_rows
79: (
80: i_item_id IN ic_loct_inv.item_id%TYPE,
81: i_whse_code IN ic_loct_inv.whse_code%TYPE,
82: i_lot_id IN ic_loct_inv.lot_id%TYPE,
83: i_lot_status IN ic_loct_inv.lot_status%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN

Line 82: i_lot_id IN ic_loct_inv.lot_id%TYPE,

78: PROCEDURE lock_rows
79: (
80: i_item_id IN ic_loct_inv.item_id%TYPE,
81: i_whse_code IN ic_loct_inv.whse_code%TYPE,
82: i_lot_id IN ic_loct_inv.lot_id%TYPE,
83: i_lot_status IN ic_loct_inv.lot_status%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN
86: )

Line 83: i_lot_status IN ic_loct_inv.lot_status%TYPE,

79: (
80: i_item_id IN ic_loct_inv.item_id%TYPE,
81: i_whse_code IN ic_loct_inv.whse_code%TYPE,
82: i_lot_id IN ic_loct_inv.lot_id%TYPE,
83: i_lot_status IN ic_loct_inv.lot_status%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN
86: )
87: IS

Line 84: i_location IN ic_loct_inv.location%TYPE,

80: i_item_id IN ic_loct_inv.item_id%TYPE,
81: i_whse_code IN ic_loct_inv.whse_code%TYPE,
82: i_lot_id IN ic_loct_inv.lot_id%TYPE,
83: i_lot_status IN ic_loct_inv.lot_status%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN
86: )
87: IS
88:

Line 123: || 'FROM ic_loct_inv '

119: END IF;
120:
121: statement :=
122: 'SELECT 1 '
123: || 'FROM ic_loct_inv '
124: || 'WHERE item_id=:i_item_id '
125: || l_where
126: || ' FOR UPDATE NOWAIT ';
127: OPEN cursor_handle FOR statement

Line 154: i_item_id IN ic_loct_inv.item_id%TYPE,

150: /* Variant #1 Lock all inventory of the specified item */
151:
152: PROCEDURE lock_inventory
153: (
154: i_item_id IN ic_loct_inv.item_id%TYPE,
155: o_lock_status OUT NOCOPY BOOLEAN
156: )
157: IS
158: i_lock_status BOOLEAN;

Line 176: i_item_id IN ic_loct_inv.item_id%TYPE,

172: /* Variant #2 Lock all inventory of the item in the warehouse specified. */
173:
174: PROCEDURE lock_inventory
175: (
176: i_item_id IN ic_loct_inv.item_id%TYPE,
177: i_whse_code IN ic_whse_mst.whse_code%TYPE,
178: o_lock_status OUT NOCOPY BOOLEAN
179: )
180: IS

Line 199: i_item_id IN ic_loct_inv.item_id%TYPE,

195: /* Variant #3 Lock the specified lot(s) of the item in the warehouse. */
196:
197: PROCEDURE lock_inventory
198: (
199: i_item_id IN ic_loct_inv.item_id%TYPE,
200: i_whse_code IN ic_loct_inv.whse_code%TYPE,
201: i_lot_id IN ic_loct_inv.lot_id%TYPE,
202: i_lot_status IN ic_loct_inv.lot_status%TYPE,
203: o_lock_status OUT NOCOPY BOOLEAN

Line 200: i_whse_code IN ic_loct_inv.whse_code%TYPE,

196:
197: PROCEDURE lock_inventory
198: (
199: i_item_id IN ic_loct_inv.item_id%TYPE,
200: i_whse_code IN ic_loct_inv.whse_code%TYPE,
201: i_lot_id IN ic_loct_inv.lot_id%TYPE,
202: i_lot_status IN ic_loct_inv.lot_status%TYPE,
203: o_lock_status OUT NOCOPY BOOLEAN
204: )

Line 201: i_lot_id IN ic_loct_inv.lot_id%TYPE,

197: PROCEDURE lock_inventory
198: (
199: i_item_id IN ic_loct_inv.item_id%TYPE,
200: i_whse_code IN ic_loct_inv.whse_code%TYPE,
201: i_lot_id IN ic_loct_inv.lot_id%TYPE,
202: i_lot_status IN ic_loct_inv.lot_status%TYPE,
203: o_lock_status OUT NOCOPY BOOLEAN
204: )
205: IS

Line 202: i_lot_status IN ic_loct_inv.lot_status%TYPE,

198: (
199: i_item_id IN ic_loct_inv.item_id%TYPE,
200: i_whse_code IN ic_loct_inv.whse_code%TYPE,
201: i_lot_id IN ic_loct_inv.lot_id%TYPE,
202: i_lot_status IN ic_loct_inv.lot_status%TYPE,
203: o_lock_status OUT NOCOPY BOOLEAN
204: )
205: IS
206: i_lock_status BOOLEAN;

Line 225: i_item_id IN ic_loct_inv.item_id%TYPE,

221: /* Variant #4 Lock inventory in the warehouse and location specified. */
222:
223: PROCEDURE lock_inventory
224: (
225: i_item_id IN ic_loct_inv.item_id%TYPE,
226: i_whse_code IN ic_loct_inv.whse_code%TYPE,
227: i_location IN ic_loct_inv.location%TYPE,
228: o_lock_status OUT NOCOPY BOOLEAN
229: )

Line 226: i_whse_code IN ic_loct_inv.whse_code%TYPE,

222:
223: PROCEDURE lock_inventory
224: (
225: i_item_id IN ic_loct_inv.item_id%TYPE,
226: i_whse_code IN ic_loct_inv.whse_code%TYPE,
227: i_location IN ic_loct_inv.location%TYPE,
228: o_lock_status OUT NOCOPY BOOLEAN
229: )
230: IS

Line 227: i_location IN ic_loct_inv.location%TYPE,

223: PROCEDURE lock_inventory
224: (
225: i_item_id IN ic_loct_inv.item_id%TYPE,
226: i_whse_code IN ic_loct_inv.whse_code%TYPE,
227: i_location IN ic_loct_inv.location%TYPE,
228: o_lock_status OUT NOCOPY BOOLEAN
229: )
230: IS
231: i_lock_status BOOLEAN;

Line 250: i_item_id IN ic_loct_inv.item_id%TYPE,

246: /* Variant #5 Lock inventory in the warehouse, lot and location specified. */
247:
248: PROCEDURE lock_inventory
249: (
250: i_item_id IN ic_loct_inv.item_id%TYPE,
251: i_whse_code IN ic_loct_inv.whse_code%TYPE,
252: i_lot_id IN ic_loct_inv.lot_id%TYPE,
253: i_location IN ic_loct_inv.location%TYPE,
254: o_lock_status OUT NOCOPY BOOLEAN

Line 251: i_whse_code IN ic_loct_inv.whse_code%TYPE,

247:
248: PROCEDURE lock_inventory
249: (
250: i_item_id IN ic_loct_inv.item_id%TYPE,
251: i_whse_code IN ic_loct_inv.whse_code%TYPE,
252: i_lot_id IN ic_loct_inv.lot_id%TYPE,
253: i_location IN ic_loct_inv.location%TYPE,
254: o_lock_status OUT NOCOPY BOOLEAN
255: )

Line 252: i_lot_id IN ic_loct_inv.lot_id%TYPE,

248: PROCEDURE lock_inventory
249: (
250: i_item_id IN ic_loct_inv.item_id%TYPE,
251: i_whse_code IN ic_loct_inv.whse_code%TYPE,
252: i_lot_id IN ic_loct_inv.lot_id%TYPE,
253: i_location IN ic_loct_inv.location%TYPE,
254: o_lock_status OUT NOCOPY BOOLEAN
255: )
256: IS

Line 253: i_location IN ic_loct_inv.location%TYPE,

249: (
250: i_item_id IN ic_loct_inv.item_id%TYPE,
251: i_whse_code IN ic_loct_inv.whse_code%TYPE,
252: i_lot_id IN ic_loct_inv.lot_id%TYPE,
253: i_location IN ic_loct_inv.location%TYPE,
254: o_lock_status OUT NOCOPY BOOLEAN
255: )
256: IS
257: i_lock_status BOOLEAN;

Line 275: i_item_id IN ic_loct_inv.item_id%TYPE,

271: /* Variant #6 - Lock inventory in a specific lot and location in the warehouse specified. */
272:
273: PROCEDURE lock_inventory
274: (
275: i_item_id IN ic_loct_inv.item_id%TYPE,
276: i_whse_code IN ic_loct_inv.whse_code%TYPE,
277: i_lot_id IN ic_loct_inv.lot_id%TYPE,
278: i_lot_status IN ic_loct_inv.lot_status%TYPE,
279: i_location IN ic_loct_inv.location%TYPE,

Line 276: i_whse_code IN ic_loct_inv.whse_code%TYPE,

272:
273: PROCEDURE lock_inventory
274: (
275: i_item_id IN ic_loct_inv.item_id%TYPE,
276: i_whse_code IN ic_loct_inv.whse_code%TYPE,
277: i_lot_id IN ic_loct_inv.lot_id%TYPE,
278: i_lot_status IN ic_loct_inv.lot_status%TYPE,
279: i_location IN ic_loct_inv.location%TYPE,
280: o_lock_status OUT NOCOPY BOOLEAN

Line 277: i_lot_id IN ic_loct_inv.lot_id%TYPE,

273: PROCEDURE lock_inventory
274: (
275: i_item_id IN ic_loct_inv.item_id%TYPE,
276: i_whse_code IN ic_loct_inv.whse_code%TYPE,
277: i_lot_id IN ic_loct_inv.lot_id%TYPE,
278: i_lot_status IN ic_loct_inv.lot_status%TYPE,
279: i_location IN ic_loct_inv.location%TYPE,
280: o_lock_status OUT NOCOPY BOOLEAN
281: )

Line 278: i_lot_status IN ic_loct_inv.lot_status%TYPE,

274: (
275: i_item_id IN ic_loct_inv.item_id%TYPE,
276: i_whse_code IN ic_loct_inv.whse_code%TYPE,
277: i_lot_id IN ic_loct_inv.lot_id%TYPE,
278: i_lot_status IN ic_loct_inv.lot_status%TYPE,
279: i_location IN ic_loct_inv.location%TYPE,
280: o_lock_status OUT NOCOPY BOOLEAN
281: )
282: IS

Line 279: i_location IN ic_loct_inv.location%TYPE,

275: i_item_id IN ic_loct_inv.item_id%TYPE,
276: i_whse_code IN ic_loct_inv.whse_code%TYPE,
277: i_lot_id IN ic_loct_inv.lot_id%TYPE,
278: i_lot_status IN ic_loct_inv.lot_status%TYPE,
279: i_location IN ic_loct_inv.location%TYPE,
280: o_lock_status OUT NOCOPY BOOLEAN
281: )
282: IS
283: i_lock_status BOOLEAN;

Line 301: i_item_id IN ic_loct_inv.item_id%TYPE,

297: /* Variant #7 - The main code. All of the above public routines call this one and filter the results. */
298:
299: PROCEDURE lock_inventory
300: (
301: i_item_id IN ic_loct_inv.item_id%TYPE,
302: i_whse_code IN ic_loct_inv.whse_code%TYPE,
303: i_lot_id IN ic_loct_inv.lot_id%TYPE,
304: i_lot_status IN ic_loct_inv.lot_status%TYPE,
305: i_location IN ic_loct_inv.location%TYPE,

Line 302: i_whse_code IN ic_loct_inv.whse_code%TYPE,

298:
299: PROCEDURE lock_inventory
300: (
301: i_item_id IN ic_loct_inv.item_id%TYPE,
302: i_whse_code IN ic_loct_inv.whse_code%TYPE,
303: i_lot_id IN ic_loct_inv.lot_id%TYPE,
304: i_lot_status IN ic_loct_inv.lot_status%TYPE,
305: i_location IN ic_loct_inv.location%TYPE,
306: i_attempts IN NUMBER,

Line 303: i_lot_id IN ic_loct_inv.lot_id%TYPE,

299: PROCEDURE lock_inventory
300: (
301: i_item_id IN ic_loct_inv.item_id%TYPE,
302: i_whse_code IN ic_loct_inv.whse_code%TYPE,
303: i_lot_id IN ic_loct_inv.lot_id%TYPE,
304: i_lot_status IN ic_loct_inv.lot_status%TYPE,
305: i_location IN ic_loct_inv.location%TYPE,
306: i_attempts IN NUMBER,
307: o_lock_status OUT NOCOPY BOOLEAN

Line 304: i_lot_status IN ic_loct_inv.lot_status%TYPE,

300: (
301: i_item_id IN ic_loct_inv.item_id%TYPE,
302: i_whse_code IN ic_loct_inv.whse_code%TYPE,
303: i_lot_id IN ic_loct_inv.lot_id%TYPE,
304: i_lot_status IN ic_loct_inv.lot_status%TYPE,
305: i_location IN ic_loct_inv.location%TYPE,
306: i_attempts IN NUMBER,
307: o_lock_status OUT NOCOPY BOOLEAN
308: )

Line 305: i_location IN ic_loct_inv.location%TYPE,

301: i_item_id IN ic_loct_inv.item_id%TYPE,
302: i_whse_code IN ic_loct_inv.whse_code%TYPE,
303: i_lot_id IN ic_loct_inv.lot_id%TYPE,
304: i_lot_status IN ic_loct_inv.lot_status%TYPE,
305: i_location IN ic_loct_inv.location%TYPE,
306: i_attempts IN NUMBER,
307: o_lock_status OUT NOCOPY BOOLEAN
308: )
309: IS