DBA Data[Home] [Help]

APPS.OTA_WF dependencies on WF_USERS

Line 2060: l_user_name wf_users.name%TYPE ;

2056: (p_email_address IN VARCHAR2)
2057: RETURN varchar2
2058: IS
2059: PRAGMA autonomous_transaction;
2060: l_user_name wf_users.name%TYPE ;
2061: l_user_display_name wf_users.display_name%TYPE ;
2062: BEGIN
2063: -- Create an ad-hoc user
2064: wf_directory.CreateAdHocUser

Line 2061: l_user_display_name wf_users.display_name%TYPE ;

2057: RETURN varchar2
2058: IS
2059: PRAGMA autonomous_transaction;
2060: l_user_name wf_users.name%TYPE ;
2061: l_user_display_name wf_users.display_name%TYPE ;
2062: BEGIN
2063: -- Create an ad-hoc user
2064: wf_directory.CreateAdHocUser
2065: ( name => l_user_name

Line 2088: l_user_name wf_users.name%TYPE ;

2084: , p_from_role IN varchar2 DEFAULT null
2085: )
2086: IS
2087: l_proc varchar2(72) := g_package||'send_notification';
2088: l_user_name wf_users.name%TYPE ;
2089: l_nid number;
2090: l_email_ids varchar2(32767) := p_email_addresses;
2091: l_person_ids varchar2(32767) := p_person_ids;
2092: l_cur_email_id fnd_user.email_address%TYPE := null;