Search Results create_pon_back_req_dist




Overview
Explore in AI Chat

Overview

PO_AUTO_LINE_PROCESS_PVT is a private PL/SQL package in the APPS schema that forms part of the Oracle Purchasing AutoCreate feature set. AutoCreate allows buyers to generate purchase order and release lines automatically from approved requisitions, sourcing rules, and other demand sources. Within that architecture, PO_AUTO_LINE_PROCESS_PVT performs the core line-level processing: it prepares interface records for processing, fetches and defaults line attributes, applies currency conversion, and writes the resulting draft records into the temporary interface tables that feed the AutoCreate workflow.

As a PVT-classified package, it is an internal implementation component not intended as a public API. It is invoked by higher-level AutoCreate packages rather than being called directly by external code. The ETRM metadata confirms it is referenced by PO_AUTOCREATE_MAINPROC_PVT and PO_AUTO_LINE_LOC_PROCESS_PVT, and it also references itself, indicating a recursive or iteratively invoked processing pattern. The package depends on the AutoCreate type definitions in PO_AUTOCREATE_TYPES and the SYS.STANDARD package.

Key Procedures and Functions

  • SETUP_INTERFACE_DATA — Initializes the draft/interface structures used during line processing, establishing the working set of records that downstream procedures consume.
  • FETCH_LINES — Retrieves candidate line data (from requisitions and related sources) for AutoCreate processing.
  • DERIVE_AND_DEFAULT_LINES — Computes derived and defaulted attribute values for fetched lines, applying sourcing and item defaults.
  • DO_CURRENCY_CONVERSION — Performs currency conversion on line amounts using established exchange-rate logic and FND_CURRENCIES data.
  • MERGE_TO_PRICE_DIFF_DRAFT — Merges processed records into the price-difference draft structure for downstream validation.
  • MERGE_TO_ATTR_VALUES_DRAFT — Merges attribute values into the attribute-values draft tables.
  • CREATE_PON_BACK_REQ_DIST — Creates back-requisition distribution records, linking AutoCreate output back to originating requisition demand.

Tables Accessed

The package reads and writes both interface and base tables. Interface and draft tables include PO_ATTR_VALUES_INTERFACE, PO_ATTR_VALUES_TLP_INTERFACE, PO_ATTRIBUTE_VALUES_DRAFT, PO_ATTRIBUTE_VALUES_TLP_DRAFT, and PON_AWARD_ALLOCATIONS, which hold staged attribute and award allocation data. It reads master and reference data from MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_GRADES, MTL_UNITS_OF_MEASURE, HR_LOCATIONS_ALL, FND_CURRENCIES, and FINANCIALS_SYSTEM_PARAMS_ALL to source items, grades, units of measure, locations, currency codes, and system parameters. It also writes to PO_DISTRIBUTIONS_ALL and the PO_ATTRIBUTE_VALUES_S / TLP_S series, completing the distribution and attribute records for generated lines.

Usage Notes

This package executes as part of the AutoCreate concurrent program flow, driven by PO_AUTOCREATE_MAINPROC_PVT and line-location processing packages. It is not exposed through a form and should not be called directly by custom code; any customization should occur through supported AutoCreate extension points or the public requisition-to-PO APIs. Because it operates on draft and interface tables, its behavior is tightly coupled to the AutoCreate run context, and failures typically surface as AutoCreate exceptions or rejected interface rows. The object is VALID in both 12.1.1 and 12.2.2; the documented procedures and table dependencies remain consistent across these releases.