Search Results show_pwp_notify_preview

Overview

PA_DCTN_APRV_NOTIFICATION is an Oracle Projects PL/SQL package that supports the deduction approval workflow within Oracle E-Business Suite. Deductions in Oracle Projects represent reductions applied against project-related costs, invoices, or funding, and their approval typically requires managerial review. This package encapsulates the notification and preview logic used by the workflow that routes deduction approval requests to the appropriate project manager.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner. In ETRM it is classified as an "OTHER" API, indicating it is an internal supporting package rather than a formally published public API. The header file identifier (PADTNWFS.pls, version 120.0.12010000.1, dated July 2009) places its most recent baseline in the 12.1.x code line, and it remains present in the 12.2.2 environment. The object is referenced by one other package, confirming its role as a dependent helper rather than a top-level entry point.

Key Procedures and Functions

The package exposes seven documented procedures that together cover workflow initiation, notification rendering, and error display:

• START_DCTN_APRV_WF — Initiates the deduction approval workflow for a given deduction request. This is the primary entry point invoked when a deduction requires approval routing.
• SELECT_PROJECT_MANAGER — A workflow-standard callback procedure that determines the project manager recipient for the approval notification. It aligns with the project manager lookup logic embedded in the package cursors.
• APPEND_VARCHAR_TO_CLOB — A utility that concatenates VARCHAR2 content onto a CLOB buffer, used to assemble large notification message bodies without VARCHAR2 length limits.
• SHOW_PWP_NOTIFY_PREVIEW — Renders a preview of the notification content, allowing the approval message to be displayed before or during workflow processing.
• GENERATE_DCTN_APRV_NOTIFY — Produces the actual notification content for the deduction approval, drawing on project, deduction header, and manager information.
• SUBMIT — Submits the workflow or notification processing step as part of the approval cycle.
• SHOW_ERROR — Displays error information. This is the procedure most relevant to the "show_error" search: it surfaces error messages raised during workflow or notification generation, typically by populating the error stack, stage, and code OUT parameters used by Oracle Workflow error handling conventions (x_err_stack, x_err_stage, x_err_code).

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• PA_PROJECTS — Source of project number, name, dates, type, organization, and status for the notification body.
• PA_DEDUCTIONS_ALL — Holds the deduction request header identified by deduction_req_id; the driver record for the approval.
• PA_PROJECT_PARTIES — Used to resolve the project manager (project role 1, resource type 101) for the approval recipient.
• PER_ALL_PEOPLE_F — Joined to validate the manager's effective employment record.
• FND_USER — Resolves the manager's application user name for notification delivery.
• FND_NEW_MESSAGES — Supports notification message assembly and preview.
• PA_CONTROL_ITEMS, PA_PAGE_CONTENTS — Provide page and control item content used in the notification preview.
• PA_WORKFLOW_ITEMKEY_S — Generates or tracks workflow item keys for the approval instance.
• DBMS_LOB — Oracle-supplied package used for CLOB manipulation in APPEND_VARCHAR_TO_CLOB.

Usage Notes

PA_DCTN_APRV_NOTIFICATION is invoked indirectly by the Oracle Projects deduction approval workflow rather than by end users. Typical invocation occurs when a deduction request is submitted for approval and the workflow engine calls START_DCTN_APRV_WF, then subsequently calls SELECT_PROJECT_MANAGER, GENERATE_DCTN_APRV_NOTIFY, and SUBMIT as the process advances. SHOW_PWP_NOTIFY_PREVIEW supports the notification preview function, often reached from the Projects forms notification or preview action. SHOW_ERROR is called when a workflow activity encounters an exception, allowing the error stack, stage, and code to be captured and displayed to the user or logged. Because the package is AUTHID CURRENT_USER and not a published API, customizations should avoid direct calls; instead, integrate at the workflow or concurrent program level. The hardcoded SQL_DATE format masks (for example, 'YYYY/MM/DD HH24:MI:SS') embedded in the source indicate the notification formatting expectations and should be respected if the package is extended.