Search Results create_usec_sp_fee




Overview
Explore in AI Chat

Overview

IGS_PS_CREATE_GENERIC_PKG is a PL/SQL package in the APPS schema belonging to the Oracle Student System (formerly Oracle iLearning/Student Systems) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its name prefix "IGS_PS" identifies it as part of the Program Structure (PS) module, which manages academic programs, program versions, unit offerings, and enrollment configurations. The "_CREATE_GENERIC" suffix indicates the package is responsible for the creation and population of generic program-structure entities — that is, the reusable, non-legacy configuration records that define how units, offerings, facilities, assessment items, teaching responsibilities, and enrollment rules are established for a program version.

The package forms part of a layered architecture in which a public API (IGS_PS_GENERIC_PUB) and a private implementation package (IGS_PS_GENERIC_PVT) coordinate validation and creation logic. IGS_PS_CREATE_GENERIC_PKG sits at the creation layer: it is invoked by the validation packages and by the legacy handler IGS_PS_UNIT_LGCY_PKG to insert generic program-structure rows after validation has succeeded. Its specific role is to translate validated, in-memory program-structure definitions into persisted table rows, and to do so consistently across the many child entity types that a program version can carry.

Key Procedures and Functions

The package exposes nineteen documented procedures, each responsible for creating one category of generic program-structure record. They fall into several functional groupings:

Each procedure is named to reflect the entity it creates; parameter lists are intentionally not reproduced here, as the documented metadata does not expose them. The consistent "CREATE_USEC_" (unit section) and "CREATE_USO_" (unit offering) prefixes confirm that the procedures operate at two distinct levels of the program-structure hierarchy.

Tables Accessed

The package reads and writes a defined set of base tables through APPS synonyms. Core program-structure tables include IGS_PS_UNIT_OFR_OPT_ALL (unit offering options), IGS_PS_USEC_X_GRP (unit section cross-groups), and IGS_PS_USO_CM_GRP (unit offering communication groups). Supporting academic reference data is drawn from IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_STAT, and IGS_CA_TYPE (calendar instance, status, and type definitions), and from IGS_AS_US_AI_GROUP and IGS_AS_US_AI_GROUP_S (assessment item group headers and specifications). Administrative and location data is sourced from IGS_AD_BUILDING_ALL, IGS_AD_LOCATION_ALL, and IGS_AD_ROOM_ALL for facility and room configuration. Enrollment and party data is resolved through IGS_EN_NSD_DLSTP_ALL and HZ_PARTIES, while FND_NEW_MESSAGES is used to surface error and warning messages to the calling form or concurrent process.

Usage Notes

IGS_PS_CREATE_GENERIC_PKG is not intended to be called directly by end users. It is typically invoked behind the Program Structure forms during program version maintenance, or by concurrent programs that bulk-generate unit offerings and sections. The dependency listing confirms it is referenced by IGS_PS_GENERIC_PVT and IGS_PS_CREATE_GENERIC_PKG itself, and by the legacy validation and unit handlers IGS_PS_VALIDATE_GENERIC_PKG, IGS_PS_VALIDATE_LGCY_PKG, and IGS_PS_UNIT_LGCY_PKG. This reference pattern is significant for users searching "igs_ps_validate_lgcy_pkg": that legacy validation package is one of the documented consumers of IGS_PS_CREATE_GENERIC_PKG, meaning creation of generic records is triggered as a post-validation step from the legacy validation path. In both 12.1.1 and 12.2.2 the package is VALID and remains the standard mechanism for persisting generic program-structure entities, so any custom extension should call the same procedures rather than inserting into the underlying tables directly.