Search Results val_line_delete

Overview

PO_RFQS_SV is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a server-side API package. Its header declares AUTHID CURRENT_USER, meaning that name resolution and privilege checks are performed against the invoking user rather than the package owner at runtime. The package resides on the purchasing side of the application and provides the RFQ (Request for Quotation) specific Application Program Interfaces used by the sourcing module.

In functional terms, PO_RFQS_SV concentrates the validation and lookup logic that governs the integrity of RFQ headers, RFQ lines and their associated supplier lists. Rather than allowing deletion or update of sourcing documents directly, Oracle EBS routes those operations through validation routines in this package so that business rules such as "printed documents may not be deleted" and "autocreated lines may not be deleted" are enforced consistently across every entry point — the RFQ form, concurrent processing, and any custom extension code.

Key Procedures and Functions

The documented interface exposes eight callable program units, of which four are named explicitly in the package header comments:

• val_header_delete — verifies that the RFQ header selected for deletion has not yet been printed and is not referenced on an existing quotation. If either condition is true, deletion is prohibited and the corresponding out parameter is set to disallow the operation.
• val_line_delete — verifies that the RFQ line selected for deletion has not been autocreated into a quotation. If the line has been autocreated, deletion is prohibited. This is the routine the user searched for under the term "val_line_delete".
• get_vendor_count — returns the number of vendors associated with the RFQ, supporting supplier list display and validation logic.
• val_vendor_site — validates the vendor site supplied against the RFQ, ensuring the site is a legitimate candidate for the sourcing document.
• val_vendor_update — validates whether the vendor information on an RFQ may be updated given the document's current state.

The metadata also records internal helper units such as test_val_header_delete, a diagnostic entry point created alongside the original validation routine. Parameter lists are intentionally not reproduced here; consult the package specification for exact signatures.

Tables Accessed

The package reads and writes through APPS synonyms for the following tables:

• PO_HEADERS and PO_HEADERS_S — the RFQ header and its corresponding DFF/secure views, used to determine printing status and header identity.
• PO_LINES — RFQ line detail, used to detect autocreation to quotations and to validate deletion eligibility.
• PO_RFQ_VENDORS — the association between an RFQ and the suppliers invited to respond.
• PO_VENDOR_LIST_HEADERS and PO_VENDOR_LIST_ENTRIES — the supplier list header and line records used by the vendor site and vendor count routines.

Usage Notes

PO_RFQS_SV is invoked primarily from the RFQ entry form when the user attempts to delete a header or line, and from supplier-list maintenance when vendor sites are added or changed. Because the package is referenced by two other PL/SQL packages in the ETRM inventory, it also functions as a shared validation layer for downstream sourcing logic. Custom code should call these routines in preference to direct DML against PO_HEADERS or PO_LINES, since bypassing them risks allowing deletion of printed or autocreated sourcing documents. The package is server-side only and is not intended for direct client invocation.