Search Results ntf_table

Overview

AP_WEB_CC_NOTIFICATIONS_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under ETRM as an "OTHER" API. It resides in the Oracle Payables (AP) module and supports the Oracle iExpenses / Payables credit card (corporate card) web notification infrastructure. The package is deployed in both EBS 12.1.1 and 12.2.2, and its header comment ("$Header: apwcnotb.pls 120.2 2005/10/02") confirms it is an older, stable web-tier utility body rather than a customer-facing business API.

The business function of the package is to generate formatted HTML notification content for the credit card processing flows. It acts as a presentation-layer helper: rather than embedding hard-coded HTML markup in notification logic, it centralizes the construction of Browser Look-and-Feel (BLAF) style tables and the substitution of card-level data into those templates. In this sense the body is a notification/rendering engine that produces the body text of workflow or e-mail notifications sent to employees, card administrators, and expense users regarding credit card status.

Key Procedures and Functions

The documented public procedures and functions are:

• GET_NEW_CARD_NOTIFICATION — Builds the notification payload used when a new corporate card is issued or assigned to an employee. It assembles the relevant card and employee-candidate information into the standard notification format.
• GET_VAL_ERROR_NOTIFICATION — Produces the notification content triggered when validation errors occur during credit card processing, such as mismatches or rejected card/transaction records. This allows the error condition and context to be delivered to the appropriate recipient.
• GET_INACTIVE_COUNT — Returns a count of inactive card or candidate records. This is used to feed notification summaries or reporting text that indicate how many records have become inactive and may require attention.

Internally, the body also defines a notable private helper, NTF_TABLE, which is the construct the user searched for. NTF_TABLE generates BLAF-like HTML tables for notifications, achieving ADA compliance through the scope attribute. Its inputs include an array of table cells, a column count, and a two-character type code: the first character determines header position and table orientation (V for vertical, H for horizontal, N for a mailer notification header table), while the optional second character specifies Bi-Directional direction (L for left-to-right default, R for right-to-left). Private package variables define layout constants such as alignment, table direction, width, border, cell padding, spacing, background colors, font faces, and font sizes.

Tables Accessed

ETRM documents four underlying tables referenced through APPS synonyms:

• AP_CARDS_ALL — The base corporate card definition table; read to retrieve card attributes for new-card notifications.
• AP_CARD_EMP_CANDIDATES — Holds employee candidates associated with cards; used to resolve recipients and to derive inactive counts.
• AP_CREDIT_CARD_TRXNS_ALL — The credit card transactions table; referenced in error notification logic to describe transaction-related validation failures.
• PLITBLM — A generic APPS storage table (commonly used for temporary or message-related content) accessed during notification processing.

Usage Notes

AP_WEB_CC_NOTIFICATIONS_PKG is invoked from the Oracle Payables credit card web flows rather than being called directly by end users. Typical callers include Oracle Workflow notification activities and web-tier PL/SQL that prepare notification bodies and subject text. The package is referenced by zero other documented packages, indicating it is a leaf-level helper within the credit card notification stack. Customizations should avoid modifying this seeded body; instead, extensions should wrap the documented public functions or use supported notification templates, since the internal NTF_TABLE helper and its private style variables are not part of the public API contract.