eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APT_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_apt_shd.g_rec_type) is

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

Line: 82


  insert into per_appraisal_templates
  (	appraisal_template_id,
	business_group_id,
	object_version_number,
	name,
	description,
	instructions,
	date_from,
	date_to,
	assessment_type_id,
	rating_scale_id,
	questionnaire_template_id,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
	objective_asmnt_type_id,
        ma_quest_template_id,
        link_appr_to_learning_path,
        final_score_formula_id,
        update_personal_comp_profile,
        comp_profile_source_type,
        show_competency_ratings,
        show_objective_ratings,
        show_overall_ratings,
        show_overall_comments,
        provide_overall_feedback,
        show_participant_details,
        allow_add_participant,
        show_additional_details,
        show_participant_names,
        show_participant_ratings,
        available_flag,
	show_questionnaire_info,
  ma_off_template_code,
	appraisee_off_template_code,
	other_part_off_template_code,
	part_app_off_template_code,
	part_rev_off_template_code,
                          show_participant_comments -- 8651478 bug fix
,show_term_employee
,show_term_contigent
,disp_term_emp_period_from
,show_future_term_employee

  )
  Values
  (	p_rec.appraisal_template_id,
	p_rec.business_group_id,
	p_rec.object_version_number,
	p_rec.name,
	p_rec.description,
	p_rec.instructions,
	p_rec.date_from,
	p_rec.date_to,
	p_rec.assessment_type_id,
	p_rec.rating_scale_id,
	p_rec.questionnaire_template_id,
	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.objective_asmnt_type_id,
        p_rec.ma_quest_template_id,
        p_rec.link_appr_to_learning_path,
        p_rec.final_score_formula_id,
        p_rec.update_personal_comp_profile,
        p_rec.comp_profile_source_type,
        p_rec.show_competency_ratings,
        p_rec.show_objective_ratings,
        p_rec.show_overall_ratings,
        p_rec.show_overall_comments,
        p_rec.provide_overall_feedback,
        p_rec.show_participant_details,
        p_rec.allow_add_participant,
        p_rec.show_additional_details,
        p_rec.show_participant_names,
        p_rec.show_participant_ratings,
        p_rec.available_flag,
	p_rec.show_questionnaire_info,
  p_rec.ma_off_template_code,
	p_rec.appraisee_off_template_code,
	p_rec.other_part_off_template_code,
	p_rec.part_app_off_template_code,
	p_rec.part_rev_off_template_code,
                         p_rec.show_participant_comments  -- 8651478 bug fix
,p_rec.show_term_employee
,p_rec.show_term_contigent
,p_rec.disp_term_emp_period_from
,p_rec.show_future_term_employee

  );

Line: 225


End insert_dml;

Line: 264


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

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

Line: 269


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

Line: 272


   select null from per_appraisal_templates
        where appraisal_template_id  = per_apt_ins.g_appraisal_template_id_i;

Line: 305


End pre_insert;

Line: 339


Procedure post_insert(p_rec in per_apt_shd.g_rec_type) is

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

Line: 349


     per_apt_rki.after_insert	(
       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_show_participant_comments     => p_rec.show_participant_comments -- 8651478 bug fix

    ,p_show_term_employee           => p_rec.show_term_employee  -- 6181267 bug fix
    ,p_show_term_contigent          => p_rec.show_term_contigent   -- 6181267 bug fix
    ,p_disp_term_emp_period_from    => p_rec.disp_term_emp_period_from   -- 6181267 bug fix
    ,p_show_future_term_employee         => p_rec.show_future_term_employee -- 6181267 bug fix

      );

Line: 423


End post_insert;

Line: 451


  per_apt_bus.insert_validate(p_rec,p_effective_date);

Line: 455


  pre_insert(p_rec);

Line: 459


  insert_dml(p_rec);

Line: 463


  post_insert(p_rec);

Line: 522


  p_update_personal_comp_profile   in     varchar2 default null,
  p_comp_profile_source_type       in     varchar2 default null,
  p_show_competency_ratings        in     varchar2 default null,
  p_show_objective_ratings         in     varchar2 default null,
  p_show_overall_ratings           in     varchar2 default null,
  p_show_overall_comments          in     varchar2 default null,
  p_provide_overall_feedback       in     varchar2 default null,
  p_show_participant_details       in     varchar2 default null,
  p_allow_add_participant          in     varchar2 default null,
  p_show_additional_details        in     varchar2 default null,
  p_show_participant_names         in     varchar2 default null,
  p_show_participant_ratings       in     varchar2 default null,
  p_available_flag                 in     varchar2 default null,
  p_show_questionnaire_info       in     varchar2 default null,
  p_effective_date		 in date
  ,p_ma_off_template_code		      in varchar2	  default null
  ,p_appraisee_off_template_code	in varchar2	  default null
  ,p_other_part_off_template_code in varchar2	  default null
  ,p_part_app_off_template_code	  in varchar2	  default null
  ,p_part_rev_off_template_code	  in varchar2	  default null,
  p_validate                     in boolean   default false ,
  p_show_participant_comments     in varchar2            default null  -- 8651478 bug fix
  ,p_show_term_employee            in varchar2            default null  -- 6181267 bug fix
  ,p_show_term_contigent           in varchar2            default null  -- 6181267 bug fix
  ,p_disp_term_emp_period_from     in     number            default null  -- 6181267 bug fix
  ,p_show_future_term_employee          in varchar2            default null  -- 6181267 bug fix

  ) is

  l_rec	  per_apt_shd.g_rec_type;

Line: 599


  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,
  p_show_participant_comments    -- 8651478 bug fix
    ,p_show_term_employee        -- 6181267 bug fix
    ,p_show_term_contigent         -- 6181267 bug fix
    ,p_disp_term_emp_period_from    -- 6181267 bug fix
    ,p_show_future_term_employee        -- 6181267 bug fix
  );