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_FES_PKG dependencies on XDP_FES

Line 1: package body XDP_FES_PKG as

1: package body XDP_FES_PKG as
2: /* $Header: XDPFEB.pls 120.2 2005/07/14 22:48:22 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_FE_ID in NUMBER,

Line 24: cursor C is select ROWID from XDP_FES

20: X_LAST_UPDATE_DATE in DATE,
21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER
23: ) is
24: cursor C is select ROWID from XDP_FES
25: where FE_ID = X_FE_ID
26: ;
27: begin
28: insert into XDP_FES (

Line 28: insert into XDP_FES (

24: cursor C is select ROWID from XDP_FES
25: where FE_ID = X_FE_ID
26: ;
27: begin
28: insert into XDP_FES (
29: FE_ID,
30: FETYPE_ID,
31: FULFILLMENT_ELEMENT_NAME,
32: MAX_CONNECTION,

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 130: from XDP_FES

126: INVALID_DATE,
127: GEO_AREA_ID,
128: ROLE_NAME,
129: NETWORK_UNIT_ID
130: from XDP_FES
131: where FE_ID = X_FE_ID
132: for update of FE_ID nowait;
133: recinfo c%rowtype;
134:

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 210: update XDP_FES set

206: X_LAST_UPDATED_BY in NUMBER,
207: X_LAST_UPDATE_LOGIN in NUMBER
208: ) is
209: begin
210: update XDP_FES set
211: FETYPE_ID = X_FETYPE_ID,
212: FULFILLMENT_ELEMENT_NAME = X_FULFILLMENT_ELEMENT_NAME,
213: MAX_CONNECTION = X_MAX_CONNECTION,
214: MIN_CONNECTION = X_MIN_CONNECTION,

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 256: delete from XDP_FES

252: if (sql%notfound) then
253: raise no_data_found;
254: end if;
255:
256: delete from XDP_FES
257: where FE_ID = X_FE_ID;
258:
259: if (sql%notfound) then
260: 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 270: from XDP_FES B

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
272: );
273:
274: update XDP_FES_TL T set (

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 359: XDP_FES_PKG.UPDATE_ROW (

355: -- user_id := 1;
356: --end if;
357: user_id := fnd_load_util.owner_id(X_OWNER);
358:
359: XDP_FES_PKG.UPDATE_ROW (
360: X_FE_ID => X_FE_ID,
361: X_FETYPE_ID => X_FETYPE_ID,
362: X_FULFILLMENT_ELEMENT_NAME => X_FULFILLMENT_ELEMENT_NAME,
363: X_MAX_CONNECTION => X_MAX_CONNECTION,

Line 379: XDP_FES_PKG.INSERT_ROW (

375: X_LAST_UPDATE_LOGIN => 0);
376:
377: exception
378: when NO_DATA_FOUND then
379: XDP_FES_PKG.INSERT_ROW (
380: X_ROWID => row_id,
381: X_FE_ID => X_FE_ID,
382: X_FETYPE_ID => X_FETYPE_ID,
383: X_FULFILLMENT_ELEMENT_NAME => X_FULFILLMENT_ELEMENT_NAME,

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,

Line 426: end XDP_FES_PKG;

422:
423: end TRANSLATE_ROW;
424:
425:
426: end XDP_FES_PKG;