25: dummy pls_integer;
26: admin_role varchar2(2000);
27: begin
28: if (nkey is null) then
29: admin_role := wf_core.translate('WF_ADMIN_ROLE');
30: -- Get recipient and original recipient of this notification
31: begin
32: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
33: into recipient, orig_recipient, from_role, more_info_role
34: from WF_NOTIFICATIONS WN
35: where WN.NOTIFICATION_ID = nid;
36: exception
37: when no_data_found then
38: Wf_Core.Token('NID', nid);
39: Wf_Core.Raise('WFNTF_NID');
40: end;
41:
42: --first check whether the user is intended recipient or from role or more info role
35: where WN.NOTIFICATION_ID = nid;
36: exception
37: when no_data_found then
38: Wf_Core.Token('NID', nid);
39: Wf_Core.Raise('WFNTF_NID');
40: end;
41:
42: --first check whether the user is intended recipient or from role or more info role
43: -- Check if current user has WF_ADMIN_ROLE privileges.
70: and ntf.notification_id = nid
71: );
72: exception
73: when no_data_found then
74: Wf_Core.Token('USER', username);
75: Wf_Core.Token('NID', to_char(nid));
76: Wf_Core.Raise('WFNTF_ACCESS_USER');
77: end;
78: end if;
71: );
72: exception
73: when no_data_found then
74: Wf_Core.Token('USER', username);
75: Wf_Core.Token('NID', to_char(nid));
76: Wf_Core.Raise('WFNTF_ACCESS_USER');
77: end;
78: end if;
79: end if;
72: exception
73: when no_data_found then
74: Wf_Core.Token('USER', username);
75: Wf_Core.Token('NID', to_char(nid));
76: Wf_Core.Raise('WFNTF_ACCESS_USER');
77: end;
78: end if;
79: end if;
80: return(username);
79: end if;
80: return(username);
81: exception
82: when others then
83: wf_core.context('Wf_Advanced_Worklist_Html', 'Authenticate', to_char(nid), nkey);
84: raise;
85: end Authenticate;
86:
87:
98: from wf_notifications
99: where notification_id = p_nid;
100: exception
101: when OTHERS then
102: wf_core.context('Wf_Notification', 'getInfoAfterDenorm', p_nid);
103: raise;
104: end getInfoAfterDenorm;
105:
106: --
126: begin
127: return wf_advanced_worklist.Authenticate(username, nid, nkey);
128: exception
129: when others then
130: if (wf_core.error_name <> 'WFNTF_ACCESS_USER') then
131: raise;
132: end if;
133: end;
134:
172: AND wn.notification_id = nid
173: );
174: exception
175: when no_data_found then
176: Wf_Core.Token('USER', username);
177: Wf_Core.Token('NID', to_char(nid));
178: Wf_Core.Raise('WFNTF_ACCESS_USER');
179: end;
180:
173: );
174: exception
175: when no_data_found then
176: Wf_Core.Token('USER', username);
177: Wf_Core.Token('NID', to_char(nid));
178: Wf_Core.Raise('WFNTF_ACCESS_USER');
179: end;
180:
181: return (username);
174: exception
175: when no_data_found then
176: Wf_Core.Token('USER', username);
177: Wf_Core.Token('NID', to_char(nid));
178: Wf_Core.Raise('WFNTF_ACCESS_USER');
179: end;
180:
181: return (username);
182:
181: return (username);
182:
183: exception
184: when others then
185: wf_core.context('Wf_Advanced_Worklist', 'Authenticate2', username, to_char(nid), nkey);
186: raise;
187: end Authenticate2;
188:
189: procedure SetNavFromHomePage(isebizhomepage in number)