Search Results get_role

Overview

HR_WPM_NTF_UTIL is a utility package body owned by APPS and classified within ETRM as a UTIL object. Its business purpose is to support the Oracle E-Business Suite Workforce Performance Management (WPM) feature set by generating and dispatching workflow notifications related to personal scorecards and performance management plans. The package encapsulates the logic required to resolve recipients, identify managers or position supervisors, and assemble notification content for scorecard-related events in Oracle EBS 12.1.1 and 12.2.2.

The package body is defined as an autonomous PL/SQL unit containing a single public function documented in ETRM, SEND_NOTIFICATION, supported by several private cursors that resolve role, person, scorecard, and hierarchy information needed to determine the correct notification audience.

Key Procedures and Functions

• SEND_NOTIFICATION — The only documented program unit in the package. It accepts an action type, a scorecard identifier, a directional flag indicating whether notification flows to or from a manager, and a reason value, and it returns a numeric status. The function is responsible for determining the appropriate recipient(s) based on the scorecard and performance management hierarchy, constructing the notification message, and submitting it through the workflow notification infrastructure.

Although not part of the documented public interface, the package body relies on several private cursors that are relevant to understanding SEND_NOTIFICATION. The get_role cursor (the target of the searched term "get_role") resolves the role name for a given person by querying WF_ROLES where ORIG_SYSTEM is 'PER' and ORIG_SYSTEM_ID matches the person identifier. Additional cursors resolve the global name of a person, retrieve scorecard information, identify a scorecard owner's manager, obtain the scorecard person, determine the performance management plan hierarchy type, and resolve a position manager through the position structure. These cursors collectively support the audience-resolution logic that SEND_NOTIFICATION requires.

Tables Accessed

ETRM documents the following tables as referenced by the package through APPS synonyms:

• PER_PERSONAL_SCORECARDS — Supplies scorecard ownership, plan association, and the assignment linkage used to identify the person and manager associated with a scorecard.
• PER_ALL_ASSIGNMENTS_F — Provides current assignment and supervisor information, restricting to employee and contingent worker assignment types and effective-dated rows.
• PER_ALL_PEOPLE_F — Resolves the person's global name and validates the person record against the current effective date range.
• PER_PERF_MGMT_PLANS — Determines the hierarchy type code governing how the scorecard's management chain is interpreted.
• PER_POS_STRUCTURE_ELEMENTS — Supports position-based manager resolution where the performance management hierarchy is position-oriented.
• PER_PERSON_TYPES and PER_PERSON_TYPE_USAGES_F — Used to qualify person records by type and effective usage.
• WF_LOCAL_ROLES — Resolves role names associated with persons, which is the table underlying the get_role cursor.
• FND_NEW_MESSAGES — Used in the construction or staging of the notification message content.

Usage Notes

HR_WPM_NTF_UTIL is an internal utility invoked by the Workforce Performance Management notification flows rather than being called directly from user-facing forms. It is typically executed in the context of scorecard lifecycle events, such as scorecard creation, update, or completion, where the application must notify the scorecard owner, the manager, or the position supervisor. ETRM records no dependent packages referencing this utility, indicating that it is a leaf-level notification helper consumed by application-level logic.

Customizations should call SEND_NOTIFICATION only as a complete unit, treating the private cursors as implementation details. Because the package performs effective-dated lookups against PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, results depend on the system date at execution and on the integrity of current assignment and supervisor data. Any extension of the get_role logic must preserve the ORIG_SYSTEM = 'PER' convention to remain consistent with the standard role resolution used across Oracle HRMS workflow notifications.