Search Results date_is_valid




Overview
Explore in AI Chat

Overview

IGC_CC_COMMON_UTILS_PVT is a private PL/SQL package in the APPS schema that provides shared utility routines for the Oracle E-Business Suite Contracts Commitment (IGC) module. The IGC application supports U.S. federal government contracting requirements, including the management of obligations, commitments, and incurred costs against purchase orders and related documents. Within this framework, IGC_CC_COMMON_UTILS_PVT serves as a central repository of reusable helper logic that is consumed by the higher-level IGC concurrent processing packages rather than being exposed directly to end users.

The package is classified as a PVT (private) API, indicating that it is intended for internal use within the IGC module and is not part of Oracle's publicly supported API surface. Its primary responsibilities include resolving descriptive text for document headers, validating date values against the general ledger calendar, determining whether XML-based report output is enabled, and retrieving XML layout metadata used during report generation. Because multiple IGC packages depend on this utility, changes to its behavior can affect a broad range of commitment and year-end processing programs.

Key Procedures and Functions

  • GET_HEADER_DESC — Returns descriptive information for a commitment or contract header, allowing dependent programs to present or log meaningful header descriptions without duplicating lookup logic.
  • DATE_IS_VALID — Validates whether a supplied date falls within an open or valid accounting period, typically by consulting the GL period status information, so that upstream processes avoid posting or processing against closed periods.
  • XML_REPORT_ENABLED — Determines whether XML-based report output is enabled for the current environment, allowing callers to branch between XML and traditional report generation paths.
  • XML_LAYOUT_INFO — Retrieves layout and template information required to produce XML report output, supporting the structured formatting of commitment reports.

These four documented programs are the package's externally visible interface. Because the package is private, callers are limited to other IGC packages within the APPS schema.

Tables Accessed

The package reads from a defined set of purchasing, payables, and general ledger tables through APPS synonyms. GL_PERIOD_STATUSES supplies the period open/closed status used by DATE_IS_VALID. The purchasing tables PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL (along with the PO_HEADERS, PO_LINES, and PO_DISTRIBUTIONS views) provide the commitment document header, line, shipment, and distribution detail needed for header description and related processing. AP_SYSTEM_PARAMETERS and AP_TERMS contribute payables system settings and payment terms, while FND_USER resolves user identity. The IGC-specific tables IGC_CC_ACCT_LINES, IGC_CC_DET_PF, IGC_CC_HEADERS, and IGC_CC_HEADERS_ALL store commitment accounting lines, detail processing information, and header records. The package also references the FND_API standard error-handling and message framework.

Usage Notes

IGC_CC_COMMON_UTILS_PVT is invoked indirectly through eight dependent IGC packages, including IGC_CBC_PO_YEAR_END_PKG, IGC_CC_ARCHIVE_PURGE_PKG, IGC_CC_COMPLETE_COVER_PKG, IGC_CC_MPFS_PROCESS_PKG, IGC_CC_OPEN_INTERFACE_PKG, IGC_CC_REVALUE_PROCESS_PKG, IGC_CC_REVAL_FIX_PROCESS_PKG, and IGC_CC_YEP_PROCESS_PKG. These packages are executed from concurrent programs and internal processes handling year-end close, commitment revaluation, open interface loading, archiving and purging, and coverage completion. The utility routines are not exposed through Oracle Forms or public APIs and should not be called directly from custom code; any custom extension should target the documented public interfaces of the calling packages. The package is valid in both Oracle EBS 12.1.1 and 12.2.2, and its dependencies on purchasing and general ledger tables mean it must be reviewed alongside any upgrade or patch affecting those modules.