Search Results admp_get_crv_comp_dt

Overview

IGS_AD_GEN_004 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Student System (formerly Oracle iLearning/Student Administration) module. The package is classified as OTHER under the ETRM API classification scheme, indicating it is an internal utility package rather than a formally published public API. Its principal business role is to serve as a central retrieval and evaluation utility for admissions processing configuration — the admission category, admission process type, and associated control indicators that govern how an application is validated, assessed, fee-assessed, and progressed through the admissions lifecycle.

The source header identifies the current shipped version as IGSAD04B.pls 115.21, dated 2003/12/05, evidencing the package's long-standing presence in the Student System code line. The user search term igs_ad_appl_inst reflects the application instance context in which this package executes; the package is consumed indirectly by the admissions application instance flows rather than being called directly by end users.

Key Procedures and Functions

The documented interface exposes eight procedures and functions, all prefixed with the ADMP_ namespace reserved for admissions configuration retrieval:

• ADMP_GET_APCS_VAL — The central procedure of the package. It returns the complete set of admission process control setting (APCS) indicators for a given admission category and admission process type, including flags governing preference limits, application fees, late applications and late fees, fee assessment, enrolment and course category handling, unit restrictions, document and fee conditions, deferral, acknowledgement, and pre-enrolment behaviour.
• ADMP_GET_ARCHIVE_IND — Retrieves the archive indicator that determines whether admissions records for the supplied context are eligible for archiving.
• ADMP_GET_CHG_PREF_DT — Returns the change-of-preference date, used to control the window in which an applicant may amend course preferences.
• ADMP_GET_COMM_PERD — Returns the communication period associated with the admissions configuration, supporting correspondence scheduling.
• ADMP_GET_COURSE_DET — Retrieves course-level detail required during admission processing.
• ADMP_GET_CRICOS_CD — Returns the CRICOS code for a course offering. The header commentary records enhancement 2858431 (06-May-2003), which replaced the system reference code for CRICOS with OTHER.
• ADMP_GET_CRS_EXISTS — Validates whether a referenced course exists, providing a boolean-style existence check for downstream validation logic.
• ADMP_GET_CRV_COMP_DT — Returns the course version completion date, used to establish version validity and completion context.

Tables Accessed

The package operates on four documented tables through APPS synonyms:

• IGS_AD_CAL_CONF — Admission calendar configuration; supplies the calendar-level parameters underpinning date and period logic.
• IGS_PE_HZ_PARTIES — The party (person/organisation) table integrated with TCA; used to resolve applicant party records.
• IGS_PS_OFR_OPT_ALL — Programme offering option data; the source of course, unit, and offering attributes returned by course detail and CRICOS lookups.
• IGS_PS_REF_CD — Reference code table; resolves system reference codes such as the CRICOS code classification.

Usage Notes

IGS_AD_GEN_004 is an internal plumbing package. It is referenced by twelve other packages, which collectively front the admissions forms and concurrent programs. It is typically invoked from admissions setup and application maintenance forms to populate admission process control indicators, to validate course existence and version completion, and to supply CRICOS and communication data during application processing. Because the procedures return scalar control flags rather than performing DML, they are safe to call from validation triggers, view queries, and custom extensions that need the same configuration logic used by the seeded admissions flows. Customisations should call the package rather than querying IGS_AD_CAL_CONF and IGS_PS_OFR_OPT_ALL directly, to preserve consistency with standard admissions processing. In EBS 12.1.1 and 12.2.2 the package remains an APPS-owned, non-public utility; signatures should be treated as stable but unsupported for direct external use.