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_GLOBAL_GRP dependencies on IC_LOCT_INV

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

241: --| USAGE |
242: --| Used to retrieve location inventory details |
243: --| |
244: --| DESCRIPTION |
245: --| This procedure is used to retrieve all details from ic_loct_inv |
246: --| |
247: --| PARAMETERS |
248: --| p_item_id IN NUMBER - Item ID |
249: --| p_whse_code IN VARCHAR2(4) - Warehouse code |

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

249: --| p_whse_code IN VARCHAR2(4) - Warehouse code |
250: --| p_lot_id IN NUMBER - Lot ID |
251: --| p_location IN VARCHAR2(4) - Location code |
252: --| p_delete_mark IN NUMBER - Delete marker (Default 0) |
253: --| x_ic_loct_inv IN RECORD - Record containing ic_loct_inv details |
254: --| |
255: --| HISTORY |
256: --| 01-OCT-1998 M.Godfrey Created |
257: --+=========================================================================+

Line 259: ( p_item_id IN ic_loct_inv.item_id%TYPE

255: --| HISTORY |
256: --| 01-OCT-1998 M.Godfrey Created |
257: --+=========================================================================+
258: PROCEDURE Get_Loct_inv
259: ( p_item_id IN ic_loct_inv.item_id%TYPE
260: , p_whse_code IN ic_loct_inv.whse_code%TYPE
261: , p_lot_id IN ic_loct_inv.lot_id%TYPE
262: , p_location IN ic_loct_inv.location%TYPE
263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE

Line 260: , p_whse_code IN ic_loct_inv.whse_code%TYPE

256: --| 01-OCT-1998 M.Godfrey Created |
257: --+=========================================================================+
258: PROCEDURE Get_Loct_inv
259: ( p_item_id IN ic_loct_inv.item_id%TYPE
260: , p_whse_code IN ic_loct_inv.whse_code%TYPE
261: , p_lot_id IN ic_loct_inv.lot_id%TYPE
262: , p_location IN ic_loct_inv.location%TYPE
263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
264: , x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE

Line 261: , p_lot_id IN ic_loct_inv.lot_id%TYPE

257: --+=========================================================================+
258: PROCEDURE Get_Loct_inv
259: ( p_item_id IN ic_loct_inv.item_id%TYPE
260: , p_whse_code IN ic_loct_inv.whse_code%TYPE
261: , p_lot_id IN ic_loct_inv.lot_id%TYPE
262: , p_location IN ic_loct_inv.location%TYPE
263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
264: , x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE
265: )

Line 262: , p_location IN ic_loct_inv.location%TYPE

258: PROCEDURE Get_Loct_inv
259: ( p_item_id IN ic_loct_inv.item_id%TYPE
260: , p_whse_code IN ic_loct_inv.whse_code%TYPE
261: , p_lot_id IN ic_loct_inv.lot_id%TYPE
262: , p_location IN ic_loct_inv.location%TYPE
263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
264: , x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE
265: )
266: IS

Line 263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE

259: ( p_item_id IN ic_loct_inv.item_id%TYPE
260: , p_whse_code IN ic_loct_inv.whse_code%TYPE
261: , p_lot_id IN ic_loct_inv.lot_id%TYPE
262: , p_location IN ic_loct_inv.location%TYPE
263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
264: , x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE
265: )
266: IS
267: CURSOR ic_loct_inv_c1 IS

Line 264: , x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE

260: , p_whse_code IN ic_loct_inv.whse_code%TYPE
261: , p_lot_id IN ic_loct_inv.lot_id%TYPE
262: , p_location IN ic_loct_inv.location%TYPE
263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
264: , x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE
265: )
266: IS
267: CURSOR ic_loct_inv_c1 IS
268: SELECT

Line 267: CURSOR ic_loct_inv_c1 IS

263: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
264: , x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE
265: )
266: IS
267: CURSOR ic_loct_inv_c1 IS
268: SELECT
269: *
270: FROM
271: ic_loct_inv

Line 271: ic_loct_inv

267: CURSOR ic_loct_inv_c1 IS
268: SELECT
269: *
270: FROM
271: ic_loct_inv
272: WHERE
273: item_id = p_item_id
274: AND whse_code = p_whse_code
275: AND lot_id = p_lot_id

Line 281: OPEN ic_loct_inv_c1;

277: AND delete_mark = p_delete_mark;
278:
279: BEGIN
280:
281: OPEN ic_loct_inv_c1;
282:
283: FETCH ic_loct_inv_c1 INTO x_ic_loct_inv;
284:
285: IF (ic_loct_inv_c1%NOTFOUND)

Line 283: FETCH ic_loct_inv_c1 INTO x_ic_loct_inv;

279: BEGIN
280:
281: OPEN ic_loct_inv_c1;
282:
283: FETCH ic_loct_inv_c1 INTO x_ic_loct_inv;
284:
285: IF (ic_loct_inv_c1%NOTFOUND)
286: THEN
287: x_ic_loct_inv.item_id := 0;

Line 285: IF (ic_loct_inv_c1%NOTFOUND)

281: OPEN ic_loct_inv_c1;
282:
283: FETCH ic_loct_inv_c1 INTO x_ic_loct_inv;
284:
285: IF (ic_loct_inv_c1%NOTFOUND)
286: THEN
287: x_ic_loct_inv.item_id := 0;
288: END IF;
289:

Line 287: x_ic_loct_inv.item_id := 0;

283: FETCH ic_loct_inv_c1 INTO x_ic_loct_inv;
284:
285: IF (ic_loct_inv_c1%NOTFOUND)
286: THEN
287: x_ic_loct_inv.item_id := 0;
288: END IF;
289:
290: CLOSE ic_loct_inv_c1;
291:

Line 290: CLOSE ic_loct_inv_c1;

286: THEN
287: x_ic_loct_inv.item_id := 0;
288: END IF;
289:
290: CLOSE ic_loct_inv_c1;
291:
292: EXCEPTION
293: WHEN OTHERS THEN
294: RAISE;

Line 397: ( p_item_id IN ic_loct_inv.item_id%TYPE

393: --| HISTORY |
394: --| 01-OCT-1998 M.Godfrey Created |
395: --+=========================================================================+
396: PROCEDURE Get_Lot_inv
397: ( p_item_id IN ic_loct_inv.item_id%TYPE
398: , p_lot_id IN ic_loct_inv.lot_id%TYPE
399: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
400: , x_lot_onhand OUT NOCOPY NUMBER
401: )

Line 398: , p_lot_id IN ic_loct_inv.lot_id%TYPE

394: --| 01-OCT-1998 M.Godfrey Created |
395: --+=========================================================================+
396: PROCEDURE Get_Lot_inv
397: ( p_item_id IN ic_loct_inv.item_id%TYPE
398: , p_lot_id IN ic_loct_inv.lot_id%TYPE
399: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
400: , x_lot_onhand OUT NOCOPY NUMBER
401: )
402: IS

Line 399: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE

395: --+=========================================================================+
396: PROCEDURE Get_Lot_inv
397: ( p_item_id IN ic_loct_inv.item_id%TYPE
398: , p_lot_id IN ic_loct_inv.lot_id%TYPE
399: , p_delete_mark IN ic_loct_inv.delete_mark%TYPE
400: , x_lot_onhand OUT NOCOPY NUMBER
401: )
402: IS
403: CURSOR ic_lot_inv_c1 IS

Line 407: ic_loct_inv

403: CURSOR ic_lot_inv_c1 IS
404: SELECT
405: SUM(loct_onhand)
406: FROM
407: ic_loct_inv
408: WHERE
409: item_id = p_item_id
410: AND lot_id = p_lot_id
411: AND delete_mark = p_delete_mark;