Search Results create_auto_cc_num




Overview
Explore in AI Chat

Overview

The APPS.IGC_CC_SYSTEM_OPTIONS_PKG package is a stored PL/SQL program unit in the Oracle E-Business Suite (EBS) Applications schema. It belongs to the IGC product family, which supports Oracle's Grants and Costing / Contracts Core functionality within the ETRM (Enterprise Technical Reference Manual) inventory. In release 12.1.1 and 12.2.2 this package has a status of VALID and is classified under the API classification of OTHER, meaning it is not a standalone public API but an internal infrastructure package supporting system options maintenance.

Its primary role is to manage the setup and configuration records that drive award and contract numbering, particularly the system options that govern automatic versus manual contract or award number generation. The package encapsulates the standard CRUD (create, read, update, delete) operations against the system options table, together with validation and uniqueness checks that protect data integrity. It also exposes logic to generate and validate numeric contract numbers, which feed directly into the downstream contracts header processing.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within the package. Their purposes are as follows:

  • INSERT_ROW — Inserts a new system options record into the options table, establishing the initial configuration row for a new or refreshed setup.
  • LOCK_ROW — Acquires an exclusive lock on the target system options row, using standard concurrency control so multiple sessions cannot simultaneously modify the same configuration record.
  • UPDATE_ROW — Modifies the attributes of an existing system options record, applying changes made through the maintenance user interface or calling process.
  • DELETE_ROW — Removes a system options record, supporting clean-up or reconfiguration scenarios.
  • CHECK_UNIQUE — Verifies that the key combination of the system options row does not already exist, returning a validation result used before insert or update operations.
  • CREATE_AUTO_CC_NUM — Generates an automatic contract or award number when the system option for automatic numbering is enabled, returning the newly created numeric identifier.
  • VALIDATE_NUMERIC_CC_NUM — Validates that a user-supplied contract or award number conforms to the expected numeric format and any configured rules before it is accepted.

Tables Accessed

The package reads and writes through APPS synonyms. The documented tables are:

  • IGC_CC_SYSTEM_OPTIONS_ALL — The primary table holding the system options configuration rows managed by the INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW procedures.
  • IGC_CC_HEADERS — The contracts/awards header table, referenced during numbering operations. This dependency ties the numbering logic to the actual header records that consume generated numbers.
  • PO_HEADERS — The Oracle Purchasing document headers table, referenced as a documented dependency, reflecting the shared source-of-truth behavior for document numbering across IGC and Purchasing.

Usage Notes

The package depends on FND_API, using the standard Oracle Application Object Library API conventions for message handling and return status. It is referenced by two other packages — IGC_CC_INT_CC_REL_PUB and IGC_CC_OPN_UPD_GET_LNK_PUB — confirming that it functions as a shared utility layer invoked by higher-level public APIs rather than being called directly by end users.

Typical invocation occurs when a user maintains IGC system options through the relevant setup form, when a higher-level contract API requests an automatically generated number, or when validation of a manually entered number is required. Custom development should not bypass the package and manipulate IGC_CC_SYSTEM_OPTIONS_ALL directly, since doing so would skip the locking, uniqueness, and validation logic enforced by LOCK_ROW, CHECK_UNIQUE, and VALIDATE_NUMERIC_CC_NUM. In Oracle EBS 12.2.2 the package retains the same structure and dependencies documented for 12.1.1.