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_FR_STAT_SITUATIONS_API SQL Statements

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

Line: 279


procedure update_statutory_situation
  ( p_validate                     in     boolean   default false
   ,p_effective_date               in     date      default sysdate
   ,p_statutory_situation_id       in     number
   ,p_object_version_number        in out nocopy number
   ,p_business_group_id            in     number    default hr_api.g_number
   ,p_situation_name               in     varchar2  default hr_api.g_varchar2
   ,p_type_of_ps                   in     varchar2  default hr_api.g_varchar2
   ,p_situation_type               in     varchar2  default hr_api.g_varchar2
   ,p_sub_type                     in     varchar2  default hr_api.g_varchar2
   ,p_source                       in     varchar2  default hr_api.g_varchar2
   ,p_location                     in     varchar2  default hr_api.g_varchar2
   ,p_reason                       in     varchar2  default hr_api.g_varchar2
   ,p_is_default                   in     varchar2  default hr_api.g_varchar2
   ,p_date_from                    in     date      default hr_api.g_date
   ,p_date_to                      in     date      default hr_api.g_date
   ,p_request_type                 in     varchar2  default hr_api.g_varchar2
   ,p_employee_agreement_needed    in     varchar2  default hr_api.g_varchar2
   ,p_manager_agreement_needed     in     varchar2  default hr_api.g_varchar2
   ,p_print_arrette                in     varchar2  default hr_api.g_varchar2
   ,p_reserve_position             in     varchar2  default hr_api.g_varchar2
   ,p_allow_progressions           in     varchar2  default hr_api.g_varchar2
   ,p_extend_probation_period      in     varchar2  default hr_api.g_varchar2
   ,p_remuneration_paid            in     varchar2  default hr_api.g_varchar2
   ,p_pay_share                    in     number    default hr_api.g_number
   ,p_pay_periods                  in     number    default hr_api.g_number
   ,p_frequency                    in     varchar2  default hr_api.g_varchar2
   ,p_first_period_max_duration    in     number    default hr_api.g_number
   ,p_min_duration_per_request     in     number    default hr_api.g_number
   ,p_max_duration_per_request     in     number    default hr_api.g_number
   ,p_max_duration_whole_career    in     number    default hr_api.g_number
   ,p_renewable_allowed            in     varchar2  default hr_api.g_varchar2
   ,p_max_no_of_renewals           in     number    default hr_api.g_number
   ,p_max_duration_per_renewal     in     number    default hr_api.g_number
   ,p_max_tot_continuous_duration  in     number    default hr_api.g_number
   ,p_remunerate_assign_status_id  in     number    default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 321


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

Line: 338


  savepoint update_statutory_situation;

Line: 356


       pqh_fr_stat_situations_bk2.update_statutory_situation_b
      (  p_effective_date               =>   l_effective_date
        ,p_business_group_id            =>   p_business_group_id
        ,p_situation_name               =>   p_situation_name
        ,p_type_of_ps                   =>   p_type_of_ps
        ,p_situation_type               =>   p_situation_type
        ,p_sub_type                     =>   p_sub_type
        ,p_source                       =>   p_source
        ,p_location                     =>   p_location
        ,p_reason                       =>   p_reason
        ,p_is_default                   =>   p_is_default
        ,p_date_from                    =>   p_date_from
        ,p_date_to                      =>   p_date_to
        ,p_request_type                 =>   p_request_type
        ,p_employee_agreement_needed    =>   p_employee_agreement_needed
        ,p_manager_agreement_needed     =>   p_manager_agreement_needed
        ,p_print_arrette                =>   p_print_arrette
        ,p_reserve_position             =>   p_reserve_position
        ,p_allow_progressions           =>   p_allow_progressions
        ,p_extend_probation_period      =>   p_extend_probation_period
        ,p_remuneration_paid            =>   p_remuneration_paid
        ,p_pay_share                    =>   p_pay_share
        ,p_pay_periods                  =>   p_pay_periods
        ,p_frequency                    =>   p_frequency
        ,p_first_period_max_duration    =>   p_first_period_max_duration
        ,p_min_duration_per_request     =>   p_min_duration_per_request
        ,p_max_duration_per_request     =>   p_max_duration_per_request
        ,p_max_duration_whole_career    =>   p_max_duration_whole_career
        ,p_renewable_allowed            =>   p_renewable_allowed
        ,p_max_no_of_renewals           =>   p_max_no_of_renewals
        ,p_max_duration_per_renewal     =>   p_max_duration_per_renewal
        ,p_max_tot_continuous_duration  =>   p_max_tot_continuous_duration
        ,p_statutory_situation_id       =>   p_statutory_situation_id
        ,p_object_version_number        =>   l_object_version_number
        ,p_remunerate_assign_status_id  =>   p_remunerate_assign_status_id
      );

Line: 395


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

Line: 447


    pqh_fr_stat_situations_bk2.update_statutory_situation_a
       ( p_effective_date               =>   l_effective_date
        ,p_business_group_id            =>   p_business_group_id
        ,p_situation_name               =>   p_situation_name
        ,p_type_of_ps                   =>   p_type_of_ps
        ,p_situation_type               =>   p_situation_type
        ,p_sub_type                     =>   p_sub_type
        ,p_source                       =>   p_source
        ,p_location                     =>   p_location
        ,p_reason                       =>   p_reason
        ,p_is_default                   =>   p_is_default
        ,p_date_from                    =>   p_date_from
        ,p_date_to                      =>   p_date_to
        ,p_request_type                 =>   p_request_type
        ,p_employee_agreement_needed    =>   p_employee_agreement_needed
        ,p_manager_agreement_needed     =>   p_manager_agreement_needed
        ,p_print_arrette                =>   p_print_arrette
        ,p_reserve_position             =>   p_reserve_position
        ,p_allow_progressions           =>   p_allow_progressions
        ,p_extend_probation_period      =>   p_extend_probation_period
        ,p_remuneration_paid            =>   p_remuneration_paid
        ,p_pay_share                    =>   p_pay_share
        ,p_pay_periods                  =>   p_pay_periods
        ,p_frequency                    =>   p_frequency
        ,p_first_period_max_duration    =>   p_first_period_max_duration
        ,p_min_duration_per_request     =>   p_min_duration_per_request
        ,p_max_duration_per_request     =>   p_max_duration_per_request
        ,p_max_duration_whole_career    =>   p_max_duration_whole_career
        ,p_renewable_allowed            =>   p_renewable_allowed
        ,p_max_no_of_renewals           =>   p_max_no_of_renewals
        ,p_max_duration_per_renewal     =>   p_max_duration_per_renewal
        ,p_max_tot_continuous_duration  =>   p_max_tot_continuous_duration
        ,p_statutory_situation_id       =>   p_statutory_situation_id
        ,p_object_version_number        =>   l_object_version_number
        ,p_remunerate_assign_status_id  =>   p_remunerate_assign_status_id
       );

Line: 486


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

Line: 513


    rollback to UPDATE_STATUTORY_SITUATION;

Line: 531


    rollback to UPDATE_STATUTORY_SITUATION;

Line: 540


end UPDATE_STATUTORY_SITUATION;

Line: 547


  procedure delete_statutory_situation
    (p_validate                      in     boolean  default false
    ,p_statutory_situation_id               in     number
    ,p_object_version_number                in     number
    ) is

  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 558


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

Line: 564


  Select null
  From pqh_fr_emp_stat_situations
  Where statutory_situation_id = p_statutory_situation_id;

Line: 583


  savepoint delete_statutory_situation;

Line: 609


       pqh_fr_stat_situations_bk3.delete_statutory_situation_b
      (  p_statutory_situation_id       =>   p_statutory_situation_id
	,p_object_version_number	=>   l_object_version_number
      );

Line: 617


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

Line: 637


      pqh_fr_stat_situations_bk3.delete_statutory_situation_a
         (
         p_statutory_situation_id       =>   p_statutory_situation_id
   	,p_object_version_number	=>   l_object_version_number
         );

Line: 645


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

Line: 672


    rollback to DELETE_STATUTORY_SITUATION;

Line: 688


    rollback to DELETE_STATUTORY_SITUATION;

Line: 696


end DELETE_STATUTORY_SITUATION;