APPS.PQH_DE_CASE_GROUPS_SWI SQL Statements

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

Line: 11

PROCEDURE delete_case_groups
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_case_group_id                in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 24

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

Line: 30

  savepoint delete_case_groups_swi;

Line: 50

  pqh_de_case_groups_api.delete_case_groups
    (p_validate                     => l_validate
    ,p_case_group_id                => p_case_group_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 77

    rollback to delete_case_groups_swi;

Line: 91

    rollback to delete_case_groups_swi;

Line: 101

end delete_case_groups;

Line: 105

PROCEDURE insert_case_groups
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_case_group_number            in     varchar2
  ,p_description                  in     varchar2
  ,p_advanced_pay_grade           in     number
  ,p_entries_in_minute            in     varchar2
  ,p_period_of_prob_advmnt        in     number
  ,p_period_of_time_advmnt        in     number
  ,p_advancement_to               in     number
  ,p_advancement_additional_pyt   in     number
  ,p_time_advanced_pay_grade      in     number
  ,p_time_advancement_to          in     number
  ,p_business_group_id            in     number
  ,p_time_advn_units              in     varchar2
  ,p_prob_advn_units              in     varchar2
  ,p_SUB_CSGRP_DESCRIPTION        in     varchar2
  ,p_case_group_id                   out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 133

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

Line: 139

  savepoint insert_case_groups_swi;

Line: 159

  pqh_de_case_groups_api.Insert_CASE_GROUPS
   (p_validate                      =>   l_validate
  ,p_effective_date                 =>   p_effective_date
  ,p_Case_Group_NUMBER              =>   p_Case_Group_NUMBER
  ,P_DESCRIPTION                    =>   P_DESCRIPTION
  ,p_Advanced_Pay_Grade		    =>   p_Advanced_Pay_Grade
  ,p_Entries_in_Minute		    =>   p_Entries_in_Minute
  ,p_Period_Of_Prob_Advmnt          =>   p_Period_Of_Prob_Advmnt
  ,p_Period_Of_Time_Advmnt	    =>   p_Period_Of_Time_Advmnt
  ,p_Advancement_To		    =>   p_Advancement_To
  ,p_Advancement_Additional_pyt     =>   p_Advancement_Additional_pyt
  ,p_time_advanced_pay_grade        =>   p_time_advanced_pay_grade
  ,p_time_advancement_to            =>   p_time_advancement_to
  ,p_business_group_id              =>   p_business_group_id
  ,p_time_advn_units                =>   p_time_advn_units
  ,p_prob_advn_units                =>   p_prob_advn_units
  ,p_sub_csgrp_description          =>   p_sub_csgrp_description
  ,P_CASE_GROUP_ID                  =>   P_CASE_GROUP_ID
  ,p_object_version_number          =>   p_object_version_number   );

Line: 200

    rollback to insert_case_groups_swi;

Line: 216

    rollback to insert_case_groups_swi;

Line: 228

end insert_case_groups;

Line: 232

PROCEDURE update_case_groups
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_case_group_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_case_group_number            in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_advanced_pay_grade           in     number    default hr_api.g_number
  ,p_entries_in_minute            in     varchar2  default hr_api.g_varchar2
  ,p_period_of_prob_advmnt        in     number    default hr_api.g_number
  ,p_period_of_time_advmnt        in     number    default hr_api.g_number
  ,p_advancement_to               in     number    default hr_api.g_number
  ,p_advancement_additional_pyt   in     number    default hr_api.g_number
  ,p_time_advanced_pay_grade      in     number    default hr_api.g_number
  ,p_time_advancement_to          in     number    default hr_api.g_number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_time_advn_units              in     varchar2  default hr_api.g_varchar2
  ,p_prob_advn_units              in     varchar2  default hr_api.g_varchar2
  ,p_SUB_CSGRP_DESCRIPTION        in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 261

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

Line: 268

  savepoint update_case_groups_swi;

Line: 289

  pqh_de_case_groups_api.update_case_groups
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_case_group_id                => p_case_group_id
    ,p_object_version_number        => p_object_version_number
    ,p_case_group_number            => p_case_group_number
    ,p_description                  => p_description
    ,p_advanced_pay_grade           => p_advanced_pay_grade
    ,p_entries_in_minute            => p_entries_in_minute
    ,p_period_of_prob_advmnt        => p_period_of_prob_advmnt
    ,p_period_of_time_advmnt        => p_period_of_time_advmnt
    ,p_advancement_to               => p_advancement_to
    ,p_advancement_additional_pyt   => p_advancement_additional_pyt
    ,p_time_advanced_pay_grade      => p_time_advanced_pay_grade
    ,p_time_advancement_to          => p_time_advancement_to
    ,p_business_group_id            => p_business_group_id
    ,p_time_advn_units              => p_time_advn_units
    ,p_prob_advn_units              => p_prob_advn_units
    ,p_SUB_CSGRP_DESCRIPTION        =>p_SUB_CSGRP_DESCRIPTION
    );

Line: 331

    rollback to update_case_groups_swi;

Line: 346

    rollback to update_case_groups_swi;

Line: 357

end update_case_groups;