APPS.PER_APT_UPD SQL Statements

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

Line: 48

Procedure update_dml(p_rec in out nocopy per_apt_shd.g_rec_type) is

  l_proc  varchar2(72) := g_package||'update_dml';

Line: 61

  update per_appraisal_templates
  set
  appraisal_template_id             = p_rec.appraisal_template_id,
  object_version_number             = p_rec.object_version_number,
  name                              = p_rec.name,
  description                       = p_rec.description,
  instructions                      = p_rec.instructions,
  date_from                         = p_rec.date_from,
  date_to                           = p_rec.date_to,
  assessment_type_id                = p_rec.assessment_type_id,
  rating_scale_id                   = p_rec.rating_scale_id,
  questionnaire_template_id         = p_rec.questionnaire_template_id,
  attribute_category                = p_rec.attribute_category,
  attribute1                        = p_rec.attribute1,
  attribute2                        = p_rec.attribute2,
  attribute3                        = p_rec.attribute3,
  attribute4                        = p_rec.attribute4,
  attribute5                        = p_rec.attribute5,
  attribute6                        = p_rec.attribute6,
  attribute7                        = p_rec.attribute7,
  attribute8                        = p_rec.attribute8,
  attribute9                        = p_rec.attribute9,
  attribute10                       = p_rec.attribute10,
  attribute11                       = p_rec.attribute11,
  attribute12                       = p_rec.attribute12,
  attribute13                       = p_rec.attribute13,
  attribute14                       = p_rec.attribute14,
  attribute15                       = p_rec.attribute15,
  attribute16                       = p_rec.attribute16,
  attribute17                       = p_rec.attribute17,
  attribute18                       = p_rec.attribute18,
  attribute19                       = p_rec.attribute19,
  attribute20                       = p_rec.attribute20,
  objective_asmnt_type_id         = p_rec.objective_asmnt_type_id,
  ma_quest_template_id            = p_rec.ma_quest_template_id,
  link_appr_to_learning_path      = p_rec.link_appr_to_learning_path,
  final_score_formula_id          = p_rec.final_score_formula_id,
  update_personal_comp_profile    = p_rec.update_personal_comp_profile,
  comp_profile_source_type        = p_rec.comp_profile_source_type,
  show_competency_ratings         = p_rec.show_competency_ratings,
  show_objective_ratings          = p_rec.show_objective_ratings,
  show_overall_ratings            = p_rec.show_overall_ratings,
  show_overall_comments           = p_rec.show_overall_comments,
  provide_overall_feedback        = p_rec.provide_overall_feedback,
  show_participant_details        = p_rec.show_participant_details,
  allow_add_participant           = p_rec.allow_add_participant,
  show_additional_details         = p_rec.show_additional_details,
  show_participant_names          = p_rec.show_participant_names,
  show_participant_ratings        = p_rec.show_participant_ratings,
  available_flag                  = p_rec.available_flag,
  show_questionnaire_info        = p_rec.show_questionnaire_info,
  ma_off_template_code			     = p_rec.ma_off_template_code,
  appraisee_off_template_code		  =	p_rec.appraisee_off_template_code,
  other_part_off_template_code	  =	p_rec.other_part_off_template_code,
  part_app_off_template_code	  	=	p_rec.part_app_off_template_code,
  part_rev_off_template_code		  = p_rec.part_rev_off_template_code
  where appraisal_template_id = p_rec.appraisal_template_id;

Line: 136

End update_dml;

Line: 170

Procedure pre_update(p_rec in per_apt_shd.g_rec_type) is

  l_proc  varchar2(72) := g_package||'pre_update';

Line: 178

End pre_update;

Line: 212

Procedure post_update(p_rec in per_apt_shd.g_rec_type) is

  l_proc  varchar2(72) := g_package||'post_update';

