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_SYS_FILTERS

Line 221: -- DELETE FROM bsc_sys_filters WHERE source_type = 1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;

217: ,x_return_status => x_return_status
218: ,x_msg_count => x_msg_count
219: ,x_msg_data => x_msg_data
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)));

Line 222: -- INSERT all filter values in bsc_sys_filters

218: ,x_msg_count => x_msg_count
219: ,x_msg_data => x_msg_data
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(

Line 236: -- INSERT INTO bsc_sys_filters(source_type,source_code, dim_level_id,dim_level_value) VALUES (1,p_tab_id ,p_dim_level_id, l_level_value );

232: ,x_return_status => x_return_status
233: ,x_msg_count => x_msg_count
234: ,x_msg_data => x_msg_data
235: );
236: -- INSERT INTO bsc_sys_filters(source_type,source_code, dim_level_id,dim_level_value) VALUES (1,p_tab_id ,p_dim_level_id, l_level_value );
237: END LOOP;
238:
239: --INSERT 'ALL' value also.
240: BSC_DIM_LEVEL_FILTERS_PVT.insert_filters(

Line 250: --INSERT INTO bsc_sys_filters(source_type, source_code, dim_level_id,dim_level_value) VALUES (1,p_tab_id , p_dim_level_id, 0);

246: ,x_return_status => x_return_status
247: ,x_msg_count => x_msg_count
248: ,x_msg_data => x_msg_data
249: );
250: --INSERT INTO bsc_sys_filters(source_type, source_code, dim_level_id,dim_level_value) VALUES (1,p_tab_id , p_dim_level_id, 0);
251: END IF;
252:
253: --Validate and rebuild level values VIEW definition and validate each child dimension object
254: BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view(

Line 345: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1

341:
342: CURSOR c_parents IS
343: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
344: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
345: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
346: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
347: FROM bsc_sys_dim_level_rels a
348: WHERE a.dim_level_id = p_dim_level_id
349: AND a.relation_type=1

Line 367: FROM bsc_sys_filters_views

363: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));
364:
365: CURSOR c_fil_view IS
366: SELECT level_view_name
367: FROM bsc_sys_filters_views
368: WHERE source_type = 1
369: AND source_code = p_tab_id
370: AND dim_level_id = p_dim_level_id;
371:

Line 386: FROM bsc_sys_filters

382: RETURN;
383: END IF;
384:
385: SELECT COUNT(0) INTO l_filter_count
386: FROM bsc_sys_filters
387: WHERE source_type = 1
388: AND source_code=p_tab_id
389: AND dim_level_id = p_dim_level_id;
390:

Line 422: --DELETE entry from bsc_sys_filters_views

418: IF (l_view IS NOT NULL) THEN
419:
420: EXECUTE IMMEDIATE ('DROP VIEW ' || l_view); --DROP FILTER VIEW
421:
422: --DELETE entry from bsc_sys_filters_views
423: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view (
424: p_tab_id => p_tab_id
425: ,p_dim_level_id => p_dim_level_id
426: ,p_commit => FND_API.G_FALSE

Line 431: --DELETE FROM bsc_sys_filters_views WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;

427: ,x_return_status => x_return_status
428: ,x_msg_count => x_msg_count
429: ,x_msg_data => x_msg_data
430: );
431: --DELETE FROM bsc_sys_filters_views WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;
432:
433: --DELTER entry from bsc_sys_filters
434: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters (
435: p_tab_id => p_tab_id

Line 433: --DELTER entry from bsc_sys_filters

429: ,x_msg_data => x_msg_data
430: );
431: --DELETE FROM bsc_sys_filters_views WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;
432:
433: --DELTER entry from bsc_sys_filters
434: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters (
435: p_tab_id => p_tab_id
436: ,p_dim_level_id => p_dim_level_id
437: ,p_commit => FND_API.G_FALSE

Line 442: -- DELETE FROM bsc_sys_filters WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;

438: ,x_return_status => x_return_status
439: ,x_msg_count => x_msg_count
440: ,x_msg_data => x_msg_data
441: );
442: -- DELETE FROM bsc_sys_filters WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;
443:
444: END IF;
445: END IF;
446: BSC_COMMON_DIMENSIONS_PUB.change_prototype_flag(

Line 566: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1

562:
563: CURSOR c_parents IS
564: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
565: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
566: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
567: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
568: FROM bsc_sys_dim_level_rels a
569: WHERE a.dim_level_id = p_dim_level_id
570: AND a.relation_type=1;

Line 574: FROM bsc_sys_filters_views

570: AND a.relation_type=1;
571:
572: CURSOR c_fil_view IS
573: SELECT level_view_name
574: FROM bsc_sys_filters_views
575: WHERE source_type = 1
576: AND source_code = p_tab_id
577: AND dim_level_id = p_dim_level_id;
578:

Line 624: ---INSERT INTO bsc_sys_filters_views(source_type, source_code, dim_level_id, level_table_name, level_view_name) VALUES (1, p_tab_id, p_dim_level_id, l_table,l_view);

620: ,x_return_status => x_return_status
621: ,x_msg_count => x_msg_count
622: ,x_msg_data => x_msg_data
623: );
624: ---INSERT INTO bsc_sys_filters_views(source_type, source_code, dim_level_id, level_table_name, level_view_name) VALUES (1, p_tab_id, p_dim_level_id, l_table,l_view);
625: END IF;
626:
627: FOR cd IN c_dim_view LOOP
628: l_view_name := cd.level_view_name;

