Search Results po_tbl_varchar30




Overview
Explore in AI Chat

Overview

PO_PDOI_TYPES is a foundational PL/SQL specification package in the Oracle E-Business Suite Procurement module, declared with AUTHID CURRENT_USER. It belongs to the PO_PDOI (Purchasing Documents Open Interface) family of objects and serves as the central repository of user-defined PL/SQL collection and record type definitions used throughout the Purchasing Document Open Interface processing engine. Rather than performing business transactions directly, the package establishes the strongly typed data structures that carry purchasing document data — headers, lines, line locations, distributions, and price differentials — from the open interface tables into the validation and import logic.

The package declares composite types such as headers_rec_type, whose individual fields are themselves PL/SQL tables. Each field is typed against a shared scalar collection type (for example PO_TBL_VARCHAR30, PO_TBL_NUMBER, PO_TBL_DATE, PO_TBL_VARCHAR2000). The user search term po_tbl_varchar30 resolves directly to these declarations: attributes such as action_tbl, document_num_tbl, doc_type_tbl, vendor_num_tbl, and vendor_site_code_tbl are all defined as PO_TBL_VARCHAR30 columns within the header record type. This type standardizes a thirty-character string array used pervasively across the PDOI code base.

Key Procedures and Functions

The documented procedures in PO_PDOI_TYPES are attribute-initialization utilities. Each one exists to populate, or zero-initialize, the corresponding record structure so that downstream PDOI routines operate on well-formed, fully defined data rather than null collections:

These procedures take no documented public parameter lists; their contract is defined by the record types they populate.

Tables Accessed

ETRM metadata records two referenced objects: DBMS_SQL and PLITBLM. DBMS_SQL is the Oracle-supplied dynamic SQL package, indicating that PDOI type handling supports dynamically constructed statements when flexfield or attribute values must be resolved at runtime. PLITBLM is the Oracle-supplied PL/SQL table management package, used here to manipulate the PL/SQL table structures that back the record field definitions (for example, extending or initializing index-by tables). Because PO_PDOI_TYPES is a type and utility specification, it does not directly read or write the PO interface tables; those accesses occur in the packages that consume its type definitions.

Usage Notes

PO_PDOI_TYPES is referenced by twelve other packages, which underscores its position as a shared dependency within the Purchasing Document Open Interface. It is not typically invoked directly from a form or concurrent program by end users. Instead, it is invoked indirectly: the PDOI import and validation concurrent programs, their associated PL/SQL drivers, and any custom extensions that leverage the PO_PDOI API family all depend on these type declarations and initialization procedures. Developers writing custom PDOI integrations should reference PO_PDOI_TYPES record structures when building payload collections, and must account for the documented maintenance rule — whenever the header record type gains a new attribute, FILL_ALL_HEADERS_ATTR must be revised accordingly, a pattern Oracle applies to each record type in this package.