Line: 222

     per_apt_rku.after_update	(
       p_appraisal_template_id        => p_rec.appraisal_template_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_description                  => p_rec.description            ,
       p_instructions                 => p_rec.instructions           ,
       p_date_from                    => p_rec.date_from              ,
       p_date_to                      => p_rec.date_to                ,
       p_assessment_type_id           => p_rec.assessment_type_id        ,
       p_rating_scale_id              => p_rec.rating_scale_id           ,
       p_questionnaire_template_id    => p_rec.questionnaire_template_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_objective_asmnt_type_id      => p_rec.objective_asmnt_type_id,
       p_ma_quest_template_id      => p_rec.ma_quest_template_id,
       p_link_appr_to_learning_path      => p_rec.link_appr_to_learning_path,
       p_final_score_formula_id      => p_rec.final_score_formula_id,
       p_update_personal_comp_profile      => p_rec.update_personal_comp_profile,
       p_comp_profile_source_type      => p_rec.comp_profile_source_type,
       p_show_competency_ratings      => p_rec.show_competency_ratings,
       p_show_objective_ratings      => p_rec.show_objective_ratings,
       p_show_overall_ratings      => p_rec.show_overall_ratings,
       p_show_overall_comments      => p_rec.show_overall_comments,
       p_provide_overall_feedback      => p_rec.provide_overall_feedback,
       p_show_participant_details      => p_rec.show_participant_details,
       p_allow_add_participant      => p_rec.allow_add_participant,
       p_show_additional_details      => p_rec.show_additional_details,
       p_show_participant_names      => p_rec.show_participant_names,
       p_show_participant_ratings      => p_rec.show_participant_ratings,
       p_available_flag      => p_rec.available_flag,
       p_show_questionnaire_info      => p_rec.show_questionnaire_info,
       p_ma_off_template_code			  => p_rec.ma_off_template_code,
       p_appraisee_off_template_code	  => p_rec.appraisee_off_template_code,
       p_other_part_off_template_code	  => p_rec.other_part_off_template_code,
       p_part_app_off_template_code	  => p_rec.part_app_off_template_code,
       p_part_rev_off_template_code	  => p_rec.part_rev_off_template_code,
       p_business_group_id_o         => per_apt_shd.g_old_rec.business_group_id     ,
       p_object_version_number_o     => per_apt_shd.g_old_rec.object_version_number ,
       p_name_o                      => per_apt_shd.g_old_rec.name          ,
       p_description_o               => per_apt_shd.g_old_rec.description   ,
       p_instructions_o              => per_apt_shd.g_old_rec.instructions  ,
       p_date_from_o                 => per_apt_shd.g_old_rec.date_from     ,
       p_date_to_o                   => per_apt_shd.g_old_rec.date_to       ,
       p_assessment_type_id_o        => per_apt_shd.g_old_rec.assessment_type_id        ,
       p_rating_scale_id_o           => per_apt_shd.g_old_rec.rating_scale_id           ,
       p_questionnaire_template_id_o => per_apt_shd.g_old_rec.questionnaire_template_id ,
       p_attribute_category_o        => per_apt_shd.g_old_rec.attribute_category        ,
       p_attribute1_o                => per_apt_shd.g_old_rec.attribute1   ,
       p_attribute2_o                => per_apt_shd.g_old_rec.attribute2   ,
       p_attribute3_o                => per_apt_shd.g_old_rec.attribute3   ,
       p_attribute4_o                => per_apt_shd.g_old_rec.attribute4   ,
       p_attribute5_o                => per_apt_shd.g_old_rec.attribute5   ,
       p_attribute6_o                => per_apt_shd.g_old_rec.attribute6   ,
       p_attribute7_o                => per_apt_shd.g_old_rec.attribute7   ,
       p_attribute8_o                => per_apt_shd.g_old_rec.attribute8   ,
       p_attribute9_o                => per_apt_shd.g_old_rec.attribute9   ,
       p_attribute10_o               => per_apt_shd.g_old_rec.attribute10   ,
       p_attribute11_o               => per_apt_shd.g_old_rec.attribute11   ,
       p_attribute12_o               => per_apt_shd.g_old_rec.attribute12   ,
       p_attribute13_o               => per_apt_shd.g_old_rec.attribute13   ,
       p_attribute14_o               => per_apt_shd.g_old_rec.attribute14   ,
       p_attribute15_o               => per_apt_shd.g_old_rec.attribute15   ,
       p_attribute16_o               => per_apt_shd.g_old_rec.attribute16   ,
       p_attribute17_o               => per_apt_shd.g_old_rec.attribute17   ,
       p_attribute18_o               => per_apt_shd.g_old_rec.attribute18   ,
       p_attribute19_o               => per_apt_shd.g_old_rec.attribute19   ,
       p_attribute20_o               => per_apt_shd.g_old_rec.attribute20 ,
       p_objective_asmnt_type_id_o      => per_apt_shd.g_old_rec.objective_asmnt_type_id,
       p_ma_quest_template_id_o      => per_apt_shd.g_old_rec.ma_quest_template_id,
       p_link_appr_to_learning_path_o      => per_apt_shd.g_old_rec.link_appr_to_learning_path,
       p_final_score_formula_id_o      => per_apt_shd.g_old_rec.final_score_formula_id,
       p_update_personal_comp_profi_o      => per_apt_shd.g_old_rec.update_personal_comp_profile,
       p_comp_profile_source_type_o      => per_apt_shd.g_old_rec.comp_profile_source_type,
       p_show_competency_ratings_o      => per_apt_shd.g_old_rec.show_competency_ratings,
       p_show_objective_ratings_o      => per_apt_shd.g_old_rec.show_objective_ratings,
       p_show_overall_ratings_o      => per_apt_shd.g_old_rec.show_overall_ratings,
       p_show_overall_comments_o      => per_apt_shd.g_old_rec.show_overall_comments,
       p_provide_overall_feedback_o      => per_apt_shd.g_old_rec.provide_overall_feedback,
       p_show_participant_details_o      => per_apt_shd.g_old_rec.show_participant_details,
       p_allow_add_participant_o      => per_apt_shd.g_old_rec.allow_add_participant,
       p_show_additional_details_o      => per_apt_shd.g_old_rec.show_additional_details,
       p_show_participant_names_o      => per_apt_shd.g_old_rec.show_participant_names,
       p_show_participant_ratings_o      => per_apt_shd.g_old_rec.show_participant_ratings,
       p_available_flag_o      => per_apt_shd.g_old_rec.available_flag,
       p_show_questionnaire_info_o => per_apt_shd.g_old_rec.show_questionnaire_info,
       p_ma_off_template_cd_o			  => per_apt_shd.g_old_rec.ma_off_template_code,
       p_appraisee_off_template_cd_o	  => per_apt_shd.g_old_rec.appraisee_off_template_code,
       p_other_part_off_template_cd_o	  => per_apt_shd.g_old_rec.other_part_off_template_code,
       p_part_app_off_template_cd_o	  	  => per_apt_shd.g_old_rec.part_app_off_template_code,
       p_part_rev_off_template_cd_o	  	  => per_apt_shd.g_old_rec.part_rev_off_template_code
       );

