Search Results end_date_student

Overview

IGS_AZ_GEN_001 is a general-purpose PL/SQL package owned by the APPS schema within the Oracle E-Business Suite. The "IGS_AZ" prefix identifies it as part of the Oracle Student System (formerly Oracle Student Systems / Higher Education) Advising ("AZ") module. Within EBS 12.1.1 and 12.2.2, this package acts as the central business logic layer for managing advisor groups, assigning student-to-advisor relationships, applying and releasing advising holds, and dispatching notifications tied to those events. Its documented API classification is OTHER, indicating that it is not a public, formally versioned Open Interface but rather an internal runtime utility invoked by higher-level UI packages and concurrent programs. The ETRM metadata confirms status VALID, and the package is referenced by IGS_AZ_ADVISORS_PKG and IGS_AZ_STUDENTS_PKG, reflecting its role as a shared foundation for both the advisor and student maintenance flows. It depends on the IGS_AZ_GROUPS table and STANDARD, and is additionally referenced by itself, consistent with internal routine reuse.

Key Procedures and Functions

The documented API exposes twelve procedures/functions, whose names indicate their purpose:

• MAINTAIN_GROUPS — creates and maintains advisor group definitions held in IGS_AZ_GROUPS.
• APPLY_HOLD — places an advising-related hold on a student record.
• SEND_NOTIFICATION — generates outbound notifications (typically via Workflow/Notification) for advising events.
• ASSIGN_STUDENTS_TO_ADVISORS — establishes student-to-advisor relationships.
• IS — an internal helper/validation routine.
• END_DATE_ADVISOR — sets an effective end date on an advisor relationship.
• END_DATE_STUDENT — sets an effective end date on a student assignment.
• END_STD_ADVSNG_HOLD — terminates an active student advising hold.
• DEACTIVATE_GROUP — logically deactivates an advisor group.
• REACTIVATE_GROUP — restores an inactive advisor group to active status.
• SUBMIT_MAINTAIN_GROUP_JOB — submits the concurrent job that drives group maintenance in batch.
• WF_SET_ROLE — assigns Workflow roles for notification routing.

Tables Accessed

Per the ETRM dependency list, the package reads and writes across several functional areas. Advising-specific tables include IGS_AZ_GROUPS (group definitions), IGS_AZ_ADVISORS, IGS_AZ_STUDENTS, and IGS_AZ_ADVISING_RELS (relationship records linking students and advisors). Person and user identity data come from HZ_PARTIES, FND_USER, WF_LOCAL_USER_ROLES, and FND_NEW_MESSAGES, supporting notifications and role assignment. Encumbrance and hold processing touches IGS_PE_PERSENC_EFFCT, IGS_PE_PERS_ENCUMB, IGS_PE_PERSENC_EFFCT_SEQ_NUM_S, IGS_PE_PERSID_GROUP_ALL, IGS_FI_ENC_DFLT_EFT, and IGS_AS_ORD_ITM_INT, which underpin the APPLY_HOLD and END_STD_ADVSNG_HOLD logic. Workflow integration uses IGS_AS_WF_BEAS006_S.

Usage Notes

IGS_AZ_GEN_001 is typically invoked indirectly. The student and advisor maintenance forms call IGS_AZ_STUDENTS_PKG and IGS_AZ_ADVISORS_PKG, which in turn call this package. Batch group maintenance is driven by SUBMIT_MAINTAIN_GROUP_JOB, which launches a concurrent program that iterates groups and applies changes in bulk. APPLY_HOLD and END_STD_ADVSNG_HOLD integrate with the Student System encumbrance engine and are triggered when advising rules dictate that a hold must be raised or lifted. SEND_NOTIFICATION and WF_SET_ROLE interact with the Oracle Workflow notification framework to alert advisors or students. Because the package is internal and not a documented public API, customizations should avoid direct calls and instead extend the calling packages or the concurrent program, preserving upgrade safety across 12.1.1 and 12.2.2. The package is referenced by two dependent packages and self-references internally, so any modification carries downstream impact and should be regression-tested against advisor and student maintenance flows.