APPS.HR_QUEST_FIELDS_SWI SQL Statements

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

Line: 11

PROCEDURE insert_quest_fields
  (p_field_id                     in	 number
  ,p_questionnaire_template_id    in     number
  ,p_name                         in     varchar2
  ,p_type                         in     varchar2
  ,p_html_text                    in     varchar2
  ,p_sql_required_flag            in     varchar2
  ,p_sql_text                     in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        out    nocopy number
  ,p_effective_date               in     date
  ,p_validate			  in	 number default hr_api.g_false_num
  ,p_return_status                out	 nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 32

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

Line: 38

  savepoint insert_quest_fields;

Line: 61

  hr_quest_fields_api.insert_quest_fields
    (p_field_id                     => l_field_id
    ,p_questionnaire_template_id    => p_questionnaire_template_id
    ,p_name                         => p_name
    ,p_type                         => p_type
    ,p_html_text                    => p_html_text
    ,p_sql_required_flag            => p_sql_required_flag
    ,p_sql_text                     => p_sql_text
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    );

Line: 85

	rollback to insert_quest_fields;

Line: 98

    rollback to insert_quest_fields;

Line: 113

    rollback to insert_quest_fields;

Line: 124

end insert_quest_fields;

Line: 129

PROCEDURE update_quest_fields
  (p_field_id                     in     number
  ,p_sql_text                     in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_effective_date               in     date
  ,p_validate			  in	 number default hr_api.g_false_num
  ,p_return_status                out	 nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 145

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

Line: 151

  savepoint update_quest_fields;

Line: 172

  hr_quest_fields_api.update_quest_fields
    (p_field_id                     => p_field_id
    ,p_sql_text                     => p_sql_text
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    );

Line: 191

	rollback to update_quest_fields;

Line: 204

    rollback to update_quest_fields;

Line: 219

    rollback to update_quest_fields;

Line: 230

end update_quest_fields;

Line: 235

PROCEDURE delete_quest_fields
  (p_field_id                     in     number
  ,p_object_version_number        in     number
  ,p_validate			  in	 number default hr_api.g_false_num
  ,p_return_status                out	 nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 248

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

Line: 254

  savepoint delete_quest_fields;

Line: 274

  hr_quest_fields_api.delete_quest_fields
    (p_field_id                     => p_field_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 291

	rollback to delete_quest_fields;

Line: 304

    rollback to delete_quest_fields;

Line: 318

    rollback to delete_quest_fields;

Line: 328

end delete_quest_fields;

Line: 333

PROCEDURE delete_quest_fields
  (p_field_id                     in     number
  ,p_validate			  in	 number default hr_api.g_false_num
  ,p_return_status                out	 nocopy varchar2
  ) is

  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 346

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

Line: 348

  CURSOR delete_fields (fldId number) IS
	select field_id, object_version_number
	from   hr_quest_fields
	where field_id <= fldId;

Line: 358

  savepoint delete_fields;

Line: 362

  For t in delete_fields(p_field_id) Loop

	delete_quest_fields
	   (p_field_id                     =>     t.field_id
	   ,p_object_version_number        =>	 t.object_version_number
	   ,p_validate			   =>	 p_validate
	   ,p_return_status                =>	 p_return_status
	);

Line: 374

     rollback to delete_quest_fields;

Line: 386

    rollback to delete_fields;

Line: 397

end delete_quest_fields;