Search Results program_transfer_api




Overview
Explore in AI Chat

Overview

IGS_EN_TRANSFER_APIS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified within the ETRM repository as an "OTHER" API (as opposed to a public or internal interface). It belongs to the Oracle Student System (formerly Oracle iLearning/Student Systems, module prefix IGS) and specifically to the Student Enrollment (IGS_EN) product family. The package encapsulates the business logic required to process student unit-set transfers — the controlled movement of a student from one enrolled unit set, teaching period, or program configuration into another — while preserving academic attempt history and grade scheme integrity. Rather than exposing a single narrow interface, the package aggregates utility routines for transfer program orchestration, error logging, scheduled job cleanup, and candidate unit-set selection. Its status is VALID and it is referenced by only one other packaged object, IGS_EN_FUTURE_DT_TRANS, indicating that it operates as a shared service called primarily by date-driven transfer processing and by its own internal recursion. The presence of the FND_NEW_MESSAGES reference confirms that it participates in the EBS standard message/notification stack for surfacing user-facing errors during transfer execution.

Key Procedures and Functions

  • PROGRAM_TRANSFER_API — The principal entry point of the package. It drives the end-to-end transfer operation, coordinating validation and persistence across the enrollment, attempt, and person tables. It is the routine callers are expected to invoke when initiating a transfer rather than writing directly to the underlying tables.
  • ARRANGE_SELECTED_UNITSETS — Selects and organizes the candidate unit sets eligible for the transfer, applying the enrollment configuration and category pricing rules held in the IGS_EN configuration tables. It determines which unit sets can participate before PROGRAM_TRANSFER_API commits them.
  • LOG_ERR_MESSAGES — Raises and records error messages encountered during processing via FND_NEW_MESSAGES, providing the diagnostic trail for failed or partially successful transfers.
  • CLEANUP_JOB — Housekeeping routine that removes or resets transient data left behind by a transfer job run, supporting the re-runnable, batch-safe nature of the API.

Tables Accessed

All table access is performed through APPS synonyms. Enrollment and attempt data is read and written through IGS_EN_STDNT_PS_ATT_ALL, IGS_AS_SC_ATMPT_ENR, IGS_AS_SU_SETATMPT, and IGS_AS_GRD_SCH_GRADE, which together hold the student's program attempt, unit-set attempt, and grade scheme records. Configuration and reference data come from IGS_EN_CAL_CONF, IGS_EN_CAT_PRC_DTL, IGS_EN_METHOD_TYPE, IGS_EN_SPA_TERMS, and IGS_CA_INST_REL (calendar instance relationships). Person-level eligibility and restrictions are drawn from IGS_PE_PERSENC_EFFCT, IGS_PE_PERSON_TYPES, and IGS_PE_PERS_UNT_EXCL, while IGS_PS_STDNT_TRN supplies the student's transfer/prior-study record. FND_NEW_MESSAGES is used for message publication.

Usage Notes

IGS_EN_TRANSFER_APIS is not intended for direct end-user invocation from a form; it is called programmatically by IGS_EN_FUTURE_DT_TRANS during scheduled, date-effective transfer processing, and from custom PL/SQL that requires controlled unit-set transfer. Because it depends on SYS.STANDARD and is tightly bound to attempt and grade records, callers should ensure the enrollment period and calendar configuration are committed before execution, and should inspect the FND_NEW_MESSAGES output produced by LOG_ERR_MESSAGES to confirm success. The package is documented as VALID in both 12.1.1 and 12.2.2, and the documented metadata does not enumerate formal parameter lists; integrators should derive signatures from the installed package specification in their instance rather than assuming a fixed interface.