Search Results revoke_access

Overview

APPS.HR_CAED_SS is a server-side PL/SQL package body that supports the Oracle E-Business Suite HR self-service transaction framework. The package name follows the HR product prefix and the "_SS" self-service naming convention, and the underlying source header (hrcaedw.pkb, version 120.1, dated 2005) identifies it as part of the HR "CAED" family of web utilities. Its principal business role is to orchestrate workflow-driven, self-service HR transactions — creating and persisting workflow transactions and their associated transaction steps on behalf of an authenticated user, and exposing the access-control primitives used by that self-service process.

Key Procedures and Functions

• CREATE_TRANSACTION — Establishes a workflow-based HR self-service transaction. Documented behaviour shows it validates the caller's session, checks for an existing transaction ID via the HR transaction utility layer, starts a new transaction when none exists, and then obtains or creates the corresponding transaction step.
• GET_TRANSACTION_STEP — Retrieves the transaction step identifier associated with a given transaction, item type, and item key. Called during transaction creation to determine whether a step already exists before one is created.
• WRITE_TRANSACTION — Persists transaction data, writing the row-level details required by the self-service transaction framework.
• PROCESS_API — Acts as the consolidated entry point, applying business handling logic to the transaction flow before results are written back.
• GRANT_ACCESS — Grants a user access to the self-service transaction, forming the positive half of the package's access-control pair.
• REVOKE_ACCESS — Withdraws previously granted access from a user. This procedure is the subject of the "revoke_access" search: it removes the authorisation record so that the corresponding user can no longer act on the transaction through the self-service UI.

Tables Accessed

• HR_API_TRANSACTION_STEPS — Stores the discrete steps belonging to each self-service transaction; read to resolve an existing step and written when a new step must be created.
• WF_ITEMS — The Oracle Workflow item repository. Item type and item key values are supplied or returned here, linking the HR transaction to its workflow instance.
• PER_ALL_PEOPLE_F — The person/employee records table, used to resolve and validate the login person identifier that owns or executes the transaction, and to determine creator identity during session validation.

All access is performed through the APPS synonyms, so the package inherits standard APPS schema privileges.

Usage Notes

HR_CAED_SS is invoked indirectly through the HR self-service transaction infrastructure rather than being called by end users. It is typically exercised by Oracle iRecruitment and related HR self-service flows that drive Oracle Workflow items, and it may be reached from self-service forms, JSP/HTML-based OA Framework pages, or custom code that calls the package after performing HR_UTIL_MISC_WEB.VALIDATE_SESSION. Because REVOKE_ACCESS removes authorisation, it should be called only by trusted custom code or workflow activities already operating within an authenticated session; improper invocation leaves stale grants or removes legitimate access. Internally the package delegates to HR_TRANSACTION_SS and HR_TRANSACTION_API for transaction and step lifecycle management, so customisations should extend rather than duplicate that logic. Referenced by zero other packages, it has no downstream PL/SQL dependents, and its internal calls to HR_UTILITY.SET_LOCATION assist debugging in the EBS 12.1.1 and 12.2.2 file systems.