Search Results create_item_attrib_if_notexist

Overview

APPS.HR_APPROVAL_SS is a server-side PL/SQL package body that implements the approval, rejection, and notification workflow logic for Oracle HRMS self-service transactions in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the integration layer between the HTML-based self-service approval pages and the Oracle Workflow engine, driving the routing of transactional approvals through the configured approval hierarchy. The package encapsulates blackout-period checks, approver resolution, notification dispatch, and workflow attribute maintenance required to advance a transaction through its approval lifecycle.

The package declares several package-level constants and exceptions, including g_package, g_no_transaction_id, g_wf_not_initialzed, g_wf_error_state, g_invalid_responsibility, and g_transaction_status_invalid, which are used for debugging traces and controlled error handling. A private cursor, csr_wiav, queries WF_ITEM_ATTRIBUTE_VALUES to determine whether a workflow item attribute already exists before attempting to create it.

Key Procedures and Functions

The 31 documented procedures and functions fall into several functional clusters:

• Approval routing: GETNEXTAPPROVERROLE, ISFINALAPPROVER, APPROVER_CATEGORY, GETROLEDISPLAYNAME, REINITPERFORMERROLES, ISAPPROVEREDITALLOWED — resolve the next approver, determine whether the current approver is the final one, classify approver type, and refresh performer role assignments.
• Status and notification maintenance: UPDATEAPPROVESTATUS, FLAGAPPROVERSASNOTIFIED, UPDATENORESPONSESTATUS, SETRESPONDEDUSERCONTEXT — update transaction approval status, mark approvers as notified, record non-response outcomes, and set the responder user context.
• Workflow submission and handling: SUBMIT_FOR_APPROVAL, PROCESSRFC, HANDLERFCACTION — initiate workflow approval, process Request For Change actions, and handle RFC workflow events.
• Context setup per responsibility: SETSFLRESPONSECONTEXT, SETRFCRESPONSECONTEXT, SETAPPROVERRESPONSECONTEXT — establish the correct responsibility context when SFL, RFC, or approver pages are entered.
• User resolution: GETUSERORIGSYSTEM, GETUSERORIGSYSTEMID — retrieve the originating system and identifier for a user.
• Rendering and helper utilities: APPROVALS_BLOCK, CREATE_ITEM_ATTRIB_IF_NOTEXIST — produce the approvals UI block and add a workflow item attribute only when it does not already exist.

The presence of 31 routines indicates this is a broad service package rather than a single-purpose API; the exact parameter signatures are not reproduced here.

Tables Accessed

The package reads and writes through APPS synonyms. It queries WF_ITEMS, WF_ITEM_ATTRIBUTE_VALUES, WF_ACTIVITIES, WF_ACTIVITY_ATTRIBUTES, WF_ITEM_ACTIVITY_STATUSES, WF_NOTIFICATIONS, WF_NOTIFICATION_ATTRIBUTES, and WF_LOCAL_ROLES to drive workflow state, item attributes, notification contents, and role membership. HR data is drawn from PER_ALL_PEOPLE_F, PER_APPRAISALS, HR_API_TRANSACTIONS, HR_WORKFLOW_ITEM_KEY_S, and PQH_SS_APPROVAL_HISTORY, supporting approver resolution and historical tracking. FND_USER and FND_NEW_MESSAGES provide user identity and notification message content.

Usage Notes

HR_APPROVAL_SS is invoked primarily by self-service approval and RFC pages within the HRMS responsibility, and is referenced by eight other packages. It executes in the APPS schema and depends on a properly initialized Workflow environment; missing initialization raises g_wf_not_initialzed. Customizations should not modify this seeded package directly, as the $Header identifies it as an Oracle-shipped object subject to patching.