188: (p_email_address IN VARCHAR2)
189: RETURN varchar2
190: IS
191: PRAGMA autonomous_transaction;
192: l_user_name wf_users.name%TYPE ;
193: l_user_display_name wf_users.display_name%TYPE ;
194: BEGIN
195: -- Create an ad-hoc user
196: wf_directory.CreateAdHocUser
189: RETURN varchar2
190: IS
191: PRAGMA autonomous_transaction;
192: l_user_name wf_users.name%TYPE ;
193: l_user_display_name wf_users.display_name%TYPE ;
194: BEGIN
195: -- Create an ad-hoc user
196: wf_directory.CreateAdHocUser
197: ( name => l_user_name
215: , p_from_role IN varchar2 DEFAULT null
216: )
217: RETURN number
218: IS
219: l_user_name wf_users.name%TYPE ;
220: l_nid number;
221: cursor get_user_name is
222: select user_name
223: from fnd_user