DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on BSC_TAB_VIEW_LABELS_B

Line 3862: -- bug 5990196 for tables bsc_tab_view_labels_b and bsc_tab_view_labels_tl

3858: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3859: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3860: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3861:
3862: -- bug 5990196 for tables bsc_tab_view_labels_b and bsc_tab_view_labels_tl
3863: -- added condition for objective based migration of data, as the tab_id is -99
3864: -- for simulation objectives
3865:
3866: g_num_metadata_tables := g_num_metadata_tables + 1;

Line 3867: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_VIEW_LABELS_B';

3863: -- added condition for objective based migration of data, as the tab_id is -99
3864: -- for simulation objectives
3865:
3866: g_num_metadata_tables := g_num_metadata_tables + 1;
3867: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_VIEW_LABELS_B';
3868: g_metadata_tables(g_num_metadata_tables).level := 1;
3869: g_metadata_tables(g_num_metadata_tables).level_column := 'TAB_ID';
3870: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3871: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3875: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_VIEW_LABELS_B';

3871: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3872: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3873:
3874: g_num_metadata_tables := g_num_metadata_tables + 1;
3875: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TAB_VIEW_LABELS_B';
3876: g_metadata_tables(g_num_metadata_tables).level := 2;
3877: g_metadata_tables(g_num_metadata_tables).level_column := 'TAB_VIEW_ID';
3878: g_metadata_tables(g_num_metadata_tables).level_condition := 'TAB_ID = -999';
3879: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 4815: h_sql := 'UPDATE bsc_tab_view_labels_b

4811: END IF;
4812: ELSE
4813: -- Source or Target system is personal
4814: -- Update link_id to -1
4815: h_sql := 'UPDATE bsc_tab_view_labels_b
4816: SET link_id = -1
4817: WHERE label_type = 2';
4818: BSC_APPS.Execute_Immediate(h_sql);
4819: END IF;

Line 9094: bsc_tab_view_labels_b

9090: indicator = p_Trg_indicator AND
9091: node_id = p_Old_DataSet_Map(i);
9092:
9093: UPDATE
9094: bsc_tab_view_labels_b
9095: SET
9096: link_id = p_New_DataSet_Map(i)
9097: WHERE
9098: tab_view_id = p_Trg_indicator AND

Line 9593: --BSC_TAB_VIEW_LABELS_B/TL

9589: BEGIN
9590: --new tables for simulatio tree objective are
9591: --BSC_SYS_IMAGES
9592: --BSC_SYS_IMAGES_MAP_TL
9593: --BSC_TAB_VIEW_LABELS_B/TL
9594: --BSC_KPI_TREE_NODES_B/TL
9595:
9596: --For existing migration we don't need to handle any thing
9597: