Search Results ap_exp_report_dists_s

Overview

AP_WEB_DB_EXPDIST_PKG is a PL/SQL package body owned by the APPS schema that provides the database-tier logic for managing expense report distribution lines within Oracle E-Business Suite Internet Expenses (OIE). Its primary business function is to create, validate, modify, move, duplicate, and delete accounting distribution records that associate expense report lines with General Ledger code combinations. The package operates against the distribution tables AP_EXP_REPORT_DISTS, AP_EXP_REPORT_DISTS_ALL, and AP_EXP_REPORT_DISTS_S, which underpin expense report accounting in both Oracle EBS 12.1.1 and 12.2.2. It is classified as an OTHER API (not a public open interface), indicating it is an internal package invoked by Oracle's own forms and concurrent logic rather than by customer integrations directly. The package is documented as VALID with 16 procedures and functions, and is referenced by three other database objects.

Key Procedures and Functions

The documented routines address the lifecycle of expense report distributions:

• FOUNDCCID and FOUNDDISTRIBUTIONS — verification routines that confirm the presence of a valid code combination identifier and existing distribution records.
• SETDISTCCID and UPDATEDISTCCID — assign or change the code combination identifier on a distribution.
• DELETEREPORTDISTRIBUTIONS — removes distribution rows for a report, supporting cleanup and re-derivation of accounting.
• MOVEDISTRIBUTIONS and DUPLICATEDISTRIBUTIONS — relocate or copy distribution records, typically when lines are reorganized or copied within a report.
• UPDATEDISTACCOUNTVALUES, UPDATEDISTACCTVALUESFORFORMS, and UPDATEACCOUNTVALUES — synchronize account segment values across distributions, including a variant tailored for the OIE Forms user interface.
• ADDDISTRIBUTIONLINE — inserts a new distribution line.
• CONTAINSPROJECTRELATEDDIST and CONTAINSNONPROJECTRELATEDDIST — determine whether distributions carry project-related attributes, governing project accounting behavior.
• RESPLITDISTAMOUNTS — recalculates and reapportions distribution amounts after changes.
• GETCCSEGMENTVALUE — retrieves individual account segment values for a code combination.

Tables Accessed

The package reads and writes AP_EXP_REPORT_DISTS, AP_EXP_REPORT_DISTS_ALL, and AP_EXP_REPORT_DISTS_S, which store expense report distribution details across the base, multi-organization, and security-enabled views used in R12. It references AP_EXPENSE_REPORT_HEADERS and AP_EXPENSE_REPORT_LINES to associate distributions with their parent report and line context. GL_CODE_COMBINATIONS supplies account validation and identifiers, while FND_ID_FLEX_SEGMENTS and AP_OIE_KFF_SEGMENTS_T provide key flexfield structure and OIE-specific segment metadata used to interpret account segments. DBMS_SQL, DUAL, and the PLITBLM PL/SQL table type support dynamic SQL and internal data handling.

Usage Notes

AP_WEB_DB_EXPDIST_PKG is invoked by the Oracle Internet Expenses Forms application and by related OIE packages. Documented dependencies include AP_WEB_DB_EXPLINE_PKG, AP_WEB_DB_AP_INT_PKG, AP_WEB_ACCTG_PKG, AP_WEB_DB_UTIL_PKG, AP_WEB_UTILITIES_PKG, and AP_WEB_DB_EXPDIST_PKG itself, indicating it sits within the core OIE expense processing chain. It is not referenced by any database object, and because it is an internal package rather than a public API, direct customer invocation is not supported; customizations should rely on documented open interfaces. The UPDATEDISTACCTVALUESFORFORMS routine specifically reflects the Forms-driven account update path.