Adding Users to PQH_ROLES

For adding user to PQH_ROLES

Table : per_people_extra_info  — Role ID would be stored in an attribute as per setup

begin
hr_person_extra_info_api.create_person_extra_info
(p_validate                   => false
,p_person_id                  => 25915
,p_information_type           => ‘PQH_ROLE_USERS’
,p_pei_information_category   => ‘PQH_ROLE_USERS’
,p_pei_information3           => 4001–l_num_role_id
,p_pei_information4           => ‘N’
,p_pei_information5           => ‘Y’
,p_pei_information9           => ‘N’
,p_person_extra_info_id       =>l_num_person_extra_info_id
,p_object_version_number      =>l_num_ovn_pie
);

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s