Search Results get_country_code

Overview

The APPS.HR_NL_CALC_TARGET_GROUP package is a Dutch localization (NL) component within Oracle E-Business Suite Human Resources. It provides the server-side logic used to derive a person's target group classification, a statutory reporting construct required for Dutch tax and social insurance purposes. The package operates with AUTHID CURRENT_USER, meaning it executes under the privilege set of the calling schema rather than the definer, and it is designed to be invoked from both Oracle Forms and concurrent processing contexts.

The core business purpose is to evaluate a person's country of birth, contact relationships, and business group attributes against Oracle Fast Formula logic, and then return the applicable target group indicator. Because target group determination depends on conditional rules that change with legislation (for example, nationality and birthplace combinations), the package deliberately pushes the decision logic into Fast Formula rather than hard-coding it, allowing functional administrators to maintain the rules without code changes.

Key Procedures and Functions

Three documented callable units comprise the package’s public interface:

• GET_COUNTRY_CODE — Returns a VARCHAR2 value representing the applicable country code for a person, based on the person’s identity, an associated contact relationship type, and a session date that controls the effective-date context of the lookup. It is used to resolve the relevant country against date-tracked person and contact records.
• RUN_FORMULA — Returns a VARCHAR2 result after evaluating Fast Formula logic. It accepts country-of-birth values for multiple relationship contexts (father, mother, and the employee), a business group identifier, and a session date. This is the rule-evaluation engine of the package and is the point at which legislation-specific rules are applied.
• GET_TARGET_GROUP — Returns the final target group VARCHAR2 classification for a person as of a given session date. This is the primary entry point and the function most likely referenced by the object the user searched for (get_country_code is called internally as part of this resolution path).

No parameter-list details beyond those documented are asserted here; refer to the ETRM package header for exact signatures.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• PER_ALL_PEOPLE_F — The date-tracked person record. Supplies person_id, country_of_birth, and business_group_id, which form the primary inputs to target group calculation.
• PER_CONTACT_RELATIONSHIPS — Provides contact type and related-person information, enabling the package to evaluate country of birth for the father and mother contexts passed into the formula runner.
• FF_FORMULAS_F — The Fast Formula repository. The package resolves and executes formula definitions from this table to apply configurable target group rules.

Usage Notes

HR_NL_CALC_TARGET_GROUP is a localization utility, typically invoked indirectly rather than being called by end users directly. It is referenced by one other package within the EBS schema set, and is commonly reached through Dutch HR forms, person-processing flows, or concurrent programs that produce statutory target group reporting. Because the entry points accept a p_session_date, callers must supply a meaningful effective date so that the date-tracked PER_ALL_PEOPLE_F and contact records resolve correctly; passing SYSDATE is common but may produce different results than a payroll or reporting period end date. The reliance on FF_FORMULAS_F means that behavior can change when Fast Formula definitions are amended, so regression testing after formula changes is advisable. Custom code should call the package through its documented functions rather than querying the underlying tables directly, and should handle the possibility of a NULL or unexpected target group return for persons whose data is incomplete.