Search Results igs_en_nstd_usec_dl_s

Overview

The package body APPS.IGS_EN_NSTD_USEC_DL_PKG is a server-side PL/SQL component within the Oracle E-Business Suite (EBS) Student Systems / Higher Education (IGS) product family. It operates against the non-standard use of enrollment records, specifically the entity preserved in the IGS_EN_NSTD_USEC_DL table and its associated IGS_EN_NSTD_USEC_DL_S sequence. In Oracle EBS 12.1.1 and 12.2.2 the IGS schema provides enrollment management functions for institutions, and non-standard use records capture exceptional enrollment circumstances that fall outside the standard enrollment path.

The ETRM classification lists this package body as a DML maintenance package (API classification OTHER). It is one of the automatically generated or template-derived "DL" (detail line / data loader) packages commonly produced by the Oracle Higher Education data model to encapsulate insert, update, delete, and validation logic for a single base table. Its validity status is VALID in the referenced 12.1.1 documentation set.

Key Procedures and Functions

The documented package exposes ten procedures and functions, all of which are typical of an EBS table-handling DML package:

• INSERT_ROW — Inserts a new non-standard use enrollment row into the base table.
• LOCK_ROW — Obtains a row-level lock on an existing record, used to serialize concurrent modifications before an update or delete.
• UPDATE_ROW — Applies changes to an existing non-standard use row.
• ADD_ROW — Higher-level convenience wrapper that combines validation and insert behavior for a new row.
• DELETE_ROW — Removes a non-standard use record from the base table.
• GET_PK_FOR_VALIDATION — Retrieves the primary key for a row to support downstream validation logic.
• GET_UK_FOR_VALIDATION — Retrieves the unique key value used for uniqueness validation.
• GET_UFK_IGS_PS_UNIT_OFR_OPT — Returns the user foreign key relating the record to the unit offering option entity maintained by IGS_PS_UNIT_OFR_OPT_PKG.
• GET_FK_IGS_EN_NSU_DLSTP_ALL — Returns the foreign key link to the related non-standard use status/detail record handled by IGS_EN_NSU_DLSTP_PKG.
• BEFORE_DML — A trigger-style procedure invoked before DML operations to apply standard attribute defaults, WHO columns, and validation checks.

Tables Accessed

The package references the following tables through APPS synonyms:

• IGS_EN_NSTD_USEC_DL — the base table storing non-standard use enrollment detail records. All INSERT, UPDATE, DELETE, and LOCK operations target this table.
• IGS_EN_NSTD_USEC_DL_S — the sequence supplying primary key values for new rows; this is the object likely surfaced when users search for igs_en_nstd_usec_dl_s.
• DUAL — used for singleton SQL statements, such as sequence or default value selection.

Additional program-unit dependencies include FND_GLOBAL (for session/user context), FND_MESSAGE and IGS_GE_MSG_STACK (for error messaging), APP_EXCEPTION (for standard exception handling), and the related packages IGS_EN_NSU_DLSTP_PKG and IGS_PS_UNIT_OFR_OPT_PKG.

Usage Notes

As a DML encapsulation package, IGS_EN_NSTD_USEC_DL_PKG is typically invoked by EBS Forms (Oracle Forms-based enrollment maintenance screens), by concurrent programs that load or migrate enrollment data, and by other PL/SQL packages that must maintain non-standard use records indirectly. The metadata notes that it is not referenced by any database object directly but is referenced by two other packages, indicating it is called programmatically rather than being triggered from a table.

Because all DML passes through this package, customizations and extensions should call its documented procedures instead of issuing direct SQL against IGS_EN_NSTD_USEC_DL. This preserves BEFORE_DML defaults, message-stack error reporting, and foreign key consistency with unit offering options and non-standard use status records.