APPS.WF_ADVANCED_WORKLIST dependencies on WF_NOTIFICATION

Line 32: from WF_NOTIFICATIONS WN

28: -- Get recipient and original recipient of this notification
29: begin
30: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
31: into recipient, orig_recipient, from_role, more_info_role
32: from WF_NOTIFICATIONS WN
33: where WN.NOTIFICATION_ID = nid;
34: exception
35: when no_data_found then
36: Wf_Core.Token('NID', nid);

Line 58: wf_notifications ntf

54: from sys.dual
55: where exists ( select null
56: from wf_item_activity_statuses ias,
57: wf_item_activity_statuses_h iash,
58: wf_notifications ntf
59: where ntf.status = 'OPEN'
60: and ias.notification_id = ntf.notification_id
61: and ias.item_type = iash.item_type
62: and ias.item_key = iash.item_key

Line 65: from wf_notifications

61: and ias.item_type = iash.item_type
62: and ias.item_key = iash.item_key
63: and ias.process_activity = iash.process_activity
64: and iash.notification_id in (select notification_id
65: from wf_notifications
66: where status in ('CLOSED','CANCELED','INVALID')
67: and from_role = username)
68: and ntf.notification_id = nid
69: );

Line 93: wf_notification.Denormalize_Notification(nid => p_nid, langcode => p_langcode );

89: p_touser out nocopy varchar2,
90: p_fromuser out nocopy varchar2)
91: is
92: begin
93: wf_notification.Denormalize_Notification(nid => p_nid, langcode => p_langcode );
94: select DECODE(MORE_INFO_ROLE, NULL, SUBJECT, FND_MESSAGE.GET_STRING('FND','FND_MORE_INFO_REQUESTED')||' '||SUBJECT) AS subject, to_user, from_user
95: into p_subject, p_touser, p_fromuser
96: from wf_notifications
97: where notification_id = p_nid;

Line 96: from wf_notifications

92: begin
93: wf_notification.Denormalize_Notification(nid => p_nid, langcode => p_langcode );
94: select DECODE(MORE_INFO_ROLE, NULL, SUBJECT, FND_MESSAGE.GET_STRING('FND','FND_MORE_INFO_REQUESTED')||' '||SUBJECT) AS subject, to_user, from_user
95: into p_subject, p_touser, p_fromuser
96: from wf_notifications
97: where notification_id = p_nid;
98: exception
99: when OTHERS then
100: wf_core.context('Wf_Notification', 'getInfoAfterDenorm', p_nid);

Line 100: wf_core.context('Wf_Notification', 'getInfoAfterDenorm', p_nid);

96: from wf_notifications
97: where notification_id = p_nid;
98: exception
99: when OTHERS then
100: wf_core.context('Wf_Notification', 'getInfoAfterDenorm', p_nid);
101: raise;
102: end getInfoAfterDenorm;
103:
104: --

Line 144: FROM wf_notifications wn,

140: FROM dual
141: WHERE username IN
142: (
143: SELECT fg.grantee_key
144: FROM wf_notifications wn,
145: wf_user_roles wur,
146: fnd_grants fg
147: WHERE ((wn.more_info_role IS NOT NULL AND wur.role_name = wn.more_info_role)
148: OR wur.role_name = wn.recipient_role)