APPS.DDR_FACT_WEBSERVICES_PUB SQL Statements

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

Line: 861

  INSERT INTO ddr_ws_job(job_id, status, SRC_SYS_IDNT,SRC_SYS_DT, CRTD_BY_DSR, LAST_UPDT_BY_DSR, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,   LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
  VALUES (l_job_id, ddr_webservices_constants.g_ret_sts_initialize,'-1', sysdate, '-1', '-1', -1,sysdate, -1, sysdate,-1);

Line: 939

   INSERT INTO ddr_ws_job(job_id, status, SRC_SYS_IDNT,SRC_SYS_DT, CRTD_BY_DSR, LAST_UPDT_BY_DSR, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,     LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
   VALUES (l_job_id, ddr_webservices_constants.g_ret_sts_initialize,'-1', sysdate, '-1', '-1', -1,sysdate, -1, sysdate,-1);

Line: 988

      SELECT ddr_ws_job_seq.NEXTVAL
        INTO l_next_val
        FROM DUAL;

Line: 1017

         SELECT file_name FROM ddr_ws_job_file_dls WHERE job_id = job_id_in;

Line: 1029

         SELECT status,ERR_MESSAGE INTO l_job_status,l_job_error FROM ddr_ws_job WHERE job_id = x_job_id;