Search Results p_review_proc_call

Overview

HR_CAED_SS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the generic "OTHER" API category. The suffix "CAED" refers to the Change Access / Employee Delete family of self-service flows, and the package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking session rather than the definer. Its principal responsibility is to orchestrate the transactional side of employee access changes — granting access, revoking access, and recording the resulting audit trail — within the Oracle Workflow-driven self-service framework. Rather than manipulating HR data directly, the package creates and progresses rows in the HR API transaction tables, delegating the actual business validation and persistence to the HR API layer through process_api. The p_review_proc_call parameter that appears on write_transaction and grant_access allows the caller to record or pass the name of a review procedure, supporting the configurable approval/review step used in access-grant workflows. The header comment dates the source to release 11.5.7 vintage, and the package remains present and callable in 12.1.1 and 12.2.2 as part of the backwards-compatible HR self-service stack.

Key Procedures and Functions

• CREATE_TRANSACTION — Establishes the initial HR API transaction record for a workflow item, taking the workflow item type, item key, activity ID, and login person, and returning the new transaction ID and transaction step ID by reference.
• PROCESS_API — Drives the HR API processing for a given transaction step, with a p_validate flag defaulting to FALSE. It is the point at which validation and persistence of the staged change are triggered.
• WRITE_TRANSACTION — Writes the descriptive detail of the access change — employee and person identifiers, the action performed, granted and deleted employee/user information, and the optional p_review_proc_call value — into the transaction step for audit and display purposes.
• GET_TRANSACTION_STEP — Retrieves the transaction step ID that corresponds to a given transaction ID, item type, and item key, returning it as an OUT parameter.
• GRANT_ACCESS — The primary entry point for granting a user access to an employee record; accepts the workflow context, actor and login person, action type, granted employee/user identity, and the optional p_review_proc_call, and returns the transaction ID and transaction step ID.
• REVOKE_ACCESS — The complementary entry point for removing access, accepting the workflow context, action type, granted user, and the deleted employee details.

Tables Accessed

• HR_API_TRANSACTION_STEPS — The central staging table for HR API operations; used to create steps, locate steps by transaction, and persist the outcome of process_api.
• WF_ITEMS — Supplies the workflow item type and item key that link each transaction to its running workflow process.
• PER_ALL_PEOPLE_F — Provides the person/employee records against which access is granted or revoked and whose names are captured in the transaction detail.

Usage Notes

HR_CAED_SS is not an end-user API; it is invoked by the self-service access-management workflow and by the forms and concurrent programs that surround it. Typical callers are the OAF/Forms pages behind the manager and employee self-service "grant access" and "revoke access" functions, together with Oracle Workflow function activities that call GRANT_ACCESS or REVOKE_ACCESS as workflow nodes and then invoke PROCESS_API to commit the change. Custom extensions should mirror the package's own pattern: create the transaction, write the descriptive detail (including any review procedure name via p_review_proc_call), locate the transaction step, and only then call PROCESS_API, invoking it first with validation enabled before a final committing pass. Because the package runs with AUTHID CURRENT_USER, the invoking session must hold the necessary HR and Workflow privileges. Standard Oracle support policy applies: the package is not documented for direct customer invocation, and its signature may change between patch levels.