Search Results ap_expense_report_headers_s

Overview

APPS.AP_WEB_DB_EXPRPT_PKG is the core database package supporting the Oracle E-Business Suite Internet Expenses (OIE) module. It encapsulates the server-side business logic used by the Expense Report entry web application to create, retrieve, modify, and process expense report headers and their associated data. The package body is the implementation counterpart of the specification, exposing the PL/SQL interfaces invoked directly by the OIE middle-tier (the Java-based Expense Report pages) and by other dependent packages within the APPS schema.

In Oracle EBS 12.1.1 and 12.2.2, this package is a staple of the AP_WEB_* family. It centralizes access to the AP_EXPENSE_REPORT_HEADERS table (the primary source for the ap_expense_report_headers data element) and shields the application layer from the underlying table structures, validation rules, and multi-org nuances. The body is large and mature—over 40 documented procedures and functions—reflecting its role as the workhorse for expense report header lifecycle management.

Key Procedures and Functions

The documented interface covers report retrieval, header maintenance, workflow integration, and accounting setup. Notable routines include:

• GETEMPLOYEEIDFROMBOTHPAYPARENT — resolves the employee identifier from a both-pay parent expense report, reading AP_EXPENSE_REPORT_HEADERS using the parent header ID.
• GETRESTORABLEREPORTSCURSOR — returns a cursor of expense reports the web user may modify, joining header data (invoice number, week-end date, currency, description, total) with employee name.
• GETREPORTINFO, GETREPORTHEADERINFO, and GETREPORTHEADERATTRIBUTES — retrieve header-level detail and attribute values for display or validation.
• GETEXPWORKFLOWINFO, GETOVERRIDEAPPROVERID — supply workflow routing and approver override information.
• GETEXPREPORTEXCHCURRINFO, SETDEFAULTEXCHRATETYPE — manage foreign-currency exchange rate context.
• GETNEXTEXPREPORTID / GETNEXTRPTHDRID — generate primary keys for new expense reports.
• INSERTREPORTHEADER and INSERTREPORTHEADERLIKEEXISTING — create new headers or clone an existing report.
• SETEXPENSEHEADERINFO, SETAMTDUESANDTOTAL, SETBOTHPAYREPORTHEADER — populate or update header amounts, currency, and both-pay linkage.
• EXPREPORTSHORTPAID, GETACCOUNTINGINFO, GETORGIDBYREPORTHEADERID, GETEXPREPORTINFO — support payment, accounting, and organizational resolution. The body uses AP_WEB_DB_UTIL_PKG.RaiseException for consistent error handling.

Tables Accessed

The package reads and writes many APPS tables via synonyms. The central entity is AP_EXPENSE_REPORT_HEADERS (and its _ALL/_S variants for multi-org and sequence access), holding report header records keyed by report_header_id. Supporting tables include AP_EXPENSE_REPORT_LINES and AP_EXPENSE_REPORT_PARAMS for detail and parameters; AP_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMETERS for setup defaults; AP_CARD_PROGRAMS, AP_CARDS, and AP_CREDIT_CARD_TRXNS/_ALL for corporate card integration; AP_SUPPLIERS for payee matching; AK_WEB_USER_SEC_ATTR_VALUES for web-user security; and FND_ATTACHED_DOCUMENTS/_S for attachments.

Usage Notes

AP_WEB_DB_EXPRPT_PKG is invoked primarily by the Internet Expenses web pages, which call its procedures through the OIE middle-tier during report entry, submission, and approval. It is also referenced by 18 other packages, making it a shared dependency; changes to its public interface can ripple across the OIE call stack. Customizations should prefer calling the documented API rather than manipulating AP_EXPENSE_REPORT_HEADERS directly, as the package enforces validation, key generation, and workflow consistency. When troubleshooting the ap_expense_report_headers element, trace execution through this package to observe the governing business logic.