Search Results igs_ad_gen_004




Overview
Explore in AI Chat

Overview

IGS_AD_GEN_004 is a PL/SQL package owned by APPS within the Oracle E-Business Suite Student Systems (Admissions) product family. It is a server-side utility package declared with AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the invoking schema rather than the definer, and it is registered as an API-related object (classification OTHER). The package is derived from the source file IGSAD04S.pls, with the header revision indicating a ship version dated 28-NOV-2002 (115.5). Its principal purpose is to return admission-related descriptive and configuration values—admission category processing settings, archive indicators, course detail, communication periods, CRICOS codes, and course-version component detail—to higher-level Admissions forms and business logic.

Key Procedures and Functions

The package exposes eight documented procedures, several of which are explicitly referenced in the source change history:

  • ADMP_GET_APCS_VAL — Retrieves the Admission Process Category Setup (APCS) values for a given admission category and admission process type, returning a large set of indicator flags (for example preference limit, application fee, late application, late fee, encumbrance checks, fee assessment, category indicators, unit restrictions, and outcome settings) as OUT parameters.
  • ADMP_GET_ARCHIVE_IND — Returns the archive indicator controlling whether admission data is treated as archived.
  • ADMP_GET_CHG_PREF_DT — Returns the change-of-preference date associated with an admission record.
  • ADMP_GET_COMM_PERD — Returns communication period information used when generating admissions correspondence.
  • ADMP_GET_COURSE_DET — Returns course detail for the supplied admission context.
  • ADMP_GET_CRICOS_CD — Returns the CRICOS code (Australian government course registration identifier) for a course.
  • ADMP_GET_CRS_EXISTS — Determines whether a course exists; the change history records the addition of a parameter P_error_message_research in April 2002 for bug 2285677.
  • ADMP_GET_CRV_COMP_DT — Returns course-version component detail; updated in October 2002 (bug 2647482) to add the p_attendance_mode and p_location_cd parameters.

Tables Accessed

The package reads from the following tables via APPS synonyms:

  • IGS_AD_CAL_CONF — Admissions calendar configuration, used in computing application and communication periods.
  • IGS_PE_HZ_PARTIES — Person/party information, providing the party context for admission records.
  • IGS_PS_OFR_OPT_ALL — Program offering option detail, used to resolve course/offering attributes.
  • IGS_PS_REF_CD — Reference code lookup values for code validation and description retrieval.

These accesses are typical of lookup-style calls that populate a localized admission context before display on an Admissions form.

Usage Notes

IGS_AD_GEN_004 is a shared internal utility invoked by admissions forms, concurrent programs, and custom extensions. The ETRM metadata records that it is referenced by twelve other packages, confirming its role as a dependent lookup library rather than a top-level entry point. Because it is declared AUTHID CURRENT_USER, callers must grant direct access to the underlying IGS tables or call through an APPS-privileged session. Common usage includes populating admission category flag defaults on entry screens, validating course existence prior to saving an application, and resolving CRICOS and communication-period values during correspondence generation. Custom code should invoke the documented procedures by name and treat all OUT parameters as read-only results; direct modification of the underlying IGS tables is not intended through this package.