DBA Data[Home] [Help]

APPS.GMIVITM dependencies on SY_UOMS_MST

Line 373: l_sy_uoms_mst_row sy_uoms_mst%ROWTYPE;

369: )
370: IS
371: l_ic_item_mst_row ic_item_mst%ROWTYPE;
372: l_ic_item_cpg_row ic_item_cpg%ROWTYPE;
373: l_sy_uoms_mst_row sy_uoms_mst%ROWTYPE;
374: l_sy_uoms_typ_row sy_uoms_typ%ROWTYPE;
375: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
376: l_qc_actn_mst_row qc_actn_mst%ROWTYPE;
377: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;

Line 410: GMIGUTL.get_um(RTRIM(p_item_rec.item_um), l_sy_uoms_mst_row, l_sy_uoms_typ_row);

406: x_ic_item_mst_row.alt_itemb := RTRIM(p_item_rec.alt_itemb);
407:
408: /* Unit of Measure */
409:
410: GMIGUTL.get_um(RTRIM(p_item_rec.item_um), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
411: IF l_sy_uoms_mst_row.um_code IS NOT NULL
412: THEN
413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);
414: ELSE

Line 411: IF l_sy_uoms_mst_row.um_code IS NOT NULL

407:
408: /* Unit of Measure */
409:
410: GMIGUTL.get_um(RTRIM(p_item_rec.item_um), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
411: IF l_sy_uoms_mst_row.um_code IS NOT NULL
412: THEN
413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);
414: ELSE
415: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

Line 413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);

409:
410: GMIGUTL.get_um(RTRIM(p_item_rec.item_um), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
411: IF l_sy_uoms_mst_row.um_code IS NOT NULL
412: THEN
413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);
414: ELSE
415: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
416: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
417: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um);

Line 446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);

442: IF NVL(p_item_rec.item_um2, x_ic_item_mst_row.item_um) <>
443: x_ic_item_mst_row.item_um
444: THEN
445: -- BUG#2461984 VAK
446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
447: IF l_sy_uoms_mst_row.um_code IS NOT NULL
448: THEN
449: -- BUG#2461984 VAK
450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);

Line 447: IF l_sy_uoms_mst_row.um_code IS NOT NULL

443: x_ic_item_mst_row.item_um
444: THEN
445: -- BUG#2461984 VAK
446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
447: IF l_sy_uoms_mst_row.um_code IS NOT NULL
448: THEN
449: -- BUG#2461984 VAK
450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);
451: END IF;

Line 450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);

446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
447: IF l_sy_uoms_mst_row.um_code IS NOT NULL
448: THEN
449: -- BUG#2461984 VAK
450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);
451: END IF;
452: END IF;
453:
454: IF x_ic_item_mst_row.item_um2 IS NULL