Search Results raise_wfevent

Overview

PER_RESPOWNER_UTIL_SS is a server-side PL/SQL package in the APPS schema that underpins the Oracle E-Business Suite responsibility ownership and delegated access model. Its role is to identify which users or user groups own or have been granted a responsibility, stage that ownership data for downstream processing, and raise the corresponding workflow business events so that interested subscribers can react. The "_SS" suffix denotes a seed/support package intended for internal use by the responsibility owner feature rather than as a public API.

The package header comment (perroutl.pkb 120.0) confirms it originated as an APPLDEV object and leans on FND_INSTALLATION and FND_LOG for environment resolution and debug tracing. A private function, getTableSchema, resolves the actual schema owner of the PER product (defaulting to 'HR' if the lookup fails), which is characteristic of EBS code that must run correctly whether or not the product is installed in a shared or standalone configuration.

Key Procedures and Functions

• POPULATE_RESPOWNER_TEMP_TABLE — Loads the temporary working table with the set of responsibilities and their owners. This acts as the staging step that the remaining procedures and any downstream concurrent process consume.
• RAISE_WFEVENT — Raises a Workflow (WF) business event related to responsibility ownership changes. This is the procedure most commonly searched for, since it is the trigger point that notifies event subscribers of ownership grants or revocations.
• REVOKE_BLOCK — Performs the revocation/blocking of responsibility access for a given owner. It enforces the removal of a grant so that the responsibility is no longer available to the user or group.
• REVOKE_ACCESS_WFEVENT_SUBSCRB — A workflow event subscription handler that carries out the access-revocation work in response to a raised event. It links the event mechanism back to the revocation logic.

The package also contains internal, non-spec helpers including getTableSchema, get_object_id (which maps an object name to FND_OBJECTS.OBJECT_ID), and get_owned_responsibilites, which returns a resp_owner_table collection built from FND_GRANTS joined to FND_RESPONSIBILITY.

Tables Accessed

• PER_RESPONSIBILITY_OWNER — the core entity storing responsibility ownership records; read and written by the population and revocation logic.
• FND_GRANTS / FND_OBJECTS / FND_RESPONSIBILITY — supply the grant definitions, object identifiers, and responsibility definitions used to determine and revoke access.
• FND_USER — resolves user identity for grants.
• WF_PARAMETER_LIST_T — carries the parameter list passed into Workflow events raised by RAISE_WFEVENT.
• HR_API_TRANSACTIONS_S — the HR API transaction sequence used when responsibility changes must be recorded as HR-style transactions.
• DUAL / PLITBLM — utility references; PLITBLM is the standard PL/SQL table index-by table used for in-memory collections.

Usage Notes

This package is not intended for direct customer invocation. It is typically driven by the Responsibility Owner management forms and related concurrent programs, which call POPULATE_RESPOWNER_TEMP_TABLE to stage data and REVOKE_BLOCK to withdraw access. RAISE_WFEVENT and REVOKE_ACCESS_WFEVENT_SUBSCRB form the event half of the design: when a grant is created or removed, a Workflow business event is raised, and the subscription handler applies the corresponding revocation. Custom code should call the supported Responsibility Owner APIs or raise the documented business event rather than calling these procedures directly, since parameter contracts are internal and subject to change between 12.1.1 and 12.2.2. Because the schema owner is resolved dynamically, deployments spanning HR and PER schema layouts are handled transparently, and FND_LOG statement-level tracing can be enabled to diagnose ownership processing.