APPS.JTS_CONFIGURATIONS_PKG dependencies on JTS_CONFIGURATIONS_TL

Line 26: DELETE FROM jts_configurations_tl

22: BEGIN
23: DELETE FROM jts_configurations_b
24: WHERE configuration_id = p_config_id;
25:
26: DELETE FROM jts_configurations_tl
27: WHERE configuration_id = p_config_id;
28:
29: EXCEPTION
30: WHEN OTHERS THEN

Line 127: insert into JTS_CONFIGURATIONS_TL (

123: X_LAST_UPDATED_BY,
124: X_LAST_UPDATE_LOGIN
125: );
126:
127: insert into JTS_CONFIGURATIONS_TL (
128: CONFIGURATION_ID,
129: DESCRIPTION,
130: CREATION_DATE,
131: CREATED_BY,

Line 153: from JTS_CONFIGURATIONS_TL T

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

Line 222: from JTS_CONFIGURATIONS_TL

218:
219: cursor c1 is select
220: DESCRIPTION,
221: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222: from JTS_CONFIGURATIONS_TL
223: where CONFIGURATION_ID = X_CONFIGURATION_ID
224: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
225: for update of CONFIGURATION_ID nowait;
226: begin

Line 355: update JTS_CONFIGURATIONS_TL set

351: if (sql%notfound) then
352: raise no_data_found;
353: end if;
354:
355: update JTS_CONFIGURATIONS_TL set
356: DESCRIPTION = X_DESCRIPTION,
357: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
358: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
359: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 372: delete from JTS_CONFIGURATIONS_TL T

368:
369: procedure ADD_LANGUAGE
370: is
371: begin
372: delete from JTS_CONFIGURATIONS_TL T
373: where not exists
374: (select NULL
375: from JTS_CONFIGURATIONS_B B
376: where B.CONFIGURATION_ID = T.CONFIGURATION_ID

Line 379: update JTS_CONFIGURATIONS_TL T set (

375: from JTS_CONFIGURATIONS_B B
376: where B.CONFIGURATION_ID = T.CONFIGURATION_ID
377: );
378:
379: update JTS_CONFIGURATIONS_TL T set (
380: DESCRIPTION
381: ) = (select
382: B.DESCRIPTION
383: from JTS_CONFIGURATIONS_TL B

Line 383: from JTS_CONFIGURATIONS_TL B

379: update JTS_CONFIGURATIONS_TL T set (
380: DESCRIPTION
381: ) = (select
382: B.DESCRIPTION
383: from JTS_CONFIGURATIONS_TL B
384: where B.CONFIGURATION_ID = T.CONFIGURATION_ID
385: and B.LANGUAGE = T.SOURCE_LANG)
386: where (
387: T.CONFIGURATION_ID,

Line 392: from JTS_CONFIGURATIONS_TL SUBB, JTS_CONFIGURATIONS_TL SUBT

388: T.LANGUAGE
389: ) in (select
390: SUBT.CONFIGURATION_ID,
391: SUBT.LANGUAGE
392: from JTS_CONFIGURATIONS_TL SUBB, JTS_CONFIGURATIONS_TL SUBT
393: where SUBB.CONFIGURATION_ID = SUBT.CONFIGURATION_ID
394: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
395: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
396: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 400: insert into JTS_CONFIGURATIONS_TL (

396: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
397: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
398: ));
399:
400: insert into JTS_CONFIGURATIONS_TL (
401: CONFIGURATION_ID,
402: DESCRIPTION,
403: CREATION_DATE,
404: CREATED_BY,

Line 422: from JTS_CONFIGURATIONS_TL B, FND_LANGUAGES L

418: B.LAST_UPDATE_LOGIN,
419: B.SECURITY_GROUP_ID,
420: L.LANGUAGE_CODE,
421: B.SOURCE_LANG
422: from JTS_CONFIGURATIONS_TL B, FND_LANGUAGES L
423: where L.INSTALLED_FLAG in ('I', 'B')
424: and B.LANGUAGE = userenv('LANG')
425: and not exists
426: (select NULL

Line 427: from JTS_CONFIGURATIONS_TL T

423: where L.INSTALLED_FLAG in ('I', 'B')
424: and B.LANGUAGE = userenv('LANG')
425: and not exists
426: (select NULL
427: from JTS_CONFIGURATIONS_TL T
428: where T.CONFIGURATION_ID = B.CONFIGURATION_ID
429: and T.LANGUAGE = L.LANGUAGE_CODE);
430: end ADD_LANGUAGE;
431:

Line 442: update jts_configurations_tl set

438: p_description IN VARCHAR2
439: )
440: IS
441: BEGIN
442: update jts_configurations_tl set
443: description = nvl(p_description, description),
444: source_lang = userenv('LANG'),
445: last_update_date = sysdate,
446: last_updated_by = decode(p_owner, 'SEED', 1, 0),