APPS.XDP_FE_ATTRIBUTE_VAL_PKG dependencies on XDP_FE_ATTRIBUTE_VAL_TL

Line 41: insert into XDP_FE_ATTRIBUTE_VAL_TL (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into XDP_FE_ATTRIBUTE_VAL_TL (
42: FE_ATTRIBUTE_ID,
43: FE_GENERIC_CONFIG_ID,
44: DISPLAY_NAME,
45: DESCRIPTION,

Line 69: from XDP_FE_ATTRIBUTE_VAL_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from XDP_FE_ATTRIBUTE_VAL_TL T
70: where T.FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
71: and T.FE_GENERIC_CONFIG_ID = X_FE_GENERIC_CONFIG_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73:

Line 103: from XDP_FE_ATTRIBUTE_VAL_TL

99: cursor c1 is select
100: DISPLAY_NAME,
101: DESCRIPTION,
102: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
103: from XDP_FE_ATTRIBUTE_VAL_TL
104: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
105: and FE_GENERIC_CONFIG_ID = X_FE_GENERIC_CONFIG_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of FE_ATTRIBUTE_ID nowait;

Line 165: update XDP_FE_ATTRIBUTE_VAL_TL set

161: if (sql%notfound) then
162: raise no_data_found;
163: end if;
164:
165: update XDP_FE_ATTRIBUTE_VAL_TL set
166: DISPLAY_NAME = X_DISPLAY_NAME,
167: DESCRIPTION = X_DESCRIPTION,
168: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
169: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 186: delete from XDP_FE_ATTRIBUTE_VAL_TL

182: X_FE_ATTRIBUTE_ID in NUMBER,
183: X_FE_GENERIC_CONFIG_ID in NUMBER
184: ) is
185: begin
186: delete from XDP_FE_ATTRIBUTE_VAL_TL
187: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
188: and FE_GENERIC_CONFIG_ID = X_FE_GENERIC_CONFIG_ID;
189:
190: if (sql%notfound) then

Line 206: delete from XDP_FE_ATTRIBUTE_VAL_TL T

202:
203: procedure ADD_LANGUAGE
204: is
205: begin
206: delete from XDP_FE_ATTRIBUTE_VAL_TL T
207: where not exists
208: (select NULL
209: from XDP_FE_ATTRIBUTE_VAL B
210: where B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID

Line 214: update XDP_FE_ATTRIBUTE_VAL_TL T set (

210: where B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID
211: and B.FE_GENERIC_CONFIG_ID = T.FE_GENERIC_CONFIG_ID
212: );
213:
214: update XDP_FE_ATTRIBUTE_VAL_TL T set (
215: DISPLAY_NAME,
216: DESCRIPTION
217: ) = (select
218: B.DISPLAY_NAME,

Line 220: from XDP_FE_ATTRIBUTE_VAL_TL B

216: DESCRIPTION
217: ) = (select
218: B.DISPLAY_NAME,
219: B.DESCRIPTION
220: from XDP_FE_ATTRIBUTE_VAL_TL B
221: where B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID
222: and B.FE_GENERIC_CONFIG_ID = T.FE_GENERIC_CONFIG_ID
223: and B.LANGUAGE = T.SOURCE_LANG)
224: where (

Line 232: from XDP_FE_ATTRIBUTE_VAL_TL SUBB, XDP_FE_ATTRIBUTE_VAL_TL SUBT

228: ) in (select
229: SUBT.FE_ATTRIBUTE_ID,
230: SUBT.FE_GENERIC_CONFIG_ID,
231: SUBT.LANGUAGE
232: from XDP_FE_ATTRIBUTE_VAL_TL SUBB, XDP_FE_ATTRIBUTE_VAL_TL SUBT
233: where SUBB.FE_ATTRIBUTE_ID = SUBT.FE_ATTRIBUTE_ID
234: and SUBB.FE_GENERIC_CONFIG_ID = SUBT.FE_GENERIC_CONFIG_ID
235: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
236: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 242: insert into XDP_FE_ATTRIBUTE_VAL_TL (

238: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
239: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
240: ));
241:
242: insert into XDP_FE_ATTRIBUTE_VAL_TL (
243: FE_ATTRIBUTE_ID,
244: FE_GENERIC_CONFIG_ID,
245: DISPLAY_NAME,
246: DESCRIPTION,

Line 266: from XDP_FE_ATTRIBUTE_VAL_TL B, FND_LANGUAGES L

262: B.LAST_UPDATE_DATE,
263: B.LAST_UPDATE_LOGIN,
264: L.LANGUAGE_CODE,
265: B.SOURCE_LANG
266: from XDP_FE_ATTRIBUTE_VAL_TL B, FND_LANGUAGES L
267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL

Line 271: from XDP_FE_ATTRIBUTE_VAL_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from XDP_FE_ATTRIBUTE_VAL_TL T
272: where T.FE_ATTRIBUTE_ID = B.FE_ATTRIBUTE_ID
273: and T.FE_GENERIC_CONFIG_ID = B.FE_GENERIC_CONFIG_ID
274: and T.LANGUAGE = L.LANGUAGE_CODE);
275: end ADD_LANGUAGE;

Line 336: update XDP_FE_ATTRIBUTE_VAL_TL

332: begin
333:
334: -- only update rows that have not been altered by user
335:
336: update XDP_FE_ATTRIBUTE_VAL_TL
337: set display_name = X_DISPLAY_NAME,
338: description = X_DESCRIPTION,
339: source_lang = userenv('LANG'),
340: last_update_date = sysdate,