Results for “igs_en_career_model”

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

Overview

IGS_EN_CAREER_MODEL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family. Its name and documented interfaces indicate that it implements the career and program model rules governing student course attempt status transitions within Oracle Student Systems. Specifically, the package encapsulates the logic that determines whether a student's attempt at a course contributes to, or fulfils, a "primary" program requirement, and whether the student maintains exactly one primary program at any point in time. Such logic is central to enrollment processing because a student's primary program designation drives requirement tracking, progression evaluation, and academic standing calculations.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user and therefore relies on the caller having appropriate grants on the underlying student records tables (accessed through APPS synonyms). It is an internal, rule-oriented package rather than a public API, and its header carries an old revision marker (115.4, dated 2002), indicating that it has been stable since the early 11i era and carried forward largely unchanged into Release 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes four documented program units:

• ENRP_GET_SEC_SCA_STATUS — A function that returns a VARCHAR2 value representing a secondary student course attempt (SCA) status. It derives this status from inputs describing the person, the course, the current course attempt status, the primary program type and its source, the course type, and optionally a new primary course. It is the package's status-derivation utility, used to compute the correct secondary attempt status under the career model rules.
• SCA_TBH_BEFORE_DML — A procedure intended as a "before DML" table handler. It receives the person, course, version, and the old and new course attempt statuses, along with IN OUT NOCOPY parameters for primary program type, program type source, and new key program. Its purpose is to evaluate and, where necessary, adjust these values before a student course attempt row is inserted or updated, enforcing the single-primary-program constraint.
• SCA_TBH_AFTER_DML — The complementary "after DML" table handler, invoked once the course attempt change has been persisted. It receives old and new status and program-type information so that downstream derivations and dependent records can be reconciled after the primary program designation changes.
• ENRP_CHECK_FOR_ONE_PRIMARY — A boolean function that validates the invariant that a student holds exactly one primary program of a given course type. It returns TRUE or FALSE and returns an associated message name through an OUT NOCOPY parameter, enabling callers to surface a specific validation message when the rule is violated.

Tables Accessed

The only documented table reference is IGS_EN_STDNT_PS_ATT_ALL, the student program attempt (program-of-study attempt) table accessed via its APPS synonym. This table stores each student's program attempt records, including the primary program type and its source, which are precisely the attributes manipulated by the BEFORE DML and AFTER DML handlers and validated by ENRP_CHECK_FOR_ONE_PRIMARY. The package reads and modifies these records to keep primary program designation consistent with course attempt status changes.

Usage Notes

IGS_EN_CAREER_MODEL is not a user-facing API; it is invoked indirectly. Its table-handler procedures are typically wired into the DML processing of student course attempt records, and the package is referenced by three other packages in the IGS schema. Invocation occurs during enrollment form transactions, concurrent program processing of student records, and any custom code that manipulates student program or course attempt data. Because the package enforces the single-primary-program rule, integrators who modify IGS_EN_STDNT_PS_ATT_ALL directly must call SCA_TBH_BEFORE_DML and SCA_TBH_AFTER_DML to avoid corrupting primary program designations.