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_UPGRADES dependencies on BIS_INDICATORS

Line 62: p_Short_Name IN BIS_INDICATORS.short_name%TYPE

58:
59:
60: FUNCTION Validate_And_Get_Short_Name
61: (
62: p_Short_Name IN BIS_INDICATORS.short_name%TYPE
63: ) RETURN VARCHAR2;
64: /*******************************************************************************
65: Refresh_Measure_Col_Names API ensures that all the PMF measures that were
66: generated using SHORT_NAME for BSC_SYS_MEASURES.MEASURE_COL is modified to

Line 154: FROM bis_indicators i, bsc_sys_datasets_b d

150: -- but in case of datasets that are formulas between measures
151: -- they were not fetched. We need to join is with bsc_sys_datasets_b
152: CURSOR c_bsc_measures_in_pmf IS
153: SELECT indicator_id, measure_id1, i.short_name
154: FROM bis_indicators i, bsc_sys_datasets_b d
155: WHERE d.dataset_id = i.dataset_id
156: AND d.source = 'BSC';
157:
158: CURSOR c_s2e_kpis(p_indicator_id NUMBER) IS

Line 160: FROM bis_indicators BIS_IND

156: AND d.source = 'BSC';
157:
158: CURSOR c_s2e_kpis(p_indicator_id NUMBER) IS
159: SELECT count(1)
160: FROM bis_indicators BIS_IND
161: ,bsc_sys_datasets_b BSC_DTS
162: ,bsc_sys_measures BSC_MEAS
163: WHERE BIS_IND.dataset_id = BSC_DTS.dataset_id
164: AND BSC_DTS.measure_id1 = BSC_MEAS.measure_id

Line 188: FROM bis_indicators;

184: BEGIN
185: l_num_ids := 0;
186:
187: SELECT nvl(max(dataset_id),0) INTO l_max_ds_id_bis
188: FROM bis_indicators;
189:
190: SELECT nvl(max(dataset_id),0) INTO l_max_ds_id_bsc
191: FROM bsc_sys_datasets_b;
192:

Line 284: FROM bsc_sys_datasets_vl d, bis_indicators_vl i, bsc_sys_measures m

280: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
281: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
282: CURSOR bsc_indicators_cursor IS
283: SELECT d.dataset_id, i.name as measure_name, i.description, i.short_name as measure_short_name, i.indicator_id measure_id, i.created_by created_by, i.last_updated_by last_updated_by, i.last_update_login last_update_login
284: FROM bsc_sys_datasets_vl d, bis_indicators_vl i, bsc_sys_measures m
285: WHERE i.short_name = m.short_name (+)
286: and (d.source is null or d.source = 'PMF')
287: and m.measure_id = d.measure_id1 (+)
288: and (i.dataset_id is null or d.dataset_id <> i.dataset_id);

Line 364: UPDATE bis_indicators

360: , x_source => 'BSC_DB_MEASURE_COLS_PKG.INSERT_ROW'
361: , x_mode => 'I'
362: );
363: END;
364: UPDATE bis_indicators
365: SET dataset_id = l_Dataset_id
366: WHERE indicator_id = icr.measure_id;
367:
368: -- mdamle 09/25/2003 - Sync up measures for all installed languages

Line 377: UPDATE bis_indicators

373: , x_msg_count => l_msg_count
374: , x_msg_data => l_msg_data);
375:
376: ELSE
377: UPDATE bis_indicators
378: SET dataset_id = icr.dataset_id
379: WHERE indicator_id = icr.measure_id;
380: END IF;
381:

Line 441: l_Short_Name BIS_INDICATORS.short_name%TYPE;

437: l_num NUMBER;
438: i NUMBER;
439: l_err VARCHAR2(2000);
440: l_Count NUMBER;
441: l_Short_Name BIS_INDICATORS.short_name%TYPE;
442:
443: CURSOR bsc_datasets_cursor_1 IS
444: SELECT d.dataset_id, name, m.measure_id, m.created_by created_by, m.last_updated_by last_updated_by, m.last_update_login last_update_login
445: FROM bsc_sys_datasets_vl d, bsc_sys_measures m, bisbv_performance_measures pm

Line 567: -- exits in bis_indicators or not.if the measure exists and its dataset_id

563: AND (pm.dataset_id IS NULL);
564:
565: BEGIN
566: --For CDS type of measures we need to check if that measure id
567: -- exits in bis_indicators or not.if the measure exists and its dataset_id
568: -- is set to NULL then we need to populate
569: l_num := 0;
570: FOR cd IN cds_datasets_cursor LOOP
571: BEGIN

Line 575: UPDATE bis_indicators

571: BEGIN
572: SAVEPOINT SP_SYNC_CDS_MEASURE;
573: IF(cd.short_name IS NOT NULL)THEN
574:
575: UPDATE bis_indicators
576: SET dataset_id =cd.dataset_id
577: WHERE short_name =cd.short_name;
578:
579: END IF;

Line 649: -- mdamle 09/22/2003 - First check if the dataset already exists in bis_indicators

645: FOR cr IN bsc_datasets_cursor_2 LOOP
646: BEGIN
647: SAVEPOINT SP_SYNC_MEASURE;
648: IF cr.measure_short_name is not null then
649: -- mdamle 09/22/2003 - First check if the dataset already exists in bis_indicators
650: -- When more than 1 dataset points to the same measure, the short_name in measures
651: -- will match with only one of the datasets.
652: -- If these datasets were already synchronized above, then there would be a record
653: -- in bis_indicators for every dataset. Hence, added the check here so that

Line 653: -- in bis_indicators for every dataset. Hence, added the check here so that

649: -- mdamle 09/22/2003 - First check if the dataset already exists in bis_indicators
650: -- When more than 1 dataset points to the same measure, the short_name in measures
651: -- will match with only one of the datasets.
652: -- If these datasets were already synchronized above, then there would be a record
653: -- in bis_indicators for every dataset. Hence, added the check here so that
654: -- update is done only if that dataset id is not already set in bis_indicators
655: SELECT count(1) INTO l_count
656: FROM BISBV_PERFORMANCE_MEASURES
657: WHERE dataset_id = cr.dataset_id;

Line 654: -- update is done only if that dataset id is not already set in bis_indicators

650: -- When more than 1 dataset points to the same measure, the short_name in measures
651: -- will match with only one of the datasets.
652: -- If these datasets were already synchronized above, then there would be a record
653: -- in bis_indicators for every dataset. Hence, added the check here so that
654: -- update is done only if that dataset id is not already set in bis_indicators
655: SELECT count(1) INTO l_count
656: FROM BISBV_PERFORMANCE_MEASURES
657: WHERE dataset_id = cr.dataset_id;
658:

Line 660: UPDATE BIS_INDICATORS

656: FROM BISBV_PERFORMANCE_MEASURES
657: WHERE dataset_id = cr.dataset_id;
658:
659: IF (l_count = 0) THEN
660: UPDATE BIS_INDICATORS
661: SET dataset_id = cr.dataset_id
662: WHERE short_name = cr.measure_short_name;
663: END IF;
664: ELSE

Line 809: ,bis_indicators_Vl B

805: ,B.dataset_id
806: ,M.measure_id
807: FROM bsc_sys_measures M
808: ,bsc_sys_datasets_vl V
809: ,bis_indicators_Vl B
810: WHERE M.measure_id = V.measure_id1
811: AND B.dataset_id = V.dataset_id
812: AND V.SOURCE = 'BSC'
813: AND M.short_name IS NULL;

Line 815: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;

811: AND B.dataset_id = V.dataset_id
812: AND V.SOURCE = 'BSC'
813: AND M.short_name IS NULL;
814:
815: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
816: l_Bsc_Measure_Short_Name BSC_SYS_MEASURES.SHORT_NAME%TYPE;
817: BEGIN
818: SAVEPOINT SP_UPDATE_SHORT_NAME;
819: FOR cBSCM IN cBscSysMeasures LOOP

Line 851: -- If the dataset_ids from BIS_INDICATORS and BSC_SYS_DATASETS_VL are not in synch

847:
848: BEGIN
849:
850: -- meastmon bug#3379110 --------------------------------------------------------------------
851: -- If the dataset_ids from BIS_INDICATORS and BSC_SYS_DATASETS_VL are not in synch
852: -- we are going to:
853: -- 1. Remove BSC measures from PMF repository
854: -- 2. Update all the dataset_ids to NULL.
855: -- Then synchronization will refresh the dataset_id in BIS_INDICATORS with the correct value

Line 855: -- Then synchronization will refresh the dataset_id in BIS_INDICATORS with the correct value

851: -- If the dataset_ids from BIS_INDICATORS and BSC_SYS_DATASETS_VL are not in synch
852: -- we are going to:
853: -- 1. Remove BSC measures from PMF repository
854: -- 2. Update all the dataset_ids to NULL.
855: -- Then synchronization will refresh the dataset_id in BIS_INDICATORS with the correct value
856: -- from BSC_SYS_DATASETS_VL
857: delete_bsc_measures_from_pmf;
858:
859: -- For every PMF record that does not exist in bsc_sys_datasets, create one in bsc_sys_datasets and bsc_sys_measures

Line 1016: l_name bis_indicators_tl.name%type;

1012: from FND_LANGUAGES L
1013: where L.INSTALLED_FLAG in ('I', 'B')
1014: and language_code <> userenv('LANG');
1015:
1016: l_name bis_indicators_tl.name%type;
1017: l_description bis_indicators_tl.description%type;
1018: l_measure_name bis_indicators_tl.name%type;
1019: l_source_lang bis_indicators_tl.source_lang%type;
1020: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

Line 1017: l_description bis_indicators_tl.description%type;

1013: where L.INSTALLED_FLAG in ('I', 'B')
1014: and language_code <> userenv('LANG');
1015:
1016: l_name bis_indicators_tl.name%type;
1017: l_description bis_indicators_tl.description%type;
1018: l_measure_name bis_indicators_tl.name%type;
1019: l_source_lang bis_indicators_tl.source_lang%type;
1020: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1021: BEGIN

Line 1018: l_measure_name bis_indicators_tl.name%type;

1014: and language_code <> userenv('LANG');
1015:
1016: l_name bis_indicators_tl.name%type;
1017: l_description bis_indicators_tl.description%type;
1018: l_measure_name bis_indicators_tl.name%type;
1019: l_source_lang bis_indicators_tl.source_lang%type;
1020: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1021: BEGIN
1022:

Line 1019: l_source_lang bis_indicators_tl.source_lang%type;

1015:
1016: l_name bis_indicators_tl.name%type;
1017: l_description bis_indicators_tl.description%type;
1018: l_measure_name bis_indicators_tl.name%type;
1019: l_source_lang bis_indicators_tl.source_lang%type;
1020: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1021: BEGIN
1022:
1023: l_dataset_rec := p_dataset_rec;

Line 1026: FROM bis_indicators_tl

1022:
1023: l_dataset_rec := p_dataset_rec;
1024:
1025: SELECT name INTO l_measure_name
1026: FROM bis_indicators_tl
1027: WHERE indicator_id = p_indicator_id
1028: AND language = userenv('LANG');
1029:
1030: for cr in installed_languages_cursor loop

Line 1033: from bis_indicators_tl

1029:
1030: for cr in installed_languages_cursor loop
1031: select name, description, source_lang
1032: into l_name, l_description, l_source_lang
1033: from bis_indicators_tl
1034: where indicator_id = p_indicator_id
1035: and language = cr.language_code;
1036:
1037: -- ankgoel: bug#3874911

Line 1108: from bis_indicators i, bis_indicators_tl itl, bsc_sys_datasets_b d, bsc_sys_datasets_tl dtl

1104: cursor synch_lang_cursor is
1105: select i.indicator_id, itl.language, itl.source_lang, i.short_name, d.source, d.dataset_id,
1106: itl.name indicator_name, dtl.name dataset_name,
1107: itl.description, dtl.help
1108: from bis_indicators i, bis_indicators_tl itl, bsc_sys_datasets_b d, bsc_sys_datasets_tl dtl
1109: where i.indicator_id = itl.indicator_id
1110: and i.dataset_id = dtl.dataset_id
1111: and d.dataset_id = dtl.dataset_id
1112: and itl.language = dtl.language

Line 1117: l_measure_name BIS_INDICATORS_TL.Name%TYPE;

1113: and itl.name <> dtl.name;
1114:
1115: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1116: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
1117: l_measure_name BIS_INDICATORS_TL.Name%TYPE;
1118: l_count number;
1119: BEGIN
1120:
1121: for scr in synch_lang_cursor loop

Line 1142: FROM bis_indicators_tl

1138: , x_error_Tbl => x_error_tbl
1139: );
1140: else
1141: SELECT name INTO l_measure_name
1142: FROM bis_indicators_tl
1143: WHERE indicator_id = scr.indicator_id
1144: AND language = userenv('LANG');
1145:
1146: l_dataset_rec.bsc_dataset_id := scr.dataset_id;

Line 1223: from bis_indicators_tl

1219: begin
1220: l_pmf_disp_name := trim(p_dataset_name);
1221:
1222: select count(indicator_id) into l_count
1223: from bis_indicators_tl
1224: where upper(name) = upper(l_pmf_disp_name)
1225: and language = p_language;
1226:
1227: while(l_count > 0) loop

Line 1231: from bis_indicators_tl

1227: while(l_count > 0) loop
1228: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);
1229:
1230: select count(indicator_id) into l_count
1231: from bis_indicators_tl
1232: where upper(name) = upper(l_pmf_disp_name)
1233: and language = p_language;
1234: end loop;
1235:

Line 2490: bis_indicators bisindic,

2486: l_return_Status BOOLEAN;
2487: CURSOR c_update_appid IS
2488: SELECT bisapp.indicator_id
2489: FROM bis_application_measures bisapp,
2490: bis_indicators bisindic,
2491: bsc_sys_datasets_vl bsc
2492: WHERE bisapp.indicator_id = bisindic.indicator_id
2493: AND bisindic.dataset_id = bsc.dataset_id
2494: AND bsc.source= 'BSC'

Line 2528: p_Short_Name IN BIS_INDICATORS.short_name%TYPE

2524: /************************************************************************/
2525:
2526: FUNCTION Validate_And_Get_Short_Name
2527: (
2528: p_Short_Name IN BIS_INDICATORS.short_name%TYPE
2529: ) RETURN VARCHAR2
2530: IS
2531: l_measure_short_name BIS_INDICATORS.short_name%TYPE;
2532: l_temp_var BIS_INDICATORS.short_name%TYPE;

