APPS.BSC_BIS_LOCKS_PVT dependencies on BSC_SYS_MEASURES

Line 65: l_sql := 'SELECT MEASURE_COL FROM BSC_SYS_MEASURES WHERE MEASURE_ID =:1';

61: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
62: l_sql varchar2(300);
63: temp varchar2(1000);
64: Begin
65: l_sql := 'SELECT MEASURE_COL FROM BSC_SYS_MEASURES WHERE MEASURE_ID =:1';
66: open l_cursor for l_sql USING p_datasource_id;
67: fetch l_cursor into temp;
68: close l_cursor;
69: return temp;

Line 115: FROM BSC_SYS_MEASURES

111: temp date;
112: Begin
113: l_sql := '
114: SELECT LAST_UPDATE_DATE
115: FROM BSC_SYS_MEASURES
116: WHERE MEASURE_ID =:1';
117:
118: open l_cursor for l_sql USING p_measure_id;
119: fetch l_cursor into temp;

Line 251: ,p_lud IN BSC_SYS_MEASURES.LAST_UPDATE_DATE%TYPE

247: Bug#4045278: Overloaded for setting Time Stamp for Datasource to take in last_update_date parameter
248: -------------------------------------------------------------------------------------------*/
249: Procedure SET_TIME_STAMP_DATASOURCE (
250: p_measure_id IN number
251: ,p_lud IN BSC_SYS_MEASURES.LAST_UPDATE_DATE%TYPE
252: ,x_return_status OUT NOCOPY varchar2
253: ,x_msg_count OUT NOCOPY number
254: ,x_msg_data OUT NOCOPY varchar2
255: ) is

Line 262: UPDATE BSC_SYS_MEASURES

258:
259: SAVEPOINT BSCSetTimeDataSrcPVT;
260:
261: l_sql := '
262: UPDATE BSC_SYS_MEASURES
263: SET LAST_UPDATE_DATE = :1
264: WHERE MEASURE_ID =:2';
265: execute immediate l_sql USING p_lud, p_measure_id;
266:

Line 449: FROM BSC_SYS_MEASURES

445: SAVEPOINT BSCLockDataSrcPVT;
446:
447: l_sql := '
448: SELECT MEASURE_ID, LAST_UPDATE_DATE
449: FROM BSC_SYS_MEASURES
450: WHERE MEASURE_ID =:1
451: FOR UPDATE NOWAIT';
452:
453: open l_cursor for l_sql USING p_measure_id;