Search Results update_exp_rev_cat

Overview

APPS.GMS_COST_PLUS_EXTN is a PL/SQL package in the Oracle E-Business Suite Grants Management (GMS) module. It provides the cost-plus and burdening extension logic that supports award costing, sponsored project processing, and funds control for grant-funded expenditures. In Oracle EBS 12.1.1 and 12.2.2, this package is a critical component of the Grants Management cost processing infrastructure, operating at the intersection of Oracle Payables (AP), Oracle Projects (PA), and the GMS awards schema.

The package carries an API classification of OTHER, indicating it is an internal utility package invoked by other GMS APIs and packages rather than a public, user-facing interface. Its status is VALID in the APPS schema, and it is documented in ETRM for 12.2.2 with cross-references relevant to 12.1.1 as well. The package encapsulates logic for determining award indicators, compiled set identifiers, burdenable raw costs, prepayment burden calculations, and burden allowance checks — all of which are essential to correctly applying indirect cost (burden) rates and identifying sponsored versus non-sponsored activity in a grants context.

Key Procedures and Functions

ETRM documents twelve procedures and functions within GMS_COST_PLUS_EXTN. Their purposes, based on documented naming and typical GMS usage, are as follows:

• GET_AWARD_IND_RATE_SCH_REV_ID — Retrieves the indirect rate schedule revision identifier associated with an award, used when determining which burden rates apply.
• GET_AWARD_CMT_COMPILED_SET_ID — Returns the compiled commitment set identifier for an award, supporting commitment compilation and tracking.
• AWARD_CMT_COMPILED_SET_ID — A related routine dealing with the award-level commitment compiled set identifier.
• GET_AWARD_COMPILED_SET_ID — Retrieves the general compiled set identifier for an award, used in cost and burden compilation.
• GET_BURDENABLE_RAW_COST — Determines the raw cost amount eligible for burdening, a core input to burden computation.
• BURDEN_ALLOWED — Evaluates whether burden is permitted for a given expenditure or distribution, acting as a gating check.
• UPDATE_BC_PKT_BURDEN_RAW_COST — Updates burden raw cost values for burden cost (BC) packets, driving packet-level cost adjustments.
• UPDATE_SOURCE_BURDEN_RAW_COST — Updates source burden raw cost, propagating corrected cost values back to originating records.
• UPDATE_TOP_TSK_PAR_RES — Updates top task parent resources, supporting task hierarchy and resource rollups in award costing.
• UPDATE_EXP_REV_CAT — Updates expenditure revenue categories, linking expenditures to the correct revenue classification.
• IS_SPON_PROJECT — A predicate function that returns whether a project is sponsored, a frequent decision point in grants costing.
• CALC_PREPAYMENT_BURDEN — Calculates burden on prepayment amounts, ensuring prepayments receive correct indirect cost treatment.

No parameter lists are documented in ETRM; invocation should rely on the package specification shipped in the APPS schema.

Tables Accessed

GMS_COST_Plus_EXTN reads and writes a broad set of APPS tables, many accessed via synonyms. Documented base tables include AP_INVOICE_DISTRIBUTIONS_ALL (invoice distribution lines), AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_SELF_ASSESSED_TAX_DIST, and AP_SELF_ASSESSED_TAX_DIST_ALL (tax distributions), which supply actual cost and tax data. GMS_AWARD_DISTRIBUTIONS provides award-level distribution detail.

Additional documented tables include GMS_AWARDS and GMS_AWARDS_ALL for the award master and translation rows, GMS_AWARD_EXP_TYPE_ACT_COST for award expenditure type actual cost, GMS_ALLOWABLE_EXPENDITURES for allowable expenditure definitions, GMS_ADJUSTMENTS_ID_S for adjustment identifiers, and GMS_BC_PACKETS, GMS_BC_PACKETS_S, and GMS_BC_PACKET_ARRIVAL_ORDER for burden cost packet processing. GL_LEDGERS is referenced for ledger context. These tables supply the raw cost, burden, commitment, and award attributes required by the package's procedures and functions.

Usage Notes

GMS_COST_PLUS_EXTN is not typically invoked directly by end users. It is referenced by several GMS packages and views: GMS_AP_API, GMS_PA_API, GMS_PA_COSTING_PKG, GMS_FUNDS_CONTROL_PKG, GMS_COST_PLUS_EXTN itself, and the views GMS_COMMITMENTS_OVERRIDE_V, GMS_COMMITMENT_TXNS_V, and GMS_ENC_PSI_V. This dependency pattern indicates the package executes during Payables invoice costing, Projects cost distribution, funds control checking, and commitment/encumbrance processing for grants.

Concurrent programs such as award costing, burden processing, and commitment compilation in Grants Management will trigger this logic indirectly. Custom code extending GMS costing should call documented procedures rather than duplicate burden and sponsorship logic, ensuring consistency with Oracle's funds control and cost-plus rules. Because only the package specification is public, customizations should be validated against the specific patch level of 12.1.1 or 12.2.2 in use.