Search Results igw_extension_pkg

Overview

The APPS.IGW_EXTENSION_PKG package is a standalone extension package within the Oracle E-Business Suite (EBS) Grants and Proposal Management / iGrants (IGW) product family. It is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the invoking session user rather than the package owner, which allows the package to respect the security context in which it is called. The package header carries the RCS revision marker igwstxts.pls 115.3 2002/03/28, indicating that it originated early in the product's lifecycle and has remained a lightweight, purpose-built utility. Its documented purpose is to expose a single, narrowly scoped function that resolves the government-issued identifier (government ID) associated with a person record. In the Oracle EBS data model, person records are centrally stored in the PER_ALL_PEOPLE_F entity, and government identifiers such as social security numbers or national tax identifiers are held in the associated PER_PERSON_TYPE_USAGES / person identifier structures keyed on PERSON_ID. The package therefore provides a convenient, reusable abstraction over those person-identity lookups for callers in the iGrants schema and related modules.

Key Procedures and Functions

ETRM documents exactly one programmatic unit on this package:

• PERSON_GOVT_ID — a function that returns a VARCHAR2 value representing the government identifier for a given person. The parameter naming convention (p_person_id) indicates that the caller supplies the Oracle person identifier, and the function returns the corresponding government ID string. The package header applies PRAGMA RESTRICT_REFERENCES(person_govt_id, WNDS), asserting that the function writes no database state. This purity guarantee permits the function to be safely invoked from SQL statements and from contexts that require read-only, deterministic behavior. The function is intentionally the sole entry point of the package, keeping the interface minimal and stable for downstream dependent code.

Tables Accessed

The documented metadata does not enumerate the base tables accessed through APPS synonyms, as the ETRM excerpt records none explicitly. In practice, a function returning a person's government ID operates against the Oracle Human Resources / person data model — principally PER_ALL_PEOPLE_F and the person-identifier tables that store government-issued numbers keyed by PERSON_ID. Because the package is AUTHID CURRENT_USER and the function carries the WNDS pragma, access is read-only: the package retrieves and returns data rather than persisting it. Any additional synonym-level access would reflect the standard APPS security model, allowing the function to resolve person identity records visible to the calling user.

Usage Notes

ETRM records that IGW_EXTENSION_PKG is referenced by three other packages, confirming it functions as a shared extension utility consumed by peer modules rather than being the primary entry point for end-user activity. Typical invocation occurs from Grants/iGrants forms, from other IGW packages that need to display or validate a person's government identifier, and from custom extensions built against the IGW schema. Because PERSON_GOVT_ID is WNDS-pure, it may also be embedded within SQL SELECT lists. In Oracle EBS 12.1.1 and 12.2.2, the package should be treated as a read-only helper for person-government-ID resolution; custom development relying on it should invoke it through APPS synonyms and honor the caller's security context implied by the AUTHID CURRENT_USER declaration.