Search Results cz_fce_compile_utils

Overview

APPS.CZ_FCE_COMPILE_UTILS is a PL/SQL package body in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment that belongs to the ETRM (Enterprise Tax and Regulatory Management) product family. Its name and documented procedures indicate that it functions as a developer utility and code-generation support library rather than as an end-user business process. The package provides low-level primitives for constructing, validating, and asserting the correctness of compiled FCE (Forms Compiler Extension / bytecode-style) objects, together with timing and diagnostic helpers. It is a standalone utility package: ETRM documentation confirms that APPS.CZ_FCE_COMPILE_UTILS is not referenced by any database object, even though it itself is referenced by three other packages and depends on CZ_DEVELOPER_UTILS_PVT and CZ_DB_LOGS. Its business value is therefore internal: it stabilizes and instruments the toolchain that manages ETRM-generated compiled artifacts, ensuring that malformed or out-of-range operands are detected at build time rather than failing silently in production.

Key Procedures and Functions

The package exposes 28 documented procedures and functions, organized into four functional clusters.

Assertion routines: ASSERT_UNSIGNED_BYTE, ASSERT_BYTE, ASSERT_UNSIGNED_WORD, ASSERT_WORD, ASSERT_ICONST, ASSERT_INTEGER, and ASSERT_LONG verify that supplied values fall within the valid range and representation of the corresponding data type. They raise errors when a value violates its type contract, providing an early validation gate.
Type conversion functions: UNSIGNED_BYTE, BYTE, UNSIGNED_WORD, WORD, INTEGER_RAW, LONG_RAW, FLOAT_RAW, and DOUBLE_RAW produce the typed and RAW representations consumed by the compiled object model, and are the constructors that the assertion routines validate.
Timing instrumentation: INIT_TIMING, START_TIMING, END_TIMING, and SPOOL_TIMING_DATA initialize a timing context, bracket measured operations, and emit the collected timing data for performance analysis of compilation workloads.
Diagnostics: REPORT_WARNING records non-fatal conditions encountered during compilation or conversion so that they can be reviewed without aborting the process.

Tables Accessed

The package references four objects through APPS synonyms.

CZ_DB_LOGS is the ETRM logging table to which diagnostic and warning output, including REPORT_WARNING messages and timing spool data, is written.
CZ_DEVELOPER_UTILS_PVT is the private developer utility package from which shared helper logic is drawn.
DBMS_UTILITY supplies Oracle's standard utility routines, typically for formatting and error-stack handling.
PLITBLM and UTL_RAW support low-level BINARY_INTEGER and RAW manipulation used by the byte/word conversion functions.

Usage Notes

CZ_FCE_COMPILE_UTILS is not surfaced through Oracle Forms or a standard concurrent program. It is invoked programmatically by compilation and code-generation routines within the ETRM toolchain, and is referenced by three dependent packages that rely on its validation, conversion, and timing services. Developers extending ETRM compilation logic call the ASSERT_* routines before persisting typed values, use the conversion functions to build RAW representations, and bracket long-running compilation phases with INIT_TIMING, START_TIMING, and END_TIMING before calling SPOOL_TIMING_DATA. Because the package depends on CZ_DB_LOGS, timing and warning output is retrievable through the standard ETRM log review process. Any modification should be treated as a change to shared infrastructure, since invalidating this package body would break every dependent compilation routine.

PACKAGE BODY: APPS.CZ_FCE_COMPILE_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_COMPILE_UTILS, status:VALID,
PACKAGE BODY: APPS.CZ_FCE_COMPILE_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_COMPILE_UTILS, status:VALID,
PACKAGE: APPS.CZ_FCE_COMPILE_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:CZ_FCE_COMPILE_UTILS, status:VALID,
PACKAGE: APPS.CZ_FCE_COMPILE_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:CZ_FCE_COMPILE_UTILS, status:VALID,
SYNONYM: APPS.CZ_DB_LOGS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:CZ_DB_LOGS, status:VALID,
SYNONYM: APPS.CZ_DB_LOGS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:CZ_DB_LOGS, status:VALID,
PACKAGE BODY: APPS.CZ_FCE_DATA 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_DATA, status:VALID,
PACKAGE BODY: APPS.CZ_FCE_COMPILE_DEBUG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_COMPILE_DEBUG, status:VALID,
PACKAGE BODY: APPS.CZ_FCE_DATA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_DATA, status:VALID,
PACKAGE BODY: APPS.CZ_FCE_COMPILE_DEBUG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_COMPILE_DEBUG, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.CZ_DEVELOPER_UTILS_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:CZ_DEVELOPER_UTILS_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.CZ_DEVELOPER_UTILS_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:CZ_DEVELOPER_UTILS_PVT, status:VALID,
PACKAGE BODY: APPS.CZ_FCE_COMPILE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_COMPILE, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.CZ_FCE_COMPILE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_FCE_COMPILE, status:VALID,
SYNONYM: PUBLIC.UTL_RAW 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:UTL_RAW, status:VALID,
SYNONYM: PUBLIC.UTL_RAW 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:UTL_RAW, status:VALID,
PACKAGE: APPS.CZ_FCE_COMPILE_UTILS 12.1.1
PACKAGE: APPS.CZ_FCE_COMPILE_UTILS 12.2.2
APPS.CZ_FCE_COMPILE_UTILS dependencies on CZ_FCE_COMPILE_UTILS 12.1.1
APPS.CZ_FCE_DATA dependencies on CZ_FCE_COMPILE_UTILS 12.1.1
APPS.CZ_FCE_COMPILE dependencies on CZ_FCE_COMPILE_UTILS 12.2.2
APPS.CZ_FCE_COMPILE_UTILS dependencies on CZ_FCE_COMPILE_UTILS 12.2.2
APPS.CZ_FCE_COMPILE_DEBUG dependencies on CZ_FCE_COMPILE_UTILS 12.1.1
APPS.CZ_FCE_DATA dependencies on CZ_FCE_COMPILE_UTILS 12.2.2
APPS.CZ_FCE_COMPILE dependencies on CZ_FCE_COMPILE_UTILS 12.1.1
APPS.CZ_FCE_COMPILE_DEBUG dependencies on CZ_FCE_COMPILE_UTILS 12.2.2
SYNONYM: PUBLIC.DBMS_UTILITY 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_UTILITY, status:VALID,
SYNONYM: PUBLIC.DBMS_UTILITY 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_UTILITY, status:VALID,
PACKAGE BODY: APPS.CZ_FCE_COMPILE_UTILS 12.2.2
PACKAGE BODY: APPS.CZ_FCE_COMPILE_UTILS 12.1.1
APPS.CZ_FCE_COMPILE dependencies on CZ_FCE_COMPILE 12.2.2
APPS.CZ_FCE_COMPILE dependencies on CZ_FCE_COMPILE 12.1.1
SYNONYM: PUBLIC.PLITBLM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.CZ_FCE_COMPILE 12.1.1
PACKAGE BODY: APPS.CZ_FCE_COMPILE 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,