Search Results create_fa_base_record




Overview
Explore in AI Chat

Overview

IGF_SP_CREATE_BASE_REC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Financial Aid module of Oracle Student Systems (OSS). Its purpose, as stated in the package header, is to create the equivalent financial aid base records that are prerequisites for sponsorship processing. The package was originally authored in January 2002 as part of the build for DLD Sponsorship, and the source header indicates a last revision dated November 2002 (115.2).

Within the sponsorship workflow, a student must have a corresponding financial aid base record before a sponsor can be assigned to that student or before the sponsor award process can run. This package provides the mechanism that generates those base records, bridging the student's person record in OSS with the financial aid base record structure held in the IGF tables.

Key Procedures and Functions

The package exposes two documented program units:

  • PROCEDURE create_base_record — The main entry point, designed to be invoked from a concurrent manager. It receives the concurrent program's standard completion parameters (errbuf and retcode) together with the award year, person identifier, person group identifier, and an optional organization identifier. The procedure drives the base record creation process for the specified student population and reports back status through the concurrent manager return values.
  • FUNCTION create_fa_base_record — A helper function called internally by create_base_record to perform the actual creation of an individual base record. It accepts calendar instance context (calendar type and sequence number) along with the person identifier, and returns a Boolean success indicator while outputting the newly created base identifier and an associated message.

No parameter lists are reproduced here beyond those documented in the package specification.

Tables Accessed

According to the documented metadata, the package accesses the following objects through APPS synonyms:

  • FND_NEW_MESSAGES — The Oracle Application Object Library message repository, used to retrieve or store user-facing messages such as the output message returned by create_fa_base_record.
  • HZ_PARTIES — The Trading Community Architecture party table, referenced to resolve the person identity associated with the base record being created.
  • IGS_PE_ALT_PERS_ID — The alternate person identifier table, used in resolving person identification and matching for the financial aid base record.

The package specification additionally declares parameters and outputs typed against IGS_CA_INST (calendar instances), IGS_PE_PERSON (person master), IGS_PE_PRSID_GRP_MEM (person group membership), and IGF_AP_FA_BASE_REC (financial aid base records), confirming that the core write target is the financial aid base record table.

Usage Notes

create_base_record is intended to be executed as a concurrent program, not called interactively from a form. The errbuf and retcode parameters follow the standard OAF/Reports concurrent manager convention, and the award year and person group parameters allow the run to be scoped to a specific population and academic period.

The metadata records that the package is referenced by one other package, indicating it is a supporting component within the sponsorship processing chain rather than a broadly reused utility. Custom code should generally not bypass it by inserting base records directly, since the function encapsulates the matching, messaging, and identifier assignment logic required for downstream sponsor assignment and sponsor award processes. When extending or troubleshooting sponsorship flows, the most reliable diag nostic point is the message returned through FND_NEW_MESSAGES by create_fa_base_record on a failed creation attempt.