1 package body WF_NOTIFICATION2 as
2 /* $Header: wfntf2b.pls 115.0 2003/03/03 20:02:05 ctilley noship $ */
3
4
5 -- Return MORE_INFO_ROLE from a notification.
6 -- IN
7 -- nid - Notification Id
8 -- RETURNS
9 --
10 function GetMoreInfoRole(
11 nid in number)
12 return varchar2
13 is
14 l_more_info_role varchar2(320);
15 begin
16 if (nid is null) then
17 wf_core.token('NID', to_char(nid));
18 wf_core.raise('WFSQL_ARGS');
19 end if;
20 -- Get more_info_role
21 begin
22 select WN.MORE_INFO_ROLE
23 into l_more_info_role
24 from WF_NOTIFICATIONS WN
25 where WN.NOTIFICATION_ID = nid;
26 exception
27 when no_data_found then
28 wf_core.token('NID', to_char(nid));
29 wf_core.raise('WFNTF_NID');
30 end;
31
32 return(l_more_info_role);
33
34 exception
35 when others then
36 Wf_Core.Context('Wf_Notification2', 'GetMoreInfoRole', to_char(nid));
37 raise;
38 end GetMoreInfoRole;
39
40
41 end WF_NOTIFICATION2;
42