APPS.HR_ABM_INS SQL Statements

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

Line: 53

Procedure insert_dml(p_rec in out hr_abm_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65

  insert into hr_api_batch_message_lines
  (	line_id,
	batch_run_number,
	api_name,
	status,
	error_number,
	error_message,
	extended_error_message,
	source_row_information
  )
  Values
  (	p_rec.line_id,
	p_rec.batch_run_number,
	p_rec.api_name,
	p_rec.status,
	p_rec.error_number,
	p_rec.error_message,
	p_rec.extended_error_message,
	p_rec.source_row_information
  );

Line: 108

End insert_dml;

Line: 147

Procedure pre_insert(p_rec  in out hr_abm_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 151

  Cursor C_Sel1 is select hr_api_batch_message_lines_s.nextval from sys.dual;

Line: 164

End pre_insert;

Line: 191

  hr_abm_bus.insert_validate(p_rec);

Line: 195

  pre_insert(p_rec);

Line: 199

  insert_dml(p_rec);