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_WORKITEMS_PKG dependencies on XDP_WORKITEMS

Line 1: package body XDP_WORKITEMS_PKG as

1: package body XDP_WORKITEMS_PKG as
2: /* $Header: XDPWIB.pls 120.2 2005/07/15 06:31:42 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_WORKITEM_ID in NUMBER,

Line 29: cursor C is select ROWID from XDP_WORKITEMS

25: X_LAST_UPDATE_DATE in DATE,
26: X_LAST_UPDATED_BY in NUMBER,
27: X_LAST_UPDATE_LOGIN in NUMBER
28: ) is
29: cursor C is select ROWID from XDP_WORKITEMS
30: where WORKITEM_ID = X_WORKITEM_ID
31: ;
32: begin
33: insert into XDP_WORKITEMS (

Line 33: insert into XDP_WORKITEMS (

29: cursor C is select ROWID from XDP_WORKITEMS
30: where WORKITEM_ID = X_WORKITEM_ID
31: ;
32: begin
33: insert into XDP_WORKITEMS (
34: WORKITEM_ID,
35: WORKITEM_NAME,
36: VERSION,
37: WI_TYPE_CODE,

Line 79: insert into XDP_WORKITEMS_TL (

75: X_LAST_UPDATED_BY,
76: X_LAST_UPDATE_LOGIN
77: );
78:
79: insert into XDP_WORKITEMS_TL (
80: WORKITEM_ID,
81: DISPLAY_NAME,
82: DESCRIPTION,
83: CREATED_BY,

Line 105: from XDP_WORKITEMS_TL T

101: from FND_LANGUAGES L
102: where L.INSTALLED_FLAG in ('I', 'B')
103: and not exists
104: (select NULL
105: from XDP_WORKITEMS_TL T
106: where T.WORKITEM_ID = X_WORKITEM_ID
107: and T.LANGUAGE = L.LANGUAGE_CODE);
108:
109: open c;

Line 155: from XDP_WORKITEMS

151: WF_EXEC_PROC,
152: TIME_ESTIMATE,
153: PROTECTED_FLAG,
154: ROLE_NAME
155: from XDP_WORKITEMS
156: where WORKITEM_ID = X_WORKITEM_ID
157: for update of WORKITEM_ID nowait;
158: recinfo c%rowtype;
159:

Line 164: from XDP_WORKITEMS_TL

160: cursor c1 is select
161: DISPLAY_NAME,
162: DESCRIPTION,
163: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
164: from XDP_WORKITEMS_TL
165: where WORKITEM_ID = X_WORKITEM_ID
166: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
167: for update of WORKITEM_ID nowait;
168: begin

Line 249: update XDP_WORKITEMS set

245: X_LAST_UPDATED_BY in NUMBER,
246: X_LAST_UPDATE_LOGIN in NUMBER
247: ) is
248: begin
249: update XDP_WORKITEMS set
250: WORKITEM_NAME = X_WORKITEM_NAME,
251: VERSION = X_VERSION,
252: WI_TYPE_CODE = X_WI_TYPE_CODE,
253: VALID_DATE = X_VALID_DATE,

Line 274: update XDP_WORKITEMS_TL set

270: if (sql%notfound) then
271: raise no_data_found;
272: end if;
273:
274: update XDP_WORKITEMS_TL set
275: DISPLAY_NAME = X_DISPLAY_NAME,
276: DESCRIPTION = X_DESCRIPTION,
277: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
278: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 293: delete from XDP_WORKITEMS_TL

289: procedure DELETE_ROW (
290: X_WORKITEM_ID in NUMBER
291: ) is
292: begin
293: delete from XDP_WORKITEMS_TL
294: where WORKITEM_ID = X_WORKITEM_ID;
295:
296: if (sql%notfound) then
297: raise no_data_found;

Line 300: delete from XDP_WORKITEMS

296: if (sql%notfound) then
297: raise no_data_found;
298: end if;
299:
300: delete from XDP_WORKITEMS
301: where WORKITEM_ID = X_WORKITEM_ID;
302:
303: if (sql%notfound) then
304: raise no_data_found;

Line 311: delete from XDP_WORKITEMS_TL T

307:
308: procedure ADD_LANGUAGE
309: is
310: begin
311: delete from XDP_WORKITEMS_TL T
312: where not exists
313: (select NULL
314: from XDP_WORKITEMS B
315: where B.WORKITEM_ID = T.WORKITEM_ID

Line 314: from XDP_WORKITEMS B

310: begin
311: delete from XDP_WORKITEMS_TL T
312: where not exists
313: (select NULL
314: from XDP_WORKITEMS B
315: where B.WORKITEM_ID = T.WORKITEM_ID
316: );
317:
318: update XDP_WORKITEMS_TL T set (

Line 318: update XDP_WORKITEMS_TL T set (

314: from XDP_WORKITEMS B
315: where B.WORKITEM_ID = T.WORKITEM_ID
316: );
317:
318: update XDP_WORKITEMS_TL T set (
319: DISPLAY_NAME,
320: DESCRIPTION
321: ) = (select
322: B.DISPLAY_NAME,

Line 324: from XDP_WORKITEMS_TL B

320: DESCRIPTION
321: ) = (select
322: B.DISPLAY_NAME,
323: B.DESCRIPTION
324: from XDP_WORKITEMS_TL B
325: where B.WORKITEM_ID = T.WORKITEM_ID
326: and B.LANGUAGE = T.SOURCE_LANG)
327: where (
328: T.WORKITEM_ID,

Line 333: from XDP_WORKITEMS_TL SUBB, XDP_WORKITEMS_TL SUBT

329: T.LANGUAGE
330: ) in (select
331: SUBT.WORKITEM_ID,
332: SUBT.LANGUAGE
333: from XDP_WORKITEMS_TL SUBB, XDP_WORKITEMS_TL SUBT
334: where SUBB.WORKITEM_ID = SUBT.WORKITEM_ID
335: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
336: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
337: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 342: insert into XDP_WORKITEMS_TL (

338: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
339: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
340: ));
341:
342: insert into XDP_WORKITEMS_TL (
343: WORKITEM_ID,
344: DISPLAY_NAME,
345: DESCRIPTION,
346: CREATED_BY,

Line 364: from XDP_WORKITEMS_TL B, FND_LANGUAGES L

360: B.LAST_UPDATE_DATE,
361: B.LAST_UPDATE_LOGIN,
362: L.LANGUAGE_CODE,
363: B.SOURCE_LANG
364: from XDP_WORKITEMS_TL B, FND_LANGUAGES L
365: where L.INSTALLED_FLAG in ('I', 'B')
366: and B.LANGUAGE = userenv('LANG')
367: and not exists
368: (select NULL

Line 369: from XDP_WORKITEMS_TL T

365: where L.INSTALLED_FLAG in ('I', 'B')
366: and B.LANGUAGE = userenv('LANG')
367: and not exists
368: (select NULL
369: from XDP_WORKITEMS_TL T
370: where T.WORKITEM_ID = B.WORKITEM_ID
371: and T.LANGUAGE = L.LANGUAGE_CODE);
372: end ADD_LANGUAGE;
373:

Line 408: XDP_WORKITEMS_PKG.UPDATE_ROW (

404: -- user_id := 1;
405: --end if;
406: user_id := fnd_load_util.owner_id(X_OWNER);
407:
408: XDP_WORKITEMS_PKG.UPDATE_ROW (
409: X_WORKITEM_ID => X_WORKITEM_ID,
410: X_WORKITEM_NAME => X_WORKITEM_NAME,
411: X_VERSION => X_VERSION,
412: X_WI_TYPE_CODE => X_WI_TYPE_CODE,

Line 433: XDP_WORKITEMS_PKG.INSERT_ROW (

429: X_LAST_UPDATE_LOGIN => 0);
430:
431: exception
432: when NO_DATA_FOUND then
433: XDP_WORKITEMS_PKG.INSERT_ROW (
434: X_ROWID => row_id,
435: X_WORKITEM_ID => X_WORKITEM_ID,
436: X_WORKITEM_NAME => X_WORKITEM_NAME,
437: X_VERSION => X_VERSION,

Line 471: update XDP_WORKITEMS_TL

467: begin
468:
469: -- only update rows that have not been altered by user
470:
471: update XDP_WORKITEMS_TL
472: set description = X_DESCRIPTION,
473: display_name = X_DISPLAY_NAME,
474: source_lang = userenv('LANG'),
475: last_update_date = sysdate,

Line 485: end XDP_WORKITEMS_PKG;

481:
482: end TRANSLATE_ROW;
483:
484:
485: end XDP_WORKITEMS_PKG;