Line: 344

End post_update;

Line: 539

  If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
    p_rec.update_personal_comp_profile :=
    per_apt_shd.g_old_rec.update_personal_comp_profile;

Line: 659

  per_apt_bus.update_validate(p_rec,p_effective_date);

Line: 663

  pre_update(p_rec);

Line: 667

  update_dml(p_rec);

Line: 671

  post_update(p_rec);

Line: 729

  p_update_personal_comp_profile in     varchar2  default hr_api.g_varchar2,
  p_comp_profile_source_type     in     varchar2  default hr_api.g_varchar2,
  p_show_competency_ratings      in     varchar2  default hr_api.g_varchar2,
  p_show_objective_ratings       in     varchar2  default hr_api.g_varchar2,
  p_show_overall_ratings         in     varchar2  default hr_api.g_varchar2,
  p_show_overall_comments        in     varchar2  default hr_api.g_varchar2,
  p_provide_overall_feedback     in     varchar2  default hr_api.g_varchar2,
  p_show_participant_details     in     varchar2  default hr_api.g_varchar2,
  p_allow_add_participant        in     varchar2  default hr_api.g_varchar2,
  p_show_additional_details      in     varchar2  default hr_api.g_varchar2,
  p_show_participant_names       in     varchar2  default hr_api.g_varchar2,
  p_show_participant_ratings     in     varchar2  default hr_api.g_varchar2,
  p_available_flag               in     varchar2  default hr_api.g_varchar2,
  p_show_questionnaire_info     in     varchar2  default hr_api.g_varchar2,
  p_effective_date		 in date
  ,p_ma_off_template_code			   in varchar2 	  default hr_api.g_varchar2
  ,p_appraisee_off_template_code	in varchar2		  default hr_api.g_varchar2
  ,p_other_part_off_template_code	 in varchar2		  default hr_api.g_varchar2
  ,p_part_app_off_template_code	  in varchar2		  default hr_api.g_varchar2
  ,p_part_rev_off_template_code	  in varchar2		  default hr_api.g_varchar2,
  p_validate                     in boolean      default false
  ) is

  l_rec	  per_apt_shd.g_rec_type;

Line: 800

  p_update_personal_comp_profile,
  p_comp_profile_source_type,
  p_show_competency_ratings,
  p_show_objective_ratings,
  p_show_overall_ratings,
  p_show_overall_comments,
  p_provide_overall_feedback,
  p_show_participant_details,
  p_allow_add_participant,
  p_show_additional_details,
  p_show_participant_names,
  p_show_participant_ratings,
  p_available_flag,
  p_show_questionnaire_info,
  p_ma_off_template_code,
  p_appraisee_off_template_code,
  p_other_part_off_template_code,
  p_part_app_off_template_code,
  p_part_rev_off_template_code
  );