APPS.MSC_CL_PROFILE_LOADERS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 242

       LOG_MESSAGE('ATTENTION: If Loader Worker has completed with ERROR, then user has to delete the records from MSC_ST_PROFILES with process flag 1 for that particular preference set,correct the data file and load it again');

Line: 244

      LOG_MESSAGE('delete from MSC_ST_PROFILES where preference_set_name=PREFERENCE_SET_NAME and process_flag=1');

Line: 362

                  select (SYSDATE- START_TIME) into lv_process_time from dual;

Line: 373

         select (SYSDATE- START_TIME) into lv_process_time from dual;