Search Results get_notifications

Overview

BIS_PMV_APPROVALS_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Process Manufacturing Viewer (PMV) framework, a set of Business Intelligence System (BIS) components that render read-only analytical pages against transactional data. The package supplies the approval-related data source for PMV dashboards, assembling the SQL and column attributes required by the BIS viewer runtime to display outstanding workflow approvals and their details.

The package was initially created on 02-DEC-2005 by nkishore and was last shipped with the header revision BISAPPVB.pls 120.0.12000000.1 dated 19-JAN-2007. A dbdrv checkfile directive referencing revision 115.13 confirms the file is versioned and deployed through the standard AD patch driver mechanism. Because the package is classified as a PVT (private) API, it is not intended for direct invocation by customers or third-party code; it is an internal component of the PMV page rendering stack.

Key Procedures and Functions

The package exposes two documented procedures. Both are designed to be called by the BIS viewer engine rather than by end users.

• APPROVALS_SQL — Generates the custom SQL statement and associated query attribute definitions that drive the PMV approvals page. Internally it assembles a WHERE clause over approval types, resolves display URLs, and constructs lookup-driven bind variables and meaning tables. A notable internal cursor, GET_NOTIFICATIONS, is defined within this procedure; it queries WF_NOTIFICATIONS joined to WF_NOTIFICATION_ATTRIBUTES to count open notifications per message type for the current user, filtering on the recipient role resolved through WF_USER_ROLES and FND_GLOBAL.USER_NAME. A second cursor, GET_APPROVAL_TYPES, reads the BIS_PMV_APPROVAL_TYPES lookup to enumerate the approval categories presented on the page. This GET_NOTIFICATIONS cursor is the construct most closely associated with the search term "get_notifications."
• APPROVALS_DETAIL_SQL — Produces the drill-down SQL and attributes used when a user navigates from the summary approvals page into the supporting detail. It follows the same BIS custom-SQL contract as APPROVALS_SQL, returning a query string and an attribute collection that the viewer consumes to render the detail region.

Tables Accessed

The package reads from the following APPS synonyms:

• FND_LOOKUP_VALUES — Supplies the approval type codes and their user-facing meanings via the BIS_PMV_APPROVAL_TYPES lookup type, allowing the page to present configurable approval categories.
• WF_NOTIFICATIONS — The primary source of open workflow notifications. The package filters on status 'OPEN' and on the recipient role belonging to the current user.
• WF_NOTIFICATION_ATTRIBUTES — Provides attribute rows joined to WF_NOTIFICATIONS to produce the detail-level data for the drill-down view.
• PLITBLM — A standard PL/SQL integer table type used for bind-variable handling within the dynamic SQL construction.

All access is read-only; the package does not commit or modify data.

Usage Notes

BIS_PMV_APPROVALS_PVT is invoked indirectly through the PMV approvals dashboard pages, which are typically reached from the Process Manufacturing Viewer menu or embedded in a framework region. The BIS runtime calls the procedures at page render time, passing the page parameter table and receiving the generated SQL and attribute collections. Because the package is classified PVT, it should not be called directly from custom forms, concurrent programs, or client extensions; supported customization is achieved through the underlying lookup configuration (BIS_PMV_APPROVAL_TYPES) and role membership rather than by modifying package logic. The ETRM metadata records no other packages referencing this object, confirming its role as a leaf consumer within the BIS stack.