DBA Data[Home] [Help]

APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_TAB_VIEW_LABELS_TL

Line 49: --Compact all label ids in BSC_TAB_VIEW_LABELS_TL and BSC_TAB_VIEW_LABELS_B to be in consecutive order

45: RETURN FALSE;
46: END IF;
47: END Is_More;
48:
49: --Compact all label ids in BSC_TAB_VIEW_LABELS_TL and BSC_TAB_VIEW_LABELS_B to be in consecutive order
50: PROCEDURE compact_custom_view_labels(
51: p_tab_id IN NUMBER
52: ,p_tab_view_id IN NUMBER
53: ,x_return_status OUT NOCOPY VARCHAR2

Line 81: UPDATE BSC_TAB_VIEW_LABELS_TL

77: WHERE tab_id = p_tab_id
78: AND tab_view_id = p_tab_view_id
79: AND label_id = l_label_cur.label_id;
80:
81: UPDATE BSC_TAB_VIEW_LABELS_TL
82: SET label_id = l_count
83: WHERE tab_id = p_tab_id
84: AND tab_view_id = p_tab_view_id
85: AND label_id = l_label_cur.label_id;

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 110: DELETE FROM BSC_TAB_VIEW_LABELS_TL

106: SAVEPOINT RollBackPt;
107: fnd_msg_pub.initialize;
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: DELETE FROM BSC_TAB_VIEW_LABELS_TL
111: WHERE TAB_ID = p_tab_id
112: AND TAB_VIEW_ID = p_tab_view_id;
113:
114: DELETE FROM BSC_TAB_VIEW_LABELS_B

Line 375: -- BSC_TAB_VIEW_LABELS_TL (1 row for kpi, 1 row for actual, 1 row for change)

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
378: ,p_tab_view_id IN NUMBER
379: ,p_object_id IN NUMBER