APPS.EDR_FILES_PKG dependencies on EDR_FILES_TL

Line 108: insert into EDR_FILES_TL (

104: X_LAST_UPDATED_BY,
105: X_LAST_UPDATE_LOGIN
106: );
107:
108: insert into EDR_FILES_TL (
109: LAST_UPDATE_DATE,
110: LAST_UPDATED_BY,
111: LAST_UPDATE_LOGIN,
112: DESCRIPTION,

Line 132: from EDR_FILES_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from EDR_FILES_TL T
133: where T.FILE_ID = X_FILE_ID
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136: open c;

Line 209: from EDR_FILES_TL

205: recinfo c%rowtype;
206: cursor c1 is select
207: DESCRIPTION,
208: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
209: from EDR_FILES_TL
210: where FILE_ID = X_FILE_ID
211: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
212: for update of FILE_ID nowait;
213: begin

Line 352: update EDR_FILES_TL set

348: where FILE_ID = X_FILE_ID;
349: if (sql%notfound) then
350: raise no_data_found;
351: end if;
352: update EDR_FILES_TL set
353: DESCRIPTION = X_DESCRIPTION,
354: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
355: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
356: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 369: delete from EDR_FILES_TL

365: procedure DELETE_ROW (
366: X_FILE_ID in NUMBER
367: ) is
368: begin
369: delete from EDR_FILES_TL
370: where FILE_ID = X_FILE_ID;
371: if (sql%notfound) then
372: raise no_data_found;
373: end if;

Line 384: delete from EDR_FILES_TL T

380:
381: procedure ADD_LANGUAGE
382: is
383: begin
384: delete from EDR_FILES_TL T
385: where not exists
386: (select NULL
387: from EDR_FILES_B B
388: where B.FILE_ID = T.FILE_ID

Line 390: update EDR_FILES_TL T set (

386: (select NULL
387: from EDR_FILES_B B
388: where B.FILE_ID = T.FILE_ID
389: );
390: update EDR_FILES_TL T set (
391: DESCRIPTION
392: ) = (select
393: B.DESCRIPTION
394: from EDR_FILES_TL B

Line 394: from EDR_FILES_TL B

390: update EDR_FILES_TL T set (
391: DESCRIPTION
392: ) = (select
393: B.DESCRIPTION
394: from EDR_FILES_TL B
395: where B.FILE_ID = T.FILE_ID
396: and B.LANGUAGE = T.SOURCE_LANG)
397: where (
398: T.FILE_ID,

Line 403: from EDR_FILES_TL SUBB, EDR_FILES_TL SUBT

399: T.LANGUAGE
400: ) in (select
401: SUBT.FILE_ID,
402: SUBT.LANGUAGE
403: from EDR_FILES_TL SUBB, EDR_FILES_TL SUBT
404: where SUBB.FILE_ID = SUBT.FILE_ID
405: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
406: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
407: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 410: insert into EDR_FILES_TL (

406: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
407: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
408: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
409: ));
410: insert into EDR_FILES_TL (
411: LAST_UPDATE_DATE,
412: LAST_UPDATED_BY,
413: LAST_UPDATE_LOGIN,
414: DESCRIPTION,

Line 430: from EDR_FILES_TL B, FND_LANGUAGES L

426: B.CREATION_DATE,
427: B.FILE_ID,
428: L.LANGUAGE_CODE,
429: B.SOURCE_LANG
430: from EDR_FILES_TL B, FND_LANGUAGES L
431: where L.INSTALLED_FLAG in ('I', 'B')
432: and B.LANGUAGE = userenv('LANG')
433: and not exists
434: (select NULL

Line 435: from EDR_FILES_TL T

431: where L.INSTALLED_FLAG in ('I', 'B')
432: and B.LANGUAGE = userenv('LANG')
433: and not exists
434: (select NULL
435: from EDR_FILES_TL T
436: where T.FILE_ID = B.FILE_ID
437: and T.LANGUAGE = L.LANGUAGE_CODE);
438: end ADD_LANGUAGE;
439: -- Bug 4472517 : start