Search Results igs_ad_ps_aplinsthst_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_PS_APLINSTHST_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Student Systems product family, specifically the Oracle Student System (IGS) admissions module. The package name follows the IGS_AD naming convention used for admissions-related database objects, with the PS designation indicating that it is a generated or auto-created package supporting a specific base table, and APLINSTHST indicating its association with applicant institution history data.

The package encapsulates the standard PL/SQL table-handling interface for the IGS_AD_PS_APLINSTHST_ALL table. It provides the core Data Manipulation Language (DML) operations, row-locking logic, and constraint validation routines that Oracle EBS uses to maintain the integrity of applicant institution history records. This includes the tracking of prior educational institutions that an applicant has attended, a critical element of the admissions evaluation process. The package is classified as OTHER in the ETRM documentation, indicating that it is an internal support package rather than a public API.

Key Procedures and Functions

The package exposes eight documented procedures and functions that implement the standard Oracle EBS table-handler pattern:

  • INSERT_ROW — Performs a direct insert of a new applicant institution history record into the underlying table.
  • UPDATE_ROW — Performs a direct update of an existing applicant institution history record.
  • DELETE_ROW — Performs a direct deletion of an applicant institution history record.
  • LOCK_ROW — Acquires a row-level lock on a specified record to prevent concurrent modification during transactional processing.
  • ADD_ROW — Adds a new row, applying the appropriate default values and validation before committing the record.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a record so that constraint validation can be performed against the correct row.
  • CHECK_CONSTRAINTS — Validates the business rules and referential integrity constraints associated with the applicant institution history record.
  • BEFORE_DML — Serves as the pre-DML trigger logic that executes validation and defaulting before insert, update, or delete operations are applied.

Tables Accessed

The package operates on a single documented table, accessed through its APPS synonym: IGS_AD_PS_APLINSTHST_ALL. This table stores the applicant institution history records that the package creates, maintains, updates, and deletes. The _ALL suffix indicates that the table is partitioned by operating unit or multi-org enabled, which means the package's DML operations are subject to the Org_ID security context of the calling session. No other tables are referenced directly by the package according to the documented metadata.

Usage Notes

IGS_AD_PS_APLINSTHST_PKG is not intended for direct invocation by end users or custom developers in most cases. It is invoked indirectly through several admissions-related generators and concurrent programs. The documented dependents include IGS_AD_GEN_001, IGS_AD_GEN_002, IGS_AD_GEN_011, and IGS_AD_IMP_027, all of which reference this package to perform insert, update, and delete operations on applicant institution history data. It is also self-referencing, meaning the package body contains internal calls among its own procedures.

In a typical Oracle EBS 12.1.1 or 12.2.2 environment, this package is exercised whenever admissions data is entered through the Oracle Student System forms, loaded through concurrent import programs, or processed by batch generation routines. Custom code that needs to manipulate applicant institution history records should invoke the documented procedures rather than issuing direct DML against the underlying table, in order to preserve the validation and locking behavior enforced by the package. Because the object is a generated support package, its interfaces should be treated as stable but internal; developers should verify compatibility against the specific EBS patch level before relying on it in custom extensions.