DBA Data[Home] [Help]

APPS.GMI_GLOBAL_GRP dependencies on IC_WHSE_MST

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

192: --| USAGE |
193: --| Used to retrieve warehouse details |
194: --| |
195: --| DESCRIPTION |
196: --| This procedure is used to retrieve all details from ic_whse_mst |
197: --| |
198: --| PARAMETERS |
199: --| p_item_no IN VARCHAR2(32) - Warehouse code to be retrieved |
200: --| x_ic_whse_mst OUT RECORD - Record containing ic_whse_mst |

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

196: --| This procedure is used to retrieve all details from ic_whse_mst |
197: --| |
198: --| PARAMETERS |
199: --| p_item_no IN VARCHAR2(32) - Warehouse code to be retrieved |
200: --| x_ic_whse_mst OUT RECORD - Record containing ic_whse_mst |
201: --| |
202: --| HISTORY |
203: --| 01-OCT-1998 M.Godfrey Created |
204: --+=========================================================================+

Line 206: ( p_whse_code IN ic_whse_mst.whse_code%TYPE

202: --| HISTORY |
203: --| 01-OCT-1998 M.Godfrey Created |
204: --+=========================================================================+
205: PROCEDURE Get_Warehouse
206: ( p_whse_code IN ic_whse_mst.whse_code%TYPE
207: , x_ic_whse_mst OUT NOCOPY ic_whse_mst%ROWTYPE
208: )
209: IS
210: CURSOR ic_whse_mst_c1 IS

Line 207: , x_ic_whse_mst OUT NOCOPY ic_whse_mst%ROWTYPE

203: --| 01-OCT-1998 M.Godfrey Created |
204: --+=========================================================================+
205: PROCEDURE Get_Warehouse
206: ( p_whse_code IN ic_whse_mst.whse_code%TYPE
207: , x_ic_whse_mst OUT NOCOPY ic_whse_mst%ROWTYPE
208: )
209: IS
210: CURSOR ic_whse_mst_c1 IS
211: SELECT

Line 210: CURSOR ic_whse_mst_c1 IS

206: ( p_whse_code IN ic_whse_mst.whse_code%TYPE
207: , x_ic_whse_mst OUT NOCOPY ic_whse_mst%ROWTYPE
208: )
209: IS
210: CURSOR ic_whse_mst_c1 IS
211: SELECT
212: *
213: FROM
214: ic_whse_mst

Line 214: ic_whse_mst

210: CURSOR ic_whse_mst_c1 IS
211: SELECT
212: *
213: FROM
214: ic_whse_mst
215: WHERE
216: whse_code = p_whse_code;
217:
218: BEGIN

Line 220: OPEN ic_whse_mst_c1;

216: whse_code = p_whse_code;
217:
218: BEGIN
219:
220: OPEN ic_whse_mst_c1;
221:
222: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst;
223:
224: IF (ic_whse_mst_c1%NOTFOUND)

Line 222: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst;

218: BEGIN
219:
220: OPEN ic_whse_mst_c1;
221:
222: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst;
223:
224: IF (ic_whse_mst_c1%NOTFOUND)
225: THEN
226: x_ic_whse_mst.whse_code := NULL;

Line 224: IF (ic_whse_mst_c1%NOTFOUND)

220: OPEN ic_whse_mst_c1;
221:
222: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst;
223:
224: IF (ic_whse_mst_c1%NOTFOUND)
225: THEN
226: x_ic_whse_mst.whse_code := NULL;
227: END IF;
228:

Line 226: x_ic_whse_mst.whse_code := NULL;

222: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst;
223:
224: IF (ic_whse_mst_c1%NOTFOUND)
225: THEN
226: x_ic_whse_mst.whse_code := NULL;
227: END IF;
228:
229: CLOSE ic_whse_mst_c1;
230:

Line 229: CLOSE ic_whse_mst_c1;

225: THEN
226: x_ic_whse_mst.whse_code := NULL;
227: END IF;
228:
229: CLOSE ic_whse_mst_c1;
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: RAISE;