Search Results save_transaction_data

Overview

HR_PROCESS_EIT_SS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the processing, persistence, and transfer of Extra Information Type (EIT) data within Oracle Human Resources. Extra Information Types are the configurable descriptive flexfield-style attribute groups attached to HR entities such as assignments, people, and other person-related records. The package functions as a server-side processing and integration layer, exposing a small set of programmatic entry points that other HR modules, Oracle Workflow, or custom code can call to create, update, delete, and stage EIT records for a transaction. Its name suffix ("_SS") and the presence of transaction-oriented procedures indicate it operates in a staged or set-based context: EIT data is accumulated in a transaction table or PL/SQL table, validated via HR APIs, and then committed through the standard HR API framework. In ETRM the object is classified under the API classification "OTHER," meaning it is not a published, customer-facing HR API in the same tier as the PER_* or HR_* public APIs, but it is still a valid, callable database object often leveraged by personalization, workflow, and extension developers.

Key Procedures and Functions

The documented package exposes nine procedures and functions. Their names and purposes are:

• SAVE_TRANSACTION_DATA — Persists staged EIT transaction data into the underlying HR tables, completing the staging step for the current transaction context.
• GET_EIT_DATA_FROM_TT — Retrieves EIT values from a PL/SQL transaction table ("TT"), used to read back data that has been staged in memory.
• DEL_TRANSACTION_DATA — Removes staged transaction rows once they have been processed or abandoned, cleaning up the transaction context.
• PROCESS_API — The central driver that orchestrates the API-level processing of EIT data, coordinating creation, update, and deletion calls.
• CREATE_EIT — Creates a new Extra Information Type record for the target HR entity.
• UPDATE_EIT — Modifies an existing EIT record with new attribute values.
• DELETE_EIT — Removes an existing EIT record from the target entity.
• DUMP_EIT_TABLE — Debugging/diagnostic routine that outputs the contents of the EIT table, typically for troubleshooting.

No parameter lists are documented in the ETRM metadata, and callers should reference the package specification in the database for exact signatures.

Tables Accessed

The package references HR tables through APPS synonyms:

• PER_PEOPLE_EXTRA_INFO — Stores the actual EIT attribute values for person records; the primary persistence target.
• PER_ALL_ASSIGNMENTS_F — The effective-dated assignment table, used to resolve the assignment context to which EITs apply.
• HR_EIT_STRUCTURE_TABLE — Defines the EIT structure/definition metadata needed to interpret stored attribute values.
• HR_API_TRANSACTION_STEPS — Tracks HR API transaction steps, indicating use of the HR API framework for validated DML.
• WF_ITEM_ATTRIBUTES — Workflow item attributes, reflecting integration with Oracle Workflow for event-driven EIT processing.
• PLITBLM — A PL/SQL index-by table type used internally for bulk operations and in-memory staging.

Usage Notes

HR_PROCESS_EIT_SS is typically invoked from custom PL/SQL, workflow function activities, or personalization code that must apply EIT changes programmatically rather than through the standard HR forms. It is not a self-service concurrent program. Callers generally stage EIT data, call PROCESS_API (which internally dispatches to CREATE_EIT, UPDATE_EIT, or DELETE_EIT as appropriate), and then invoke SAVE_TRANSACTION_DATA to commit. Because the package is not an ETRM-published API, it is referenced by zero other packages; custom code should therefore treat it as a supported-but-internal utility and verify object signatures against the target release. It behaves consistently across EBS 12.1.1 and 12.2.2, though testing against the specific 12.2 online patching environment is recommended.