APPS.GMIGUTL dependencies on SY_UOMS_TYP

Line 362: | and sy_uoms_typ |

358: | Used to retrieve unit of measure details |
359: | |
360: | DESCRIPTION |
361: | This procedure is used to retrieve all details from sy_uoms_mst |
362: | and sy_uoms_typ |
363: | |
364: | PARAMETERS |
365: | p_um_code IN VARCHAR2(4) - Unit of measure code to be retrieved |
366: | x_sy_uoms_mst OUT RECORD - Record containing sy_uoms_mst details |

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

363: | |
364: | PARAMETERS |
365: | p_um_code IN VARCHAR2(4) - Unit of measure code to be retrieved |
366: | x_sy_uoms_mst OUT RECORD - Record containing sy_uoms_mst details |
367: | x_sy_uoms_typ OUT RECORD - Record containing sy_uoms_typ details |
368: | x_error_code OUT NUMBER - Error code returned |
369: | |
370: | HISTORY |
371: +=========================================================================+

Line 376: , x_sy_uoms_typ_row OUT NOCOPY sy_uoms_typ%ROWTYPE

372: */
373: PROCEDURE Get_Um
374: ( p_um_code IN sy_uoms_mst.um_code%TYPE
375: , x_sy_uoms_mst_row OUT NOCOPY sy_uoms_mst%ROWTYPE
376: , x_sy_uoms_typ_row OUT NOCOPY sy_uoms_typ%ROWTYPE
377: )
378: IS
379: BEGIN
380: x_sy_uoms_mst_row.um_code := p_um_code;

Line 383: x_sy_uoms_typ_row.um_type := x_sy_uoms_mst_row.um_type;

379: BEGIN
380: x_sy_uoms_mst_row.um_code := p_um_code;
381: IF GMIVDBL.sy_uoms_mst_select(x_sy_uoms_mst_row, x_sy_uoms_mst_row)
382: THEN
383: x_sy_uoms_typ_row.um_type := x_sy_uoms_mst_row.um_type;
384: IF GMIVDBL.sy_uoms_typ_select (x_sy_uoms_typ_row, x_sy_uoms_typ_row)
385: THEN
386: RETURN;
387: END IF;

Line 384: IF GMIVDBL.sy_uoms_typ_select (x_sy_uoms_typ_row, x_sy_uoms_typ_row)

380: x_sy_uoms_mst_row.um_code := p_um_code;
381: IF GMIVDBL.sy_uoms_mst_select(x_sy_uoms_mst_row, x_sy_uoms_mst_row)
382: THEN
383: x_sy_uoms_typ_row.um_type := x_sy_uoms_mst_row.um_type;
384: IF GMIVDBL.sy_uoms_typ_select (x_sy_uoms_typ_row, x_sy_uoms_typ_row)
385: THEN
386: RETURN;
387: END IF;
388: END IF;