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.CSM_NEW_MESSAGES_EVENT_PKG dependencies on CSM_NEW_MESSAGES_PERZ

Line 6: g_new_msg_perz_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_PERZ';

2: /* $Header: csmenmgb.pls 120.13.12010000.2 2008/10/22 12:43:56 trajasek ship $ */
3: /*** Globals ***/
4: g_new_msg_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_ACC';
5: g_new_msg_tl_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_TL';
6: g_new_msg_perz_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_PERZ';
7: g_new_msg_table_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES';
8: g_new_msg_pubi_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES';
9:
10: g_new_msg_pkg_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_EVENT_PKG';

Line 25: FROM CSM_NEW_MESSAGES_PERZ CNMP

21: FROM CSM_NEW_MESSAGES_ACC CNMA
22: WHERE CNMA.LEVEL_ID=10001
23: AND CNMA.LEVEL_VALUE=0
24: AND NOT EXISTS (SELECT 1
25: FROM CSM_NEW_MESSAGES_PERZ CNMP
26: WHERE CNMP.MESSAGE_ID = CNMA.MESSAGE_ID
27: AND CNMP.LANGUAGE=CNMA.LANGUAGE
28: AND CNMP.LEVEL_ID=10001 )
29: UNION ALL

Line 36: FROM CSM_NEW_MESSAGES_PERZ CNMP,ASG_USER AU

32: CNMA.USER_ID
33: FROM CSM_NEW_MESSAGES_ACC CNMA
34: WHERE CNMA.LEVEL_ID=10003
35: AND NOT EXISTS (SELECT 1
36: FROM CSM_NEW_MESSAGES_PERZ CNMP,ASG_USER AU
37: WHERE CNMP.MESSAGE_ID = CNMA.MESSAGE_ID
38: AND CNMP.LANGUAGE=CNMA.LANGUAGE
39: AND CNMP.LEVEL_ID=10003
40: AND CNMA.USER_ID=AU.USER_ID

Line 50: FROM CSM_NEW_MESSAGES_PERZ CNMP

46: FROM CSM_NEW_MESSAGES_ACC CNMA
47: WHERE CNMA.LEVEL_ID=10004
48: AND
49: NOT EXISTS (SELECT 1
50: FROM CSM_NEW_MESSAGES_PERZ CNMP
51: WHERE CNMP.MESSAGE_ID = CNMA.MESSAGE_ID
52: AND CNMP.LANGUAGE=CNMA.LANGUAGE
53: AND CNMP.LEVEL_ID=10004
54: AND CNMA.USER_ID=CNMP.LEVEL_VALUE)

Line 62: FROM CSM_NEW_MESSAGES_PERZ CNMP,ASG_USER AU

58: CNMA.USER_ID
59: FROM CSM_NEW_MESSAGES_ACC CNMA
60: WHERE CNMA.LEVEL_ID=0
61: AND EXISTS (SELECT 1
62: FROM CSM_NEW_MESSAGES_PERZ CNMP,ASG_USER AU
63: WHERE CNMP.MESSAGE_ID = CNMA.MESSAGE_ID
64: AND CNMA.USER_ID = AU.USER_ID
65: AND (
66: (CNMP.LEVEL_ID=10001

Line 85: FROM CSM_NEW_MESSAGES_PERZ CNMP,

81: FROM CSM_NEW_MESSAGES_ACC CNMA
82: WHERE CNMA.LEVEL_ID = 10001
83: AND CNMA.LEVEL_VALUE = 0
84: AND EXISTS (SELECT 1
85: FROM CSM_NEW_MESSAGES_PERZ CNMP,
86: ASG_USER AU
87: WHERE CNMP.MESSAGE_ID=CNMA.MESSAGE_ID
88: AND CNMP.LANGUAGE = CNMA.LANGUAGE
89: AND CNMA.USER_ID = AU.USER_ID

Line 103: FROM CSM_NEW_MESSAGES_PERZ CNMP,

99: CNMA.USER_ID
100: FROM CSM_NEW_MESSAGES_ACC CNMA
101: WHERE CNMA.LEVEL_ID = 10003
102: AND EXISTS (SELECT 1
103: FROM CSM_NEW_MESSAGES_PERZ CNMP,
104: ASG_USER AU
105: WHERE CNMP.MESSAGE_ID=CNMA.MESSAGE_ID
106: AND CNMP.LANGUAGE = CNMA.LANGUAGE
107: AND CNMA.USER_ID = AU.USER_ID

Line 227: CSM_NEW_MESSAGES_PERZ CNMP

223: CNMP.DESCRIPTION,
224: CNMA.USER_ID,
225: CNMA.ACCESS_ID
226: FROM CSM_NEW_MESSAGES_ACC CNMA,
227: CSM_NEW_MESSAGES_PERZ CNMP
228: WHERE CNMA.MESSAGE_ID=CNMP.MESSAGE_ID
229: AND (CNMP.LEVEL_ID = CNMA.LEVEL_ID
230: AND CNMP.LEVEL_VALUE= CNMA.LEVEL_VALUE
231: AND CNMP.LANGUAGE = CNMA.LANGUAGE

Line 248: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP,ASG_USER AU

244: WHERE CNMT.MESSAGE_ID = CNMA.MESSAGE_ID
245: AND CNMT.LANGUAGE = CNMA.LANGUAGE
246: AND CNMT.LAST_UPDATE_DATE>b_lastrundate
247: AND CNMA.LEVEL_ID=0 --PREVIOUSLY AND NOW ALSO NOT PERSONALIZED
248: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP,ASG_USER AU
249: WHERE CNMA.MESSAGE_ID=CNMP.MESSAGE_ID
250: AND AU.USER_ID=AU.OWNER_ID
251: AND ( CNMP.LEVEL_ID=10001
252: OR ---IF SITE-LEVEL PERZ IS THERE THEN DON'T UPDATE ANY REC WITH TL-TABLE

Line 274: CSM_NEW_MESSAGES_PERZ CNMP,

270: CNMP.DESCRIPTION,
271: AU.USER_ID,
272: 1 ACCESS_ID
273: FROM CSM_NEW_MESSAGES CNM,
274: CSM_NEW_MESSAGES_PERZ CNMP,
275: ASG_USER AU
276: WHERE CNM.MESSAGE_ID=CNMP.MESSAGE_ID
277: AND CNMP.LANGUAGE =AU.LANGUAGE
278: AND AU.USER_ID=AU.OWNER_ID

Line 284: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1

280: AND CNMP.LEVEL_ID = 10004)
281: OR
282: (CNMP.LEVEL_VALUE = AU.RESPONSIBILITY_ID
283: AND CNMP.LEVEL_ID = 10003
284: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1
285: WHERE AU.USER_ID = CNMP1.LEVEL_VALUE AND CNMP1.LEVEL_ID = 10004))
286: OR
287: (CNMP.LEVEL_VALUE=0
288: AND CNMP.LEVEL_ID = 10001

Line 289: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1

285: WHERE AU.USER_ID = CNMP1.LEVEL_VALUE AND CNMP1.LEVEL_ID = 10004))
286: OR
287: (CNMP.LEVEL_VALUE=0
288: AND CNMP.LEVEL_ID = 10001
289: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1
290: WHERE CNMP.MESSAGE_ID=CNMP1.MESSAGE_ID
291: AND CNMP.LANGUAGE=CNMP1.LANGUAGE
292: AND AU.RESPONSIBILITY_ID = CNMP1.LEVEL_VALUE
293: AND CNMP1.LEVEL_ID = 10003)

Line 294: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1

290: WHERE CNMP.MESSAGE_ID=CNMP1.MESSAGE_ID
291: AND CNMP.LANGUAGE=CNMP1.LANGUAGE
292: AND AU.RESPONSIBILITY_ID = CNMP1.LEVEL_VALUE
293: AND CNMP1.LEVEL_ID = 10003)
294: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1
295: WHERE CNMP.MESSAGE_ID=CNMP1.MESSAGE_ID
296: AND CNMP.LANGUAGE=CNMP1.LANGUAGE
297: AND AU.USER_ID = CNMP1.LEVEL_VALUE
298: AND CNMP1.LEVEL_ID = 10004)

Line 321: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP

317: ASG_USER AU
318: WHERE CNM.MESSAGE_ID = CNMT.MESSAGE_ID
319: AND AU.USER_ID=AU.OWNER_ID
320: AND CNMT.LANGUAGE = AU.LANGUAGE
321: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP
322: WHERE CNMP.MESSAGE_ID=CNM.MESSAGE_ID
323: AND(
324: CNMP.LEVEL_ID=10001
325: OR

Line 343: LEVEL_ID CSM_NEW_MESSAGES_PERZ.LEVEL_ID%TYPE,

339:
340: TYPE con_rec_type IS RECORD
341: (
342: MESSAGE_ID CSM_NEW_MESSAGES.MESSAGE_ID%TYPE,
343: LEVEL_ID CSM_NEW_MESSAGES_PERZ.LEVEL_ID%TYPE,
344: LEVEL_VALUE CSM_NEW_MESSAGES_PERZ.LEVEL_VALUE%TYPE,
345: LANGUAGE CSM_NEW_MESSAGES_TL.LANGUAGE%TYPE,
346: MESSAGE_TEXT CSM_NEW_MESSAGES_TL.MESSAGE_TEXT%TYPE,
347: DESCRIPTION CSM_NEW_MESSAGES_TL.DESCRIPTION%TYPE,

Line 344: LEVEL_VALUE CSM_NEW_MESSAGES_PERZ.LEVEL_VALUE%TYPE,

340: TYPE con_rec_type IS RECORD
341: (
342: MESSAGE_ID CSM_NEW_MESSAGES.MESSAGE_ID%TYPE,
343: LEVEL_ID CSM_NEW_MESSAGES_PERZ.LEVEL_ID%TYPE,
344: LEVEL_VALUE CSM_NEW_MESSAGES_PERZ.LEVEL_VALUE%TYPE,
345: LANGUAGE CSM_NEW_MESSAGES_TL.LANGUAGE%TYPE,
346: MESSAGE_TEXT CSM_NEW_MESSAGES_TL.MESSAGE_TEXT%TYPE,
347: DESCRIPTION CSM_NEW_MESSAGES_TL.DESCRIPTION%TYPE,
348: USER_ID ASG_USER.USER_ID%TYPE,

Line 385: FROM CSM_NEW_MESSAGES_PERZ;

381: -- Don't bother to run the update cursor unless the max(last_update_date) is > last_run_date
382: -- Will reduce buffer gets. See bug 5184173
383: -- An index will be created on last_update_date column to avoid FTS.
384: SELECT NVL(MAX(last_update_date), to_date('1', 'J')) INTO l_max_update_date
385: FROM CSM_NEW_MESSAGES_PERZ;
386: -- Find the next max_last_update_date only if the above query shows a lower last_update_date
387: IF(l_max_update_date <= l_lastrundate.last_run_date) THEN
388: SELECT NVL(MAX(last_update_date), to_date('1', 'J')) INTO l_max_update_date
389: FROM CSM_NEW_MESSAGES_TL;

Line 522: CSM_NEW_MESSAGES_PERZ CNMP,

518: CNMP.DESCRIPTION,
519: AU.USER_ID,
520: 1 ACCESS_ID
521: FROM CSM_NEW_MESSAGES CNM,
522: CSM_NEW_MESSAGES_PERZ CNMP,
523: ASG_USER AU
524: WHERE AU.USER_ID= b_user_id
525: AND AU.USER_ID=AU.OWNER_ID
526: AND CNM.MESSAGE_ID=CNMP.MESSAGE_ID

Line 533: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1

529: AND CNMP.LEVEL_ID = 10004)
530: OR
531: (CNMP.LEVEL_VALUE = AU.RESPONSIBILITY_ID
532: AND CNMP.LEVEL_ID = 10003
533: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1
534: WHERE AU.USER_ID = CNMP1.LEVEL_VALUE AND CNMP1.LEVEL_ID = 10004))
535: OR
536: (CNMP.LEVEL_VALUE=0
537: AND CNMP.LEVEL_ID = 10001

Line 538: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1

534: WHERE AU.USER_ID = CNMP1.LEVEL_VALUE AND CNMP1.LEVEL_ID = 10004))
535: OR
536: (CNMP.LEVEL_VALUE=0
537: AND CNMP.LEVEL_ID = 10001
538: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1
539: WHERE CNMP.MESSAGE_ID=CNMP1.MESSAGE_ID
540: AND CNMP.LANGUAGE=CNMP1.LANGUAGE
541: AND AU.RESPONSIBILITY_ID = CNMP1.LEVEL_VALUE
542: AND CNMP1.LEVEL_ID = 10003)

Line 543: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1

539: WHERE CNMP.MESSAGE_ID=CNMP1.MESSAGE_ID
540: AND CNMP.LANGUAGE=CNMP1.LANGUAGE
541: AND AU.RESPONSIBILITY_ID = CNMP1.LEVEL_VALUE
542: AND CNMP1.LEVEL_ID = 10003)
543: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP1
544: WHERE CNMP.MESSAGE_ID=CNMP1.MESSAGE_ID
545: AND CNMP.LANGUAGE=CNMP1.LANGUAGE
546: AND AU.USER_ID = CNMP1.LEVEL_VALUE
547: AND CNMP1.LEVEL_ID = 10004)

Line 567: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP

563: WHERE AU.USER_ID= b_user_id
564: AND AU.USER_ID=AU.OWNER_ID
565: AND CNM.MESSAGE_ID = CNMT.MESSAGE_ID
566: AND CNMT.LANGUAGE = AU.LANGUAGE
567: AND NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES_PERZ CNMP
568: WHERE CNMP.MESSAGE_ID=CNM.MESSAGE_ID
569: AND(
570: CNMP.LEVEL_ID=10001
571: OR

Line 585: LEVEL_ID CSM_NEW_MESSAGES_PERZ.LEVEL_ID%TYPE,

581:
582: TYPE con_rec_type IS RECORD
583: (
584: MESSAGE_ID CSM_NEW_MESSAGES.MESSAGE_ID%TYPE,
585: LEVEL_ID CSM_NEW_MESSAGES_PERZ.LEVEL_ID%TYPE,
586: LEVEL_VALUE CSM_NEW_MESSAGES_PERZ.LEVEL_VALUE%TYPE,
587: LANGUAGE CSM_NEW_MESSAGES_TL.LANGUAGE%TYPE,
588: MESSAGE_TEXT CSM_NEW_MESSAGES_TL.MESSAGE_TEXT%TYPE,
589: DESCRIPTION CSM_NEW_MESSAGES_TL.DESCRIPTION%TYPE,

Line 586: LEVEL_VALUE CSM_NEW_MESSAGES_PERZ.LEVEL_VALUE%TYPE,

582: TYPE con_rec_type IS RECORD
583: (
584: MESSAGE_ID CSM_NEW_MESSAGES.MESSAGE_ID%TYPE,
585: LEVEL_ID CSM_NEW_MESSAGES_PERZ.LEVEL_ID%TYPE,
586: LEVEL_VALUE CSM_NEW_MESSAGES_PERZ.LEVEL_VALUE%TYPE,
587: LANGUAGE CSM_NEW_MESSAGES_TL.LANGUAGE%TYPE,
588: MESSAGE_TEXT CSM_NEW_MESSAGES_TL.MESSAGE_TEXT%TYPE,
589: DESCRIPTION CSM_NEW_MESSAGES_TL.DESCRIPTION%TYPE,
590: USER_ID ASG_USER.USER_ID%TYPE,