Search Results get_pcard_valid_active_tbl

Overview

PO_PCARD_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, declared with AUTHID CURRENT_USER. It encapsulates the business rules governing Procurement Card (PCard) validation and activation within the Purchasing module. Its central responsibility is to determine whether a given procurement card is valid and active, whether a vendor site accepts PCard payments, and to resolve the correct PCard identifier for a vendor and vendor site combination. The package is classified as OTHER in the ETRM metadata, indicating it is not a public, formally supported open interface API but an internal utility package. The header comment ($Header: POPCARDS.pls 120.0) dates the source to 2005, reflecting the long-standing stability of the logic. The package exposes both scalar and table-based (bulk) variants of its validation routines, allowing callers to validate a single card or process a set of identifiers in one call. Two other packages reference PO_PCARD_PKG, confirming its role as a shared validation layer.

Key Procedures and Functions

• IS_PCARD_VALID_AND_ACTIVE — Returns a Boolean indicating whether the referenced procurement card is both valid and in an active status.
• GET_PCARD_VALID_ACTIVE_TBL — Bulk variant of the above. Accepts a table of PCard identifiers (PO_TBL_NUMBER) and returns a PO_TBL_VARCHAR1 table, allowing set-based validation of multiple cards in a single invocation. This is the specific function the user searched for. It is bracketed by <HTMLAC START> and <HTMLAC END> markers, indicating auto-generated wrapper or HTML integration support.
• IS_SITE_PCARD_ENABLED — Returns a Boolean indicating whether a given vendor and vendor site are enabled for PCard processing.
• GET_SITE_PCARD_ENABLED_TBL — Bulk variant that accepts parallel tables of vendor identifiers and vendor site identifiers and returns a PO_TBL_VARCHAR1 table of enablement flags.
• GET_VENDOR_PCARD_INFO — Returns a numeric value representing PCard-related information for a specified vendor and vendor site.
• GET_VALID_PCARD_ID — Returns the valid procurement card identifier for a supplied PCard ID, vendor ID, and vendor site ID combination, performing cross-validation across those dimensions.

Tables Accessed

• AP_CARDS / AP_CARDS_ALL — The Payables procurement card definition tables. These hold card records, status, and validity attributes that drive IS_PCARD_VALID_AND_ACTIVE and GET_VALID_PCARD_ID.
• AP_CARD_SUPPLIERS — Associates procurement cards with suppliers, supporting vendor and vendor site enablement checks.
• PO_SESSION_GT — A purchasing session global temporary table, typically used to stage session-scoped data during bulk validation calls.
• PLITBLM — A generic PL/SQL table-to-string conversion utility referenced for handling table data types.

Usage Notes

Because PO_PCARD_PKG is classified as OTHER, it is not intended as a supported extension API. It is invoked internally by Oracle Purchasing forms and concurrent programs wherever procurement card eligibility must be evaluated, for example during requisition or purchase order entry when a card is entered or defaulted. The bulk functions are designed for set-based processing, such as validating all cards on a document or batch, and their HTMLAC markers suggest integration with generated HTML/AC wrapper layers for display or reporting. Custom code should invoke these routines only with full awareness of their internal definition, since parameter signatures and behavior are not guaranteed across patches or releases. Developers extending this package should obtain proper change control authorization and regression-test all dependent callers, given its shared use by at least two other packages.