APPS.HR_QUEST_ANSWER_API SQL Statements

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

Line: 145

procedure update_quest_answer
  (
    p_validate                     in     boolean  default false
   ,p_effective_date               in     date
   ,p_questionnaire_answer_id      in     number
   ,p_questionnaire_template_id    in     number    default hr_api.g_number
   ,p_type                         in     varchar2  default hr_api.g_varchar2
   ,p_type_object_id               in     number    default hr_api.g_number
   ,p_business_group_id            in     number    default hr_api.g_number

  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 161

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

Line: 167

  savepoint update_quest_answer;

Line: 181

    hr_quest_answer_bk2.update_quest_answer_b
      (
       p_effective_date            	=>		 l_effective_date
      ,p_questionnaire_answer_id   	=>		 p_questionnaire_answer_id
      ,p_questionnaire_template_id      =>		 p_questionnaire_template_id
      ,p_type                           =>		 p_type
      ,p_type_object_id            	=>		 p_type_object_id
      ,p_business_group_id         	=>		 p_business_group_id
      );

Line: 193

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

Line: 220

    hr_quest_answer_bk2.update_quest_answer_a
      (
   	  p_effective_date            	=>		 l_effective_date
   	 ,p_questionnaire_answer_id   	=>		 p_questionnaire_answer_id
   	 ,p_questionnaire_template_id   =>		 p_questionnaire_template_id
   	 ,p_type                        =>		 p_type
   	 ,p_type_object_id            	=>		 p_type_object_id
      	 ,p_business_group_id         	=>		 p_business_group_id
      );

Line: 232

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

Line: 255

    rollback to update_quest_answer;

Line: 267

    rollback to update_quest_answer;

Line: 275

end update_quest_answer;

Line: 282

procedure delete_quest_answer
  (
   p_validate                      in     boolean  default false
  ,p_questionnaire_answer_id       in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  Cursor c_hr_quest_answer_vals is

     SELECT quest_answer_val_id, object_version_number from HR_QUEST_ANSWER_VALUES where questionnaire_answer_id = p_questionnaire_answer_id;

Line: 297

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

Line: 304

  savepoint delete_quest_answer;

Line: 317

    hr_quest_answer_bk3.delete_quest_answer_b
      (
        p_questionnaire_answer_id        => p_questionnaire_answer_id
      );

Line: 324

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

Line: 341

                hr_quest_ans_val_api.delete_quest_answer_val
          	(
          	 p_validate => false -- as per documentaion always should pass false when one BP calls another BP
          	,p_quest_answer_val_id  => hr_quest_answer_vals_rec.quest_answer_val_id
          	,p_object_version_number => hr_quest_answer_vals_rec.object_version_number
          	);

Line: 360

    hr_quest_answer_bk3.delete_quest_answer_a
      (
        p_questionnaire_answer_id        => p_questionnaire_answer_id
      );

Line: 367

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

Line: 390

    rollback to delete_quest_answer;

Line: 402

    rollback to delete_quest_answer;

Line: 410

end delete_quest_answer;