Search Results igs_ad_int_reconsider




Overview
Explore in AI Chat

Overview

IGS_AD_INT_RECONSIDER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM taxonomy as OTHER. It belongs to the Oracle Student System (formerly Oracle iRecruitment and Admissions) family of admission objects, whose naming convention uses the IGS_AD prefix. The package supports the admission reconsideration business process, whereby an applicant whose original admission decision is revisited — for example following an appeal, a change of admission category, or the roll-forward of an application into a future academic admissions calendar — has the associated application and instance records copied and re-evaluated under a new or future admissions period.

The package exposes two utility functions that clone the child records attached to an application and its instance, and a single public procedure that initialises the reconsideration workflow. Because it is classified as an OTHER API rather than a public or private API, it is intended for internal use by Oracle Student System components and by controlled extensions rather than as a general-purpose integration interface. The header comment indicates the source file IGSADD6S.pls and a last revision date of 14 October 2005, with a version of 120.0, confirming the object has been carried forward essentially unchanged into the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

  • COPY_APPLICATION_CHILD_RECORDS — A function returning BOOLEAN. It copies the child records associated with an admission application, keyed by person, the new and old admission application numbers, the nominated course code, and a sequence number. It is the application-level copy routine used when an application is reconsidered and its dependent rows must be duplicated against the new application reference.
  • COPY_INSTANCE_CHILD_RECORDS — A function returning BOOLEAN. It performs the equivalent copy at the application instance level, taking the new and old admission application numbers and sequence numbers, the person identifier, the nominated course code, and a start date. This isolates the cloning of instance-level attributes such as course nomination details from the application-level copy.
  • ADMP_INIT_RECONSIDER — A public procedure that initialises the reconsideration process. Its parameters include the current and future academic admissions calendar, the application type, a person identifier group, the application identifier, a decision date, the decision maker, and a decision reason code. It is the entry point that orchestrates the re-evaluation of an application against a future admissions calendar.

Tables Accessed

The package reads and writes a broad set of admission and trading-community tables through APPS synonyms. HZ_PARTIES supplies the person (party) identifier used as the applicant key throughout the API. IGS_AD_APPL_ALL and IGS_AD_APPL_ARP hold the application header and applicant response data, while IGS_AD_PS_APPL_INST_ALL and IGS_AD_PS_APPL_INST hold the application instance and course nomination records. Supporting application detail is drawn from IGS_AD_APLINS_ADMREQ, IGS_AD_APPL_EVAL, IGS_AD_APPL_NOTES, IGS_AD_APPL_PERSTAT, IGS_AD_APPL_PGMAPPRV, IGS_AD_APPQUAL_CODE, IGS_AD_APP_INTENT, IGS_AD_APP_REQ, and IGS_AD_EDUGOAL, which together capture admission requirements, evaluations, notes, personal statements, programme approvals, qualification codes, applicant intent, and educational goals. IGS_AD_ACAD_INTEREST records the applicant's academic interests, and IGS_AD_CODE_CLASSES supplies the decision reason code referenced by ADMP_INIT_RECONSIDER.

Usage Notes

The package is referenced by zero other packages in the documented ETRM metadata, indicating it is invoked directly rather than as part of a wider package dependency chain. Typical invocation is from the Oracle Student System admissions forms during the reconsider or re-decision action, or from a concurrent program that processes reconsideration in batch for a person identifier group against a future admissions calendar. Custom code should treat the two copy functions as internal helpers and call ADMP_INIT_RECONSIDER as the supported entry point, supplying a valid person identifier group and decision reason code. Because the object is classified as OTHER and carries a 2005 header, implementers should verify behaviour against the target release and avoid assuming forward compatibility of the BOOLEAN return values when calling from non-PL/SQL environments such as Java or concurrent program wrappers.