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_SW_GEN_LOOKUP_PKG dependencies on XDP_FE_SW_GEN_LOOKUP

Line 1: package body XDP_FE_SW_GEN_LOOKUP_PKG as

1: package body XDP_FE_SW_GEN_LOOKUP_PKG as
2: /* $Header: XDPFEGLB.pls 120.2 2005/07/15 01:18:30 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_FE_SW_GEN_LOOKUP_ID in NUMBER,

Line 19: cursor C is select ROWID from XDP_FE_SW_GEN_LOOKUP

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from XDP_FE_SW_GEN_LOOKUP
20: where FE_SW_GEN_LOOKUP_ID = X_FE_SW_GEN_LOOKUP_ID
21: ;
22: begin
23: insert into XDP_FE_SW_GEN_LOOKUP (

Line 23: insert into XDP_FE_SW_GEN_LOOKUP (

19: cursor C is select ROWID from XDP_FE_SW_GEN_LOOKUP
20: where FE_SW_GEN_LOOKUP_ID = X_FE_SW_GEN_LOOKUP_ID
21: ;
22: begin
23: insert into XDP_FE_SW_GEN_LOOKUP (
24: FE_SW_GEN_LOOKUP_ID,
25: FETYPE_ID,
26: SW_GENERIC,
27: ADAPTER_TYPE,

Line 49: insert into XDP_FE_SW_GEN_LOOKUP_TL (

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

Line 75: from XDP_FE_SW_GEN_LOOKUP_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_SW_GEN_LOOKUP_TL T
76: where T.FE_SW_GEN_LOOKUP_ID = X_FE_SW_GEN_LOOKUP_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 105: from XDP_FE_SW_GEN_LOOKUP

101: SW_GENERIC,
102: ADAPTER_TYPE,
103: SW_START_PROC,
104: SW_EXIT_PROC
105: from XDP_FE_SW_GEN_LOOKUP
106: where FE_SW_GEN_LOOKUP_ID = X_FE_SW_GEN_LOOKUP_ID
107: for update of FE_SW_GEN_LOOKUP_ID nowait;
108: recinfo c%rowtype;
109:

Line 114: from XDP_FE_SW_GEN_LOOKUP_TL

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

Line 171: update XDP_FE_SW_GEN_LOOKUP set

167: X_LAST_UPDATED_BY in NUMBER,
168: X_LAST_UPDATE_LOGIN in NUMBER
169: ) is
170: begin
171: update XDP_FE_SW_GEN_LOOKUP set
172: FETYPE_ID = X_FETYPE_ID,
173: SW_GENERIC = X_SW_GENERIC,
174: ADAPTER_TYPE = X_ADAPTER_TYPE,
175: SW_START_PROC = X_SW_START_PROC,

Line 186: update XDP_FE_SW_GEN_LOOKUP_TL set

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update XDP_FE_SW_GEN_LOOKUP_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_SW_GEN_LOOKUP_TL

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

Line 212: delete from XDP_FE_SW_GEN_LOOKUP

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from XDP_FE_SW_GEN_LOOKUP
213: where FE_SW_GEN_LOOKUP_ID = X_FE_SW_GEN_LOOKUP_ID;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 223: delete from XDP_FE_SW_GEN_LOOKUP_TL T

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

Line 226: from XDP_FE_SW_GEN_LOOKUP B

222: begin
223: delete from XDP_FE_SW_GEN_LOOKUP_TL T
224: where not exists
225: (select NULL
226: from XDP_FE_SW_GEN_LOOKUP B
227: where B.FE_SW_GEN_LOOKUP_ID = T.FE_SW_GEN_LOOKUP_ID
228: );
229:
230: update XDP_FE_SW_GEN_LOOKUP_TL T set (

Line 230: update XDP_FE_SW_GEN_LOOKUP_TL T set (

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

Line 236: from XDP_FE_SW_GEN_LOOKUP_TL B

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

Line 245: from XDP_FE_SW_GEN_LOOKUP_TL SUBB, XDP_FE_SW_GEN_LOOKUP_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.FE_SW_GEN_LOOKUP_ID,
244: SUBT.LANGUAGE
245: from XDP_FE_SW_GEN_LOOKUP_TL SUBB, XDP_FE_SW_GEN_LOOKUP_TL SUBT
246: where SUBB.FE_SW_GEN_LOOKUP_ID = SUBT.FE_SW_GEN_LOOKUP_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_SW_GEN_LOOKUP_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_SW_GEN_LOOKUP_TL (
255: FE_SW_GEN_LOOKUP_ID,
256: DISPLAY_NAME,
257: DESCRIPTION,
258: CREATED_BY,

Line 276: from XDP_FE_SW_GEN_LOOKUP_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_SW_GEN_LOOKUP_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_SW_GEN_LOOKUP_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_SW_GEN_LOOKUP_TL T
282: where T.FE_SW_GEN_LOOKUP_ID = B.FE_SW_GEN_LOOKUP_ID
283: and T.LANGUAGE = L.LANGUAGE_CODE);
284: end ADD_LANGUAGE;
285:

Line 310: XDP_FE_SW_GEN_LOOKUP_PKG.UPDATE_ROW (

306: -- user_id := 1;
307: --end if;
308: user_id := fnd_load_util.owner_id(X_OWNER);
309:
310: XDP_FE_SW_GEN_LOOKUP_PKG.UPDATE_ROW (
311: X_FE_SW_GEN_LOOKUP_ID => X_FE_SW_GEN_LOOKUP_ID,
312: X_FETYPE_ID => X_FETYPE_ID,
313: X_SW_GENERIC => X_SW_GENERIC,
314: X_ADAPTER_TYPE => X_ADAPTER_TYPE,

Line 325: XDP_FE_SW_GEN_LOOKUP_PKG.INSERT_ROW (

321: X_LAST_UPDATE_LOGIN => 0);
322:
323: exception
324: when NO_DATA_FOUND then
325: XDP_FE_SW_GEN_LOOKUP_PKG.INSERT_ROW (
326: X_ROWID => row_id,
327: X_FE_SW_GEN_LOOKUP_ID => X_FE_SW_GEN_LOOKUP_ID,
328: X_FETYPE_ID => X_FETYPE_ID,
329: X_SW_GENERIC => X_SW_GENERIC,

Line 353: update XDP_FE_SW_GEN_LOOKUP_TL

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

Line 367: end XDP_FE_SW_GEN_LOOKUP_PKG;

363:
364: end TRANSLATE_ROW;
365:
366:
367: end XDP_FE_SW_GEN_LOOKUP_PKG;