Search Results set_migration_mode

Overview

HXC_PREFERENCE_EVALUATION is a core PL/SQL package within the Oracle E-Business Suite Time and Labor (HXC) module. Its business function is to evaluate, resolve, and return resource preferences applicable to a worker, assignment, or organizational context at a given point in time. Time and Labor stores preferences hierarchically through preference definitions and preference hierarchies, and this package traverses those hierarchies to determine which preference values apply to a specific resource. It also caches evaluated results in memory to accelerate repeated lookups during timecard processing, rule evaluation, and preference retrieval.

The package is classified as an API of type OTHER under the APPS schema and is referenced by 46 other packages, indicating it is a foundational dependency for Time and Labor preference logic rather than an end-user facing component.

Key Procedures and Functions

The documented API contains 26 procedures and functions. The primary retrieval entry points are RESOURCE_PREFERENCES, which resolves and returns the set of preferences applicable to a single resource, and RESOURCE_PREFS_BULK, which performs the same resolution for multiple resources in a single invocation to reduce round trips. SET_RESOURCE_PREFERENCES persists or applies preference values, while GET_RESOURCE_PREFERENCES retrieves previously resolved values.

Supporting utility functions include RESOURCE_PREF_SEP, which separates or delimits concatenated preference components, and RESOURCE_PREF_ERRCODE, which returns the error code associated with a preference evaluation attempt. CLEAR_SORT_PREF_TABLE_CACHE clears the in-memory cache of sorted preference tables, forcing subsequent evaluations to rebuild cached data — this is the routine targeted by the search term "clear_sort_pref_table_cache." NUM_HIERARCHY_OCCURANCES counts occurrences within a preference hierarchy.

Date and context resolution helpers include EMPLOYMENT_ENDED, which determines whether an assignment has terminated, ASSIGNMENT_LAST_EFF_DT, which returns the last effective date of an assignment, and EVALUATION_DATE, which establishes the effective date used during preference evaluation. MIGRATION_MODE and SET_MIGRATION_MODE expose and control a migration flag, CHECK_NUMBER performs a numeric validation, RETURN_VERSION_ID returns a version identifier, and GET_TC_RESP retrieves timecard responsibility context.

Tables Accessed

Core preference metadata is read from HXC_PREF_DEFINITIONS and HXC_PREF_HIERARCHIES, which together define preference attributes and their hierarchical relationships. HXC_RESOURCE_RULES supplies rule logic governing preference applicability, while HXC_TIME_BUILDING_BLOCKS and HXC_TIME_ATTRIBUTES with HXC_TIME_ATTRIBUTE_USAGES provide time-related context. HXC_LATEST_DETAILS and HXC_TIMECARD_SUMMARY provide summarized timecard state.

Employee and assignment data come from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, and PER_ASSIGNMENT_STATUS_TYPES, with organizational context from HR_ALL_ORGANIZATION_UNITS and PER_ORGANIZATION_STRUCTURES. Security and access context are derived from FND_RESPONSIBILITY and FND_USER.

Usage Notes

HXC_PREFERENCE_EVALUATION is invoked programmatically by Time and Labor forms, concurrent programs, and dependent packages rather than directly by end users. Because it caches preference hierarchy evaluations, callers that modify preference definitions or hierarchy structures must invoke CLEAR_SORT_PREF_TABLE_CACHE to invalidate stale cached data. Custom extensions should call the documented APIs rather than querying the underlying preference tables directly, ensuring consistent evaluation semantics across EBS 12.1.1 and 12.2.2.