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_TYPES_PKG dependencies on XDP_FE_TYPES

Line 1: package body XDP_FE_TYPES_PKG as

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

Line 15: cursor C is select ROWID from XDP_FE_TYPES

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from XDP_FE_TYPES
16: where FETYPE_ID = X_FETYPE_ID
17: ;
18: begin
19: insert into XDP_FE_TYPES (

Line 19: insert into XDP_FE_TYPES (

15: cursor C is select ROWID from XDP_FE_TYPES
16: where FETYPE_ID = X_FETYPE_ID
17: ;
18: begin
19: insert into XDP_FE_TYPES (
20: FETYPE_ID,
21: FULFILLMENT_ELEMENT_TYPE,
22: CREATION_DATE,
23: CREATED_BY,

Line 37: insert into XDP_FE_TYPES_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into XDP_FE_TYPES_TL (
38: FETYPE_ID,
39: DISPLAY_NAME,
40: DESCRIPTION,
41: CREATED_BY,

Line 63: from XDP_FE_TYPES_TL T

59: from FND_LANGUAGES L
60: where L.INSTALLED_FLAG in ('I', 'B')
61: and not exists
62: (select NULL
63: from XDP_FE_TYPES_TL T
64: where T.FETYPE_ID = X_FETYPE_ID
65: and T.LANGUAGE = L.LANGUAGE_CODE);
66:
67: open c;

Line 85: from XDP_FE_TYPES

81: X_DESCRIPTION in VARCHAR2
82: ) is
83: cursor c is select
84: FULFILLMENT_ELEMENT_TYPE
85: from XDP_FE_TYPES
86: where FETYPE_ID = X_FETYPE_ID
87: for update of FETYPE_ID nowait;
88: recinfo c%rowtype;
89:

Line 94: from XDP_FE_TYPES_TL

90: cursor c1 is select
91: DISPLAY_NAME,
92: DESCRIPTION,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from XDP_FE_TYPES_TL
95: where FETYPE_ID = X_FETYPE_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of FETYPE_ID nowait;
98: begin

Line 141: update XDP_FE_TYPES set

137: X_LAST_UPDATED_BY in NUMBER,
138: X_LAST_UPDATE_LOGIN in NUMBER
139: ) is
140: begin
141: update XDP_FE_TYPES set
142: FULFILLMENT_ELEMENT_TYPE = X_FULFILLMENT_ELEMENT_TYPE,
143: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
145: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 152: update XDP_FE_TYPES_TL set

148: if (sql%notfound) then
149: raise no_data_found;
150: end if;
151:
152: update XDP_FE_TYPES_TL set
153: DISPLAY_NAME = X_DISPLAY_NAME,
154: DESCRIPTION = X_DESCRIPTION,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 171: delete from XDP_FE_TYPES_TL

167: procedure DELETE_ROW (
168: X_FETYPE_ID in NUMBER
169: ) is
170: begin
171: delete from XDP_FE_TYPES_TL
172: where FETYPE_ID = X_FETYPE_ID;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 178: delete from XDP_FE_TYPES

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: delete from XDP_FE_TYPES
179: where FETYPE_ID = X_FETYPE_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 189: delete from XDP_FE_TYPES_TL T

185:
186: procedure ADD_LANGUAGE
187: is
188: begin
189: delete from XDP_FE_TYPES_TL T
190: where not exists
191: (select NULL
192: from XDP_FE_TYPES B
193: where B.FETYPE_ID = T.FETYPE_ID

Line 192: from XDP_FE_TYPES B

188: begin
189: delete from XDP_FE_TYPES_TL T
190: where not exists
191: (select NULL
192: from XDP_FE_TYPES B
193: where B.FETYPE_ID = T.FETYPE_ID
194: );
195:
196: update XDP_FE_TYPES_TL T set (

Line 196: update XDP_FE_TYPES_TL T set (

192: from XDP_FE_TYPES B
193: where B.FETYPE_ID = T.FETYPE_ID
194: );
195:
196: update XDP_FE_TYPES_TL T set (
197: DISPLAY_NAME,
198: DESCRIPTION
199: ) = (select
200: B.DISPLAY_NAME,

Line 202: from XDP_FE_TYPES_TL B

198: DESCRIPTION
199: ) = (select
200: B.DISPLAY_NAME,
201: B.DESCRIPTION
202: from XDP_FE_TYPES_TL B
203: where B.FETYPE_ID = T.FETYPE_ID
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.FETYPE_ID,

Line 211: from XDP_FE_TYPES_TL SUBB, XDP_FE_TYPES_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.FETYPE_ID,
210: SUBT.LANGUAGE
211: from XDP_FE_TYPES_TL SUBB, XDP_FE_TYPES_TL SUBT
212: where SUBB.FETYPE_ID = SUBT.FETYPE_ID
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
215: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 220: insert into XDP_FE_TYPES_TL (

216: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
217: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
218: ));
219:
220: insert into XDP_FE_TYPES_TL (
221: FETYPE_ID,
222: DISPLAY_NAME,
223: DESCRIPTION,
224: CREATED_BY,

Line 242: from XDP_FE_TYPES_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_DATE,
239: B.LAST_UPDATE_LOGIN,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from XDP_FE_TYPES_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from XDP_FE_TYPES_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from XDP_FE_TYPES_TL T
248: where T.FETYPE_ID = B.FETYPE_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:

Line 272: XDP_FE_TYPES_PKG.UPDATE_ROW (

268: -- user_id := 1;
269: --end if;
270: user_id := fnd_load_util.owner_id(X_OWNER);
271:
272: XDP_FE_TYPES_PKG.UPDATE_ROW (
273: X_FETYPE_ID => X_FETYPE_ID,
274: X_FULFILLMENT_ELEMENT_TYPE => X_FULFILLMENT_ELEMENT_TYPE,
275: X_DISPLAY_NAME => X_DISPLAY_NAME,
276: X_DESCRIPTION => X_DESCRIPTION,

Line 283: XDP_FE_TYPES_PKG.INSERT_ROW (

279: X_LAST_UPDATE_LOGIN => 0);
280:
281: exception
282: when NO_DATA_FOUND then
283: XDP_FE_TYPES_PKG.INSERT_ROW (
284: X_ROWID => row_id,
285: X_FETYPE_ID => X_FETYPE_ID,
286: X_FULFILLMENT_ELEMENT_TYPE => X_FULFILLMENT_ELEMENT_TYPE,
287: X_DISPLAY_NAME => X_DISPLAY_NAME,

Line 307: update XDP_FE_TYPES_TL

303: begin
304:
305: -- only update rows that have not been altered by user
306:
307: update XDP_FE_TYPES_TL
308: set display_name = X_DISPLAY_NAME,
309: description = X_DESCRIPTION,
310: source_lang = userenv('LANG'),
311: last_update_date = sysdate,

Line 322: end XDP_FE_TYPES_PKG;

318: end TRANSLATE_ROW;
319:
320:
321:
322: end XDP_FE_TYPES_PKG;