APPS.PER_APT_SHD SQL Statements

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

Line: 83

    select
		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_rev_off_template_code,
	  part_app_off_template_code
    from	per_appraisal_templates
    where	appraisal_template_id = p_appraisal_template_id;

Line: 208

    select 	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_rev_off_template_code,
	  part_app_off_template_code
    from	per_appraisal_templates
    where	appraisal_template_id = p_appraisal_template_id
    for	update nowait;

Line: 351

  ,p_update_personal_comp_profile   in varchar2
  ,p_comp_profile_source_type       in varchar2
  ,p_show_competency_ratings        in varchar2
  ,p_show_objective_ratings         in varchar2
  ,p_show_overall_ratings           in varchar2
  ,p_show_overall_comments          in varchar2
  ,p_provide_overall_feedback       in varchar2
  ,p_show_participant_details       in varchar2
  ,p_allow_add_participant          in varchar2
  ,p_show_additional_details        in varchar2
  ,p_show_participant_names         in varchar2
  ,p_show_participant_ratings       in varchar2
  ,p_available_flag                 in varchar2
  ,p_show_questionnaire_info        in varchar2
  ,p_ma_off_template_code			      in varchar2
  ,p_apraisee_off_template_code	 	  in varchar2
  ,p_other_part_off_template_code  	in varchar2
  ,p_part_app_off_template_code	  	in varchar2
  ,p_part_rev_off_template_code 	  in varchar2
	)
	Return g_rec_type is

  l_rec	  g_rec_type;

Line: 418

  l_rec.update_personal_comp_profile     := p_update_personal_comp_profile;