Search Results ap_web_db_ccard_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_WEB_DB_CCARD_PKG is a foundational PL/SQL package within the Oracle E-Business Suite (EBS) Internet Expenses and Payables credit card subsystem. Its principal business function is to provide the database access layer for corporate credit card transactions, card programs, and cardholder profiles that flow through the Oracle iExpenses and Payables credit card workflows. In the context of EBS 12.1.1 and 12.2.2, the package is documented as VALID in the APPS schema and classified as an OTHER API rather than a published public interface, which reflects its role as an internal utility used primarily by other application packages and workflows.

The package encapsulates the query and lookup logic required to retrieve credit card transaction details, categorize expenses, identify disputed or unsubmitted transactions, and resolve card program attributes such as currency codes and vendor identifiers. By centralizing these operations, AP_WEB_DB_CCARD_PKG supports the broader credit card reconciliation, expense report assignment, and invoice generation processes executed by Oracle Payables.

Key Procedures and Functions

The ETRM metadata documents 43 procedures and functions. Representative members include:

  • GETCCARDTRXNINFOFORTRXNID — returns detailed credit card transaction information for a specific transaction identifier.
  • GETCREDITCARDTRXNCURSOR, GETCREDITCARDINFOCURSOR — return ref cursors of credit card transactions and card information for downstream processing.
  • GETUNPAIDCREDITCARDTRXNCURSOR, GETDISPUTEDCCARDTRXNCURSOR, GETUNSUBMITTEDCCARDTRXNCURSOR, GETDUNNINGCCARDTRXNCURSOR — return cursors filtered by transaction status, such as unpaid, disputed, unsubmitted, or dunner-flagged records.
  • GETTOTALUNSUBMITTEDCCCURSOR, GETTOTALCCARDTRXNCURSOR — return aggregate totals of unsubmitted and overall credit card transactions.
  • GETEXPRPTCCTRXNCATEGORYCURSOR, GETCCTRXNCATEGORY — retrieve the expense report category associated with a credit card transaction.
  • SETCCTRXNREPORTHEADERID — updates the expense report header reference on a credit card transaction.
  • GETCARDPROGRAMINFO, GETCARDPROGRAMNAME, GETCARDPROGRAMID, GETCARDPROGRAMCURRENCYCODE — resolve card program attributes.
  • GETVENDORIDS, GETCOMPPREPAIDINVID, GETEXPENSEDAMT, COMPANYHASTRAVELCARDPROGRAM — provide vendor identification, prepaid invoice identifiers, expensed amount calculations, and travel card program existence checks.

Tables Accessed

The package reads and writes against the core credit card and expense tables through APPS synonyms, including AP_CARDS, AP_CARD_PROFILES, AP_CARD_PROGRAMS, AP_CREDIT_CARD_TRXNS, AP_EXPENSE_REPORT_HEADERS, and AP_EXPENSE_REPORT_LINES. It also references the _ALL variants (AP_CARDS_ALL, AP_CARD_PROGRAMS_ALL, AP_CREDIT_CARD_TRXNS_ALL, AP_EXPENSE_REPORT_HEADERS_ALL), which support multi-org (MOAC) access, along with AP_EXPENSE_PARAMS and PLITBLM for parameter and PL/SQL table handling. AK_WEB_USER_SEC_ATTR_VALUES is used for user security attribute lookups governing record access.

Usage Notes

AP_WEB_DB_CCARD_PKG is not typically invoked directly by end users. It is referenced by eight other packages, including AP_CREDIT_CARD_INVOICE_PKG, AP_WEB_CREDIT_CARD_WF, AP_WEB_DB_EXPLINE_PKG, AP_WEB_EXPENSE_WF, AP_WEB_INACTIVE_EMP_WF_PKG, AP_WEB_OA_MAINFLOW_PKG, and AP_WEB_UTILITIES_PKG. These callers operate within the Internet Expenses credit card workbench, expense report creation flows, and credit card invoice workflows. Customizations and extensions that must retrieve credit card transaction data should reuse these documented routines rather than querying the underlying tables directly, preserving the integrity of the credit card to expense report to invoice lifecycle.