Design Overview

This wrapper batch program is used to populate/merge the delta changes that were made to the base Merchandising tables into respective MERCHAPI cache tables based on the ICL entries. Each API has a separate cache table and respective API package to refresh the table. Based on the Job name, it retrieves all the Job parameters from the MERCH_BATCH_PARAM table and calls the Delta PLSQL dynamically to process all the changes that were logged in the respective ICL table. All the ICL records which are in “N” status and consumer configured for that particular API are picked up for processing. First, it updates all the “N” records to “I” (In-Progress) and deletes all the “I” records once these are processed successfully.