APPS.IRC_SAVED_SEARCH_CRITERIA_API SQL Statements

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

Line: 21

	select NVL(bginfo.ORG_INFORMATION11,'N')
	from HR_ORGANIZATION_INFORMATION bginfo ,per_all_vacancies vac
	where bginfo.ORG_INFORMATION_CONTEXT = 'BG Recruitment'
	and bginfo.organization_id = vac.business_group_id
	and vac.vacancy_id = p_vacancy_id;

Line: 137

procedure update_search_criteria
  (p_validate                      in     boolean  default false
  ,p_vacancy_id                     in     number
  ,p_saved_search_criteria_id           in out nocopy   number
  ,p_object_version_number         in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  -- out variables
  l_saved_search_criteria_id		irc_saved_search_criteria.saved_search_criteria_id%TYPE;

Line: 149

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

Line: 156

  savepoint update_search_criteria;

Line: 172

    irc_saved_search_criteria_bk2.update_search_criteria_b
      (p_vacancy_id              => p_vacancy_id
      ,p_saved_search_criteria_id    => l_saved_search_criteria_id
      ,p_object_version_number  => l_object_version_number
      );

Line: 180

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

Line: 202

    irc_saved_search_criteria_bk2.update_search_criteria_a
      (p_vacancy_id              => p_vacancy_id
      ,p_saved_search_criteria_id	=> l_saved_search_criteria_id
      ,p_object_version_number	=> l_object_version_number
      );

Line: 210

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

Line: 233

    rollback to update_search_criteria;

Line: 247

    rollback to update_search_criteria;

Line: 257

end update_search_criteria;

Line: 264

procedure delete_search_criteria
  (p_validate				in     boolean  default false
   ,p_vacancy_id			in     number
   ,p_saved_search_criteria_id          in     number
   ,p_object_version_number		in     number
    ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_search_criteria';

Line: 279

  savepoint delete_search_criteria;

Line: 286

    irc_saved_search_criteria_bk3.delete_search_criteria_b
      (p_vacancy_id		       => p_vacancy_id
      ,p_saved_search_criteria_id      => p_saved_search_criteria_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 294

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

Line: 309

    irc_saved_search_criteria_bk3.delete_search_criteria_a
      (p_vacancy_id		       => p_vacancy_id
      ,p_saved_search_criteria_id      => p_saved_search_criteria_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 317

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

Line: 335

    rollback to delete_search_criteria;

Line: 342

    rollback to delete_search_criteria;

Line: 346

end delete_search_criteria;