Search Results get_proposal_numbering_method




Overview
Explore in AI Chat

Overview

IGW_CREATE_PROPOSAL_PVT is a private PL/SQL package body in the APPS schema that supports the creation of proposals within the Oracle E-Business Suite Grants and Proposal (IGW) module. Its primary business function is to centralize the internal logic used when a new proposal record is constructed, including the resolution of proposal numbering methods, lookup code translations, party identifiers, and organization identifiers. The package is classified as a private (PVT) API, meaning it is not intended to be called directly by external integrations, and instead operates as a supporting layer for the public proposal-creation interfaces that surface through the Grants forms and related concurrent processes.

Key Procedures and Functions

  • GET_PROPOSAL_NUMBERING_METHOD — Returns the numbering method applied when generating proposal numbers. This governs whether proposal numbers are system-generated or manually entered, and it is a prerequisite for correctly sequencing new proposal identifiers.
  • IS_POSITIVE_INTEGER — A validation helper that evaluates a supplied value and returns a Boolean indicating whether it represents a positive integer. This supports input validation during proposal creation.
  • GET_PARTY_ID — Resolves a party identifier using party type, party ID, or party name inputs. This allows the package to link a proposal to the correct trading partner or party record maintained in the TCA (Trading Community Architecture) model.
  • CREATE_PROPOSAL — The principal procedure responsible for assembling and inserting the proposal record into the underlying proposal table, drawing upon the helper functions above to resolve numbering, party, and organizational context.

Additional internal helpers visible in the source—such as GET_LOOKUP_CODE, GET_ORGANIZATION_ID, and GET_PROPOSAL_ID—serve similar resolution roles for lookup meanings, HR organization units, and existing proposal identifiers respectively.

Tables Accessed

  • IGW_PROPOSALS_ALL — The core proposal table where newly created proposal records are written and from which existing proposal data is validated or retrieved. All creation activity ultimately targets this table.
  • HZ_PARTIES — Accessed through the GET_PARTY_ID routine to resolve and validate the party associated with a proposal, ensuring referential integrity with the TCA registry.

The documented metadata references these tables via APPS synonyms, consistent with standard EBS schema access conventions. Because the package body appears partially stubbed in the excerpt (several functions contain a NULL body), the functional logic in this baseline may be superseded by higher-version editions of the package.

Usage Notes

As a PVT-classified package, IGW_CREATE_PROPOSAL_PVT is not a supported public entry point and is referenced by zero other documented packages within the ETRM metadata. It is typically invoked indirectly—most commonly through the Oracle Grants Proposal entry forms or through internal concurrent program logic that constructs proposal records on behalf of a user. Custom code should not call this package directly, as Oracle does not guarantee the stability of private APIs across patch levels. Integrators seeking to create proposals programmatically should use the supported public APIs in the IGW schema. The user search term "get_proposal_id" corresponds to the internal resolution function within this package that locates an existing proposal identifier, reinforcing the package's role as an internal utility rather than an integration surface.