APPS.XDP_WORKITEMS_PKG dependencies on XDP_WORKITEMS_TL

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 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 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 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 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 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,