Search Results create_ie_org_info




Overview
Explore in AI Chat

Overview

APPS.PER_IE_ORG_INFO is a jurisdiction-specific PL/SQL package that supports Oracle HRMS legislative requirements for the Republic of Ireland. It encapsulates the logic required to maintain Irish statutory organization information and assignment-level payroll-related information within Oracle E-Business Suite Release 12.1.1 and 12.2.2.

The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking schema rather than the definer, and it is compiled into the APPS schema alongside the rest of the HRMS legislative library. Its four public procedures target the two primary structures that Irish payroll and organization reporting depend on: organization information records (held in the HR_ORGANIZATION_INFORMATION framework) and assignment records (held in PER_ALL_ASSIGNMENTS_F). By centralizing creation and update logic, the package allows standard Oracle forms, concurrent programs, and customer extensions to manipulate Irish-specific data using validated API calls rather than direct DML against HRMS base tables.

Key Procedures and Functions

The package exposes four documented procedures, none of which return a value:

  • CREATE_IE_ORG_INFO — Creates a new Irish organization information record of a specified information type code, including the dependent organization information values (information2 and information3), the owning organization, and an effective date. This is the entry point invoked when a user creates organization-level Irish statutory data, such as legislative or tax-related identifiers.
  • UPDATE_IE_ORG_INFO — Performs a date-effective update to an existing organization information record identified by its organization information ID, supplying revised type code and information values together with the effective date of the change. It is used to maintain the historical chain of organization information rows rather than overwriting prior values.
  • CREATE_IE_ASG_INFO — Creates Irish assignment-level information for a person, associating the assignment with a payroll and an organization as of a given effective date. This supports the linkage needed for Irish payroll processing and assignment-driven reporting.
  • UPDATE_IE_ASG_INFO — Updates an existing assignment record, identified by assignment ID, with a new payroll and organization combination and an effective date. Like the organization update routine, it applies date-effective semantics so that prior assignment rows are preserved.

Tables Accessed

The package reads from and writes to the following HRMS objects, referenced through APPS synonyms:

  • HR_ALL_ORGANIZATION_UNITS — the master organization definition; validates and resolves the organization to which information and assignments belong.
  • HR_ORGANIZATION_INFORMATION — the generic key-flex structure that stores organization-level information rows; the primary target of CREATE_IE_ORG_INFO and UPDATE_IE_ORG_INFO.
  • HR_SOFT_CODING_KEYFLEX — the descriptive flexfield definitions that determine which information type codes are valid for organization information.
  • PAY_ALL_PAYROLLS_F — payroll definitions; used to validate the payroll supplied when creating or updating assignment information.
  • PER_ALL_ASSIGNMENTS_F — the date-effective assignment table; read and written by CREATE_IE_ASG_INFO and UPDATE_IE_ASG_INFO.
  • PER_ALL_PEOPLE_F — the date-effective person table; used to resolve the person associated with an assignment.
  • DUAL — used for single-row lookups and validation queries.

Usage Notes

PER_IE_ORG_INFO is a legislative (le) library, not a form-bound API. It is typically invoked from the Irish HRMS forms that capture organization and assignment information, from concurrent programs that load or migrate Irish statutory data, and from customer-written PL/SQL that must maintain Irish organization or assignment records without violating HRMS date-effectiveness rules.

Because the procedures are not described with explicit parameter lists in the excerpt, integrators should reference the package specification (peieorgp.pkh) for the exact signature and order before calling the APIs directly. The package is referenced by four other packages in the ETRM repository, indicating that it functions as a shared lower-level routine for Irish HRMS processing. Oracle recommends always invoking these procedures within the correct business process context (with the appropriate effective date and a committed transaction scope), since they write to date-tracked HRMS tables whose integrity depends on consistent effective dating and organization/payroll validation.