APPS.BSC_UPGRADES dependencies on BIS_INDICATORS_TL

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: