Search Results igf_ap_profile_gen_pkg




Overview
Explore in AI Chat

Overview

IGF_AP_PROFILE_GEN_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that exposes generic utility routines supporting the Oracle Student System (IGS/IGF) self-service pages and the Profile Import process. The package sits within the financial aid and student profile management area of EBS and is responsible for creating, loading, matching, and removing profile-related records tied to a Candidate Student Identification (CSS_ID). Its procedures are invoked to generate base and person-level profile records, upload profile data gathered through self-service, and clean up interface and matching records when a profile transaction is abandoned or reprocessed.

The package name prefix IGF indicates it belongs to the Oracle Student System (formerly Oracle iLearning/Student System) financial module, with the AP segment suggesting an interface to Oracle Payables-style batch processing. The documented header notes that the routines are used in self-service pages and the Profile Import Process, confirming the package serves both online user-triggered operations and batch integrations.

Key Procedures and Functions

  • CREATE_BASE_RECORD — Creates a base profile record for a given CSS_ID, person and batch year, returning a message and status. It is the primary entry point for seeding the base record used by downstream profile processing.
  • CREATE_PERSON_RECORD — Creates a person-level record associated with a CSS_ID and returns the generated person identifier, along with status output. It may invoke or depend on base record creation.
  • DELETE_PERSON_MATCH — Deletes person matching records for the supplied CSS_ID, clearing stale matches before re-matching.
  • DELETE_INTERFACE_RECORD — Removes a single interface record associated with a CSS_ID and returns a status indicator. This is the routine the user searched for ("delete_interface_record").
  • DELETE_INT_RECORDS — Performs a bulk deletion of interface records given a delimited list of CSS_IDs, supporting cleanup of multiple profiles in one call.
  • SS_UPLOAD_PROFILE — Uploads profile data captured through a self-service page for a CSS_ID, returning message and status output; this is the main routine invoked from the self-service UI.

Tables Accessed

  • IGF_AP_CSS_INTERFACE_ALL — The staging/interface table holding profile data to be processed; DELETE_INTERFACE_RECORD and DELETE_INT_RECORDS operate against this table.
  • IGF_AP_FA_BASE_REC_ALL — Stores base profile records created by CREATE_BASE_RECORD.
  • IGF_AP_MATCH_DETAILS — Holds matching detail rows; affected by delete operations and matching logic.
  • IGF_AP_PERSON_MATCH_ALL — Stores person-level match records; DELETE_PERSON_MATCH targets this table.
  • IGS_PE_ALT_PERS_ID — Alternate personal identifier table referenced during person record creation and matching.

Usage Notes

IGF_AP_PROFILE_GEN_PKG is typically invoked from Oracle EBS self-service pages in the Student System, from the Profile Import concurrent process, and from custom extensions that manage candidate student profiles. DELETE_INTERFACE_RECORD and DELETE_INT_RECORDS are commonly called after a failed or superseded profile upload to prevent orphaned interface rows from being reprocessed. Because the package is not documented as a public API under a formal API classification (OTHER), callers should treat its procedures as internal utilities and be cautious about signature or behavior changes across patch levels. The package references APPS synonyms for all underlying tables, so it must be invoked within the APPS schema context or with appropriate synonym grants. One other package references this package, indicating a dependency chain that custom code should respect. Its creation date (2004) and header comments confirm it is a long-standing component of the financial aid integration layer.