DBA Data[Home] [Help]

APPS.BSC_LOCKS_PVT dependencies on BSC_TAB_VIEWS_B

Line 50: SELECT 1 FROM BSC_TAB_VIEWS_B

46: CURSOR c_validate_data_column(c_measure_id NUMBER) IS
47: SELECT 1 FROM BSC_SYS_MEASURES
48: WHERE MEASURE_ID = c_measure_id;
49: CURSOR c_validate_custom_view(c_tab_id NUMBER, c_tab_view_id NUMBER) IS
50: SELECT 1 FROM BSC_TAB_VIEWS_B
51: WHERE TAB_ID = c_tab_id
52: AND TAB_VIEW_ID = c_tab_view_id;
53: CURSOR c_validate_launchpad(c_menu_id NUMBER) IS
54: SELECT 1 FROM FND_MENUS

Line 1512: FROM BSC_TAB_VIEWS_B

1508: WHERE TAB_ID = c_tab_id
1509: UNION
1510: SELECT TO_CHAR(c_tab_id)||','||TO_CHAR(TAB_VIEW_ID) OBJECT_KEY,
1511: 'CUSTOM_VIEW' OBJECT_TYPE
1512: FROM BSC_TAB_VIEWS_B
1513: WHERE TAB_ID = c_tab_id;
1514:
1515: CURSOR c_get_child_objective(c_indicator NUMBER) IS
1516: SELECT TO_CHAR(DIM_GROUP_ID) OBJECT_KEY,

Line 2968: FROM BSC_TAB_VIEWS_B;

2964: FND_GLOBAL.USER_ID,
2965: SYSDATE,
2966: FND_GLOBAL.USER_ID,
2967: l_session_id
2968: FROM BSC_TAB_VIEWS_B;
2969:
2970: INSERT INTO BSC_OBJECT_LOCK_USERS (
2971: OBJECT_KEY,
2972: OBJECT_TYPE,

Line 2995: FROM BSC_TAB_VIEWS_B;

2991: SYSDATE,
2992: FND_GLOBAL.USER_ID,
2993: SYSDATE,
2994: FND_GLOBAL.USER_ID
2995: FROM BSC_TAB_VIEWS_B;
2996:
2997: INSERT INTO BSC_OBJECT_LOCK_USERS (
2998: OBJECT_KEY,
2999: OBJECT_TYPE,

Line 3022: FROM BSC_TAB_VIEWS_B;

3018: SYSDATE,
3019: FND_GLOBAL.USER_ID,
3020: SYSDATE,
3021: FND_GLOBAL.USER_ID
3022: FROM BSC_TAB_VIEWS_B;
3023:
3024: EXCEPTION
3025: WHEN FND_API.G_EXC_ERROR THEN
3026: x_return_status := FND_API.G_RET_STS_ERROR;