DBA Data[Home] [Help]

APPS.HR_CAGR_GRADES_API SQL Statements

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

Line: 12

PROCEDURE update_concat_segs
  (p_cagr_grade_def_id     IN per_cagr_grades_def.cagr_grade_def_id%TYPE
  ,p_concatenated_segments IN per_cagr_grades_def.concatenated_segments%TYPE) is
--
  l_proc VARCHAR2(72) := g_package||'update_concat_segs';
Line: 21

    SELECT  concatenated_segments
    FROM    per_cagr_grades_def
    WHERE   cagr_grade_def_id = p_cagr_grade_def_id;
Line: 25

  procedure update_concat_segs_auto
    (p_cagr_grade_def_id in number) is
    PRAGMA AUTONOMOUS_TRANSACTION;
Line: 30

      SELECT null
        FROM per_cagr_grades_def
        where cagr_grade_def_id = p_cagr_grade_def_id
        for update nowait;
Line: 36

    l_proc    varchar2(72) := g_package||'update_concat_segs_auto';
Line: 49

      UPDATE  per_cagr_grades_def
      SET     concatenated_segments  = p_concatenated_segments
      WHERE   cagr_grade_def_id      = p_cagr_grade_def_id;
Line: 65

  end update_concat_segs_auto;
Line: 88

       update_concat_segs_auto(p_cagr_grade_def_id);
Line: 95

end update_concat_segs;
Line: 170

    select pcg.id_flex_num
      from per_cagr_grade_structures pcg
     where pcg.cagr_grade_structure_id = p_cagr_grade_structure_id;
Line: 178

    select segment1,
           segment2,
           segment3,
           segment4,
           segment5,
           segment6,
           segment7,
           segment8,
           segment9,
           segment10,
           segment11,
           segment12,
           segment13,
           segment14,
           segment15,
           segment16,
           segment17,
           segment18,
           segment19,
           segment20
      from per_cagr_grades_def
     where cagr_grade_def_id = l_cagr_grade_def_id;
Line: 355

     update_concat_segs
       (p_cagr_grade_def_id     => l_cagr_grade_def_id
       ,p_concatenated_segments => l_name);
Line: 476

procedure update_cagr_grades
  (p_validate       in  boolean   default false
  ,p_cagr_grade_id  in  number
  ,p_sequence       in  number    default hr_api.g_number
  ,p_segment1            in  varchar2  default hr_api.g_varchar2
  ,p_segment2            in  varchar2  default hr_api.g_varchar2
  ,p_segment3            in  varchar2  default hr_api.g_varchar2
  ,p_segment4            in  varchar2  default hr_api.g_varchar2
  ,p_segment5            in  varchar2  default hr_api.g_varchar2
  ,p_segment6            in  varchar2  default hr_api.g_varchar2
  ,p_segment7            in  varchar2  default hr_api.g_varchar2
  ,p_segment8            in  varchar2  default hr_api.g_varchar2
  ,p_segment9            in  varchar2  default hr_api.g_varchar2
  ,p_segment10           in  varchar2  default hr_api.g_varchar2
  ,p_segment11           in  varchar2  default hr_api.g_varchar2
  ,p_segment12           in  varchar2  default hr_api.g_varchar2
  ,p_segment13           in  varchar2  default hr_api.g_varchar2
  ,p_segment14           in  varchar2  default hr_api.g_varchar2
  ,p_segment15           in  varchar2  default hr_api.g_varchar2
  ,p_segment16           in  varchar2  default hr_api.g_varchar2
  ,p_segment17           in  varchar2  default hr_api.g_varchar2
  ,p_segment18           in  varchar2  default hr_api.g_varchar2
  ,p_segment19           in  varchar2  default hr_api.g_varchar2
  ,p_segment20           in  varchar2  default hr_api.g_varchar2
  ,p_concat_segments         in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number in out nocopy number
  ,p_effective_date           in     date
  ,p_name                           out nocopy varchar2
  ,p_cagr_grade_def_id      in out nocopy number) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_cagr_grades';
Line: 544

    select pcs.id_flex_num
    from per_cagr_grade_structures pcs
    where pcs.cagr_grade_structure_id in
          (select pcg.cagr_grade_structure_id
           from   per_cagr_grades pcg
           where  pcg.cagr_grade_id = p_cagr_grade_id);
Line: 555

    select segment1,
           segment2,
           segment3,
           segment4,
           segment5,
           segment6,
           segment7,
           segment8,
           segment9,
           segment10,
           segment11,
           segment12,
           segment13,
           segment14,
           segment15,
           segment16,
           segment17,
           segment18,
           segment19,
           segment20
      from per_cagr_grades_def
     where cagr_grade_def_id = l_cagr_grade_def_id;
