APPS.PQP_GDS_API SQL Statements

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

Line: 166

procedure update_duration_summary
 (p_validate                          IN  BOOLEAN DEFAULT FALSE
 ,p_gap_duration_summary_id      IN  NUMBER
 ,p_date_start                        IN  DATE
 ,p_date_end                          IN  DATE
 ,p_assignment_id                     IN  NUMBER
 ,p_gap_absence_plan_id               IN  NUMBER
 ,p_duration_in_days                  IN  NUMBER
 ,p_duration_in_hours                 IN  NUMBER
 ,p_summary_type                      IN  VARCHAR2
 ,p_gap_level                         IN  VARCHAR2
 ,p_object_version_number          IN OUT NOCOPY NUMBER
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number  number;

Line: 185

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

Line: 191

  savepoint update_duration_summary;

Line: 208

    pqp_gds_bk2.update_duration_summary_b
      (p_date_start                        =>  l_date_start
      ,p_gap_duration_summary_id      =>  p_gap_duration_summary_id
      ,p_date_end                          =>  l_date_end
      ,p_assignment_id                     =>  p_assignment_id
      ,p_gap_absence_plan_id               =>  p_gap_absence_plan_id
      ,p_duration_in_days                  =>  p_duration_in_days
      ,p_duration_in_hours                 =>  p_duration_in_hours
      ,p_summary_type                      =>  p_summary_type
      ,p_gap_level                         =>  p_gap_level
      ,p_object_version_number             =>  l_object_version_number
     );

Line: 223

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

Line: 253

      pqp_gds_bk2.update_duration_summary_a
      (p_date_start                        =>  l_date_start
      ,p_gap_duration_summary_id      =>  p_gap_duration_summary_id
      ,p_date_end                          =>  l_date_end
      ,p_assignment_id                     =>  p_assignment_id
      ,p_gap_absence_plan_id               =>  p_gap_absence_plan_id
      ,p_duration_in_days                  =>  p_duration_in_days
      ,p_duration_in_hours                 =>  p_duration_in_hours
      ,p_summary_type                      =>  p_summary_type
      ,p_gap_level                         =>  p_gap_level
      ,p_object_version_number             =>  l_object_version_number
     );

Line: 268

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

Line: 290

    rollback to update_duration_summary;

Line: 302

    rollback to update_duration_summary;

Line: 310

end update_duration_summary;

Line: 317

procedure delete_duration_summary
  (p_validate                          IN  BOOLEAN DEFAULT FALSE
  ,p_gap_duration_summary_id     IN  NUMBER
  ,p_object_version_number             IN  NUMBER
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number  number;

Line: 326

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

Line: 332

  savepoint delete_duration_summary;

Line: 342

    pqp_gds_bk3.delete_duration_summary_b
      (p_gap_duration_summary_id   =>     p_gap_duration_summary_id
      ,p_object_version_number          =>     p_object_version_number
      );

Line: 349

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

Line: 370

    pqp_gds_bk3.delete_duration_summary_a
      (p_gap_duration_summary_id   =>     p_gap_duration_summary_id
      ,p_object_version_number          =>     p_object_version_number
      );

Line: 378

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

Line: 400

    rollback to delete_duration_summary;

Line: 412

    rollback to delete_duration_summary;

Line: 420

end delete_duration_summary;