Legislation and Customer Overrides

An override enables a user to customize field values and data in a code package . An override is different from a user hook, which enables users to write code and update both fields and HRMS database tables.

Within SSHR, you can use overrides in the following situations:

To enable an override, you must carry out the following steps:

  1. Open the required package. This package may be one of the following:

    Note: The packages reside in the following directory:

    $PER_TOP/patch/115/sql directory

  2. Modify the override flag in the package to enable the customer override. The override flag is similar to the following line of code:

    g_override_flg	BOOLEAN:=FALSE

    Change the BOOLEAN value to TRUE.

  3. Insert your code for the override. For examples of code, see the documentation relevant to your function:

  4. Compile the override and apply to database.

    When the override packages are implemented, they are called by the application.

Examples of Overrides

Displaying Position or Job Names

You can use customer overrides to configure a user-defined format for displaying position or job names. For example, you can choose to replace the defined format for displaying a user's job with a user-defined name format consisting of fewer segments.

For example, instead of displaying a job as:

12345.Global Development.Development Manager.12B

you can display only the third segment (Development Manager).

To make this change, you need to modify the perwscor.pkb code package to include the following code:

Note: The packages are available within $PER_TOP/patch/115/sql directory. The file containing the package header is perwscor.pkh.

FUNCTION getJobName(
		p_job_id		IN number,
		p_bg_id		IN number,
		p_value		IN varchar2//Actual MLS job name
)
return varchar2

To make a similar change to the position field, you need to modify the package to include the following code:

FUNCTION getPositionName(
		p_pos_id		IN number,
		p_bg_id		IN number,
		p_value		IN varchar2
)
return varchar2

You also need to change the job override and/or position override flag to TRUE in the package. In the following example, only the job override flag is set to TRUE.:

g_job_override_flg			BOOLEAN:=TRUE;
g_position_override_flg	BOOLEAN:=FALSE