eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_DE_CASE_GROUPS_API SQL Statements

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

Line: 12


procedure Insert_CASE_GROUPS
   (p_validate                            in  boolean  default false
  ,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)
   is
  --
  -- Declare cursors and local variables
  --

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

Line: 46


  savepoint Insert_CASE_GROUPS;

Line: 55


   PQH_DE_CASE_GROUPS_BK1.Insert_CASE_GROUPS_b
    (p_effective_date                   => L_Effective_date
    ,p_case_group_number              => p_case_group_number
    ,p_description                    => P_DESCRIPTION
    ,p_advanced_pay_grade             => P_advanced_pay_grade
    ,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_entries_in_minute              => p_entries_in_minute
    ,p_period_of_prob_advmnt          => p_period_of_prob_advmnt
    ,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: 112


        PQH_DE_CASE_GROUPS_BK1.Insert_CASE_GROUPS_a
           (p_effective_date                 => L_Effective_Date
           ,p_CASE_GROUP_NUMBER              => p_CASE_GROUP_NUMBER
           ,P_DESCRIPTION                    => P_DESCRIPTION
           ,P_CASE_GROUP_ID                  => l_CASE_GROUP_ID
           ,p_advanced_pay_grade             => P_advanced_pay_grade
           ,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_entries_in_minute              => p_entries_in_minute
           ,p_period_of_prob_advmnt          => p_period_of_prob_advmnt
           ,p_object_version_number          => P_object_version_number
           ,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: 160


    rollback to Insert_CASE_GROUPS;

Line: 176


    rollback to Insert_CASE_GROUPS;

Line: 179


end Insert_CASE_GROUPS;

Line: 185


Procedure Update_CASE_GROUPS
   (p_validate                     in     boolean  default false
  ,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
  ) is

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

Line: 215


  savepoint Update_CASE_GROUPS;

Line: 225


           PQH_DE_CASE_GROUPS_BK2.Update_CASE_GROUPS_b
           (p_effective_date                 => L_Effective_Date
           ,p_CASE_GROUP_NUMBER              => p_CASE_GROUP_NUMBER
           ,P_DESCRIPTION                    => P_DESCRIPTION
           ,P_CASE_GROUP_ID                  => p_CASE_GROUP_ID
           ,p_advanced_pay_grade             => P_advanced_pay_grade
           ,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_entries_in_minute              => p_entries_in_minute
           ,p_period_of_prob_advmnt          => p_period_of_prob_advmnt
           ,p_object_version_number          => P_object_version_number
           ,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: 249


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

Line: 279


 PQH_DE_CASE_GROUPS_BK2.Update_CASE_GROUPS_a
           (p_effective_date                 => L_Effective_Date
           ,p_CASE_GROUP_NUMBER              => p_CASE_GROUP_NUMBER
           ,P_DESCRIPTION                    => P_DESCRIPTION
           ,P_CASE_GROUP_ID                  => p_CASE_GROUP_ID
           ,p_advanced_pay_grade             => P_advanced_pay_grade
           ,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_entries_in_minute              => p_entries_in_minute
           ,p_period_of_prob_advmnt          => p_period_of_prob_advmnt
           ,p_object_version_number          => P_object_version_number
           ,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: 301


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

Line: 325


    rollback to Update_CASE_GROUPS;

Line: 338


    rollback to Update_CASE_GROUPS;

Line: 341


end Update_CASE_GROUPS;

Line: 347


procedure delete_CASE_GROUPS
  (p_validate                      in     boolean  default false
  ,p_CASE_GROUP_ID                 In     Number
  ,p_object_version_number         In     number) Is
 --

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_CASE_GROUPS';

Line: 362


  savepoint delete_CASE_GROUPS;

Line: 367


  PQH_DE_CASE_GROUPS_BK3.Delete_CASE_GROUPS_b
  (p_CASE_GROUP_Id                 =>   p_CASE_GROUP_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 375


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

Line: 390


  PQH_DE_CASE_GROUPS_BK3.Delete_CASE_GROUPS_a
  (p_CASE_GROUP_Id                  =>   p_CASE_GROUP_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 397


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

Line: 416


    rollback to delete_CASE_GROUPS;

Line: 427


    rollback to delete_CASE_GROUPS;

Line: 430


end delete_CASE_GROUPS;