Search Results copy_table_records




Overview
Explore in AI Chat

Overview

PA_RES_ASG_CURRENCY_PUB is a public PL/SQL package in the Oracle EBS Projects (PA) module that manages the currency-denominated amounts associated with resource assignments. Resource assignments in Oracle Projects retain amounts expressed in the assignment currency, and the package coordinates the maintenance, deletion, copying, insertion, and rollup of those rows in the PA_RESOURCE_ASGN_CURR family of tables. The package is classified as a PUB API, meaning it exposes a supported entry point intended for invocation by other Oracle Projects processes and approved external callers rather than being restricted to internal package use.

The body opens with a debug-mode profile lookup against FND_PROFILE for the PA_DEBUG_MODE profile option, which governs diagnostic output during execution. The implementation distinguishes between public and private calling modules through a set of named constants. Private calling modules include MAINTAIN_DATA, DELETE_TABLE_RECORDS, COPY_TABLE_RECORDS, INSERT_TABLE_RECORDS, and ROLLUP_AMOUNTS. Public calling modules include BUDGET_GENERATION, FORECAST_GENERATION, CALCULATE_API, UPDATE_PLAN_TRANSACTION, WORKPLAN, AMG_API, WEBADI, CHANGE_MGT, COPY_PLAN, and UPGRADE. Validation helpers IS_PUBLIC_CALLING_MODULE, IS_PRIVATE_CALLING_MODULE, IS_VALID_COPY_MODE, and IS_VALID_FLAG enforce which callers and parameter values are acceptable before processing proceeds.

Key Procedures and Functions

  • MAINTAIN_DATA — The single documented public procedure. It serves as the primary supported entry point for creating, updating, and otherwise maintaining resource assignment currency records. Its behavior is directed by the calling module context and the private constants listed above, allowing the same procedure to support maintenance, deletion, copy, insert, and rollup operations internally depending on the validated calling path.

The package body additionally declares private helper functions that are not part of the supported public interface. These helpers validate the calling module and flag inputs before the documented procedure performs any table-level work.

Tables Accessed

The package references the following objects through APPS synonyms:

  • PA_RESOURCE_ASGN_CURR — The principal base table holding resource assignment currency amounts. This is the primary target of maintain, insert, update, and delete activity.
  • PA_RESOURCE_ASGN_CURR_S — The corresponding sequence used to generate primary keys for new currency rows.
  • PA_RESOURCE_ASGN_CURR_TMP — A temporary table used to stage records during bulk copy, rollup, or upgrade operations before committed persistence.
  • PA_RESOURCE_ASSIGNMENTS — The parent resource assignment table, read to resolve and validate assignment context for the currency rows.
  • PA_BUDGET_VERSIONS — Read to support budget generation and forecast generation calling paths that touch assignment currency data.
  • PA_BUDGET_LINES — Read in conjunction with budget versions when budget-related calling modules drive the maintenance flow.
  • PLITBLM — The Oracle Applications standard PL/SQL table storage object, used internally for array-based processing.

Usage Notes

PA_RES_ASG_CURRENCY_PUB is invoked indirectly across a wide range of Oracle Projects flows; the metadata indicates that eighteen other packages reference it. Typical invocation paths include budget generation and forecast generation, the Project Status Inquiry calculate API, plan transaction updates, workplan processing, the AMG API, Web ADI integrations, change management, plan copy, and upgrade routines. Because the documented public interface exposes only MAINTAIN_DATA, custom code should call that procedure rather than attempting to invoke private-level operations directly.

The p_calling_module parameter is central to correct use: it determines whether the call is treated as public or private and drives validation through IS_PUBLIC_CALLING_MODULE and IS_PRIVATE_CALLING_MODULE. Callers passing an unrecognized or null module value will fail validation. When debugging behavior, the PA_DEBUG_MODE profile option can be enabled to surface diagnostic output. The package is version-stamped PAFPRBCB.pls and, per the header, was last revised at the 12.1.1 / 12.2.2 release level, so behavior is consistent across both releases.