Search Results clean_dangling_adls

Overview

GMS_AWARDS_DIST_PKG is the Oracle Grants Management (GMS) distribution package responsible for maintaining the award distribution lines that link sponsored award funding to the operational transactions that consume it. Within Oracle EBS 12.1.1 and 12.2.2, Grants Management must reconcile expenditures, requisitions, purchase orders, payables invoices, and encumbrances against specific award and funding source combinations. The ADLS (Award Distribution Line Set) records stored in GMS_AWARD_DISTRIBUTIONS capture that reconciliation. This package provides the programmatic interface through which those records are created, maintained, and removed.

The package header, dated 2006 and shipped NOSHIP, declares package-level state used by the associated Workflow process, including G_doc_type and a record index convention that distinguishes six document sources: Requisition (1), PO (2), AP Invoice (3), APD Distribution Set (4), EXP Expenditure Entry (5), and ENC Expenditure Inquiry (6). This indexing scheme reflects the package's central design purpose: translating transaction rows from multiple Oracle sub-ledgers into a single, normalized award distribution structure.

Key Procedures and Functions

• GET_AWARD_SET_ID — Returns the next value from the GMS_ADLS_AWARD_SET_ID_S sequence. Documented to be called before CREATE_ADLS so that the award_set_id is available for the new distribution record.
• CREATE_ADLS — Inserts a new row into GMS_AWARD_DISTRIBUTIONS. Accepts a row type based on that table.
• UPDATE_ADLS — Updates an existing GMS_AWARD_DISTRIBUTIONS record; accepts the same row type convention as CREATE_ADLS.
• DELETE_ADLS — Removes an award distribution record, keyed by the distribution set identifier.
• CLEAN_DANGLING_ADLS — Removes orphaned award distribution lines that no longer have a valid parent transaction.
• COPY_ADLS — Duplicates award distribution records, typically when a source document is copied or a distribution set is re-used.
• COPY_EXP_ADLS — A variant of COPY_ADLS scoped to expenditure-sourced distributions.
• INSSI_ITEMS — Inserts items associated with the award distribution, supporting encumbrance and installment handling.
• UPDATE_BILLABLE_FLAG — Maintains the billable indicator on distribution records, controlling whether a line is passed to billing.
• VERIFY_CREATE_ADLS — Validation routine invoked prior to or during creation to confirm the source transaction is eligible for award distribution generation.

Tables Accessed

The package reads and writes GMS_AWARD_DISTRIBUTIONS as its primary table, with GMS_ADLS_AWARD_SET_ID_S supplying surrogate keys. Source transactions are read from AP_INVOICE_DISTRIBUTIONS_ALL, AP_SELF_ASSESSED_TAX_DIST_ALL, PO_DISTRIBUTIONS_ALL, PO_REQUISITION_LINES_ALL, PO_REQ_DISTRIBUTIONS, PO_REQ_DISTRIBUTIONS_ALL, PA_COST_DISTRIBUTION_LINES_ALL, and PA_EXPENDITURE_ITEMS_ALL, matching the six document types encoded in the package header. Award and funding context is obtained from GMS_INSTALLMENTS, GMS_SUMMARY_PROJECT_FUNDINGS, GMS_ENCUMBRANCE_ITEMS_ALL, and PA_PROJECTS_ALL. DUAL supports sequence selection.

Usage Notes

GMS_AWARDS_DIST_PKG is an internal Grants Management API rather than a public integration point. It is referenced by twenty other packages and is normally invoked from Grants Management forms and concurrent processes that generate or refresh award distributions during requisition, purchasing, payables, and expenditure processing. Custom code should avoid calling CREATE_ADLS, UPDATE_ADLS, or DELETE_ADLS directly against GMS_AWARD_DISTRIBUTIONS without first invoking GET_AWARD_SET_ID and honoring the documented call sequence, because the Workflow integration and downstream billing logic depend on the integrity of the award set identifier. Direct DML against the underlying tables is not supported.