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_NOTIFICATION_EVENT_PKG dependencies on WF_NOTIFICATION

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

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

Line 42: FROM wf_notifications wfn,asg_user au

38: CSM_UTIL_PKG.LOG('Entered DOWNLOAD_MULTIPLAT_NFN', 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);
39: -- set the program update date in jtm_con_request_data to sysdate
40:
41: FOR l_notf_rec IN ( SELECT DISTINCT wfn.notification_id ,au.USER_ID
42: FROM wf_notifications wfn,asg_user au
43: WHERE au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
44: AND au.enabled='Y' and au.multi_platform='Y'
45: AND wfn.STATUS='OPEN'
46: AND wfn.MESSAGE_TYPE='CSM_MSGS'

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

99:
100: END check_if_notification_exists;
101:
102: --Bug 5337816
103: PROCEDURE INSERT_NOTIFICATIONS_ACC (p_notification_id wf_notifications.notification_id%TYPE,
104: p_user_id fnd_user.user_id%TYPE)
105: IS
106: l_sysdate DATE;
107: l_count NUMBER;

Line 135: FROM wf_notifications wfn,

131:
132: -- get all notifications in which user is a recipient
133: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
134: SELECT DISTINCT wfn.notification_id
135: FROM wf_notifications wfn,
136: asg_user au
137: WHERE au.user_id=b_user_id
138: AND au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
139: AND wfn.STATUS='OPEN'

Line 151: FROM WF_NOTIFICATIONS wfn,

147:
148: --12.1
149: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS
150: SELECT DISTINCT wfn.notification_id
151: FROM WF_NOTIFICATIONS wfn,
152: ASG_USER au
153: WHERE au.user_id=b_user_id
154: AND wfn.STATUS='OPEN'
155: AND wfn.MESSAGE_TYPE='CSM_MSGS'

Line 200: FROM WF_NOTIFICATIONS wfn,

196: PROCEDURE DOWNLOAD_NOTIFICATION(p_notification_id IN NUMBER ,x_return_status OUT NOCOPY VARCHAR2)
197: IS
198: CURSOR c_users(b_nid NUMBER) IS
199: SELECT DISTINCT au.user_id
200: FROM WF_NOTIFICATIONS wfn,
201: ASG_USER au
202: WHERE wfn.NOTIFICATION_ID=b_nid
203: AND wfn.STATUS='OPEN'
204: AND wfn.MESSAGE_TYPE='CSM_MSGS'

Line 217: FROM WF_NOTIFICATIONS wfn,

213:
214: --12.1
215: CURSOR c_broadcast_users(b_nid NUMBER) IS
216: SELECT DISTINCT au.user_id
217: FROM WF_NOTIFICATIONS wfn,
218: ASG_USER au
219: WHERE wfn.NOTIFICATION_ID=b_nid
220: AND wfn.STATUS='OPEN'
221: AND wfn.MESSAGE_TYPE='CSM_MSGS'

Line 281: l_notification_id wf_notifications.notification_id%TYPE;

277: l_sqlerrmsg VARCHAR2(4000);
278: l_error_msg VARCHAR2(4000);
279: l_return_status VARCHAR2(80);
280:
281: l_notification_id wf_notifications.notification_id%TYPE;
282:
283: BEGIN
284: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_ATTR_WF_EVENT_SUB',
285: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

Line 318: l_notification_id wf_notifications.notification_id%TYPE;

314: l_sqlerrmsg VARCHAR2(4000);
315: l_error_msg VARCHAR2(4000);
316: l_return_status VARCHAR2(2000);
317:
318: l_notification_id wf_notifications.notification_id%TYPE;
319:
320: -- get sender/recipient for this notification
321: CURSOR c_users(b_nid NUMBER) IS
322: SELECT acc.user_id

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

Line 406: wf_notification.respond(rec.notification_id);

402: LOOP
403:
404: IF rec.status= 'OPEN' THEN
405: begin
406: wf_notification.respond(rec.notification_id);
407: exception
408: when others then
409: null;
410: end;

Line 435: These records will get purged from WF Notifications table

431: /*12.1.2 PURGE AUTO SYNC Notifications
432: Step-1 : Purge all CSM_AUTO_SYNC_NFN/CLIENT notifications that are created earlier than
433: purge interval
434: Step-2 : Close unresponded notifications that are older than purge interval
435: These records will get purged from WF Notifications table
436: after another purge interval has elapsed
437: Step-3 : Purge all WF notifications that are responded/closed
438: with end_date earlier than purge interval
439: */

Line 437: Step-3 : Purge all WF notifications that are responded/closed

433: purge interval
434: Step-2 : Close unresponded notifications that are older than purge interval
435: These records will get purged from WF Notifications table
436: after another purge interval has elapsed
437: Step-3 : Purge all WF notifications that are responded/closed
438: with end_date earlier than purge interval
439: */
440: OPEN c_purge_days;
441: FETCH c_purge_days INTO l_days;

Line 479: FOR ntf_rec IN (SELECT NOTIFICATION_ID FROM WF_NOTIFICATIONS

475:
476: COMMIT;
477:
478: --STEP-2
479: FOR ntf_rec IN (SELECT NOTIFICATION_ID FROM WF_NOTIFICATIONS
480: WHERE MESSAGE_TYPE='CSM_MSGS'
481: AND (STATUS='OPEN' OR END_DATE IS NULL)
482: AND BEGIN_DATE < SYSDATE-l_days)
483: LOOP

Line 484: wf_notification.respond(ntf_rec.NOTIFICATION_ID);

480: WHERE MESSAGE_TYPE='CSM_MSGS'
481: AND (STATUS='OPEN' OR END_DATE IS NULL)
482: AND BEGIN_DATE < SYSDATE-l_days)
483: LOOP
484: wf_notification.respond(ntf_rec.NOTIFICATION_ID);
485: END LOOP;
486:
487:
488: --STEP-3

Line 812: FROM WF_NOTIFICATIONS

808:
809: BEGIN
810: SELECT NOTIFICATION_ID
811: INTO l_nid
812: FROM WF_NOTIFICATIONS
813: WHERE MESSAGE_TYPE='CSM_MSGS'
814: AND MESSAGE_NAME=l_template
815: AND RECIPIENT_ROLE=p_recipient_role
816: AND ITEM_KEY = l_item_key;

Line 840: SELECT wf.name,wf.email_address,wf.notification_preference INTO role_name,l_wf_email ,l_pref

836: l_err_msg VARCHAR2(2000);
837: l_upd BOOLEAN:=false;
838: BEGIN
839: BEGIN
840: SELECT wf.name,wf.email_address,wf.notification_preference INTO role_name,l_wf_email ,l_pref
841: FROM WF_LOCAL_ROLES wf, ASG_USER au
842: WHERE wf.name ='CSM_'||b_user_name||'_ROLE'
843: AND au.user_name=b_user_name
844: AND au.enabled='Y';

Line 1590: select notification_id,text_value INTO l_nid,l_text_value from wf_notification_attributes

1586: IF(item_type='CSM_MSGS' and command = 'RESPOND') THEN
1587:
1588: BEGIN
1589:
1590: select notification_id,text_value INTO l_nid,l_text_value from wf_notification_attributes
1591: where notification_id = (select notification_id from wf_notifications
1592: where message_type='CSM_MSGS' and message_name='DOWNLOAD_INIT_MSG'
1593: and item_key=p_item_key) and name='RESULT';
1594:

Line 1591: where notification_id = (select notification_id from wf_notifications

1587:
1588: BEGIN
1589:
1590: select notification_id,text_value INTO l_nid,l_text_value from wf_notification_attributes
1591: where notification_id = (select notification_id from wf_notifications
1592: where message_type='CSM_MSGS' and message_name='DOWNLOAD_INIT_MSG'
1593: and item_key=p_item_key) and name='RESULT';
1594:
1595: EXCEPTION

Line 1624: FROM WF_NOTIFICATIONS

1620: l_try NUMBER;
1621: l_wftimer wf_event_t;
1622: CURSOR c_response(b_nid NUMBER) IS
1623: SELECT 1
1624: FROM WF_NOTIFICATIONS
1625: WHERE NOTIFICATION_ID=b_nid
1626: AND STATUS='CLOSED';
1627:
1628: CURSOR c_get_resp_id(b_user_name VARCHAR2) IS

Line 1680: wf_notification.forward(l_nid,l_role);

1676: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_'||l_count,
1677: asg_base.get_user_id(substr(l_role,5,length(l_role)-9)),l_resp_id,l_app_id));
1678:
1679: --try sending Email again
1680: wf_notification.forward(l_nid,l_role);
1681:
1682: UPDATE CSM_AUTO_SYNC_NFN
1683: SET REMINDERS_SENT = REMINDERS_SENT + 1
1684: WHERE NOTIFICATION_ID=l_nid;

