Search Results igs_pe_persenc_effct_seq_num_s

Overview

The package body APPS.IGS_AZ_GEN_001 belongs to the Oracle E-Business Suite Student System (formerly Oracle Student System, now part of Oracle Higher Education) and supports the advising and student-group management functions delivered within the IGS (Institution of Graduate Studies / Student System) product family. Its prefix, IGS_AZ, identifies it as a member of the "AZ" functional module, which in the ETRM classification covers advising, advisor assignment, and student group maintenance. The package is classified as an "OTHER" API, meaning it is a general-purpose server-side utility rather than a formally published public API with a guaranteed interface. It is owned by the APPS schema and is marked VALID, indicating successful compilation against the 12.1.1 and 12.2.2 database schemas.

Functionally, the package orchestrates the lifecycle of student advising groups and the relationships between students, advisors, and the holds that may be placed upon those relationships. It also interacts with Oracle Workflow to drive notifications and role resolution, reflecting the integration of advising activities with the EBS workflow engine.

Key Procedures and Functions

ETRM documents twelve procedures and functions within this package. MAINTAIN_GROUPS is the central driver for creating, updating, or otherwise maintaining advising groups. APPLY_HOLD places an advising-related hold on a student or advisor record. SEND_NOTIFICATION generates and dispatches messages through the workflow mailer and FND_MESSAGE/FND_MSG_PUB infrastructure. ASSIGN_STUDENTS_TO_ADVISORS establishes the advising relationships recorded in IGS_AZ_ADVISING_RELS. IS is a boolean-style helper, and END_DATE_ADVISOR and END_DATE_STUDENT apply effective end dates to advisor and student advising assignments respectively. END_STD_ADVSNG_HOLD terminates an existing student advising hold. DEACTIVATE_GROUP and REACTIVATE_GROUP toggle the status of an advising group. SUBMIT_MAINTAIN_GROUP_JOB submits the group maintenance logic as a concurrent program request via FND_REQUEST. WF_SET_ROLE resolves and sets the workflow role, interacting with WF_LOCAL_USER_ROLES and WF_DIRECTORY. No parameter lists are documented, so signatures are not reproduced here.

Tables Accessed

The package reads and writes the advising tables IGS_AZ_GROUPS, IGS_AZ_ADVISORS, IGS_AZ_STUDENTS, and IGS_AZ_ADVISING_RELS, which hold the group, advisor, student, and relationship definitions. It consults IGS_PE_PERSON, IGS_PE_PERSID_GROUP_ALL, IGS_PE_DYNAMIC_PERSID_GROUP, IGS_PE_PERSENC_EFFCT, IGS_PE_PERSENC_EFFCT_SEQ_NUM_S, and IGS_PE_PERS_ENCUMB to resolve person identifiers, group membership, and encumbrance status — the sequence view IGS_PE_PERSENC_EFFCT_SEQ_NUM_S supplies the effective sequence number for person encumbrance records. IGS_FI_ENC_DFLT_EFT provides default encumbrance/effectivity settings. FND_USER, HZ_PARTIES, FND_NEW_MESSAGES, and WF_LOCAL_USER_ROLES supply user, party, messaging, and workflow role data. IGS_AS_ORD_ITM_INT, IGS_AS_WF_BEAS006_S, and IGS_GE_GEN_003 support ordering and general process integration.

Usage Notes

The package is typically invoked from the Advising forms, from the concurrent manager via SUBMIT_MAINTAIN_GROUP_JOB, and from Oracle Workflow business events through the IGS_AS_WF_BEAS006_S subscription. It is referenced by two other database objects, indicating reuse by dependent packages. Customizations should avoid direct calls, since IGS_AZ_GEN_001 is not a published API; institutions extending advising behavior should layer their logic on the supported IGS_AZ_*_PKG wrappers instead.