Search Results is_project_type_sponsored

Overview

The APPS.GMS_PA_API3 package is a PL/SQL API within the Oracle E-Business Suite Grants Management (GMS) module, tightly integrated with Oracle Projects (PA). It supports award and sponsored-project accounting by bridging grant award data with project cost processing, encumbrance tracking, and revenue recognition. Standard status is VALID, and the package is owned by the APPS schema.

In the context of Oracle EBS 12.1.1 and 12.2.2, the package operates as a support layer that governs how sponsored project transactions, encumbrances, cost base definitions, and indirect rate schedules interact with award information. It is classified as OTHER (not a public outbound API intended for direct customer extension), indicating it is primarily invoked internally by other Projects and Grants packages. Its responsibilities center on determining whether awards share common attributes, validating item-task combinations, and marking encumbrance and commitment records for recalculation when underlying project or award conditions change.

Key Procedures and Functions

• GRANTS_ENABLED — Determines whether the Grants Management functionality is enabled in the environment, controlling downstream logic that depends on grant-aware processing.
• OVERRIDE_RATE_REV_ID — Manages override scheduling associated with rate revisions, supporting custom indirect cost treatment.
• IS_AWARD_SAME — Evaluates whether two award references resolve to the same award, useful when aggregating or comparing grant data.
• CREATE_CMT_TXNS — Creates commitment transactions derived from award or project data, feeding the PA commitment transaction tables.
• IS_PROJECT_TYPE_SPONSORED — Tests whether a given project is of a sponsored type, gating award-specific logic.
• MARK_IMPACTED_ENC_ITEMS — Identifies and flags encumbrance items affected by a change, preparing them for recalculation.
• MARK_PREV_REV_ENC_ITEMS — Flags previously recognized revenue encumbrance items that require re-evaluation.
• MARK_ENC_ITEMS_FOR_RECALC — Marks encumbrance items for recalculation, ensuring accuracy after award or rate changes.
• ITEM_TASK_VALIDATE — Validates the combination of an expenditure item and its associated task against award rules.

Tables Accessed

The package reads and writes several Grants and Projects tables through APPS synonyms, including GMS_ALLOWABLE_EXPENDITURES, GMS_AWARDS, GMS_AWARDS_ALL, GMS_AWARD_DISTRIBUTIONS, GMS_ENCUMBRANCES_ALL, GMS_ENCUMBRANCE_ITEMS_ALL, and GMS_OVERRIDE_SCHEDULES. On the Projects side, it touches PA_COMMITMENT_TXNS for commitment records, PA_COMPILED_MULTIPLIERS, PA_COST_BASE_EXP_TYPES, PA_EXPENDITURE_TYPES, PA_IND_COMPILED_SETS, PA_IND_COST_CODES, PA_IND_RATE_SCHEDULES_ALL_BG, and PA_IND_RATE_SCH_REVISIONS. These tables supply award definitions, encumbrance states, indirect cost setups, and rate schedule revisions required for accurate sponsored-project accounting.

Usage Notes

GMS_PA_API3 is referenced by several Projects packages, including PA_CLIENT_EXTN_BURDEN_SUMMARY, PA_COST_PLUS, PA_PROJ_ACCUM_MAIN, and PA_TXN_ACCUMS. Invocation typically occurs through concurrent programs, extension hooks, or internal package calls during project cost accumulation, burden calculation, and revenue processing. Because it is an OTHER-class API rather than a supported public interface, customization should avoid direct calls and instead rely on documented extension points or wrapping packages.