Search Results p_package_type

Overview

AS_MULTI_CURRENCIES_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Despite its broad name, its documented function centers on the maintenance of multi-currency type mappings and period conversion rate records used by the Oracle Assets (fixed asset) multi-currency processing framework. The package exposes a symmetric set of DML-based APIs—insert, update, and delete operations—for two logical entities: currency type mappings and period rates. Each routine follows the standard EBS API savepoint and message-handling conventions, initializing an OUT return status to FND_API.G_RET_STS_SUCCESS and relying on AS_UTILITY_PVT.Debug_Message for low-level debug tracing when the FND message level is enabled.

The package is classified as an "OTHER" API in the ETRM repository. Its source header references file asxtmcpb.pls and identifies it as version 120.2, dated 2005. In the 12.1.1 and 12.2.2 releases it remains a stable, relatively thin data-access layer rather than a business-rule engine. As documented metadata indicates, it is referenced by one other package, implying it is invoked primarily as a subordinate utility rather than as a top-level entry point.

Key Procedures and Functions

The package comprises six documented procedures, each dedicated to a single DML verb against one of the two managed entities.

• INSERT_TYPE_MAPPINGS — inserts one or more multi-currency type mapping rows. The procedure accepts a PL/SQL associative array of type mappings and iterates from FIRST to LAST, inserting each record. Attributes such as PERIOD_SET_NAME, PERIOD_TYPE, and CONVERSION_TYPE are set to NULL when the incoming value equals FND_API.G_MISS_CHAR, a standard EBS idiom for distinguishing "not supplied" from "explicit null."
• UPDATE_TYPE_MAPPINGS — updates existing mapping rows identified by the supplied table collection, following the same iterative, savepoint-based pattern.
• DELETE_TYPE_MAPPINGS — removes mapping rows corresponding to the supplied collection entries.
• INSERT_PERIOD_RATES — inserts period conversion rate records, which populate the daily rates interface for multi-currency asset processing.
• UPDATE_PERIOD_RATES — modifies existing period rate rows.
• DELETE_PERIOD_RATES — deletes period rate rows.

No function-type members are documented; all six are procedures. Exact parameter signatures are not reproduced here, but the insert and update families share a common convention of a table-typed input parameter with a defaulted G_MISS value plus three NOCOPY OUT parameters (return status, message count, message data).

Tables Accessed

• AS_MC_TYPE_MAPPINGS — the primary target of the three mapping procedures. It stores the linkage between period sets, period types, and conversion types that govern how multi-currency conversions are performed. INSERT_TYPE_MAPPINGS writes to this table; UPDATE and DELETE modify or remove its rows.
• GL_DAILY_RATES_INTERFACE — the General Ledger interface table for daily conversion rates. The period-rate procedures write or maintain records here, allowing rate information to be validated and loaded into GL_DAILY_RATES. This coupling to the GL interface confirms that period rates are not maintained in an Assets-specific table but are staged for central currency rate processing.
• PLITBLM — a standard EBS PL/SQL table utility used to support the associative array handling intrinsic to the table-typed parameters. Reference to this object indicates the procedures manipulate collection payloads before or during their DML.

Usage Notes

The package is an internal data-maintenance utility. It is not exposed as a concurrent program or a form-level API in the documented metadata; rather, it is invoked by the one referencing package that coordinates multi-currency setup and rate loading for Oracle Assets. Custom code should invoke these procedures only within the transaction context expected by that caller, honoring the savepoint and return-status contract: the caller must check X_Return_Status and roll back to the API savepoint on failure. Because the procedures rely on FND_API.G_MISS_CHAR decoding, callers must initialize unused attributes of the input collection to the G_MISS_CHAR constant rather than to NULL, or the defaulting logic will not behave as intended. Direct DML against AS_MC_TYPE_MAPPINGS outside this package is discouraged, since the package encapsulates the expected column defaults for audit columns such as LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY. The user search term "p_package_type" does not correspond to any documented parameter of this package; callers seeking the package classification value should read the ETRM API classification ("OTHER") from the repository rather than from a package argument.