Search Results get_business_group

Overview

APPS.PER_IE_ORG_INFO is a PL/SQL package body that supports Oracle HRMS legislative functionality for the Republic of Ireland (IE), specifically the capture and maintenance of PAYE (Pay As You Earn) employer and organization information. In Oracle EBS 12.1.1 and 12.2.2, this package operates within the Oracle Human Resources (PER) product schema and is classified under ETRM as an "OTHER" API — meaning it is a supporting/internal package rather than a formally published public API. Its primary business purpose is to enforce Irish statutory rules governing PAYE reference numbers, including validation that PAYE references are unique both at Business Group level and at Legal Employer level. The package source header indicates it has been under development since at least release 120.5 (2008) and is marked "noship," indicating it is not shipped as an end-user-facing object but rather is invoked internally by HRMS legislative processes.

Key Procedures and Functions

The ETRM metadata documents four procedures within this package:

• CREATE_IE_ORG_INFO — Creates Irish-specific organization-level information, typically storing PAYE reference details against an organization within a Business Group. It is used when a new Irish legal employer or organization is set up and the PAYE registration data is captured.
• UPDATE_IE_ORG_INFO — Updates existing Irish organization-level information. It allows changes to be made to previously recorded PAYE reference data while preserving validation rules.
• CREATE_IE_ASG_INFO — Creates Irish-specific assignment-level information, capturing data associated with an employee assignment relevant to Irish PAYE processing.
• UPDATE_IE_ASG_INFO — Updates previously created Irish assignment-level information.

The source excerpt also reveals internal validation procedures, including validate_uniqueness (which checks that PAYE references at Business Group level are unique) and validate_employer (which checks that PAYE references defined at Legal Employer level are unique within a Business Group). These procedures raise the application error HR_IE_PAYE_UNIQUE_ERROR when duplicates are detected, and are gated by a call to hr_utility.chk_product_install checking for the 'IE' installation of Oracle Human Resources.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — Source of organization and business group identifiers, and effective date boundaries used in validations.
• HR_ORGANIZATION_INFORMATION — Stores the Irish organization information records (context 'IE_ORG_INFORMATION') including PAYE references and classification entries.
• HR_SOFT_CODING_KEYFLEX — Supports descriptive flexfield/soft coding for organization data.
• PER_ALL_ASSIGNMENTS_F — Provides assignment records for Irish assignment-level information creation and updates.
• PER_ALL_PEOPLE_F — Supplies person records tied to the assignments handled by this package.
• PAY_ALL_PAYROLLS_F — Links Irish PAYE information to payroll definitions where relevant.
• DUAL — Used for single-row queries in validation logic.

Usage Notes

APPS.PER_IE_ORG_INFO is typically invoked indirectly rather than called directly by end users. It is referenced by four other packages within the ETRM metadata, indicating it serves as a dependency for higher-level HRMS legislative flows. In practice it is triggered through the Oracle HRMS Irish localization forms — particularly organization and assignment maintenance screens where PAYE references are entered — and may be called by concurrent programs that process Irish statutory reporting. Custom code that programmatically inserts or updates Irish PAYE organization or assignment data should not call this package directly unless the calling code also respects the underlying validation rules (uniqueness at both BG and Legal Employer level) enforced internally. Developers should treat it as an internal supporting object and prefer documented public HRMS APIs where available.