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_LOTS_MST

Line 226: | This procedure is used to retrieve all details from ic_lots_mst |

222: | USAGE |
223: | Used to retrieve lot master details |
224: | |
225: | DESCRIPTION |
226: | This procedure is used to retrieve all details from ic_lots_mst |
227: | |
228: | PARAMETERS |
229: | p_item_id IN NUMBER - Item ID of lot to be retrieved |
230: | p_lot_no IN VARCHAR2(32) - Lot number of lot to be retrieved |

Line 232: | x_ic_lots_mst OUT RECORD - Record containing ic_lots_mst |

228: | PARAMETERS |
229: | p_item_id IN NUMBER - Item ID of lot to be retrieved |
230: | p_lot_no IN VARCHAR2(32) - Lot number of lot to be retrieved |
231: | p_sublot_no IN VARCHAR2(32) - Sublot number to be retrieved |
232: | x_ic_lots_mst OUT RECORD - Record containing ic_lots_mst |
233: | x_ic_lots_cpg OUT RECORD - Record containing ic_lots_cpg |
234: | |
235: | HISTORY |
236: +=========================================================================+

Line 239: ( p_item_id IN ic_lots_mst.item_id%TYPE

235: | HISTORY |
236: +=========================================================================+
237: */
238: PROCEDURE Get_Lot
239: ( p_item_id IN ic_lots_mst.item_id%TYPE
240: , p_lot_no IN ic_lots_mst.lot_no%TYPE
241: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
242: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
243: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE

Line 240: , p_lot_no IN ic_lots_mst.lot_no%TYPE

236: +=========================================================================+
237: */
238: PROCEDURE Get_Lot
239: ( p_item_id IN ic_lots_mst.item_id%TYPE
240: , p_lot_no IN ic_lots_mst.lot_no%TYPE
241: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
242: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
243: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
244: )

Line 241: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

237: */
238: PROCEDURE Get_Lot
239: ( p_item_id IN ic_lots_mst.item_id%TYPE
240: , p_lot_no IN ic_lots_mst.lot_no%TYPE
241: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
242: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
243: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
244: )
245: IS

Line 242: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE

238: PROCEDURE Get_Lot
239: ( p_item_id IN ic_lots_mst.item_id%TYPE
240: , p_lot_no IN ic_lots_mst.lot_no%TYPE
241: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
242: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
243: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
244: )
245: IS
246: BEGIN

Line 247: x_ic_lots_mst_row.item_id := p_item_id;

243: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
244: )
245: IS
246: BEGIN
247: x_ic_lots_mst_row.item_id := p_item_id;
248: x_ic_lots_mst_row.lot_no := p_lot_no;
249: x_ic_lots_mst_row.sublot_no := p_sublot_no;
250:
251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)

Line 248: x_ic_lots_mst_row.lot_no := p_lot_no;

244: )
245: IS
246: BEGIN
247: x_ic_lots_mst_row.item_id := p_item_id;
248: x_ic_lots_mst_row.lot_no := p_lot_no;
249: x_ic_lots_mst_row.sublot_no := p_sublot_no;
250:
251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)
252: THEN

Line 249: x_ic_lots_mst_row.sublot_no := p_sublot_no;

245: IS
246: BEGIN
247: x_ic_lots_mst_row.item_id := p_item_id;
248: x_ic_lots_mst_row.lot_no := p_lot_no;
249: x_ic_lots_mst_row.sublot_no := p_sublot_no;
250:
251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)
252: THEN
253: /* Jalaj Srivastava - Bug 3158806. Remove CPG_INSTALL check. */

Line 251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)

247: x_ic_lots_mst_row.item_id := p_item_id;
248: x_ic_lots_mst_row.lot_no := p_lot_no;
249: x_ic_lots_mst_row.sublot_no := p_sublot_no;
250:
251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)
252: THEN
253: /* Jalaj Srivastava - Bug 3158806. Remove CPG_INSTALL check. */
254: x_ic_lots_cpg_row.item_id := x_ic_lots_mst_row.item_id;
255: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;

Line 254: x_ic_lots_cpg_row.item_id := x_ic_lots_mst_row.item_id;

250:
251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)
252: THEN
253: /* Jalaj Srivastava - Bug 3158806. Remove CPG_INSTALL check. */
254: x_ic_lots_cpg_row.item_id := x_ic_lots_mst_row.item_id;
255: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;
256: IF GMIVDBL.ic_lots_cpg_select(x_ic_lots_cpg_row, x_ic_lots_cpg_row)
257: THEN
258: RETURN;

Line 255: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;

251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)
252: THEN
253: /* Jalaj Srivastava - Bug 3158806. Remove CPG_INSTALL check. */
254: x_ic_lots_cpg_row.item_id := x_ic_lots_mst_row.item_id;
255: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;
256: IF GMIVDBL.ic_lots_cpg_select(x_ic_lots_cpg_row, x_ic_lots_cpg_row)
257: THEN
258: RETURN;
259: END IF;

Line 267: x_ic_lots_mst_row.lot_id := NULL;

263: RAISE FND_API.G_EXC_ERROR;
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: x_ic_lots_mst_row.lot_id := NULL;
268: END Get_Lot;
269:
270: /* +=========================================================================+
271: | PROCEDURE NAME |