DBA Data[Home] [Help]

APPS.BSC_LOCKS_PVT dependencies on BSC_KPIS_B

Line 35: SELECT 1 FROM BSC_KPIS_B

31: CURSOR c_validate_scorecard(c_tab_id NUMBER) IS
32: SELECT 1 FROM BSC_TABS_B
33: WHERE TAB_ID = c_tab_id;
34: CURSOR c_validate_objective(c_indicator NUMBER) IS
35: SELECT 1 FROM BSC_KPIS_B
36: WHERE INDICATOR = c_indicator;
37: CURSOR c_validate_dimension(c_dim_group_id NUMBER) IS
38: SELECT 1 FROM BSC_SYS_DIM_GROUPS_TL
39: WHERE DIM_GROUP_ID = c_dim_group_id;

Line 2148: FROM BSC_KPIS_B;

2144: FND_GLOBAL.USER_ID,
2145: SYSDATE,
2146: FND_GLOBAL.USER_ID,
2147: l_session_id
2148: FROM BSC_KPIS_B;
2149:
2150: INSERT INTO BSC_OBJECT_LOCK_USERS (
2151: OBJECT_KEY,
2152: OBJECT_TYPE,

Line 2175: FROM BSC_KPIS_B;

2171: SYSDATE,
2172: FND_GLOBAL.USER_ID,
2173: SYSDATE,
2174: FND_GLOBAL.USER_ID
2175: FROM BSC_KPIS_B;
2176:
2177: INSERT INTO BSC_OBJECT_LOCK_USERS (
2178: OBJECT_KEY,
2179: OBJECT_TYPE,

Line 2202: FROM BSC_KPIS_B;

2198: SYSDATE,
2199: FND_GLOBAL.USER_ID,
2200: SYSDATE,
2201: FND_GLOBAL.USER_ID
2202: FROM BSC_KPIS_B;
2203:
2204: EXCEPTION
2205: WHEN FND_API.G_EXC_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_ERROR;