Search Results gms_adjustments_id_s

Overview

GMS_COST_PLUS_EXTN is an APPS-owned PL/SQL package body in Oracle EBS Grants Management (GMS). It extends the Oracle Projects cost-plus burdening engine for sponsored (grant and award) projects, providing the award-specific logic that determines how indirect costs, burden schedules, and revenue categories are applied to expenditures. The package is the sponsored-projects counterpart to the standard PA_COST_PLUS functionality: where PA_COST_PLUS applies a generic burden structure to a project, GMS_COST_PLUS_EXTN resolves the award-level override schedules, compiled cost sets, and sponsored classification flags that govern whether and how a given raw cost may be burdened. It is classified as OTHER rather than a public API, and the ETRM metadata records it as VALID in 12.2.2 with no database object referencing it, meaning it is invoked exclusively as dependent code by other GMS packages. It is referenced by seven other packages, including GMS_BURDEN_ADJUSTMENTS and related burden-processing routines.

Key Procedures and Functions

The package exposes twelve documented procedures and functions, each tied to a facet of award-driven burdening:

• GET_AWARD_IND_RATE_SCH_REV_ID — resolves the indirect rate schedule revision associated with an award, used to select the correct burden rates for a period.
• GET_AWARD_CMT_COMPILED_SET_ID and AWARD_CMT_COMPILED_SET_ID — retrieve and establish the compiled cost set identifier for the award's cost method of transfer, linking expenditures to the correct cost-plus structure.
• GET_AWARD_COMPILED_SET_ID — returns the award-level compiled set, a companion to the CMT variants.
• IS_SPON_PROJECT — a predicate that determines whether a project is a sponsored (award) project, gating the extension logic so standard projects bypass it.
• GET_BURDENABLE_RAW_COST — extracts the raw cost amount eligible for burden application, respecting award allowable-expenditure rules.
• BURDEN_ALLOWED — evaluates whether a transaction is allowable and thus permitted to receive burden.
• CALC_PREPAYMENT_BURDEN — computes burden on prepayment-related distributions, a specialized case in sponsored accounting.
• UPDATE_BC_PKT_BURDEN_RAW_COST and UPDATE_SOURCE_BURDEN_RAW_COST — write adjusted raw cost figures back to burden-cost packets and to the originating source transaction.
• UPDATE_TOP_TSK_PAR_RES — maintains top task and parent resource references used in burden distribution.
• UPDATE_EXP_REV_CAT — updates the expenditure revenue category, aligning the transaction with award revenue recognition.

Tables Accessed

The package reads and writes across three functional areas. Award and burden configuration comes from GMS_AWARDS, GMS_AWARDS_ALL, GMS_AWARD_DISTRIBUTIONS, GMS_BUDGET_VERSIONS, GMS_OVERRIDE_SCHEDULES, GMS_ALLOWABLE_EXPENDITURES, GMS_PROJECT_TYPES, and GMS_AWARD_EXP_TYPE_ACT_COST. Burden processing and packets use GMS_BC_PACKETS, GMS_BC_PACKETS_S, GMS_BC_PACKET_ARRIVAL_ORDER, GMS_BURDEN_ADJUSTMENTS_LOG, PA_COST_BASES, PA_COST_PLUS, and PA_COST_PLUS_STRUCTURES. Transaction and payables detail is sourced from AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, AP_SELF_ASSESSED_TAX_DIST, AP_SELF_ASSESSED_TAX_DIST_ALL, PO_DISTRIBUTIONS, PO_DISTRIBUTIONS_ALL, PO_REQUISITION_HEADERS, PO_REQUISITION_LINES, PO_REQ_DISTRIBUTIONS, PO_REQ_DISTRIBUTIONS_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_TYPES, and GMS_ENCUMBRANCES_ALL with its item and adjustment sequences, including GMS_ADJUSTMENTS_ID_S.

Usage Notes

GMS_COST_PLUS_EXTN is not a standalone public API. It is invoked internally by GMS burdening and award-adjustment packages during cost-plus processing, typically within concurrent programs that generate or adjust burdens on sponsored awards, and from the expenditure adjustment and burden-cost packet flows. Customizations should not call it directly unless they replicate the full award context expected by its caller. The presence of GMS_ADJUSTMENTS_ID_S in its dependency list indicates that the sequence supplies adjustment identifiers when new award adjustment records are created during burden recalculation.