When you refresh the repository data, the system calls override packages to populate the repository tables with data from Oracle HRMS. You can edit these packages to override values at legislation or customer level.

All customer override package bodies for the Employee Directory are in the peredcor.pkb file, in the $PER_TOP/patch/115/sql directory. The legislation override package body is in the peredlor.pkb file, in the $PER_TOP/patch/115/sql directory.

For more information, see: Customer and Legislation Overrides.

1. Identify which segments you want to override for any table in the Employee Directory repository, and note the attribute name for each.

2. Identify the correct override call to edit.

   The following table shows which Employee Directory repository tables map to the Oracle HRMS tables:

   Entities Denormalized from Oracle HRMS

   EMPDIR table name	HRMS table name
   PER_EMPDIR_PEOPLE	PER_ALL_PEOPLE_F
   PER_EMPDIR_ASSIGNMENTS	PER_ALL_ASSIGNMENTS_F
   PER_EMPDIR_ORGANIZATIONS	HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL
   PER_EMPDIR_JOBS	PER_JOBS, PER_JOBS_TL
   PER_EMPDIR_POSITIONS	HR_ALL_POSITIONS_F, HR_ALL_POSITIONS_TL
   PER_EMPDIR_LOCATIONS	HR_LOCATIONS_ALL
   PER_EMPDIR_LOCATIONS_TL	HR_LOCATIONS_ALL_TL
   PER_EMPDIR_PHONES	PER_PHONES

   The following table shows which override call to use to override values in the repository tables at legislation or customer levels.

   Legislation and Customer Override Calls

   Table	Legislation Override Call	Customer Override Call	Record Structure (Instance)
   PER_EMPDIR_PEOPLE	PER_EMPDIR_LEG_OVERRIDE. PEOPLE	PER_EMPDIR_PEOPLE_OVERRIDE.BEFORE_DML	PER_EMPDIR_SS.PersonTblType (personTbl)
   PER_EMPDIR_ASG	PER_EMPDIR_LEG_OVERRIDE. ASG	PER_EMPDIR_ASG_OVERRIDE.BEFORE_DML	PER_EMPDIR_SS.AsgTblType (asgTbl)
   PER_EMPDIR_ORGS	PER_EMPDIR_LEG_OVERRIDE. ORGS	PER_EMPDIR_ORGS_OVERRIDE.BEFORE_DML	PER_EMPDIR_SS.OrgTblType (orgTbl)
   PER_EMPDIR_JOBS	PER_EMPDIR_LEG_OVERRIDE. JOBS	PER_EMPDIR_JOBS_OVERRIDE.BEFORE_DML	PER_EMPDIR_SS.JobTblType (jobTbl)
   PER_EMPDIR_POSITIONS	PER_EMPDIR_LEG_OVERRIDE. POSITIONS	PER_EMPDIR_POSITIONS_OVERRIDE.BEFORE_DML	PER_EMPDIR_SS.PosTblType (posTbl)
   PER_EMPDIR_LOCATIONS	PER_EMPDIR_LEG_OVERRIDE. LOCATIONS	PER_EMPDIR_LOCATIONS_OVERRIDE.BEFORE_DML	PER_EMPDIR_SS.LocTblType(locationTbl)

3. In the package body modify the line

        g_override_flg BOOLEAN := FALSE;

   to

        g_override_flg BOOLEAN := TRUE;

   This change enables the override package.

4. Edit the procedure to override data, using the attribute name you identified in Step 1. For an example showing how to edit an override call, see: Customer Override for Single Sign On

If you have enabled the override packages, they are called when the repository data is refreshed. See: Populating the Repository