Search Results set_nls_fmt

Overview

IGF_SL_UPLOAD_XML is an APPS-owned PL/SQL package within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment that supports the Student Loan (SL) component of the Oracle Financial Aid / ETRM (Enterprise Transaction Resource Management) module. Its central business function is to receive, parse, and persist XML payloads originating from external student lending and reporting agencies—such as the Common Origination and Disbursement (COD) system and the Department of Education—and to reconcile those payloads back into the EBS records that track loan origination, disbursement, and response processing. The package also provides utility accessors for auditing metadata (created by, creation date, last updated by, last update date, last update login) and helpers that format or convert date/time values for downstream writing. In this sense, IGF_SL_UPLOAD_XML acts as the ingestion and response layer between the .xml files delivered through the notification/response cycle and the structured ETRM tables that the Oracle Financial Aid application queries and displays.

Key Procedures and Functions

The documented program units include a small set of public entry points and a larger body of supporting utilities:

• MAIN / MAIN_RESPONSE — Primary driver entry points. MAIN handles the upload/processing workflow, while MAIN_RESPONSE drives the processing of response-type XML.
• UPLOAD_XML — Performs the core upload operation, parsing the incoming XML and inserting or updating the corresponding staging and detail records.
• LAUNCH_REQUEST — Submits a concurrent request, allowing the upload to run in a scheduled background process rather than synchronously.
• UPDATE_RS_RESPCODE / UPDATE_RCPTDATE_RESPCODE — Update the response code and receipt date fields on the relevant records after the response is received from the agency.
• GET_CREATED_BY, GET_CREATION_DATE, GET_LAST_UPDATED_BY, GET_LAST_UPDATE_DATE, GET_LAST_UPDATE_LOGIN — Accessors that return standard EBS audit column values.
• GET_DATETIME, GET_DATE, SET_NLS_FMT — Formatting/conversion utilities for dates and NLS date-format settings used when reading or writing textual data.

Tables Accessed

The package reads from and writes to a broad set of ETRM tables via APPS synonyms. These include staging and sequence structures such as IGF_SL_LOAD_XML_S and IGF_SL_COD_TEMP; document detail tables such as IGF_SL_COD_DOC_DTLS, IGF_GR_COD_DTLS, and IGF_AW_DB_CHG_DTLS; response detail tables such as IGF_SL_AS_RESP_DTLS, IGF_SL_CR_RESP_DTLS, IGF_SL_DI_RESP_DTLS, IGF_SL_DL_RESP_DTLS, IGF_GR_RESP_DTLS, and IGF_GR_DB_RESP_DTLS; plus summary, location, and receipt/response tables including IGF_SL_RESP_F_SMRY, IGF_SL_LOR_LOC_ALL, IGF_GR_REPORT_PELL, and IGF_SL_DLDB_RSP_DTL. Collectively these tables hold the loan origination, disbursement, Pell grant, and agency-response detail that the uploaded XML must populate and reconcile.

Usage Notes

IGF_SL_UPLOAD_XML is referenced by 0 other packages, indicating it is invoked directly rather than as a shared library. It is typically executed through concurrent programs or custom code that supplies the incoming XML, with LAUNCH_REQUEST available to schedule the work as a background request. Because it writes to staging and response tables used by Oracle Financial Aid screens, it should be run during controlled intake windows, and any custom invocation should preserve the package's audit-column population and NLS date-format handling to avoid corrupting downstream reporting values.