Search Results pos_supp_classification_pkg




Overview
Explore in AI Chat

Overview

APPS.POS_SUPP_CLASSIFICATION_PKG is a stored PL/SQL package body in the Oracle E-Business Suite Applications schema that manages supplier business classification data and the mapping between supplier records in the TCA (Trading Community Architecture) model and the corresponding supplier records in the Purchasing (PO) model. In EBS 12.1.1 and 12.2.2, supplier information is maintained in two parallel structures: AP_SUPPLIERS and its associated TCA entities, and PO_VENDORS / PO_VENDOR_SITES on the Purchasing side. Classification assignments — the category, business-class, and attribute values that describe a supplier, supplier address, or supplier site — must remain consistent across both models. This package owns the logic that synchronizes those classification assignments, applies defaults, and validates concurrency before changes are committed.

The package is classified as type OTHER (not a public or private API in the traditional sense) and is validated in the APPS schema. It is referenced by four other packages, indicating it functions as a shared internal service used by supplier-related processing rather than being called directly from the user interface.

Key Procedures and Functions

The package body exposes eleven documented procedures and functions:

Tables Accessed

The package reads and writes POS_SUPPLIER_MAPPINGS and POS_SUPPLIER_MAPPING_S (the mapping and mapping shadow tables) to resolve the relationship between TCA supplier identifiers and Purchasing vendor identifiers. Classification data is stored and maintained through POS_BUS_CLASS_ATTR and POS_BUS_CLASS_ATTR_S, with supporting request records in POS_BUS_CLASS_REQS and POS_BUS_CLASS_REQUEST_S. Supplier identity is validated against AP_SUPPLIERS, PO_VENDORS, and HZ_CODE_ASSIGNMENTS. Utility operations use DUAL, and bulk PL/SQL collections such as PO_TBL_DATE, PO_TBL_NUMBER, PO_TBL_VARCHAR30, and PLITBLM support array-based processing. Message formatting and session context rely on FND_MESSAGE and FND_GLOBAL.

Usage Notes

POS_SUPP_CLASSIFICATION_PKG is an internal dependency rather than a documented public API. It is invoked indirectly by supplier forms, supplier classification concurrent programs, and other APPS packages that manage supplier business classifications. Because the "_S" shadow tables and the concurrency validation routine are integral to its design, the package participates in the standard EBS concurrency-control and audit pattern. Customizations should avoid calling these routines directly; instead, they should invoke the higher-level supplier APIs that in turn depend on this package. Any extension that writes to POS_BUS_CLASS_ATTR or POS_SUPPLIER_MAPPINGS outside these procedures risks leaving the TCA and Purchasing representations out of synchronization.