APPS.PSP_REPORT_TEMPLATE_SWI SQL Statements

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

Line: 34

  ,p_selection_match_level        in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 103

    ,p_selection_match_level        => p_selection_match_level
    );

Line: 159

PROCEDURE update_report_template
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_template_id                  in     number
  ,p_template_name                in     varchar2
  ,p_business_group_id            in     number
  ,p_set_of_books_id              in     number
  ,p_report_type                  in     varchar2
  ,p_period_frequency_id          in     number
  ,p_report_template_code         in     varchar2
  ,p_display_all_emp_distrib_flag in     varchar2
  ,p_manual_entry_override_flag   in     varchar2
  ,p_approval_type                in     varchar2
  ,p_sup_levels                   in     number
  ,p_preview_effort_report_flag   in     varchar2
  ,p_notification_reminder        in     number
  ,p_sprcd_tolerance_amt          in     number
  ,p_sprcd_tolerance_percent      in     number
  ,p_description                  in     varchar2
  ,p_egislation_code              in     varchar2
  ,p_object_version_number        in out nocopy number
  ,p_return_status_from_api          out nocopy number
  ,p_custom_approval_code         in     varchar2
  ,p_hundred_pcent_eff_at_per_asg in     varchar2
  ,p_selection_match_level        in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 195

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

Line: 201

  savepoint update_report_template_swi;

Line: 225

  psp_report_template_api.update_report_template
    (p_validate                     => l_validate
    ,p_template_id                  => p_template_id
    ,p_template_name                => p_template_name
    ,p_business_group_id            => p_business_group_id
    ,p_set_of_books_id              => p_set_of_books_id
    ,p_report_type                  => p_report_type
    ,p_period_frequency_id          => p_period_frequency_id
    ,p_report_template_code         => p_report_template_code
    ,p_display_all_emp_distrib_flag => p_display_all_emp_distrib_flag
    ,p_manual_entry_override_flag   => p_manual_entry_override_flag
    ,p_approval_type                => p_approval_type
    ,p_sup_levels                   => p_sup_levels
    ,p_preview_effort_report_flag   => p_preview_effort_report_flag
    ,p_notification_reminder        => p_notification_reminder
    ,p_sprcd_tolerance_amt          => p_sprcd_tolerance_amt
    ,p_sprcd_tolerance_percent      => p_sprcd_tolerance_percent
    ,p_description                  => p_description
    ,p_egislation_code              => p_egislation_code
    ,p_object_version_number        => p_object_version_number
    ,p_warning                      => l_warning
    ,p_return_status                => l_return_status
    ,p_custom_approval_code         => p_custom_approval_code
    ,p_hundred_pcent_eff_at_per_asg => p_hundred_pcent_eff_at_per_asg
    ,p_selection_match_level        => p_selection_match_level
    );

Line: 273

    rollback to update_report_template_swi;

Line: 289

    rollback to update_report_template_swi;

Line: 301

end update_report_template;

Line: 305

PROCEDURE delete_report_template
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_template_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: 320

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

Line: 326

  savepoint delete_report_template_swi;

Line: 347

  psp_report_template_api.delete_report_template
    (p_validate                     => l_validate
    ,p_template_id                  => p_template_id
    ,p_object_version_number        => p_object_version_number
    ,p_warning                      => p_warning
    );

Line: 375

    rollback to delete_report_template_swi;

Line: 390

    rollback to delete_report_template_swi;

Line: 401

end delete_report_template;