Search Results igs_fi_sub_er_rt_pkg

Overview

The APPS.IGS_FI_SUB_ER_RT_PKG package is a PL/SQL database object within the Oracle E-Business Suite (EBS) Student Systems / Financials integrated module set, specifically belonging to the IGS product family — Oracle's legacy Student Information System (SIS) components that handle fee assessment, fee rate definition, and student financial transactions. In ETRM and related EBS 12.1.1 / 12.2.2 documentation, this package is classified with an API classification of OTHER, indicating it is not a formal public API but rather an internal helper package used to maintain the "Sub-Entity Rate" (SUB_ER_RT) data structures.

Its principal business function is to provide programmatic maintenance of the sub-entity rate records used by the fee assessment engine. These records determine how fee rates are applied to subordinate entities — for example, specific study modes, attendance types, or fee categories nested beneath a higher-level entity. The package therefore acts as the low-level data access layer that the higher-level fee rate packages (such as IGS_FI_FEE_AS_RATE_PKG) and fee processing routines (such as IGS_FI_PRC_FEE_ROLLV and IGS_FI_GEN_003) depend upon to read and persist sub-entity rate definitions.

Key Procedures and Functions

ETRM documents eight procedures/functions within this package. Their names and purposes are as follows:

• INSERT_ROW — Inserts a new sub-entity rate record into the base table, populating the standard WHO columns and primary key.
• LOCK_ROW — Acquires a row-level lock on a specified sub-entity rate record to prevent concurrent modification during update transactions.
• UPDATE_ROW — Applies changes to an existing sub-entity rate record, including audit column maintenance.
• ADD_ROW — A convenience wrapper that validates the incoming data and then delegates to the insert logic, providing a higher-level entry point for adding a rate row.
• GET_PK_FOR_VALIDATION — Resolves the primary key of a sub-entity rate record so that validation routines can confirm its existence and identity.
• GET_UK_FOR_VALIDATION — Resolves the unique key of a record, supporting duplicate-detection and validation logic.
• GET_FK_IGS_FI_FEE_AS_RATE — Returns the foreign key linkage to the parent fee assessment rate entity, establishing the referential relationship between the sub-entity rate and its owning fee-as-rate record.
• BEFORE_DML — A trigger-style pre-DML handler that enforces WHO-column defaults, key derivation, and any mandatory validations before an insert or update executes.

Tables Accessed

The package reads and writes the following documented tables (accessed via APPS synonyms):

• IGS_FI_SUB_ER_RT — The primary base table storing sub-entity rate definitions. All INSERT, UPDATE, and LOCK operations target this table, and the GET_* validation helpers query it to resolve keys.
• IGS_FI_SUB_ER_RT_S — The corresponding "_S" (secondary/supplementary or translated) table. It typically holds the language-dependent or descriptive attributes linked to the base row and is consulted during insert/update to keep the paired rows synchronized.

Because the "_S" table is maintained alongside the base table, the package effectively guarantees that a base sub-entity rate record and its associated descriptive record remain consistent within the same transaction.

Usage Notes

This package is an internal component and is not intended to be called directly by end users or external customer code. Its dependencies confirm its position within the fee-rate maintenance stack:

• It is referenced by three packages — IGS_FI_FEE_AS_RATE_PKG, IGS_FI_GEN_003, and IGS_FI_PRC_FEE_ROLLV — which call it when creating, updating, or rolling over fee rates.
• It references only the standard SYS.STANDARD package, reflecting that it relies on normal PL/SQL semantics rather than other application-level APIs.

Typical invocation occurs indirectly through:

• Fee assessment and rate maintenance forms that save sub-entity rate data.
• Concurrent programs that generate or roll over fee rates (for example, the process behind IGS_FI_PRC_FEE_ROLLV).
• Custom or extension code that manipulates sub-entity rate definitions, though this should ideally be routed through the higher-level IGS_FI_FEE_AS_RATE_PKG API.

Because ETRM lists the object as VALID in APPS for both 12.1.1 and 12.2.2, the package is a supported, present component in those releases. However, given its classification as OTHER, developers should treat it as a private implementation detail and avoid direct calls where a documented public API exists.