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
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
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);
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:
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: