Search Results vert_transfer




Overview
Explore in AI Chat

Overview

APPS.PA_GMS_API is the integration bridge between Oracle Projects and Oracle Grants Management (GMS) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to apply Grants-specific business rules and validation logic to expenditure items processed within Projects, without requiring Grants to duplicate the core transaction engine. The package header carries the version marker $Header: PAXGMS1S.pls 120.3 2006/08/26, indicating that the interface has remained stable across the 12.x release family.

The library exposes nineteen documented functions and procedures. Several act as installation and configuration probes (VERT_INSTALL), several validate whether a given expenditure item is eligible for adjustment, transfer, or award reassignment, and others support the creation of Award Distribution Lines (ADLS) when expenditure items arrive through the Payables invoice interface, the Loader/Web ADI interface, or the LD (Labor Distribution) interface. Internal session context — project, award, adjust action — is managed through a group of VERT_SET_* and VERT_GET_* helpers.

PA_GMS_API is referenced by ten other packages, confirming it is a shared service consumed across the Projects and Grants product boundary rather than a standalone entry point.

Key Procedures and Functions

  • VERT_INSTALL — Returns a Boolean indicating whether the Grants Management module is installed and active in the current instance. Used by callers to short-circuit Grants-specific processing.
  • VERT_ALLOW_ADJUSTMENTS — Validates whether a specific expenditure item is eligible for adjustment. This is the function most closely associated with the search term "vert_allow_adjustments"; it is invoked from the Expenditure Inquiry adjustment path and from custom validation extensions.
  • VERT_TRANSFER — Performs additional validation on an expenditure item before it is transferred, returning a Boolean and populating an error message variable.
  • VERT_ADJUST_ITEMS — Bulk handler that drives the adjustment validation across a set of rows, accepting a calling process name and returning a status code.
  • VERT_ALLOW_ACTION — Compares the requested adjustment action (for example, a mass adjustment) against the award and returns a result string.
  • VERT_TRX_INTERFACE — Creates ADLS for expenditure items generated through the PA interface from Payables or LD; called after PA_TRX_IMPORT.NEWexpend.
  • VERT_PAAP_SI_ADJUSTMENTS, VERT_APP_VALIDATE, VERT_SI_ADJ — Support the Supplier Invoice / Payables adjustment paths, validating and applying Grants adjustments on invoice-related expenditure.
  • IS_SPONSORED_PROJECT — Determines whether the current project is associated with an award.
  • VERT_GET_AWARD_ID, VERT_GET_AWARD_NUMBER, VERT_GET_EI_AWARD_ID, VERT_GET_SRC_DEST_AWARD_ID — Accessors returning award identifiers and numbers for the session, the expenditure item, and the source/destination pair during a transfer.
  • VERT_SET_ADJUST_ACTION, VERT_SET_PROJECT_ID, VERT_SET_AWARD_ID — Session-context setters that seed the package with the values used by the validation functions.
  • VERT_EI_AWD_EQUALS_SRC_AWD — Tests whether the expenditure item's award matches the source award, used in transfer validation.
  • VERT_IS_AWARD_WITHIN_RANGE — Confirms that an award falls within an allowable range for the requested action.

Tables Accessed

The package reads and writes two principal tables through APPS synonyms:

  • GMS_AWARDS_ALL — The base award table. Read to resolve award identifiers, numbers, and ranges, and to determine award status for adjustment and transfer eligibility.
  • PA_EXPENDITURE_ITEMS_ALL — The core Projects expenditure item table. Used to look up the item being validated and to write distribution changes resulting from award adjustments and ADLS creation.

Usage Notes

PA_GMS_API is not intended for direct end-user invocation. It is called programmatically from the Expenditure Inquiry form, from concurrent programs such as the mass adjustment and interface import processes, and from the PA transaction import routines following expenditure creation. Custom extensions that need to enforce Grants adjustment rules should call VERT_ALLOW_ADJUSTMENTS or the VERT_ALLOW_ACTION/VERT_SET_* pair rather than reading the underlying tables directly, since the package encapsulates award-range and sponsored-project logic. Because the API classification is documented as API, the signatures are treated as public and are supported for integration use, but callers should guard Grants-dependent calls with VERT_INSTALL.