APPS.PSP_TEMPLATE_DETAILS_SWI SQL Statements

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

Line: 144

PROCEDURE update_template_details
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_template_id                  in     number
  ,p_criteria_lookup_type         in     varchar2
  ,p_criteria_lookup_code         in     varchar2
  ,p_include_exclude_flag         in     varchar2
  ,p_criteria_value1              in     varchar2
  ,p_criteria_value2              in     varchar2
  ,p_criteria_value3              in     varchar2
  ,p_template_detail_id           in out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_return_status_from_api          out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 169

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

Line: 175

  savepoint update_template_details_swi;

Line: 200

  psp_template_details_api.update_template_details
    (p_validate                     => l_validate
    ,p_template_id                  => p_template_id
    ,p_criteria_lookup_type         => p_criteria_lookup_type
    ,p_criteria_lookup_code         => p_criteria_lookup_code
    ,p_include_exclude_flag         => p_include_exclude_flag
    ,p_criteria_value1              => p_criteria_value1
    ,p_criteria_value2              => p_criteria_value2
    ,p_criteria_value3              => p_criteria_value3
    ,p_template_detail_id           => p_template_detail_id
    ,p_object_version_number        => p_object_version_number
    ,p_warning                      => l_warning
    ,p_return_status                => l_return_status
    );

Line: 245

    rollback to update_template_details_swi;

Line: 262

    rollback to update_template_details_swi;

Line: 275

end update_template_details;

Line: 279

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

Line: 294

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

Line: 300

  savepoint delete_template_details_swi;

Line: 321

  psp_template_details_api.delete_template_details
    (p_validate                     => l_validate
    ,p_template_detail_id           => p_template_detail_id
    ,p_object_version_number        => p_object_version_number
    ,p_warning                      => p_warning
    );

Line: 349

    rollback to delete_template_details_swi;

Line: 364

    rollback to delete_template_details_swi;

Line: 375

end delete_template_details;