APPS.HR_QUESTIONNAIRE_API SQL Statements

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

Line: 151

procedure update_questionnaire
  (
   p_validate              	  in     boolean   default false
  ,p_questionnaire_template_id    in     number
  ,p_object_version_number        in out nocopy number
  ,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: 167

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

Line: 173

  savepoint update_questionnaire;

Line: 187

      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
      );

Line: 200

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

Line: 228

      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
      );

Line: 241

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

Line: 261

    rollback to update_questionnaire;

Line: 274

    rollback to update_questionnaire;

Line: 283

end update_questionnaire;

Line: 290

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: 306

     SELECT field_id, object_version_number from HR_QUEST_FIELDS where questionnaire_template_id = p_questionnaire_template_id;

Line: 309

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

Line: 315

  savepoint delete_questionnaire;

Line: 326

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

Line: 334

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

Line: 351

           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: 365

               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: 386

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

Line: 395

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

Line: 416

    rollback to delete_questionnaire;

Line: 427

    rollback to delete_questionnaire;

Line: 435

end delete_questionnaire;