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.GMIGUTL dependencies on IC_LOCT_INV

Line 314: | This procedure is used to retrieve all details from ic_loct_inv |

310: | USAGE |
311: | Used to retrieve location inventory details |
312: | |
313: | DESCRIPTION |
314: | This procedure is used to retrieve all details from ic_loct_inv |
315: | |
316: | PARAMETERS |
317: | p_item_id IN NUMBER - Item ID |
318: | p_whse_code IN VARCHAR2(4) - Warehouse code |

Line 321: | x_ic_loct_inv IN RECORD - Record containing ic_loct_inv details |

317: | p_item_id IN NUMBER - Item ID |
318: | p_whse_code IN VARCHAR2(4) - Warehouse code |
319: | p_lot_id IN NUMBER - Lot ID |
320: | p_location IN VARCHAR2(4) - Location code |
321: | x_ic_loct_inv IN RECORD - Record containing ic_loct_inv details |
322: | |
323: | HISTORY |
324: +=========================================================================+
325: */

Line 327: ( p_item_id IN ic_loct_inv.item_id%TYPE

323: | HISTORY |
324: +=========================================================================+
325: */
326: PROCEDURE Get_Loct_inv
327: ( p_item_id IN ic_loct_inv.item_id%TYPE
328: , p_whse_code IN ic_loct_inv.whse_code%TYPE
329: , p_lot_id IN ic_loct_inv.lot_id%TYPE
330: , p_location IN ic_loct_inv.location%TYPE
331: , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE

Line 328: , p_whse_code IN ic_loct_inv.whse_code%TYPE

324: +=========================================================================+
325: */
326: PROCEDURE Get_Loct_inv
327: ( p_item_id IN ic_loct_inv.item_id%TYPE
328: , p_whse_code IN ic_loct_inv.whse_code%TYPE
329: , p_lot_id IN ic_loct_inv.lot_id%TYPE
330: , p_location IN ic_loct_inv.location%TYPE
331: , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE
332: )

Line 329: , p_lot_id IN ic_loct_inv.lot_id%TYPE

325: */
326: PROCEDURE Get_Loct_inv
327: ( p_item_id IN ic_loct_inv.item_id%TYPE
328: , p_whse_code IN ic_loct_inv.whse_code%TYPE
329: , p_lot_id IN ic_loct_inv.lot_id%TYPE
330: , p_location IN ic_loct_inv.location%TYPE
331: , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE
332: )
333: IS

Line 330: , p_location IN ic_loct_inv.location%TYPE

326: PROCEDURE Get_Loct_inv
327: ( p_item_id IN ic_loct_inv.item_id%TYPE
328: , p_whse_code IN ic_loct_inv.whse_code%TYPE
329: , p_lot_id IN ic_loct_inv.lot_id%TYPE
330: , p_location IN ic_loct_inv.location%TYPE
331: , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE
332: )
333: IS
334: BEGIN

Line 331: , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE

327: ( p_item_id IN ic_loct_inv.item_id%TYPE
328: , p_whse_code IN ic_loct_inv.whse_code%TYPE
329: , p_lot_id IN ic_loct_inv.lot_id%TYPE
330: , p_location IN ic_loct_inv.location%TYPE
331: , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE
332: )
333: IS
334: BEGIN
335: x_ic_loct_inv_row.item_id := p_item_id;

Line 335: x_ic_loct_inv_row.item_id := p_item_id;

331: , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE
332: )
333: IS
334: BEGIN
335: x_ic_loct_inv_row.item_id := p_item_id;
336: x_ic_loct_inv_row.whse_code := p_whse_code;
337: x_ic_loct_inv_row.lot_id := p_lot_id;
338: x_ic_loct_inv_row.location := p_location;
339:

Line 336: x_ic_loct_inv_row.whse_code := p_whse_code;

332: )
333: IS
334: BEGIN
335: x_ic_loct_inv_row.item_id := p_item_id;
336: x_ic_loct_inv_row.whse_code := p_whse_code;
337: x_ic_loct_inv_row.lot_id := p_lot_id;
338: x_ic_loct_inv_row.location := p_location;
339:
340: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row)

Line 337: x_ic_loct_inv_row.lot_id := p_lot_id;

333: IS
334: BEGIN
335: x_ic_loct_inv_row.item_id := p_item_id;
336: x_ic_loct_inv_row.whse_code := p_whse_code;
337: x_ic_loct_inv_row.lot_id := p_lot_id;
338: x_ic_loct_inv_row.location := p_location;
339:
340: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row)
341: THEN

Line 338: x_ic_loct_inv_row.location := p_location;

334: BEGIN
335: x_ic_loct_inv_row.item_id := p_item_id;
336: x_ic_loct_inv_row.whse_code := p_whse_code;
337: x_ic_loct_inv_row.lot_id := p_lot_id;
338: x_ic_loct_inv_row.location := p_location;
339:
340: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row)
341: THEN
342: RETURN;

Line 340: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row)

336: x_ic_loct_inv_row.whse_code := p_whse_code;
337: x_ic_loct_inv_row.lot_id := p_lot_id;
338: x_ic_loct_inv_row.location := p_location;
339:
340: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row)
341: THEN
342: RETURN;
343: END IF;
344:

Line 349: x_ic_loct_inv_row.loct_onhand := NULL;

345: RAISE FND_API.G_EXC_ERROR;
346:
347: EXCEPTION
348: WHEN OTHERS THEN
349: x_ic_loct_inv_row.loct_onhand := NULL;
350:
351: END Get_Loct_inv;
352:
353: /* +=========================================================================+