APPS.BSC_SYS_BENCHMARKS_PKG dependencies on BSC_SYS_BENCHMARKS_TL

Line 76: INSERT INTO bsc_sys_benchmarks_tl (

72: , p_Last_update_date
73: , NVL(p_Last_update_login,FND_GLOBAL.login_id)
74: );
75:
76: INSERT INTO bsc_sys_benchmarks_tl (
77: bm_id
78: , name
79: , language
80: , source_lang

Line 90: FROM bsc_sys_benchmarks_tl t

86: FROM fnd_languages l
87: WHERE l.installed_flag IN ('I', 'B')
88: AND NOT EXISTS
89: ( SELECT NULL
90: FROM bsc_sys_benchmarks_tl t
91: WHERE t.bm_id = p_Bm_id
92: AND t.language = l.language_code
93: );
94:

Line 105: UPDATE bsc_sys_benchmarks_tl

101: p_Bm_id IN NUMBER
102: , p_Name IN VARCHAR2
103: )IS
104: BEGIN
105: UPDATE bsc_sys_benchmarks_tl
106: SET name = NVL(p_Name,name)
107: , source_lang = USERENV('LANG')
108: WHERE USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
109: AND bm_id = p_Bm_id;

Line 136: from BSC_SYS_BENCHMARKS_TL

132:
133: cursor c1 is select
134: NAME,
135: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
136: from BSC_SYS_BENCHMARKS_TL
137: where BM_ID = X_BM_ID
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
139: for update of BM_ID nowait;
140: begin

Line 226: UPDATE bsc_sys_benchmarks_tl

222: IF (SQL%NOTFOUND) THEN
223: RAISE NO_DATA_FOUND;
224: END IF;
225:
226: UPDATE bsc_sys_benchmarks_tl
227: SET name = p_Name
228: , source_lang = USERENV('LANG')
229: WHERE bm_id = p_Bm_id
230: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 243: delete from BSC_SYS_BENCHMARKS_TL

239: PROCEDURE DELETE_ROW (
240: X_BM_ID in NUMBER
241: ) is
242: begin
243: delete from BSC_SYS_BENCHMARKS_TL
244: where BM_ID = X_BM_ID;
245:
246: if (sql%notfound) then
247: raise no_data_found;

Line 261: delete from BSC_SYS_BENCHMARKS_TL T

257:
258: procedure ADD_LANGUAGE
259: is
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

Line 268: update BSC_SYS_BENCHMARKS_TL T set (

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 (
269: NAME
270: ) = (select
271: B.NAME
272: from BSC_SYS_BENCHMARKS_TL B

Line 272: from BSC_SYS_BENCHMARKS_TL B

268: update BSC_SYS_BENCHMARKS_TL T set (
269: NAME
270: ) = (select
271: B.NAME
272: from BSC_SYS_BENCHMARKS_TL B
273: where B.BM_ID = T.BM_ID
274: and B.LANGUAGE = T.SOURCE_LANG)
275: where (
276: T.BM_ID,

Line 281: from BSC_SYS_BENCHMARKS_TL SUBB, BSC_SYS_BENCHMARKS_TL SUBT

277: T.LANGUAGE
278: ) in (select
279: SUBT.BM_ID,
280: SUBT.LANGUAGE
281: from BSC_SYS_BENCHMARKS_TL SUBB, BSC_SYS_BENCHMARKS_TL SUBT
282: where SUBB.BM_ID = SUBT.BM_ID
283: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
284: and (SUBB.NAME <> SUBT.NAME
285: ));

Line 287: insert into BSC_SYS_BENCHMARKS_TL (

283: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
284: and (SUBB.NAME <> SUBT.NAME
285: ));
286:
287: insert into BSC_SYS_BENCHMARKS_TL (
288: BM_ID,
289: NAME,
290: LANGUAGE,
291: SOURCE_LANG

Line 297: from BSC_SYS_BENCHMARKS_TL B, FND_LANGUAGES L

293: B.BM_ID,
294: B.NAME,
295: L.LANGUAGE_CODE,
296: B.SOURCE_LANG
297: from BSC_SYS_BENCHMARKS_TL B, FND_LANGUAGES L
298: where L.INSTALLED_FLAG in ('I', 'B')
299: and B.LANGUAGE = userenv('LANG')
300: and not exists
301: (select NULL

Line 302: from BSC_SYS_BENCHMARKS_TL T

298: where L.INSTALLED_FLAG in ('I', 'B')
299: and B.LANGUAGE = userenv('LANG')
300: and not exists
301: (select NULL
302: from BSC_SYS_BENCHMARKS_TL T
303: where T.BM_ID = B.BM_ID
304: and T.LANGUAGE = L.LANGUAGE_CODE);
305: end ADD_LANGUAGE;
306: