APPS.GHR_COMPLAINT_ADRS_API SQL Statements

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

Line: 163

procedure update_compl_adr
  (p_validate                     in     boolean
  ,p_effective_date               in     date
  ,p_compl_adr_id                 in     number
  ,p_complaint_id                 in     number
  ,p_stage                        in     varchar2
  ,p_start_date                   in     date
  ,p_end_date                     in     date
  ,p_adr_resource                 in     varchar2
  ,p_technique                    in     varchar2
  ,p_outcome                      in     varchar2
  ,p_adr_offered                  in     varchar2
  ,p_date_accepted                in     date
  ,p_object_version_number        in out nocopy number
   )

is
  l_proc                varchar2(72) := g_package||'update_compl_adr';

Line: 186

   savepoint update_compl_adr;

Line: 193

    ghr_complaint_adrs_bk_2.update_compl_adr_b
      (p_effective_date                 => trunc(p_effective_date)
      ,p_compl_adr_id                   => p_compl_adr_id
      ,p_complaint_id                   => p_complaint_id
      ,p_stage                          => p_stage
      ,p_start_date                     => p_start_date
      ,p_end_date                       => p_end_date
      ,p_adr_resource                   => p_adr_resource
      ,p_technique                      => p_technique
      ,p_outcome                        => p_outcome
      ,p_adr_offered                    => p_adr_offered
      ,p_date_accepted                  => p_date_accepted
      ,p_object_version_number          => l_object_version_number
      );

Line: 210

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

Line: 241

    ghr_complaint_adrs_bk_2.update_compl_adr_a
      (p_effective_date                => trunc(p_effective_date)
      ,p_complaint_id                  => p_complaint_id
      ,p_stage                         => p_stage
      ,p_start_date                    => p_start_date
      ,p_end_date                      => p_end_date
      ,p_adr_resource                  => p_adr_resource
      ,p_technique                     => p_technique
      ,p_outcome                       => p_outcome
      ,p_adr_offered                   => p_adr_offered
      ,p_date_accepted                 => p_date_accepted
      ,p_compl_adr_id                  => p_compl_adr_id
      ,p_object_version_number         => l_object_version_number
      );

Line: 258

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

Line: 280

    rollback to update_compl_adr;

Line: 292

    rollback to update_compl_adr;

Line: 297

end update_compl_adr;

Line: 303

procedure delete_compl_adr
  (p_validate                      in     boolean
  ,p_compl_adr_id                  in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_compl_adr';

Line: 318

  savepoint delete_compl_adr;

Line: 326

    ghr_complaint_adrs_bk_3.delete_compl_adr_b
      (p_compl_adr_id                  => p_compl_adr_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 333

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

Line: 350

    ghr_complaint_adrs_bk_3.delete_compl_adr_a
      (p_compl_adr_id                  => p_compl_adr_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 357

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

Line: 373

    ROLLBACK TO delete_compl_adr;

Line: 376

    ROLLBACK TO delete_compl_adr;

Line: 380

end delete_compl_adr;