APPS.XDP_FE_ATTRIBUTE_DEF_PKG dependencies on XDP_FE_ATTRIBUTE_DEF_TL

Line 49: insert into XDP_FE_ATTRIBUTE_DEF_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into XDP_FE_ATTRIBUTE_DEF_TL (
50: FE_ATTRIBUTE_ID,
51: DISPLAY_NAME,
52: DESCRIPTION,
53: CREATED_BY,

Line 75: from XDP_FE_ATTRIBUTE_DEF_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from XDP_FE_ATTRIBUTE_DEF_TL T
76: where T.FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from XDP_FE_ATTRIBUTE_DEF_TL

110: cursor c1 is select
111: DISPLAY_NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from XDP_FE_ATTRIBUTE_DEF_TL
115: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of FE_ATTRIBUTE_ID nowait;
118: begin

Line 186: update XDP_FE_ATTRIBUTE_DEF_TL set

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update XDP_FE_ATTRIBUTE_DEF_TL set
187: DISPLAY_NAME = X_DISPLAY_NAME,
188: DESCRIPTION = X_DESCRIPTION,
189: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
190: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 205: delete from XDP_FE_ATTRIBUTE_DEF_TL

201: procedure DELETE_ROW (
202: X_FE_ATTRIBUTE_ID in NUMBER
203: ) is
204: begin
205: delete from XDP_FE_ATTRIBUTE_DEF_TL
206: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 223: delete from XDP_FE_ATTRIBUTE_DEF_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from XDP_FE_ATTRIBUTE_DEF_TL T
224: where not exists
225: (select NULL
226: from XDP_FE_ATTRIBUTE_DEF B
227: where B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID

Line 230: update XDP_FE_ATTRIBUTE_DEF_TL T set (

226: from XDP_FE_ATTRIBUTE_DEF B
227: where B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID
228: );
229:
230: update XDP_FE_ATTRIBUTE_DEF_TL T set (
231: DISPLAY_NAME,
232: DESCRIPTION
233: ) = (select
234: B.DISPLAY_NAME,

Line 236: from XDP_FE_ATTRIBUTE_DEF_TL B

232: DESCRIPTION
233: ) = (select
234: B.DISPLAY_NAME,
235: B.DESCRIPTION
236: from XDP_FE_ATTRIBUTE_DEF_TL B
237: where B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (
240: T.FE_ATTRIBUTE_ID,

Line 245: from XDP_FE_ATTRIBUTE_DEF_TL SUBB, XDP_FE_ATTRIBUTE_DEF_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.FE_ATTRIBUTE_ID,
244: SUBT.LANGUAGE
245: from XDP_FE_ATTRIBUTE_DEF_TL SUBB, XDP_FE_ATTRIBUTE_DEF_TL SUBT
246: where SUBB.FE_ATTRIBUTE_ID = SUBT.FE_ATTRIBUTE_ID
247: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
248: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
249: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 254: insert into XDP_FE_ATTRIBUTE_DEF_TL (

250: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
251: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
252: ));
253:
254: insert into XDP_FE_ATTRIBUTE_DEF_TL (
255: FE_ATTRIBUTE_ID,
256: DISPLAY_NAME,
257: DESCRIPTION,
258: CREATED_BY,

Line 276: from XDP_FE_ATTRIBUTE_DEF_TL B, FND_LANGUAGES L

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

Line 281: from XDP_FE_ATTRIBUTE_DEF_TL T

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

Line 353: update XDP_FE_ATTRIBUTE_DEF_TL

349: begin
350:
351: -- only update rows that have not been altered by user
352:
353: update XDP_FE_ATTRIBUTE_DEF_TL
354: set display_name = X_DISPLAY_NAME,
355: description = X_DESCRIPTION,
356: source_lang = userenv('LANG'),
357: last_update_date = sysdate,