APPS.HR_QUEST_FIELDS_API SQL Statements

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

Line: 12

procedure insert_quest_fields
  (   p_validate                       in     boolean  default false
     ,p_effective_date                 in     date
     ,p_questionnaire_template_id      in     number
     ,p_name                           in     varchar2
     ,p_type                           in     varchar2
     ,p_sql_required_flag              in     varchar2
     ,p_html_text                      in     CLOB
     ,p_sql_text                       in     varchar2 default null
     ,p_field_id                          out nocopy number
     ,p_validation_type                in     varchar2
     ,p_validation_detail              in     varchar2
     ,p_display_sequence               in     number
     ,p_object_version_number             out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 31

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

Line: 37

  savepoint insert_quest_fields;

Line: 52

     hr_quest_fields_bk1.insert_quest_fields_b
      (
        p_effective_date              		    =>l_effective_date
       ,p_questionnaire_template_id   		    =>p_questionnaire_template_id
       ,p_name                        		    =>p_name
       ,p_type                        		    =>p_type
       ,p_sql_required_flag           		    =>p_sql_required_flag
       ,p_html_text                   		    =>NULL
       ,p_sql_text                    		    =>p_sql_text
       ,p_validation_type                           =>p_validation_type
       ,p_validation_detail                         =>p_validation_detail
       ,p_display_sequence                          =>p_display_sequence
      );

Line: 68

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

Line: 101

      hr_quest_fields_bk1.insert_quest_fields_a
      (
      	      p_effective_date              		    =>l_effective_date
             ,p_questionnaire_template_id   		    =>p_questionnaire_template_id
             ,p_name                        		    =>p_name
             ,p_type                        		    =>p_type
             ,p_sql_required_flag           		    =>p_sql_required_flag
             ,p_html_text                   		    =>NULL
             ,p_sql_text                    		    =>p_sql_text
             ,p_field_id                    		    =>p_field_id
             ,p_object_version_number       		    =>p_object_version_number
	     ,p_validation_type             		    => p_validation_type
             ,p_validation_detail              		    => p_validation_detail
             ,p_display_sequence                	    => p_display_sequence
      );

Line: 119

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

Line: 141

    rollback to insert_quest_fields;

Line: 155

    rollback to insert_quest_fields;

Line: 165

end insert_quest_fields;

Line: 173

procedure update_quest_fields
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_field_id                     in     number
  ,p_object_version_number        in out nocopy number
  ,p_questionnaire_template_id    in     number    default hr_api.g_number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_type                         in     varchar2  default hr_api.g_varchar2
  ,p_sql_required_flag            in     varchar2  default hr_api.g_varchar2
  ,p_html_text                    in     CLOB      default hr_api.g_varchar2
  ,p_sql_text                     in     varchar2  default hr_api.g_varchar2
  ,p_validation_type              in     varchar2
  ,p_validation_detail            in     varchar2
  ,p_display_sequence             in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 193

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

Line: 199

  savepoint update_quest_fields;

Line: 214

     hr_quest_fields_bk2.update_quest_fields_b
      (
       p_effective_date            	    =>    l_effective_date
      ,p_field_id                  	    =>    p_field_id
      ,p_object_version_number     	    =>    p_object_version_number
      ,p_questionnaire_template_id 	    =>    p_questionnaire_template_id
      ,p_name                      	    =>    p_name
      ,p_type                      	    =>    p_type
      ,p_sql_required_flag         	    =>    p_sql_required_flag
      ,p_html_text                 	    =>    NULL
      ,p_sql_text                  	    =>    p_sql_text
      ,p_validation_type                    =>    p_validation_type
      ,p_validation_detail                  =>    p_validation_detail
      ,p_display_sequence                   =>    p_display_sequence
      );

Line: 232

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

Line: 264

      hr_quest_fields_bk2.update_quest_fields_a
      (
       p_effective_date            	    =>    l_effective_date
      ,p_field_id                  	    =>    p_field_id
      ,p_object_version_number     	    =>    p_object_version_number
      ,p_questionnaire_template_id 	    =>    p_questionnaire_template_id
      ,p_name                      	    =>    p_name
      ,p_type                      	    =>    p_type
      ,p_sql_required_flag         	    =>    p_sql_required_flag
      ,p_html_text                 	    =>    NULL
      ,p_sql_text                  	    =>    p_sql_text
      ,p_validation_type                    =>    p_validation_type
      ,p_validation_detail                  =>    p_validation_detail
      ,p_display_sequence                   =>    p_display_sequence
      );

Line: 282

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

Line: 304

    rollback to update_quest_fields;

Line: 317

    rollback to update_quest_fields;

Line: 327

end update_quest_fields;

Line: 335

procedure delete_quest_fields
  (   p_validate                       in     boolean  default false
     ,p_field_id                       in     number
     ,p_object_version_number          in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  Cursor c_hr_que_ans_vals is

   SELECT quest_answer_val_id, object_version_number from HR_QUEST_ANSWER_VALUES where field_id = p_field_id;

Line: 348

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

Line: 355

  savepoint delete_quest_fields;

Line: 369

     hr_quest_fields_bk3.delete_quest_fields_b
      (
          p_field_id                    		    => p_field_id
         ,p_object_version_number       		    => p_object_version_number
      );

Line: 377

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

Line: 395

          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_que_ans_vals_rec.quest_answer_val_id
            	,p_object_version_number => hr_que_ans_vals_rec.object_version_number
            	);

Line: 414

      hr_quest_fields_bk3.delete_quest_fields_a
      (
      	      p_field_id                    		    =>p_field_id
             ,p_object_version_number       		    =>p_object_version_number
      );

Line: 422

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

Line: 444

    rollback to delete_quest_fields;

Line: 456

    rollback to delete_quest_fields;

Line: 465

end delete_quest_fields;