95: from wf_event_subscriptions
96: where guid = p_subscription;
97:
98: if l_subparams is not null then
99: l_mail_to := wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'MAIL_TO') ;
100: l_wf_admin := wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'WF_ADMINISTRATOR') ;
101: l_system :=wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'PUB_SYSTEM') ;
102: l_wf_admin := CONVERT_PERFORMER(l_wf_admin);
103: if l_wf_admin is null then
96: where guid = p_subscription;
97:
98: if l_subparams is not null then
99: l_mail_to := wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'MAIL_TO') ;
100: l_wf_admin := wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'WF_ADMINISTRATOR') ;
101: l_system :=wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'PUB_SYSTEM') ;
102: l_wf_admin := CONVERT_PERFORMER(l_wf_admin);
103: if l_wf_admin is null then
104: l_wf_admin :=WF_DEFAULT_ADMIN;
97:
98: if l_subparams is not null then
99: l_mail_to := wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'MAIL_TO') ;
100: l_wf_admin := wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'WF_ADMINISTRATOR') ;
101: l_system :=wf_event_functions_pkg.subscriptionparameters(p_string=>l_subparams,p_key=> 'PUB_SYSTEM') ;
102: l_wf_admin := CONVERT_PERFORMER(l_wf_admin);
103: if l_wf_admin is null then
104: l_wf_admin :=WF_DEFAULT_ADMIN;
105: end if;