Create Position Control roles(pqh_roles)

The following script can be used for creating Position Control roles used for AME.

Table : PQH_ROLES

Navigation : Global HRMS Manger –> Ctrl + L –> Maintain Roles

 

Capture

 

DECLARE
L_NUM_ROLE_ID  pqh_roles.role_id%TYPE;
l_num_object_version_number  pqh_roles.object_version_number%TYPE;
BEGIN
pqh_roles_api.create_role
(
P_VALIDATE                      => FALSE
,P_ROLE_ID                       => L_NUM_ROLE_ID
,P_ROLE_NAME                    => ‘DEMO_ROLE’
,P_ROLE_TYPE_CD                  =>’EMP’
,P_ENABLE_FLAG                   => ‘Y’
,P_OBJECT_VERSION_NUMBER         =>L_NUM_OBJECT_VERSION_NUMBER
— ,p_business_group_id              in  number    default null
,P_EFFECTIVE_DATE                =>SYSDATE
, P_INFORMATION_CATEGORY        =>NULL
,p_information4=> ‘IN-BAN19’
);
COMMIT;
END;

/***********************END********************************/

 

 

 

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