APPS.JTS_CONFIG_VERSIONS_PKG dependencies on JTS_CONFIG_VERSIONS_TL

Line 126: insert into JTS_CONFIG_VERSIONS_TL (

122: X_LAST_UPDATED_BY,
123: X_LAST_UPDATE_LOGIN
124: );
125:
126: insert into JTS_CONFIG_VERSIONS_TL (
127: VERSION_ID,
128: CONFIGURATION_ID,
129: DESCRIPTION,
130: CREATION_DATE,

Line 154: from JTS_CONFIG_VERSIONS_TL T

150: from FND_LANGUAGES L
151: where L.INSTALLED_FLAG in ('I', 'B')
152: and not exists
153: (select NULL
154: from JTS_CONFIG_VERSIONS_TL T
155: where T.VERSION_ID = X_VERSION_ID
156: and T.LANGUAGE = L.LANGUAGE_CODE);
157:
158: open c;

Line 233: from JTS_CONFIG_VERSIONS_TL

229:
230: cursor c1 is select
231: DESCRIPTION,
232: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
233: from JTS_CONFIG_VERSIONS_TL
234: where VERSION_ID = X_VERSION_ID
235: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
236: for update of VERSION_ID nowait;
237: begin

Line 386: update JTS_CONFIG_VERSIONS_TL set

382: if (sql%notfound) then
383: raise no_data_found;
384: end if;
385:
386: update JTS_CONFIG_VERSIONS_TL set
387: DESCRIPTION = X_DESCRIPTION,
388: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
389: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
390: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 408: DELETE FROM jts_config_versions_tl

404: BEGIN
405: DELETE FROM jts_config_versions_b
406: WHERE version_id = p_version_id;
407:
408: DELETE FROM jts_config_versions_tl
409: WHERE version_id = p_version_id;
410:
411: EXCEPTION
412: WHEN OTHERS THEN

Line 419: delete from JTS_CONFIG_VERSIONS_TL T

415:
416: procedure ADD_LANGUAGE
417: is
418: begin
419: delete from JTS_CONFIG_VERSIONS_TL T
420: where not exists
421: (select NULL
422: from JTS_CONFIG_VERSIONS_B B
423: where B.VERSION_ID = T.VERSION_ID

Line 426: update JTS_CONFIG_VERSIONS_TL T set (

422: from JTS_CONFIG_VERSIONS_B B
423: where B.VERSION_ID = T.VERSION_ID
424: );
425:
426: update JTS_CONFIG_VERSIONS_TL T set (
427: DESCRIPTION
428: ) = (select
429: B.DESCRIPTION
430: from JTS_CONFIG_VERSIONS_TL B

Line 430: from JTS_CONFIG_VERSIONS_TL B

426: update JTS_CONFIG_VERSIONS_TL T set (
427: DESCRIPTION
428: ) = (select
429: B.DESCRIPTION
430: from JTS_CONFIG_VERSIONS_TL B
431: where B.VERSION_ID = T.VERSION_ID
432: and B.LANGUAGE = T.SOURCE_LANG)
433: where (
434: T.VERSION_ID,

Line 439: from JTS_CONFIG_VERSIONS_TL SUBB, JTS_CONFIG_VERSIONS_TL SUBT

435: T.LANGUAGE
436: ) in (select
437: SUBT.VERSION_ID,
438: SUBT.LANGUAGE
439: from JTS_CONFIG_VERSIONS_TL SUBB, JTS_CONFIG_VERSIONS_TL SUBT
440: where SUBB.VERSION_ID = SUBT.VERSION_ID
441: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
442: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
443: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 447: insert into JTS_CONFIG_VERSIONS_TL (

443: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
444: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
445: ));
446:
447: insert into JTS_CONFIG_VERSIONS_TL (
448: VERSION_ID,
449: CONFIGURATION_ID,
450: DESCRIPTION,
451: CREATION_DATE,

Line 471: from JTS_CONFIG_VERSIONS_TL B, FND_LANGUAGES L

467: B.LAST_UPDATE_LOGIN,
468: B.SECURITY_GROUP_ID,
469: L.LANGUAGE_CODE,
470: B.SOURCE_LANG
471: from JTS_CONFIG_VERSIONS_TL B, FND_LANGUAGES L
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL

Line 476: from JTS_CONFIG_VERSIONS_TL T

472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
476: from JTS_CONFIG_VERSIONS_TL T
477: where T.VERSION_ID = B.VERSION_ID
478: and T.LANGUAGE = L.LANGUAGE_CODE);
479: end ADD_LANGUAGE;
480:

Line 491: update jts_config_versions_tl set

487: p_description IN VARCHAR2
488: )
489: IS
490: BEGIN
491: update jts_config_versions_tl set
492: description = nvl(p_description, description),
493: source_lang = userenv('LANG'),
494: last_update_date = sysdate,
495: last_updated_by = decode(p_owner, 'SEED', 1, 0),