APPS.PO_GML_DB_COMMON dependencies on SY_UOMS_MST

Line 63: v_um_code SY_UOMS_MST.UM_CODE%TYPE;

59: # 06-FEB-2001 MChandak Created
60: #
61: ## #######################################################################*/
62: FUNCTION get_opm_uom_code(x_apps_unit_meas_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
63: v_um_code SY_UOMS_MST.UM_CODE%TYPE;
64: v_progress VARCHAR2(3) := '010';
65: BEGIN
66: /*
67: Select decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,

Line 79: From sy_uoms_mst

75: /* Bug #3514053 */
76:
77: Select um_code
78: Into v_um_code
79: From sy_uoms_mst
80: Where unit_of_measure = x_apps_unit_meas_lookup_code;
81:
82: RETURN(v_um_code);
83:

Line 129: from sy_uoms_mst

125: /* Bug #3514053 */
126:
127: select unit_of_measure,delete_mark
128: into v_unit_of_measure,v_delete_mark
129: from sy_uoms_mst
130: where um_code = x_opm_um_code;
131:
132: If v_delete_mark = 1 then
133: raise uom_deleted;