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_SETUP_TASKS_ALL_PKG dependencies on CN_CW_SETUP_TASKS_ALL_TL

Line 57: insert into CN_CW_SETUP_TASKS_ALL_TL (

53: X_LAST_UPDATE_LOGIN,
54: X_ORG_ID
55: );
56:
57: insert into CN_CW_SETUP_TASKS_ALL_TL (
58: SETUP_TASK_CODE,
59: SETUP_TASK_NAME,
60: SETUP_TASK_DESCRIPTION,
61: LAST_UPDATE_DATE,

Line 85: from CN_CW_SETUP_TASKS_ALL_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from CN_CW_SETUP_TASKS_ALL_TL T
86: where T.SETUP_TASK_CODE = X_SETUP_TASK_CODE
87: and T.ORG_ID = X_ORG_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:

Line 129: from CN_CW_SETUP_TASKS_ALL_TL

125: cursor c1 is select
126: SETUP_TASK_NAME,
127: SETUP_TASK_DESCRIPTION,
128: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
129: from CN_CW_SETUP_TASKS_ALL_TL
130: where SETUP_TASK_CODE = X_SETUP_TASK_CODE
131: and ORG_ID = X_ORG_ID
132: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
133: for update of SETUP_TASK_CODE nowait;

Line 207: update CN_CW_SETUP_TASKS_ALL_TL set

203: if (sql%notfound) then
204: raise no_data_found;
205: end if;
206:
207: update CN_CW_SETUP_TASKS_ALL_TL set
208: SETUP_TASK_NAME = X_SETUP_TASK_NAME,
209: SETUP_TASK_DESCRIPTION = X_SETUP_TASK_DESCRIPTION,
210: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
211: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 228: delete from CN_CW_SETUP_TASKS_ALL_TL

224: X_SETUP_TASK_CODE in VARCHAR2,
225: X_ORG_ID in NUMBER
226: ) is
227: begin
228: delete from CN_CW_SETUP_TASKS_ALL_TL
229: where SETUP_TASK_CODE = X_SETUP_TASK_CODE
230: and ORG_ID = X_ORG_ID;
231:
232: if (sql%notfound) then

Line 265: UPDATE CN_CW_SETUP_TASKS_ALL_TL SET

261: ELSE
262: user_id := 0;
263: END IF;
264: -- Update the translation
265: UPDATE CN_CW_SETUP_TASKS_ALL_TL SET
266: SETUP_TASK_NAME = X_SETUP_TASK_NAME,
267: SETUP_TASK_DESCRIPTION=X_SETUP_TASK_DESCRIPTION,
268: last_update_date = sysdate,
269: last_updated_by = user_id,

Line 344: UPDATE CN_CW_SETUP_TASKS_ALL_TL set

340: X_ORG_ID
341: );
342: END IF;
343:
344: UPDATE CN_CW_SETUP_TASKS_ALL_TL set
345: SETUP_TASK_NAME = X_SETUP_TASK_NAME,
346: SETUP_TASK_DESCRIPTION = X_SETUP_TASK_DESCRIPTION,
347: LAST_UPDATED_BY = USER_ID,
348: LAST_UPDATE_LOGIN = 0,

Line 354: insert into CN_CW_SETUP_TASKS_ALL_TL (

350: where SETUP_TASK_CODE = X_SETUP_TASK_CODE
351: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
352:
353: IF (SQL%NOTFOUND) THEN
354: insert into CN_CW_SETUP_TASKS_ALL_TL (
355: SETUP_TASK_CODE,
356: SETUP_TASK_NAME,
357: SETUP_TASK_DESCRIPTION,
358: LAST_UPDATE_DATE,

Line 382: from CN_CW_SETUP_TASKS_ALL_TL T

378: from FND_LANGUAGES L
379: where L.INSTALLED_FLAG in ('I', 'B')
380: and not exists
381: (select NULL
382: from CN_CW_SETUP_TASKS_ALL_TL T
383: where T.SETUP_TASK_CODE = X_SETUP_TASK_CODE
384: and T.LANGUAGE = L.LANGUAGE_CODE AND
385: ORG_ID=X_ORG_ID);
386: END IF;

Line 396: delete from CN_CW_SETUP_TASKS_ALL_TL T

392:
393: procedure ADD_LANGUAGE
394: is
395: begin
396: delete from CN_CW_SETUP_TASKS_ALL_TL T
397: where not exists
398: (select NULL
399: from CN_CW_SETUP_TASKS_ALL_B B
400: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE

Line 404: update CN_CW_SETUP_TASKS_ALL_TL T set (

400: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE
401: and B.ORG_ID = T.ORG_ID
402: );
403:
404: update CN_CW_SETUP_TASKS_ALL_TL T set (
405: SETUP_TASK_NAME,
406: SETUP_TASK_DESCRIPTION
407: ) = (select
408: B.SETUP_TASK_NAME,

Line 410: from CN_CW_SETUP_TASKS_ALL_TL B

406: SETUP_TASK_DESCRIPTION
407: ) = (select
408: B.SETUP_TASK_NAME,
409: B.SETUP_TASK_DESCRIPTION
410: from CN_CW_SETUP_TASKS_ALL_TL B
411: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE
412: and ORG_ID = T.ORG_ID
413: and B.LANGUAGE = T.SOURCE_LANG)
414: where (

Line 422: from CN_CW_SETUP_TASKS_ALL_TL SUBB, CN_CW_SETUP_TASKS_ALL_TL SUBT

418: ) in (select
419: SUBT.SETUP_TASK_CODE,
420: SUBT.ORG_ID,
421: SUBT.LANGUAGE
422: from CN_CW_SETUP_TASKS_ALL_TL SUBB, CN_CW_SETUP_TASKS_ALL_TL SUBT
423: where SUBB.SETUP_TASK_CODE = SUBT.SETUP_TASK_CODE
424: and SUBB.ORG_ID = SUBT.ORG_ID
425: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
426: and (SUBB.SETUP_TASK_NAME <> SUBT.SETUP_TASK_NAME

Line 430: insert into CN_CW_SETUP_TASKS_ALL_TL (

426: and (SUBB.SETUP_TASK_NAME <> SUBT.SETUP_TASK_NAME
427: or SUBB.SETUP_TASK_DESCRIPTION <> SUBT.SETUP_TASK_DESCRIPTION
428: ));
429:
430: insert into CN_CW_SETUP_TASKS_ALL_TL (
431: SETUP_TASK_CODE,
432: SETUP_TASK_NAME,
433: SETUP_TASK_DESCRIPTION,
434: LAST_UPDATE_DATE,

Line 454: from CN_CW_SETUP_TASKS_ALL_TL B, FND_LANGUAGES L

450: B.CREATION_DATE,
451: L.LANGUAGE_CODE,
452: B.SOURCE_LANG,
453: B.ORG_ID
454: from CN_CW_SETUP_TASKS_ALL_TL B, FND_LANGUAGES L
455: where L.INSTALLED_FLAG in ('I', 'B')
456: and B.LANGUAGE = userenv('LANG')
457: and not exists
458: (select NULL

Line 459: from CN_CW_SETUP_TASKS_ALL_TL T

455: where L.INSTALLED_FLAG in ('I', 'B')
456: and B.LANGUAGE = userenv('LANG')
457: and not exists
458: (select NULL
459: from CN_CW_SETUP_TASKS_ALL_TL T
460: where T.SETUP_TASK_CODE = B.SETUP_TASK_CODE
461: and T.ORG_ID = B.ORG_ID
462: and T.LANGUAGE = L.LANGUAGE_CODE);
463: end ADD_LANGUAGE;