APPS.HR_QUESTIONNAIRE_SWI SQL Statements

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

Line: 9

Procedure delete_questionnaire_fields
  (
	p_questionnaire_template_id in number
  );

Line: 18

PROCEDURE update_questionnaire_recs(p_effective_date IN DATE
				   ,p_quest_tbl IN OUT NOCOPY HR_QUEST_TABLE
			           ,p_error_message OUT NOCOPY LONG
				   ,p_status OUT NOCOPY VARCHAR2) IS
BEGIN
	FOR I in 1 .. p_quest_tbl.count LOOP
            IF (not p_quest_tbl(I).questionnaire_template_id = -1) THEN
		BEGIN
			hr_qsn_upd.upd(p_quest_tbl(I).questionnaire_template_id
				      ,p_quest_tbl(I).available_flag
				      ,p_quest_tbl(I).object_version_number
				      ,p_effective_date);

Line: 36

END update_questionnaire_recs;

Line: 157

Procedure update_questionnaire
  (p_questionnaire_template_id in number
  ,p_object_version_number     in out nocopy number
  ,p_text		       in CLOB
  ,p_available_flag            in varchar2 default hr_api.g_varchar2
  ,p_business_group_id         in number   default hr_api.g_number
  ,p_effective_date            in date     default hr_api.g_date
  ,p_validate                  in number   default hr_api.g_false_num
  ,p_return_status             out nocopy  varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 175

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

Line: 181

	  SELECT text, business_group_id
	  FROM  HR_QUESTIONNAIRES
	  WHERE questionnaire_template_id = p_questionnaire_template_id;

Line: 190

  savepoint update_questionnaire_swi;

Line: 214

  hr_questionnaire_api.update_questionnaire
   (p_questionnaire_template_id => p_questionnaire_template_id
   ,p_text			=> p_text
   ,p_available_flag		=> p_available_flag
   ,p_business_group_id		=> p_business_group_id
   ,p_object_version_number	=> p_object_version_number
   ,p_effective_date		=> p_effective_date
   );

Line: 227

      delete_questionnaire_fields  (
		p_questionnaire_template_id => p_questionnaire_template_id
      );

Line: 234

	rollback to update_questionnaire_swi;

Line: 243

    rollback to update_questionnaire_swi;

Line: 252

    rollback to update_questionnaire_swi;

Line: 263

end update_questionnaire;

Line: 270

Procedure delete_questionnaire
  (p_questionnaire_template_id in number
  ,p_object_version_number     in number
  ,p_validate                  in number default hr_api.g_false_num
  ,p_return_status             out nocopy varchar2
  ) is

  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 284

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

Line: 292

  savepoint delete_questionnaire_swi;

Line: 319

  	hr_questionnaire_api.delete_questionnaire
  	(
	 p_questionnaire_template_id=>p_questionnaire_template_id
	,p_object_version_number=>p_object_version_number
	,p_validate=>l_validate
  	);

Line: 339

	rollback to delete_questionnaire_swi;

Line: 352

    rollback to delete_questionnaire_swi;

Line: 366

    rollback to delete_questionnaire_swi;

Line: 376

end delete_questionnaire;

Line: 378

Procedure delete_questionnaire_fields
  (
	p_questionnaire_template_id in number
  )
  IS

 Cursor C_Quest_Fields  IS
  select field_id, object_version_number
  from hr_quest_fields
  where questionnaire_template_id = p_questionnaire_template_id;

Line: 400

end delete_questionnaire_fields;