Search Results set_award_change_source

Overview

IGF_AW_AWARD_PKG is the core PL/SQL package in the Oracle E-Business Suite Grants Management (formerly Oracle Grants, IGF) schema that encapsulates the row-level data manipulation logic for award records and their associated change history. It belongs to the Awards (AW) module and serves as the primary low-level API through which award header data is inserted, updated, locked, and deleted within the APPS schema. The package is classified as an "OTHER" API rather than a public or private interface, indicating that it is intended for internal use by the Grants Management application rather than for direct customer invocation.

Functionally, the package implements a standard table handler pattern for the award entity. It centralizes the mechanics of maintaining award rows, populating primary and foreign key values needed for validation, applying WHO columns and audit attributes through a BEFORE_DML trigger-style procedure, and preserving an auditable trail of award changes. Its central role is confirmed by the fact that it is referenced by 28 other packages in the IGF schema, making it one of the most widely depended-upon award objects in the module.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, organized into three functional groups.

• Table handler procedures: INSERT_ROW, UPDATE_ROW, ADD_ROW, DELETE_ROW, and LOCK_ROW perform the physical DML against the award tables. LOCK_ROW obtains a row-level lock to serialize concurrent modifications, while the remaining procedures handle creation, modification, and removal of award rows.
• Validation and key resolution functions: GET_PK_FOR_VALIDATION returns the primary key value used by the framework's validation logic. GET_FK_IGF_AW_AWD_RVSN_RSN, GET_FK_IGF_AW_FUND_MAST, GET_FK_IGF_AP_FA_BASE_REC, and GET_FK_IGF_AW_AWD_DIST_PLANS resolve foreign key values for the award revision reason, fund master, base award record, and distribution plans relationships respectively.
• Audit and history procedures: BEFORE_DML applies standard column initialization prior to insert or update. SET_AWARD_CHANGE_SOURCE records the origin of an award modification so downstream history and integration processes can attribute the change correctly. RESET_AWD_HIST_TRANS_ID resets the award history transaction identifier, supporting the sequencing of change tracking records.

The cursor-level dependency on DBMS_LOCK is consistent with the locking behavior expected of LOCK_ROW, while the reference to FND_NEW_MESSAGES indicates that user-facing messages are raised through the standard Oracle Application Object Library message dictionary.

Tables Accessed

The package operates against the principal award tables and their history and validation companions: IGF_AW_AWARD_ALL (the award header), IGF_AW_AWARD_S (the award security/sequence table), IGF_AW_AWD_HIST (the award change history), and IGF_AW_AWARD_LEVEL_HIST and IGF_AW_AWARD_LEVEL_HIST_S (award level history and its sequence). Supporting lookups include IGF_AW_FUND_CAT_ALL for fund category validation, IGF_SL_CLCHSN_DTLS for award classification details, and DUAL for PL/SQL scalar evaluation. DBMS_LOCK is invoked through its public synonym for row locking, and FND_NEW_MESSAGES provides message text retrieval.

Usage Notes

IGF_AW_AWARD_PKG is a server-side handler rather than an end-user entry point. It is invoked from Oracle Forms-based Award maintenance windows, from concurrent programs and generators such as IGF_AW_GEN, IGF_AW_GEN_003, IGF_AW_GEN_005, IGF_AW_SS_GEN_PKG, IGF_AW_PACKAGING, and IGF_AW_CANCEL_AWD, and from integration and detail packages including IGF_AP_FA_BASE_REC_PKG, IGF_AW_AWD_DISB_PKG, IGF_AW_FUND_MAST_PKG, IGF_GR_REPACKAGE, and IGF_SL_LOANS_PKG. Custom development should not call this package directly, because it bypasses higher-level business validation; the supported integration path is the Grants Management public APIs. Developers should instead treat IGF_AW_AWARD_PKG as an internal implementation detail whose signature may change between releases such as 12.1.1 and 12.2.2.