APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_NOTIFICATIONS_ACC

Line 4: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';

1: PACKAGE BODY CSM_NOTIFICATION_EVENT_PKG AS
2: /* $Header: csmentfb.pls 120.31.12020000.3 2013/04/09 10:57:22 saradhak ship $ */
3:
4: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
5: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
6: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
7: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
8: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 6: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';

2: /* $Header: csmentfb.pls 120.31.12020000.3 2013/04/09 10:57:22 saradhak ship $ */
3:
4: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
5: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
6: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
7: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
8: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
10: g_switch_optimize_off BOOLEAN:=TRUE;

Line 48: AND NOT EXISTS(SELECT 1 FROM CSM_NOTIFICATIONS_ACC ACC

44: AND au.enabled='Y' and au.multi_platform='Y'
45: AND wfn.STATUS='OPEN'
46: AND wfn.MESSAGE_TYPE='CSM_MSGS'
47: AND nvl(wfn.begin_date, sysdate) >= l_upd_date
48: AND NOT EXISTS(SELECT 1 FROM CSM_NOTIFICATIONS_ACC ACC
49: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
50: AND ACC.USER_ID = AU.USER_ID))
51: LOOP
52: INSERT_NOTIFICATIONS_ACC (l_notf_rec.notification_id, l_notf_rec.user_id);

Line 85: FROM csm_notifications_acc

81:
82: CURSOR l_csm_notifications_csr(b_notificationid IN number, p_userid IN number)
83: IS
84: SELECT 1
85: FROM csm_notifications_acc
86: WHERE notification_id = b_notificationid
87: AND user_id = p_userid;
88:
89: BEGIN

Line 144: FROM CSM_NOTIFICATIONS_ACC ACC

140: AND wfn.MESSAGE_TYPE='CSM_MSGS'
141: AND (nvl(wfn.begin_date, sysdate) between
142: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
143: AND NOT EXISTS(SELECT 1
144: FROM CSM_NOTIFICATIONS_ACC ACC
145: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
146: AND ACC.USER_ID = AU.USER_ID);
147:
148: --12.1

Line 162: FROM CSM_NOTIFICATIONS_ACC ACC

158: AND au.enabled='Y'
159: AND (nvl(wfn.begin_date, sysdate) between
160: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
161: AND NOT EXISTS(SELECT 1
162: FROM CSM_NOTIFICATIONS_ACC ACC
163: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
164: AND ACC.USER_ID = AU.USER_ID);
165:
166: BEGIN

Line 210: FROM CSM_NOTIFICATIONS_ACC ACC

206: AND au.enabled='Y'
207: AND (nvl(wfn.begin_date, sysdate) between
208: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
209: AND NOT EXISTS(SELECT 1
210: FROM CSM_NOTIFICATIONS_ACC ACC
211: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
212: AND ACC.USER_ID = AU.USER_ID);
213:
214: --12.1

Line 228: FROM CSM_NOTIFICATIONS_ACC ACC

224: AND au.enabled='Y'
225: AND (nvl(wfn.begin_date, sysdate) between
226: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
227: AND NOT EXISTS(SELECT 1
228: FROM CSM_NOTIFICATIONS_ACC ACC
229: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
230: AND ACC.USER_ID = AU.USER_ID);
231:
232: l_sqlerrno VARCHAR2(20);

Line 323: FROM CSM_NOTIFICATIONS_ACC acc

319:
320: -- get sender/recipient for this notification
321: CURSOR c_users(b_nid NUMBER) IS
322: SELECT acc.user_id
323: FROM CSM_NOTIFICATIONS_ACC acc
324: WHERE acc.NOTIFICATION_ID=b_nid;
325:
326:
327: BEGIN

Line 394: FROM csm_notifications_acc acc,wf_notifications wfn

390: BEGIN
391: l_last_run_date := SYSDATE;
392:
393: FOR rec IN ( SELECT acc.user_id,acc.notification_id,wfn.status
394: FROM csm_notifications_acc acc,wf_notifications wfn
395: WHERE acc.notification_id = wfn.notification_id
396: AND (
397: (wfn.RECIPIENT_ROLE NOT LIKE 'JRES_GRP:%')
398: OR