Search Results igs_ad_def_appl_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_DEF_APPL_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, belonging to the Student System (formerly Student Administration) product family and the Admissions (IGS_AD) application module. It serves as the default application processing package, encapsulating the business logic required to create, validate, and progress admission applications through the recruitment and admissions lifecycle. The package is classified as an OTHER API in ETRM documentation, meaning it is not a formally published open interface but is nonetheless a reusable server-side component invoked by Oracle's own admissions forms, workflows, and concurrent processes.

The package operates at the boundary between person/party data and the admissions application record, resolving identifiers, validating offer and deferral terms, and maintaining the status of offers and responses. Because admissions processing touches both the recruiting (prospective applicant) and admissions (formal application) areas, the package coordinates across several base tables within the IGS_AD and HZ schemas.

Key Procedures and Functions

Six documented procedures and functions comprise the public interface:

  • ADMP_VAL_OFFER_DEFER_TERM — Validates an offer or deferral term against admissions rules, ensuring the term supplied is permissible for the application being processed and consistent with institutional admissions policy.
  • CMN_HANDLE_APPLICATION — A common (shared) routine that performs the core application handling logic, centralising behaviour reused by other entry points within the package and by callers in the Admissions module.
  • HANDLE_APPLICATION — The primary application-processing entry point. It drives creation or update of an application record, applies defaulting rules, and controls the state transitions of the application.
  • VALIDATE_OFFER_VALIDATIONS — Executes the suite of offer-level validation checks, confirming that an offer may be issued or amended given the applicant, programme, and term context.
  • COPY_ENTRYCOMP_QUAL_STATUS — Copies entry competency and qualification status information, typically from one application or applicant record to another (for example, on re-application or transfer), preserving prior assessment outcomes.
  • UPDATE_OFFER_RESPONSE_ACCEPTED — Records that an applicant has accepted an offer, updating the offer response status accordingly.

Tables Accessed

The package reads from and writes to the following documented tables through APPS synonyms:

  • HZ_PARTIES — The Trading Community Architecture party record. Used to resolve and validate the person identity behind an application.
  • IGS_AD_APPL_ALL — The core admissions application table. This is the principal read/write target, holding application headers, programme choices, and application status.
  • IGS_AD_OFRDFRMT_STAT — Offer and deferment status. Maintained when offers are validated, deferred, or accepted.
  • IGS_AD_OFR_RESP_STAT — Offer response status. Updated by UPDATE_OFFER_RESPONSE_ACCEPTED to reflect applicant decisions.
  • IGS_AD_SS_APPL_TYP — Application type setup. Consulted to apply the correct defaulting and validation rules for the application type in use.

Additional dependencies documented in ETRM include IGS_AD_PS_APPL, IGS_AD_PS_APPL_INST, and IGS_PE_PERSID_GROUP, used for person identification grouping and application instance handling.

Usage Notes

The package is typically invoked from Admissions forms (such as the application and offer maintenance forms), from workflow background processes, and from custom extensions that must replicate standard admissions defaulting logic. It is not itself an open interface; customers integrating external systems should prefer the published admissions APIs. When extending, callers should invoke HANDLE_APPLICATION or CMN_HANDLE_APPLICATION rather than inserting directly into IGS_AD_APPL_ALL, so that status and offer validations remain consistent. ETRM records no other packages referencing this package, so it sits near the top of the admissions call hierarchy.