Search Results pa_exp_copy




Overview
Explore in AI Chat

Overview

PA_EXP_COPY is an Oracle EBS Projects (PA) schema package owned by APPS that supports duplication of expenditure records within Oracle Project Costing. Its principal business function is to enable users to copy existing expenditure items — together with their associated cost, quantity, and comment detail — from a source context into a target expenditure group, thereby avoiding redundant manual entry when similar transactions recur across projects, tasks, or expenditure batches. The package also supports online (interactive) copying and the reversal of previously copied expenditure groups, and it participates in labor cost multiplier validation and LCM-related checks. In Oracle EBS 12.1.1 and 12.2.2 the package is documented in ETRM with a status of VALID and an API classification of OTHER, indicating that it is an internal supporting package rather than a formally published public API. It is referenced by APPS.PA_ALLOC_RUN and may also reference itself during recursive processing, and it is relied upon by one other package within the Projects schema.

Key Procedures and Functions

The ETRM metadata documents five procedures or functions in PA_EXP_COPY:

  • VALIDATEEMP — Validates employee-related data required before expenditure items can be copied, ensuring the source or target employee context is valid for the copy operation.
  • COPYITEMS — The core routine that duplicates expenditure item rows and their associated detail into the target expenditure group. This procedure embodies the primary copy business logic of the package.
  • ONLINE — Supports the interactive, form-driven invocation of the copy process, providing the entry point used when a user performs a copy action through the Projects forms interface rather than a batch program.
  • REVERSEEXPGROUP — Reverses an expenditure group that was created or affected by a prior copy, restoring the pre-copy state by processing the affected expenditure items.
  • CHECK_LCM — Performs validation related to labor cost multipliers, verifying that multiplier configuration associated with the items is consistent before or during processing.

Parameter lists are not enumerated in the ETRM documentation; callers should obtain signatures from the package specification in the target environment.

Tables Accessed

PA_EXP_COPY accesses the core Project Costing expenditure tables through APPS synonyms. It reads and writes PA_EXPENDITURE_ITEMS_ALL and its interface/transaction variants PA_EXPENDITURE_ITEMS and PA_EXPENDITURE_ITEMS_S, which hold the individual expenditure item rows created during a copy. PA_EXPENDITURES and PA_EXPENDITURES_S provide the corresponding distribution and summarized expenditure records. PA_EXPENDITURE_GROUPS identifies the source and target expenditure groups that scope the copy and the reversal operation. PA_EXPENDITURE_COMMENTS stores any textual comments attached to copied items so that they are preserved. PA_LABOR_COST_MULTIPLIERS is queried to support the CHECK_LCM validation of labor cost multipliers. PA_TASKS is referenced to resolve or validate the task context of the items being copied. DUAL is used for single-row computations and lookups. These accesses confirm that the package operates exclusively within the expenditure and costing domain of Oracle Projects.

Usage Notes

PA_EXP_COPY is invoked from the Projects expenditure copy forms and is also called by the allocation run package APPS.PA_ALLOC_RUN, reflecting its role in batch allocation and costing flows. The ONLINE procedure indicates that the standard entry point is the interactive form used by project accountants and cost analysts when they copy expenditure batches; the same logic may be triggered programmatically during allocation processing. REVERSEEXPGROUP supports corrective workflows when a copied expenditure group must be undone. Because the package is classified as OTHER and is not a documented public API, custom code should avoid calling it directly and should instead rely on supported public interfaces or concurrent programs to safeguard upgrade compatibility across 12.1.1 and 12.2.2. The presence of table variants such as _ALL and _S indicates that copy operations occur in an interface or staging context before final validation, so any diagnostic effort should account for records that exist temporarily in these tables. Dependency on PA_ALLOC_RUN means that changes to allocation behavior can indirectly exercise this package during period-end processing.