APPS.IRC_LOCATION_PREFERENCES_SWI SQL Statements

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

Line: 123

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

Line: 136

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

Line: 142

  savepoint delete_location_preference_swi;

Line: 162

  irc_location_preferences_api.delete_location_preference
    (p_validate                     => l_validate
    ,p_location_pref_id             => p_location_pref_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 189

    rollback to delete_location_preference_swi;

Line: 203

    rollback to delete_location_preference_swi;

Line: 213

end delete_location_preference;

Line: 395

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

Line: 408

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

Line: 414

  savepoint delete_vac_rec_area_value_swi;

Line: 434

  irc_location_preferences_api.delete_vac_rec_area_value
    (p_validate                     => l_validate
    ,p_vac_rec_area_id              => p_vac_rec_area_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 461

    rollback to delete_vac_rec_area_value_swi;

Line: 475

    rollback to delete_vac_rec_area_value_swi;

Line: 485

end delete_vac_rec_area_value;

Line: 490

PROCEDURE update_vac_rec_area_value
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_vacancy_id                   in     number    default hr_api.g_number
  ,p_hierarchy_version_id         in     number    default hr_api.g_number
  ,p_hierarchy_name               in     varchar2  default hr_api.g_varchar2
  ,p_vac_rec_area_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 507

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

Line: 514

  savepoint update_vac_rec_area_value_swi;

Line: 533

    irc_location_preferences_api.update_vac_rec_area_value
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_vacancy_id                   => p_vacancy_id
    ,p_hierarchy_version_id         => p_hierarchy_version_id
    ,p_hierarchy_name               => p_hierarchy_name
    ,p_vac_rec_area_id              => p_vac_rec_area_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 565

    rollback to update_vac_rec_area_value_swi;

Line: 580

    rollback to update_vac_rec_area_value_swi;

Line: 591

end update_vac_rec_area_value;

Line: 666

    update_vac_rec_area_value(
     p_validate                     =>  p_validate
    ,p_effective_date               =>  l_effective_date
    ,p_vacancy_id                   =>  hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
    ,p_hierarchy_version_id         =>  hr_transaction_swi.getNumberValue(l_CommitNode,'HierarchyVersionId',NULL)
    ,p_hierarchy_name               =>  hr_transaction_swi.getVarchar2Value(l_CommitNode,'HierarchyName',NULL)
    ,p_vac_rec_area_id              =>  l_vac_rec_area_id
    ,p_object_version_number        =>  l_object_version_number
    ,p_return_status                =>  l_return_status
    ) ;

Line: 682

     delete_vac_rec_area_value(
      p_validate                 =>  p_validate
     ,p_object_version_number    =>  l_object_version_number
     ,p_vac_rec_area_id          =>  l_vac_rec_area_id
     ,p_return_status            =>  l_return_status
     );

Line: 802

     delete_location_preference(
      p_validate                 =>  p_validate
     ,p_object_version_number    =>  l_object_version_number
     ,p_location_pref_id         =>  l_location_pref_id
     ,p_return_status            =>  l_return_status
     );