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.CN_CW_WORKBENCH_ITEMS_ALL_PKG dependencies on CN_CW_WORKBENCH_ITEMS_ALL_TL

Line 50: insert into CN_CW_WORKBENCH_ITEMS_ALL_TL (

46: X_LAST_UPDATE_LOGIN,
47: X_ORG_ID
48: );
49:
50: insert into CN_CW_WORKBENCH_ITEMS_ALL_TL (
51: WORKBENCH_ITEM_CODE,
52: WORKBENCH_ITEM_NAME,
53: WORKBENCH_ITEM_DESCRIPTION,
54: LAST_UPDATE_DATE,

Line 78: from CN_CW_WORKBENCH_ITEMS_ALL_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from CN_CW_WORKBENCH_ITEMS_ALL_TL T
79: where T.WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE
80: and T.LANGUAGE = L.LANGUAGE_CODE AND
81: ORG_ID=X_ORG_ID);
82:

Line 119: from CN_CW_WORKBENCH_ITEMS_ALL_TL

115: cursor c1 is select
116: WORKBENCH_ITEM_NAME,
117: WORKBENCH_ITEM_DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from CN_CW_WORKBENCH_ITEMS_ALL_TL
120: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
122: ORG_ID=X_ORG_ID
123: for update of WORKBENCH_ITEM_CODE nowait;

Line 191: update CN_CW_WORKBENCH_ITEMS_ALL_TL set

187: if (sql%notfound) then
188: raise no_data_found;
189: end if;
190:
191: update CN_CW_WORKBENCH_ITEMS_ALL_TL set
192: WORKBENCH_ITEM_NAME = X_WORKBENCH_ITEM_NAME,
193: WORKBENCH_ITEM_DESCRIPTION = X_WORKBENCH_ITEM_DESCRIPTION,
194: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
195: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 212: delete from CN_CW_WORKBENCH_ITEMS_ALL_TL

208: X_WORKBENCH_ITEM_CODE in VARCHAR2,
209: X_ORG_ID IN NUMBER
210: ) is
211: begin
212: delete from CN_CW_WORKBENCH_ITEMS_ALL_TL
213: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE AND
214: ORG_ID=X_ORG_ID;
215:
216: if (sql%notfound) then

Line 232: delete from CN_CW_WORKBENCH_ITEMS_ALL_TL T