Line 2531: l_measure_short_name BIS_INDICATORS.short_name%TYPE;

2527: (
2528: p_Short_Name IN BIS_INDICATORS.short_name%TYPE
2529: ) RETURN VARCHAR2
2530: IS
2531: l_measure_short_name BIS_INDICATORS.short_name%TYPE;
2532: l_temp_var BIS_INDICATORS.short_name%TYPE;
2533: l_alias VARCHAR2(5);
2534: l_flag BOOLEAN;
2535: l_count NUMBER;

Line 2532: l_temp_var BIS_INDICATORS.short_name%TYPE;

2528: p_Short_Name IN BIS_INDICATORS.short_name%TYPE
2529: ) RETURN VARCHAR2
2530: IS
2531: l_measure_short_name BIS_INDICATORS.short_name%TYPE;
2532: l_temp_var BIS_INDICATORS.short_name%TYPE;
2533: l_alias VARCHAR2(5);
2534: l_flag BOOLEAN;
2535: l_count NUMBER;
2536:

Line 2545: FROM BIS_INDICATORS

2541:
2542: WHILE (l_flag) LOOP
2543: SELECT count(1)
2544: INTO l_count
2545: FROM BIS_INDICATORS
2546: WHERE UPPER(TRIM(Short_Name)) = UPPER(TRIM(l_temp_var));
2547:
2548: IF (l_count = 0) THEN
2549: l_flag := FALSE;

Line 2590: BIS_INDICATORS_VL I

2586: I.NAME
2587: FROM
2588: BSC_SYS_MEASURES M,
2589: BSC_SYS_DATASETS_VL D,
2590: BIS_INDICATORS_VL I
2591: WHERE
2592: M.MEASURE_ID = D.MEASURE_ID1 AND
2593: D.DATASET_ID=I.DATASET_ID AND
2594: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND

Line 2605: BIS_INDICATORS_VL I

2601: I.DATASET_ID,
2602: I.NAME
2603: FROM
2604: BSC_SYS_MEASURES M,
2605: BIS_INDICATORS_VL I
2606: WHERE
2607: M.SHORT_NAME = I.SHORT_NAME AND
2608: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND
2609: M.MEASURE_COL = I.SHORT_NAME ORDER BY I.DATASET_ID;*/