Search Results get_major_goals

Overview

IGW_VIEW_PARAMETERS is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. It belongs to the Oracle Grants/Proposal (IGW/GMS) family of modules and is designed as a lightweight, read-only access layer that exposes commonly requested proposal and award attributes to reporting and display routines. The package is declared with AUTHID CURRENT_USER, meaning that privilege resolution occurs under the calling schema rather than the definer, and virtually every function carries a pragma restrict_references(..., wnds) directive. The WNDS (Write No Database State) restriction confirms that these functions do not modify database state; they are pure query helpers intended solely to retrieve values.

In practical terms, IGW_VIEW_PARAMETERS acts as a convenience facade over the underlying Grants tables, sparing developers and form builders from writing repetitive joins against abstract, location, personnel, and cost tables. It is referenced by two other packages, indicating that it is a shared utility embedded within the broader proposal-to-award workflow.

Key Procedures and Functions

The package exposes ten documented functions, all with the WNDS restriction:

• get_project_location_id — Returns the project location identifier associated with a given proposal.
• get_project_location_name — Returns the human-readable location name for a given organization identifier.
• get_major_goals — Returns the major goals narrative for a given proposal. This is the function most commonly targeted by users searching for proposal narrative or goals text.
• get_pi_id — Returns the principal investigator identifier, resolved from either an award or a proposal context.
• get_pi_name — Returns the principal investigator's name for the supplied award/proposal context.
• get_percent_effort — Returns the percent effort attributed to a specified person on a proposal.
• get_direct_cost — Returns the direct cost amount for a given award or proposal.
• get_total_cost — Returns the total cost amount for a given award or proposal.
• get_old_direct_cost — Returns a prior or baseline direct cost value for an award.
• get_old_total_cost — Returns a prior or baseline total cost value for an award.

Note that parameter lists are intentionally omitted here; the metadata documents function existence and purpose, not signatures.

Tables Accessed

The package reads from several core Grants and HR tables via APPS synonyms:

• IGW_PROP_ABSTRACTS — source of proposal narrative content, including major goals text.
• IGW_PROP_LOCATIONS — proposal location associations used by get_project_location_id.
• IGW_PROP_PERSONS — proposal personnel assignments.
• GMS_PERSONNEL — award personnel and effort data.
• GMS_INSTALLMENTS — award funding installment records underpinning cost lookups.
• HR_ALL_ORGANIZATION_UNITS — organization names for location resolution.
• PER_ALL_PEOPLE_F — person records used to resolve principal investigator names.

Usage Notes

IGW_VIEW_PARAMETERS is typically invoked from Oracle Forms, OAF pages, and custom PL/SQL or reports that need to display proposal and award attributes without direct table navigation. Because all functions are WNDS-restricted and AUTHID CURRENT_USER, they are safe to call inside SELECT statements and views. Developers should grant appropriate privileges to the calling schema, since CURRENT_USER semantics require the invoker to have access to the underlying tables. It is frequently used in statement-of-work and proposal summary reports, and is called by two dependent packages. When troubleshooting issues such as missing goals text returned by get_major_goals, verify the corresponding IGW_PROP_ABSTRACTS row exists and that the caller has synonyms and grants in place.