Search Results hr_absutil_ss




Overview
Explore in AI Chat

Overview

HR_ABSUTIL_SS is an Oracle E-Business Suite PL/SQL utility package owned by the APPS schema and classified under the OTHER API category in ETRM for releases 12.1.1 and 12.2.2. The suffix "SS" denotes a self-service utility library rather than a business object API; the package does not itself create, update, or validate absence records through the standard HR_API wrapper, but instead exposes read-mostly helper logic consumed by the Oracle Self-Service Human Resources (SSHR) absence and attendance flows. Its central role is to abstract the retrieval of absence attributes — dates, type, category, duration in hours and days, and workflow status — for a given transaction and absence/attendance record, so that multiple self-service pages and approval notifications present a single consistent view of the same absence data. The header revision string (hrabsutlss.pkh 120.5.12020000.2, dated 2012/09/04) confirms the file was last shipped on the 12.2 codeline, and the package is referenced by two other packages, indicating it is a shared dependency rather than an entry point invoked directly by end users.

Key Procedures and Functions

The getter functions form the bulk of the interface and all resolve the same identifying pair — a transaction identifier and an absence/attendance identifier — into a single attribute value. GETSTARTDATE and GETENDDATE return the effective start and end dates of the absence. GETABSENCETYPE returns the absence type name, while GETABSENCECATEGORY and GETABSENCECATEGORYCODE return the category description and its coded value respectively, the latter typically resolving through lookup values for programmatic comparison. GETABSENCEHOURSDURATION and GETABSENCEDAYSDURATION return the absence duration in hours and in days, supported by the auxiliary helpers GETABSDURHOURS and GETABSDURDAYS.

Status-related functions report workflow and approval state: GETAPPROVALSTATUS and GETAPPROVALSTATUSCODE return the human-readable and coded approval states, while GETABSENCESTATUS and GETABSENCESTATUSVALUE return the equivalent pair for overall absence status. The predicate functions ISUPDATEALLOWED, ISCONFIRMALLOWED, and ISCANCELALLOWED take the transaction, absence record, and in some cases the current transaction status, and return flags indicating which self-service actions the current user may perform. HASSUPPORTINGDOCUMENTS indicates whether attachments exist for the absence. GETABSENCENOTIFICATIONDETAILS is the sole documented procedure; it returns the notification subject text used when the absence approval workflow raises a message. DELETE_TRANSACTION and REMOVE_ABSENCE_TRANSACTION perform the teardown of a transaction and its associated absence record.

Tables Accessed

The package reads absence configuration from PER_ABSENCE_ATTENDANCE_TYPES and its translation table PER_ABS_ATTENDANCE_TYPES_TL, and code meanings from FND_LOOKUP_VALUES. Transaction and step state are sourced from HR_API_TRANSACTIONS and HR_API_TRANSACTION_STEPS. Workflow context is obtained from WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, and WF_NOTIFICATIONS, which supports the approval-status and notification-subject functions. Attachment existence is checked against FND_ATTACHED_DOCUMENTS, and notification text may be resolved through FND_NEW_MESSAGES. All access occurs through APPS synonyms.

Usage Notes

HR_ABSUTIL_SS is normally called from SSHR absence pages, approval notification handlers, and OAF or Forms-based self-service regions that need to render or evaluate an absence without re-implementing the underlying queries. It is also called by the two documented dependent packages. Customizations should treat the package as a read utility, using its predicates to gate UI actions consistently with seeded behavior; direct DML against the underlying tables is not exposed here. Because the package is declared AUTHID CURRENT_USER, effective privileges derive from the invoking schema, so custom callers must be granted execute on the APPS synonym and rely on APPS-owned synonyms for the referenced tables.