Search Results igw_awards_pvt

Overview

IGW_AWARDS_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the IGW module, the Grants Accounting and Awards Management application set that underpins Oracle Grants Management. The suffix PVT classifies the package as a private API layer: it holds the core business logic for creating, maintaining, and finalising award records, and it is not intended for direct invocation by external consumers. Public entry points and forms screens delegate work to this package rather than manipulating award tables directly, which preserves encapsulation and keeps validation, numbering, and referential integrity rules in a single location.

The package status is documented as VALID in the ETRM reference, confirming that the specification and body compile cleanly against the APPS schema. Its dependency list shows direct references to APPS.FND_API, the Oracle Application Object Library public API utility package, and to SYS.STANDARD. The FND_API reference is significant: it indicates that the package uses the standard EBS error-handling and message-stack conventions, including the familiar x_return_status, x_msg_count, and x_msg_data out-parameters, and that callers should expect messages to be posted to the FND message stack on failure.

Key Procedures and Functions

The documented interface exposes eight procedures and functions, covering the full award lifecycle:

• CREATE_AWARD — inserts a new award header record, applying validation and defaulting rules before committing the award to the base tables.
• CREATE_AWARD_INSTALLMENT — creates an installment line associated with an existing award, used when award funding is scheduled across multiple payment periods.
• UPDATE_AWARD — modifies attributes of an existing award record while enforcing change-control and validation rules.
• DELETE_AWARD — removes an award record, subject to the referential and status checks that prevent deletion of awards with dependent transactions.
• TRANSFER_AWARD_INSTALLMENT — moves an installment from one award to another, supporting reallocation and correction scenarios.
• GET_AWARD_NUMBERING_METHOD — returns the numbering scheme configured for awards, allowing the caller to obtain the correct document sequence or manual numbering rule.
• DELETE_TEMP_AWARD — removes a temporary, not-yet-permanent award record, typically created during data entry or an import process and abandoned before validation completed.
• MAKE_PERMANENT — promotes a temporary award to permanent status, the final step in the entry workflow.

Tables Accessed

The ETRM metadata for this package does not enumerate the underlying tables, listing the referenced-table section as empty. Based on the procedure semantics, the package manipulates the award and award installment entities within the IGW schema through APPS synonyms. The temporary-versus-permanent distinction implies a staging or temporary award structure that is populated first and then promoted by MAKE_PERMANENT, with DELETE_TEMP_AWARD available to discard abandoned staging rows. Because the tables are reached via APPS synonyms, referential access is consistent with the shared APPS schema model used throughout EBS.

Usage Notes

IGW_AWARDS_PVT is referenced by no other documented packages, which is consistent with its private classification. It is normally invoked indirectly: the Awards entry forms and any concurrent programs that load or convert award data call the public wrapper package, which in turn calls this private implementation. Custom development should not call IGW_AWARDS_PVT directly. Instead, use the supported public IGW awards API, so that validation, message-stack handling through FND_API, and internal logic remain under Oracle's control and are not bypassed. Standard FND_API error handling applies, and callers should check the return status and query the message stack after every call.