Search Results call_sql_loader

Overview

APPS.CE_UK_VALIDATIONS_DATA_LDR is a United Kingdom localization utility within the Oracle Cash Management (CE) product family. Its business purpose is to load United Kingdom bank account validation data into the Cash Management validation repository so that the application can perform sort code and account number validation for UK bank accounts. The package supports the data-loading phase of UK payment and bank account setup, allowing customers to populate the modulus-weight and subsidiary-code reference data required by the UK validation algorithm.

The package is declared with AUTHID CURRENT_USER, meaning its database objects are resolved under the privileges of the invoking user rather than the definer. The header carries the EBS source control identifier $Header: ceukvlds.pls 120.0.12020000.5 2013/02/25, indicating a file version delivered with the 12.0.12 maintenance lineage and shipped forward into Oracle EBS 12.1.1 and 12.2.2. In the ETRM inventory the package is classified as API classification OTHER, reflecting that it is an internal localization utility rather than a general-purpose public API.

Key Procedures and Functions

The package exposes a single documented procedure, CALL_SQL_LOADER. This procedure is the entry point for loading UK validation data from an external flat file into the Cash Management interface tables. It accepts an error buffer and return code for standard concurrent-program style error handling, together with flags that describe the file type being processed, the directory path on the database server, and the name of the input file. The interface expects a file type identifier and a fully qualified server-side directory location so the routine can locate and parse the incoming data.

No other procedures or functions are documented for this package. The procedure is not referenced by any other package in the ETRM metadata, so it operates as a standalone loader invoked directly rather than as a dependency of a larger code chain.

Tables Accessed

Three application tables are documented as being accessed through APPS synonyms:

• CE_UK_VALIDATIONS_INTERFACE — the staging interface table into which the loader writes parsed records from the input file prior to validation and promotion into the permanent validation tables.
• CE_UK_VAL_MODULUS_WEIGHTS — holds the modulus weighting factors used by the UK modulus-check algorithm when validating sort codes and account numbers.
• CE_UK_VAL_SUBS_CODES — holds the substitute sort code mappings applied during successful validation when an account passes under a substitute code.

Together these tables constitute the reference and staging structures required to execute UK bank account validation, and the loader is the mechanism by which their content is populated from supplied data files.

Usage Notes

Because the procedure signature follows the conventional concurrent-program parameter pattern — an error buffer, a return code, and file location inputs — CALL_SQL_LOADER is typically invoked from a concurrent program or a wrapper script rather than interactively from a form. The loader also relies on SQL*Loader or an equivalent server-side file access mechanism, so the input file must reside in a directory accessible to the database server tier. In Oracle EBS 12.1.1 and 12.2.2 this aligns with the standard use of directory objects and the UTL_FILE or external table infrastructure used by similar data loaders.

Administrators should run the loader as part of the initial UK localization setup or when the vendored modulus weight and substitute code data changes. Because the package is classified as OTHER and is not referenced by other packages, it should be treated as an internal localization component; custom code should not depend on it, and any direct invocation should supply a valid file type, directory path, and input file name to avoid a failed load and partial interface records.