APPS.GMIGUTL dependencies on IC_LOTS_CPG

Line 233: | x_ic_lots_cpg OUT RECORD - Record containing ic_lots_cpg |

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: +=========================================================================+
237: */

Line 243: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE

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
247: x_ic_lots_mst_row.item_id := p_item_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 256: IF GMIVDBL.ic_lots_cpg_select(x_ic_lots_cpg_row, x_ic_lots_cpg_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;
260: RETURN;