Line: 585

  savepoint update_cagr_grades;
Line: 645

    hr_cagr_grades_bk2.update_cagr_grades_b
      (p_cagr_grade_id      =>  p_cagr_grade_id
      ,p_sequence           =>  p_sequence
      ,p_segment1             =>  l_segment1
      ,p_segment2             =>  l_segment2
      ,p_segment3             =>  l_segment3
      ,p_segment4             =>  l_segment4
      ,p_segment5             =>  l_segment5
      ,p_segment6             =>  l_segment6
      ,p_segment7             =>  l_segment7
      ,p_segment8             =>  l_segment8
      ,p_segment9             =>  l_segment9
      ,p_segment10              =>  l_segment10
      ,p_segment11              =>  l_segment11
      ,p_segment12              =>  l_segment12
      ,p_segment13              =>  l_segment13
      ,p_segment14              =>  l_segment14
      ,p_segment15              =>  l_segment15
      ,p_segment16              =>  l_segment16
      ,p_segment17              =>  l_segment17
      ,p_segment18              =>  l_segment18
      ,p_segment19              =>  l_segment19
      ,p_segment20              =>  l_segment20
      ,p_concat_segments        =>  p_concat_segments
      ,p_object_version_number  =>  p_object_version_number
      ,p_effective_date         =>  trunc(p_effective_date));
Line: 676

        (p_module_name => 'UPDATE_CAGR_GRADES'
        ,p_hook_type   => 'BP'
        );
Line: 751

  update_concat_segs
       (p_cagr_grade_def_id     => l_cagr_grade_def_id
       ,p_concatenated_segments => l_name);
Line: 768

    hr_cagr_grades_bk2.update_cagr_grades_a
      (p_cagr_grade_id     =>  p_cagr_grade_id
      ,p_sequence          =>  p_sequence
      ,p_segment1            =>  l_segment1
      ,p_segment2            =>  l_segment2
      ,p_segment3            =>  l_segment3
      ,p_segment4            =>  l_segment4
      ,p_segment5            =>  l_segment5
      ,p_segment6            =>  l_segment6
      ,p_segment7            =>  l_segment7
      ,p_segment8            =>  l_segment8
      ,p_segment9            =>  l_segment9
      ,p_segment10              =>  l_segment10
      ,p_segment11              =>  l_segment11
      ,p_segment12              =>  l_segment12
      ,p_segment13              =>  l_segment13
      ,p_segment14              =>  l_segment14
      ,p_segment15              =>  l_segment15
      ,p_segment16              =>  l_segment16
      ,p_segment17              =>  l_segment17
      ,p_segment18              =>  l_segment18
      ,p_segment19              =>  l_segment19
      ,p_segment20              =>  l_segment20
      ,p_concat_segments      =>  p_concat_segments
      ,p_effective_date       =>  trunc(p_effective_date)
      ,p_name                    =>  l_name
      ,p_cagr_grade_def_id  =>  l_cagr_grade_def_id
      ,p_object_version_number =>  l_object_version_number);
Line: 802

        (p_module_name => 'UPDATE_CAGR_GRADES'
        ,p_hook_type   => 'AP');
Line: 834

    ROLLBACK TO update_cagr_grades;
Line: 853

    ROLLBACK TO update_cagr_grades;
Line: 862

end update_cagr_grades;
Line: 867

procedure delete_cagr_grades
  (p_validate                       in  boolean  default false
  ,p_cagr_grade_id                  in  number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date         in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_cagr_grades';
Line: 886

  savepoint delete_cagr_grades;
Line: 899

    hr_cagr_grades_bk3.delete_cagr_grades_b
      (
       p_cagr_grade_id                  =>  p_cagr_grade_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date       =>  trunc(p_effective_date)
      );
Line: 908

        (p_module_name => 'DELETE_CAGR_GRADES'
        ,p_hook_type   => 'BP'
        );
Line: 926

    hr_cagr_grades_bk3.delete_cagr_grades_a
      (
       p_cagr_grade_id                  =>  p_cagr_grade_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date       =>  trunc(p_effective_date)
      );
Line: 935

        (p_module_name => 'DELETE_CAGR_GRADES'
        ,p_hook_type   => 'AP'
        );
Line: 964

    ROLLBACK TO delete_cagr_grades;
Line: 975

    ROLLBACK TO delete_cagr_grades;
Line: 982

end delete_cagr_grades;