| modify_portal_user procedure

Related topics
Contained in package wwsec_api. Call this procedure to update personal and business-related information relating to an Oracle Portal user. Note: In Oracle9iAS Portal 9.0.2 (or later) this function can be used to modify a user profile for a user that exists in Oracle Internet Directory (OID). procedure modify_portal_user ( p_user_name in varchar2, p_db_user in varchar2 default wwctx_api.get_public_schema, p_portal_user in varchar2 default 'Y', p_display in varchar2 default 'Y', p_display_personal_info in varchar2 default 'N', p_notification_preference in varchar2 default 'MAILHTML', p_empno in varchar2 default null, p_last_name in varchar2 default null, p_first_name in varchar2 default null, p_middle_name in varchar2 default null, p_known_as in varchar2 default null, p_maiden_name in varchar2 default null, p_date_of_birth in varchar2 default null, p_email in varchar2 default null, p_work_phone in varchar2 default null, p_home_phone in varchar2 default null, p_mobile_phone in varchar2 default null, p_pager in varchar2 default null, p_fax in varchar2 default null, p_office_addr1 in varchar2 default null, p_office_addr2 in varchar2 default null, p_office_addr3 in varchar2 default null, p_office_city in varchar2 default null, p_office_state in varchar2 default null, p_office_zip in varchar2 default null, p_office_country in varchar2 default null, p_home_addr1 in varchar2 default null, p_home_addr2 in varchar2 default null, p_home_addr3 in varchar2 default null, p_home_city in varchar2 default null, p_home_state in varchar2 default null, p_home_zip in varchar2 default null, p_home_country in varchar2 default null, p_organization in varchar2 default null, p_title varchar2 in varchar2 default null, p_spending_limit in number default null, p_hiredate in varchar2 default null, p_source in varchar2 default null, p_manager_user_name in varchar2 default null );

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_user_name | The user name of the Oracle Portal user whose account is to be modified. Datatype: in varchar2
p_db_user | A database user name. Datatype: in varchar2 Default: wwctx_api.get_public_schema
p_portal_user | Indicates whether the user is an active Oracle Portal user. Datatype: in varchar2 Default: Y
p_display | Indicates whether the user will be displayed in a workflow. Datatype: in varchar2 Default: Y
p_display_personal_info | Enter Y or N to choose to display personal information. Datatype: in varchar2 Default: N
p_notification_preference | A workflow notification method. The valid values are: MAILHTML - send HTML mail MAILTEXT - send text mail MAILATTH - send as attachment QUERY - don’t notify, will query SUMMARY - send summary information only Datatype: in varchar2 Default: MAILHTML
p_empno | An employee number. Datatype: in varchar2 Default: null
p_last_name | The user's family name. Datatype: in varchar2 Default: null
p_first_name | The user's given name. Datatype: in varchar2 Default: null
p_middle_name | The user's middle name. Datatype: in varchar2 Default: null
p_known_as | The user's nickname. Datatype: in varchar2 Default: null
p_maiden_name | The user's maiden name. Datatype: in varchar2 Default: null
p_date_of_birth | The user's date of birth. Note: Use the date format ‘DD-MON-YYYY’ format (the month is not case sensitive). Datatype: in varchar2 Default: null
p_email | The user's e-mail address. Datatype: in varchar2 Default: null
p_work_phone | The user's work phone number. Datatype: in varchar2 Default: null
p_home_phone | The user's home phone number. Datatype: in varchar2 Default: null
p_mobile_phone | The user's mobile phone number. Datatype: in varchar2 Default: null
p_pager | The user's pager number. Datatype: in varchar2 Default: null
p_fax | The user's fax number. Datatype: in varchar2 Default: null
p_office_addr1 | The first line of the user's office address. Datatype: in varchar2 Default: null
p_office_addr2 | The second line of the user's office address. Datatype: in varchar2 Default: null
p_office_addr3 | The third line of the user's office address. Datatype: in varchar2 Default: null
p_office_city | The city in which the user's office is located. Datatype: in varchar2 Default: null
p_office_state | The state in which the user's office is located. Datatype: in varchar2 Default: null
p_office_zip | The zip code for the person's office. Datatype: in varchar2 Default: null
p_office_country | The country in which the user's office is located. Datatype: in varchar2 Default: null
p_home_addr1 | The first line of the user's home address. Datatype: in varchar2 Default: null
p_home_addr2 | The second line of the user's home address. Datatype: in varchar2 Default: null
p_home_addr3 | The third line of the user's home address Datatype: in varchar2 Default: null
p_home_city | The user's home city. Datatype: in varchar2 Default: null
p_home_state | The user's home state. Datatype: in varchar2 Default: null
p_home_zip | The user's home zip code. Datatype: in varchar2 Default: null
p_home_country | The user's home country. Datatype: in varchar2 Default: null
p_organization | The user's organization. Note: This parameter is currently ignored. The organization value is always taken from the subscriber. Datatype: in varchar2 Default: null
p_title | The user's job title. Datatype: in varchar2 Default: null
p_spending_limit | The user's spending limit. Note: This parameter is currently ignored. Datatype: in varchar2 Default: null
p_hire_date | The user's date of hire. Note: Use the date format ‘DD-MON-YYYY’ format (the month is not case sensitive). Datatype: in varchar2 Default: null
p_source | The user's source. Note: This parameter is currently ignored. Datatype: in varchar2 Default: null
p_manager_user_name | The user name of the user's manager. Datatype: in varchar2 Default: null
Exceptions: If the user's manager's user ID is not entered, a NO_MANAGER_EXCEPTION is raised. If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised. If the user is not found in OID, a USER_NOT_FOUND_EXCEPTION is raised. Example: l_id number; l_id := wwsec_api.modify_portal_user ( p_User_Name => ‘JWDOE’, p_Portal_User => ‘Y’, p_Display => ‘Y’, p_Display_Personal_Info => ‘Y’, p_Notification_Preference => ‘MAILHTML’, p_Empno => ‘123-45-6789’, p_Last_Name => ‘Doe’, p_First_Name => ‘John’, p_Middle_Name => ‘Wilson’, p_Known_As => ‘John’, p_Date_Of_Birth => ‘15-MAR-1968’, p_Email => ‘jdoe@abc.com’, p_Work_Phone => ‘(123) 456-7890’, p_Home_Phone => ‘(234) 567-8901’, p_Mobile_Phone => ‘(345) 678-9012’, p_Pager => ‘(456) 789-0123’, p_Fax => ‘(567) 890-1234’, p_Office_Addr1 => ‘123 First St’, p_Office_City => ‘Washington’, p_Office_State => ‘DC’, p_Office_Zip => ‘20001’, p_Office_Country => ‘USA’, p_Home_Addr1 => ‘234 Second St’, p_Home_City => ‘Washington’, p_Home_State => ‘DC’, p_Home_Zip => ‘20001’, p_Home_Country => ‘USA’, p_Title => ‘Not Assigned’, p_Hiredate => ‘01-Oct-2000’, p_Manager_User_Name => ‘GHTHOMAS’ );

Related topics
Security API packages | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio