APPS.BSC_SYS_BENCHMARKS_PKG dependencies on BSC_SYS_BENCHMARKS_B

Line 50: INSERT INTO bsc_sys_benchmarks_b (

46: , p_Last_update_login IN NUMBER
47: ) IS
48: BEGIN
49:
50: INSERT INTO bsc_sys_benchmarks_b (
51: bm_id
52: , color
53: , data_type
54: , source_type

Line 128: from BSC_SYS_BENCHMARKS_B

124: DATA_TYPE,
125: SOURCE_TYPE,
126: PERIODICITY_ID,
127: NO_DISPLAY_FLAG
128: from BSC_SYS_BENCHMARKS_B
129: where BM_ID = X_BM_ID
130: for update of BM_ID nowait;
131: recinfo c%rowtype;
132:

Line 190: l_prev_last_updated_by BSC_SYS_BENCHMARKS_B.last_updated_by%TYPE;

186: , p_Last_update_date IN DATE
187: , p_Last_update_login IN NUMBER
188: , p_Custom_mode IN VARCHAR2
189: ) IS
190: l_prev_last_updated_by BSC_SYS_BENCHMARKS_B.last_updated_by%TYPE;
191: l_prev_last_update_date BSC_SYS_BENCHMARKS_B.last_update_date%TYPE;
192: BEGIN
193:
194: SELECT NVL(last_updated_by,FND_GLOBAL.USER_ID)

Line 191: l_prev_last_update_date BSC_SYS_BENCHMARKS_B.last_update_date%TYPE;

187: , p_Last_update_login IN NUMBER
188: , p_Custom_mode IN VARCHAR2
189: ) IS
190: l_prev_last_updated_by BSC_SYS_BENCHMARKS_B.last_updated_by%TYPE;
191: l_prev_last_update_date BSC_SYS_BENCHMARKS_B.last_update_date%TYPE;
192: BEGIN
193:
194: SELECT NVL(last_updated_by,FND_GLOBAL.USER_ID)
195: , NVL(last_update_date,SYSDATE)

Line 197: FROM bsc_sys_benchmarks_b

193:
194: SELECT NVL(last_updated_by,FND_GLOBAL.USER_ID)
195: , NVL(last_update_date,SYSDATE)
196: INTO l_prev_last_updated_by,l_prev_last_update_date
197: FROM bsc_sys_benchmarks_b
198: WHERE bm_id = p_Bm_id;
199:
200: IF(SQL%NOTFOUND)THEN
201: RAISE NO_DATA_FOUND;

Line 211: UPDATE bsc_sys_benchmarks_b

207: , l_prev_last_update_date
208: , p_Custom_mode)) THEN
209:
210:
211: UPDATE bsc_sys_benchmarks_b
212: SET color = p_Color
213: , data_type = p_Data_type
214: , source_type = p_Source_type
215: , periodicity_id = p_Periodicity_id

Line 250: delete from BSC_SYS_BENCHMARKS_B

246: if (sql%notfound) then
247: raise no_data_found;
248: end if;
249:
250: delete from BSC_SYS_BENCHMARKS_B
251: where BM_ID = X_BM_ID;
252:
253: if (sql%notfound) then
254: raise no_data_found;

Line 264: from BSC_SYS_BENCHMARKS_B B

260: begin
261: delete from BSC_SYS_BENCHMARKS_TL T
262: where not exists
263: (select NULL
264: from BSC_SYS_BENCHMARKS_B B
265: where B.BM_ID = T.BM_ID
266: );
267:
268: update BSC_SYS_BENCHMARKS_TL T set (