Search Results igs_ad_program_appl




Overview
Explore in AI Chat

Overview

IGS_RATINGS_PUB is a public PL/SQL API belonging to the Oracle Student System (formerly Oracle iLearning and Student Information), delivered under the APPS schema with application identifier 8405. Its package body provides the transactional plumbing that supports admissions rating and program-approval processing within the IGS (Institutional Graduation and Student) product family. The package encapsulates the server-side logic that lets admissions officers and academic reviewers record decisions against an applicant's chosen program of study, and lets the institution assign individuals to evaluate a specific application. The only header comment visible in the body is the standard CVS identifier, indicating the shipped source file IGSPRATB.pls at version 120.0, dated 2005, which places the lineage of the package well before the 12.1.1 release but still shipped in the 12.1.1 and 12.2.2 file systems.

A notable feature of the body is the internal helper check_length, which queries FND_COLUMNS and FND_TABLES to derive the declared width or numeric precision of a target column, then raises the IGS AD_EXCEED_MAX_LENGTH message through FND_MESSAGE when the supplied parameter exceeds that limit. This defensive routine ensures that data passed in from a calling form or API does not breach the underlying schema definition before an INSERT or UPDATE is attempted.

Key Procedures and Functions

  • REC_PGM_APPROVAL — Records a program-approval decision for an applicant. The procedure follows the Oracle Application Object Library standard API signature conventions (p_api_version, p_init_msg_list, p_commit, p_validation_level, plus the x_return_status, x_msg_count and x_msg_data OUT parameters). In addition it accepts a person identifier, an admission application number, and a nominated program code, and writes the resulting approval record. Because it is a PUB API, it is safe to call from other PL/SQL units and is the supported entry point for program-approval processing.
  • ASSIGN_EVALUATORS_TO_AI — Assigns one or more evaluators to an admission item or application, populating the evaluation rows used later by the ratings workflow. The procedure likewise adheres to the FND_API error-stack protocol so that any validation failure is surfaced through x_msg_count and x_msg_data rather than an unhandled exception.

Tables Accessed

  • IGS_AD_APPL_PGMAPPRV — the primary store of program-approval rows written by REC_PGM_APPROVAL.
  • IGS_AD_APPL_ARP — admission application response or applicant record data read to validate the person and application context.
  • IGS_AD_APPL_EVAL — evaluation rows created by ASSIGN_EVALUATORS_TO_AI.
  • IGS_AD_APL_REV_PRF_ALL — applicant review profile data, the multi-org table of record for review attributes.
  • IGS_AD_DOC_STAT — document status of the applicant, consulted during validation.
  • FND_COLUMNS and FND_TABLES — queried by check_length to resolve the physical width or precision of a parameter's target column, restricted to APPLICATION_ID 8405.

Usage Notes

As a _PUB API, IGS_RATINGS_PUB is intended to be the supported integration point for admissions evaluation and program approval. It is typically invoked from the Admissions forms within the Oracle Student System responsibility, and it may also be called from concurrent programs, workflow activities, or bespoke customer extensions that need to approve an applicant for a program or attach evaluators to an application. The package is referenced by no other delivered packages in the ETRM inventory, so its consumers are almost always forms or customer code. Callers must supply a valid p_api_version, inspect x_return_status after every invocation, and iterate x_msg_count using FND_MSG_PUB.GET to retrieve messages. Because the procedures raise FND_API.G_EXC_ERROR on validation failure — for example when a parameter exceeds its column length — calling code should not assume success without checking the return status.