eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_UTILITY

Line 72: WHILE (BSC_UTILITY.is_more

68: l_found := FND_API.G_FALSE;
69: l_level_vals_list := p_level_vals_list;
70:
71: IF(cd.dim_level_id =p_dim_level_id ) THEN
72: WHILE (BSC_UTILITY.is_more
73: ( p_comma_sep_values => l_level_vals_list
74: , x_value => l_level_val
75: )
76: ) LOOP

Line 162: l_key_item_recs BSC_UTILITY.varchar_tabletype;

158: l_filter_count NUMBER;
159: l_level_val VARCHAR2(100);
160: l_level_value NUMBER;
161: l_sql VARCHAR2(500);
162: l_key_item_recs BSC_UTILITY.varchar_tabletype;
163: l_key_item_cnt NUMBER;
164: l_key_item_props_recs BSC_UTILITY.varchar_tabletype;
165: l_key_item_props_cnt NUMBER;
166: l_key_name VARCHAR2(100);

Line 164: l_key_item_props_recs BSC_UTILITY.varchar_tabletype;

160: l_level_value NUMBER;
161: l_sql VARCHAR2(500);
162: l_key_item_recs BSC_UTILITY.varchar_tabletype;
163: l_key_item_cnt NUMBER;
164: l_key_item_props_recs BSC_UTILITY.varchar_tabletype;
165: l_key_item_props_cnt NUMBER;
166: l_key_name VARCHAR2(100);
167: l_dim_level_view VARCHAR2(100);
168: l_key_item NUMBER;

Line 224: WHILE (BSC_UTILITY.is_more(p_comma_sep_values => p_level_vals_list, x_value => l_level_val)) LOOP

220: );
221: -- DELETE FROM bsc_sys_filters WHERE source_type = 1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;
222: -- INSERT all filter values in bsc_sys_filters
223: IF (p_level_vals_list IS NOT NULL) THEN --p_level_vals_list contains a comma seperated values of dim level values
224: WHILE (BSC_UTILITY.is_more(p_comma_sep_values => p_level_vals_list, x_value => l_level_val)) LOOP
225: l_level_value := TO_NUMBER(RTRIM(LTRIM(l_level_val)));
226: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters(
227: p_source_type => 1
228: ,p_source_code => p_tab_id

Line 1435: WHILE (BSC_UTILITY.is_more(p_comma_sep_values => l_level_vals_list, x_value => l_level_val)) LOOP

1431:
1432:
1433:
1434:
1435: WHILE (BSC_UTILITY.is_more(p_comma_sep_values => l_level_vals_list, x_value => l_level_val)) LOOP
1436:
1437: l_level_value := TO_NUMBER(RTRIM(LTRIM(l_level_val)));
1438:
1439: IF (l_level_value = cd.default_key_value) THEN