Results for “igs_as_spl_cons_appl_pkg”

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

Overview

IGS_AS_SPL_CONS_APPL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the data-access logic for the IGS_AS_SPL_CONS_APPL entity within the Student Systems (IGS) product family, specifically the Academic Support / Special Consideration area. The entity stores special consideration applications raised by or on behalf of students, capturing the person, course, unit, calendar, and assessment context together with administrative tracking attributes such as creation date, received date, tracking identifier, estimated processing days, notified date, and commentary.

The package follows the standard Oracle Designer-generated table handler pattern: it provides a coordinated set of insert, update, lock, delete, and pre-DML procedures that centralize all DML against the base table, together with helper functions that expose primary-key and foreign-key validation logic. This centralization ensures that constraints, defaulting rules, and referential checks are applied consistently regardless of whether the row originates from an Oracle Forms block, a concurrent program, or custom integration code.

Key Procedures and Functions

The ten documented program units divide into three functional groups.

• INSERT_ROW — Inserts a new special consideration application row. It accepts the complete attribute set (person, course, unit, calendar type, calendar instance sequence number, assessment identifier, creation and received dates, consideration category, sought outcome, consideration outcome, estimated processing days, tracking identifier, comments, unit offering option, and notified date) and returns the ROWID of the newly created record. A mode parameter defaults to 'R'.
• ADD_ROW — Variant of the insert operation, also returning the ROWID, used where the caller requires the row to be added without a pre-existing key.
• UPDATE_ROW — Updates an existing application row identified by ROWID, accepting the full attribute set including the mode parameter.
• LOCK_ROW — Issues a locking read against the row identified by ROWID, verifying that the supplied column values still match the persisted values. This supports optimistic concurrency control in the Forms layer.
• DELETE_ROW — Removes the application row. It is a documented unit of the package though its full signature is not reproduced in the excerpt.
• GET_PK_FOR_VALIDATION — Resolves and returns primary-key information used by the validation layer, allowing callers to confirm that a candidate key corresponds to a genuine application record.
• GET_FK_IGS_AS_SPCL_CONS_OUT — Foreign-key validation function for the special consideration outcome reference, confirming that the outcome value supplied by the user exists as a valid lookup.
• GET_FK_IGS_AS_SU_ATMPT_ITM — The foreign-key validation function the user searched for. It validates the association between a special consideration application and the corresponding student unit attempt item, ensuring the assessment context referenced by the application is legitimate before the row is committed.
• CHECK_CONSTRAINTS — Performs the package's consolidated constraint validation, invoked prior to DML to enforce mandatory and referential business rules.
• BEFORE_DML — A pre-DML hook that executes shared logic (defaulting, auditing, and constraint checks) ahead of insert, update, or delete operations.

Tables Accessed

Per the documented metadata, the package operates against a single base table, IGS_AS_SPL_CONS_APPL, accessed through its APPS synonym. This table is the persistent store for special consideration applications and holds the columns surfaced by the insert, update, and lock parameter lists. The foreign-key helper functions imply read access to the parent reference entities for special consideration outcomes and student unit attempt items, which are validated rather than modified by this package.

Usage Notes

The package is referenced by four other packages and is therefore a foundational table handler within the IGS Academic Support module rather than an end-user-facing API. It is typically invoked from the Oracle Forms application that maintains special consideration records, where block-level triggers call LOCK_ROW on record navigation, UPDATE_ROW on save, INSERT_ROW or ADD_ROW on create, and DELETE_ROW on removal. The GET_FK_* functions are called from validation triggers to perform LOV and foreign-key checks in the user interface.

Custom code and concurrent programs should call these procedures rather than issuing direct DML against IGS_AS_SPL_CONS_APPL, so that BEFORE_DML logic, constraint checking, and mode handling are consistently honored. Because the package carries a 2005 header revision (120.0) and is present in both EBS 12.1.1 and 12.2.2, behavior is stable across those releases; the 12.2.2 online patching architecture does not alter the package's runtime contract, though the editioning model means callers in custom schemas must reference the APPS synonym appropriately.