Search Results igs_ps_ent_pt_ref_cd_seq_num_s

Overview

IGS_PS_OFR_OPT_PKG is the server-side PL/SQL package body that encapsulates the core data manipulation and validation logic for the Program Offering Option entity within the Oracle E-Business Suite Student Systems (Oracle Student System / OSS) product family. In the Oracle EBS 12.1.1 and 12.2.2 releases, the package resides in the APPS schema and carries a classification of OTHER, meaning it is a supporting application package rather than a formally published public API. Its principal responsibility is to service the IGS_PS_OFR_OPT and IGS_PS_OFR_OPT_ALL tables, providing the insert, update, delete, locking, and referential constraint validation operations required when users define or maintain offering options attached to a program offering. Offering options represent the configurable choices (such as attendance mode, attendance type, location, and person-level defaults) that govern how a specific program offering may be delivered and enrolled.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. INSERT_ROW, UPDATE_ROW, and DELETE_ROW perform the base DML operations against the offering option record. ADD_ROW provides a higher-level entry point that supplies defaulted values and orchestrates an insert, while LOCK_ROW performs the standard optimistic concurrency check by selecting the row for update and comparing its last-update timestamp. GET_PK_FOR_VALIDATION and GET_UK_FOR_VALIDATION return the primary key and unique key values used to detect duplicate or conflicting records. GET_FK_IGS_EN_ATD_MODE, GET_FK_IGS_EN_ATD_TYPE, GET_FK_IGS_PS_OFR, GET_FK_IGS_AD_LOCATION, and GET_FK_IGS_PE_PERSON resolve and validate the foreign key references to attendance mode, attendance type, program offering, location, and person. CHECK_CONSTRAINTS centralises the business-rule validation invoked during DML, and BEFORE_DML acts as the pre-insert/pre-update trigger body that enforces WHO-column auditing and constraint checks. The package also references IGS_PS_ENT_PT_REF_CD_PKG, which is why the sequence IGS_PS_ENT_PT_REF_CD_SEQ_NUM_S appears among the dependencies queried in the user's search.

Tables Accessed

The package reads and writes IGS_PS_OFR_OPT and IGS_PS_OFR_OPT_ALL, the base and international (MLS) tables holding offering option data. Reference validation is performed against IGS_GE_REF_CD and IGS_GE_REF_CD_TYPE_ALL for code values, IGS_PS_ENT_PT_REF_CD_SEQ_NUM_S for sequence numbering of entry point reference codes, and IGS_PS_VER, IGS_PS_VAL_CO, IGS_PS_VAL_COO, IGS_PS_VAL_CRS, and IGS_PS_VAL_UOO for offering version and validation rules. Composition and related-entity lookups are satisfied through IGS_EN_STDNT_PS_ATT_PKG, IGS_PS_OFR_PKG, IGS_PS_OFR_PAT_PKG, IGS_PS_OFR_OPT_NOTE_PKG, IGS_PS_OF_OPT_AD_CAT_PKG, and IGS_PS_OF_OPT_UNT_ST_PKG. DUAL and USER_OBJECTS support utility lookups, while FND_GLOBAL, FND_MESSAGE, IGS_GE_GEN_003, IGS_GE_MNT_SDTT, IGS_GE_MSG_STACK, IGS_GE_NUMBER, and APP_EXCEPTION provide session context, message handling, and error management. Package SYS.STANDARD is used implicitly.

Usage Notes

Because the package is classified as OTHER and is not referenced by any other database object in the reverse dependency chain, it is invoked directly by the Oracle Forms-based maintenance screens and by supporting PL/SQL APIs rather than being called from a public wrapper. The BEFORE_DML and CHECK_CONSTRAINTS routines are typically triggered from the form's PRE-INSERT, PRE-UPDATE, and PRE-DELETE triggers, while ADD_ROW and LOCK_ROW are called from the block-level ON-INSERT and ON-LOCK triggers respectively. Fifteen other packages depend on this package, indicating that offering option maintenance is embedded in broader program offering and enrolment business flows. Custom extensions should call the documented procedures rather than performing direct DML on IGS_PS_OFR_OPT_ALL, so that the WHO-column defaults, foreign key validations, and sequence handling remain consistent. No concurrent program is documented as a direct caller.