Search Results insert_period_rates

Overview

APPS.AS_MULTI_CURRENCIES_PKG_W is a PL/SQL wrapper package belonging to the Oracle E-Business Suite service (AS) module, which underpins Service Contracts, field service, and related customer-facing maintenance applications. The package's responsibilities are currency-related: it maintains type mappings and period rates that allow multi-currency processing within the service architecture. The "_W" suffix identifies the object as an interface-only wrapper, a convention used by Oracle to expose a tightly controlled set of data manipulation operations to service-layer clients, typically generated from a base package. In this case the base package is AS_MULTI_CURRENCIES_PKG, and the wrapper model enforces a consistent call signature for bulk collection input and output, an approach characteristic of Oracle's Java-to-PLSQL integration layer (the "rosetta" table-copy pattern). The package therefore serves as the integration point through which external or middle-tier code inserts, updates, and deletes currency type mappings and period exchange rates rather than manipulating the underlying base tables directly.

Key Procedures and Functions

ETRM documents ten procedures, grouped into three functional blocks:

• Rosetta table-copy procedures: ROSETTA_TABLE_COPY_IN_P3 and ROSETTA_TABLE_COPY_OUT_P3 transfer data to and from the TYPE_MAPPINGS_TBL_TYPE collection, while ROSETTA_TABLE_COPY_IN_P7 and ROSETTA_TABLE_COPY_OUT_P7 perform the equivalent conversion for the PERIOD_RATES_TBL_TYPE collection. These routines marshal arrays of JTF collection types (varchar2, date, and number tables) into and out of the strongly typed records expected by the API.
• Type mapping maintenance: INSERT_TYPE_MAPPINGS, UPDATE_TYPE_MAPPINGS, and DELETE_TYPE_MAPPINGS provide the create, modify, and remove operations for currency type mapping rows.
• Period rate maintenance: INSERT_PERIOD_RATES, UPDATE_PERIOD_RATES, and DELETE_PERIOD_RATES provide the equivalent create, modify, and remove operations for period-based exchange rates. The user's search term, delete_period_rates, corresponds to this final routine — the API invoked when period rate rows must be purged, for example during correction of an incorrectly loaded rate set or when a rate period is superseded.

Tables Accessed

The only table documented against this package is PLITBLM, referenced through an APPS synonym. PLITBLM is a standard Oracle EBS tooling table (the PL/SQL table load interface) and is not a business data table; is typically used by the rosetta-style bulk bind mechanisms to stage collection data during array DML. The genuine business records handled by the API — type mappings and period rates — are inserted into, updated in, and deleted from their respective base tables by the underlying AS_MULTI_CURRENCIES_PKG package that this wrapper delegates to. Practitioners should inspect the base package and its database links for the authoritative table list.

Usage Notes

This wrapper is not designed for interactive form invocation. It is normally called from Java-based or other middle-tier service code that has already populated JTF collection types, uses the ROSETTA_TABLE_COPY_IN_P* routines to convert arrays into typed collections, and then invokes the insert, update, or delete routines as a batch. The package is not referenced by any other database package, which confirms its role as an entry point rather than an internal shared utility. Custom code may call it directly provided the caller can construct the required JTF table types, but Oracle's recommended practice is to use the documented service APIs that sit above this wrapper. Because multi-currency rate maintenance directly affects financial calculation and contract billing in the AS module, DELETE_PERIOD_RATES and its companions should be executed with appropriate validation and audit controls in place.