Search Results no_set_day_ind




Overview
Explore in AI Chat

Overview

IGS_PS_UNIT_LGCY_PUB is a public PL/SQL API in the Oracle E-Business Suite Student System (OSS) product family. As indicated by its name, the package exposes legacy import functionality for student unit (enrollment) data originating in external systems. Its stated purpose, per the header comment, is to declare a public API that imports data from an external system into OSS, together with the PL/SQL record and table types required to pass that data into the API. Because it is classified as a PUB (public) interface and owned by APPS, it is intended for consumption by external feeders, staging programs, and custom integration code rather than by internal private routines.

The package is especially relevant to institutions using the "No Set Day" (USO) scheduling model, in which unit offerings are not tied to a fixed set day. The search term no_set_day_ind maps directly to the no_set_day_ind attribute defined in this package's record structures. This flag was introduced under Bug #3793580 (28-Jul-2004) to permit the import of instructors for No Set Day USO, and was also added to the unit offering (uso) record structure as part of the PSP Scheduling Enhancements technical design.

Key Procedures and Functions

The ETRM metadata for this object does not enumerate individually documented procedures or functions; the published excerpt consists primarily of the package specification header and its change history. Consequently, no parameter lists are asserted here. What the header does document is the API's contract: it declares a public entry point for importing external data into OSS alongside the associated PL/SQL table types (including uso_ins_tbl_type) and their companion record types (uso_ins_rec_type, usec_rec_type, unit_ver_rec_type, unit_ref_rec_type, and uso_rec_type). The import routine accepts an in/out table parameter, such as p_uso_ins_tbl, through which callers supply collections of unit, section, instructor, version, and reference records. From the change history, the functional remit of the API's procedures can be characterized as: importing unit and unit section records, importing instructor assignments (including the No Set Day case governed by no_set_day_ind), handling unit versions and credit point values, and processing unit references, including the generation reference flag.

Tables Accessed

The documented metadata does not list specific base tables for this package. The record and table types it declares correspond to the OSS tables underlying the public synonyms it operates against, principally the unit offering and unit section tables (the IGS_PS_UNIT_* and IGS_PS_USEC_* families) and the unit instructor assignment table. The import logic populates or updates attributes such as unit version number, teaching calendar and location codes, enrolled and achievable credit points, billing credit points, workload values and override flags, preferred region code, multiple-section flag, and the no_set_day_ind indicator, which is why those columns and flags appear in the record type definitions.

Usage Notes

This package is typically invoked from custom integration or conversion code that stages legacy enrollment data and then calls the public API to persist it into OSS. It is not an end-user form; rather it is called by staging concurrent programs or bespoke PL/SQL that first populates the declared table types and then passes them to the import procedure. Callers must use the exact record structures shipped in the specification, because attributes were added incrementally over releases (for example, no_set_day_ind, ovrd_wkld_val_flag, workload_val_code, gen_ref_flag, and the surrounding unit section columns), and code that constructs records positionally must reflect the current version. The superseded sup_unit_allowed_ind and sub_unit_allowed_ind columns were removed in Enh#3052452 and must not be referenced. Compatibility applies across Oracle EBS 12.1.1 and 12.2.2.