Search Results ap_card_database_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_CARD_DATABASE_PKG is a package in the Oracle E-Business Suite Payables (AP) module whose name identifies it as a database support package for the corporate card functionality. Corporate cards allow employees to charge business expenses against a company-issued card; the associated transactions are loaded into Payables, reconciled against employee expense reports, and settled through the card issuer. The package provides the underlying PL/SQL plumbing that the Oracle Forms-based corporate card user interface relies upon for querying card programs, resolving currencies and chart of accounts information, retrieving employee data, and preparing HTML/JavaScript output for the embedded card administration pages. The package is owned by APPS and is VALID in the documented ETRM 12.2.2 repository. Its API classification is OTHER, indicating it is not a published open interface or public API but rather an internal helper package invoked by the standard Payables card forms.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions in AP_CARD_DATABASE_PKG. Their names and purposes are as follows:

  • GETCARDPROGRAMCURRENCYCODE — returns the currency code associated with a corporate card program, allowing the form to default or validate the currency for the card being processed.
  • GETLOOKUPCODESCURSOR — supplies a cursor over AP_LOOKUP_CODES values, used to populate lookup-driven list items and validation lists on the card pages.
  • GETCURRCODEPROPERTIES — retrieves properties of a currency code (such as precision and descriptive attributes) from the currency views, supporting formatting and validation logic.
  • GETCOAOFSOB — returns the chart of accounts associated with a given set of books, enabling the form to present the correct accounting flexfield structure for the operating unit or ledger context.
  • GETAKPAGEROWID — resolves the row identifier for an AK (Applications Framework) page region, used to link the card UI to the appropriate framework region definition.
  • GETEMPLOYEEINFO — returns employee details from the HR employee view, typically the employee name and number of the card holder.
  • GETPROMPTS — retrieves user-interface prompt text, allowing the card pages to display configurable or localized labels.
  • RAISEEXCEPTION — centralizes error signaling, raising a consistent application error when validation in the card pages fails.
  • JSPREPSTRING_LONG — prepares a long character string for safe embedding in generated JavaScript/HTML output.
  • JSPREPSTRING — the standard-length variant of the same string-preparation utility, escaping or reformatting text destined for the browser.

Tables Accessed

The documented dependency list shows the package references the following tables and views, normally through APPS synonyms: AK_FLOW_REGION_RELATIONS (region/flow relationships for the AK framework pages used by the card UI), AK_REGIONS_VL (region definitions), AP_CARD_PROFILES (employee-to-card-program assignments), AP_CARD_PROGRAMS (card program setup, including clearing accounts and currency), AP_LOOKUP_CODES (lookup values for list items), FND_CURRENCIES_VL (currency definitions and properties), GL_SETS_OF_BOOKS (set of books / accounting context), HR_EMPLOYEES_CURRENT_V (current employee records), and AP_SYSTEM_PARAMETERS (Payables system options). The package is referenced only by itself; no other package in the documented set depends on it.

Usage Notes

AP_CARD_DATABASE_PKG is an internal, form-driven package. It is invoked from the standard Payables corporate card forms and supporting AK/HTML pages rather than from concurrent programs or open interfaces. Because the ETRM signature classification is OTHER and the package has no documented public API contract, it should not be called directly from custom code; Oracle does not guarantee stability of its signatures across patches or upgrades. Customizations that require corporate card data should use supported open interfaces or direct queries against AP_CARD_PROFILES and AP_CARD_PROGRAMS instead. The behavior described above is consistent across 12.1.1 and 12.2.2, with the usual caveat that 12.2.x introduces the ledger-based replacement for sets of books, so GETCOAOFSOB operates against the ledger context in 12.2.2.