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

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

Line: 295


procedure update_process_log
  (p_validate                       in  boolean   default false
  ,p_process_log_id                 in  number
  ,p_module_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_txn_id                         in  number    default hr_api.g_number
  ,p_master_process_log_id          in  number    default hr_api.g_number
  ,p_message_text                   in  varchar2  default hr_api.g_varchar2
  ,p_message_type_cd                in  varchar2  default hr_api.g_varchar2
  ,p_batch_status                   in  varchar2  default hr_api.g_varchar2
  ,p_batch_start_date               in  date      default hr_api.g_date
  ,p_batch_end_date                 in  date      default hr_api.g_date
  ,p_txn_table_route_id             in  number    default hr_api.g_number
  ,p_log_context                    in  varchar2  default hr_api.g_varchar2
  ,p_information_category           in  varchar2  default hr_api.g_varchar2
  ,p_information1                   in  varchar2  default hr_api.g_varchar2
  ,p_information2                   in  varchar2  default hr_api.g_varchar2
  ,p_information3                   in  varchar2  default hr_api.g_varchar2
  ,p_information4                   in  varchar2  default hr_api.g_varchar2
  ,p_information5                   in  varchar2  default hr_api.g_varchar2
  ,p_information6                   in  varchar2  default hr_api.g_varchar2
  ,p_information7                   in  varchar2  default hr_api.g_varchar2
  ,p_information8                   in  varchar2  default hr_api.g_varchar2
  ,p_information9                   in  varchar2  default hr_api.g_varchar2
  ,p_information10                  in  varchar2  default hr_api.g_varchar2
  ,p_information11                  in  varchar2  default hr_api.g_varchar2
  ,p_information12                  in  varchar2  default hr_api.g_varchar2
  ,p_information13                  in  varchar2  default hr_api.g_varchar2
  ,p_information14                  in  varchar2  default hr_api.g_varchar2
  ,p_information15                  in  varchar2  default hr_api.g_varchar2
  ,p_information16                  in  varchar2  default hr_api.g_varchar2
  ,p_information17                  in  varchar2  default hr_api.g_varchar2
  ,p_information18                  in  varchar2  default hr_api.g_varchar2
  ,p_information19                  in  varchar2  default hr_api.g_varchar2
  ,p_information20                  in  varchar2  default hr_api.g_varchar2
  ,p_information21                  in  varchar2  default hr_api.g_varchar2
  ,p_information22                  in  varchar2  default hr_api.g_varchar2
  ,p_information23                  in  varchar2  default hr_api.g_varchar2
  ,p_information24                  in  varchar2  default hr_api.g_varchar2
  ,p_information25                  in  varchar2  default hr_api.g_varchar2
  ,p_information26                  in  varchar2  default hr_api.g_varchar2
  ,p_information27                  in  varchar2  default hr_api.g_varchar2
  ,p_information28                  in  varchar2  default hr_api.g_varchar2
  ,p_information29                  in  varchar2  default hr_api.g_varchar2
  ,p_information30                  in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_process_log';

Line: 354


  savepoint update_process_log;

Line: 366


    pqh_process_log_bk2.update_process_log_b
      (
       p_process_log_id                 =>  p_process_log_id
      ,p_module_cd                      =>  p_module_cd
      ,p_txn_id                         =>  p_txn_id
      ,p_master_process_log_id          =>  p_master_process_log_id
      ,p_message_text                   =>  p_message_text
      ,p_message_type_cd                =>  p_message_type_cd
      ,p_batch_status                   =>  p_batch_status
      ,p_batch_start_date               =>  p_batch_start_date
      ,p_batch_end_date                 =>  p_batch_end_date
      ,p_txn_table_route_id             =>  p_txn_table_route_id
      ,p_log_context                    =>  p_log_context
      ,p_information_category           =>  p_information_category
      ,p_information1                   =>  p_information1
      ,p_information2                   =>  p_information2
      ,p_information3                   =>  p_information3
      ,p_information4                   =>  p_information4
      ,p_information5                   =>  p_information5
      ,p_information6                   =>  p_information6
      ,p_information7                   =>  p_information7
      ,p_information8                   =>  p_information8
      ,p_information9                   =>  p_information9
      ,p_information10                  =>  p_information10
      ,p_information11                  =>  p_information11
      ,p_information12                  =>  p_information12
      ,p_information13                  =>  p_information13
      ,p_information14                  =>  p_information14
      ,p_information15                  =>  p_information15
      ,p_information16                  =>  p_information16
      ,p_information17                  =>  p_information17
      ,p_information18                  =>  p_information18
      ,p_information19                  =>  p_information19
      ,p_information20                  =>  p_information20
      ,p_information21                  =>  p_information21
      ,p_information22                  =>  p_information22
      ,p_information23                  =>  p_information23
      ,p_information24                  =>  p_information24
      ,p_information25                  =>  p_information25
      ,p_information26                  =>  p_information26
      ,p_information27                  =>  p_information27
      ,p_information28                  =>  p_information28
      ,p_information29                  =>  p_information29
      ,p_information30                  =>  p_information30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 416


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

Line: 476


    pqh_process_log_bk2.update_process_log_a
      (
       p_process_log_id                 =>  p_process_log_id
      ,p_module_cd                      =>  p_module_cd
      ,p_txn_id                         =>  p_txn_id
      ,p_master_process_log_id          =>  p_master_process_log_id
      ,p_message_text                   =>  p_message_text
      ,p_message_type_cd                =>  p_message_type_cd
      ,p_batch_status                   =>  p_batch_status
      ,p_batch_start_date               =>  p_batch_start_date
      ,p_batch_end_date                 =>  p_batch_end_date
      ,p_txn_table_route_id             =>  p_txn_table_route_id
      ,p_log_context                    =>  p_log_context
      ,p_information_category           =>  p_information_category
      ,p_information1                   =>  p_information1
      ,p_information2                   =>  p_information2
      ,p_information3                   =>  p_information3
      ,p_information4                   =>  p_information4
      ,p_information5                   =>  p_information5
      ,p_information6                   =>  p_information6
      ,p_information7                   =>  p_information7
      ,p_information8                   =>  p_information8
      ,p_information9                   =>  p_information9
      ,p_information10                  =>  p_information10
      ,p_information11                  =>  p_information11
      ,p_information12                  =>  p_information12
      ,p_information13                  =>  p_information13
      ,p_information14                  =>  p_information14
      ,p_information15                  =>  p_information15
      ,p_information16                  =>  p_information16
      ,p_information17                  =>  p_information17
      ,p_information18                  =>  p_information18
      ,p_information19                  =>  p_information19
      ,p_information20                  =>  p_information20
      ,p_information21                  =>  p_information21
      ,p_information22                  =>  p_information22
      ,p_information23                  =>  p_information23
      ,p_information24                  =>  p_information24
      ,p_information25                  =>  p_information25
      ,p_information26                  =>  p_information26
      ,p_information27                  =>  p_information27
      ,p_information28                  =>  p_information28
      ,p_information29                  =>  p_information29
      ,p_information30                  =>  p_information30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 526


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

Line: 555


    ROLLBACK TO update_process_log;

Line: 568


    ROLLBACK TO update_process_log;

Line: 571


end update_process_log;

Line: 576


procedure delete_process_log
  (p_validate                       in  boolean  default false
  ,p_process_log_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_process_log';

Line: 594


  savepoint delete_process_log;

Line: 607


    pqh_process_log_bk3.delete_process_log_b
      (
       p_process_log_id                 =>  p_process_log_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 616


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

Line: 635


    pqh_process_log_bk3.delete_process_log_a
      (
       p_process_log_id                 =>  p_process_log_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 644


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

Line: 669


    ROLLBACK TO delete_process_log;

Line: 680


    ROLLBACK TO delete_process_log;

Line: 683


end delete_process_log;