Search Results get_fk_igs_en_atd_mode

Overview

IGS_FI_FEE_AS_RT_PKG is a student-system fee API package in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and classified under the ETRM "OTHER" API category. Its name decomposes into the functional area it serves: IGS (Oracle Student System / iGSi), FI (Financial), and FEE_AS_RT (fee assessment rate). The package therefore encapsulates the fee assessment rate entity for higher-education institutions, which determines how charges are calculated against a student's course registration, fee type, attendance profile, and location over a defined date range. The package exposes the canonical transactional operations — insert, lock, update, add, delete, and validation — that EBS uses to maintain the assessment rate rows, together with foreign-key lookup routines and a before-DML trigger helper that enforce relational and business integrity. Because it is a table-handler API rather than a public business flow API, it is called by generated forms, other fee packages, and the standard EBS DML infrastructure rather than by end users directly.

Key Procedures and Functions

• INSERT_ROW — inserts a new fee assessment rate record for a person, course, fee type, and effective date range, including location, attendance type, attendance mode, charge rate, and the lower normal rate override indicator.
• LOCK_ROW — acquires a pessimistic lock on an existing row to support optimistic/concurrency-controlled maintenance from the UI layer.
• UPDATE_ROW — modifies an existing assessment rate row identified by its ROWID, applying the same attribute set as INSERT_ROW.
• ADD_ROW — performs an add-style insert (insert-if-absent semantics) within the API, returning the new ROWID to the caller.
• DELETE_ROW — removes an assessment rate row by ROWID.
• GET_PK_FOR_VALIDATION — validates the primary key combination (person, course, fee type, start date), returning Boolean success/failure for caller-side validation.
• CHECK_CONSTRAINTS — centralizes constraint enforcement (mandatory columns, lookup membership, FK integrity) for the entity and is typically invoked from Before-DML triggers.
• BEFORE_DML — the trigger-support procedure containing pre-DML logic such as column derivation, WHO-column population, and constraint calls.
• GET_FK_IGS_EN_ATD_MODE — foreign-key lookup that validates/derives the attendance mode against the IGS_EN_ATD_MODE reference entity. This is the routine the user searched for, and it is the documented FK check for the X_ATTENDANCE_MODE column.
• GET_FK_IGS_EN_ATD_TYPE — FK lookup for attendance type. GET_FK_IGS_AD_LOCATION — FK lookup for location code. GET_FK_IGS_EN_STDNT_PS_ATT — FK lookup for the student person-attendance entity.

Tables Accessed

The package operates on the base table IGS_FI_FEE_AS_RT (accessed via the APPS synonym), which stores fee assessment rates with a composite key of person, course, fee type, and effective start/end dates. Reads and writes are performed through the documented DML and lookup procedures, with row identification consistently performed by ROWID to ensure the API manipulates the intended physical row. The GET_FK_* routines implicitly reference the IGS_EN_ATD_MODE, IGS_EN_ATD_TYPE, IGS_AD_LOCATION, and IGS_EN_STDNT_PS_ATT reference entities to validate foreign-key values before commits.

Usage Notes

IGS_FI_FEE_AS_RT_PKG is invoked from the Oracle Forms layer backing Student System fee maintenance windows, from Before-DML database triggers that delegate constraint and FK processing to the package, and from other PL/SQL packages — ETRM records seven dependent packages that reference it. Customizations should call the packaged procedures rather than issuing direct DML against IGS_FI_FEE_AS_RT so that FK validation (including GET_FK_IGS_EN_ATD_MODE), WHO columns, and concurrency locking remain consistent with EBS standards. The X_MODE parameter, defaulting to 'R', controls how lookups are resolved relative to form state.