84: temp date;
85: Begin
86: l_sql := '
87: SELECT LAST_UPDATE_DATE
88: FROM BSC_SYS_DATASETS_B
89: WHERE DATASET_ID =:1';
90:
91:
92: open l_cursor for l_sql USING p_dim_set_id;
169: Bug#4045278: Overloaded for setting Time Stamp for Dataset to take in last_update_date parameter
170: -------------------------------------------------------------------------------------------*/
171: Procedure SET_TIME_STAMP_DATASET (
172: p_dim_set_id IN number
173: ,p_lud IN BSC_SYS_DATASETS_B.LAST_UPDATE_DATE%TYPE
174: ,x_return_status OUT NOCOPY varchar2
175: ,x_msg_count OUT NOCOPY number
176: ,x_msg_data OUT NOCOPY varchar2
177: ) is
179: begin
180: SAVEPOINT BSCSetTimeDataSetPVT;
181:
182: l_sql := '
183: UPDATE BSC_SYS_DATASETS_B
184: SET LAST_UPDATE_DATE = :1
185: WHERE DATASET_ID =:2';
186: execute immediate l_sql USING p_lud, p_dim_set_id;
187:
316:
317: SAVEPOINT BSCLockDataSetPVT;
318:
319: l_sql := 'SELECT DATASET_ID, LAST_UPDATE_DATE
320: FROM BSC_SYS_DATASETS_B
321: WHERE DATASET_ID =:1
322: FOR UPDATE NOWAIT';
323:
324: open l_cursor for l_sql USING p_dataset_id;