Search Results igs_ad_val_acai_ftr_offer




Overview
Explore in AI Chat

Overview

IGS_AD_VAL_ACAI_FTR_OFFER is an Oracle EBS Student System (IGS) admissions validation package owned by APPS. Its documented purpose is to create a future term application, a common admissions business process in which an applicant who has applied for one academic period wishes to be considered against a subsequent (future) academic calendar and admission calendar. The package header dates to February 2002, with a change in September 2002 that added a p_process parameter to the internal child-record copy routine in support of a deferment enhancement (patch 2563941). It carries an API classification of OTHER, meaning it is not published as a fully supported public API but is instead an internal procedural library invoked by other admissions components.

Key Procedures and Functions

The package body exposes five documented program units.

  • admp_val_offer_future_term — The principal concurrent-program entry point. It accepts a person, person-identifier group, nominated course code, previous and future academic admission calendars, offer date, offer response date, and optional application type and application ID, together with the standard concurrent errbuf/retcode pair. It drives validation and creation of the future-term offer.
  • handle_application — The function that resolves an application. Given the person, admission application number, nominated course, application-instance sequence, and the future academic/admission calendar type and sequence, it returns a new admission application number and a new sequence number through OUT NOCOPY parameters and returns a BOOLEAN status. In practice this is the routine that identifies or builds the target application record for the future term. This is the object the user query referenced.
  • copy_child_records — Copies dependent child rows (application and application-instance children) from the source application to the newly resolved application, returning the new application number and sequence number.
  • validate_offer_validations — Performs the business-rule checks applied before an offer for the future term is accepted as valid.
  • copy_entrycomp_qual_status — Propagates entry-competency and qualification status data linked to the originating application onto the new future-term application.

Tables Accessed

The package reads and writes the HZ_PARTIES party record that anchors the applicant, and the core admissions tables IGS_AD_APPL_ALL and IGS_AD_APPL (designated by the _ALL suffix as multi-org/language-enabled views) for the application header. Application-instance detail and child records are taken from IGS_AD_APLINS_ADMREQ, IGS_AD_APPL_ARP, IGS_AD_APPL_EVAL, IGS_AD_APPL_NOTES, IGS_AD_APPL_PERSTAT, IGS_AD_APPL_PGMAPPRV, and IGS_AD_APPQUAL_CODE. Supporting reference and preference data include IGS_AD_APP_INTENT, IGS_AD_APP_REQ, IGS_AD_ACAD_INTEREST, IGS_AD_CODE_CLASSES, IGS_AD_EDUGOAL, and IGS_AD_OTHER_INST. These are accessed through APPS synonyms, so the underlying objects resolve to the IGS and HZ schemas under standard EBS data model conventions.

Usage Notes

The package is invoked from admissions forms and concurrent processing rather than being called directly by end users. The admp_val_offer_future_term signature with errbuf and retcode confirms registration as a concurrent program, typically submitted to defer or re-offer an applicant to a later admission period. handle_application may also be called from custom code that needs to resolve or create the future-term application, but because the API classification is OTHER, the interface is not guaranteed stable across patches and should be wrapped defensively. ETRM records one package referencing this unit. When troubleshooting, note the copy routines are sensitive to the presence of complete child records on the source application; a failure in handle_application usually indicates the future academic or admission calendar instance is not defined for the nominated course.