APPS.BSC_UPGRADES dependencies on BSC_SYS_DATASETS_TL

Line 28: --- 29-SEP-2003 mdamle Bug#3168129 - Change l_pmf_disp_name to bsc_sys_datasets_tl.name%type

24: --- being created when migrating from another system.
25: --- 22-SEP-2003 mdamle Bug#3154208 - > 1 dataset pointing to same measure
26: --- 25-SEP-2003 mdamle Bug#3160325 - Sync up measures for all installed languages
27: --- 29-SEP-2003 adrao Bug#3160325 - Sync up measures with source_lang
28: --- 29-SEP-2003 mdamle Bug#3168129 - Change l_pmf_disp_name to bsc_sys_datasets_tl.name%type
29: --- 03-OCT-2003 mdamle Bug#3172902 - Measure ID not being set before synch
30: -- 07-OCT-2003 mdamle Bug#3170184 - For BSC type measure, always use short name in PMF display name
31: -- 04-DEC-2003 kyadamak bug#3284202 - while sync'ing from BSC->PMF generate new short_name
32: -- 22-DEC-2003 meastmon: bug#3333957 - Pass application id 271(Balanced scorecard application Id)

Line 114: l_dataset_name bsc_sys_datasets_tl.name%TYPE;

110: p_dataset_name IN VARCHAR2
111: )
112: RETURN VARCHAR2
113: IS
114: l_dataset_name bsc_sys_datasets_tl.name%TYPE;
115: l_return_name bsc_sys_datasets_tl.name%TYPE;
116: l_flag VARCHAR2(10);
117: BEGIN
118: l_flag := 'F';

Line 115: l_return_name bsc_sys_datasets_tl.name%TYPE;

111: )
112: RETURN VARCHAR2
113: IS
114: l_dataset_name bsc_sys_datasets_tl.name%TYPE;
115: l_return_name bsc_sys_datasets_tl.name%TYPE;
116: l_flag VARCHAR2(10);
117: BEGIN
118: l_flag := 'F';
119: l_dataset_name := p_dataset_name;

Line 935: l_name bsc_sys_datasets_tl.name%type;

931: where L.INSTALLED_FLAG in ('I', 'B')
932: and language_code <> userenv('LANG');
933:
934:
935: l_name bsc_sys_datasets_tl.name%type;
936: l_help bsc_sys_datasets_tl.help%type;
937: l_source_lang bsc_sys_datasets_tl.source_lang%type;
938: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
939: l_count number;

Line 936: l_help bsc_sys_datasets_tl.help%type;

932: and language_code <> userenv('LANG');
933:
934:
935: l_name bsc_sys_datasets_tl.name%type;
936: l_help bsc_sys_datasets_tl.help%type;
937: l_source_lang bsc_sys_datasets_tl.source_lang%type;
938: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
939: l_count number;
940:

Line 937: l_source_lang bsc_sys_datasets_tl.source_lang%type;

933:
934:
935: l_name bsc_sys_datasets_tl.name%type;
936: l_help bsc_sys_datasets_tl.help%type;
937: l_source_lang bsc_sys_datasets_tl.source_lang%type;
938: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
939: l_count number;
940:
941: BEGIN

Line 946: from bsc_sys_datasets_tl

942:
943: l_measure_rec := p_measure_rec;
944: for cr in installed_languages_cursor loop
945: select name, help, source_lang into l_name, l_help, l_source_lang
946: from bsc_sys_datasets_tl
947: where dataset_id = p_dataset_id
948: and language = cr.language_code;
949:
950: l_measure_rec.measure_name := l_name;

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 1217: l_pmf_disp_name bsc_sys_datasets_tl.name%type;

1213: function getUniqueDisplayName(
1214: p_dataset_name IN VARCHAR2
1215: , p_language IN VARCHAR2) return varchar2
1216: IS
1217: l_pmf_disp_name bsc_sys_datasets_tl.name%type;
1218: l_count number;
1219: begin
1220: l_pmf_disp_name := trim(p_dataset_name);
1221: