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.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on WF_NOTIFICATIONS

Line 9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');

5: /*** Globals for notification attributes ***/
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATION_ATTR');
8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';
12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
13: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTRIBUTES';

Line 12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';

8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';
12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
13: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTRIBUTES';
14: g_table_name2 CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
16: g_pk2_name CONSTANT VARCHAR2(30) := 'NAME';

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

10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';
12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
13: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTRIBUTES';
14: g_table_name2 CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
16: g_pk2_name CONSTANT VARCHAR2(30) := 'NAME';
17: g_debug_level NUMBER;
18:

Line 34: , wf_notifications wno

30: )
31: IS
32: SELECT user_id
33: FROM fnd_user usr
34: , wf_notifications wno
35: , wf_notification_attributes wna
36: WHERE usr.user_name = wna.text_value
37: AND wna.notification_id = wno.notification_id
38: AND wna.notification_id = b_notification_id

Line 53: , wf_notifications wfn

49: )
50: IS
51: SELECT user_id
52: FROM fnd_user usr
53: , wf_notifications wfn
54: WHERE wfn.recipient_role = usr.user_name
55: AND wfn.MESSAGE_TYPE = 'CS_MSGS'
56: AND wfn.MESSAGE_NAME = 'FYI_MESSAGE'
57: AND wfn.STATUS = 'OPEN'

Line 89: FROM JTM_WF_NOTIFICATIONS_ACC

85:
86: CURSOR c_notification_exists( b_notification_id NUMBER ) IS
87: SELECT access_id
88: , resource_id
89: FROM JTM_WF_NOTIFICATIONS_ACC
90: WHERE NOTIFICATION_ID = b_notification_id;
91:
92: r_notification_exists c_notification_exists%ROWTYPE;
93:

Line 204: CSL_WF_NOTIFICATIONS_ACC_PKG.INSERT_NOTIFICATION( p_notification_id );

200: OPEN c_notification_exists( p_notification_id );
201: FETCH c_notification_exists INTO r_notification_exists;
202: IF c_notification_exists%NOTFOUND THEN
203: /*** Notification id is not in ACC table yet: Insert ***/
204: CSL_WF_NOTIFICATIONS_ACC_PKG.INSERT_NOTIFICATION( p_notification_id );
205: END IF;
206: CLOSE c_notification_exists;
207: END IF;
208:

Line 359: FROM WF_NOTIFICATIONS WNO,

355: IS
356:
357: CURSOR c_notification_sender (b_resource_id NUMBER) IS
358: SELECT DISTINCT WNO.NOTIFICATION_ID
359: FROM WF_NOTIFICATIONS WNO,
360: WF_NOTIFICATION_ATTRIBUTES WNA,
361: FND_USER USR,
362: ASG_USER ADU
363: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 375: FROM WF_NOTIFICATIONS WNO,

371: r_notification_sender c_notification_sender%ROWTYPE;
372:
373: CURSOR c_notification_receive (b_resource_id NUMBER) IS
374: SELECT DISTINCT WNO.NOTIFICATION_ID
375: FROM WF_NOTIFICATIONS WNO,
376: FND_USER USR,
377: ASG_USER ADU
378: WHERE WNO.RECIPIENT_ROLE = USR.USER_NAME
379: AND USR.USER_ID = ADU.USER_ID

Line 449: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_sender.notification_id);

445: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
446: END IF;
447: ELSE
448: WHILE c_notification_sender%FOUND LOOP
449: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_sender.notification_id);
450: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
451: FETCH c_get_attribute_name INTO r_get_attribute_name;
452: IF c_get_attribute_name%NOTFOUND THEN
453: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 486: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_receive.notification_id);

482: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
483: END IF;
484: ELSE
485: WHILE c_notification_receive%FOUND LOOP
486: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_receive.notification_id);
487: OPEN c_get_attribute_name ( r_notification_receive.notification_id );
488: FETCH c_get_attribute_name INTO r_get_attribute_name;
489: IF c_get_attribute_name%NOTFOUND THEN
490: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 538: FROM WF_NOTIFICATIONS WNO,

534:
535: CURSOR c_notification_sender (b_resource_id NUMBER) IS
536: SELECT DISTINCT WNO.NOTIFICATION_ID,
537: USR.USER_ID
538: FROM WF_NOTIFICATIONS WNO,
539: WF_NOTIFICATION_ATTRIBUTES WNA,
540: FND_USER USR,
541: ASG_USER ADU
542: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 552: FROM WF_NOTIFICATIONS WNO,

548:
549: CURSOR c_notification_receive (b_resource_id NUMBER) IS
550: SELECT DISTINCT WNO.NOTIFICATION_ID,
551: USR.USER_ID
552: FROM WF_NOTIFICATIONS WNO,
553: FND_USER USR,
554: ASG_USER ADU
555: WHERE WNO.RECIPIENT_ROLE = USR.USER_NAME
556: AND USR.USER_ID = ADU.USER_ID