APPS.GMI_GLOBAL_GRP dependencies on SY_UOMS_MST

Line 306: --| This procedure is used to retrieve all details from sy_uoms_mst |

302: --| USAGE |
303: --| Used to retrieve unit of measure details |
304: --| |
305: --| DESCRIPTION |
306: --| This procedure is used to retrieve all details from sy_uoms_mst |
307: --| and sy_uoms_typ |
308: --| |
309: --| PARAMETERS |
310: --| p_um_code IN VARCHAR2(4) - Unit of measure code to be retrieved |

Line 311: --| x_sy_uoms_mst OUT RECORD - Record containing sy_uoms_mst details |

307: --| and sy_uoms_typ |
308: --| |
309: --| PARAMETERS |
310: --| p_um_code IN VARCHAR2(4) - Unit of measure code to be retrieved |
311: --| x_sy_uoms_mst OUT RECORD - Record containing sy_uoms_mst details |
312: --| x_sy_uoms_typ OUT RECORD - Record containing sy_uoms_typ details |
313: --| x_error_code OUT NUMBER - Error code returned |
314: --| |
315: --| HISTORY |

Line 319: ( p_um_code IN sy_uoms_mst.um_code%TYPE

315: --| HISTORY |
316: --| 01-OCT-1998 M.Godfrey Created |
317: --+=========================================================================+
318: PROCEDURE Get_Um
319: ( p_um_code IN sy_uoms_mst.um_code%TYPE
320: , x_sy_uoms_mst OUT NOCOPY sy_uoms_mst%ROWTYPE
321: , x_sy_uoms_typ OUT NOCOPY sy_uoms_typ%ROWTYPE
322: , x_error_code OUT NOCOPY NUMBER
323: )

Line 320: , x_sy_uoms_mst OUT NOCOPY sy_uoms_mst%ROWTYPE

316: --| 01-OCT-1998 M.Godfrey Created |
317: --+=========================================================================+
318: PROCEDURE Get_Um
319: ( p_um_code IN sy_uoms_mst.um_code%TYPE
320: , x_sy_uoms_mst OUT NOCOPY sy_uoms_mst%ROWTYPE
321: , x_sy_uoms_typ OUT NOCOPY sy_uoms_typ%ROWTYPE
322: , x_error_code OUT NOCOPY NUMBER
323: )
324: IS

Line 325: CURSOR sy_uoms_mst_c1 IS

321: , x_sy_uoms_typ OUT NOCOPY sy_uoms_typ%ROWTYPE
322: , x_error_code OUT NOCOPY NUMBER
323: )
324: IS
325: CURSOR sy_uoms_mst_c1 IS
326: SELECT
327: *
328: FROM
329: sy_uoms_mst

Line 329: sy_uoms_mst

325: CURSOR sy_uoms_mst_c1 IS
326: SELECT
327: *
328: FROM
329: sy_uoms_mst
330: WHERE
331: um_code = p_um_code
332: AND delete_mark = 0;
333:

Line 343: l_sy_uoms_mst sy_uoms_mst%ROWTYPE;

339: WHERE
340: um_type = v_um_type
341: AND delete_mark = 0;
342:
343: l_sy_uoms_mst sy_uoms_mst%ROWTYPE;
344:
345: BEGIN
346:
347: x_error_code := 0;

Line 349: OPEN sy_uoms_mst_c1;

345: BEGIN
346:
347: x_error_code := 0;
348:
349: OPEN sy_uoms_mst_c1;
350:
351: FETCH sy_uoms_mst_c1 INTO l_sy_uoms_mst;
352:
353: IF (sy_uoms_mst_c1%NOTFOUND)

Line 351: FETCH sy_uoms_mst_c1 INTO l_sy_uoms_mst;

347: x_error_code := 0;
348:
349: OPEN sy_uoms_mst_c1;
350:
351: FETCH sy_uoms_mst_c1 INTO l_sy_uoms_mst;
352:
353: IF (sy_uoms_mst_c1%NOTFOUND)
354: THEN
355: x_error_code := -1;

Line 353: IF (sy_uoms_mst_c1%NOTFOUND)

349: OPEN sy_uoms_mst_c1;
350:
351: FETCH sy_uoms_mst_c1 INTO l_sy_uoms_mst;
352:
353: IF (sy_uoms_mst_c1%NOTFOUND)
354: THEN
355: x_error_code := -1;
356: ELSE
357: x_sy_uoms_mst := l_sy_uoms_mst;

Line 357: x_sy_uoms_mst := l_sy_uoms_mst;

353: IF (sy_uoms_mst_c1%NOTFOUND)
354: THEN
355: x_error_code := -1;
356: ELSE
357: x_sy_uoms_mst := l_sy_uoms_mst;
358: OPEN sy_uoms_typ_c1(l_sy_uoms_mst.um_type);
359: FETCH sy_uoms_typ_c1 INTO x_sy_uoms_typ;
360:
361: IF (sy_uoms_typ_c1%NOTFOUND)

Line 358: OPEN sy_uoms_typ_c1(l_sy_uoms_mst.um_type);

354: THEN
355: x_error_code := -1;
356: ELSE
357: x_sy_uoms_mst := l_sy_uoms_mst;
358: OPEN sy_uoms_typ_c1(l_sy_uoms_mst.um_type);
359: FETCH sy_uoms_typ_c1 INTO x_sy_uoms_typ;
360:
361: IF (sy_uoms_typ_c1%NOTFOUND)
362: THEN

Line 368: CLOSE sy_uoms_mst_c1;

364: END IF;
365: CLOSE sy_uoms_typ_c1;
366: END IF;
367:
368: CLOSE sy_uoms_mst_c1;
369:
370: EXCEPTION
371: WHEN OTHERS THEN
372: RAISE;