Search Results igs_pe_pers_residency_flex




Overview
Explore in AI Chat

Overview

IGS_CO_GEN_003 is a general-purpose PL/SQL utility package body in the Oracle E-Business Suite student system (IGS) schema, owned by APPS and classified as OTHER under ETRM. It provides reusable data-retrieval functions for correspondence generation and for resolving flexfield and reference-data values associated with applicants, students, and programs. The package is not tied to a single business flow; rather it is called by other packages and by concurrent/form-driven processes that need formatted person, address, descriptive flexfield, or citizenship data. The header comment records creation in February 2002 by rbezawad and a change in January 2004 correcting improper use of the FND_LOOKUP_VALUES view (bug 3349171). The package is referenced by nine other packages, confirming its role as a shared service layer rather than a terminal process.

Key Procedures and Functions

  • GET_PER_ADDR_FOR_CORR — Returns the person name and address used for correspondence, assembling the person name from its component parts (title, first, middle, last, suffix) based on user preferences. The supplied source shows a cursor over HZ_PARTIES joined to FND_LOOKUP_VALUES to resolve the pre-name adjunct, with an outer join so that a person without a matching lookup still returns a name.
  • GET_PRG_APPL_INST_DFF_VALUES — Retrieves descriptive flexfield (DFF) values for a program application instance, surfacing the applicant-instance DFF segments held against IGS_AD_PS_APPL_INST_ALL.
  • GET_PROGRAM_COMPLETION_DT — Returns the program completion date for a student's program record.
  • GET_RESIDENCY_DFF_VALUES — Returns descriptive flexfield values from the residency details record (IGS_PE_RES_DTLS_ALL).
  • GET_STUDENT_CITIZENSHIP_STATUS — Returns the student's citizenship status, derived from extra information type (EIT) data held in IGS_PE_EIT.

The naming pattern indicates each function encapsulates a single lookup or formatting concern, so callers do not repeat join and NVL logic.

Tables Accessed

  • FND_LOOKUP_VALUES — Oracle Application Object Library lookup view, used to translate lookup codes into meanings (for example the person pre-name adjunct).
  • HZ_PARTIES — TCA party table supplying the person name components and party identifier.
  • IGS_AD_PS_APPL_INST_ALL — Admissions program application instance table, source of application-instance descriptive flexfield values (relevant to searches such as igs_ad_appl_inst_flex).
  • IGS_PE_EIT — Person extra information types, source of citizenship-related attributes.
  • IGS_PE_RES_DTLS_ALL — Person residency details, source of residency descriptive flexfield values.

All access is read-only in the documented usage; the package returns values rather than maintaining transactional data.

Usage Notes

Because the package is classified as OTHER and is referenced by nine other packages, it is normally invoked indirectly: a calling PL/SQL package, a correspondence or admissions process, or a personalization executes these functions to obtain formatted names, addresses, DFF values, or citizenship status. Direct calls from a form or concurrent program are possible where a specific value is required at runtime, but the intended pattern is reuse through the calling layer. The outer-joined lookup logic and USERENV('LANG') reference indicate the functions are language-sensitive and safe against missing setup data. The IGS_AD_PS_APPL_INST_ALL function is the relevant entry point when resolving applicant-instance flexfield values surfaced by searches such as igs_ad_appl_inst_flex. Customizations should call these functions rather than re-implementing the joins, preserving the 2004 correction to the FND_LOOKUP_VALUES access and ensuring consistent behavior across Oracle EBS 12.1.1 and 12.2.2.