Results for “igs_re_cdt_fld_of_sy_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.IGS_RE_CDT_FLD_OF_SY_PKG package body is a component of the Oracle E-Business Suite (EBS) Student System, specifically within the Recruitment and Admissions (IGS_RE) product family. It encapsulates the server-side business logic associated with the IGS_RE_CDT_FLD_OF_SY entity, which stores the field-of-study information linked to a candidate's record during the recruitment and admissions lifecycle. Its principal role is to provide a controlled Data Manipulation Language (DML) interface over that table so that forms, concurrent processes, and other PL/SQL units do not manipulate the underlying data directly. The package is classified in ETRM as an "OTHER" API type and is registered in the APPS schema as a VALID object, suitable for use across both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The documented package exposes nine procedures and functions, forming a complete row-level DML and validation surface:

• INSERT_ROW — Inserts a new field-of-study record for a candidate.
• UPDATE_ROW — Updates an existing field-of-study record with revised attribute values.
• DELETE_ROW — Removes a field-of-study record from the entity.
• ADD_ROW — Provides a convenience entry point for creating a new record, typically orchestrating sequence or key derivation alongside insertion.
• LOCK_ROW — Acquires a pessimistic lock on the target row to prevent concurrent modification during a transaction.
• GET_PK_FOR_VALIDATION — Retrieves the primary key of the record to support downstream validation logic.
• GET_FK_IGS_RE_CANDIDATURE — Resolves the candidate foreign key linkage, ensuring the field-of-study record is associated with a valid candidate.
• CHECK_CONSTRAINTS — Enforces the business and referential constraints applicable to the record before data is persisted.
• BEFORE_DML — A pre-DML hook that performs standard housekeeping such as setting the WHO columns (created/updated by, date, and login context) via FND_GLOBAL.

Because the package is an internal Supporting/Other API, its parameters are not published for external consumption; callers should interact through the standard recruitment forms or through the higher-level recruitment APIs such as IGS_RE_CANDIDATURE_PKG.

Tables Accessed

The package operates against a single documented base table, IGS_RE_CDT_FLD_OF_SY, accessed through the APPS synonym. This table holds the association between a candidate (foreign key to the candidature entity) and the field of study selected or recorded for that candidate. All insert, update, delete, lock, and constraint-checking operations performed by the package target this table. Supporting data lookups and validations are delegated to dependent objects including IGS_RE_CANDIDATURE_PKG, IGS_PS_FLD_OF_STUDY_PKG, and the validation packages IGS_RE_VAL_CAFOS, IGS_RE_VAL_CAH, and IGS_AS_VAL_SUAAP.

Usage Notes

The package is not referenced by any database object in ETRM, indicating it is invoked primarily at runtime rather than being called directly from other stored PL/SQL units. In practice, it is driven by the Recruitment and Admissions forms that maintain candidate field-of-study data, and by any concurrent programs or custom extensions that must create, maintain, or validate those records. Its dependency on FND_MESSAGE, IGS_GE_MSG_STACK, and APP_EXCEPTION indicates that it raises user-friendly, message-stack-integrated errors rather than raw Oracle exceptions, so callers should handle errors using the standard EBS message-stack pattern. Because it is marked as an OTHER API, direct invocation from custom code is possible but not formally guaranteed across releases; where possible, developers should route changes through the documented candidature API and treat this package as a supporting internal layer.