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