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

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

Line: 357


     pqh_wks_budget.insert_default_period
     (
      p_worksheet_detail_id             => l_worksheet_detail_id
     ,p_worksheet_unit1_value           => p_budget_unit1_value
     ,p_worksheet_unit2_value           => p_budget_unit2_value
     ,p_worksheet_unit3_value           => p_budget_unit3_value
     ,p_worksheet_period_id             => l_worksheet_period_id
     ,p_wkd_ovn                         => l_wkd_ovn
     ,p_wpr_ovn                         => l_wpr_ovn
     );

Line: 385


procedure update_WORKSHEET_DETAIL
  (p_validate                       in  boolean   default false
  ,p_worksheet_detail_id            in  number
  ,p_worksheet_id                   in  number    default hr_api.g_number
  ,p_organization_id                in  number    default hr_api.g_number
  ,p_job_id                         in  number    default hr_api.g_number
  ,p_position_id                    in  number    default hr_api.g_number
  ,p_grade_id                       in  number    default hr_api.g_number
  ,p_position_transaction_id        in  number    default hr_api.g_number
  ,p_budget_detail_id               in  number    default hr_api.g_number
  ,p_parent_worksheet_detail_id     in  number    default hr_api.g_number
  ,p_user_id                        in  number    default hr_api.g_number
  ,p_action_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit1_percent           in  number    default hr_api.g_number
  ,p_budget_unit1_value             in  number    default hr_api.g_number
  ,p_budget_unit2_percent           in  number    default hr_api.g_number
  ,p_budget_unit2_value             in  number    default hr_api.g_number
  ,p_budget_unit3_percent           in  number    default hr_api.g_number
  ,p_budget_unit3_value             in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_budget_unit1_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit2_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit3_value_type_cd     in  varchar2  default hr_api.g_varchar2
  ,p_status                         in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit1_available         in  number    default hr_api.g_number
  ,p_budget_unit2_available         in  number    default hr_api.g_number
  ,p_budget_unit3_available         in  number    default hr_api.g_number
  ,p_old_unit1_value                in  number    default hr_api.g_number
  ,p_old_unit2_value                in  number    default hr_api.g_number
  ,p_old_unit3_value                in  number    default hr_api.g_number
  ,p_defer_flag                     in  varchar2  default hr_api.g_varchar2
  ,p_propagation_method             in  varchar2  default hr_api.g_varchar2
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_WORKSHEET_DETAIL';

Line: 431


  savepoint update_WORKSHEET_DETAIL;

Line: 443


    pqh_WORKSHEET_DETAILS_bk2.update_WORKSHEET_DETAIL_b
      (
       p_worksheet_detail_id            =>  p_worksheet_detail_id
      ,p_worksheet_id                   =>  p_worksheet_id
      ,p_organization_id                =>  p_organization_id
      ,p_job_id                         =>  p_job_id
      ,p_position_id                    =>  p_position_id
      ,p_grade_id                       =>  p_grade_id
      ,p_position_transaction_id        =>  p_position_transaction_id
      ,p_budget_detail_id               =>  p_budget_detail_id
      ,p_parent_worksheet_detail_id     =>  p_parent_worksheet_detail_id
      ,p_user_id                        =>  p_user_id
      ,p_action_cd                      =>  p_action_cd
      ,p_budget_unit1_percent           =>  p_budget_unit1_percent
      ,p_budget_unit1_value             =>  p_budget_unit1_value
      ,p_budget_unit2_percent           =>  p_budget_unit2_percent
      ,p_budget_unit2_value             =>  p_budget_unit2_value
      ,p_budget_unit3_percent           =>  p_budget_unit3_percent
      ,p_budget_unit3_value             =>  p_budget_unit3_value
      ,p_object_version_number          =>  p_object_version_number
      ,p_budget_unit1_value_type_cd     =>  p_budget_unit1_value_type_cd
      ,p_budget_unit2_value_type_cd     =>  p_budget_unit2_value_type_cd
      ,p_budget_unit3_value_type_cd     =>  p_budget_unit3_value_type_cd
      ,p_status                         =>  p_status
      ,p_budget_unit1_available         =>  p_budget_unit1_available
      ,p_budget_unit2_available         =>  p_budget_unit2_available
      ,p_budget_unit3_available         =>  p_budget_unit3_available
      ,p_old_unit1_value                =>  p_old_unit1_value
      ,p_old_unit2_value                =>  p_old_unit2_value
      ,p_old_unit3_value                =>  p_old_unit3_value
      ,p_defer_flag                     =>  p_defer_flag
      ,p_propagation_method             =>  p_propagation_method
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 480


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

Line: 527


    pqh_WORKSHEET_DETAILS_bk2.update_WORKSHEET_DETAIL_a
      (
       p_worksheet_detail_id            =>  p_worksheet_detail_id
      ,p_worksheet_id                   =>  p_worksheet_id
      ,p_organization_id                =>  p_organization_id
      ,p_job_id                         =>  p_job_id
      ,p_position_id                    =>  p_position_id
      ,p_grade_id                       =>  p_grade_id
      ,p_position_transaction_id        =>  p_position_transaction_id
      ,p_budget_detail_id               =>  p_budget_detail_id
      ,p_parent_worksheet_detail_id     =>  p_parent_worksheet_detail_id
      ,p_user_id                        =>  p_user_id
      ,p_action_cd                      =>  p_action_cd
      ,p_budget_unit1_percent           =>  p_budget_unit1_percent
      ,p_budget_unit1_value             =>  p_budget_unit1_value
      ,p_budget_unit2_percent           =>  p_budget_unit2_percent
      ,p_budget_unit2_value             =>  p_budget_unit2_value
      ,p_budget_unit3_percent           =>  p_budget_unit3_percent
      ,p_budget_unit3_value             =>  p_budget_unit3_value
      ,p_object_version_number          =>  l_object_version_number
      ,p_budget_unit1_value_type_cd     =>  p_budget_unit1_value_type_cd
      ,p_budget_unit2_value_type_cd     =>  p_budget_unit2_value_type_cd
      ,p_budget_unit3_value_type_cd     =>  p_budget_unit3_value_type_cd
      ,p_status                         =>  p_status
      ,p_budget_unit1_available         =>  p_budget_unit1_available
      ,p_budget_unit2_available         =>  p_budget_unit2_available
      ,p_budget_unit3_available         =>  p_budget_unit3_available
      ,p_old_unit1_value                =>  p_old_unit1_value
      ,p_old_unit2_value                =>  p_old_unit2_value
      ,p_old_unit3_value                =>  p_old_unit3_value
      ,p_defer_flag                     =>  p_defer_flag
      ,p_propagation_method             =>  p_propagation_method
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 564


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

Line: 593


    ROLLBACK TO update_WORKSHEET_DETAIL;

Line: 606


    ROLLBACK TO update_WORKSHEET_DETAIL;

Line: 609


end update_WORKSHEET_DETAIL;

Line: 614


procedure delete_WORKSHEET_DETAIL
  (p_validate                       in  boolean  default false
  ,p_worksheet_detail_id            in  number
  ,p_object_version_number          in  number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_WORKSHEET_DETAIL';

Line: 632


  savepoint delete_WORKSHEET_DETAIL;

Line: 645


    pqh_WORKSHEET_DETAILS_bk3.delete_WORKSHEET_DETAIL_b
      (
       p_worksheet_detail_id            =>  p_worksheet_detail_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 654


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

Line: 673


    pqh_WORKSHEET_DETAILS_bk3.delete_WORKSHEET_DETAIL_a
      (
       p_worksheet_detail_id            =>  p_worksheet_detail_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 682


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

Line: 707


    ROLLBACK TO delete_WORKSHEET_DETAIL;

Line: 718


    ROLLBACK TO delete_WORKSHEET_DETAIL;

Line: 721


end delete_WORKSHEET_DETAIL;