Search Results check_mand_person_type

Overview

IGS_AD_GEN_001 is a general-purpose PL/SQL package in the APPS schema within Oracle E-Business Suite, owned by the Student System (IGS) product family and specifically associated with the Admissions (IGS_AD) module. It serves as a shared utility and maintenance package for admissions processing in Oracle Student System across EBS 12.1.1 and 12.2.2. Based on its documented contents, the package provides two distinct categories of functionality: administrative cleanup routines that purge historical admission and application- decision records, and lightweight utility routines that support person-type validation, form context resolution, and token handling.

The package sits near the base of the admissions dependency hierarchy. It is referenced by five other packages — IGS_AD_APPL_PKG, IGS_AD_PANEL_DTLS_PKG, IGS_AD_PNMEMBR_DTLS_PKG, IGS_AD_PS_APPL_INST_PKG, and IGS_AD_PS_APPL_PKG — indicating that it is called from application maintenance, panel detail, and prospect/application processing logic. It also carries a self-reference, confirming internal calls between its own routines.

Key Procedures and Functions

The documented interface exposes eight procedures/functions:

• ADMP_DEL_AA_HIST — Deletes historical admission-application (AA) records, part of the admissions purge family.
• ADMP_DEL_ACAIU_HIST — Deletes historical admissions applicant/instance unit records, supporting cleanup of obsolete application-instance history.
• ADMP_DEL_ACAI_HIST — Deletes historical admissions applicant-instance records.
• ADMP_DEL_ACA_HIST — Deletes historical admissions applicant (ACA) records.
• ADMP_DEL_SCA_UNCONF — Removes unconfirmed student/admissions candidate application data, allowing abandoned or unconfirmed submissions to be purged.
• SET_TOKEN — Establishes or initialises a token value used for session or transactional context within admissions processing.
• CHECK_MAND_PERSON_TYPE — Validates whether a mandatory person type has been supplied or is valid for the current admissions transaction.
• GET_USER_FORM_NAME — Returns the current user-facing form name, typically for messaging, logging, or context identification.

The ADMP_DEL_* routines share a common naming convention (ADMP = Admissions maintenance/delete, DEL = delete, HIST = history), indicating they are invoked together by housekeeping or archival programmes. The four remaining routines are utility helpers rather than transactional APIs.

Tables Accessed

The package reads and writes a broad set of admissions, student, and shared reference tables through APPS synonyms:

• HZ_PARTIES — the Trading Community Architecture party master; used for person/party identification during validation and purge operations.
• IGS_PE_STUP_DATA_EMT_ALL — student person data (effective-dated, multi-org); supports person-type and student context checks.
• FND_FORM_TL and FND_NEW_MESSAGES — Oracle Forms and message dictionary tables, used by GET_USER_FORM_NAME and for message resolution.
• IGS_AD_OFRDFRMT_STAT, IGS_AD_OFR_RESP_STAT, IGS_AD_OU_STAT — admissions offer, response, and organisational unit status tables supporting application-state maintenance.
• IGS_AS_SC_ATMPT_ENR, IGS_AS_SC_ATMPT_NOTE, IGS_AS_SU_SETATMPT — assessment attempt, attempt note, and set-attempt tables, used when purging or validating applicant assessment history.
• IGS_CA_INST_REL, IGS_CA_TYPE — calendar instance relationship and calendar type, providing effective-dating and calendar context for purge routines.
• IGS_EN_CAL_CONF, IGS_EN_SPA_AWD_AIM, IGS_EN_SPA_TERMS — enrolment calendar, special award aim, and special terms tables, supporting admission-to-enrolment linkage.

Usage Notes

IGS_AD_GEN_001 is not intended as a public integration API; it is an internal support package. Its ADMP_DEL_* routines are typically invoked from concurrent programs, maintenance forms, or scheduled archival jobs that remove obsolete admissions history. Because these procedures perform destructive deletes, they should be called only within controlled housekeeping windows and with appropriate backup.

The utility routines are called more frequently. CHECK_MAND_PERSON_TYPE and SET_TOKEN are invoked from admissions forms and from the five dependent packages during application and panel processing. GET_USER_FORM_NAME is a diagnostic helper. Customisations should avoid direct calls to the delete routines unless the purge logic is fully understood, and should reference the package only through its documented procedures.