Results for “check_asl_action”

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

Overview

PO_ASL_SV is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite release 12.1.1 and 12.2.2. The suffix "SV" denotes a validation or view-support package, and PO_ASL_SV operates within the Approved Supplier List (ASL) subsystem of Oracle Purchasing. Its business purpose is to resolve and validate supplier sourcing data — determining which suppliers, manufacturers, and sourcing rules are approved for a given inventory item, organization, and category combination. ASL data underpins both transactional purchasing and planning activities, so this package functions as a shared reference layer consumed by Purchasing forms, Oracle Planning, and the sourcing APIs.

The object holds a VALID status and is classified as OTHER in the API taxonomy, indicating it is an internal support package rather than a published public API. It depends directly only on SYS.STANDARD, confirming that it is a lightweight package whose substantive work is performed through SQL against ASL and inventory tables.

Key Procedures and Functions

The documented interface exposes 8 procedures and functions, of which two are named in the metadata:

• NAMES — a plural routine, consistent with resolving or returning multiple ASL attribute names, likely iterating a set of validated sourcing attribute identifiers.
• NAME — the singular counterpart, returning a single resolved name for an ASL attribute, status, or sourcing element.

The remaining six routines are not individually documented in the ETRM extract. Given the package's role, they are presumed to provide supporting validation and lookup logic used internally by the two named entry points. No parameter lists are documented, and none should be assumed; the named routines should be treated as internal utilities rather than a stable extension point.

Tables Accessed

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

• PO_APPROVED_SUPPLIER_LIST, PO_ASL_ATTRIBUTES, PO_ASL_STATUSES — the core ASL tables holding approved supplier records, attribute assignments, and status definitions. These are the primary data sources for validation.
• MTL_SYSTEM_ITEMS_KFV, MTL_ITEM_CATEGORIES, MTL_CATEGORIES_KFV — key flexfield views supplying item and category context for ASL resolution.
• MTL_MANUFACTURERS — resolves manufacturer names associated with ASL entries.
• MTL_PARAMETERS — supplies inventory organization defaults.
• FND_LOG_MESSAGES, FND_NEW_MESSAGES — the standard EBS logging and message framework used for diagnostics.
• PLITBLM — a generic PL/SQL index-by table used for bulk name resolution.
• CHV_CUM_PERIODS — cumulative period data supporting supplier scheduling validations.

Usage Notes

PO_ASL_SV is referenced by 18 other database objects, giving a clear picture of its callers. On the Purchasing side, it is consumed by PO_APPROVED_SUPPLIER_LIST_SV, PO_ASL_THS, PO_ASL_UPGRADE_SV2, and POR_AUTOSOURCE_UTIL_PKG, indicating use during ASL maintenance, upgrade processing, and autosource rule evaluation. On the planning side, it is referenced by MRP_SOURCING_API_PK, MRP_SOURCING_GRP, and the MRP sourcing views, which resolve approved suppliers for sourcing decisions.

The package is typically invoked implicitly — from ASL and sourcing forms, from supplier scheduling via CHV_CONFIRM_SCHEDULES, and from concurrent sourcing and planning programs — rather than being called directly. Because it is an internal validation package with no documented parameter interface, custom code should not depend on it directly; developers requiring ASL data should use the supported Approved Supplier List public APIs or the ASL views instead. As with all APPS-owned support packages, any customization should be confined to wrapper packages to remain upgrade-safe across 12.1.1 and 12.2.2.