Search Results igs_ad_ps_aplinstunt_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_PS_APINTUNTHS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified under the Student Systems (IGS) product family as an "OTHER" API type. Its naming convention — combining the IGS_AD module prefix with the PS (Public Sector/Student) and APINTUNTHS tokens — indicates that it serves as a table-handling package for the IGS_AD_PS_APINTUNTHS entity, a prospective/applicant "interest" or "intent" staging structure used by the Student Systems admissions and recruitment modules. The package encapsulates the standard Oracle Forms server-side DML logic (INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, ADD_ROW, BEFORE_DML, CHECK_CONSTRAINTS, and validation-key retrieval routines) that supports the base table and its translated or secondary table. Its primary business role is to maintain the referential and business integrity of records that capture applicant interest in academic programs, while providing a reusable, callable API for the C-form and any concurrent or custom processes that must maintain the same data.

Key Procedures and Functions

The documented API exposes nine procedures and functions that mirror the classic Oracle EBS table-handling pattern:

  • INSERT_ROW — Inserts a new row into the base table, populating surrogate and descriptive columns from the caller's values.
  • ADD_ROW — Companion insert routine typically used to add a row from a single-record block in a form, handling defaulting and primary-key derivation.
  • UPDATE_ROW — Modifies an existing row, refreshing the WHO columns and the object version number used for optimistic locking.
  • DELETE_ROW — Physically removes the identified row after verifying it is eligible for deletion.
  • LOCK_ROW — Issues a SELECT ... FOR UPDATE against the row's primary key to serialize concurrent form sessions and prevent lost updates.
  • GET_PK_FOR_VALIDATION — Resolves and returns the primary-key value for a row (or validates that a supplied key is correct) before protected DML executes.
  • GET_UK_FOR_VALIDATION — Returns the unique-key values (typically the combination of business columns such as person, program, and term) for validation and duplicate checking.
  • CHECK_CONSTRAINTS — Performs the procedural equivalent of database check constraints, rejecting invalid or inconsistent column combinations before DML proceeds.
  • BEFORE_DML — Central pre-DML hook that sets WHO audit columns, the object version number, and other standard row attributes, and is invoked by all insert, update, and delete paths.

The package specification and body are both reported as VALID, and no parameter signatures are documented in the ETRM extract; parameter lists therefore should be confirmed against the actual source before use.

Tables Accessed

The package operates against two documented APPS synonyms:

  • IGS_AD_PS_APINTUNTHS_ALL — The base (non-translated) table containing all applicant-interest rows for every language; INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW target this table.
  • IGS_AD_PS_APINTUNTHS_S — The translated (or "S" language) table holding language-specific description columns; it is maintained in parallel during DML so that multilingual support remains consistent.

CHECK_CONSTRAINTS validates values against these tables' business rules, while GET_PK_FOR_VALIDATION and GET_UK_FOR_VALIDATION read them to resolve identifying keys.

Usage Notes

This package is referenced by three other APPS packages: IGS_AD_GEN_001, IGS_AD_GEN_010, and IGS_AD_PS_APLINSTUNT_PKG, and it also references itself (for internal recursive calls). In practice it is invoked from the Student Systems admissions/recruitment Oracle Forms when a user inserts, updates, or deletes an interest record, and from concurrent programs or custom extensions that must write to the same base and translated tables. Because the metadata shows only dependencies on SYS.STANDARD and no other external packages, it is safe to call directly from PL/SQL. Developers should call the BEFORE_DML routine before any direct DML and honor the LOCK_ROW / GET_PK_FOR_VALIDATION sequence to preserve concurrency and audit integrity. Note the user search term "igs_ad_ps_aplinstunt_pkg" appears to be a transposition of the related package IGS_AD_PS_APLINSTUNT_PKG; the object documented here is IGS_AD_PS_APINTUNTHS_PKG. All changes should be regression-tested against APPS compilation in both EBS 12.1.1 and 12.2.2.