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

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

Line: 209


PROCEDURE delete_statutory_situation
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_statutory_situation_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: 222


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

Line: 226


  Select stat_situation_rule_id , object_version_number
  from pqh_fr_stat_situation_rules
  where statutory_situation_id = p_statutory_situation_id;

Line: 243


  savepoint delete_statutory_situation_swi;

Line: 268


    	pqh_fr_stat_sit_rules_api.delete_stat_situation_rule
        (p_validate                     => l_validate
        ,p_stat_situation_rule_id       => l_rec.stat_situation_rule_id
        ,p_object_version_number        => l_rec.object_version_number
    	);

Line: 279


  pqh_fr_stat_situations_api.delete_statutory_situation
    (p_validate                     => l_validate
    ,p_statutory_situation_id       => p_statutory_situation_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 310


    rollback to delete_statutory_situation_swi;

Line: 330


    rollback to delete_statutory_situation_swi;

Line: 350


end delete_statutory_situation;

Line: 354


PROCEDURE update_statutory_situation
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date      default hr_api.g_date
  ,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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 400


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

Line: 413


  savepoint update_statutory_situation_swi;

Line: 434


  pqh_fr_stat_situations_api.update_statutory_situation
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_statutory_situation_id       => p_statutory_situation_id
    ,p_object_version_number        => p_object_version_number
    ,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_remunerate_assign_status_id  => p_remunerate_assign_status_id
    );

Line: 499


    rollback to update_statutory_situation_swi;

Line: 520


    rollback to update_statutory_situation_swi;

Line: 543


end update_statutory_situation;