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’

);

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