Search Results asp_order_content_provider




Overview
Explore in AI Chat

Overview

ASP_ORDER_CONTENT_PROVIDER is an APPS-owned PL/SQL package in Oracle E-Business Suite (available in 12.1.1 and 12.2.2) whose business purpose is to supply dynamic content to the Sales Agreement Alert. The Sales Agreement Alert operates within the Oracle Workflow notification framework, generating a business event for service or sales agreement records that require attention. Rather than storing static notification text, the Workflow engine calls this package at runtime to assemble the message body from live transactional and party data. In EBS documentation the package is classified as an "OTHER" API type, indicating that Oracle does not expose it as an officially supported public interface, but instead uses it internally as a content provider invoked by the Workflow notification subsystem.

The package header carries the source marker $Header: aspaorcs.pls 120.0 2005/08/19 12:57 axavier noship $, and its history records creation by axavier on 16-Aug-2005. The "noship" annotation in the header indicates the file is not shipped independently through the standard patchship mechanism, consistent with its role as an internal Workflow callback rather than a user-facing API.

Key Procedures and Functions

  • CREATE_CONTENT — The single documented routine in the package. It provides the content for the Sales Agreement Alert (the procedure comment also refers to the Service Alert). It is a standard Oracle Workflow function activity callback, and its signature follows the Workflow engine convention: an item type drawn from WF_ITEM_TYPES, an item key generated from the application object's primary key, an activity instance identifier (actid), a function mode set by the engine as RUN, CANCEL, or TIMEOUT, and a result out parameter returning COMPLETE:SUCCESS or NULL to signal that the activity has completed with the indicated result. The exact parameter list is not reproduced here, and no additional routines are documented.

Tables Accessed

The package reads from four APPS synonyms, which represent the data sources used to assemble the alert content:

  • OE_BLANKET_HEADERS_ALL — the base table of sales blanket agreements; supplies agreement identity and header-level attributes.
  • OE_BLANKET_HEADERS_EXT — the extension table holding additional attribute values for the same blanket headers.
  • HZ_CUST_ACCOUNTS_ALL — the customer account record associated with the agreement, used to identify and address the trading partner.
  • HZ_PARTIES — the party record providing party name and related profile information for the customer.

Together these tables let CREATE_CONTENT resolve a blanket sales agreement to its owning customer and assemble a notification message containing agreement and customer context. No writes to these tables are implied by the metadata.

Usage Notes

ASP_ORDER_CONTENT_PROVIDER is not intended to be invoked directly by users, forms, or concurrent programs. It is called by the Oracle Workflow engine as a function activity during execution of the Sales Agreement Alert workflow. The Notification System passes the item type, item key, activity instance, and function mode; CREATE_CONTENT returns the generated content for the notification and signals completion via the result out parameter. It can also be tested from a Workflow definition or a PL/SQL block executing under the APPS schema. The package is not referenced by any other documented package (referenced-by count of zero), confirming that its consumers are Workflow definitions and not dependent PL/SQL units. Because it is classified as OTHER and carries a "noship" header, customers should treat it as internal and avoid direct dependencies on its signature; any customization should be made through supported Workflow configuration or custom content providers rather than by modifying this package.