Search Results jdr_docbuilder




Overview
Explore in AI Chat

Overview

The APPS.JDR_DOCBUILDER package body is a component of the Oracle E-Business Suite XML Publisher (BI Publisher) infrastructure, providing programmatic construction, manipulation, and persistence of XML document structures within the JDR (Java Document Repository / XML Publisher data model) framework. In Oracle EBS 12.1.1 and 12.2.2, this package functions as a server-side API for building hierarchical XML documents and elements that are stored in and retrieved from the XML Publisher repository.

The package carries an API classification of OTHER and is validated as VALID in the APPS schema. Its singular role is to abstract the low-level operations of creating documents, managing parent-child element relationships, assigning attributes, and persisting the resulting structures — operations that would otherwise require direct manipulation of the underlying JDR repository tables. This makes it a foundational utility for any EBS component that must generate structured XML output, such as report data models, template processing, and EDI-style document assembly.

Key Procedures and Functions

The ETRM metadata documents 11 procedures and functions within this package body. Their purposes are as follows:

  • CREATEDOCUMENT — Creates a new top-level XML document container within the repository.
  • CREATECHILDDOCUMENT — Creates a subordinate document nested beneath an existing parent document, supporting hierarchical document composition.
  • CREATEELEMENT — Instantiates an XML element node within the document structure.
  • ADDCHILD — Attaches a child element to a specified parent element, establishing the tree hierarchy.
  • SETATTRIBUTE — Assigns an attribute name and value to a document or element node.
  • SETTOPLEVELELEMENT — Designates a particular element as the root or top-level element of the document.
  • DOCUMENTEXISTS — Returns a boolean/indicator confirming whether a named document already exists in the repository.
  • DELETEDOCUMENT — Removes a document and its associated structure from the repository.
  • REFRESH — Synchronizes in-memory document state with the persisted repository representation.
  • SAVE — Commits the assembled document structure to the repository tables.

Tables Accessed

The package references the following tables through APPS synonyms:

  • JDR_ATTRIBUTES — Stores attribute name/value pairs attached to documents and elements via SETATTRIBUTE.
  • JDR_COMPONENTS — Holds the component (document and element) definitions that form the document tree.
  • JDR_PATHS — Maintains path and hierarchy information that maps each element to its position within the document structure.
  • PLITBLM — A PL/SQL internal table type used for bulk processing of document data.

Together these tables constitute the persistent backing store for XML Publisher documents. JDR_COMPONENTS and JDR_PATHS define the structural tree, while JDR_ATTRIBUTES enriches nodes with metadata. The package also draws on internal JDR components such as JDR_MDS_INTERNAL for repository services.

Usage Notes

JDR_DOCBUILDER is typically invoked indirectly rather than called directly by end users. It is referenced by 11 other database objects, indicating its role as a shared internal service consumed by higher-level XML Publisher and JDR packages. Typical invocation paths include concurrent programs that generate XML data models, Oracle Forms-based XML Publisher administration screens, and custom PL/SQL code that must programmatically assemble repository documents. Because several procedures modify persistent repository state, callers should invoke SAVE explicitly to commit changes and REFRESH to reconcile in-memory and stored representations. Direct modification of the underlying JDR tables is discouraged; the package API should be used to preserve repository consistency.