Search Results receive_be

Overview

PA_PWP_NOTIFICATION is an Oracle Projects PL/SQL package owned by the APPS schema that supports the Project Workbench/Project Work Plan notification infrastructure. Its principal business function is the generation and delivery of workflow-based notification content regarding project-related financial events, most notably Accounts Receivable (AR) activity such as cash receipts, payment schedules, and receivable applications that affect a project. The package is classified as an OTHER API in the ETRM documentation, indicating that it is an internal utility package rather than an externally callable public API.

The package operates by receiving Oracle Workflow business events, identifying the relevant project manager, assembling notification content (including CLOB-based page content), and dispatching notification messages. This supports the Project Manager Workbench notification capability by keeping project managers informed of AR-related transactions tied to their projects.

Key Procedures and Functions

• RECEIVE_BE — Entry point that receives an Oracle Workflow business event (WF_EVENT_T) and initiates the notification processing logic. This is the standard inbound subscription mechanism for event-driven notification.
• START_AR_NOTIFY_WF — Starts the Accounts Receivable notification workflow process, orchestrating the notification sequence for AR-related project events.
• SELECT_PROJECT_MANAGER — Identifies and returns the project manager for the relevant project, typically resolving the party and person records used as the notification recipient.
• APPEND_VARCHAR_TO_CLOB — Utility routine that concatenates VARCHAR2 content onto a CLOB, supporting the incremental assembly of notification page content that may exceed VARCHAR2 limits.
• SHOW_PWP_NOTIFY_PREVIEW — Produces a preview rendering of the PWP notification content, allowing the assembled page to be reviewed before or independent of delivery.
• GENERATE_PWP_NOTIFY_PAGE — Builds the full HTML/content page that forms the body of the PWP notification delivered to the recipient.

Tables Accessed

The package reads and writes against a documented set of APPS synonym-referenced tables. AR-related tables—AR_CASH_RECEIPTS, AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, and RA_CUSTOMER_TRX—supply the cash receipt, payment schedule, receivable application, and transaction data that trigger and populate notifications. PA_DRAFT_INVOICES and PA_DRAFT_INVOICE_ITEMS provide project draft invoice details, while PA_CUST_REV_DIST_LINES supplies customer revenue distribution lines. PA_PROJECTS, PA_PROJECT_PARTIES, and PA_PROJECT_STATUSES provide project identity, party, and status context. PER_ALL_PEOPLE_F and PA_EMPLOYEES resolve project manager and employee information. FND_USER supports workflow user resolution. WF_EVENT_T carries the incoming business event payload. AP_HOLDS and AP_INVOICES support payable-side invoice and hold context where applicable. Additional references include AR_CASH_RECEIPTS and FND_CURRENCY for currency handling.

Usage Notes

PA_PWP_NOTIFICATION is not intended for direct invocation by external or custom code; it is invoked indirectly through Oracle Workflow event subscriptions, typically when AR transactions affect a project and a project manager notification must be raised. The RECEIVE_BE routine functions as the event subscription handler, while START_AR_NOTIFY_WF drives the notification workflow. The package is referenced by no other documented packages, confirming its role as a terminal notification producer. Customizations should avoid modifying this package and instead extend notification behavior through supported workflow subscription mechanisms. Because the package depends on Workflow event structures and AR/Projects data, deployment and testing should ensure those dependencies are configured in the target environment (12.1.1 or 12.2.2).