Results for “rec_pgm_approval”

10 results




Overview
Explore in AI Chat

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

Overview

IGS_RATINGS_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Student System (product code IGS) and specifically within the component designated as iRecruitment/Admissions evaluation infrastructure. The package encapsulates server-side business logic for the admissions evaluation process, providing a supported public interface for assigning review groups and evaluators to admission applications, and for recording program approval decisions against an application instance. The header comment identifies the package scope as public, its lifecycle status as active, and its compatibility as "S" (supported), meaning it is eligible for customer invocation and is subject to Oracle's public API upgrade guarantees. The associated business entity is IGS_ADM_APPLICATION.

Key Procedures and Functions

The ETRM repository documents two callable procedures in this package:

  • ASSIGN_EVALUATORS_TO_AI — The procedure corresponding to the search term raised by the user. It assigns review groups and evaluators to a specific admission application. This is the primary business function of the package and supports the routing of an application to the appropriate reviewers within the admissions evaluation cycle.
  • REC_PGM_APPROVAL — A public API that records program approval for an application. The program approval can be recorded against an application instance, with the procedure designed to be called from workflow logic, triggered by data entry or update events raising a business event, or invoked as the result of evaluating a defined sequence of logic.

The REC_PGM_APPROVAL interface follows the standard Oracle EBS API parameter convention: an API version, an initialization flag (p_init_msg_list), a commit flag (p_commit), a validation level, and the standard return status and message count/data output parameters. Its business parameters identify the person, admission application number, nominated program code, sequence number, program approver, approval date, approval status, and approval notes.

Tables Accessed

The package references the following tables through APPS synonyms:

  • IGS_AD_APL_REV_PRF_ALL — Stores reviewer profile assignments associated with an admission application; central to the evaluator-to-application assignment performed by ASSIGN_EVALUATORS_TO_AI.
  • IGS_AD_APPL_EVAL — Holds evaluation records for an admission application, supporting the evaluation workflow.
  • IGS_AD_APPL_ARP — Links applications to review groups or applicant review profiles.
  • IGS_AD_APPL_PGMAPPRV — Stores program approval decisions written by REC_PGM_APPROVAL.
  • IGS_AD_DOC_STAT — Tracks document status associated with the application, used for validation and procedural context during evaluation.
  • FND_COLUMNS and FND_TABLES — Oracle Application Object Library metadata tables, consulted for dynamic column and table information used by the API's validation layer.

Usage Notes

IGS_RATINGS_PUB is a supported public API and is intended for invocation from forms, concurrent programs, workflow activities, and custom extensions rather than as an internal helper. Because REC_PGM_APPROVAL is explicitly documented as callable from workflow logic and business events, implementers can integrate program approval recording into admissions business processes without directly manipulating base tables. Callers should pass an appropriate API version, initialize the message list when required, and control transaction commit explicitly through the p_commit parameter so that the assignment and approval operations participate correctly in the surrounding transaction. The standard x_return_status, x_msg_count, and x_msg_data outputs should always be checked to confirm success and to retrieve validation messages. As a public, compatible API, it is safe to reference from custom code in both EBS 12.1.1 and 12.2.2. The package is not referenced by any other documented package, confirming its role as a top-level entry point for admissions evaluation and program approval functionality.