Results for “ap_web_db_exprpt_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AP_WEB_DB_EXPRPT_PKG is a core database package within the Oracle E-Business Suite Internet Expenses (OIE) module, residing in the APPS schema with a VALID status in both EBS 12.1.1 and 12.2.2. Its principal business function is to provide the central data-access and manipulation layer for the Expense Report (ER) workflow and the underlying web-based expense entry forms. The package encapsulates the PL/SQL logic required to create, retrieve, update, and persist expense report header and line information, resolve employee and organizational context, support credit card transaction processing, and enforce expense report exchange rate and accounting behavior. Because it is classified as an API of type OTHER, it is intended primarily for internal consumption by the Internet Expenses application tier rather than as a formally published integration interface. It is referenced extensively across the OIE codebase—by eighteen other packages including AP_WEB_ACCTG_PKG, AP_WEB_AME_PKG, AP_WEB_EXPENSE_WF, AP_WEB_DB_AP_INT_PKG, and AP_WEB_OA_MAINFLOW_PKG—which confirms its role as a low-level, shared persistence and query utility package for the expense reporting flow.

Key Procedures and Functions

The package exposes forty-one documented procedures and functions. The following are representative of the documented API surface:

• GETEMPLOYEEIDFROMBOTHPAYPARENT — Resolves the employee identifier by considering both the pay and parent organizational relationships, used to correctly attribute an expense report to an employee during creation or query.
• GETRESTORABLEREPORTSCURSOR — Returns a cursor over expense reports eligible for restoration, supporting the retrieval of saved or previously suspended reports.
• GETEXPWORKFLOWINFO — Retrieves workflow-relevant information for an expense report, used by the expense workflow packages to drive approval routing.
• GETREPORTINFO and GETREPORTHEADERINFO — Return descriptive and status information for an expense report header.
• GETOVERRIDEAPPROVERID — Determines the override approver for a report where an alternate approver has been designated.
• GETORGIDBYREPORTHEADERID — Returns the organization identifier associated with a given expense report header.
• GETREPORTHEADERATTRIBUTES — Retrieves header-level attributes for a report.
• GETEXPREPORTEXCHCURRINFO — Returns exchange currency information for an expense report.
• GETNEXTEXPREPORTID and GETNEXTRPTHDRID — Generate the next identifiers for expense reports and report headers, respectively.
• GETACCOUNTINGINFO — Returns the accounting information associated with a report.
• GETEXPREPORTINFO — Retrieves general expense report information.
• EXPREPORTSHORTPAID — Indicates whether a report is short-paid.
• INSERTREPORTHEADER and INSERTREPORTHEADERLIKEEXISTING — Insert a new expense report header, the latter copying the structure of an existing report.
• SETDEFAULTEXCHRATETYPE — Establishes the default exchange rate type for a report.
• SETEXPENSEHEADERINFO — Populates or updates expense report header fields.
• SETAMTDUESANDTOTAL — Sets the amount due and total values for a report.
• SETBOTHPAYREPORTHEADER — Sets pay-related header information for a report.

Tables Accessed

The package reads and writes a set of AP and shared tables through APPS synonyms. Expense report data is held in AP_EXPENSE_REPORT_HEADERS, AP_EXPENSE_REPORT_HEADERS_ALL, AP_EXPENSE_REPORT_HEADERS_S, and AP_EXPENSE_REPORT_LINES. Credit card functionality depends on AP_CARD_PROGRAMS, AP_CARDS, AP_CREDIT_CARD_TRXNS, and AP_CREDIT_CARD_TRXNS_ALL. Supplier and employee context is supplied by AP_SUPPLIERS and HR_EMPLOYEES_CURRENT_V. Configuration and defaults derive from AP_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMETERS, GL_SETS_OF_BOOKS, and FND_CURRENCIES_VL. Security and access attributes come from AK_WEB_USER_SEC_ATTR_VALUES, and attachment records from FND_ATTACHED_DOCUMENTS and FND_ATTACHED_DOCUMENTS_S. AP_EXPENSE_REPORT_PARAMS provides reporting and setup parameters.

Usage Notes

AP_WEB_DB_EXPRPT_PKG is invoked from the Internet Expenses OA (Oracle Applications) pages, the expense report workflow, and numerous internal OIE packages such as AP_WEB_EXPENSE_WF, AP_WEB_OA_MAINFLOW_PKG, AP_WEB_DB_CCARD_PKG, and AP_WEB_EXPORT_ER. It is not designed as a standalone public API; customizations should avoid direct dependency and prefer supported interfaces. Because it participates in expense report creation and approval, changes or debugging must respect the transactional integrity of the header/line tables it maintains. In both 12.1.1 and 12.2.2 the object remains VALID and is a dependency prerequisite for the surrounding Internet Expenses package hierarchy.