Search Results ct_id

Overview

APPS.CSTPUTIL is a utility package body in the Oracle E-Business Suite Cost Management (CST) product family. Its documented name and procedure conventions identify it as a shared "CST PU" (Cost Processing Utility) library that centralizes low-level helper logic used across costing routines rather than exposing a formal public API. The package carries an API classification of OTHER, indicating that it is invoked internally by other cost modules and is not marketed as a callable interface for external integration.

The package has two principal responsibilities as revealed by its documented procedures. The first is currency and precision resolution for a given inventory organization: CSTPUGCI derives the rounding unit, standard precision, and extended precision that downstream costing calculations require. The second is generic runtime execution: DO_SQL and EXECUTE_INSERT_CIT provide dynamic SQL and bulk insert capabilities used to move costing data. The ct_id search term that led to this article most plausibly relates to a costing transaction identifier passed to the insert routine, consistent with the cost transaction tables that the package touches.

Key Procedures and Functions

• CSTPUGCI — Returns currency information for a specified organization. It resolves the rounding unit (the extension of the minimum accountable unit, applied as ROUND(number/O_ROUND_UNIT)*O_ROUND_UNIT), the regular precision, and the extended precision. The implementation joins FND_CURRENCIES to the set of books identified through HR_ORGANIZATION_INFORMATION accounting information, and falls back to a rounding unit of 1 and zero precision when no row is found.
• DO_SQL — Executes a dynamically supplied SQL statement. It opens a DBMS_SQL cursor, parses the statement in V7 mode, executes it, and closes the cursor, providing a controlled wrapper around dynamic DDL or DML used by costing maintenance routines.
• EXECUTE_INSERT_CIT — Performs an insert against the cost interface table (CIT) area. The ct_id reference in the source metadata is most consistent with this procedure, which moves cost transaction rows into the costing interface for subsequent processing. The name implies a set-based insert driven by dynamic SQL.

Tables Accessed

The package reads and writes the following objects, accessed through APPS synonyms:

• FND_CURRENCIES — Supplies minimum accountable unit, precision, and extended precision for the organization's functional currency.
• HR_ORGANIZATION_INFORMATION — Resolves the organization's accounting information, specifically the associated set of books, replacing the older org_organization_definitions view.
• MTL_SYSTEM_ITEMS — Referenced for item attribute and cost-related lookups used during transaction processing.
• DBMS_SQL — The Oracle-supplied dynamic SQL package, used by DO_SQL and EXECUTE_INSERT_CIT.
• UTL_FILE — Oracle's file I/O package, indicating debug or log file output used during costing runs.

Usage Notes

CSTPUTIL is not a form-invoked or user-facing package. It is called programmatically by eight other packages within the EBS costing stack, principally cost processor and cost manager routines that need consistent currency precision or efficient interface inserts. Typical invocation points include concurrent programs that process cost transactions, the Cost Manager and related worker programs, and any customization that must replicate standard rounding behaviour.

Two operational cautions apply. First, CSTPUGCI returns NOCOPY OUT parameters and raises ORA-20001 on unexpected errors, so callers should trap exceptions defensively. Second, because DO_SQL accepts arbitrary SQL text, its use is restricted to internal, trusted code paths; the procedure should not be exposed to user-entered SQL. The header revision tag indicates the package has been stable since the 11i era and remains valid in both 12.1.1 and 12.2.2.