Search Results hr_transaction_snapshot_s

Overview

APPS.HR_SNP_INS is a PL/SQL package body in the Oracle E-Business Suite (EBS) Human Resources (HR) module. Its name follows the Oracle HR naming convention in which "HR" identifies the product, "SNP" denotes the snapshot family of objects, and "INS" designates an insertion routine. The package is classified under the ETRM metadata as OTHER, meaning it is not a public, supported "HR_API"-style interface but an internal helper that supports the snapshot mechanism for HR transactions.

The package forms part of the HR transaction snapshot infrastructure, which captures and preserves the state of HR datetracked records so that transaction history can be audited, reported on, and reprocessed. As the "INS" suffix suggests, the package is responsible for the insert phase of a snapshot operation: it writes a new snapshot row for a transaction (or a set of related records) into the snapshot table. It executes in the APPS schema and is recorded as VALID in the EBS 12.1.1 / 12.2.2 instance in which it was catalogued.

Key Procedures and Functions

The documented package exposes two entry points:

• SET_BASE_KEY_VALUE — Establishes the base key value used to identify the snapshot row being created. In the HR snapshot design, snapshot records are keyed by the transactional entity (for example, a person or assignment) together with a sequence generated through the HR_TRANSACTION_SNAPSHOT_S sequence. This routine resolves and sets the key that the subsequent insert will use, ensuring that the snapshot row is correctly associated with its parent transaction context.
• INS — Performs the actual insertion of the snapshot record into the HR_TRANSACTION_SNAPSHOT table. It is invoked to materialise a snapshot row once the keying information has been established, writing the snapshot payload that downstream snapshot processing, comparison, or audit logic relies on.

These procedures are intentionally narrow in scope, reflecting the package's role as a focused insertion utility rather than a broad public API.

Tables Accessed

The metadata documents direct access to two objects, both referenced through APPS synonyms:

• HR_TRANSACTION_SNAPSHOT — The base snapshot table into which the INS procedure inserts rows. This table stores the captured snapshot of HR transaction data.
• HR_TRANSACTION_SNAPSHOT_S — The associated Oracle sequence that supplies the unique snapshot identifier value. Usage of this sequence corresponds directly to the search term "hr_transaction_snapshot_s" and the SET_BASE_KEY_VALUE routine, which resolves the generated key used to populate the snapshot row.

In addition, the package depends on shared HR infrastructure objects, notably HR_SNP_BUS (business rules for snapshots), HR_SNP_SHD (shadow/consolidation support), HR_API, HR_UTILITY, HR_MULTI_MESSAGE, and FND_MESSAGE for error messaging. The package is not referenced by any database object, confirming it is a leaf-level internal component.

Usage Notes

HR_SNP_INS is an internal package and is not intended for direct invocation from forms, concurrent programs, or custom code. It is called by higher-level HR snapshot logic — through the HR_SNP_BUS business layer — as part of the standard snapshot creation flow whenever an HR transaction snapshot needs to be written. Because it carries the legacy "HR_" internal naming rather than an approved "_API" classification, Oracle conventions discourage direct customer calls.

Customisations should avoid calling HR_SNP_INS.INS or SET_BASE_KEY_VALUE directly. Where snapshot creation is required, the supported path is through the documented snapshot business logic in HR_SNP_BUS and the public HR APIs that trigger it. Direct dependence on this package risks breakage across patch levels, since internal procedures and their signatures are not guaranteed to remain stable between 12.1.1 and 12.2.2.

For debugging or extension, the safest approach is to examine how HR_SNP_BUS invokes HR_SNP_INS and to restrict any changes to the business layer rather than modifying the insertion helper itself.