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

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

Line: 216


procedure update_TRAN_CATEGORY
  (p_validate                       in  boolean   default false
  ,p_transaction_category_id        in  number
  ,p_custom_wf_process_name         in  varchar2  default hr_api.g_varchar2
  ,p_custom_workflow_name           in  varchar2  default hr_api.g_varchar2
  ,p_form_name                      in  varchar2  default hr_api.g_varchar2
  ,p_freeze_status_cd               in  varchar2  default hr_api.g_varchar2
  ,p_future_action_cd               in  varchar2  default hr_api.g_varchar2
  ,p_member_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_name                           in  varchar2  default hr_api.g_varchar2
  ,p_short_name                     in  varchar2  default hr_api.g_varchar2
  ,p_post_style_cd                  in  varchar2  default hr_api.g_varchar2
  ,p_post_txn_function              in  varchar2  default hr_api.g_varchar2
  ,p_route_validated_txn_flag       in  varchar2  default hr_api.g_varchar2
  ,p_prevent_approver_skip          in  varchar2  default hr_api.g_varchar2
  ,p_workflow_enable_flag       in  varchar2  default hr_api.g_varchar2
  ,p_enable_flag       in  varchar2  default hr_api.g_varchar2
  ,p_timeout_days                   in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_consolidated_table_route_id    in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_setup_type_cd                  in varchar2   default hr_api.g_varchar2
  ,p_master_table_route_id          in number     default hr_api.g_number
  ,p_effective_date                 in  date
  ,p_language_code                  in  varchar2  default hr_api.userenv_lang
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_TRAN_CATEGORY';

Line: 254


  savepoint update_TRAN_CATEGORY;

Line: 266


    pqh_TRAN_CATEGORY_bk2.update_TRAN_CATEGORY_b
      (
       p_transaction_category_id        =>  p_transaction_category_id
      ,p_custom_wf_process_name         =>  p_custom_wf_process_name
      ,p_custom_workflow_name           =>  p_custom_workflow_name
      ,p_form_name                      =>  p_form_name
      ,p_freeze_status_cd               =>  p_freeze_status_cd
      ,p_future_action_cd               =>  p_future_action_cd
      ,p_member_cd                      =>  p_member_cd
      ,p_name                           =>  p_name
      ,p_short_name                     =>  p_short_name
      ,p_post_style_cd                  =>  p_post_style_cd
      ,p_post_txn_function              =>  p_post_txn_function
      ,p_route_validated_txn_flag       =>  p_route_validated_txn_flag
      ,p_prevent_approver_skip          =>  p_prevent_approver_skip
      ,p_workflow_enable_flag       =>  p_workflow_enable_flag
      ,p_enable_flag       =>  p_enable_flag
      ,p_timeout_days                   =>  p_timeout_days
      ,p_object_version_number          =>  p_object_version_number
      ,p_consolidated_table_route_id    =>  p_consolidated_table_route_id
  ,p_business_group_id            =>  p_business_group_id
  ,p_setup_type_cd                =>  p_setup_type_cd
      ,p_master_table_route_id    =>  p_master_table_route_id
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 294


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

Line: 338


    pqh_TRAN_CATEGORY_bk2.update_TRAN_CATEGORY_a
      (
       p_transaction_category_id        =>  p_transaction_category_id
      ,p_custom_wf_process_name         =>  p_custom_wf_process_name
      ,p_custom_workflow_name           =>  p_custom_workflow_name
      ,p_form_name                      =>  p_form_name
      ,p_freeze_status_cd               =>  p_freeze_status_cd
      ,p_future_action_cd               =>  p_future_action_cd
      ,p_member_cd                      =>  p_member_cd
      ,p_name                           =>  p_name
      ,p_short_name                           =>  p_short_name
      ,p_post_style_cd                  =>  p_post_style_cd
      ,p_post_txn_function              =>  p_post_txn_function
      ,p_route_validated_txn_flag       =>  p_route_validated_txn_flag
      ,p_prevent_approver_skip          =>  p_prevent_approver_skip
      ,p_workflow_enable_flag       =>  p_workflow_enable_flag
      ,p_enable_flag       =>  p_enable_flag
      ,p_timeout_days                   =>  p_timeout_days
      ,p_object_version_number          =>  l_object_version_number
      ,p_consolidated_table_route_id    =>  p_consolidated_table_route_id
  ,p_business_group_id            =>  p_business_group_id
  ,p_setup_type_cd                =>  p_setup_type_cd
      ,p_master_table_route_id    =>  p_master_table_route_id
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 366


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

Line: 395


    ROLLBACK TO update_TRAN_CATEGORY;

Line: 408


    ROLLBACK TO update_TRAN_CATEGORY;

Line: 411


end update_TRAN_CATEGORY;

Line: 416


procedure delete_TRAN_CATEGORY
  (p_validate                       in  boolean  default false
  ,p_transaction_category_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_TRAN_CATEGORY';

Line: 434


  savepoint delete_TRAN_CATEGORY;

Line: 447


    pqh_TRAN_CATEGORY_bk3.delete_TRAN_CATEGORY_b
      (
       p_transaction_category_id        =>  p_transaction_category_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 456


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

Line: 487


    pqh_TRAN_CATEGORY_bk3.delete_TRAN_CATEGORY_a
      (
       p_transaction_category_id        =>  p_transaction_category_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 496


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

Line: 521


    ROLLBACK TO delete_TRAN_CATEGORY;

Line: 532


    ROLLBACK TO delete_TRAN_CATEGORY;

Line: 535


end delete_TRAN_CATEGORY;