Search Results fill_all_attr_values_tlp_attr




Overview
Explore in AI Chat

Overview

APPS.PO_PDOI_TYPES is a foundational PL/SQL package body in Oracle E-Business Suite that supports the Purchasing Documents Open Interface (PDOI). Its principal business function is to provide the type definitions and initialization utilities that populate the PL/SQL index-by tables used throughout the PDOI import process. Purchasing documents — requisitions, purchase orders, blankets, and contracts — must be loaded into EBS through a prescribed interface that maps flat interface tables into normalized base tables. Before any row-level validation or insertion can take place, the associated collection structures must be sized and initialized so that the loading logic can reference consistent, fully populated arrays.

The package accomplishes this by declaring a family of private overloaded fill_tbl procedures, each accepting a record count and an IN OUT NOCOPY collection of a specific scalar type (number, date, varchar1, varchar5, varchar30, varchar100, varchar2000). These private helpers are invoked by the public FILL_ALL_*_ATTR procedures to ready every column of a record type simultaneously. The user search term "fill_all_headers_attr" corresponds to this package's public entry point for that purpose.

Key Procedures and Functions

  • FILL_ALL_HEADERS_ATTR — Initializes all PL/SQL tables within the header record type, accepting a record count and the header record of tables as IN OUT. This is the procedure users invoke to prepare the header collection prior to importing document headers.
  • FILL_ALL_LINES_ATTR — Prepares the line-level collections, sizing and initializing the table attributes that hold purchase order or requisition line data.
  • FILL_ALL_LINE_LOCS_ATTR — Initializes the shipment or line location level collections, corresponding to the scheduling and delivery attributes of each line.
  • FILL_ALL_DISTS_ATTR — Readies the distribution-level collections, used for accounting distributions attached to each shipment.
  • FILL_ALL_PRICE_DIFFS_ATTR — Initializes the price differential collections that store tiered or bracket pricing information on a document line.
  • FILL_ALL_ATTR_VALUES_ATTR — Prepares the descriptor and attribute-value collections for the flexfield or descriptive flexfield style attributes associated with the document.
  • FILL_ALL_ATTR_VALUES_TLP_ATTR — Performs the same initialization for attribute values at the TLP (tax, land, or price-related layer) level, mirroring the descriptor collection for the corresponding document tier.

Tables Accessed

The package references the PLITBLM package and DBMS_SQL via APPS synonyms. PLITBLM (PL/SQL Index Table Library Management) provides the underlying collection allocation and resizing utilities that the fill_tbl overloads rely on, while DBMS_SQL is used for dynamic SQL operations where the package must interact with structures not known statically. No base purchasing tables are read or written by PO_PDOI_TYPES itself; its role is strictly foundational, populating in-memory collections that other PDOI packages then consume when inserting into PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, and the associated interface tables.

Usage Notes

PO_PDOI_TYPES is not typically invoked directly by end users or standard concurrent programs. Rather, it is called by the broader PDOI processing packages — referenced by approximately twelve other packages in the APPS schema — which invoke FILL_ALL_HEADERS_ATTR and its sibling procedures before loading records. Custom integrations that extend the standard Purchasing Documents Open Interface should follow the same pattern: call the relevant FILL_ALL_*_ATTR routine with the desired record count to pre-size the collection, then populate and pass that structure into the standard PDOI validation and import APIs. Because the procedures operate purely on PL/SQL collections, they carry no direct transactional or database-write side effects, making them safe to invoke repeatedly during batch loads and in custom EBS 12.1.1 and 12.2.2 deployments.