APPS.BSC_MIGRATION dependencies on BSC_SYS_DATASETS_TL

Line 599: -- BSC_SYS_DATASETS_TL

595: ' )'||
596: ' )';
597: BSC_APPS.Execute_Immediate(h_sql);
598:
599: -- BSC_SYS_DATASETS_TL
600: h_sql := 'DELETE FROM bsc_sys_datasets_tl'||
601: ' WHERE dataset_id IN ('||
602: ' SELECT dataset_id'||
603: ' FROM bsc_sys_datasets_b'||

Line 600: h_sql := 'DELETE FROM bsc_sys_datasets_tl'||

596: ' )';
597: BSC_APPS.Execute_Immediate(h_sql);
598:
599: -- BSC_SYS_DATASETS_TL
600: h_sql := 'DELETE FROM bsc_sys_datasets_tl'||
601: ' WHERE dataset_id IN ('||
602: ' SELECT dataset_id'||
603: ' FROM bsc_sys_datasets_b'||
604: ' WHERE measure_id1 IN ('||

Line 3433: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DATASETS_TL';

3429: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3430: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3431:
3432: g_num_metadata_tables := g_num_metadata_tables + 1;
3433: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DATASETS_TL';
3434: g_metadata_tables(g_num_metadata_tables).level := 0;
3435: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3436: g_metadata_tables(g_num_metadata_tables).level_condition := 'DATASET_ID IN ('||
3437: ' SELECT DATASET_ID'||

Line 9051: bsc_sys_datasets_tl d

9047: SET
9048: attribute_label_long = (SELECT
9049: d.name
9050: FROM
9051: bsc_sys_datasets_tl d
9052: WHERE
9053: d.dataset_id = p_New_DataSet_Map(i) AND
9054: d.language = ak_item.language)
9055: WHERE

Line 9076: bsc_sys_datasets_tl d

9072: node_id = p_New_DataSet_Map(i),
9073: name = (SELECT
9074: d.name
9075: FROM
9076: bsc_sys_datasets_tl d
9077: WHERE
9078: d.dataset_id = p_New_DataSet_Map(i) AND
9079: (d.language = tr.language OR
9080: d.language = tr.language)),

Line 9084: bsc_sys_datasets_tl d

9080: d.language = tr.language)),
9081: help = (SELECT
9082: d.help
9083: FROM
9084: bsc_sys_datasets_tl d
9085: WHERE
9086: d.dataset_id = p_New_DataSet_Map(i) AND
9087: (d.language = tr.language OR
9088: d.language = tr.language))