Search Results ap_web_db_expline_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_WEB_DB_EXP_ATTENDEES_PKG is a database package within the Oracle E-Business Suite (EBS) Internet Expenses (OIE) module. It encapsulates the core data-manipulation logic governing expense report attendees — the individuals associated with a given expense report line, such as business colleagues sharing a meal or entertainment event. As a member of the AP_WEB_DB_* family of "database" packages, it sits beneath the OIE user interface and exposes stable PL/SQL entry points that Forms and other callers can invoke without embedding SQL directly. The package is owned by APPS, is classified under ETRM as OTHER, and exposes exactly two documented procedures: DELETEATTENDEES and DUPLICATEATTENDEEINFO. Its header carries a 2006 revision stamp, reflecting long-standing stability across 12.1.1 and 12.2.2. The package operates against attendee data captured during expense entry, ensuring that when report lines are removed, copied, or otherwise manipulated, the corresponding attendee records remain consistent with their parent line. This consistency is essential because attendee data feeds downstream reimbursement, tax, and audit reporting where incomplete association between a line and its participants would create compliance exposure.

Key Procedures and Functions

Two procedures are documented in the package specification:

  • DELETEATTENDEES — Removes attendee records associated with a specified expense report. It accepts a report identifier and is used to purge attendee rows when an expense report or one of its lines is deleted, or when attendee data is being cleanly replaced. The customer's search term suggests this routine is commonly reached when investigating tickets or service requests involving stale attendee records.
  • DUPLICATEATTENDEEINFO — Copies attendee information from a source report line to a target report line. It accepts a user identifier plus a source and target report line identifier. This supports scenarios where an existing line's attendee list is reused on a newly created line, avoiding redundant manual re-entry and preserving the association between participants and the duplicated expense.

Neither procedure returns a value; both perform direct DML against the underlying tables.

Tables Accessed

The package references the following objects via APPS synonyms:

  • AP_EXPENSE_REPORT_LINES — the parent expense line table. The package reads line context to identify the report and line that attendee records belong to, and to validate source and target lines during duplication.
  • OIE_ATTENDEES_S — the primary attendee detail store for the Internet Expenses module. Rows here are inserted, deleted, or copied by the package's procedures. The "_S" suffix indicates the attendee detail entity within the OIE schema family.
  • DUAL — used for trivial single-row selection, validation, or sequencing logic internal to the procedures.

Usage Notes

AP_WEB_DB_EXP_ATTENDEES_PKG is not exposed to end users directly. It is invoked programmatically by OIE Forms and related UI layers during expense report creation, modification, line deletion, and line duplication. The ETRM record notes the package is referenced by one other package, indicating it is a lower-level utility within a layered call stack — typically invoked by a higher-level AP_WEB_DB_* orchestration package or by the Attendees region of the expense entry form when a user adds or removes participants. In 12.1.1 and 12.2.2 it functions identically, since the package's interface has remained unchanged since its 2006 revision. Customizations should call these procedures rather than issuing direct DML against OIE_ATTENDEES_S, preserving integrity and forward compatibility across patch levels and release upgrades.