APPS.HR_QUESTIONNAIRE_API SQL Statements

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

Line: 155

procedure update_questionnaire
  (
   p_validate              	  in     boolean   default false
  ,p_questionnaire_template_id    in     number
  ,p_object_version_number        in out nocopy number
  ,p_quest_type_code              in varchar2
  ,p_effective_date               in     date
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_available_flag               in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_text                         in     CLOB
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 172

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

Line: 178

  savepoint update_questionnaire;

Line: 192

      hr_questionnaire_bk2.update_questionnaire_b
      (      p_effective_date               => l_effective_date
	    ,p_questionnaire_template_id    => p_questionnaire_template_id
	    ,p_object_version_number        => p_object_version_number
	    ,p_name                         => p_name
	    ,p_available_flag               => p_available_flag
	    ,p_business_group_id            => p_business_group_id
  	    ,p_text                         => NULL
  ,p_quest_type_code      =>p_quest_type_code
      );

Line: 206

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

Line: 235

      hr_questionnaire_bk2.update_questionnaire_a
      (      p_effective_date               => l_effective_date
	    ,p_questionnaire_template_id    => p_questionnaire_template_id
	    ,p_object_version_number        => p_object_version_number
	    ,p_name                         => p_name
	    ,p_available_flag               => p_available_flag
	    ,p_business_group_id            => p_business_group_id
  	    ,p_text                         => NULL
  ,p_quest_type_code =>p_quest_type_code
      );

Line: 249

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

Line: 269

    rollback to update_questionnaire;

Line: 282

    rollback to update_questionnaire;

Line: 291

end update_questionnaire;

Line: 298

procedure delete_questionnaire
 (
   p_validate                             in     boolean   default false
  ,p_questionnaire_template_id            in     number
  ,p_object_version_number                in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  Cursor c_hr_que_ans is

     SELECT questionnaire_answer_id  /*, object_version_number */ from HR_QUEST_ANSWERS where questionnaire_template_id = p_questionnaire_template_id;

Line: 314

     SELECT field_id, object_version_number from HR_QUEST_FIELDS where questionnaire_template_id = p_questionnaire_template_id;

Line: 317

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

Line: 323

  savepoint delete_questionnaire;

Line: 334

    hr_questionnaire_bk3.delete_questionnaire_b
      (
           p_questionnaire_template_id           => p_questionnaire_template_id
  	  ,p_object_version_number               => p_object_version_number
      );

Line: 342

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

Line: 359

           hr_quest_answer_api.delete_quest_answer
             	(
             	 p_validate => false -- as per documentaion always should pass false when one BP calls another BP
             	,p_questionnaire_answer_id  => hr_que_ans_rec.questionnaire_answer_id
             	--,p_object_version_number    => hr_que_ans_rec.object_version_number
             	);

Line: 373

               hr_quest_fields_api.delete_quest_fields
		(
		 p_validate => false -- as per documentaion always should pass false when one BP calls another BP
		,p_field_id  => hr_que_flds_rec.field_id
		,p_object_version_number    => hr_que_flds_rec.object_version_number
		);

Line: 394

     hr_questionnaire_bk3.delete_questionnaire_a
     (
           p_questionnaire_template_id           => p_questionnaire_template_id
  	  ,p_object_version_number               => p_object_version_number
     );

Line: 403

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

Line: 424

    rollback to delete_questionnaire;

Line: 435

    rollback to delete_questionnaire;

Line: 443

end delete_questionnaire;