APPS.HR_DU_MASTER SQL Statements

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

Line: 29

  SELECT module_id
    FROM hr_du_modules
    WHERE module_name = 'Spreadsheet-to-lines';

Line: 34

  SELECT hr_du_uploads_s.currval
    FROM dual;

Line: 51

hr_du_utility.message('INFO','performing insert', 15);

Line: 53

INSERT INTO hr_du_uploads (
  UPLOAD_ID,
  MODULE_ID,
  BATCH_ID,
  SOURCE,
  STATUS,
  DATA_INPUT_STATUS,
  DATA_REFERENCE_COMPLETE,
  BUSINESS_GROUP_NAME,
  DO_REQUEST_ID,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN,
  CREATED_BY,
  CREATION_DATE
  )
  SELECT
  hr_du_uploads_s.nextval,
  l_module_id,
  null,
  r_upload_data.filename,
  'NS',
  'NS',
  null,
  null,
  FND_GLOBAL.CONC_REQUEST_ID,
  sysdate,
  1,
  1,
  1,
  sysdate
  FROM sys.dual;

Line: 105

  hr_du_utility.update_uploads(p_new_status => 'E',
                               p_id => r_upload_data.upload_id);

Line: 172

hr_du_di_insert.rollback(r_upload_data.upload_id);

Line: 176

hr_du_di_insert.ordered_sequence(r_upload_data.upload_id);

Line: 191

hr_du_dp_pc_conversion.INSERT_API_MODULE_IDS(r_upload_data.upload_id);

Line: 232

  hr_du_utility.update_uploads(p_new_status => 'E',p_id => r_upload_data.upload_id);

Line: 239

  hr_du_utility.update_uploads(p_new_status => 'E',p_id => r_upload_data.upload_id);