Search Results css_import




Overview
Explore in AI Chat

Overview

The IGF_AP_LI_PROF_IMP_PROC package is a PL/SQL concurrency program driver within the Oracle E-Business Suite Financial Aid (IGF) module, specifically supporting the administration of Title IV aid under the U.S. federal student financial assistance framework. The package name indicates its role in Award Letter/Profile Import Processing for the Loan Interface (LI) subsystem, combining both Institutional Student Information Record (ISIR) profile data and Common Origination and Disbursement (COD) Student Subsidy (CSS) data into the Oracle student aid tables. It is owned by APPS and classified as an OTHER API, meaning it is intended primarily for internal concurrent program invocation rather than as a public extension interface. The declared AUTHID CURRENT_USER pragma indicates the package executes with the privileges of the invoker, which is standard for a concurrent-program entry point executed by an APPS-schema responsibility.

Key Procedures and Functions

The documented package exposes two procedures:

  • MAIN — The primary driver entry point invoked by a concurrent program. It orchestrates the overall import operation across multiple input sources, accepting context parameters that identify the award year, the batch to process, a deletion indicator, and a p_css_import flag. The default of NULL on the CSS import flag means the procedure can be invoked either for a combined profile/CSS import or selectively for CSS-only processing. It also declares supporting collection and record types (message_rec, lookup_meaning_tab, igf_ap_lkup_hash_table, igf_ap_message_table) used for internal message handling and lookup caching.
  • CSS_IMPORT — A specialized procedure for processing CSS (COD Student Subsidy) data specifically. It receives the standard concurrent-program return parameters (errbuf, retcode) and an award year, and drives the CSS-specific import logic independent of the broader MAIN flow.

No public functions or additional procedures are documented in the ETRM metadata.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

  • IGF_AP_CSS_INTERFACE_ALL and IGF_AP_LI_CSS_INTS — Interface tables holding inbound CSS data, consistent with the css_import procedure's purpose and the user's "css_import" search term.
  • IGF_AP_ISIR_INTRFACE_ALL — The ISIR interface staging table for incoming federal student aid applicant records.
  • IGF_AP_LI_BAT_INTS — Batch control/interface table used to track import batches (aligned with the p_batch_id parameter).
  • IGF_AW_LI_COA_INTS — Cost of Attendance interface table, feeding award calculations.
  • IGS_PE_ALT_PERS_ID and IGS_PE_PERSON_ID_TYP — Person/alternate identifier tables in the Student System (IGS) used for matching incoming records to existing persons.
  • FND_NEW_MESSAGES — Oracle Application Object Library message repository, used to resolve message text for user-facing errors.
  • DBMS_UTILITY, DUAL, and PLITBLM — Utility and inline-table helpers; PLITBLM refers to the PL/SQL table bulk-loading utility.

Usage Notes

IGF_AP_LI_PROF_IMP_PROC is typically invoked as a concurrent program from the Financial Aid responsibility, most often during the nightly or scheduled ISIR/CSS load cycle. It is registered via the standard concurrent program framework (handling errbuf/retcode) rather than being called directly from forms. The presence of a p_del_int parameter indicates a mode to delete previously staged interface rows before reloading. Because the package is classified as OTHER and is referenced by zero other packages, custom code should treat it as an implementation-level program invoked through the concurrent manager; direct calls should replicate the standard errbuf/retcode signature. The css_import procedure provides a narrower entry point when only CSS data requires processing, which is commonly scheduled separately from the broader profile import to align with COD transmission windows.