APPS.PER_APT_DEL SQL Statements

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

Line: 45

Procedure delete_dml(p_rec in per_apt_shd.g_rec_type) is

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

Line: 54

  delete from per_appraisal_templates
  where appraisal_template_id = p_rec.appraisal_template_id;

Line: 66

End delete_dml;

Line: 100

Procedure pre_delete(p_rec in per_apt_shd.g_rec_type) is

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

Line: 108

End pre_delete;

Line: 142

Procedure post_delete(p_rec in per_apt_shd.g_rec_type) is

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

Line: 152

     per_apt_rkd.after_delete	(
       p_appraisal_template_id       => p_rec.appraisal_template_id                 ,
       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_show_participant_comments_o      => per_apt_shd.g_old_rec.show_participant_comments  -- 8651478 bug fix

    ,p_show_term_employee_o           => per_apt_shd.g_old_rec.show_term_employee  -- 6181267 bug fix
    ,p_show_term_contigent_o          => per_apt_shd.g_old_rec.show_term_contigent   -- 6181267 bug fix
    ,p_disp_term_emp_period_from_o    => per_apt_shd.g_old_rec.disp_term_emp_period_from   -- 6181267 bug fix
    ,p_show_future_term_employee_o         => per_apt_shd.g_old_rec.show_future_term_employee -- 6181267 bug fix

       );

Line: 221

End post_delete;

Line: 256

  per_apt_bus.delete_validate(p_rec);

Line: 260

  pre_delete(p_rec);

Line: 264

  delete_dml(p_rec);

Line: 268

  post_delete(p_rec);