APPS.HR_ASSESSMENT_GROUPS_API SQL Statements

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

Line: 223

procedure update_assessment_group
 (p_assessment_group_id           in number,
  p_name                         in varchar2         default hr_api.g_varchar2,
  p_comments                     in varchar2         default hr_api.g_varchar2,
  p_object_version_number        in out 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_validate                     in boolean      default false,
  p_effective_date               in date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc               	varchar2(72) := g_package||'update_assessment_group';

Line: 264

  savepoint update_assess_group;

Line: 270

	hr_assessment_groups_bk2.update_assessment_group_b	(
           p_assessment_group_id          =>     p_assessment_group_id,
           p_name                         =>     p_name,
           p_comments                     =>     p_comments,
           p_object_version_number        =>     p_object_version_number,
           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_effective_date               =>     p_effective_date		);

Line: 300

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

Line: 350

	hr_assessment_groups_bk2.update_assessment_group_a	(
           p_assessment_group_id          =>     p_assessment_group_id,
           p_name                         =>     p_name,
           p_comments                     =>     p_comments,
           p_object_version_number        =>     l_object_version_number,
           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_effective_date               =>     p_effective_date		);

Line: 380

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

Line: 405

    ROLLBACK TO update_assess_group;

Line: 420

    ROLLBACK TO update_assess_group;

Line: 427

end update_assessment_group;

Line: 434

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

Line: 448

  savepoint delete_assess_group;

Line: 454

	hr_assessment_groups_bk3.delete_assessment_group_b
		(
               p_assessment_group_id      =>  p_assessment_group_id
              ,p_object_version_number    =>  p_object_version_number
		);

Line: 462

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

Line: 489

	hr_assessment_groups_bk3.delete_assessment_group_a	(
               p_assessment_group_id      =>  p_assessment_group_id
              ,p_object_version_number    =>  p_object_version_number
		);

Line: 496

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

Line: 516

    ROLLBACK TO delete_assess_group;

Line: 525

    ROLLBACK TO delete_assess_group;

Line: 531

end delete_assessment_group;