APPS.JTF_DSP_SECTION_GRP dependencies on JTF_DSP_SECTIONS_TL

Line 221: INSERT INTO jtf_dsp_sections_tl

217: END IF;
218: CLOSE c;
219:
220: -- insert tl
221: INSERT INTO jtf_dsp_sections_tl
222: (
223: last_update_login,
224: display_name,
225: description,

Line 260: FROM jtf_dsp_sections_tl T

256: FROM fnd_languages L
257: WHERE L.installed_flag IN ('I', 'B')
258: AND NOT EXISTS
259: (SELECT NULL
260: FROM jtf_dsp_sections_tl T
261: WHERE T.section_id = x_section_id
262: AND T.language = L.language_code);
263:
264: OPEN c;

Line 395: UPDATE jtf_dsp_sections_tl SET

391: IF (sql%NOTFOUND) THEN
392: RAISE NO_DATA_FOUND;
393: END IF;
394:
395: UPDATE jtf_dsp_sections_tl SET
396: object_version_number = object_version_number + 1,
397: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
398: display_name, p_display_name),
399: description = decode(p_description, FND_API.G_MISS_CHAR,

Line 437: DELETE FROM jtf_dsp_sections_tl

433: )
434: IS
435: BEGIN
436:
437: DELETE FROM jtf_dsp_sections_tl
438: WHERE section_id = p_section_id;
439:
440: IF (sql%NOTFOUND) THEN
441: RAISE NO_DATA_FOUND;

Line 655: FROM jtf_dsp_sections_tl

651: WHERE access_name = l_c_access_name;
652:
653: CURSOR c2(l_c_display_name IN VARCHAR2, l_c_tmp_sql_str IN VARCHAR2)
654: IS SELECT section_id
655: FROM jtf_dsp_sections_tl
656: WHERE display_name = l_c_display_name || l_c_tmp_sql_str;
657:
658:
659: BEGIN

Line 2246: delete from JTF_DSP_SECTIONS_TL T

2242: --
2243: procedure ADD_LANGUAGE
2244: is
2245: begin
2246: delete from JTF_DSP_SECTIONS_TL T
2247: where not exists
2248: (select NULL
2249: from JTF_DSP_SECTIONS_B B
2250: where B.SECTION_ID = T.SECTION_ID

Line 2253: update JTF_DSP_SECTIONS_TL T set (

2249: from JTF_DSP_SECTIONS_B B
2250: where B.SECTION_ID = T.SECTION_ID
2251: );
2252:
2253: update JTF_DSP_SECTIONS_TL T set (
2254: DISPLAY_NAME,
2255: DESCRIPTION,
2256: LONG_DESCRIPTION,
2257: KEYWORDS

Line 2263: from JTF_DSP_SECTIONS_TL B

2259: B.DISPLAY_NAME,
2260: B.DESCRIPTION,
2261: B.LONG_DESCRIPTION,
2262: B.KEYWORDS
2263: from JTF_DSP_SECTIONS_TL B
2264: where B.SECTION_ID = T.SECTION_ID
2265: and B.LANGUAGE = T.SOURCE_LANG)
2266: where (
2267: T.SECTION_ID,

Line 2272: from JTF_DSP_SECTIONS_TL SUBB, JTF_DSP_SECTIONS_TL SUBT

2268: T.LANGUAGE
2269: ) in (select
2270: SUBT.SECTION_ID,
2271: SUBT.LANGUAGE
2272: from JTF_DSP_SECTIONS_TL SUBB, JTF_DSP_SECTIONS_TL SUBT
2273: where SUBB.SECTION_ID = SUBT.SECTION_ID
2274: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2275: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
2276: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 2287: insert into JTF_DSP_SECTIONS_TL (

2283: or (SUBB.KEYWORDS is null and SUBT.KEYWORDS is not null)
2284: or (SUBB.KEYWORDS is not null and SUBT.KEYWORDS is null)
2285: ));
2286:
2287: insert into JTF_DSP_SECTIONS_TL (
2288: SECTION_ID,
2289: OBJECT_VERSION_NUMBER,
2290: CREATED_BY,
2291: CREATION_DATE,

Line 2315: from JTF_DSP_SECTIONS_TL B, FND_LANGUAGES L

2311: B.LONG_DESCRIPTION,
2312: B.KEYWORDS,
2313: L.LANGUAGE_CODE,
2314: B.SOURCE_LANG
2315: from JTF_DSP_SECTIONS_TL B, FND_LANGUAGES L
2316: where L.INSTALLED_FLAG in ('I', 'B')
2317: and B.LANGUAGE = userenv('LANG')
2318: and not exists
2319: (select NULL

Line 2320: from JTF_DSP_SECTIONS_TL T

2316: where L.INSTALLED_FLAG in ('I', 'B')
2317: and B.LANGUAGE = userenv('LANG')
2318: and not exists
2319: (select NULL
2320: from JTF_DSP_SECTIONS_TL T
2321: where T.SECTION_ID = B.SECTION_ID
2322: and T.LANGUAGE = L.LANGUAGE_CODE);
2323: end ADD_LANGUAGE;
2324:

Line 2337: UPDATE jtf_dsp_sections_tl SET

2333: )
2334: IS
2335: BEGIN
2336:
2337: UPDATE jtf_dsp_sections_tl SET
2338: section_id = p_section_id,
2339: display_name = p_display_name,
2340: description = p_description,
2341: long_description = p_long_description,