APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on WF_NOTIFICATIONS

Line 14: g_notification_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';

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 :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_MAIL_MESSAGES', 'CSF_M_MAIL_RECIPIENTS');

Line 46: PROCEDURE INSERT_NOTIFICATIONS_ACC (p_notification_id wf_notifications.notification_id%TYPE,

42:
43: END check_if_notification_exists;
44:
45: --Bug 5337816
46: PROCEDURE INSERT_NOTIFICATIONS_ACC (p_notification_id wf_notifications.notification_id%TYPE,
47: p_user_id fnd_user.user_id%TYPE)
48: IS
49: l_sysdate DATE;
50: l_count NUMBER;

Line 78: FROM wf_notifications wfn,

74:
75: -- get all notifications in which user is a recipient
76: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
77: SELECT DISTINCT wfn.notification_id
78: FROM wf_notifications wfn,
79: asg_user au
80: WHERE au.user_id=b_user_id
81: AND au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
82: AND (nvl(wfn.begin_date, sysdate) between

Line 92: FROM WF_NOTIFICATIONS wfn,

88:
89: --12.1
90: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS
91: SELECT DISTINCT wfn.notification_id
92: FROM WF_NOTIFICATIONS wfn,
93: ASG_USER au
94: WHERE au.user_id=b_user_id
95: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
96: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))

Line 139: FROM WF_NOTIFICATIONS wfn,

135: PROCEDURE DOWNLOAD_NOTIFICATION(p_notification_id IN NUMBER ,x_return_status OUT NOCOPY VARCHAR2)
136: IS
137: CURSOR c_users(b_nid NUMBER) IS
138: SELECT DISTINCT au.user_id
139: FROM WF_NOTIFICATIONS wfn,
140: ASG_USER au
141: WHERE wfn.NOTIFICATION_ID=b_nid
142: AND au.user_name IN (WFN.FROM_ROLE,WFN.RECIPIENT_ROLE)
143: AND au.enabled='Y'

Line 154: FROM WF_NOTIFICATIONS wfn,

150:
151: --12.1
152: CURSOR c_broadcast_users(b_nid NUMBER) IS
153: SELECT DISTINCT au.user_id
154: FROM WF_NOTIFICATIONS wfn,
155: ASG_USER au
156: WHERE wfn.NOTIFICATION_ID=b_nid
157: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
158: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))

Line 215: l_notification_id wf_notifications.notification_id%TYPE;

211: l_sqlerrmsg VARCHAR2(4000);
212: l_error_msg VARCHAR2(4000);
213: l_return_status VARCHAR2(80);
214:
215: l_notification_id wf_notifications.notification_id%TYPE;
216: BEGIN
217: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_ATTR_WF_EVENT_SUB',
218: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
219:

Line 251: l_notification_id wf_notifications.notification_id%TYPE;

247: l_sqlerrmsg VARCHAR2(4000);
248: l_error_msg VARCHAR2(4000);
249: l_return_status VARCHAR2(2000);
250:
251: l_notification_id wf_notifications.notification_id%TYPE;
252:
253: -- get sender/recipient for this notification
254: CURSOR c_users(b_nid NUMBER) IS
255: SELECT acc.user_id

Line 309: wf_notifications wfn

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)));
313: