APPS.FND_DEBUG_OPTION_VALUES_PKG dependencies on FND_DEBUG_OPTION_VALUES_TL

Line 162: insert into FND_DEBUG_OPTION_VALUES_TL (

158: X_LAST_UPDATED_BY,
159: X_LAST_UPDATE_LOGIN
160: );
161:
162: insert into FND_DEBUG_OPTION_VALUES_TL (
163: DEBUG_OPTION_NAME,
164: DEBUG_OPTION_VALUE,
165: DESCRIPTION,
166: CREATION_DATE,

Line 188: from FND_DEBUG_OPTION_VALUES_TL T

184: from FND_LANGUAGES L
185: where L.INSTALLED_FLAG in ('I', 'B')
186: and not exists
187: (select NULL
188: from FND_DEBUG_OPTION_VALUES_TL T
189: where T.DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
190: and T.DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE
191: and T.LANGUAGE = L.LANGUAGE_CODE);
192:

Line 228: from FND_DEBUG_OPTION_VALUES_TL

224:
225: cursor c1 is select
226: DESCRIPTION,
227: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
228: from FND_DEBUG_OPTION_VALUES_TL
229: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
230: and DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE
231: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
232: for update of DEBUG_OPTION_NAME nowait;

Line 303: update FND_DEBUG_OPTION_VALUES_TL set

299: if (sql%notfound) then
300: raise no_data_found;
301: end if;
302:
303: update FND_DEBUG_OPTION_VALUES_TL set
304: DESCRIPTION = X_DESCRIPTION,
305: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
306: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
307: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 323: delete from FND_DEBUG_OPTION_VALUES_TL

319: X_DEBUG_OPTION_NAME in VARCHAR2,
320: X_DEBUG_OPTION_VALUE in VARCHAR2
321: ) is
322: begin
323: delete from FND_DEBUG_OPTION_VALUES_TL
324: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
325: and DEBUG_OPTION_VALUE = X_DEBUG_OPTION_VALUE;
326:
327: if (sql%notfound) then

Line 343: delete from FND_DEBUG_OPTION_VALUES_TL T

339:
340: procedure ADD_LANGUAGE
341: is
342: begin
343: delete from FND_DEBUG_OPTION_VALUES_TL T
344: where not exists
345: (select NULL
346: from FND_DEBUG_OPTION_VALUES B
347: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME

Line 351: update FND_DEBUG_OPTION_VALUES_TL T set (

347: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
348: and B.DEBUG_OPTION_VALUE = T.DEBUG_OPTION_VALUE
349: );
350:
351: update FND_DEBUG_OPTION_VALUES_TL T set (
352: DESCRIPTION
353: ) = (select
354: B.DESCRIPTION
355: from FND_DEBUG_OPTION_VALUES_TL B

Line 355: from FND_DEBUG_OPTION_VALUES_TL B

351: update FND_DEBUG_OPTION_VALUES_TL T set (
352: DESCRIPTION
353: ) = (select
354: B.DESCRIPTION
355: from FND_DEBUG_OPTION_VALUES_TL B
356: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
357: and B.DEBUG_OPTION_VALUE = T.DEBUG_OPTION_VALUE
358: and B.LANGUAGE = T.SOURCE_LANG)
359: where (

Line 367: from FND_DEBUG_OPTION_VALUES_TL SUBB, FND_DEBUG_OPTION_VALUES_TL SUBT

363: ) in (select
364: SUBT.DEBUG_OPTION_NAME,
365: SUBT.DEBUG_OPTION_VALUE,
366: SUBT.LANGUAGE
367: from FND_DEBUG_OPTION_VALUES_TL SUBB, FND_DEBUG_OPTION_VALUES_TL SUBT
368: where SUBB.DEBUG_OPTION_NAME = SUBT.DEBUG_OPTION_NAME
369: and SUBB.DEBUG_OPTION_VALUE = SUBT.DEBUG_OPTION_VALUE
370: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
371: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 374: insert into FND_DEBUG_OPTION_VALUES_TL (

370: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
371: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
372: ));
373:
374: insert into FND_DEBUG_OPTION_VALUES_TL (
375: DEBUG_OPTION_NAME,
376: DEBUG_OPTION_VALUE,
377: DESCRIPTION,
378: CREATION_DATE,

Line 396: from FND_DEBUG_OPTION_VALUES_TL B, FND_LANGUAGES L

392: B.LAST_UPDATED_BY,
393: B.LAST_UPDATE_LOGIN,
394: L.LANGUAGE_CODE,
395: B.SOURCE_LANG
396: from FND_DEBUG_OPTION_VALUES_TL B, FND_LANGUAGES L
397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL

Line 401: from FND_DEBUG_OPTION_VALUES_TL T

397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL
401: from FND_DEBUG_OPTION_VALUES_TL T
402: where T.DEBUG_OPTION_NAME = B.DEBUG_OPTION_NAME
403: and T.DEBUG_OPTION_VALUE = B.DEBUG_OPTION_VALUE
404: and T.LANGUAGE = L.LANGUAGE_CODE);
405: end ADD_LANGUAGE;

Line 461: update fnd_debug_option_values_tl set

457:
458: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
459: db_ludate, X_CUSTOM_MODE)) then
460:
461: update fnd_debug_option_values_tl set
462: DESCRIPTION=nvl(X_DESCRIPTION,DESCRIPTION),
463: SOURCE_LANG=userenv('LANG'),
464: last_update_date = f_ludate,
465: last_updated_by = f_luby,