APPS.FND_DEBUG_OPTIONS_PKG dependencies on FND_DEBUG_OPTIONS_TL

Line 147: insert into FND_DEBUG_OPTIONS_TL (

143: X_LAST_UPDATED_BY,
144: X_LAST_UPDATE_LOGIN
145: );
146:
147: insert into FND_DEBUG_OPTIONS_TL (
148: DEBUG_OPTION_NAME,
149: DESCRIPTION,
150: CREATION_DATE,
151: CREATED_BY,

Line 171: from FND_DEBUG_OPTIONS_TL T

167: from FND_LANGUAGES L
168: where L.INSTALLED_FLAG in ('I', 'B')
169: and not exists
170: (select NULL
171: from FND_DEBUG_OPTIONS_TL T
172: where T.DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
173: and T.LANGUAGE = L.LANGUAGE_CODE);
174:
175: open c;

Line 211: update FND_DEBUG_OPTIONS_TL set

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: update FND_DEBUG_OPTIONS_TL set
212: DESCRIPTION = X_DESCRIPTION,
213: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 229: delete from FND_DEBUG_OPTIONS_TL T

225:
226: procedure ADD_LANGUAGE
227: is
228: begin
229: delete from FND_DEBUG_OPTIONS_TL T
230: where not exists
231: (select NULL
232: from FND_DEBUG_OPTIONS B
233: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME

Line 236: update FND_DEBUG_OPTIONS_TL T set (

232: from FND_DEBUG_OPTIONS B
233: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
234: );
235:
236: update FND_DEBUG_OPTIONS_TL T set (
237: DESCRIPTION
238: ) = (select
239: B.DESCRIPTION
240: from FND_DEBUG_OPTIONS_TL B

Line 240: from FND_DEBUG_OPTIONS_TL B

236: update FND_DEBUG_OPTIONS_TL T set (
237: DESCRIPTION
238: ) = (select
239: B.DESCRIPTION
240: from FND_DEBUG_OPTIONS_TL B
241: where B.DEBUG_OPTION_NAME = T.DEBUG_OPTION_NAME
242: and B.LANGUAGE = T.SOURCE_LANG)
243: where (
244: T.DEBUG_OPTION_NAME,

Line 249: from FND_DEBUG_OPTIONS_TL SUBB, FND_DEBUG_OPTIONS_TL SUBT

245: T.LANGUAGE
246: ) in (select
247: SUBT.DEBUG_OPTION_NAME,
248: SUBT.LANGUAGE
249: from FND_DEBUG_OPTIONS_TL SUBB, FND_DEBUG_OPTIONS_TL SUBT
250: where SUBB.DEBUG_OPTION_NAME = SUBT.DEBUG_OPTION_NAME
251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
253: ));

Line 255: insert into FND_DEBUG_OPTIONS_TL (

251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
253: ));
254:
255: insert into FND_DEBUG_OPTIONS_TL (
256: DEBUG_OPTION_NAME,
257: DESCRIPTION,
258: CREATION_DATE,
259: CREATED_BY,

Line 275: from FND_DEBUG_OPTIONS_TL B, FND_LANGUAGES L

271: B.LAST_UPDATED_BY,
272: B.LAST_UPDATE_LOGIN,
273: L.LANGUAGE_CODE,
274: B.SOURCE_LANG
275: from FND_DEBUG_OPTIONS_TL B, FND_LANGUAGES L
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL

Line 280: from FND_DEBUG_OPTIONS_TL T

276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
280: from FND_DEBUG_OPTIONS_TL T
281: where T.DEBUG_OPTION_NAME = B.DEBUG_OPTION_NAME
282: and T.LANGUAGE = L.LANGUAGE_CODE);
283: end ADD_LANGUAGE;
284:

Line 290: delete from FND_DEBUG_OPTIONS_TL

286: procedure DELETE_ROW (
287: X_DEBUG_OPTION_NAME in VARCHAR2
288: ) is
289: begin
290: delete from FND_DEBUG_OPTIONS_TL
291: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME;
292:
293: if (sql%notfound) then
294: raise no_data_found;

Line 327: from FND_DEBUG_OPTIONS_TL

323:
324: cursor c1 is select
325: DESCRIPTION,
326: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
327: from FND_DEBUG_OPTIONS_TL
328: where DEBUG_OPTION_NAME = X_DEBUG_OPTION_NAME
329: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
330: for update of DEBUG_OPTION_NAME nowait;
331: begin

Line 416: update fnd_debug_options_tl set

412:
413: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
414: db_ludate, X_CUSTOM_MODE)) then
415:
416: update fnd_debug_options_tl set
417: DESCRIPTION=nvl(X_DESCRIPTION,DESCRIPTION),
418: SOURCE_LANG=userenv('LANG'),
419: last_update_date = f_ludate,
420: last_updated_by = f_luby,