Search Results igf_sl_load_xml_s

Overview

IGF_SL_UPLOAD_XML is an APPS-owned PL/SQL package body in the Oracle E-Business Suite Financial Aid (IGF) module, part of the Student Loan processing family. Its purpose is to ingest, parse, and persist student loan data supplied in XML form, typically from external servicing partners, guarantee agencies, or regulatory data exchanges. The package reads inbound XML messages, maps them to the IGF student loan staging and transaction tables, and records processing outcomes such as response codes and receipt dates. Because its dependencies include workflow objects (WF_CORE, WF_ENGINE, WF_EVENT) and FND_REQUEST, the package participates both in workflow-driven event handling and in concurrent program submission, making it a hybrid loader and orchestration unit rather than a pure utility. In Oracle EBS 12.1.1 and 12.2.2, the object remains VALID and resides in the APPS schema, with synonyms exposing the underlying IGF tables to the package.

Key Procedures and Functions

The documented API includes fourteen procedures and functions. The naming and structure suggest the following roles, though parameter lists are not published here.

• MAIN and MAIN_RESPONSE: Primary entry points that drive XML processing and response generation.
• UPLOAD_XML: Core routine that reads and stages the inbound XML payload.
• SET_NLS_FMT, GET_DATETIME, GET_DATE: Formatting and date-conversion helpers supporting NLS and XML date parsing.
• GET_CREATED_BY, GET_CREATION_DATE, GET_LAST_UPDATED_BY, GET_LAST_UPDATE_DATE, GET_LAST_UPDATE_LOGIN: Standard audit column accessors.
• LAUNCH_REQUEST: Wrapper over FND_REQUEST used to submit concurrent programs, typically for downstream processing.
• UPDATE_RS_RESPCODE and UPDATE_RCPTDATE_RESPCODE: Status-update routines that record response codes and receipt dates on student loan response detail records.

Tables Accessed

The package touches a broad set of IGF and IGS tables via APPS synonyms. Loan staging and header data pass through IGF_SL_LOAD_XML_S and IGF_SL_LOANS (with IGF_SL_LOANS_PKG). Response detail tables — IGF_SL_AS_RESP_DTLS, IGF_SL_CR_RESP_DTLS, IGF_SL_DI_RESP_DTLS, IGF_SL_DL_RESP_DTLS, IGF_SL_DLDB_RSP_DTL, IGF_SL_RS_RESP_DTLS, IGF_SL_ST_RESP_DTLS, and IGF_SL_RESP_F_SMRY — store status, disbursement, and rejection outcomes. Change and code detail tables (IGF_AW_DB_CHG_DTLS, IGF_GR_COD_DTLS, IGF_GR_DB_RESP_DTLS) supply reference and demographic validation data. Lists of reports and locations are drawn from IGF_GR_REPORT_PELL, IGF_SL_LOR, IGF_SL_LOR_LOC, and IGF_SL_LOR_LOC_ALL. Finally, IGS_OR_ORG_ALT_IDS supplies institutional identifiers, while DBMS_LOB, UTL_FILE, FND_FILE, and FND_LOG provide CLOB handling and logging.

Usage Notes

IGF_SL_UPLOAD_XML is invoked from concurrent programs, workflow background processes, or custom integration code that must consume student loan XML feeds. It is not referenced by any other database object, indicating it functions as a top-level loader rather than a shared library. Implementers typically schedule it through FND_REQUEST or workflow event subscriptions. Because it emits messages through FND_MESSAGE and IGS_GE_MSG_STACK and logs to FND_LOG, diagnostics are available in the standard EBS log/report framework. No documented parameters are published; consult the package specification in the APPS schema before direct invocation.