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.HR_APPRAISAL_TEMPLATES_SWI SQL Statements

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

Line: 49


  ,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_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_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 143


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

Line: 217


PROCEDURE delete_appraisal_template
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_appraisal_template_id        in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 230


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

Line: 236


  savepoint delete_appraisal_template_swi;

Line: 256


  hr_appraisal_templates_api.delete_appraisal_template
    (p_validate                     => l_validate
    ,p_appraisal_template_id        => p_appraisal_template_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 283


    rollback to delete_appraisal_template_swi;

Line: 297


    rollback to delete_appraisal_template_swi;

Line: 307


end delete_appraisal_template;

Line: 311


PROCEDURE update_appraisal_template
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_appraisal_template_id        in     number
  ,p_object_version_number        in out nocopy number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_instructions                 in     varchar2  default hr_api.g_varchar2
  ,p_date_from                    in     date      default hr_api.g_date
  ,p_date_to                      in     date      default hr_api.g_date
  ,p_assessment_type_id           in     number    default hr_api.g_number
  ,p_rating_scale_id              in     number    default hr_api.g_number
  ,p_questionnaire_template_id    in     number    default hr_api.g_number
  ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
  ,p_objective_asmnt_type_id      in     number    default hr_api.g_number
  ,p_ma_quest_template_id         in     number    default hr_api.g_number
  ,p_link_appr_to_learning_path   in     varchar2  default hr_api.g_varchar2
  ,p_final_score_formula_id       in     number    default hr_api.g_number
  ,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_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_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 378


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

Line: 384


  savepoint update_appraisal_template_swi;

Line: 405


  hr_appraisal_templates_api.update_appraisal_template
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_appraisal_template_id        => p_appraisal_template_id
    ,p_object_version_number        => p_object_version_number
    ,p_name                         => p_name
    ,p_description                  => p_description
    ,p_instructions                 => p_instructions
    ,p_date_from                    => p_date_from
    ,p_date_to                      => p_date_to
    ,p_assessment_type_id           => p_assessment_type_id
    ,p_rating_scale_id              => p_rating_scale_id
    ,p_questionnaire_template_id    => p_questionnaire_template_id
    ,p_attribute_category           => p_attribute_category
    ,p_attribute1                   => p_attribute1
    ,p_attribute2                   => p_attribute2
    ,p_attribute3                   => p_attribute3
    ,p_attribute4                   => p_attribute4
    ,p_attribute5                   => p_attribute5
    ,p_attribute6                   => p_attribute6
    ,p_attribute7                   => p_attribute7
    ,p_attribute8                   => p_attribute8
    ,p_attribute9                   => p_attribute9
    ,p_attribute10                  => p_attribute10
    ,p_attribute11                  => p_attribute11
    ,p_attribute12                  => p_attribute12
    ,p_attribute13                  => p_attribute13
    ,p_attribute14                  => p_attribute14
    ,p_attribute15                  => p_attribute15
    ,p_attribute16                  => p_attribute16
    ,p_attribute17                  => p_attribute17
    ,p_attribute18                  => p_attribute18
    ,p_attribute19                  => p_attribute19
    ,p_attribute20                  => p_attribute20
    ,p_objective_asmnt_type_id      => p_objective_asmnt_type_id
    ,p_ma_quest_template_id         => p_ma_quest_template_id
    ,p_link_appr_to_learning_path   => p_link_appr_to_learning_path
    ,p_final_score_formula_id       => p_final_score_formula_id
    ,p_update_personal_comp_profile => p_update_personal_comp_profile
    ,p_comp_profile_source_type     => p_comp_profile_source_type
    ,p_show_competency_ratings      => p_show_competency_ratings
    ,p_show_objective_ratings       => p_show_objective_ratings
    ,p_show_overall_ratings         => p_show_overall_ratings
    ,p_show_overall_comments        => p_show_overall_comments
    ,p_provide_overall_feedback     => p_provide_overall_feedback
    ,p_show_participant_details     => p_show_participant_details
    ,p_allow_add_participant        => p_allow_add_participant
    ,p_show_additional_details      => p_show_additional_details
    ,p_show_participant_names       => p_show_participant_names
    ,p_show_participant_ratings     => p_show_participant_ratings
    ,p_available_flag               => p_available_flag
    ,p_show_questionnaire_info      => p_show_questionnaire_info
    ,p_ma_off_template_code			=> p_ma_off_template_code
  	,p_appraisee_off_template_code	=> p_appraisee_off_template_code
  	,p_other_part_off_template_code	=> p_other_part_off_template_code
  	,p_part_app_off_template_code  	=> p_part_app_off_template_code
  	,p_part_rev_off_template_code	=> p_part_rev_off_template_code
    );

Line: 485


    rollback to update_appraisal_template_swi;

Line: 500


    rollback to update_appraisal_template_swi;

Line: 511


end update_appraisal_template;