Search Results igs_ge_date




Overview
Explore in AI Chat

Overview

IGS_GE_DATE is a general utility package body in the APPS schema of Oracle E-Business Suite, classified under the ETRM as an "OTHER" API type. Its name and documented procedures indicate that it supplies standardized date handling, character conversion, and date-formatting services used throughout the Oracle Student System (IGS) product family and related modules. Rather than implementing a specific business transaction, the package centralizes low-level date and value conversion logic so that other PL/SQL units can call a single, consistent implementation instead of duplicating format masks and conversion routines.

In EBS 12.1.1 and 12.2.2, the object is present and VALID. It is a foundational dependency rather than an application-facing entry point; the ETRM records it as referenced by 158 other packages, confirming that it sits near the base of the IGS dependency hierarchy. Its own dependencies are limited to APPS.FND_DATE, the STANDARD package, and a self-reference to IGS_GE_DATE in the schema listing, which is consistent with a thin wrapper layer over the EBS date utilities.

Key Procedures and Functions

  • IGSDATE — The primary date-handling routine of the package. It provides a standardized means of obtaining or resolving a date value in the format expected by IGS modules, shielding callers from direct dependence on NLS and session date-format settings.
  • IGSCHAR — A character conversion routine. It converts a supplied value into a character representation, providing consistent string output for downstream comparisons, display, or message construction.
  • IGSCHARDT — A combined character-and-date conversion routine. It converts a date value into its character representation using the package's canonical date format, and is typically used where a date must be embedded in text, concatenated into a key, or passed to an interface expecting a string.

The ETRM metadata documents the existence and names of these three program units but does not publish their parameter lists; callers should reference the installed source in the APPS schema for exact signatures.

Tables Accessed

No base tables or views are documented as being referenced by IGS_GE_DATE. The dependency listing contains only APPS.FND_DATE, SYS.STANDARD, and the self-reference to IGS_GE_DATE. This is consistent with a pure utility package that performs conversion and formatting in PL/SQL memory and relies on FND_DATE for the underlying EBS date conversion primitives, rather than persisting or querying application data. Because it performs no DML, the package is safe to invoke in read-only contexts, including within queries and validation routines.

Usage Notes

IGS_GE_DATE is not intended for direct end-user invocation through a form or concurrent program. It is an internal service package, invoked from within other PL/SQL units when a date or value must be normalized or rendered as text. Typical call sites include other IGS packages, validation routines attached to forms, and custom extensions that must produce output matching the format used by delivered Student System components.

Given that 158 packages depend on it, changes to its behavior carry a broad blast radius. Customizations should call the existing procedures rather than reimplementing their logic, and any modification should be treated as a patch to a shared foundation object, retested across dependent components, and applied consistently to 12.1.1 and 12.2.2 environments. The package is not referenced by any database object according to the ETRM, so it should be considered a leaf dependency in the reverse direction even though it is heavily consumed.