Search Results psv_ntf_api

Overview

PQH_FR_WF_NTF is an Oracle E-Business Suite package owned by APPS and classified under the general "OTHER" API category. It belongs to the Public Sector / Human Resources (PQH) product family and is specifically associated with the French HR (FR) localization and Oracle Workflow notification processing. Its primary business purpose is to generate and route notifications related to HR validation events, and to support Workflow-driven message resolution. The package acts as a bridge between HR validation logic and the Oracle Workflow notification framework, allowing validation outcomes to be communicated to the appropriate recipients through standard Workflow mechanisms. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user and relies on the APPS synonym layer for access to underlying data.

Key Procedures and Functions

• PSV_NTF_API — The notification API procedure. It accepts a validation identifier and a person identifier, together with optional role, user, and comment attributes. It further accepts up to ten generic parameter name/value pairs (p_param1_name through p_param10_value), which allow the calling context to pass variable substitution data into the notification. This procedure is the principal entry point for creating HR validation notifications, resolving recipient identity details, and forwarding the assembled message content to the Workflow notification subsystem.
• WHICH_MESSAGE — A standard Oracle Workflow function-mode procedure designed to be invoked by the Workflow engine. It receives the Workflow item type, item key, activity identifier, and function mode, and returns a result through an OUT parameter. Its role is to determine or route which notification message should be produced for the given Workflow activity — the function that the user's search term "which_message" refers to. This mirrors the conventional Workflow "Which Message" callback pattern used to select and return message content dynamically.

Tables Accessed

The package accesses several tables through APPS synonyms:

• FND_USER — used to resolve user-name and user-identifier information when directing notifications to specific Workflow recipients.
• PER_ALL_PEOPLE_F — the HR people table, consulted to resolve the person associated with the validation event and to derive recipient details.
• PQH_FR_VALIDATION_EVENTS — the French HR validation event table, which holds the validation records that trigger notification processing. The validation ID passed into PSV_NTF_API corresponds to a record in this table.
• PQH_FR_WF_NOTIFICATION_S — the notification staging/reference table that stores the message definitions or notification details used when assembling outbound Workflow messages.
• DUAL — a standard Oracle construct used for single-row computations and value evaluation.

Usage Notes

PQH_FR_WF_NTF is typically invoked from within the French HR validation business flow, where a validation event must generate a notification to a responsible party. PSV_NTF_API is the callable entry point used by forms, concurrent programs, or custom PL/SQL code when a validation notification needs to be raised. WHICH_MESSAGE, by contrast, is not called by application code directly; it is registered as a function activity in an Oracle Workflow process and is invoked by the Workflow engine whenever that activity is encountered. The ETRM metadata records that the package is referenced by zero other packages, indicating it sits at the edge of the dependency graph and is driven primarily by Workflow configuration and direct application invocation rather than being reused as a shared utility. Because it uses AUTHID CURRENT_USER, callers must possess the necessary privileges on the referenced objects and APPS synonyms. In Oracle EBS 12.1.1 and 12.2.2 the package version and header path are consistent, and no documented replacement API exists within the ETRM record.