Search Results pl_to_sql24




Overview
Explore in AI Chat

Overview

DPP_BPEL_UPDATELISTPRICE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports list price maintenance within the Advanced Pricing (DPP) module. Its header identifies the unit as AUTHID CURRENT_USER, meaning that execution privileges are resolved against the calling schema rather than the defining schema. The package is classified as an OTHER API in the ETRM metadata, reflecting that it is an internal, supporting construct rather than a formally published public interface.

The package serves a bridging role between PL/SQL record structures and SQL-callable object types. It exposes conversion utilities that translate between the PL/SQL record type DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE and its SQL counterpart DPP_LISTPRICE_PVT_DPP_TXN_H12, and between the corresponding line and line-table types. These conversions allow list price transaction data assembled in PL/SQL to be passed through SQL or BPEL-style invocation paths that cannot directly consume PL/SQL-only datatypes. The dated header comment ($Header: dppvbuls.pls 120.1 2007/12/12) and the noship marker indicate the file predates current shipping baselines and is retained for upgrade compatibility.

Key Procedures and Functions

  • PL_TO_SQL22 — Converts a header record of type DPP_TXN_HDR_REC_TYPE into the SQL object type DPP_TXN_H12.
  • SQL_TO_PL22 — Performs the inverse conversion, turning a DPP_TXN_H12 SQL object back into the PL/SQL header record.
  • PL_TO_SQL23 — Converts a line record of type DPP_TXN_LINE_REC_TYPE into the SQL object type DPP_TXN_L14.
  • SQL_TO_PL24 — Converts a DPP_TXN_L14 SQL object back into the PL/SQL line record.
  • PL_TO_SQL24 — Converts a line-table collection of type DPP_TXN_LINE_TBL_TYPE into the SQL collection type DPP_TXN_L13.
  • SQL_TO_PL23 — Converts a DPP_TXN_L13 SQL collection back into the PL/SQL line-table collection.
  • DPP_LISTPRICE_PVT$UPDATE_LIST — The operative public procedure, which drives the list price update. It accepts API-version, message-list, commit, and validation-level controls, returns standard status and message outputs, and consumes the header record together with the item cost or line collection.

Tables Accessed

The documented metadata identifies a single referenced object: the APPS synonym PLITBLM. This synonym maps to the underlying Advanced Pricing list price base table, which stores list price header and line information used when applying price list updates. The package reads and writes list price definitions through this synonym, ensuring that the update procedure operates against the base pricing tables while relying on the conversion functions to marshal the header and line payloads into the format the underlying pricing logic expects.

Usage Notes

Because the package is marked noship and classified as OTHER, it is not intended for direct customer invocation. It is typically called from within Advanced Pricing internal flows — notably price list maintenance and update processing — and from the BPEL-facing integration layer for which the SQL-type conversion functions exist. The no-copy (NOCOPY) output parameters on DPP_LISTPRICE_PVT$UPDATE_LIST indicate that callers should expect standard API status and message handling; commit behavior is governed by the p_commit argument, so custom code that invokes the procedure must manage transactions explicitly. The ETRM metadata records that no other packages reference this unit, confirming its position as a leaf-level internal support package rather than a widely shared utility.