Line 634: FROM bsc_sys_filters

630: END LOOP;
631:
632:
633: SELECT COUNT(0) INTO l_filter_count
634: FROM bsc_sys_filters
635: WHERE source_type= 1
636: AND source_code = p_tab_id
637: AND dim_level_id = p_dim_level_id;
638:

Line 641: l_sql_tables := 'bsc_sys_filters f, ' || l_view_name || ' d ';

637: AND dim_level_id = p_dim_level_id;
638:
639:
640: IF (l_filter_count > 0) THEN
641: l_sql_tables := 'bsc_sys_filters f, ' || l_view_name || ' d ';
642: l_sql_where_cond := ' f.source_type=1 AND f.source_code=' || p_tab_id || ' AND f.dim_level_id=' || p_dim_level_id || ' AND f.dim_level_value=d.code';
643:
644: ELSE
645: l_cnt := 0;

Line 830: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1

826:
827: CURSOR c_parents IS
828: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
829: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
830: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
831: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
832: FROM bsc_sys_dim_level_rels a
833: WHERE a.dim_level_id = p_dim_level_id AND a.relation_type=1 ;
834:

Line 954: FROM bsc_sys_filters_views

950: IS
951:
952: CURSOR c_filter_view IS
953: SELECT level_view_name
954: FROM bsc_sys_filters_views
955: WHERE source_type=1
956: AND source_code = p_tab_id
957: AND dim_level_id = p_dim_level_id;
958:

Line 997: x_sql := x_sql || ' FROM bsc_sys_filters f WHERE f.source_type=1 AND f.source_code=';

993:
994: x_sql := 'SELECT TO_CHAR(f.dim_level_value) ID, ';
995: x_sql := x_sql || '(SELECT v.name FROM ' || l_sql_view || ' v ';
996: x_sql := x_sql || ' WHERE v.code=f.dim_level_value and rownum < 2 ) VALUE ';
997: x_sql := x_sql || ' FROM bsc_sys_filters f WHERE f.source_type=1 AND f.source_code=';
998: x_sql := x_sql || p_tab_id || ' AND f.dim_level_id=' || p_dim_level_id || ' AND f.dim_level_value <> 0';
999: x_sql := x_sql || ' ORDER BY VALUE ';
1000:
1001: ELSE

Line 1090: FROM bsc_sys_filters_views

1086: ref_cur ref_cursor;
1087:
1088: CURSOR c_ch_dim_view IS
1089: SELECT level_view_name
1090: FROM bsc_sys_filters_views
1091: WHERE source_type = 1
1092: AND source_code = p_tab_id
1093: AND dim_level_id = p_ch_level_id;
1094:

Line 1097: FROM bsc_sys_filters_views

1093: AND dim_level_id = p_ch_level_id;
1094:
1095: CURSOR c_pa_dim_view IS
1096: SELECT level_view_name
1097: FROM bsc_sys_filters_views
1098: WHERE source_type = 1
1099: AND source_code = p_tab_id
1100: AND dim_level_id = p_pa_level_id;
1101:

Line 1158: FROM bsc_sys_filters

1154:
1155: l_row_count := ref_cur%ROWCOUNT;
1156:
1157: SELECT COUNT(0) INTO l_filter_count
1158: FROM bsc_sys_filters
1159: WHERE source_type= 1
1160: AND source_code = p_tab_id
1161: AND dim_level_id = p_ch_level_id;
1162:

Line 1165: FROM bsc_sys_filters

1161: AND dim_level_id = p_ch_level_id;
1162:
1163: IF (l_row_count >= l_filter_count - 1) THEN -- Unmatched filter values present in the child
1164: DELETE
1165: FROM bsc_sys_filters
1166: WHERE source_type = 1
1167: AND source_code = p_tab_id
1168: AND dim_level_id = p_ch_level_id;
1169:

Line 1179: FROM bsc_sys_filters

1175:
1176: IF (l_code IS NOT NULL) THEN
1177:
1178: DELETE
1179: FROM bsc_sys_filters
1180: WHERE source_type = 1
1181: AND source_code = p_tab_id
1182: AND dim_level_id = p_ch_level_id
1183: AND dim_level_value = l_code;

Line 1194: FROM bsc_sys_filters

1190: CLOSE ref_cur;
1191: END IF;
1192:
1193: SELECT COUNT(0) INTO l_filter_count
1194: FROM bsc_sys_filters
1195: WHERE source_type= 1
1196: AND source_code = p_tab_id
1197: AND dim_level_id = p_ch_level_id;
1198:

Line 1202: FROM bsc_sys_filters

1198:
1199: IF (l_filter_count = 1) THEN
1200:
1201: DELETE
1202: FROM bsc_sys_filters
1203: WHERE source_type = 1
1204: AND source_code = p_tab_id
1205: AND dim_level_id = p_ch_level_id;
1206: END IF;