Search Results execute_insert_cit

Overview

APPS.CSTPUTIL is a utility package within the Oracle E-Business Suite Cost Management (CST) module. It provides a small set of reusable PL/SQL building blocks that support cost processing, currency handling, and dynamic record creation against costing flexfield structures. The package header, sourced from CSTPUTIS.pls, exposes three documented procedures: CSTPUGCI, DO_SQL, and EXECUTE_INSERT_CIT. Its scope is deliberately narrow, serving as shared infrastructure that other costing packages call rather than a user-facing API. In ETRM 12.2.2 the package is classified as OTHER, indicating it is not a formally published open interface but is nonetheless referenced across the application.

Key Procedures and Functions

• CSTPUGCI — Return Currency Information. Given an organization identifier, this procedure returns currency-related rounding and precision values: a rounding unit representing an extension of the minimum accounting unit, a regular precision, and an extended precision. These outputs allow calling code to apply consistent currency rounding conventions during cost calculations.
• DO_SQL — Executes a dynamic SQL statement. The procedure accepts a SQL statement string of up to 8K in length, supporting scenarios where SQL text must be constructed at runtime.
• EXECUTE_INSERT_CIT — Accepts a view name, cost organization identifier, cost type identifier, item identifier, an application column name, and a flex value. It performs an insert operation against the costing information type (CIT) key flexfield structure, populating the flexfield segment identified by the application column with the supplied flex value.

Tables Accessed

The package operates against several base tables through APPS synonyms. FND_CURRENCIES supplies currency definitions and precision attributes consumed by CSTPUGCI. HR_ORGANIZATION_INFORMATION provides the organizational context, including the accounting information required to resolve rounding and precision for the specified organization. MTL_SYSTEM_ITEMS is referenced to validate and resolve item-level details during insert processing. The package also depends on the DBMS_SQL built-in to support the dynamic SQL executed by DO_SQL, and on UTL_FILE for file-based output operations. Exact read/write direction per table is not separated in the documented metadata, but the functional intent is consistent with currency lookup, organization resolution, and item-based costing inserts.

Usage Notes

CSTPUTIL is invoked indirectly rather than directly by end users. Its eight dependent packages call these utilities to obtain currency rounding rules, to run dynamically generated SQL, and to insert key flexfield combinations into cost information type structures. Customizations that require currency precision or rounding logic for costing should call CSTPUGCI instead of hard-coding values, ensuring consistency with standard costing behavior. EXECUTE_INSERT_CIT is relevant when custom code must populate CIT flexfield segments programmatically; callers must supply the correct view name, cost organization, cost type, item, application column, and flex value. Because these routines are classified as OTHER rather than as a published open API, signature changes across releases are possible, and any custom integration should be validated against the target EBS version (12.1.1 or 12.2.2) before deployment.