Search Results to_cann




Overview
Explore in AI Chat

Overview

IGS_GE_NUMBER is a general utility package body in the APPS schema belonging to the Oracle E-Business Suite product family associated with the IGS (Student/General) module set. Its documented classification is OTHER, indicating that it is not a public business-facing API but rather an internal helper library used throughout the application. The package provides reusable numeric and character conversion routines, most notably the conversion of arbitrary string input into valid numeric representations and the canonicalization of character data. In Oracle EBS 12.1.1 and 12.2.2, such low-level helpers are commonly invoked by higher-level APIs, validation routines, and user-interface triggers that must normalize user input before it is persisted or compared.

Key Procedures and Functions

Two documented entry points are exposed by IGS_GE_NUMBER:

  • TO_NUM — Converts an input value into a numeric representation. Its purpose is to provide a tolerant, centralized conversion routine, allowing callers to obtain a numeric result from character or mixed-format input without duplicating exception handling across the code base.
  • TO_CANN — Produces a "canonical" form of the input. The naming convention suggests a normalization function used to standardize character values, likely for comparison, lookup, or storage purposes where a consistent format is required.

The ETRM metadata does not document parameter lists for either routine, so their exact signatures should be confirmed against the deployed package specification in the target environment before direct invocation.

Tables Accessed

No application tables are documented as being referenced by IGS_GE_NUMBER. The dependency listing shows only references to the Oracle-supplied SYS.STANDARD package and to the APPS.FND_NUMBER package, indicating that the routines rely on generic numeric and language utilities rather than on IGS or other application data. This is consistent with a pure conversion utility whose behaviour is deterministic and independent of database state.

Usage Notes

IGS_GE_NUMBER is not referenced by any database object according to the ETRM dependency information, and no forms, concurrent programs, or public APIs are documented as calling it directly. However, the package itself references APPS.FND_NUMBER, the Framework numeric utility, confirming that it operates within the standard EBS stack. Because the routines perform generic conversions, they are most likely invoked from custom code, personalizations, or internal IGS module logic that requires numeric parsing or canonicalization. When extending or troubleshooting such logic, developers should prefer the documented public APIs of the owning module; IGS_GE_NUMBER should be treated as an internal helper whose behaviour may change across maintenance packs. Any direct use in custom code should be validated against the specific EBS release (12.1.1 or 12.2.2) and re-tested after patching.