APPS.GMIGUTL dependencies on SY_UOMS_MST

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

357: | USAGE |
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 |

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

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 |
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 |

Line 374: ( p_um_code IN sy_uoms_mst.um_code%TYPE

370: | HISTORY |
371: +=========================================================================+
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

Line 375: , x_sy_uoms_mst_row OUT NOCOPY sy_uoms_mst%ROWTYPE

371: +=========================================================================+
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

Line 380: x_sy_uoms_mst_row.um_code := p_um_code;

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;
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)

Line 381: IF GMIVDBL.sy_uoms_mst_select(x_sy_uoms_mst_row, x_sy_uoms_mst_row)

377: )
378: IS
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

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 394: x_sy_uoms_mst_row.um_code := NULL;

390: RAISE FND_API.G_EXC_ERROR;
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: x_sy_uoms_mst_row.um_code := NULL;
395: END Get_Um;
396:
397: FUNCTION v_expaction_code
398: ( p_action_code IN qc_actn_mst.action_code%TYPE