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     varchar2
     ,p_sql_text                       in     varchar2 default null
     ,p_field_id                          out nocopy number
     ,p_object_version_number             out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 28

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

Line: 34

  savepoint insert_quest_fields;

Line: 49

     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                   		    =>p_html_text
       ,p_sql_text                    		    =>p_sql_text
      );

Line: 62

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

Line: 92

      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                   		    =>p_html_text
             ,p_sql_text                    		    =>p_sql_text
             ,p_field_id                    		    =>p_field_id
             ,p_object_version_number       		    =>p_object_version_number
      );

Line: 107

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

Line: 129

    rollback to insert_quest_fields;

Line: 143

    rollback to insert_quest_fields;

Line: 153

end insert_quest_fields;

Line: 161

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     varchar2  default hr_api.g_varchar2
  ,p_sql_text                     in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 178

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

Line: 184

  savepoint update_quest_fields;

Line: 199

     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                 	    =>    p_html_text
      ,p_sql_text                  	    =>    p_sql_text
      );

Line: 214

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

Line: 238

      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                 	    =>    p_html_text
      ,p_sql_text                  	    =>    p_sql_text
      );

Line: 253

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

Line: 275

    rollback to update_quest_fields;

Line: 288

    rollback to update_quest_fields;

Line: 298

end update_quest_fields;

Line: 306

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

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

Line: 326

  savepoint delete_quest_fields;

Line: 340

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

Line: 348

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

Line: 366

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

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

Line: 393

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

Line: 415

    rollback to delete_quest_fields;

Line: 427

    rollback to delete_quest_fields;

Line: 436

end delete_quest_fields;