APPS.GMIGUTL dependencies on IC_WHSE_MST

Line 278: | This procedure is used to retrieve all details from ic_whse_mst |

274: | USAGE |
275: | Used to retrieve warehouse details |
276: | |
277: | DESCRIPTION |
278: | This procedure is used to retrieve all details from ic_whse_mst |
279: | |
280: | PARAMETERS |
281: | p_item_no IN VARCHAR2(4) - Warehouse code to be retrieved |
282: | x_ic_whse_mst OUT RECORD - Record containing ic_whse_mst |

Line 282: | x_ic_whse_mst OUT RECORD - Record containing ic_whse_mst |

278: | This procedure is used to retrieve all details from ic_whse_mst |
279: | |
280: | PARAMETERS |
281: | p_item_no IN VARCHAR2(4) - Warehouse code to be retrieved |
282: | x_ic_whse_mst OUT RECORD - Record containing ic_whse_mst |
283: | |
284: | HISTORY |
285: +=========================================================================+
286: */

Line 288: ( p_whse_code IN ic_whse_mst.whse_code%TYPE

284: | HISTORY |
285: +=========================================================================+
286: */
287: PROCEDURE Get_Warehouse
288: ( p_whse_code IN ic_whse_mst.whse_code%TYPE
289: , x_ic_whse_mst_row OUT NOCOPY ic_whse_mst%ROWTYPE
290: )
291: IS
292: BEGIN

Line 289: , x_ic_whse_mst_row OUT NOCOPY ic_whse_mst%ROWTYPE

285: +=========================================================================+
286: */
287: PROCEDURE Get_Warehouse
288: ( p_whse_code IN ic_whse_mst.whse_code%TYPE
289: , x_ic_whse_mst_row OUT NOCOPY ic_whse_mst%ROWTYPE
290: )
291: IS
292: BEGIN
293: x_ic_whse_mst_row.whse_code := p_whse_code;

Line 293: x_ic_whse_mst_row.whse_code := p_whse_code;

289: , x_ic_whse_mst_row OUT NOCOPY ic_whse_mst%ROWTYPE
290: )
291: IS
292: BEGIN
293: x_ic_whse_mst_row.whse_code := p_whse_code;
294: IF GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row)
295: THEN
296: RETURN;
297: END IF;

Line 294: IF GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row)

290: )
291: IS
292: BEGIN
293: x_ic_whse_mst_row.whse_code := p_whse_code;
294: IF GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row)
295: THEN
296: RETURN;
297: END IF;
298:

Line 303: x_ic_whse_mst_row.whse_code := NULL;

299: RAISE FND_API.G_EXC_ERROR;
300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: x_ic_whse_mst_row.whse_code := NULL;
304: END Get_Warehouse;
305:
306: /* +=========================================================================+
307: | PROCEDURE NAME |