Results for “ast_event_order_pkg”

20 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AST_EVENT_ORDER_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It is classified under the ETRM as an "OTHER" API, meaning it is a supporting program unit rather than a formally published public interface. Its documented business purpose is to create and submit order and quote records in Oracle Order Management and Oracle Quoting on behalf of the Advanced Scheduler / telephony (AST) event processing subsystem. In practice, the package acts as a thin service layer that bridges AST events to the order capture interfaces, allowing quotes and sales orders to be generated programmatically without direct user interaction.

The package body is documented as VALID, with three procedures exposed: OPEN_ORDER, ADD_ORDER_LINE, and SUBMIT_ORDER. It is not referenced by any other database object, which indicates it is a top-level entry point rather than a shared utility invoked by other PL/SQL units.

Key Procedures and Functions

  • OPEN_ORDER — Initializes a new order or quote record. It establishes the header-level context for the order interface structures before any lines are attached. This is the standard first step in the order creation sequence.
  • ADD_ORDER_LINE — Appends one or more line items to the order or quote being assembled. It populates the line-level interface records that describe the item, quantity, and related attributes prior to submission.
  • SUBMIT_ORDER — Commits the assembled order structure to the order capture layer, invoking the downstream Order Management or Quoting interface to create the actual transaction. It is the final step in the three-procedure workflow.

The three procedures are designed to be called in sequence: OPEN_ORDER, then one or more ADD_ORDER_LINE calls, then SUBMIT_ORDER. No parameter lists are documented in the available metadata; the exact signatures should be confirmed by inspecting the package specification in the database.

Tables Accessed

The only table documented as referenced through an APPS synonym is PLITBLM. This is a PL/SQL index-by table type used for in-memory collections, not a physical base table, and it reflects the package's use of PL/SQL collection structures rather than direct SQL against application tables. The actual persistence of order and quote data is delegated to the dependent APIs below.

The package body depends on the following objects:

  • ASO_ORDER_INT — the Order Management public interface used to load and submit order data.
  • ASO_QUOTE_PUB — the Oracle Quoting public API used to create and manage quotes.
  • FND_API — the standard Oracle Applications API framework, providing the global constants and helper routines used for API conformance and error handling.
  • FND_MSG_PUB — the standard message handling package for retrieving and reporting API messages to the calling layer.
  • AST_EVENT_ORDER_PKG — self-reference within the package body.

Usage Notes

AST_EVENT_ORDER_PKG is intended to be invoked programmatically rather than through a standard concurrent program or form. Typical callers are custom wrappers, event-driven handlers, or the AST telephony/event subsystem itself, which assemble an order or quote request and then submit it through this package. Because the package depends on FND_API and FND_MSG_PUB, calling code should follow the standard Oracle API error-handling pattern: initialize the message stack with FND_MSG_PUB.INITIALIZE, invoke the procedures, and check the return status and message stack for errors before proceeding. This behavior applies to both 12.1.1 and 12.2.2, as the underlying dependency set is unchanged. Given the limited documented metadata and the absence of references from other database objects, any implementation should verify the exact package specification and the expected parameter structures in the target environment before use.