Search Results conv_num

Overview

APPS.CZ_UTILS is a shared PL/SQL utility package delivered as part of the Oracle E-Business Suite environment, historically associated with the Centura/CrossZ utilities layer used by older EBS components. It is declared with AUTHID CURRENT_USER, meaning that its unqualified references resolve against the privileges of the invoking schema rather than the package owner. The package aggregates a broad set of low-level helper routines that other EBS packages rely upon: report and error logging, date and numeric conversion, session and user interrogation, translation text lookup, and cross-reference metadata checks against the CZ_XFR tables. In ETRM 12.2.2 it is classified as API classification OTHER, and the documented inventory lists twenty-nine procedures and functions. Its reach is substantial: one hundred sixty-seven other packages reference it, indicating that CZ_UTILS functions as an internal utility backbone rather than a business-facing API. The header comment ($Header: czcutils.pls 120.2 2006/01/18) confirms the lineage of the file. Within Oracle EBS 12.1.1 and 12.2.2, the package is typically deployed in the APPS schema and is not exposed directly to end users; it supports the plumbing of logging, message resolution, and translation infrastructure across the applications tier.

Key Procedures and Functions

• LOG_REPORT – Records a report or diagnostic message with urgency, caller, and status code context; an overload accepts a RunId for concurrent-request association.
• REPORT – Companion routine to LOG_REPORT that reports a message with urgency, caller, and status code.
• TODATE – Converts a string representation into a DATE value.
• EPOCH_BEGIN / EPOCH_END – Return the package-level date boundaries used for validation (12/1/109 through 1/31/4711).
• GET_PK_USEEXPANSION_FLAG – Looks up the primary-key use-expansion flag for a given table and transfer group.
• GET_NOUPDATE_FLAG – Retrieves the no-update attribute for a table/column within a transfer group.
• ISNUM – Tests whether a supplied string value is numeric.
• GET_USER_NAME – Returns the user name associated with a supplied SPX identifier via an OUT parameter.
• CONV_NUM – Converts a string to a number; an overload accepts a format mask.
• SPX_UID / SPX_LOGIN_TYPE – Return the current session's user identifier and login type respectively.
• GET_TEXT – Message-name based lookup returning translated text; an overload accepts a token/value pair for substitution.
• CHECK_INSTALLED_LANG – Verifies whether a given language is installed.
• REPORT_HTML_TAGS – Provides HTML markup handling for report output.
• RETRIEVE_DB_LINK – Resolves a database link reference.
• ADD_ERROR_MESSAGE_TO_STACK / ADD_EXC_MSG_TO_FNDSTACK – Push error and exception messages onto the FND message stack.

Tables Accessed

The package reads and writes a defined set of synonyms: CZ_DB_SETTINGS for configuration such as debug and report levels; CZ_DB_LOGS for persisted log output generated by LOG_REPORT and REPORT; CZ_SERVERS for server context; CZ_XFR_FIELDS and CZ_XFR_TABLES for transfer metadata consulted by GET_PK_USEEXPANSION_FLAG and GET_NOUPDATE_FLAG; FND_USER and ALL_USERS for user resolution in GET_USER_NAME; and DUAL for scalar evaluation. No undocumented tables are assumed.

Usage Notes

CZ_UTILS is invoked programmatically rather than through a form. Its routines are commonly called from concurrent programs and custom PL/SQL that require standardized logging (LOG_REPORT/REPORT), safe type conversion (TODATE, CONV_NUM, ISNUM), translated message retrieval (GET_TEXT), or FND error-stack population (ADD_ERROR_MESSAGE_TO_STACK, ADD_EXC_MSG_TO_FNDSTACK). Because one hundred sixty-seven packages depend on it, changes to its signatures carry wide impact and should be treated as an upgrade-sensitive area during patching from 12.1.1 to 12.2.2.