Search Results log_cost_rec_parameters

Overview

CS_COST_DETAILS_PUB is a public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema that manages cost detail records for the Service (CS) module. Its header comment identifies the source file as csxpcstb.pls and the package as a body (version 120.1, dated 2008/01/18), indicating that it implements the business logic declared in the corresponding CS_COST_DETAILS_PUB specification. The package encapsulates creation, maintenance, and deletion of cost detail data, and it exposes a dedicated logging routine. It follows the standard Oracle EBS API programming model, relying on FND_API and FND_GLOBAL utilities for message handling, transaction control, savepoint management, API version compatibility checking, and capture of the runtime responsibility, user, and login context. Parameter defaults such as FND_GLOBAL.RESP_APPL_ID, FND_GLOBAL.RESP_ID, and FND_GLOBAL.USER_ID mean callers inherit their current session context unless they explicitly override it. The package is classified as a PUBLIC API and is referenced by four other packages, confirming it is a reusable integration point rather than a private helper.

Key Procedures and Functions

The documented API surface contains four procedures:

• CREATE_COST_DETAILS — Inserts a new cost detail record. It accepts a cost record structure (Cost_Rec_Type, defaulting to G_MISS_COST_REC), performs standard savepoint and API-compatibility handling when called with transaction control enabled, initializes the message list on request, and returns the new cost identifier along with the standard return status, message count, message data, and object version number.
• UPDATE_COST_DETAILS — Modifies an existing cost detail record, applying the same validation, message-list, and transaction-control conventions used throughout the package.
• DELETE_COST_DETAILS — Removes a cost detail record, following the same standard API contract for status and message reporting.
• LOG_COST_REC_PARAMETERS — Records the cost record parameter values passed into the package's APIs for diagnostic and debugging purposes. This is the routine referenced by the search term "log_cost_rec_parameters" and is typically used to trace the exact input payload supplied by a caller.

Tables Accessed

The ETRM metadata for this package does not enumerate the underlying base tables; it lists no table references in the supplied documentation. Based on the package's purpose and the CS module context, the API operates on the Service cost details tables (the CS cost tables such as CS_COST_DETAILS and related cost structures), through APPS synonyms. Because the metadata is limited on this point, the precise table list should be confirmed directly from the package source in the target instance.

Usage Notes

CS_COST_DETAILS_PUB is invoked from Oracle Forms, concurrent programs, and custom PL/SQL integration code within Oracle EBS 12.1.1 and 12.2.2. Callers should pass a valid p_api_version (the package's internal version constant is 1.0), set p_init_msg_list, p_commit, and p_validation_level according to their transactional needs, and always inspect x_return_status plus the output message list. Because the procedures accept responsibility and user identifiers as defaults from FND_GLOBAL, direct database sessions and concurrent programs should ensure these globals are properly initialized. Note that the sample code contains a minor defect — the l_api_name constant for Create_Cost_Details is assigned with a trailing backtick — which does not affect runtime behavior but is worth remembering when reading error messages.