APPS.BSC_UPGRADES_GENERIC dependencies on BSC_TAB_VIEW_KPI_TL

Line 247: -- This function will loop through all entries in BSC_TAB_VIEW_KPI_TL and add an entry to BSC_TAB_VIEW_LABEL_B/TL

243: END Upgrade_Tab_View_Functions;
244:
245: /*******************************************************************************************************
246: -- Upgrade for BSC 5.2 RUP Custom View Region Supporting DBI Pge
247: -- This function will loop through all entries in BSC_TAB_VIEW_KPI_TL and add an entry to BSC_TAB_VIEW_LABEL_B/TL
248: *********************************************************************************************************/
249: FUNCTION Upgrade_Tab_View_Kpi_Labels
250: (
251: x_error_msg OUT NOCOPY VARCHAR2

Line 266: from bsc_tab_view_kpi_tl;

262:
263: CURSOR c_all_tab_view_kpis IS
264: select distinct tab_id, tab_view_id, indicator, text_flag, left_position,
265: top_position, width, height, font_size, font_style, font_color
266: from bsc_tab_view_kpi_tl;
267: BEGIN
268: l_property_code := 'TAB_VIEW_KPIS';
269:
270: -- check bsc_sys_init for flag

Line 294: -- position and color info is stored in BSC_TAB_VIEW_KPI_TL entries

290: from bsc_tab_view_labels_b
291: where tab_id = all_tab_view_kpis.tab_id and tab_view_id=all_tab_view_kpis.tab_view_id;
292:
293: -- Add specified entry for objectives to BSC_TAB_VIEW_LABELS_PKG
294: -- position and color info is stored in BSC_TAB_VIEW_KPI_TL entries
295: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_kpi_label(
296: p_tab_id => all_tab_view_kpis.tab_id
297: ,p_tab_view_id => all_tab_view_kpis.tab_view_id
298: ,p_object_id => l_label_id