APPS.XDP_FES_PKG dependencies on XDP_FES_TL

Line 64: insert into XDP_FES_TL (

60: X_LAST_UPDATED_BY,
61: X_LAST_UPDATE_LOGIN
62: );
63:
64: insert into XDP_FES_TL (
65: FE_ID,
66: DISPLAY_NAME,
67: DESCRIPTION,
68: CREATED_BY,

Line 90: from XDP_FES_TL T

86: from FND_LANGUAGES L
87: where L.INSTALLED_FLAG in ('I', 'B')
88: and not exists
89: (select NULL
90: from XDP_FES_TL T
91: where T.FE_ID = X_FE_ID
92: and T.LANGUAGE = L.LANGUAGE_CODE);
93:
94: open c;

Line 139: from XDP_FES_TL

135: cursor c1 is select
136: DISPLAY_NAME,
137: DESCRIPTION,
138: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
139: from XDP_FES_TL
140: where FE_ID = X_FE_ID
141: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
142: for update of FE_ID nowait;
143: begin

Line 230: update XDP_FES_TL set

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: update XDP_FES_TL set
231: DISPLAY_NAME = X_DISPLAY_NAME,
232: DESCRIPTION = X_DESCRIPTION,
233: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
234: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 249: delete from XDP_FES_TL

245: procedure DELETE_ROW (
246: X_FE_ID in NUMBER
247: ) is
248: begin
249: delete from XDP_FES_TL
250: where FE_ID = X_FE_ID;
251:
252: if (sql%notfound) then
253: raise no_data_found;

Line 267: delete from XDP_FES_TL T

263:
264: procedure ADD_LANGUAGE
265: is
266: begin
267: delete from XDP_FES_TL T
268: where not exists
269: (select NULL
270: from XDP_FES B
271: where B.FE_ID = T.FE_ID

Line 274: update XDP_FES_TL T set (

270: from XDP_FES B
271: where B.FE_ID = T.FE_ID
272: );
273:
274: update XDP_FES_TL T set (
275: DISPLAY_NAME,
276: DESCRIPTION
277: ) = (select
278: B.DISPLAY_NAME,

Line 280: from XDP_FES_TL B

276: DESCRIPTION
277: ) = (select
278: B.DISPLAY_NAME,
279: B.DESCRIPTION
280: from XDP_FES_TL B
281: where B.FE_ID = T.FE_ID
282: and B.LANGUAGE = T.SOURCE_LANG)
283: where (
284: T.FE_ID,

Line 289: from XDP_FES_TL SUBB, XDP_FES_TL SUBT

285: T.LANGUAGE
286: ) in (select
287: SUBT.FE_ID,
288: SUBT.LANGUAGE
289: from XDP_FES_TL SUBB, XDP_FES_TL SUBT
290: where SUBB.FE_ID = SUBT.FE_ID
291: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
292: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
293: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 298: insert into XDP_FES_TL (

294: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
295: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
296: ));
297:
298: insert into XDP_FES_TL (
299: FE_ID,
300: DISPLAY_NAME,
301: DESCRIPTION,
302: CREATED_BY,

Line 320: from XDP_FES_TL B, FND_LANGUAGES L

316: B.LAST_UPDATE_DATE,
317: B.LAST_UPDATE_LOGIN,
318: L.LANGUAGE_CODE,
319: B.SOURCE_LANG
320: from XDP_FES_TL B, FND_LANGUAGES L
321: where L.INSTALLED_FLAG in ('I', 'B')
322: and B.LANGUAGE = userenv('LANG')
323: and not exists
324: (select NULL

Line 325: from XDP_FES_TL T

321: where L.INSTALLED_FLAG in ('I', 'B')
322: and B.LANGUAGE = userenv('LANG')
323: and not exists
324: (select NULL
325: from XDP_FES_TL T
326: where T.FE_ID = B.FE_ID
327: and T.LANGUAGE = L.LANGUAGE_CODE);
328: end ADD_LANGUAGE;
329:

Line 412: update XDP_FES_TL

408: begin
409:
410: -- only update rows that have not been altered by user
411:
412: update XDP_FES_TL
413: set display_name = X_DISPLAY_NAME,
414: description = X_DESCRIPTION,
415: source_lang = userenv('LANG'),
416: last_update_date = sysdate,