126: Function get_level_id ( p_dim_code in varchar2, p_level_name in varchar2) return number is
127:
128: cursor c_lvl is
129: select level_id
130: from msd_levels
131: where dimension_code = p_dim_code and level_name = p_level_name;
132:
133: l_ret number;
134:
152: Function get_level_name ( p_dim_code in varchar2, p_level_id varchar2) return varchar2 is
153:
154: cursor c_lvl is
155: select level_name
156: from msd_levels
157: where dimension_code = p_dim_code and level_id = p_level_id;
158:
159: l_ret varchar2(80);
160:
184: lookup_code = p_level_id;
185:
186: cursor c_lvl is
187: select description
188: from msd_levels_v
189: where owning_dimension_code = p_dim_code and level_id = p_level_id;
190:
191: l_ret varchar2(80);
192: