APPS.BEN_REPORTING_API SQL Statements

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

Line: 125

procedure update_reporting
  (p_validate                       in  boolean   default false
  ,p_reporting_id                   in  number
  ,p_benefit_action_id              in  number    default hr_api.g_number
  ,p_thread_id                      in  number    default hr_api.g_number
  ,p_sequence                       in  number    default hr_api.g_number
  ,p_text                           in  varchar2  default hr_api.g_varchar2
  ,p_rep_typ_cd                     in  varchar2  default hr_api.g_varchar2
  ,p_error_message_code             in  varchar2  default hr_api.g_varchar2
  ,p_national_identifier            in  varchar2  default hr_api.g_varchar2
  ,p_related_person_ler_id          in  number    default hr_api.g_number
  ,p_temporal_ler_id                in  number    default hr_api.g_number
  ,p_ler_id                         in  number    default hr_api.g_number
  ,p_person_id                      in  number    default hr_api.g_number
  ,p_pgm_id                         in  number    default hr_api.g_number
  ,p_pl_id                          in  number    default hr_api.g_number
  ,p_related_person_id              in  number    default hr_api.g_number
  ,p_oipl_id                        in  number    default hr_api.g_number
  ,p_pl_typ_id                      in  number    default hr_api.g_number
  ,p_actl_prem_id                   in  number    default hr_api.g_number
  ,p_val                            in  number    default hr_api.g_number
  ,p_mo_num                         in  number    default hr_api.g_number
  ,p_yr_num                         in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_reporting';

Line: 161

  savepoint update_reporting;

Line: 214

    ROLLBACK TO update_reporting;

Line: 228

    ROLLBACK TO update_reporting;

Line: 231

end update_reporting;

Line: 236

procedure delete_reporting
  (p_validate                       in  boolean  default false
  ,p_reporting_id                   in  number
  ,p_object_version_number          in out nocopy number) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_reporting';

Line: 252

  savepoint delete_reporting;

Line: 282

    ROLLBACK TO delete_reporting;

Line: 294

    ROLLBACK TO delete_reporting;

Line: 297

end delete_reporting;