Search Results xdp_procedure_builder_util




Overview
Explore in AI Chat

Overview

XDP_PROCEDURE_BUILDER_UTIL is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It supports the Oracle Advanced Planning and Scheduling (APS) / Supply Chain Planning footprint, specifically the XDP module that governs procedure, macro, and constraint definitions used by planning engines. Its classification as a utility package indicates that it provides shared helper routines consumed by other packages rather than exposing an end-user API of its own. The package operates as a foundational layer beneath XDP_PROCEDURE_BUILDER and XDP_MACROS, supplying the parsing, substitution, validation, and translation logic needed when procedure and macro definitions are generated, imported, or resolved at runtime.

Key Procedures and Functions

The documented interface exposes eight procedures and functions that fall into four functional pairs:

  • REPLACEORDERPARAMETERS — Substitutes ordering-related parameter placeholders within procedure text, resolving them to concrete values before execution.
  • VALIDATEFPPARAMETERS — Validates fast-plan (FP) parameters associated with a procedure definition, ensuring required parameters are present and well-formed.
  • REPLACEFEATTRIBUTES — Replaces feature-attribute tokens in procedure or macro bodies with values drawn from the feature attribute definitions.
  • VALIDATEFEATTRIBUTES — Validates feature-attribute references so that only correctly defined attributes are accepted for substitution.
  • TRANSLATEDEFMACROS — Translates default macro definitions into their executable or canonical form.
  • TRANSLATEFPMACROS — Translates fast-plan macros, mirroring the default-macro logic for the FP macro set.
  • TRANSLATECONNMACROS — Translates connection macros used when procedure definitions reference external or linked data sources.
  • TRANSLATEDISCONNMACROS — Translates disconnection macros that release or terminate those connections.

Together these routines implement a token-substitution and validation pipeline: parameters and attributes are validated, then macro and parameter tokens are translated and replaced to yield runnable procedure text.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • XDP_FA_PARAMETERS — Stores fast-plan parameter definitions used by the parameter validation and replacement routines.
  • XDP_FE_ATTRIBUTE_DEF — Holds feature attribute definitions consulted by the attribute validation and replacement routines.
  • XDP_FE_SW_GEN_LOOKUP — Provides lookup values for software-generation feature attributes, supporting attribute resolution.
  • PLITBLM — The standard PL/SQL intermediate table used for parsing and buffer manipulation during text transformation.

These tables supply the metadata required to resolve tokens safely and consistently across procedure definitions.

Usage Notes

XDP_PROCEDURE_BUILDER_UTIL is referenced by XDP_MACROS and XDP_PROCEDURE_BUILDER, and it also recurses into itself. In practice it is invoked indirectly whenever procedure or macro definitions are built, imported, or executed, rather than being called directly from forms or concurrent programs. Because it depends only on SYS.STANDARD and the XDP tables noted above, it is lightweight and safe to call from custom code that must resolve procedure tokens or validate FP parameters. Developers extending the XDP planning configuration should call the documented procedures rather than reimplementing substitution logic, ensuring consistency with Oracle's macro translation and attribute validation behavior across EBS 12.1.1 and 12.2.2.