Search Results ap_web_cc_notifications_pkg




Overview
Explore in AI Chat

Overview

AP_WEB_CC_NOTIFICATIONS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name associates it with the Oracle Payables credit card (corporate card) processing flow, specifically the generation of workflow notifications for the self-service credit card application. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the definer, a common convention for application packages that must respect the session's security context.

The package serves the notification layer of the credit card workflow: it produces the message body and document type metadata consumed by the Oracle Workflow notification framework when specific events occur during card issuance and transaction validation. Rather than performing the business transaction itself, the package formats the notification content that a user later views in the Workflow Notification Web page or in the EBS worklist.

Key Procedures and Functions

  • GET_NEW_CARD_NOTIFICATION — Generates the notification document associated with the creation or issuance of a new credit card. It receives a document identifier and display type, and returns the notification content through a CLOB output parameter along with the document type. This is the routine matched by the search term "get_new_card_notification."
  • GET_VAL_ERROR_NOTIFICATION — Produces the notification document raised when validation errors are encountered during credit card processing. Like its counterpart, it accepts a document identifier and display type and returns the CLOB body and document type, allowing the workflow to present descriptive error information to the user.
  • GET_INACTIVE_COUNT — A function that accepts a concurrent request identifier and returns a numeric count of inactive items. It is typically used to determine whether cards or cardholder records have been deactivated, driving conditional notification logic within the workflow.

All three routines are documented in ETRM with classification OTHER. The two notification procedures return content through IN OUT NOCOPY parameters, an efficiency choice that avoids copying large CLOB values.

Tables Accessed

  • AP_CARDS_ALL — Stores the corporate credit card definitions, including cardholder and card program attributes referenced when building new-card notifications.
  • AP_CARD_EMP_CANDIDATES — Holds employee candidates eligible for card assignment, relevant to card issuance and related notifications.
  • AP_CREDIT_CARD_TRXNS_ALL — Contains imported credit card transactions, which underpin validation-error notification content.
  • PLITBLM — The PL/SQL integer table type used for internal collections.

Access occurs through APPS synonyms, consistent with standard EBS coding practice. The package reads card and transaction data to populate notification text; it is not documented as performing direct inserts or updates.

Usage Notes

AP_WEB_CC_NOTIFICATIONS_PKG is invoked indirectly by the Oracle Workflow credit card process rather than being called directly by end users. When a workflow activity requires a notification, the workflow engine calls the appropriate getter procedure, passing the document identifier and display type, and then embeds the returned CLOB in the notification message. This pattern is characteristic of the Payables credit card notifications used in iExpenses and supplier card programs.

The package is documented as referenced by zero other packages, indicating it sits at the outer notification layer of the credit card flow rather than in a shared utility position. Customizations should avoid modifying the package directly; instead, extensions should be implemented through supported workflow customization or a custom package that calls these routines. Because the procedures rely on session privileges, callers must have the necessary access to the underlying AP tables and synonyms. In 12.1.1 and 12.2.2 the object remains an APPS-owned, non-API package intended for workflow-driven notification generation.