Search Results get_ap_system_params

Overview

APPS.AP_WEB_DB_AP_INT_PKG is a server-side PL/SQL package in the Oracle E-Business Suite Payables (AP) module that provides the database interface layer for the Oracle Payables Internet Expenses (OIE) application, commonly referred to as AP Web Expenses. The package name reflects its role: it is a database (DB) package that bridges the AP Web/Internet Expenses user interface tier and the underlying Oracle Payables invoice interface tables. Its primary business function is to gather Payables setup and reference information required during expense report entry, and to write validated expense report data into the Payables invoice interface for downstream import into the Payables invoice tables.

The package is classified as API type OTHER and is owned by the APPS schema. It is a foundational dependency for a large family of Internet Expenses packages, and ETRM shows it is referenced by fifteen other packages, underscoring its central position in the OIE processing stack.

Key Procedures and Functions

The documented package exposes 34 procedures and functions. The principal groups are described below.

• System and currency setup: GET_AP_SYSTEM_PARAMS, GETAPSYSCURRENCYSETUPINFO, GETBASECURRINFO, GETCURRNAMEFORCURRCODE, GETDEFAULTEXCHANGE, and GETSOB/GETCOAOFSOB retrieve Payables system parameters, set of books (ledger) context, chart of accounts information, and currency and exchange rate defaults.
• Supplier and employee vendor data: GETVENDORINFOOFEMP, GETVENDORID, GETVENDORCODECOMBID, GETVENDORSITESCODECOMBID, and GETVENDORAWTSETUPFOREXPRPT resolve employee-as-supplier records, supplier identifiers, site code combinations, and withholding tax setup relevant to expense report reimbursement.
• Validation and authority: APPROVERHASAUTHORITY, ISCOSTCENTERUPPERCASE, COSTCENTERVALID, and GETPAYGROUPLOOKUPCODE support approval authority checks, cost center validation, and pay group derivation.
• Clearing and prepayment handling: GETEXPENSECLEARINGCCID and GETAVAILABLEPREPAYMENTS return the expense clearing account code combination and identify prepayments available for application.
• Interface population: INSERTINVOICEINTERFACE and INSERTINVOICELINESINTERFACE write expense report header and line data into the Payables invoice interface tables.

Tables Accessed

The package reads and writes a defined set of Payables tables through APPS synonyms.

• Setup and reference: AP_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMETERS, GL_SETS_OF_BOOKS, FND_CURRENCIES_VL, AP_TERMS, and AP_TAX_CODES supply system options, ledger, currency, payment term, and tax code defaults.
• Supplier data: AP_SUPPLIERS, AP_SUPPLIER_SITES, and AP_CARDS/AP_CARD_PROGRAMS provide supplier, supplier site, and corporate card information.
• Expense and invoice data: AP_EXPENSE_REPORT_HEADERS, AP_EXPENSE_FEED_DISTS, AP_INVOICES, AP_INVOICES_ALL, and AP_WEB_SIGNING_LIMITS provide expense report and invoice details plus approval authority limits.
• Interface write targets: AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE receive the header and line records generated by the insert routines.

Usage Notes

AP_WEB_DB_AP_INT_PKG is not an end-user-facing API. It is invoked internally by Internet Expenses packages such as AP_WEB_EXPENSE_WF, AP_WEB_ACCTG_PKG, AP_WEB_VALIDATE_UTIL, AP_WEB_DB_EXPLINE_PKG, and AP_CREDIT_CARD_INVOICE_PKG during expense report creation, validation, approval workflow, and accounting generation. The insert routines place data in the invoice interface, which the standard Payables Invoice Import concurrent program subsequently processes.

Because the package is tightly coupled to OIE validation and interface logic, customizations should avoid direct modification. Extensions should instead call documented procedures where dependencies permit, and the package should be reviewed following patches or upgrades to EBS 12.1.1 or 12.2.2 as interface table structures and OIE flows evolve.