Search Results validate_date

Overview

The APPS.IGS_PE_CITIZENSHIP_PKG package body belongs to the Oracle E-Business Suite Student Systems / People Enterprise (IGS PE) module, which manages person-level data for higher education institutions. Its principal business function is to enforce data integrity rules around citizenship records held against a party (person or organization) in the HZ_CITIZENSHIP table. The package encapsulates the validation logic that prevents inconsistent citizenship information from being committed — for example, ensuring that a citizenship end date is not earlier than its start date, that a citizenship recognition date does not precede the person's birth date, and that overlapping citizenship periods for the same country do not occur for a given party.

Because citizenship data feeds downstream processes such as fee assessment, residency classification, and regulatory reporting, the validation routines in this package protect the quality of that data at the point of entry.

Key Procedures and Functions

The documented package exposes one public procedure, CITIZENSHIP, which serves as the primary entry point for citizenship record processing. The package body also contains an internal validation routine, VALIDATE_DATE, which is the object most closely associated with the user search term "validate_date."

• VALIDATE_DATE — An internal procedure that performs the core date and overlap checks. It reads the person's birth date from IGS_PE_PERSON_BASE_V, compares it against the proposed citizenship start date, verifies that the start date is not later than the end date, and uses a cursor against HZ_CITIZENSHIP to detect periods that overlap existing citizenship rows for the same party, country, and citizenship identifier. On failure it uses FND_MESSAGE and IGS_GE_MSG_STACK to raise a user-facing error via APP_EXCEPTION.RAISE_EXCEPTION.
• CITIZENSHIP — The documented public procedure that orchestrates citizenship processing and invokes the validation logic before committing changes.

Two error messages are referenced in the body: IGS_FI_ST_DT_LE_END_DT (start date must be less than or equal to end date) and IGS_PE_DREC_GT_BTDT (date recognized must be greater than birth date).

Tables Accessed

• HZ_CITIZENSHIP — The primary transactional table holding citizenship rows for a party. The package reads it to detect overlapping citizenship periods and, through the public procedure, writes or validates records against it.
• IGS_PE_PERSON_BASE_V — A view over the person base entity, queried to retrieve the stored birth_date for the party so that citizenship dates can be validated against it.

Usage Notes

The package is typically invoked from the Oracle Forms-based citizenship maintenance screens in the Student Systems People module, and from any custom code or concurrent process that inserts or updates citizenship records for a party. In Oracle EBS 12.1.1 and 12.2.2 the object resides under the APPS schema and is referenced by two other packages, indicating it is a shared dependency within the IGS PE stack.

The internal default end date of 4712/12/31 is used as an effective "open-ended" sentinel when validating overlap, so records without an explicit end date are correctly treated as ongoing. Because validation failures are raised through the FND message stack and APP_EXCEPTION, callers must be prepared to handle the raised exception and present the associated message to the user. The header comment ($Header: IGSNI74B.pls 120.1 2005/09/21) indicates the file has been stable since 2005, with no listed change history, so behavior should be consistent across 12.1.1 and 12.2.2.