Search Results create_release

Overview

PO_GMS_INTEGRATION_PVT is a private PL/SQL package in the APPS schema that provides the integration layer between Oracle Purchasing and Oracle Grants Management (GMS). Its central responsibility is to maintain Award Distribution Lines (ADL) on award records when Purchasing distribution lines are created, changed, or deleted in contexts that reference a sponsored award. The package is declared with AUTHID CURRENT_USER, meaning that privilege checking is performed against the invoking user rather than the package owner, which is appropriate for an internal integration utility invoked from within the Purchasing application stack.

The business problem addressed is that a purchasing document distribution may be associated with a project funded by an award. When that distribution is generated or modified — for example through document copy, autocreate from requisitions, the release process, or an amendment — the corresponding award distribution lines in Grants must be synchronized so that award balances, billing, and reporting remain accurate. PO_GMS_INTEGRATION_PVT encapsulates the logic and the calls into the Grants APIs that perform this synchronization, insulating the Purchasing code paths from the details of the GMS data model.

The user search term "create_release" corresponds to one of the recognized values of the p_caller parameter of the package's primary routine, MAINTAIN_ADL. When purchasing releases are created, the caller passes CREATE_RELEASE so that the integration logic can identify the originating business event and process award distribution lines accordingly, alongside the other supported callers AUTOCREATE, CHANGEPO, and COPYDOC.

Key Procedures and Functions

• MAINTAIN_ADL — The core public routine. It is invoked when PO or requisition distribution lines are created from CopyDoc, Autocreate, the PO Release process, or Change PO, and it calls the Grants API to generate new award distribution lines when the parent distribution record references an award. It accepts an API version, a caller identifier (AUTOCREATE, CHANGEPO, COPYDOC, CREATE_RELEASE), and an IN OUT object of type gms_po_interface_type that carries distribution identifiers, numbers, project and task identifiers, and award set references. It returns the standard EBS API status (x_return_status of S, E, or U) together with message count and message data.
• MAINTAIN_PO_ADL — Supports the maintenance of award distribution lines specifically in the Purchasing context, providing the entry point used by PO-side processing.
• GET_GMS_ENABLED_FLAG — Returns the flag indicating whether Grants Management integration is enabled, allowing callers to short-circuit processing when GMS is not installed or configured.
• IS_GMS_ENABLED — Boolean-style check used internally and by callers to determine whether GMS functionality is active before attempting award-related work.
• VALIDATE_AWARD_DATA — Validates the award-related data supplied on the interface structure prior to invoking Grants APIs, guarding against incomplete or inconsistent input.
• GET_AWARD_ID — Resolves the award identifier associated with a given distribution or project, supplying the key needed to locate the correct award record.
• GET_NUMBER_FROM_AWARD_SET_ID — Derives the award set number from an award set identifier, used when populating or interpreting the interface object.
• IS_AWARD_REQUIRED_FOR_PROJECT — Determines whether a project requires award processing, allowing the integration to be skipped for non-sponsored projects.

Tables Accessed

The package accesses GMS_AWARDS_ALL to retrieve and validate award information, including award identifiers and the attributes needed to drive the Grants APIs. It references PO_DISTRIBUTIONS_ALL as the source of the purchasing distribution records whose creation or modification triggers award distribution line maintenance. PLITBLM is referenced as the standard EBS message-list table used by the API messaging framework to accumulate and return validation and error messages to the caller through the message count and message data output parameters. Together these tables support the read of purchasing distribution context, the lookup and validation of the governing award, and the return of diagnostic messages.

Usage Notes

PO_GMS_INTEGRATION_PVT is an internal (PVT) package and is not intended as a public integration surface. It is invoked programmatically from within the Purchasing application logic — notably from the release generation, autocreate, copy document, and change order flows — rather than directly from a form or concurrent program. Because MAINTAIN_ADL expects a populated gms_po_interface_type object and a caller designation such as CREATE_RELEASE, custom code that needs equivalent behavior should call the public Grants and Purchasing APIs rather than this private routine. The package is referenced by seven other packages, reflecting its role as a shared, low-level service in the Purchasing-to-Grants integration chain. Any customization should account for the fact that the package header dates to release 12.0 and that its signature is consumed by dependent code across the application.