Search Results pft_activity_rates

Overview

PFT_BR_ACTIVITY_RATE_PVT is a private PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite, classified under the Profitability Manager (PFT) module commonly associated with Enterprise Territory and Resource Management (ETRM) and related profitability/activity rate functionality. The package encapsulates the business logic that manages the lifecycle of an Activity Rate Definition object. An Activity Rate Definition represents a logical grouping of activity rates and their associated activity driver assignments, allowing the application to calculate and apply rates to business activities. The package body acts as the private implementation layer of the public API, exposing reusable routines that the Activity Rate Definition infrastructure invokes whenever a definition must be created by copying an existing one, or removed along with all of its dependent detail records. By centralizing this logic, the package enforces consistent, transaction-safe handling of the underlying rate and driver-assignment tables.

Key Procedures and Functions

• DeleteObjectDefinition — Removes all detail records belonging to a specified Activity Rate Definition. It accepts the object definition identifier and deletes the corresponding rows from both the activity driver assignment table and the activity rate table, ensuring no orphaned child records remain. On error, the procedure adds an exception message to the FND message stack and raises the standard unexpected-error condition, allowing the calling program to handle the failure uniformly.
• CopyObjectDefinition — Creates the full set of detail records for a new (target) Activity Rate Definition by copying the detail records of an existing (source) Activity Rate Definition. It takes the source and target object definition identifiers and duplicates the associated rate and driver-assignment data so that a user can rapidly derive a new definition from an existing template without re-entering configuration.

Tables Accessed

• PFT_ACTIVITY_RATES — Stores the activity rate records that belong to an Activity Rate Definition. Rows are deleted by DeleteObjectDefinition based on the object definition ID, and they are read and inserted by CopyObjectDefinition when cloning a definition.
• PFT_ACTIVITY_DRIVER_ASGN — Stores the assignment of activity drivers to rate definitions. It is maintained in tandem with PFT_ACTIVITY_RATES to keep driver assignments consistent when a definition is deleted or copied.

Usage Notes

As a private (PVT) package, PFT_BR_ACTIVITY_RATE_PVT is not intended for direct invocation by external or customer code; it is called internally by the Activity Rate Definition public API or the UI layer that manages rate definitions, such as setup or administration forms in the Profitability Manager module. It is typically invoked when a user deletes an existing Activity Rate Definition or creates a new one by copying from a source definition. The ETRM documentation records that the package is not referenced by any other documented package, confirming its role as a leaf-level implementation unit. Customizations should avoid calling this private package directly and instead use the supported public API that wraps it, preserving upgrade safety and transactional integrity.