Search Results get_apc_date

Overview

IGS_AD_GEN_003 is a public PL/SQL package in the APPS schema that forms part of the Oracle Student System (formerly Oracle iRecruitment/Student Administration) admission processing layer. It is a general-purpose utility package whose header carries the internal designation IGSAD03S.pls and ships as part of the IGS_AD product family. The package encapsulates reusable lookup and derivation logic against the admissions application tables, exposing typed function interfaces that other admission-processing packages, forms, and concurrent programs can call rather than re-implementing the underlying queries.

The package is an essentially read-only retrieval API. Callers supply an admission application key — person, application number, nominated course, and sequence — and receive derived values through OUT parameters, such as admission outcome status, course version, application opening date, and calendar/period derivations. This concentrates the reference-data dependency on a single unit, so that ETRM classifies it as an "OTHER" API rather than a business-event API. Its header has been relatively stable since 2002, with the last shipped revision recorded in July 2005.

Key Procedures and Functions

• ADMP_GET_ACAI_AOS_ID — Returns admission calendar/application-instance context for a given person, application number, nominated course, and ACAI sequence, supplying the associated date through an OUT parameter.
• ADMP_GET_ACAI_CRV — Derives the course code and course version number associated with an ACAI record, returning the course code and version through OUT parameters.
• ADMP_GET_ACAI_STATUS — Retrieves the admission outcome status and offer response status for an application instance.
• ADMP_GET_AC_BFA — Resolves a TAC admission code to its underlying admission code, basis-for-admission type, and message name, returning a BOOLEAN flag to indicate success.
• ADMP_GET_ADM_PERD_DT — Computes an admission period date. It accepts a date alias, admission calendar type and sequence, an admission category, admission process type, course and version, academic calendar, and location, returning the resolved date by reference.
• ADMP_GET_ADM_PP — Resolves admission process and period attributes for the caller.
• ADMP_GET_APCS_MNDTRY — Determines the mandatory nature of an application processing step. It is the object most commonly located by administrators searching for the admp_get_apcs_mndtry identifier, and it supports the reusable "Submitted Applications" component by deciding whether a step is compulsory for a given application.
• GET_ENTR_DOC_APC — Retrieves entrance documentation or applicant-processing information held against an applicant record.
• GET_CORE_OR_OPTIONAL_UNIT — Returns a CORE_ONLY, Y, or N indicator classifying a unit as core, core-optional, or non-core. It was created for the pre-enrolment process to flag unit enrolment status.
• GET_APC_DATE — Returns an associated application/period date; added in 2005 for the Submitted Applications Reusable Component.

Tables Accessed

The package reads through APPS synonyms over the IGS_AD and shared IGS_CA schemas. IGS_AD_APPL_ALL and IGS_AD_PS_APPL_INST_ALL supply admission application and application-instance rows. IGS_AD_BASIS_FOR_AD resolves basis-for-admission data, while IGS_AD_CD, IGS_AD_OFR_RESP_STAT, and IGS_AD_CAL_CONF provide admission codes, offer response statuses, and calendar configuration. Period and category logic draws on IGS_AD_PERD_AD_CAT, IGS_AD_PECRS_OFOP_DT, and IGS_AD_PRCS_CAT_STEP_ALL, the last underpinning the mandatory-step determination. IGS_CA_DA_INST supplies academic calendar instance data used by the date-derivation functions.

Usage Notes

IGS_AD_GEN_003 is not invoked directly by end users; it is a server-side utility called from admission forms, the pre-enrolment and Submitted Applications processing flows, and custom extension code that needs the same admissions lookups. The package is referenced by twelve other packages, so care is required when extending or recompiling it, since signature changes propagate across those callers. Functions return status strings or BOOLEANs and communicate results primarily through NOCOPY OUT parameters, so callers must supply correctly typed host variables and check the returned status before consuming the OUT values.