Search Results create_releases

Overview

The APPS.IGC_CC_INT_CC_REL_PUB package is a public PL/SQL API within the Oracle E-Business Suite Contracts Commitment (IGC) module, specifically belonging to the Contracts Core (CC) sub-component. Its primary business function is to programmatically generate commitment releases against an existing contract commitment header. In ETRM-based procurement and contract management flows, a commitment represents an obligation to spend against a contract; when actual invoices or purchasing documents are matched, a release must be created to draw down the committed amount. This package encapsulates that logic, allowing external callers — such as Accounts Payable invoice validation, purchasing workflows, or custom extensions — to create a release record tied to an AP invoice, vendor, and contract commitment header without directly manipulating the underlying IGC tables.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is standard for many EBS public APIs that rely on the caller's session context (including org_id and sob_id).

Key Procedures and Functions

The documented API exposes a single public procedure: create_releases. This procedure is the principal entry point for release generation. Its purpose is to accept identifying context for a contract commitment and an associated invoice, validate the invocation, and insert a new commitment release record, returning the generated release number to the caller.

While the ETRM excerpt documents the parameter list of create_releases, the parameters themselves are not individually re-listed here beyond their role as defined inputs and outputs. The inputs supply the organizational context (p_org_id), set of books (p_sob_id), the source contract commitment header (p_cover_cc_header_id), the AP invoice reference and amount (p_invoice_id, p_invoice_amount), vendor (p_vendor_id), and audit/user context (p_user_id, p_login_id). Standard EBS API conventions apply: p_api_version, p_init_msg_list, p_commit, and p_validation_level control versioning, message stack initialization, transaction commit behavior, and validation rigor.

The outputs follow EBS conventions: x_return_status reports success, error, or unexpected status; x_msg_count and x_msg_data convey diagnostic messages; and x_release_num returns the newly created release number from the commitment header sequence.

Tables Accessed

The package interacts with a defined set of tables, all referenced through APPS synonyms:

• IGC_CC_HEADERS and IGC_CC_HEADERS_S — the commitment header and its primary key sequence, used to read contract context and derive the new release number.
• IGC_CC_ACCT_LINES and IGC_CC_ACCT_LINES_S — accounting distribution lines associated with the commitment, read or written to keep release accounting consistent.
• IGC_CC_DET_PF and IGC_CC_DET_PF_S — the detail/performance (public function) base and sequence tables supporting commitment detail records.
• IGC_CC_SYSTEM_OPTIONS_ALL — organizational system options that control validation and defaulting behavior.
• AP_INVOICES_ALL — the AP invoice against which the release is created, supplying invoice amount and identity.
• FND_USER and FND_LOGINS — used to resolve and validate the calling user and login context.
• DUAL — used for singleton computations and sequence value retrieval.

Usage Notes

IGC_CC_INT_CC_REL_PUB.create_releases is typically invoked from AP invoice validation or matching logic when a contract commitment must be released, from Oracle Forms-based contract management UIs, or from custom PL/SQL integration code. Because it is classified as a PUB API, it is the supported integration surface and should be called rather than direct DML on the IGC tables. Callers should honor the p_init_msg_list, p_commit, and validation-level conventions, and always inspect x_return_status and the message stack. The API is not referenced by other documented packages, indicating it is a leaf-level public interface intended for external callers.