APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_TAB_VIEW_KPI_TL

Line 97: -- Clear BSC_TAB_VIEW_LABELS_TL, BSC_TAB_VIEW_LABELS_B and BSC_TAB_VIEW_KPI_TL with given tab_id and tab_view_id

93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: x_msg_data := SQLERRM;
95: END compact_custom_view_labels;
96:
97: -- Clear BSC_TAB_VIEW_LABELS_TL, BSC_TAB_VIEW_LABELS_B and BSC_TAB_VIEW_KPI_TL with given tab_id and tab_view_id
98: PROCEDURE clear_custom_view_canvas(
99: p_tab_id IN NUMBER
100: ,p_tab_view_id IN NUMBER
101: ,x_return_status OUT NOCOPY VARCHAR2

Line 118: DELETE FROM BSC_TAB_VIEW_KPI_TL

114: DELETE FROM BSC_TAB_VIEW_LABELS_B
115: WHERE TAB_ID = p_tab_id
116: AND TAB_VIEW_ID = p_tab_view_id;
117:
118: DELETE FROM BSC_TAB_VIEW_KPI_TL
119: WHERE TAB_ID = p_tab_id
120: AND TAB_VIEW_ID = p_tab_view_id;
121:
122: EXCEPTION

Line 373: -- BSC_TAB_VIEW_KPI_TL (1 row for kpi)

369: x_msg_data := SQLERRM;
370: END add_or_update_kpi_label;
371:
372: -- insert to the following tables:
373: -- BSC_TAB_VIEW_KPI_TL (1 row for kpi)
374: -- BSC_TAB_VIEW_LABELS_B (1 row for kpi, 1 row for actual, 1 row for change)
375: -- BSC_TAB_VIEW_LABELS_TL (1 row for kpi, 1 row for actual, 1 row for change)
376: PROCEDURE add_or_update_kpi(
377: p_tab_id IN NUMBER

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

418: fnd_msg_pub.initialize;
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: -- Add specified entry for objectives to BSC_TAB_VIEW_LABELS_PKG
422: -- position and color info is stored in BSC_TAB_VIEW_KPI_TL entries
423: add_or_update_kpi_label(
424: p_tab_id => p_tab_id
425: ,p_tab_view_id => p_tab_view_id
426: ,p_object_id => p_object_id

Line 443: -- Add specified kpi to BSC_TAB_VIEW_KPI_TL

439: ,x_msg_count => x_msg_count
440: ,x_msg_data => x_msg_data
441: );
442:
443: -- Add specified kpi to BSC_TAB_VIEW_KPI_TL
444: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_kpi(
445: p_tab_id => p_tab_id
446: ,p_tab_view_id => p_tab_view_id
447: ,p_kpi_id => p_kpi_id