APPS.BSC_LOCKS_PVT dependencies on BSC_SYS_DATASETS_B

Line 44: SELECT 1 FROM BSC_SYS_DATASETS_B

40: CURSOR c_validate_dimension_object(c_dim_level_id NUMBER) IS
41: SELECT 1 FROM BSC_SYS_DIM_LEVELS_B
42: WHERE DIM_LEVEL_ID = c_dim_level_id;
43: CURSOR c_validate_measure(c_dataset_id NUMBER) IS
44: SELECT 1 FROM BSC_SYS_DATASETS_B
45: WHERE DATASET_ID = c_dataset_id;
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;

Line 1535: FROM BSC_SYS_DATASETS_B

1531:
1532: CURSOR c_get_child_measure(c_dataset_id NUMBER) IS
1533: SELECT TO_CHAR(MEASURE_ID1) OBJECT_KEY,
1534: 'DATA_COLUMN' OBJECT_TYPE
1535: FROM BSC_SYS_DATASETS_B
1536: WHERE DATASET_ID = c_dataset_id
1537: UNION
1538: SELECT TO_CHAR(MEASURE_ID2) OBJECT_KEY,
1539: 'DATA_COLUMN' OBJECT_TYPE

Line 1540: FROM BSC_SYS_DATASETS_B

1536: WHERE DATASET_ID = c_dataset_id
1537: UNION
1538: SELECT TO_CHAR(MEASURE_ID2) OBJECT_KEY,
1539: 'DATA_COLUMN' OBJECT_TYPE
1540: FROM BSC_SYS_DATASETS_B
1541: WHERE DATASET_ID = c_dataset_id
1542: AND MEASURE_ID2 IS NOT NULL;
1543:
1544: CURSOR c_get_child_custom_view(c_tab_id NUMBER, c_tab_view_id NUMBER) IS

Line 2640: FROM BSC_SYS_DATASETS_B;

2636: FND_GLOBAL.USER_ID,
2637: SYSDATE,
2638: FND_GLOBAL.USER_ID,
2639: l_session_id
2640: FROM BSC_SYS_DATASETS_B;
2641:
2642: INSERT INTO BSC_OBJECT_LOCK_USERS (
2643: OBJECT_KEY,
2644: OBJECT_TYPE,

Line 2667: FROM BSC_SYS_DATASETS_B;

2663: SYSDATE,
2664: FND_GLOBAL.USER_ID,
2665: SYSDATE,
2666: FND_GLOBAL.USER_ID
2667: FROM BSC_SYS_DATASETS_B;
2668:
2669: INSERT INTO BSC_OBJECT_LOCK_USERS (
2670: OBJECT_KEY,
2671: OBJECT_TYPE,

Line 2694: FROM BSC_SYS_DATASETS_B;

2690: SYSDATE,
2691: FND_GLOBAL.USER_ID,
2692: SYSDATE,
2693: FND_GLOBAL.USER_ID
2694: FROM BSC_SYS_DATASETS_B;
2695:
2696: EXCEPTION
2697: WHEN FND_API.G_EXC_ERROR THEN
2698: x_return_status := FND_API.G_RET_STS_ERROR;