APPS.HR_ASSESSMENTS_API SQL Statements

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

Line: 268

procedure update_assessment
 (
  p_assessment_id                in number,
  p_assessment_type_id           in number           default hr_api.g_number,
  p_assessment_group_id          in number           default hr_api.g_number,
  p_assessment_period_start_date in date             default hr_api.g_date,
  p_assessment_period_end_date   in date             default hr_api.g_date,
  p_assessment_date              in date             default hr_api.g_date,
  p_comments                     in varchar2         default hr_api.g_varchar2,
  p_total_score                  in number           default hr_api.g_number,
  p_status                       in varchar2         default hr_api.g_varchar2,
  --
  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_object_version_number        in out nocopy number,
  p_validate                     in boolean      default false,
  p_effective_date               in date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc               	varchar2(72) := g_package||'update_assessment';

Line: 318

  savepoint update_assess;

Line: 324

	hr_assessments_bk2.update_assessment_b	(
         p_assessment_id                => p_assessment_id,
         p_assessment_type_id           => p_assessment_type_id,
         p_assessment_group_id          => p_assessment_group_id,
         p_assessment_period_start_date => p_assessment_period_start_date,
         p_assessment_period_end_date   => p_assessment_period_end_date,
         p_assessment_date              => p_assessment_date,
         p_comments                     => p_comments,
         p_total_score                  => p_total_score,
         p_status                       => p_status,
         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_object_version_number        => p_object_version_number,
         p_effective_date               => p_effective_date
		);

Line: 361

				(p_module_name	=> 'update_assessment',
				 p_hook_type	=> 'BP'
				);

Line: 419

	hr_assessments_bk2.update_assessment_a	(
         p_assessment_id                => p_assessment_id,
         p_assessment_type_id           => p_assessment_type_id,
         p_assessment_group_id          => p_assessment_group_id,
         p_assessment_period_start_date => p_assessment_period_start_date,
         p_assessment_period_end_date   => p_assessment_period_end_date,
         p_assessment_date              => p_assessment_date,
         p_comments                     => p_comments,
         p_total_score                  => p_total_score,
         p_status                       => p_status,
         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_object_version_number        => l_object_version_number,
         p_effective_date               => p_effective_date
		);

Line: 456

				(p_module_name	=> 'update_assessment',
				 p_hook_type	=> 'AP'
				);

Line: 481

    ROLLBACK TO update_assess;

Line: 498

    ROLLBACK TO update_assess;

Line: 505

end update_assessment;

Line: 512

procedure delete_assessment
(p_validate                   in boolean default false,
 p_assessment_id 		      in number,
 p_object_version_number      in number
) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_assessment';

Line: 526

  savepoint delete_assess;

Line: 532

	hr_assessments_bk3.delete_assessment_b
		(
                p_assessment_id              => p_assessment_id
               ,p_object_version_number      => p_object_version_number
		);

Line: 540

				(p_module_name	=> 'delete_assessment',
				 p_hook_type	=> 'BP'
				);

Line: 567

	hr_assessments_bk3.delete_assessment_a	(
                p_assessment_id              => p_assessment_id
               ,p_object_version_number      => p_object_version_number
		);

Line: 574

				(p_module_name	=> 'delete_assessment',
				 p_hook_type	=> 'AP'
				);

Line: 594

    ROLLBACK TO delete_assess;

Line: 603

    ROLLBACK TO delete_assess;

Line: 609

end delete_assessment;