Search Results delete_personnel_related_data




Overview
Explore in AI Chat

Overview

IGW_GR_PERSONNEL is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its name associates it with the Grants (IGW) module, and the "GR" prefix and proposal-oriented parameters indicate it serves the Grants Proposal and personnel tracking functionality. The package encapsulates reusable business logic used to retrieve and manipulate personnel-related data attached to a proposal, such as the individuals associated with a grant application, their sponsor information, their assignment dates, and their biographical records.

The header comment ($Header: igwgrpersonnelb.pls 120.3 2005/09/30) indicates the package has been maintained since the early 2000s, consistent with the 11i lineage carried forward into EBS 12.1.1 and 12.2.2. The package is classified under the ETRM metadata as an "OTHER" API rather than a formal Public or Private API, meaning it is intended primarily for internal use by the Grants forms and concurrent programs rather than as a published integration interface.

Key Procedures and Functions

The ETRM documentation records nine procedures and functions. The following are the documented entry points:

  • MIN_PERSONNEL_START_DATE — Returns the earliest start date for a given person on a given proposal. Takes a proposal identifier and a person party identifier and returns a DATE.
  • MAX_PERSONNEL_END_DATE — Returns the latest end date for a given person on a given proposal, accepting the same proposal and person party identifiers and returning a DATE.
  • GET_SPONSOR_NAME — Retrieves the display name of a sponsor based on a sponsor identifier, returning a VARCHAR2.
  • GET_PERSON_NAME — Returns the formatted name of a person given a person party identifier, returning a VARCHAR2.
  • GET_MAJOR_GOALS — Returns the major goals text associated with a proposal, based on the proposal identifier, returning a VARCHAR2.
  • GET_FORMATTED_ADDRESS — Returns a formatted, concatenated address string for a person or party, typically composing address lines, city, state, and postal code into a single display value used by the Grants personnel forms.
  • POPULATE_BIO_TABLES — Populates the biographical data tables maintained for personnel attached to proposals.
  • ADD_OTHER_SUPPORT_COMMITMENTS — Inserts or records "other support" commitment information for personnel.
  • DELETE_PERSONNEL_RELATED_DATA — Removes personnel-related records, commonly invoked when a person is detached from a proposal.

Tables Accessed

The ETRM metadata documents HZ_PARTIES as the primary table referenced through APPS synonyms. HZ_PARTIES is the Trading Community Architecture (TCA) registry of parties, including persons and organizations. The personnel functions rely on it to resolve party identifiers into names and addresses — for example, GET_PERSON_NAME and GET_FORMATTED_ADDRESS derive their display output from party records. Because several functions return names and addresses in the format expected by the Grants UI, HZ_PARTIES is central to the package's read operations. The write-oriented routines, such as POPULATE_BIO_TABLES, ADD_OTHER_SUPPORT_COMMITMENTS, and DELETE_PERSONNEL_RELATED_DATA, also operate against personnel and proposal tables within the IGW schema, though only HZ_PARTIES is explicitly documented.

Usage Notes

IGW_GR_PERSONNEL is referenced by no other packages per the ETRM metadata, confirming that its callers are external to the PL/SQL dependency graph — typically the Oracle Forms screens in the Grants Proposal module (such as the Personnel and Biography forms), report definitions, and occasional custom extensions. The query "get_formatted_address" points to a common requirement: displaying a reliable, concatenated address for a person in a form field or report. Because the package accepts party identifiers and returns formatted strings, it is appropriate for read-only display and validation logic rather than for bulk processing. Its exception handlers generally return NULL on error, so callers should treat absent values as non-fatal and supply their own defaults.