Results for “get_title_section”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_SS_ENR_DETAILS is a PL/SQL package in the APPS schema that forms part of the Oracle Student System (formerly Oracle iLearning/Student System) enrollment subsystem within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to assemble and return the detailed descriptive attributes of a student's enrollment records — that is, the "presentation layer" information associated with a unit offering option or a unit attempt. Rather than performing enrollment transactions itself (which is the role of packages such as IGS_EN_ADD_UNITS_API and IGS_EN_DROP_UNITS_API), IGS_SS_ENR_DETAILS resolves the descriptive, descriptive-reference, and scheduling detail required to render enrollment information on self-service and administrative pages.

The package carries an API classification of OTHER in the ETRM repository and is documented as VALID, exposing approximately 80 procedures and functions. Its dependency footprint shows it is heavily consumed by other enrollment components, including wrapper packages, dashboard logic, eligibility engines, IVR publication, and self-service views, indicating that it is a shared utility package rather than a top-level transactional API.

Key Procedures and Functions

The documented procedures and functions fall into several functional groupings:

• Location and scheduling resolution: GET_LOCATION_BLDG_ROOM retrieves building and room descriptions for an offering occurrence; GET_INSTRUCTOR_DAY_TIME returns instructor and meeting-day/time detail; GET_OCCUR_DETAILS_NO_LOCATION, GET_OCCUR_DESC_DETAILS, and GET_OCCUR_CD_DETAILS return occurrence descriptions and codes without location context.
• Reference and code lookups: GET_USEC_REF_CD and GET_USEC_OCCURS_REF_CD resolve reference codes for unit section occurrences, typically sourced from IGS_LOOKUPS_VIEW.
• Descriptive text retrieval: GET_TITLE_SECTION, GET_TITLE, GET_SUBTITLE, GET_UNIT_NOTE, and GET_USEC_NOTE return the title, subtitle, section title, unit notes, and unit-section notes associated with an enrollment.
• Grading and credit: GET_GRADING_SCHEMA, GET_GRADING_SCHEMA_VER, GET_GRADING_SCHEMA_DESC, GET_GRADING_CD_VER, GET_CREDIT_POINTS, and GET_ALLOWABLE_CP_RANGE return grading schema identifiers, versions, descriptions, grade code versions, credit point values, and the allowable credit point range for a unit attempt.
• Program and eligibility context: GET_PROGRAMS and ENRP_GET_PRGM_FOR_CAREER resolve the program(s) associated with a student's career and enrollment, supporting eligibility and planning logic.

Tables Accessed

The package reads from a set of enrollment, academic, and descriptive tables through APPS synonyms. Documented tables include:

• Unit offering and grouping: IGS_PS_UNIT_OFR_OPT_ALL and IGS_PS_USEC_X_GRP provide unit offering option and unit section occurrence grouping data.
• Grading and attempt data: IGS_AS_GRD_SCHEMA, IGS_AS_SU_SETATMPT, IGS_CA_INST_ALL, IGS_CA_INST_REL, and IGS_CA_TYPE supply grading schema definitions and student unit attempt/institution records.
• Enrollment configuration: IGS_EN_CAL_CONF, IGS_EN_CAT_PRC_DTL, and IGS_EN_CPD_EXT_ALL provide calendar configuration, category pricing detail, and extended enrollment configuration used for detail resolution.
• Location data: IGS_AD_BUILDING_ALL and IGS_AD_ROOM_ALL provide building and room names for occurrence location display.
• Reference and messaging: FND_NEW_MESSAGES and HZ_PARTIES are referenced for messaging and party context. IGS_CA_DA_INST provides date-instance information.

Usage Notes

IGS_SS_ENR_DETAILS is not intended to be invoked directly by end users. It is a back-end utility package invoked by enrollment APIs, self-service views, and concurrent programs. The dependency report shows it is referenced by IGS_EN_ADD_UNITS_API, IGS_EN_DROP_UNITS_API, IGS_EN_DASHBOARD, IGS_EN_ELGBL_PERSON, IGS_EN_ELGBL_PROGRAM, IGS_EN_ELGBL_UNIT, IGS_EN_ENROLL_WLST, IGS_EN_IVR_PUB, IGS_EN_PLAN_UTILS, IGS_EN_PRC_LOAD, IGS_EN_VAL_SUA, IGS_PT_GEN_PKG, IGS_SS_EN_WRAPPERS, IGS_SS_ENR_DETAILS itself, and self-service views such as IGS_SS_EN_SUA_DTLS_V, IGS_SS_EN_USEC_EXAM_SCH_V, IGS_SS_USEC_V, and IGS_DA_XML_COURSE_V. Custom extensions that need to display enrollment detail should call the public procedures rather than querying the underlying tables directly, since the package encapsulates the derivation rules for titles, locations, grading, and credit values. When debugging enrollment display issues, invalid objects in this package will cascade to all of the referencing packages and views listed above, so it should be validated first in any dependency-chain investigation.