Search Results igw_create_proposal_pvt

Overview

IGW_CREATE_PROPOSAL_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified with an API type of PVT. It belongs to the Oracle Grants Management (IGW) product family and is responsible for the internal creation of proposal records within the Grants Management module. Proposals in Oracle Grants represent the formal requests for funding that precede the award lifecycle; this package encapsulates the core logic required to instantiate a new proposal row, resolve the numbering method to be applied, validate identifying inputs, and derive the party identifier associated with the proposal. Because the package is classified as private (PVT), it is intended for internal consumption by other Grants components rather than as a public, supported integration API, and the documented metadata records that it is referenced by zero other packages.

Key Procedures and Functions

The documented package exposes four procedures and functions, each supporting a discrete step in the proposal creation flow:

• GET_PROPOSAL_NUMBERING_METHOD — Retrieves the numbering method that governs how a proposal number is generated or assigned. This drives whether numbering is manual, automatic, or derived from a configured sequence or lookup.
• IS_POSITIVE_INTEGER — A validation utility that confirms whether a supplied value represents a positive integer. It supports input checking during proposal creation and numbering resolution.
• GET_PARTY_ID — Resolves the party identifier associated with the proposal, tying the proposal to the correct trading party or customer record held in the party model.
• CREATE_PROPOSAL — The primary procedure that performs the actual insertion of the proposal record, orchestrating numbering, party resolution, and validation logic before committing the new proposal.

Parameter lists are not reproduced here, as the documented metadata does not specify them.

Tables Accessed

The package operates against two documented application tables, referenced through APPS synonyms:

• IGW_PROPOSALS_ALL — The core proposals table, which the package writes to when creating a new proposal and reads from during numbering method determination. This is the principal target of the CREATE_PROPOSAL operation.
• HZ_PARTIES — The Oracle Trading Community Architecture parties table, read by GET_PARTY_ID to resolve the party identifier linked to the proposal.

The dependency listing also references FND_LOOKUPS, indicating that proposal numbering or related configuration values are resolved against the standard Oracle lookups repository.

Usage Notes

IGW_CREATE_PROPOSAL_PVT is invoked internally to produce proposal records during Grants Management processing. Typical entry points include the Grants proposal entry forms, concurrent processing that generates proposals programmatically, and other internal Grants packages that require proposal creation services. Because it is a private package and is documented as being referenced by no other packages, custom code should not rely on it as a stable interface; integrators requiring proposal creation functionality should prefer supported, public APIs. Standard dependency caution applies, and any changes to this package should be validated against the Grants proposal lifecycle and the IGW_PROPOSALS_ALL insert path.