228:
229: procedure ADD_LANGUAGE
230: is
231: begin
232: delete from CN_CW_WORKBENCH_ITEMS_ALL_TL T
233: where not exists
234: (select NULL
235: from CN_CW_WORKBENCH_ITEMS_ALL_B B
236: where B.WORKBENCH_ITEM_CODE = T.WORKBENCH_ITEM_CODE AND

Line 240: update CN_CW_WORKBENCH_ITEMS_ALL_TL T set (

236: where B.WORKBENCH_ITEM_CODE = T.WORKBENCH_ITEM_CODE AND
237: B.ORG_ID=T.ORG_ID
238: );
239:
240: update CN_CW_WORKBENCH_ITEMS_ALL_TL T set (
241: WORKBENCH_ITEM_NAME,
242: WORKBENCH_ITEM_DESCRIPTION
243: ) = (select
244: B.WORKBENCH_ITEM_NAME,

Line 246: from CN_CW_WORKBENCH_ITEMS_ALL_TL B

242: WORKBENCH_ITEM_DESCRIPTION
243: ) = (select
244: B.WORKBENCH_ITEM_NAME,
245: B.WORKBENCH_ITEM_DESCRIPTION
246: from CN_CW_WORKBENCH_ITEMS_ALL_TL B
247: where B.WORKBENCH_ITEM_CODE = T.WORKBENCH_ITEM_CODE
248: and B.LANGUAGE = T.SOURCE_LANG AND B.ORG_ID=T.ORG_ID)
249: where (
250: T.WORKBENCH_ITEM_CODE,

Line 257: from CN_CW_WORKBENCH_ITEMS_ALL_TL SUBB, CN_CW_WORKBENCH_ITEMS_ALL_TL SUBT

253: ) in (select
254: SUBT.WORKBENCH_ITEM_CODE,
255: SUBT.LANGUAGE,
256: SUBT.ORG_ID
257: from CN_CW_WORKBENCH_ITEMS_ALL_TL SUBB, CN_CW_WORKBENCH_ITEMS_ALL_TL SUBT
258: where SUBB.WORKBENCH_ITEM_CODE = SUBT.WORKBENCH_ITEM_CODE
259: and SUBB.LANGUAGE = SUBT.SOURCE_LANG AND
260: SUBB.ORG_ID=SUBT.ORG_ID
261: and (SUBB.WORKBENCH_ITEM_NAME <> SUBT.WORKBENCH_ITEM_NAME

Line 265: insert into CN_CW_WORKBENCH_ITEMS_ALL_TL (

261: and (SUBB.WORKBENCH_ITEM_NAME <> SUBT.WORKBENCH_ITEM_NAME
262: or SUBB.WORKBENCH_ITEM_DESCRIPTION <> SUBT.WORKBENCH_ITEM_DESCRIPTION
263: ));
264:
265: insert into CN_CW_WORKBENCH_ITEMS_ALL_TL (
266: WORKBENCH_ITEM_CODE,
267: WORKBENCH_ITEM_NAME,
268: WORKBENCH_ITEM_DESCRIPTION,
269: LAST_UPDATE_DATE,

Line 289: from CN_CW_WORKBENCH_ITEMS_ALL_TL B, FND_LANGUAGES L

285: B.CREATION_DATE,
286: L.LANGUAGE_CODE,
287: B.SOURCE_LANG,
288: B.ORG_ID
289: from CN_CW_WORKBENCH_ITEMS_ALL_TL B, FND_LANGUAGES L
290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL

Line 294: from CN_CW_WORKBENCH_ITEMS_ALL_TL T

290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL
294: from CN_CW_WORKBENCH_ITEMS_ALL_TL T
295: where T.WORKBENCH_ITEM_CODE = B.WORKBENCH_ITEM_CODE
296: and T.LANGUAGE = L.LANGUAGE_CODE AND
297: T.ORG_ID=B.ORG_ID);
298: end ADD_LANGUAGE;

Line 320: UPDATE CN_CW_WORKBENCH_ITEMS_ALL_TL SET

316: ELSE
317: user_id := 0;
318: END IF;
319: -- Update the translation
320: UPDATE CN_CW_WORKBENCH_ITEMS_ALL_TL SET
321: WORKBENCH_ITEM_NAME = X_WORKBENCH_ITEM_NAME,
322: WORKBENCH_ITEM_DESCRIPTION=X_WORKBENCH_ITEM_DESCRIPTION,
323: last_update_date = sysdate,
324: last_updated_by = user_id,

Line 391: UPDATE CN_CW_WORKBENCH_ITEMS_ALL_TL set

387: X_ORG_ID
388: );
389: END IF;
390:
391: UPDATE CN_CW_WORKBENCH_ITEMS_ALL_TL set
392: WORKBENCH_ITEM_NAME = X_WORKBENCH_ITEM_NAME,
393: WORKBENCH_ITEM_DESCRIPTION = X_WORKBENCH_ITEM_DESCRIPTION,
394: LAST_UPDATED_BY = USER_ID,
395: LAST_UPDATE_LOGIN = 0,

Line 401: insert into CN_CW_WORKBENCH_ITEMS_ALL_TL (

397: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE
398: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
399:
400: IF (SQL%NOTFOUND) THEN
401: insert into CN_CW_WORKBENCH_ITEMS_ALL_TL (
402: WORKBENCH_ITEM_CODE,
403: WORKBENCH_ITEM_NAME,
404: WORKBENCH_ITEM_DESCRIPTION,
405: LAST_UPDATE_DATE,

Line 429: from CN_CW_WORKBENCH_ITEMS_ALL_TL T

425: from FND_LANGUAGES L
426: where L.INSTALLED_FLAG in ('I', 'B')
427: and not exists
428: (select NULL
429: from CN_CW_WORKBENCH_ITEMS_ALL_TL T
430: where T.WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE
431: and T.LANGUAGE = L.LANGUAGE_CODE AND
432: ORG_ID=X_ORG_ID);
433: END IF;