Search Results convert_cc_to_po




Overview
Explore in AI Chat

Overview

IGC_CC_PO_INTERFACE_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that belongs to the Oracle Contracts (IGC) module, specifically the Contract Commitment (CC) to Purchase Order integration. The package provides the programmatic bridge that converts contract commitment headers maintained in the IGC application into standard Oracle Purchasing documents. It is declared with AUTHID CURRENT_USER, meaning its database objects and privileges resolve against the calling schema rather than the defining schema, which is typical of public EBS APIs intended to be invoked from forms, concurrent programs and custom code alike.

The package follows the standard EBS API scaffolding conventions: every documented procedure accepts the p_api_version, p_init_msg_list, p_commit and p_validation_level parameters and returns the standard x_return_status, x_msg_count and x_msg_data triplet. This uniform signature allows callers to invoke the procedures using the FND_API error-handling and message-stack framework.

Key Procedures and Functions

The package exposes three documented procedures, each keyed on a contract commitment header identifier (p_cc_header_id):

  • UPDATE_PO_APPROVED_FLAG — The procedure that users locate when searching for "update_po_approved_flag". It synchronises the approved status of the associated purchase order with the state of the contract commitment header, updating the PO approval attribute so the purchasing document reflects the commitment's approval outcome.
  • CONVERT_CC_TO_PO — The core conversion routine that transforms a contract commitment header and its associated accounting and detail lines into the corresponding Purchasing entities (headers, lines, line locations and distributions), thereby creating the actual PO document from the commitment.
  • LOCK_PO_ROW — A concurrency-control procedure that attempts to lock the PO row associated with the given commitment header, returning x_row_locked to indicate whether the lock was obtained, thereby preventing simultaneous modification of the same purchasing record.

Tables Accessed

The package operates across two data domains. The IGC commitment side is represented by IGC_CC_HEADERS (the driving header record), IGC_CC_ACCT_LINES and IGC_CC_DET_PF (accounting and detail/price-flexfield information). The Purchasing side is represented by PO_HEADERS_ALL and PO_HEADERS_S, PO_LINES_ALL and PO_LINES_S, PO_LINE_LOCATIONS_ALL and PO_LINE_LOCATIONS_S, PO_DISTRIBUTIONS_ALL and PO_DISTRIBUTIONS_S, plus the reference tables PO_LINE_TYPES_B and PO_LINE_TYPES_TL used to classify and describe PO lines. Support tables include FND_USER (likely for audit/defaulting and lock ownership) and GL_PERIODS (used to derive accounting period information for the generated distributions). The _S date-tracked tables are populated alongside their _ALL counterparts to maintain EBS date-tracking integrity.

Usage Notes

The package is referenced by ten other packages, confirming it is a shared integration point rather than a standalone utility. It is typically invoked when a contract commitment is progressed to a purchasing document: CONVERT_CC_TO_PO performs the creation, LOCK_PO_ROW guards against concurrent edits, and UPDATE_PO_APPROVED_FLAG keeps the PO approval indicator consistent with the commitment. Callers should supply a valid p_api_version, pass p_commit appropriately, initialise the message list when required, and inspect x_return_status and the message stack to detect error conditions. Because it is a public EBS API, it may be called from Oracle Forms, concurrent programs or custom PL/SQL, and any modification of contract commitment or purchase order data outside these procedures risks desynchronising the two applications.