Search Results inqp_get_appl_ind

Overview

IGS_IN_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an OTHER API within the ETRM documentation set for release 12.1.1 and 12.2.2. The package belongs to the Oracle Student System product family (the IGS_ prefix) and supports the Student Information / Enrollment and Registration functional area. Its central role is to serve as an inquiry engine for student attempt, enrolment, and progression data, exposing read-oriented functions used by inquiry views and concurrent processes that need consolidated student academic status information. The "GEN" designation indicates a general-purpose utility package rather than a single-module API, and the 001 suffix reflects its position within a versioned series.

Key Procedures and Functions

The package exposes eight documented functions, all prefixed INQP, indicating an "inquiry" purpose. They are read-only accessors that return individual data elements for a given student attempt or enrolment context.

• INQP_GET_APPL_IND — Returns an application indicator associated with a student record, used to determine whether an application exists or is active for the student in context.
• INQP_GET_ENCMB — Returns encumbrance information, indicating whether a student record is subject to an encumbrance that may restrict enrolment or progression.
• INQP_GET_ENR_CAT — Retrieves the enrolment category applicable to the student's enrolment, distinguishing between award, non-award, and other enrolment classifications.
• INQP_GET_PRG_CP — Returns progression or program completion status, supporting determination of whether a student has completed a program or progressed to a subsequent stage.
• INQP_GET_SCA_STATUS — Returns the status of a student course attempt, reflecting the outcome or current standing of the attempt.
• INQP_GET_SCHO — Retrieves school or organisational unit information associated with the attempt or enrolment.
• INQP_GET_SCI — Returns the student course instance reference, identifying the specific delivery occurrence against which the attempt is recorded.
• INQP_GET_SUA_ACHVD — Returns the achieved outcome of a student unit attempt, such as a mark, grade, or completion indicator.

Tables Accessed

The documented table references reveal the package's data domain across three areas. Enrolment and attempt data is drawn from IGS_AS_SC_ATMPT_ENR, IGS_AS_GRD_SCH_GRADE, IGS_EN_ENROLMENT_CAT, IGS_EN_INTM_TYPES, IGS_EN_STDNTPSHECSOP, and IGS_EN_STDNT_PS_INTM. Person and institutional restriction data is sourced from IGS_PE_PERSENC_EFFCT, IGS_PE_PERS_ENCUMB, IGS_PE_COURSE_EXCL, IGS_PE_CRS_GRP_EXCL, IGS_PE_PERS_UNT_EXCL, IGS_PE_UNT_REQUIRMNT, and IGS_PE_UNT_SET_EXCL, which collectively underpin the encumbrance and exclusion logic. Application status and program structure data come from IGS_AD_APPL_STAT and IGS_PS_GRP_MBR. All access is via APPS synonyms, and the ETRM dependency record confirms the package references IGS_EN_SU_ATTEMPT directly.

Usage Notes

IGS_IN_GEN_001 functions are consumed internally rather than invoked directly by end users. The ETRM metadata records that the package is referenced by three other packages, including IGF_AP_OSS_INTR_DTLS, and by the inquiry views IGS_AS_SUA_INQ_V and IGS_PR_SUA_INQ_V. These views materialise student unit attempt information for enquiry screens and reports, and the INQP functions supply the derived attributes displayed to users. The package itself depends on the STANDARD SYS package. Because the functions are inquiry-oriented and read-only, they are safe to call from custom code, concurrent programs, or form logic where the objective is to display or evaluate student enrolment standing without performing DML. Developers extending student self-service pages or building reporting extracts should treat this package as the supported access point for the derived attempt and encumbrance attributes it exposes.