Search Results ap_expense_params

Overview

AP_WEB_DB_CCARD_PKG is the core database package behind the Oracle Payables credit card (corporate card) functionality delivered through the Internet Expenses and Payables web user interfaces. In Oracle E-Business Suite 12.1.1 and 12.2.2, its principal business purpose is to manage the lifecycle of credit card transactions that flow into employee expense reports and Payables invoice processing. The package encapsulates the queries, validation logic, and data manipulation routines required to retrieve outstanding, disputed, unsubmitted, and dunning-related corporate card transactions; to identify the card program that issued a transaction; to resolve company and vendor associations for card issuers; and to establish the link between a credit card transaction and the expense report header that reimburses or clears it.

By centralizing this logic in a single PL/SQL package, Oracle ensures consistent enforcement of card program rules, currency handling, and security across concurrent programs, OAF-based web pages, and dependent packages such as AP_WEB_DB_EXPRPT_PKG and AP_WEB_DB_HR_INT_PKG.

Key Procedures and Functions

The ETRM metadata documents 43 procedures and functions in the package body. The principal documented routines include:

• GETCCARDTRXNINFOFORTRXNID — retrieves the full detail record for a specific credit card transaction identifier.
• GETCREDITCARDTRXNCURSOR — returns a cursor of credit card transactions, typically for a given card or employee scope.
• GETEXPENSEDAMT — derives the expense amount applicable to a transaction for expense reporting purposes.
• GETUNPAIDCREDITCARDTRXNCURSOR / GETDISPUTEDCCARDTRXNCURSOR / GETUNSUBMITTEDCCARDTRXNCURSOR / GETDUNNINGCCARDTRXNCURSOR — return cursor sets for transactions in specific states: unpaid, disputed, not yet submitted into an expense report, and past due, supporting the Credit Card workbench.
• GETTOTALUNSUBMITTEDCCCURSOR / GETTOTALCCARDTRXNCURSOR — aggregate cursor functions providing totals for reporting and workbench display.
• GETEXPRPTCCTRXNCATEGORYCURSOR / GETCCTRXNCATEGORY — determine the expense report category associated with a card transaction.
• GETCARDPROGRAMINFO / GETCARDPROGRAMID / GETCARDPROGRAMNAME / GETCARDPROGRAMCURRENCYCODE — resolve card program attributes, including issuer currency.
• GETVENDORIDS / COMPANYHASTRAVELCARDPROGRAM — identify the supplier(s) associated with card programs and confirm whether a company operates a travel card program.
• SETCCTRXNREPORTHEADERID — writes the association between a credit card transaction and its expense report header.
• GETCOMPPREPAIDINVID — resolves the prepaid invoice identifier related to company-level card processing.

Tables Accessed

The package operates against the base and _ALL credit card tables via APPS synonyms:

• AP_CREDIT_CARD_TRXNS / _ALL — the primary transaction store; read and updated by the retrieval and SETCCTRXNREPORTHEADERID routines.
• AP_CARDS / AP_CARDS_ALL and AP_CARD_PROGRAMS / AP_CARD_PROGRAMS_ALL — card and card program definitions, used to resolve issuer, program name, and currency.
• AP_CARD_PROFILES — profile-level card configuration.
• AP_EXPENSE_REPORT_HEADERS / _ALL and AP_EXPENSE_REPORT_LINES — expense report structures to which card transactions are matched and linked.
• AP_EXPENSE_PARAMS — the expense parameters table (the object referenced by the user search term "ap_expense_params"), which supplies policy and processing settings governing credit card and expense behaviour.
• AK_WEB_USER_SEC_ATTR_VALUES — web user security attribute values used to restrict data visibility.
• PER_CONT_WORKERS_CURRENT_X, PER_EMPLOYEES_X, PER_PEOPLE_X — HR person and assignment data for associating employees with cards and expense reports.
• AP_LOOKUP_CODES — lookup values for transaction categories and statuses, and PLITBLM for PL/SQL table handling.

Usage Notes

AP_WEB_DB_CCARD_PKG is invoked primarily from the Internet Expenses Credit Card workbench, the Create Expense Report flows, and related Payables concurrent programs that load or reconcile corporate card transactions. It is also called by dependent packages including AP_WEB_DB_EXPRPT_PKG, AP_WEB_DB_HR_INT_PKG, AP_WEB_DB_UTIL_PKG, AP_WEB_DFLEX_PKG, AP_WEB_OA_ACTIVE_PKG, AP_WEB_OA_MAINFLOW_PKG and AP_WEB_UTILITIES_PKG. The package is documented as valid in 12.1.1 and 12.2.2 and is not referenced by any database object outside the APPS schema set listed above, making it a foundational internal API rather than a public extension point. Customizations should call the documented routines rather than bypassing the package to preserve card program validation and expense parameter enforcement.