Search Results gms_oie_int_pkg




Overview
Explore in AI Chat

Overview

APPS.GMS_OIE_INT_PKG is a PL/SQL integration package in Oracle EBS Grants Management (GMS), part of the Oracle Grants/Projects suite. Its header declares the package with AUTHID CURRENT_USER, meaning all unqualified object references resolve under the privileges of the invoking schema rather than the defining schema — a convention typical of APIs intended to be called from forms, concurrent programs, and custom code running as APPS. The package's stated purpose is to bridge Oracle Internet Expenses (OIE) and Oracle Grants by supplying award validation, award lookup, and award distribution creation logic. Its naming (OIE_INT) indicates integration between expense-report processing and sponsored award accounting. Within the 12.1.1 / 12.2.2 documented metadata it is classified as an OTHER API, exposing 13 documented procedures and functions. It references seven application tables plus DUAL, and it is referenced by six other packages, confirming its role as a shared utility used across the Grants schema.

Key Procedures and Functions

The documented program units fall into three functional groups.

  • Error handling: RAISEEXCEPTION is the package's common routine for unrecoverable database errors; it accepts a calling sequence, debug information, an FND message name, and message parameters, and raises a standardized FND-style error.
  • Award lookup utilities: GETAWARDNUMBER, GETAWARDINFO, and GETAWARDID each return BOOLEAN to signal success or failure, retrieving an award number from an award ID, an award ID and name from an award number, and an award ID from an award number, respectively. Three additional validators — ISSPONSOREDPROJECT, ISGRANTSENABLED, ISAWARDVALID, and GMS_ENABLED — test whether a project is sponsored, whether Grants is enabled, whether an award is valid, and whether the GMS module is enabled generally.
  • Distribution processing: AWARDFUNDINGPROJECT, DOGRANTSVALIDATION, CREATEACGENADL, DELETEACGENADL, and CREATE_AWARD_DISTRIBUTIONS perform the substantive work. CREATE_AWARD_DISTRIBUTIONS, the procedure matching the user's search term, is the entry point that generates award distribution records. CREATEACGENADL and DELETEACGENADL create and remove award distribution lines associated with the GMS_ADLS_AWARD_SET_ID_S sequence, while DOGRANTSVALIDATION performs the Grants-specific validation checks that must succeed before distributions are written. AWARDFUNDINGPROJECT resolves the funding project associated with an award. Subtypes gms_awardNum, gms_awardId, and gms_awardName anchor these APIs to columns in GMS_AWARDS_ALL.

Tables Accessed

The package reads and writes through APPS synonyms across the following documented tables:

  • GMS_AWARDS_ALL — the source of award numbers, IDs, and short names for all lookup functions.
  • GMS_AWARD_DISTRIBUTIONS — the primary target table populated by CREATE_AWARD_DISTRIBUTIONS.
  • GMS_ADLS_AWARD_SET_ID_S — the sequence supplying award distribution set identifiers used by CREATEACGENADL.
  • PA_PROJECTS_ALL — used to resolve project information for award funding project determinations.
  • AP_INVOICE_DISTRIBUTIONS_ALL — expense and invoice distribution data validated or used when building award distributions.
  • AP_EXPENSE_REPORT_HEADERS_ALL and AP_EXPENSE_REPORT_LINES_ALL — Internet Expenses report header and line data examined during OIE integration and Grants validation.
  • DUAL — used for single-row computations and existence checks.
  • PLITBLM — a PL/SQL table type used internally for array processing.

Usage Notes

GMS_OIE_INT_PKG is invoked programmatically rather than through a dedicated form. Typical callers include Internet Expenses expense-report workflows, Grants award distribution concurrent programs, and the six dependent packages that call its validators. Custom code should call CREATE_AWARD_DISTRIBUTIONS only after confirming the award is valid and Grants is enabled via ISAwardValid and GMS_Enabled, and should follow the FND message conventions established by RaiseException so that errors surface consistently. Because the package executes under AUTHID CURRENT_USER, ensure the invoking schema has execute privilege on the package and appropriate DML access to the underlying GMS and AP tables. As with all Grants integration APIs in 12.1.1 and 12.2.2, transactions should be committed by the caller after verifying the BOOLEAN return values.