Results for “seq_num_type”

4 results




Overview
Explore in AI Chat

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

Overview

APPS.IGS_EN_DASHBOARD is a PL/SQL package belonging to the Oracle Student System (formerly Oracle Student Systems / OSS) module of Oracle E-Business Suite, delivered under the APPS schema. Its purpose is to support the Enrollment Dashboard, a self-service style informational page that presents a student with consolidated enrollment-related data such as registration links, calendar context, program and curriculum references, and scheduling eligibility. In Oracle EBS 12.1.1 and 12.2.2 the package retains the API classification "OTHER," indicating that it is an internal, product-owned utility rather than a published integration API intended for customer extension.

The package header carries the header identifier IGSENB2S.pls 120.1, dated 18-Nov-2005, authored by Somasekar.N of Oracle Student Systems, Oracle IDC. The change history records a single documented revision by developer jnalam that introduced a new function, Schedule_Units_Exists, to address Bug# 4742735. The package exposes a small, tightly scoped interface consisting of one procedure and one function, both oriented toward reading enrollment data rather than performing transactional writes.

Key Procedures and Functions

Two program units are documented in the package specification:

  • STUDENT_API — The principal procedure of the package. It accepts a person identifier and person type as inputs and returns several collections through OUT NOCOPY parameters. These outputs supply the dashboard with display-oriented data: link text entries, calendar type references, sequence numbers, program/curriculum codes, and plan or schedule indicator values, together with a scheduling-allowed flag. The procedure therefore assembles the data set that the enrollment dashboard page renders for a given student.
  • SCHEDULE_UNITS_EXISTS — A Boolean function that determines whether schedule units exist for a specified person, program, calendar type, and sequence number. It was added under Bug# 4742735 and is used to conditionally control scheduling-related behavior on the dashboard, for example enabling or suppressing scheduling actions when no units are present.

The specification also declares several PL/SQL collection types — LINK_TEXT_TYPE, CAL_TYPE, SEQ_NUM_TYPE, PRG_CAR_TYPE, and PLAN_SCHED_TYPE — all indexed by BINARY_INTEGER, which serve as the return signatures for the table-valued outputs of STUDENT_API.

Tables Accessed

Through APPS synonyms the package reads from ten documented Student System tables, spanning calendar, planning, and student records:

  • IGS_CA_TYPE, IGS_CA_INST_ALL, IGS_CA_INST_REL, and IGS_CA_STAT — calendar type, calendar instance, instance relationship, and instance status data used to resolve the teaching calendar context displayed to the student.
  • IGS_EN_CAL_CONF — enrollment calendar configuration, used to determine which calendars are valid for enrollment dashboard display.
  • IGS_EN_PLAN_UNITS and IGS_EN_SPA_TERMS — enrollment plan units and sponsored/term planning data, supporting the Schedule_Units_Exists check and planning information.
  • IGS_EN_STDNT_PS_ATT_ALL — student program-of-study attempt records, the primary source of an individual's enrollment status and program association.
  • IGS_PS_USEC_REF and IGS_PS_VER_ALL — program version and use-of-code reference data, providing the program and curriculum descriptors returned by STUDENT_API.

All access is read-oriented; no documented inserts, updates, or deletes are attributed to this package.

Usage Notes

IGS_EN_DASHBOARD is an internal supporting package invoked by Student System self-service dashboard pages and related enrollment UI components rather than by direct customer callout. It is referenced by one other package in the ETRM inventory, confirming its role as a subordinate data-provider rather than a top-level API. Typical invocation occurs through the enrollment dashboard region logic, where the calling layer first executes STUDENT_API to populate the link, calendar, sequence, program, and schedule indicator collections, then optionally calls SCHEDULE_UNITS_EXISTS to decide whether scheduling functionality should be presented. Because the package is classified as OTHER and is not a supported public API, customizations should avoid direct dependency; any extension work should instead use documented Student System public APIs. Its 2005 vintage and 120.1 version indicate it has remained stable across the 12.1.1 and 12.2.2 releases with no material interface change.