APPS.IBE_DSP_SECTION_GRP dependencies on IBE_DSP_SECTIONS_TL

Line 228: INSERT INTO ibe_dsp_sections_tl

224: END IF;
225: CLOSE c;
226:
227: -- insert tl
228: INSERT INTO ibe_dsp_sections_tl
229: (
230: last_update_login,
231: display_name,
232: description,

Line 267: FROM ibe_dsp_sections_tl T

263: FROM fnd_languages L
264: WHERE L.installed_flag IN ('I', 'B')
265: AND NOT EXISTS
266: (SELECT NULL
267: FROM ibe_dsp_sections_tl T
268: WHERE T.section_id = x_section_id
269: AND T.language = L.language_code);
270:
271: OPEN c;

Line 402: UPDATE ibe_dsp_sections_tl SET

398: IF (sql%NOTFOUND) THEN
399: RAISE NO_DATA_FOUND;
400: END IF;
401:
402: UPDATE ibe_dsp_sections_tl SET
403: object_version_number = object_version_number + 1,
404: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
405: display_name, p_display_name),
406: description = decode(p_description, FND_API.G_MISS_CHAR,

Line 444: DELETE FROM ibe_dsp_sections_tl

440: )
441: IS
442: BEGIN
443:
444: DELETE FROM ibe_dsp_sections_tl
445: WHERE section_id = p_section_id;
446:
447: IF (sql%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;

Line 677: -- FROM ibe_dsp_sections_tl

673: -- comment out (bug 2699543, since the code using the cursor is
674: -- already commented out)
675: --CURSOR c2(l_c_display_name IN VARCHAR2, l_c_tmp_sql_str IN VARCHAR2)
676: --IS SELECT section_id
677: -- FROM ibe_dsp_sections_tl
678: -- WHERE display_name = l_c_display_name || l_c_tmp_sql_str;
679:
680:
681: BEGIN

Line 2381: delete from IBE_DSP_SECTIONS_TL T

2377: --
2378: procedure ADD_LANGUAGE
2379: is
2380: begin
2381: delete from IBE_DSP_SECTIONS_TL T
2382: where not exists
2383: (select NULL
2384: from IBE_DSP_SECTIONS_B B
2385: where B.SECTION_ID = T.SECTION_ID

Line 2388: update IBE_DSP_SECTIONS_TL T set (

2384: from IBE_DSP_SECTIONS_B B
2385: where B.SECTION_ID = T.SECTION_ID
2386: );
2387:
2388: update IBE_DSP_SECTIONS_TL T set (
2389: DISPLAY_NAME,
2390: DESCRIPTION,
2391: LONG_DESCRIPTION,
2392: KEYWORDS

Line 2398: from IBE_DSP_SECTIONS_TL B

2394: B.DISPLAY_NAME,
2395: B.DESCRIPTION,
2396: B.LONG_DESCRIPTION,
2397: B.KEYWORDS
2398: from IBE_DSP_SECTIONS_TL B
2399: where B.SECTION_ID = T.SECTION_ID
2400: and B.LANGUAGE = T.SOURCE_LANG)
2401: where (
2402: T.SECTION_ID,

Line 2407: from IBE_DSP_SECTIONS_TL SUBB, IBE_DSP_SECTIONS_TL SUBT

2403: T.LANGUAGE
2404: ) in (select
2405: SUBT.SECTION_ID,
2406: SUBT.LANGUAGE
2407: from IBE_DSP_SECTIONS_TL SUBB, IBE_DSP_SECTIONS_TL SUBT
2408: where SUBB.SECTION_ID = SUBT.SECTION_ID
2409: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2410: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
2411: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 2422: insert into IBE_DSP_SECTIONS_TL (

2418: or (SUBB.KEYWORDS is null and SUBT.KEYWORDS is not null)
2419: or (SUBB.KEYWORDS is not null and SUBT.KEYWORDS is null)
2420: ));
2421:
2422: insert into IBE_DSP_SECTIONS_TL (
2423: SECTION_ID,
2424: OBJECT_VERSION_NUMBER,
2425: CREATED_BY,
2426: CREATION_DATE,

Line 2450: from IBE_DSP_SECTIONS_TL B, FND_LANGUAGES L

2446: B.LONG_DESCRIPTION,
2447: B.KEYWORDS,
2448: L.LANGUAGE_CODE,
2449: B.SOURCE_LANG
2450: from IBE_DSP_SECTIONS_TL B, FND_LANGUAGES L
2451: where L.INSTALLED_FLAG in ('I', 'B')
2452: and B.LANGUAGE = userenv('LANG')
2453: and not exists
2454: (select NULL

Line 2455: from IBE_DSP_SECTIONS_TL T

2451: where L.INSTALLED_FLAG in ('I', 'B')
2452: and B.LANGUAGE = userenv('LANG')
2453: and not exists
2454: (select NULL
2455: from IBE_DSP_SECTIONS_TL T
2456: where T.SECTION_ID = B.SECTION_ID
2457: and T.LANGUAGE = L.LANGUAGE_CODE);
2458: end ADD_LANGUAGE;
2459:

Line 2482: from ibe_dsp_sections_tl

2478: f_luby := fnd_load_util.owner_id(x_owner);
2479: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
2480: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2481: into db_luby, db_ludate
2482: from ibe_dsp_sections_tl
2483: where SECTION_ID = p_section_id
2484: and language=userenv('LANG'); -- bug #5089259
2485:
2486: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, P_CUSTOM_MODE)) then

Line 2487: UPDATE ibe_dsp_sections_tl SET

2483: where SECTION_ID = p_section_id
2484: and language=userenv('LANG'); -- bug #5089259
2485:
2486: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, P_CUSTOM_MODE)) then
2487: UPDATE ibe_dsp_sections_tl SET
2488: section_id = p_section_id,
2489: display_name = p_display_name,
2490: description = p_description,
2491: long_description = p_long_description,