APPS.BSC_LOCKS_PVT dependencies on BSC_SYS_MEASURES

Line 47: SELECT 1 FROM BSC_SYS_MEASURES

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

Line 1558: FROM BSC_SYS_MEASURES

1554: AND LINK_ID IS NOT NULL;
1555:
1556: CURSOR c_get_measure_col(c_measure_id NUMBER) IS
1557: SELECT MEASURE_COL, SOURCE
1558: FROM BSC_SYS_MEASURES
1559: WHERE MEASURE_ID = c_measure_id;
1560:
1561: CURSOR c_get_measure_id(c_measure_col VARCHAR2, c_source VARCHAR2) IS
1562: SELECT TO_CHAR(MEASURE_ID) OBJECT_KEY,

Line 1564: FROM BSC_SYS_MEASURES

1560:
1561: CURSOR c_get_measure_id(c_measure_col VARCHAR2, c_source VARCHAR2) IS
1562: SELECT TO_CHAR(MEASURE_ID) OBJECT_KEY,
1563: 'DATA_COLUMN' OBJECT_TYPE
1564: FROM BSC_SYS_MEASURES
1565: WHERE MEASURE_COL = c_measure_col
1566: AND SOURCE = c_source;
1567:
1568: BEGIN

Line 2804: FROM BSC_SYS_MEASURES;

2800: FND_GLOBAL.USER_ID,
2801: SYSDATE,
2802: FND_GLOBAL.USER_ID,
2803: l_session_id
2804: FROM BSC_SYS_MEASURES;
2805:
2806: INSERT INTO BSC_OBJECT_LOCK_USERS (
2807: OBJECT_KEY,
2808: OBJECT_TYPE,

Line 2831: FROM BSC_SYS_MEASURES;

2827: SYSDATE,
2828: FND_GLOBAL.USER_ID,
2829: SYSDATE,
2830: FND_GLOBAL.USER_ID
2831: FROM BSC_SYS_MEASURES;
2832:
2833: INSERT INTO BSC_OBJECT_LOCK_USERS (
2834: OBJECT_KEY,
2835: OBJECT_TYPE,

Line 2858: FROM BSC_SYS_MEASURES;

2854: SYSDATE,
2855: FND_GLOBAL.USER_ID,
2856: SYSDATE,
2857: FND_GLOBAL.USER_ID
2858: FROM BSC_SYS_MEASURES;
2859:
2860: EXCEPTION
2861: WHEN FND_API.G_EXC_ERROR THEN
2862: x_return_status := FND_API.G_RET_STS_ERROR;