Results for “val_reply”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_QUOTES_SV is a server-side validation package in the Oracle E-Business Suite Purchasing module, owned by the APPS schema and holding VALID status in both release 12.1.1 and 12.2.2. Its name follows the EBS convention for a "server validation" (SV) package, indicating that its primary business function is to enforce data integrity rules for supplier quotation and quotation reply records before those records are committed to the database. In the Oracle Purchasing sourcing flow, buyers issue requests for quotations (RFQs) to suppliers, and suppliers or buyers then enter quotation headers, quotation lines, and quotation replies. PO_QUOTES_SV provides the centralized validation logic that the Oracle Forms-based Quotations window and related AutoSource processing call to verify that insertions, updates, and deletions against these records are legal. This prevents orphaned replies, invalid deletions of headers or lines that still carry dependent child records, and inconsistent quotation status transitions. The package is documented as an OTHER-classified API rather than a public, supported interface, which means it is intended for internal use by Oracle Purchasing forms and concurrent logic rather than for direct customer invocation.

Key Procedures and Functions

The documented program units (eleven in total, with the ETRM excerpt listing the principal ones) address the core validation scenarios in the quotation lifecycle:

  • VAL_HEADER_DELETE — validates whether a quotation header can be deleted, checking for dependent lines, replies, or approval records that would be orphaned by removal of the header.
  • VAL_LINE_DELETE — validates whether an individual quotation line can be deleted, ensuring no dependent reply or approval data references the line.
  • VAL_REPLY — validates quotation reply data, confirming required fields and referential integrity before the reply is saved.
  • GET_QUOTE_STATUS — returns the current status of a quotation, supporting status-driven display and processing decisions in the form.
  • GET_FROM_RFQ_DEFAULTS — retrieves default values derived from an associated RFQ, allowing quotation records to be pre-populated consistently with the originating request for quotation.
  • NAME, NAMES, and additional helper units — ancillary name-resolution and utility routines used internally by the validation logic.

Parameter lists are not documented in the available metadata and are intentionally not reproduced here.

Tables Accessed

PO_QUOTES_SV references its base tables through APPS synonyms. Quotation header and line data reside in PO_HEADERS and PO_LINES. Reply and RFQ-sourcing context is read from PO_REQUISITION_LINES, PO_AUTOSOURCE_DOCUMENTS (the AutoSource document registry that matches sourcing rules to documents, which is directly relevant to the search term "po_autosource_documents"), and PO_ASL_DOCUMENTS (approved supplier list documents). Quotation approval state is read from PO_QUOTATION_APPROVALS. Error and debug output is written through PO_MESSAGE_S and DBMS_OUTPUT. These reads support validation of deletions, replies, and defaults.

Usage Notes

The package is invoked primarily by the Oracle Purchasing Quotations form and by AutoSource processing when creating or updating quotation records, and it is referenced by two other database objects within the APPS schema (it is not referenced outside APPS). Because it is an internal validation package rather than a public API, direct calls from custom code are not recommended; customizations should use the supported PO quotation APIs instead. When troubleshooting quotation deletion or AutoSource errors, PO_QUOTES_SV is the object to trace, and DBMS_OUTPUT remains useful for diagnostic purposes.