APPS.PER_AST_INS SQL Statements

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

Line: 71

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

Line: 82

  insert into per_assessment_types
  (	assessment_type_id,
	name,
	business_group_id,
	description,
	rating_scale_id,
	weighting_scale_id,
	rating_scale_comment,
	weighting_scale_comment,
	assessment_classification,
	display_assessment_comments,
	date_from,
        date_to,
	comments,
	instructions,
        weighting_classification,
        line_score_formula,
        total_score_formula,
	object_version_number,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
    type,
    line_score_formula_id,
    default_job_competencies,
    available_flag
  )
  Values
  (	p_rec.assessment_type_id,
	p_rec.name,
	p_rec.business_group_id,
	p_rec.description,
	p_rec.rating_scale_id,
	p_rec.weighting_scale_id,
	p_rec.rating_scale_comment,
	p_rec.weighting_scale_comment,
	p_rec.assessment_classification,
	p_rec.display_assessment_comments,
	p_rec.date_from,
        p_rec.date_to,
	p_rec.comments,
	p_rec.instructions,
	p_rec.weighting_classification,
        p_rec.line_score_formula,
        p_rec.total_score_formula,
	p_rec.object_version_number,
	p_rec.attribute_category,
	p_rec.attribute1,
	p_rec.attribute2,
	p_rec.attribute3,
	p_rec.attribute4,
	p_rec.attribute5,
	p_rec.attribute6,
	p_rec.attribute7,
	p_rec.attribute8,
	p_rec.attribute9,
	p_rec.attribute10,
	p_rec.attribute11,
	p_rec.attribute12,
	p_rec.attribute13,
	p_rec.attribute14,
	p_rec.attribute15,
	p_rec.attribute16,
	p_rec.attribute17,
	p_rec.attribute18,
	p_rec.attribute19,
	p_rec.attribute20,
    p_rec.type,
    p_rec.line_score_formula_id,
    p_rec.default_job_competencies,
    p_rec.available_flag
  );

Line: 180

    hr_utility.trace('A check constraint has been violated insert-dml');

Line: 188

    hr_utility.trace('Parent integrity has been violated insert-dml');

Line: 195

    hr_utility.trace('Unique integrity has been violated insert-dml');

Line: 202

    hr_utility.trace('Something else has been violated insert-dml');

Line: 204

End insert_dml;

Line: 243

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

Line: 248

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

Line: 250

   select null from per_assessment_types
        where assessment_type_id  = per_ast_ins.g_assessment_type_id_i;

Line: 289

End pre_insert;

Line: 324

Procedure post_insert(p_rec in per_ast_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 334

     per_ast_rki.after_insert	(
      p_assessment_type_id          => p_rec.assessment_type_id          ,
      p_business_group_id           => p_rec.business_group_id           ,
      p_object_version_number       => p_rec.object_version_number       ,
      p_name                        => p_rec.name                        ,
      p_date_to                     => p_rec.date_to                     ,
      p_date_from                   => p_rec.date_from                   ,
      p_assessment_classification   => p_rec.assessment_classification   ,
      p_display_assessment_comments => p_rec.display_assessment_comments ,
      p_description                 => p_rec.description                 ,
      p_rating_scale_comment        => p_rec.rating_scale_comment        ,
      p_weighting_scale_comment     => p_rec.weighting_scale_comment     ,
      p_comments                    => p_rec.comments                    ,
      p_instructions                => p_rec.instructions                ,
      p_line_score_formula          => p_rec.line_score_formula          ,
      p_total_score_formula         => p_rec.total_score_formula         ,
      p_weighting_classification    => p_rec.weighting_classification    ,
      p_rating_scale_id             => p_rec.rating_scale_id             ,
      p_weighting_scale_id          => p_rec.weighting_scale_id          ,
      p_attribute_category          => p_rec.attribute_category          ,
      p_attribute1                  => p_rec.attribute1   ,
      p_attribute2                  => p_rec.attribute2   ,
      p_attribute3                  => p_rec.attribute3   ,
      p_attribute4                  => p_rec.attribute4   ,
      p_attribute5                  => p_rec.attribute5   ,
      p_attribute6                  => p_rec.attribute6   ,
      p_attribute7                  => p_rec.attribute7   ,
      p_attribute8                  => p_rec.attribute8   ,
      p_attribute9                  => p_rec.attribute9   ,
      p_attribute10                 => p_rec.attribute10  ,
      p_attribute11                 => p_rec.attribute11  ,
      p_attribute12                 => p_rec.attribute12  ,
      p_attribute13                 => p_rec.attribute13  ,
      p_attribute14                 => p_rec.attribute14  ,
      p_attribute15                 => p_rec.attribute15  ,
      p_attribute16                 => p_rec.attribute16  ,
      p_attribute17                 => p_rec.attribute17  ,
      p_attribute18                 => p_rec.attribute18  ,
      p_attribute19                 => p_rec.attribute19  ,
      p_attribute20                 => p_rec.attribute20  ,
      p_type                        => p_rec.type,
      p_line_score_formula_id       => p_rec.line_score_formula_id,
      p_default_job_competencies    => p_rec.default_job_competencies,
      p_available_flag              => p_rec.available_flag
      );

Line: 389

End post_insert;

Line: 416

  hr_utility.set_location(' insert_validate called :'||l_proc, 11);

Line: 417

  per_ast_bus.insert_validate(p_rec
  			     ,p_effective_date);

Line: 420

  hr_utility.set_location(' insert_validate finished :'||l_proc, 11);

Line: 426

  hr_utility.trace('about to do pre_insert');

Line: 427

  pre_insert(p_rec);

Line: 431

  insert_dml(p_rec);

Line: 435

  post_insert(p_rec);