13: Begin
14: x_return_status := FND_API.G_RET_STS_SUCCESS;
15: select short_name
16: into x_level_name
17: from BIS_levels
18: where level_id = p_level_id;
19: EXCEPTION
20:
21: WHEN OTHERS THEN
632: begin
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: select level_values_view_name into l_view_name
636: from bis_levels where level_id = p_dim_level_id;
637:
638: l_cursor := dbms_sql.open_cursor;
639:
640: l_select_stmt := 'select value from '|| l_view_name
694:
695: x_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: select level_values_view_name into l_view_name
698: from bis_levels where level_id = p_dim_level_id;
699: --dbms_output.put_line('view name: '||l_view_name);
700:
701: l_cursor := DBMS_SQL.OPEN_CURSOR;
702: