APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_NOTIFICATIONS_ACC

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

9: -- MODIFICATION HISTORY
10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
14: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
16: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
17: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

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

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13: g_notification_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC';
14: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_notification_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTIFICATIONS_ACC_S';
16: g_notification_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
17: g_notification_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');
19:

Line 28: FROM csm_notifications_acc

24:
25: CURSOR l_csm_notifications_csr(b_notificationid IN number, p_userid IN number)
26: IS
27: SELECT 1
28: FROM csm_notifications_acc
29: WHERE notification_id = b_notificationid
30: AND user_id = p_userid;
31:
32: BEGIN

Line 85: FROM CSM_NOTIFICATIONS_ACC ACC

81: AND au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
82: AND (nvl(wfn.begin_date, sysdate) between
83: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
84: AND NOT EXISTS(SELECT 1
85: FROM CSM_NOTIFICATIONS_ACC ACC
86: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
87: AND ACC.USER_ID = AU.USER_ID);
88:
89: --12.1

Line 101: FROM CSM_NOTIFICATIONS_ACC ACC

97: AND au.enabled='Y'
98: AND (nvl(wfn.begin_date, sysdate) between
99: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
100: AND NOT EXISTS(SELECT 1
101: FROM CSM_NOTIFICATIONS_ACC ACC
102: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
103: AND ACC.USER_ID = AU.USER_ID);
104:
105: BEGIN

Line 147: FROM CSM_NOTIFICATIONS_ACC ACC

143: AND au.enabled='Y'
144: AND (nvl(wfn.begin_date, sysdate) between
145: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
146: AND NOT EXISTS(SELECT 1
147: FROM CSM_NOTIFICATIONS_ACC ACC
148: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
149: AND ACC.USER_ID = AU.USER_ID);
150:
151: --12.1

Line 163: FROM CSM_NOTIFICATIONS_ACC ACC

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

Line 256: FROM CSM_NOTIFICATIONS_ACC acc

252:
253: -- get sender/recipient for this notification
254: CURSOR c_users(b_nid NUMBER) IS
255: SELECT acc.user_id
256: FROM CSM_NOTIFICATIONS_ACC acc
257: WHERE acc.NOTIFICATION_ID=b_nid;
258:
259:
260: BEGIN

Line 305: SELECT /*+ INDEX(acc CSM_NOTIFICATIONS_ACC_U1) */

301: l_last_run_date DATE;
302:
303: CURSOR l_purge_notifications_csr
304: IS
305: SELECT /*+ INDEX(acc CSM_NOTIFICATIONS_ACC_U1) */
306: acc.user_id,
307: acc.notification_id
308: FROM csm_notifications_acc acc,
309: wf_notifications wfn

Line 308: FROM csm_notifications_acc acc,

304: IS
305: SELECT /*+ INDEX(acc CSM_NOTIFICATIONS_ACC_U1) */
306: acc.user_id,
307: acc.notification_id
308: FROM csm_notifications_acc acc,
309: wf_notifications wfn
310: WHERE acc.notification_id = wfn.notification_id
311: AND (NVL(wfn.begin_date, SYSDATE)
312: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)));