APPS.GMI_GLOBAL_GRP dependencies on SY_UOMS_TYP

Line 307: --| and sy_uoms_typ |

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 |
311: --| x_sy_uoms_mst OUT RECORD - Record containing sy_uoms_mst details |

Line 312: --| x_sy_uoms_typ OUT RECORD - Record containing sy_uoms_typ details |

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 |
316: --| 01-OCT-1998 M.Godfrey Created |

Line 321: , x_sy_uoms_typ OUT NOCOPY sy_uoms_typ%ROWTYPE

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
325: CURSOR sy_uoms_mst_c1 IS

Line 334: CURSOR sy_uoms_typ_c1(v_um_type sy_uoms_typ.um_type%TYPE) IS

330: WHERE
331: um_code = p_um_code
332: AND delete_mark = 0;
333:
334: CURSOR sy_uoms_typ_c1(v_um_type sy_uoms_typ.um_type%TYPE) IS
335: SELECT
336: *
337: FROM
338: sy_uoms_typ

Line 338: sy_uoms_typ

334: CURSOR sy_uoms_typ_c1(v_um_type sy_uoms_typ.um_type%TYPE) IS
335: SELECT
336: *
337: FROM
338: sy_uoms_typ
339: WHERE
340: um_type = v_um_type
341: AND delete_mark = 0;
342:

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 359: FETCH sy_uoms_typ_c1 INTO x_sy_uoms_typ;

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
363: x_error_code := -2;

Line 361: IF (sy_uoms_typ_c1%NOTFOUND)

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
363: x_error_code := -2;
364: END IF;
365: CLOSE sy_uoms_typ_c1;

Line 365: CLOSE sy_uoms_typ_c1;

361: IF (sy_uoms_typ_c1%NOTFOUND)
362: THEN
363: x_error_code := -2;
364: END IF;
365: CLOSE sy_uoms_typ_c1;
366: END IF;
367:
368: CLOSE sy_uoms_mst_c1;
369: