DBA Data[Home] [Help]

APPS.CSM_NEW_MESSAGES_EVENT_PKG dependencies on CSM_NEW_MESSAGES_TL

Line 5: g_new_msg_tl_tab_name CONSTANT VARCHAR2(30) := 'CSM_NEW_MESSAGES_TL';

1: PACKAGE BODY CSM_NEW_MESSAGES_EVENT_PKG AS
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:

Line 243: CSM_NEW_MESSAGES_TL CNMT

239: CNMT.DESCRIPTION,
240: CNMA.USER_ID,
241: CNMA.ACCESS_ID
242: FROM CSM_NEW_MESSAGES_ACC CNMA,
243: CSM_NEW_MESSAGES_TL CNMT
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

Line 316: CSM_NEW_MESSAGES_TL CNMT,

312: CNMT.DESCRIPTION,
313: AU.USER_ID,
314: 1 ACCESS_ID
315: FROM CSM_NEW_MESSAGES CNM,
316: CSM_NEW_MESSAGES_TL CNMT,
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

Line 345: LANGUAGE CSM_NEW_MESSAGES_TL.LANGUAGE%TYPE,

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,
349: ACCESS_ID CSM_NEW_MESSAGES_ACC.ACCESS_ID%TYPE

Line 346: MESSAGE_TEXT CSM_NEW_MESSAGES_TL.MESSAGE_TEXT%TYPE,

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,
349: ACCESS_ID CSM_NEW_MESSAGES_ACC.ACCESS_ID%TYPE
350: );

Line 347: DESCRIPTION CSM_NEW_MESSAGES_TL.DESCRIPTION%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,
349: ACCESS_ID CSM_NEW_MESSAGES_ACC.ACCESS_ID%TYPE
350: );
351:

Line 389: FROM CSM_NEW_MESSAGES_TL;

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;
390: IF(l_max_update_date > l_lastrundate.last_run_date) THEN
391: l_checkupdates := 'Y';
392: END IF;
393: ELSE

Line 561: CSM_NEW_MESSAGES_TL CNMT,

557: CNMT.DESCRIPTION,
558: AU.USER_ID,
559: 1 ACCESS_ID
560: FROM CSM_NEW_MESSAGES CNM,
561: CSM_NEW_MESSAGES_TL CNMT,
562: ASG_USER AU
563: WHERE AU.USER_ID= b_user_id
564: AND AU.USER_ID=AU.OWNER_ID
565: AND CNM.MESSAGE_ID = CNMT.MESSAGE_ID

Line 587: LANGUAGE CSM_NEW_MESSAGES_TL.LANGUAGE%TYPE,

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,
591: ACCESS_ID CSM_NEW_MESSAGES_ACC.ACCESS_ID%TYPE

Line 588: MESSAGE_TEXT CSM_NEW_MESSAGES_TL.MESSAGE_TEXT%TYPE,

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,
591: ACCESS_ID CSM_NEW_MESSAGES_ACC.ACCESS_ID%TYPE
592: );

Line 589: DESCRIPTION CSM_NEW_MESSAGES_TL.DESCRIPTION%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,
591: ACCESS_ID CSM_NEW_MESSAGES_ACC.ACCESS_ID%TYPE
592: );
593: