eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_FE_ATTRIBUTE_VAL_PKG dependencies on XDP_FE_ATTRIBUTE_VAL

Line 1: package body XDP_FE_ATTRIBUTE_VAL_PKG as

1: package body XDP_FE_ATTRIBUTE_VAL_PKG as
2: /* $Header: XDPFEAVB.pls 120.2 2005/07/14 22:49:31 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_FE_ATTRIBUTE_ID in NUMBER,

Line 16: cursor C is select ROWID from XDP_FE_ATTRIBUTE_VAL

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from XDP_FE_ATTRIBUTE_VAL
17: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
18: and FE_GENERIC_CONFIG_ID = X_FE_GENERIC_CONFIG_ID
19: ;
20: begin

Line 21: insert into XDP_FE_ATTRIBUTE_VAL (

17: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
18: and FE_GENERIC_CONFIG_ID = X_FE_GENERIC_CONFIG_ID
19: ;
20: begin
21: insert into XDP_FE_ATTRIBUTE_VAL (
22: FE_ATTRIBUTE_ID,
23: FE_GENERIC_CONFIG_ID,
24: FE_ATTRIBUTE_VALUE,
25: CREATION_DATE,

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 93: from XDP_FE_ATTRIBUTE_VAL

89: X_DESCRIPTION in VARCHAR2
90: ) is
91: cursor c is select
92: FE_ATTRIBUTE_VALUE
93: from XDP_FE_ATTRIBUTE_VAL
94: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
95: and FE_GENERIC_CONFIG_ID = X_FE_GENERIC_CONFIG_ID
96: for update of FE_ATTRIBUTE_ID nowait;
97: recinfo c%rowtype;

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 153: update XDP_FE_ATTRIBUTE_VAL set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update XDP_FE_ATTRIBUTE_VAL set
154: FE_ATTRIBUTE_VALUE = X_FE_ATTRIBUTE_VALUE,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
157: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

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 194: delete from XDP_FE_ATTRIBUTE_VAL

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: delete from XDP_FE_ATTRIBUTE_VAL
195: where FE_ATTRIBUTE_ID = X_FE_ATTRIBUTE_ID
196: and FE_GENERIC_CONFIG_ID = X_FE_GENERIC_CONFIG_ID;
197:
198: 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 209: from XDP_FE_ATTRIBUTE_VAL B

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
211: and B.FE_GENERIC_CONFIG_ID = T.FE_GENERIC_CONFIG_ID
212: );
213:

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 298: XDP_FE_ATTRIBUTE_VAL_PKG.UPDATE_ROW (

294: -- user_id := 1;
295: --end if;
296: user_id := fnd_load_util.owner_id(X_OWNER);
297:
298: XDP_FE_ATTRIBUTE_VAL_PKG.UPDATE_ROW (
299: X_FE_ATTRIBUTE_ID => X_FE_ATTRIBUTE_ID,
300: X_FE_GENERIC_CONFIG_ID => X_FE_GENERIC_CONFIG_ID,
301: X_FE_ATTRIBUTE_VALUE => X_FE_ATTRIBUTE_VALUE,
302: X_DISPLAY_NAME => X_DISPLAY_NAME,

Line 310: XDP_FE_ATTRIBUTE_VAL_PKG.INSERT_ROW (

306: X_LAST_UPDATE_LOGIN => 0);
307:
308: exception
309: when NO_DATA_FOUND then
310: XDP_FE_ATTRIBUTE_VAL_PKG.INSERT_ROW (
311: X_ROWID => row_id,
312: X_FE_ATTRIBUTE_ID => X_FE_ATTRIBUTE_ID,
313: X_FE_GENERIC_CONFIG_ID => X_FE_GENERIC_CONFIG_ID,
314: X_FE_ATTRIBUTE_VALUE => X_FE_ATTRIBUTE_VALUE,

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,

Line 351: end XDP_FE_ATTRIBUTE_VAL_PKG;

347:
348: end TRANSLATE_ROW;
349:
350:
351: end XDP_FE_ATTRIBUTE_VAL_PKG;