Search Results po_coo_s




Overview
Explore in AI Chat

Overview

PO_COO_S is an Oracle E-Business Suite PL/SQL specification package owned by the APPS schema that provides country-of-origin defaulting logic for the Oracle Purchasing application. Its sole documented member, GET_DEFAULT_COUNTRY_OF_ORIGIN, encapsulates the business rules that determine which country of origin should be associated with an item when it is procured from a given supplier, supplier site, and ship-to organization. The package is declared with AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the calling schema rather than the definer, an important consideration for organizations that invoke it from custom code or from tightly controlled database sessions.

The header comment embedded in the specification indicates that the source file POXRCOOS.pls was last revised under version 115.4, which reflects a stable code line dating from the early 2000s and carried forward into the 12.1.1 and 12.2.2 releases. Because the package exposes only a specification with a single defaulting procedure, its role is narrowly scoped: it centralizes the derivation of country-of-origin information so that multiple Purchasing flows obtain consistent results rather than reimplementing the logic independently.

Key Procedures and Functions

The package documents one public program unit:

  • GET_DEFAULT_COUNTRY_OF_ORIGIN — Returns the default country of origin for a given sourcing context. Based on the parameter names visible in the package specification, the procedure accepts inputs identifying the item, the ship-to organization, the supplier, and the supplier site, and returns the resolved country of origin through an IN OUT NOCOPY VARCHAR2 parameter. The procedure determines the applicable default by consulting approved supplier list configuration before returning a value to the caller. No additional public functions or procedures are documented for this package, and no overloads are exposed in the specification.

Tables Accessed

The package reads from a single documented table, accessed through its APPS synonym:

  • PO_ASL_ATTRIBUTES — The Approved Supplier List attributes table, which stores sourcing-specific attributes keyed to an item, supplier, supplier site, and owning organization. This is the logical source of country-of-origin defaults, since country of origin is maintained as an approved supplier list attribute in Oracle Purchasing. The procedure queries this table using the supplied item, ship-to organization, vendor, and vendor site identifiers to retrieve the configured country, then returns it to the calling process. The specification does not document any write operations against this table, indicating the procedure performs read-only lookups.

Usage Notes

PO_COO_S is referenced by four other packages within the E-Business Suite, which confirms that it is an internal utility relied upon by higher-level Purchasing APIs rather than an end-user-facing entry point. It is typically invoked during document creation and validation flows — for example, when purchase orders, requisitions, or sourcing documents need a country-of-origin value populated without user intervention. The procedure is equally suitable for direct invocation from custom PL/SQL and concurrent programs that must reproduce standard Purchasing defaulting behavior.

Callers should note several practical points. First, because the package uses AUTHID CURRENT_USER, the invoking schema must itself have access to PO_ASL_ATTRIBUTES or its APPS synonym; invocations from restricted schemas may fail unless appropriate grants exist. Second, the country-of-origin output is passed as an IN OUT NOCOPY parameter, so callers should initialize the variable and be aware that the procedure may return an unchanged or empty value when no approved supplier list attribute is configured for the supplied combination. Third, because the package has remained at version 115.4 across releases, behavior is consistent between 12.1.1 and 12.2.2, and no Multi-Org or MOAC-specific changes are documented. Organizations extending Purchasing should treat this package as the authoritative source for country-of-origin defaulting logic and avoid duplicating its rules in custom code.