APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_TABS_B

Line 209: ,p_tabId IN BSC_TABS_B.tab_id%TYPE

205:
206: FUNCTION Is_Assign_To_Tab
207: (
208: p_indicator IN BSC_KPIS_B.indicator%TYPE
209: ,p_tabId IN BSC_TABS_B.tab_id%TYPE
210: )RETURN VARCHAR2 IS
211:
212: l_count NUMBER;
213: l_attached VARCHAR2(2);

Line 1988: FROM bsc_tabs_b a

1984: l_tab_id NUMBER;
1985: BEGIN
1986: SELECT a.tab_id
1987: INTO l_tab_id
1988: FROM bsc_tabs_b a
1989: WHERE a.short_name = p_page_function_name;
1990:
1991: RETURN l_tab_id;
1992:

Line 9123: FROM BSC_TABS_B T,

9119: l_Count NUMBER;
9120: BEGIN
9121:
9122: SELECT COUNT(1) INTO l_Count
9123: FROM BSC_TABS_B T,
9124: BSC_TAB_INDICATORS K,
9125: BSC_KPI_ANALYSIS_OPTIONS_B A
9126: WHERE T.TAB_ID = p_Tab_id
9127: AND K.TAB_ID = T.TAB_ID

Line 9412: l_tab_id BSC_TABS_B.tab_id%TYPE;

9408: , x_Return_Status OUT NOCOPY VARCHAR2
9409: , x_Msg_Count OUT NOCOPY NUMBER
9410: , x_Msg_Data OUT NOCOPY VARCHAR2
9411: )IS
9412: l_tab_id BSC_TABS_B.tab_id%TYPE;
9413:
9414: CURSOR c_GetTabId IS
9415: SELECT tab_id
9416: FROM BSC_TABS_B

Line 9416: FROM BSC_TABS_B

9412: l_tab_id BSC_TABS_B.tab_id%TYPE;
9413:
9414: CURSOR c_GetTabId IS
9415: SELECT tab_id
9416: FROM BSC_TABS_B
9417: WHERE SHORT_NAME = p_region_code;
9418:
9419: BEGIN
9420: FND_MSG_PUB.INITIALIZE;

Line 9524: ,BSC_TABS_B A

9520: CURSOR c_meas_sht IS
9521: SELECT B.short_name
9522: FROM BIS_INDICATORS B
9523: ,BSC_TAB_VIEW_LABELS_B C
9524: ,BSC_TABS_B A
9525: WHERE A.tab_id = C.tab_id
9526: AND C.link_id = B.dataset_id
9527: AND A.short_name = p_region_code;
9528:

Line 9533: FROM BSC_TABS_B A

9529: CURSOR c_cust_views IS
9530: SELECT A.tab_id
9531: ,B.tab_view_id
9532: ,B.last_update_date
9533: FROM BSC_TABS_B A
9534: ,BSC_TAB_VIEWS_B B
9535: WHERE A.tab_id =B.tab_id
9536: AND A.short_name = p_region_code;
9537:

Line 9594: p_tab_sht_name IN BSC_TABS_B.short_name%TYPE

9590: Created by : ashankar 08-JUL-2005
9591: /****************************************************/
9592:
9593: FUNCTION is_Scorecard_From_Reports (
9594: p_tab_sht_name IN BSC_TABS_B.short_name%TYPE
9595: ) RETURN VARCHAR2 IS
9596:
9597: CURSOR c_form_function IS
9598: SELECT Web_html_call