Search Results delete_sit

Overview

APPS.HR_SIT_BK3 is the generated hook body for the Oracle HRMS Person Analysis (SIT) API, created by the Oracle HRMS API Hook Pre-processor. The suffix BK denotes the "Book" layer of the API stack that Oracle HRMS uses to separate public entry points, business-rule implementation, and customer hooks. HR_SIT_BK3 forms the outermost generated hook shell that application layer code calls before, and in coordination with, the underlying business logic in HR_SIT_BE3.

The package header lists the source file as pesitapi.pkb and the creation timestamp 2009/03/30 04:46:46, confirming this is a shipped, auto-generated object rather than custom code. In Oracle EBS 12.1.1 / 12.2.2 it belongs to the HRMS SIT (Person Analysis) business area and is classified in ETRM as an "OTHER" API type.

Key Procedures and Functions

• DELETE_SIT_A — the primary delete procedure for the SIT object. It enters the API via hr_utility.set_location, captures the commit unit via hr_api.return_commit_unit, conditionally invokes hr_sit_be3.DELETE_SIT_A when hr_api.call_app_hooks is true, closes the validation set via hr_multi_message.end_validation_set, and then validates the commit unit with the message tag 'DELETE_SIT' and application indicator 'AP'. Its parameters are P_PERSON_ANALYSIS_ID and P_PEA_OBJECT_VERSION_NUMBER.
• DELETE_SIT_B — the corresponding "B" hook, which in this shipped version contains only entry/exit location markers and no functional logic. This is the standard pattern for an empty customer hook stub that can be overridden by extension code.
• DELETE_SIT — the public business logic implementation is referenced indirectly via the commit-unit validation call naming 'DELETE_SIT'.

Tables Accessed

No tables are directly referenced by the package body shown. The only DML is delegated to hr_sit_be3.DELETE_SIT_A, which performs the physical delete against the Person Analysis entity. The relevant base table is PER_PERSON_ANALYSIS, keyed by PERSON_ANALYSIS_ID, with optimistic locking enforced through PEA_OBJECT_VERSION_NUMBER. The table references are therefore indirect and documented through the business entity layer rather than exposed in this hook body.

Usage Notes

• Invoked as part of the standard HRMS API call chain: public API → HR_SIT_BK3 hook → HR_SIT_BE3 business rules.
• Called from the Person Analysis (SIT) form, from concurrent processes that maintain person analysis records, and from custom PL/SQL code that deletes a person analysis.
• The commit unit and validation set handling mean the caller must be within an active HR API transaction; DELETE_SIT is validated with application 'AP'.
• Because DELETE_SIT_B is empty in this release, sites requiring the row to be deleted must ensure no conflicting standard logic deletes the analysis record.
• ETRM records this package as referenced by one other package, and its procedures are documented as DELETE_SIT_B and DELETE_SIT_A.
• Do not modify the generated body; place any custom logic in the corresponding BK hook (B variant) as supported by the Oracle HRMS API Hook Pre-processor.