Search Results hr_third_party_interface_pkg




Overview
Explore in AI Chat

Overview

The APPS.HR_THIRD_PARTY_INTERFACE_PKG package body is a stored PL/SQL construct owned by the APPS schema in Oracle E-Business Suite. It resides within the Human Resources (HR) product family and, as its name implies, supports the interface layer through which Oracle HRMS exchanges data with external, third-party systems. Third-party interfaces in EBS commonly encompass benefits providers, payroll bureaus, time-and-labor vendors, recruiting portals, and other downstream applications that rely on extracting HR data on a controlled schedule.

The ETRM classification for this package is OTHER, indicating that it is an internal supporting package rather than a formally published public API such as those in the HR_API family. The package body status is documented as VALID, and the metadata confirms that the package is functionally active within the environment. Its principal responsibility is the management of an extract date reference, which third-party integration processes use to determine the effective window of data to be transmitted to external recipients.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package body:

  • SET_EXTRACT_DATE — Establishes or updates the stored extract date value maintained by the package. This value is used to mark the point in time from which, or up to which, third-party extract data should be selected.
  • GET_EXTRACT_DATE — Retrieves the currently maintained extract date. This allows calling processes to synchronise their data extraction with the most recently recorded reference point.

No parameter lists are documented for these procedures in the ETRM metadata, and none are asserted here. The two procedures operate as a paired setter/getter mechanism, a common design pattern in EBS interface packages where a persistent control value governs the scope of batch processing.

Tables Accessed

The ETRM metadata does not enumerate specific base tables accessed via APPS synonyms for this package body. The dependency listing confirms references to the APPS schema, the HR_THIRD_PARTY_INTERFACE_PKG specification, and the SYS STANDARD package. Notably, the metadata states that the package is not referenced by any database object, meaning there are no stored dependencies pointing into it. The extract date value managed by the package is therefore expected to be persisted through an internal or interface-specific mechanism rather than through a documented HR transactional table.

Usage Notes

Although the package is not referenced by any database object, the ETRM documentation records that it is referenced by four other packages, indicating that consuming code invokes it directly rather than through a declarative dependency. Typical invocation patterns include:

  • Concurrent programs that extract HR data for transmission to third-party vendors, calling SET_EXTRACT_DATE after a successful run to advance the reference point.
  • Custom PL/SQL integration code that reads the last successful extract date via GET_EXTRACT_DATE to bound its selection criteria.
  • Scheduled batch processing where consistent extract date management is required across multiple HRMS interfaces.

Because the package is internal (classification OTHER) and undocumented in the public HRMS API layer, it should be treated as a supporting utility. Customisations that depend on it must be validated against the specific 12.1.1 or 12.2.2 patch level in use, as internal APIs are not covered by Oracle's public API compatibility guarantees.