Search Results igs_ad_gen_010




Overview
Explore in AI Chat

Overview

IGS_AD_GEN_010 is a VALID PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (IGS) product family for Admissions (AD) processing. It functions as an internal generator/utility package supporting the admissions application lifecycle, specifically the recording of admission decisions, offers, and their associated status and history records. According to the ETRM metadata, the package is documented as an "OTHER" API classification rather than a published public API, indicating it is intended for internal consumption by other IGS packages rather than direct external invocation.

The package operates on admissions applicant data stored in IGS_AD_APPL_ALL and related reference tables. Its procedures suggest responsibilities around Test Admission Criteria (TAC) evaluation, unit detail resolution, and the insertion of admissions action/audit history rows. It sits within a dependency chain that includes IGS_AD_APPL_PKG, IGS_AD_GEN_002, IGS_AD_PRC_TAC_OFFER, and IGS_AD_PS_APLINSTUNT_PKG.

Key Procedures and Functions

The ETRM metadata documents eight procedures/functions. Consistent with the package's internal utility role, they fall into three functional groups:

  • ADMP_GET_TAC_API — Retrieves Test Admission Criteria (TAC) information via the appropriate API, used to determine admission decisions against configured criteria.
  • ADMP_GET_TAC_CEPRC — Retrieves TAC evaluation results, likely returning the calculated percentage or criterion outcome used in decision logic.
  • ADMP_GET_TAC_RETURN — Returns the TAC result value, supporting downstream decision and offer processing.
  • ADMP_GET_UNIT_DET — Retrieves unit (offering) detail, resolving unit-set information required to evaluate an application against admission criteria.
  • ADMP_INS_AAL — Inserts an Admissions Action Log (AAL) record, capturing an admission decision event.
  • ADMP_INS_AAL_COMMIT — Performs the AAL insert and issues a commit, providing a transactional variant for callers that require an immediate persist.
  • ADMP_INS_AA_HIST — Inserts an Admissions Application history row, retaining prior state for audit and status tracking.
  • ADMP_INS_ACAIU_HIST — Inserts a history record related to applicant instruction/unit status changes.

Parameter lists are not published in the ETRM excerpt and should be confirmed against the package specification in the target instance.

Tables Accessed

The documented tables include IGS_AD_APPL_ALL, the base admissions application table, read and written during decision and history processing. Reference and validation tables include HZ_PARTIES (party/person identity), IGS_PE_ALT_PERS_ID and IGS_PE_PERSON_ID_TYP (person identifiers), IGS_PS_ENT_PT_REF_CD (entry point reference), IGS_PS_STAT (status codes), and IGS_EN_UNIT_SET_STAT (unit-set status). Application-specific tables IGS_AD_APPL_LTR, IGS_AD_OFRDFRMT_STAT, and IGS_AD_OFR_RESP_STAT support offer letter, offer format status, and offer response status processing. Collectively these tables support applicant identification, criteria resolution, and the recording of admission offers and outcomes.

Usage Notes

IGS_AD_GEN_010 is invoked internally. The ETRM dependency report shows it is referenced by IGS_AD_APPL_PKG, IGS_AD_GEN_002, IGS_AD_PRC_TAC_OFFER, and IGS_AD_PS_APLINSTUNT_PKG, and it references IGS_AD_APPL_ALL. Its ADMP_ prefixed procedures follow the Oracle Student System generator naming convention, confirming it is a supporting module driven by the admissions offer/decision process rather than a user-facing API. It is not directly bound to a form or concurrent program; calls originate from the referencing packages during TAC evaluation, offer generation, and application status/history updates. Customizations must avoid direct dependency on this package and instead use the supported IGS_AD_APPL_PKG or TAC offer APIs.