Search Results pa_expend_item_adj_act_s

Overview

PA_PURGE_COSTING is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an OTHER-type API. Its role is to purge expenditure and costing data associated with Oracle Projects, encompassing the transactional tables that hold project expenditures, cost distribution lines, and the denormalized structures used to streamline inquiry and reporting performance. The package is part of the broader PA_PURGE family of utilities, coordinating with packages such as PA_PURGE, PA_PURGE_PROJECTS, PA_PROJECT_UTILS2, and PA_UTILS2 to remove obsolete or archived costing records in a controlled manner.

The object is relevant to administrators and developers working with expenditure adjustments, as evidenced by its dependency on PA_EXPEND_ITEM_ADJ_ACT_S, a table frequently investigated during data cleanup, reconciliation, and archival activities. Because the package is only invoked internally by the purge infrastructure, it does not expose a public API surface intended for direct ad hoc use.

Key Procedures and Functions

The package body contains fifteen documented procedures covering the major costing entities subject to purge. PA_COSTING_MAIN_PURGE serves as the central driver that orchestrates the remaining purge routines for a given project or range of expenditure data. PA_COSTDISTLINES and PA_CCDISTLINES remove cost distribution and cost collection distribution records respectively, while PA_EXPENDITURES1 and PA_EXPENDITUREITEMS address expenditure headers and expenditure item rows. PA_EXPENDITURECOMMENTS and PA_EXPENDITUREHISTORY clear associated comment and audit history entries.

The adjustment-related procedures PA_EXPENDITEMADJACTIVITIES and PA_ROUTINGS1 target expenditure item adjustment activities and routing records. The denormalization procedure PA_EIDENORM maintains the PA_EI_DENORM structures that support inquiry performance. For multiple reporting currency environments, PA_MRCEXPENDITUREITEMS, PA_MRCCOSTDISTLINES, and PA_MRCCCDISTLINES purge the corresponding MRC mirrored tables. Finally, PA_EXPITEMSSRCPURGE and PA_EXPITEMSDESTPURGE handle expenditure items on the source and destination sides of inter-project or cross-charge transfers. Collectively these procedures ensure that a purge request deletes or archives all dependent costing rows rather than orphaning children of the expenditure item hierarchy.

Tables Accessed

The package reads and writes the primary expenditure and distribution base tables PA_EXPENDITURES_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_COMMENTS, PA_EXPENDITURE_HISTORY, PA_COST_DISTRIBUTION_LINES_ALL, and PA_CC_DIST_LINES_ALL, together with their _AR reporting counterparts and the MRC _ALL representations PA_MC_EXP_ITEMS_ALL, PA_MC_COST_DIST_LINES_ALL, and PA_MC_CC_DIST_LINES_ALL. Denormalized support tables PA_EI_DENORM and PA_EI_DENORM_AR are maintained via PA_EIDENORM. The expenditure adjustment tables PA_EXPEND_ITEM_ADJ_ACTIVITIES and PA_EXPEND_ITEM_ADJ_ACT_S are purged alongside routing records in PA_ROUTINGS and PA_ROUTINGS_AR and tasks in PA_TASKS. Standard Oracle components such as FND_PROFILE, DUAL, PLITBLM, and the STANDARD package are referenced for profile option retrieval, utility functions, and PL/SQL support.

Usage Notes

PA_PURGE_COSTING is normally invoked indirectly through the Oracle Projects purge concurrent programs and related purge flows rather than from forms or custom code. It is referenced by one other database package, reinforcing its role as an internal worker within the purge framework. Profile options accessed via FND_PROFILE govern the scope and behavior of the purge. Because the package performs destructive operations against high-volume costing tables, direct invocation in a production environment is not recommended; purge should be executed through the supported concurrent program with appropriate backup and validation. Developers investigating the PA_EXPEND_ITEM_ADJ_ACT_S table frequently encounter this package when tracing which process removes adjustment activity records during project or expenditure cleanups.