Search Results del_transaction_data

Overview

HR_PROCESS_SIT_SS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as OTHER (a non-public, internal API). Its name reflects its role in processing SIT (Special Information Types) records within Oracle Human Resources. The package header is declared AUTHID CURRENT_USER, meaning all unqualified object references resolve against the privileges of the invoking schema rather than the definer, which is typical for internal HR processing routines that are called from the HR forms and workflow layer. The header carries a legacy version string (hrsitwrs.pkh 115.8, dated 2002), indicating the package has been stable since the earlier stages of the EBS Release 11i/12 lineage and remains present in 12.1.1 and 12.2.2 without structural change.

The package also declares a strongly typed record, per_analysis_criteria_rec, that mirrors the thirty segment columns (segment1 through segment30) of the PER_ANALYSIS_CRITERIA table. This record type exists to pass a complete analysis criteria row through the transaction pipeline without individual parameter lists, a common pattern in HR's API transaction framework.

Key Procedures and Functions

The package exposes eight documented routines:

• SAVE_TRANSACTION_DATA — Persists transaction payload data associated with an SIT operation, bridging the caller's in-memory record to the HR API transaction infrastructure.
• INSERT_SIT — Creates a new Special Information Type entry for a person, applying the standard HR validation and date-tracked insert logic.
• UPDATE_SIT — Modifies an existing SIT record, preserving DateTrack history where applicable.
• DELETE_SIT — Removes an SIT record, either logically or physically depending on the HR date-track and delete conventions in force.
• GET_SEGMENTS_FROM_CCID — Resolves the thirty analysis criteria segments from a supplied Code Combination ID, translating a GL/Key Flexfield combination into the human-readable segment values used by PER_ANALYSIS_CRITERIA.
• GET_TRANSACTION_DATA — Retrieves previously saved transaction data, typically to drive a review or approval step.
• PROCESS_API — The orchestrating entry point that drives the SIT insert/update/delete operations through the HR API transaction framework and applies workflow routing.
• DEL_TRANSACTION_DATA — Cleans up the transaction staging rows once processing completes, fails, or is abandoned. This is the routine most commonly surfaced by searches for "del_transaction_data".

Tables Accessed

Four base tables are referenced through APPS synonyms:

• PER_ANALYSIS_CRITERIA — Stores the thirty flexfield segment values that define an SIT record; read and written across insert, update, and segment-resolution paths.
• HR_API_TRANSACTION_STEPS — The HR API framework's step/state table, tracking each transaction through its lifecycle and consulted by SAVE, GET, and DEL_TRANSACTION_DATA.
• WF_ITEM_ATTRIBUTES — Holds the gv_wf_review_region_item constant ('HR_REVIEW_REGION_ITEM'), which binds the SIT transaction to its Oracle Workflow review region.
• PER_PERSON_ANALYSES — The person-level analysis (SIT) assignment table against which INSERT_SIT, UPDATE_SIT, and DELETE_SIT act.

Usage Notes

HR_PROCESS_SIT_SS is an internal package with no documented inbound package dependencies (referenced by 0 other packages per ETRM). It is invoked indirectly: the HR SIT forms call into the HR API transaction framework, which routes to PROCESS_API and the supporting GET/SAVE/DEL_TRANSACTION_DATA routines. It may also be reached from Oracle Workflow processes that review pending SIT changes. Direct invocation from custom code is not supported; the AUTHID CURRENT_USER declaration and the 2002-era header signal that it should be treated as a private implementation detail. The visibility of DEL_TRANSACTION_DATA in ETRM metadata is consistent with it being a cleanup utility referenced in debugging or transaction-recovery scenarios rather than a documented integration point.