Search Results get_vendor_defaults




Overview
Explore in AI Chat

Overview

APPS.PO_VENDORS_SV is an Oracle E-Business Suite server-side PL/SQL package that supports supplier (vendor) validation and defaulting within the Purchasing application. The suffix "SV" indicates a "server validation" package, a convention used extensively in Oracle EBS to encapsulate validation logic invoked from Oracle Forms, concurrent programs, and other PL/SQL units. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, which is consistent with its role as a shared utility invoked across the application.

The package primarily serves the supplier entry and maintenance workflow, particularly the Supplier form and the purchase order entry path. Its core responsibility is to determine whether a supplier is still active and to retrieve the default attributes that govern purchasing and invoicing behavior for that supplier, falling back to supplier site level values where appropriate. The source header dates back to 1995, reflecting its long-standing role in the Purchasing module.

Key Procedures and Functions

The documented package exposes 18 procedures and functions. The principal ones are:

  • VAL_VENDOR — Checks whether a given supplier is still active. Returns a Boolean result indicating supplier validity.
  • GET_VENDOR_DEFAULTS — Retrieves the vendor attributes for a given supplier. If a default vendor site exists, it returns the site-level information; if no default site exists, vendor-level validation is deferred since values will likely be overridden by site information. Where a default site exists, the site-level value is validated first, and only if invalid does the logic fall back to the vendor-level value.
  • VAL_SHIPPING_CONTROL — The procedure matching the user's search term. It validates the shipping control attribute for a supplier, confirming that the shipping control value is valid and acceptable for the purchasing context.
  • GET_TERMS_CONDITIONS — Retrieves the payment terms conditions associated with the supplier or vendor site.
  • GET_TERMS_DSP — Returns the displayed (formatted) value of the payment terms for presentation in the user interface.
  • GET_TERMS — Retrieves the payment terms identifier or associated value for the supplier.
  • TEST_GET_VENDOR — A diagnostic/testing entry point used to exercise the vendor defaulting logic.
  • NAME — Resolves the supplier name for a given supplier record.

Tables Accessed

The package references the following tables through APPS synonyms:

  • AP_TERMS — Read to validate and resolve payment terms (terms_id) and to obtain the displayed terms description.
  • PO_HEADERS_ALL — Accessed to support purchasing document context, including document type determination used by the defaulting logic.
  • ORG_FREIGHT — Used for freight terms and shipment-related validation, including shipping control and ship-via information.
  • DBMS_SQL — An Oracle-supplied dynamic SQL package, indicating that portions of the validation logic build and execute dynamic SQL statements at runtime.

Together these tables supply the validation and defaulting data needed to confirm supplier status and to prime purchasing attributes such as currency, freight terms, FOB, ship-via, and terms.

Usage Notes

PO_VENDORS_SV is typically invoked from Oracle Forms during supplier entry and amendment, and from the purchase order entry forms where supplier defaults are propagated into the document. It may also be called from concurrent programs and custom PL/SQL code that require supplier validation or defaulting. Because the package is referenced by 19 other packages, it functions as a shared dependency in the Purchasing module and should be treated as an internal, non-public API. Customizations should not call undocumented internals directly; instead, supplier data should generally be manipulated through the supported supplier and purchasing APIs. Any change to this package carries broad impact due to its many dependents.