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_PERSONAL_SCORECARD_SWI SQL Statements

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

Line: 209


PROCEDURE delete_scorecard
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_scorecard_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: 223


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

Line: 229


  savepoint delete_scorecard_swi;

Line: 249


  hr_personal_scorecard_api.delete_scorecard
    (p_validate                     => l_validate
    ,p_scorecard_id                 => p_scorecard_id
    ,p_object_version_number        => p_object_version_number
    ,p_created_by_plan_warning      => l_created_by_plan_warning
    );

Line: 282


    rollback to delete_scorecard_swi;

Line: 296


    rollback to delete_scorecard_swi;

Line: 306


end delete_scorecard;

Line: 310


PROCEDURE update_scorecard
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_scorecard_id                 in     number
  ,p_object_version_number        in out nocopy number
  ,p_scorecard_name               in     varchar2  default hr_api.g_varchar2
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_plan_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_attribute21                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute22                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute23                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute24                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute25                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute26                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute27                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute28                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute29                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute30                  in     varchar2  default hr_api.g_varchar2
  ,p_status_code                  in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
	,p_obj_setting_deadline			in 	 date     default hr_api.g_date
	,p_supervisor_id				in	 number   default hr_api.g_number
	,p_supervisor_assignment_id		in	 number   default hr_api.g_number
	,p_eligibility_status			in	 varchar2 default hr_api.g_varchar2
	,p_eligibility_eval_date		in	 date     default hr_api.g_date
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 367


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

Line: 373


  savepoint update_scorecard_swi;

Line: 394


  hr_personal_scorecard_api.update_scorecard
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_scorecard_id                 => p_scorecard_id
    ,p_object_version_number        => p_object_version_number
    ,p_scorecard_name               => p_scorecard_name
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_plan_id                      => p_plan_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_attribute21                  => p_attribute21
    ,p_attribute22                  => p_attribute22
    ,p_attribute23                  => p_attribute23
    ,p_attribute24                  => p_attribute24
    ,p_attribute25                  => p_attribute25
    ,p_attribute26                  => p_attribute26
    ,p_attribute27                  => p_attribute27
    ,p_attribute28                  => p_attribute28
    ,p_attribute29                  => p_attribute29
    ,p_attribute30                  => p_attribute30
    ,p_status_code                  => p_status_code
    ,p_duplicate_name_warning       => l_duplicate_name_warning
	,p_obj_setting_deadline			=> p_obj_setting_deadline
	,p_supervisor_id				=> p_supervisor_id
	,p_supervisor_assignment_id		=> p_supervisor_assignment_id
	,p_eligibility_status			=> p_eligibility_status
	,p_eligibility_eval_date		=> p_eligibility_eval_date
    );

Line: 469


    rollback to update_scorecard_swi;

Line: 484


    rollback to update_scorecard_swi;

Line: 495


end update_scorecard;

Line: 499


PROCEDURE update_scorecard_status
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_scorecard_id                 in     number
  ,p_object_version_number        in out nocopy number
  ,p_status_code                  in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 515


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

Line: 521


  savepoint update_scorecard_status_swi;

Line: 542


  hr_personal_scorecard_api.update_scorecard_status
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_scorecard_id                 => p_scorecard_id
    ,p_object_version_number        => p_object_version_number
    ,p_status_code                  => p_status_code
    );

Line: 571


    rollback to update_scorecard_status_swi;

Line: 586


    rollback to update_scorecard_status_swi;

Line: 597


end update_scorecard_status;