Search Results list_section_in_cart

Overview

IGS_EN_IVR_PUB is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, belonging to the Student System (IGS) enrollment product family. Its stated purpose, per the embedded header comment, is to support the Interactive Voice Response (IVR) enrollment build delivered under Bug# 2745985, created 16-Jan-2003 by Nalin Kumar. The package exposes a set of callable public APIs that allow an external telephony or self-service front end to perform the same core enrollment operations available in the standard Student System forms: adding and removing sections from a student's cart, validating a student's career, program, term, and person details, enrolling or waitlisting a student, dropping sections, listing schedule and cart contents, and evaluating unit/step eligibility. Because the body is classified as a PUB API, its procedures and functions are intended as a supported interface rather than internal helpers, and it is referenced by one other package within the enrollment module.

Key Procedures and Functions

The package exposes fourteen documented callable units, each serving a discrete IVR enrollment task:

• ADD_TO_CART — Adds a section, identified by call number, to the student's enrollment cart. Per the source comment, it checks seat availability, returns an error status when seats are unavailable, and sets a waitlist indicator based on whether waitlisting is permitted before unit-step validation is performed.
• ENROLL_CART — Enrolls the student in the sections currently held in the cart.
• CLEAN_UP_CART — Clears cart contents, typically after a completed or abandoned IVR session.
• DROP_ALL_SECTION — Drops all enrolled sections for the student.
• DROP_SECTION_BY_CALL_NUMBER — Drops a single section identified by its call number.
• EVALUATE_PERSON_STEPS — Evaluates enrollment steps/eligibility for the person.
• LIST_SCHEDULE — Returns the student's current schedule.
• LIST_SECTION_IN_CART — Lists the sections currently in the cart.
• REMOVE_FROM_CART — Removes a specific section from the cart.
• UPDATE_ENROLL_STATS — Updates enrollment statistics. The change history records that this procedure was modified on 05-Aug-2003 under Enhancement# 3045069 (PSP Enhancement Build).
• VALIDATE_CAREER_PROGRAM — Validates the student's career and program combination.
• VALIDATE_PERSON_DETAILS — Validates person-level data prior to enrollment.
• VALIDATE_TERM — Validates the requested term for enrollment activity.
• WAITLIST — Places the student on a section waitlist.

Tables Accessed

Documented table references are made through APPS synonyms: FND_NEW_MESSAGES, used for message retrieval and API messaging; IGS_EN_METHOD_TYPE, which defines enrollment method types and supports method validation; IGS_EN_SU_ATTEMPT_ALL, the enrollment attempt/section registration entity read and written during cart and enrollment processing; and IGS_PE_PERSON_TYPES, used for person-type validation in the person and career checks.

Usage Notes

IGS_EN_IVR_PUB is normally invoked by external IVR/telephony middleware or custom self-service code rather than by standard Forms, which explains its validation-heavy, status-returning API style (return status, message count, and message data out parameters). It follows the standard EBS API conventions of API version, initialization of message list, and commit flag. The 2005 change history shows that the waitlist flag parameter on one procedure was added (Bug# 4580204, 22-Sept-2005) and then removed (26-Sept-2005), so custom callers should not rely on that transient parameter. In 12.1.1 and 12.2.2, the object resident in APPS remains callable from concurrent programs, PL/SQL wrappers, and OAF/telephony integrations.