Line 2164: for rec in (select nfn.notification_id from csm_auto_sync_nfn nfn, wf_notifications wfn

2160: delete from csm_deferred_transactions_acc where user_id=p_user_id;
2161:
2162: delete from csm_deferred_nfn_info where client_id=csm_util_pkg.get_user_name(p_user_id);
2163:
2164: for rec in (select nfn.notification_id from csm_auto_sync_nfn nfn, wf_notifications wfn
2165: where nfn.user_id=p_user_id and nfn.notification_id = wfn.notification_id
2166: and wfn.status='OPEN')
2167: loop
2168: wf_notification.respond(rec.notification_id);

Line 2168: wf_notification.respond(rec.notification_id);

2164: for rec in (select nfn.notification_id from csm_auto_sync_nfn nfn, wf_notifications wfn
2165: where nfn.user_id=p_user_id and nfn.notification_id = wfn.notification_id
2166: and wfn.status='OPEN')
2167: loop
2168: wf_notification.respond(rec.notification_id);
2169: end loop;
2170:
2171: DELETE FROM csm_client_nfn_log cl
2172: WHERE EXISTS (SELECT 1 FROM csm_auto_sync_nfn b WHERE b.NOTIFICATION_ID=cl.NOTIFICATION_ID and user_id=p_user_id);