APPS.HR_PARTICIPANTS_API SQL Statements

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

Line: 266

procedure update_participant
 (p_validate                     in boolean	default false,
  p_effective_date               in date,
  p_participant_id               in number,
  p_object_version_number        in out nocopy number,
  p_questionnaire_template_id    in number           default hr_api.g_number,
  p_participation_status         in varchar2         default hr_api.g_varchar2,
  p_participation_type           in varchar2         default hr_api.g_varchar2,
  p_last_notified_date           in date             default hr_api.g_date,
  p_date_completed               in date             default hr_api.g_date,
  p_comments                     in varchar2         default hr_api.g_varchar2,
  p_person_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_participant_usage_status	   in varchar2		     default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 313

  savepoint update_participant;

Line: 319

	hr_participants_bk2.update_participant_b	(
         p_participant_id               =>     p_participant_id,
         p_object_version_number        =>     p_object_version_number,
         p_questionnaire_template_id    =>     p_questionnaire_template_id,
         p_effective_date               =>     p_effective_date,
         p_participation_status         =>     p_participation_status,
         p_participation_type           =>     p_participation_type,
         p_last_notified_date           =>     p_last_notified_date,
         p_date_completed               =>     p_date_completed,
         p_comments                     =>     p_comments,
         p_person_id                    =>     p_person_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_participant_usage_status		  =>	   p_participant_usage_status
	);

Line: 356

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

Line: 413

	hr_participants_bk2.update_participant_a	(
         p_participant_id               =>     p_participant_id,
         p_object_version_number        =>     l_object_version_number,
         p_questionnaire_template_id    =>     p_questionnaire_template_id,
         p_effective_date               =>     p_effective_date,
         p_participation_status         =>     p_participation_status,
         p_participation_type           =>     p_participation_type,
         p_last_notified_date           =>     p_last_notified_date,
         p_date_completed               =>     p_date_completed,
         p_comments                     =>     p_comments,
         p_person_id                    =>     p_person_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_participant_usage_status		  =>	   p_participant_usage_status
	);

Line: 450

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

Line: 475

    ROLLBACK TO update_participant;

Line: 490

    ROLLBACK TO update_participant;

Line: 501

end update_participant;

Line: 508

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

Line: 522

    select questionnaire_answer_id
    from hr_quest_answers
    where hr_quest_answers.type = 'PARTICIPANT' and
    hr_quest_answers.type_object_id = p_participant_id;

Line: 535

  savepoint delete_participant;

Line: 541

	hr_participants_bk3.delete_participant_b
		(
		p_participant_id         =>   p_participant_id,
		p_object_version_number  =>   p_object_version_number
		);

Line: 549

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

Line: 564

    hr_quest_perform_web.delete_quest_answer(p_questionnaire_answer_id => l_quest_ans_id);

Line: 586

	hr_participants_bk3.delete_participant_a	(
		p_participant_id         =>    p_participant_id,
		p_object_version_number  =>    p_object_version_number
		);

Line: 593

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

Line: 613

    ROLLBACK TO delete_participant;

Line: 622

    ROLLBACK TO delete_participant;

Line: 628

end delete_participant;