APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_TAB_VIEW_LABELS_B

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 61: FROM BSC_TAB_VIEW_LABELS_B

57: l_count NUMBER;
58:
59: CURSOR LABEL_CUR IS
60: SELECT label_id
61: FROM BSC_TAB_VIEW_LABELS_B
62: WHERE tab_id = p_tab_id
63: AND tab_view_id = p_tab_view_id
64: ORDER BY label_id;
65: l_label_cur LABEL_CUR%ROWTYPE;

Line 75: UPDATE BSC_TAB_VIEW_LABELS_B

71:
72: l_count := 0;
73:
74: FOR l_label_cur IN LABEL_CUR LOOP
75: UPDATE BSC_TAB_VIEW_LABELS_B
76: SET label_id = l_count
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;

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 114: DELETE FROM BSC_TAB_VIEW_LABELS_B

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
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

Line 374: -- BSC_TAB_VIEW_LABELS_B (1 row for kpi, 1 row for actual, 1 row for change)

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

Line 905: l_object_id BSC_TAB_VIEW_LABELS_B.LABEL_ID%TYPE;

901: ,x_msg_data OUT NOCOPY VARCHAR2
902: ) IS
903: l_str VARCHAR2(100);
904: l_count NUMBER;
905: l_object_id BSC_TAB_VIEW_LABELS_B.LABEL_ID%TYPE;
906: BEGIN
907: SAVEPOINT RollBackPt;
908: fnd_msg_pub.initialize;
909: x_return_status := FND_API.G_RET_STS_SUCCESS;