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

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

Line: 231


procedure update_budget
  (p_validate                       in  boolean   default false
  ,p_budget_id                      in  number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_start_organization_id          in  number    default hr_api.g_number
  ,p_org_structure_version_id       in  number    default hr_api.g_number
  ,p_budgeted_entity_cd             in  varchar2  default hr_api.g_varchar2
  ,p_budget_style_cd                in  varchar2  default hr_api.g_varchar2
  ,p_budget_name                    in  varchar2  default hr_api.g_varchar2
  ,p_period_set_name                in  varchar2  default hr_api.g_varchar2
  ,p_budget_start_date              in  date      default hr_api.g_date
  ,p_budget_end_date                in  date      default hr_api.g_date
  ,p_gl_budget_name                 in  varchar2  default hr_api.g_varchar2
  ,p_psb_budget_flag                in  varchar2  default hr_api.g_varchar2
  ,p_transfer_to_gl_flag            in  varchar2  default hr_api.g_varchar2
  ,p_transfer_to_grants_flag        in  varchar2  default hr_api.g_varchar2
  ,p_status                         in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_budget_unit1_id                in  number    default hr_api.g_number
  ,p_budget_unit2_id                in  number    default hr_api.g_number
  ,p_budget_unit3_id                in  number    default hr_api.g_number
  ,p_gl_set_of_books_id             in  number    default hr_api.g_number
  ,p_budget_unit1_aggregate         in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit2_aggregate         in  varchar2  default hr_api.g_varchar2
  ,p_budget_unit3_aggregate         in  varchar2  default hr_api.g_varchar2
  ,p_position_control_flag          in  varchar2  default hr_api.g_varchar2
  ,p_valid_grade_reqd_flag          in  varchar2  default hr_api.g_varchar2
  ,p_currency_code                  in  varchar2  default hr_api.g_varchar2
  ,p_dflt_budget_set_id             in  number    default hr_api.g_number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_budget';

Line: 274


  savepoint update_budget;

Line: 286


    pqh_budgets_bk2.update_budget_b
      (
       p_budget_id                      =>  p_budget_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_start_organization_id          =>  p_start_organization_id
      ,p_org_structure_version_id       =>  p_org_structure_version_id
      ,p_budgeted_entity_cd             =>  p_budgeted_entity_cd
      ,p_budget_style_cd                =>  p_budget_style_cd
      ,p_budget_name                    =>  p_budget_name
      ,p_period_set_name                =>  p_period_set_name
      ,p_budget_start_date              =>  p_budget_start_date
      ,p_budget_end_date                =>  p_budget_end_date
      ,p_gl_budget_name                 =>  p_gl_budget_name
      ,p_psb_budget_flag                =>  p_psb_budget_flag
      ,p_transfer_to_gl_flag            =>  p_transfer_to_gl_flag
      ,p_transfer_to_grants_flag        =>  p_transfer_to_grants_flag
      ,p_status                         =>  p_status
      ,p_object_version_number          =>  p_object_version_number
      ,p_budget_unit1_id                =>  p_budget_unit1_id
      ,p_budget_unit2_id                =>  p_budget_unit2_id
      ,p_budget_unit3_id                =>  p_budget_unit3_id
      ,p_gl_set_of_books_id             =>  p_gl_set_of_books_id
      ,p_budget_unit1_aggregate         =>  p_budget_unit1_aggregate
      ,p_budget_unit2_aggregate         =>  p_budget_unit2_aggregate
      ,p_budget_unit3_aggregate         =>  p_budget_unit3_aggregate
      ,p_position_control_flag          =>  p_position_control_flag
      ,p_valid_grade_reqd_flag          =>  p_valid_grade_reqd_flag
      ,p_currency_code                  =>  p_currency_code
      ,p_dflt_budget_set_id             =>  p_dflt_budget_set_id
      ,p_effective_date                 =>  trunc(p_effective_date)
      );

Line: 320


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

Line: 364


    pqh_budgets_bk2.update_budget_a
      (
       p_budget_id                      =>  p_budget_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_start_organization_id          =>  p_start_organization_id
      ,p_org_structure_version_id       =>  p_org_structure_version_id
      ,p_budgeted_entity_cd             =>  p_budgeted_entity_cd
      ,p_budget_style_cd                =>  p_budget_style_cd
      ,p_budget_name                    =>  p_budget_name
      ,p_period_set_name                =>  p_period_set_name
      ,p_budget_start_date              =>  p_budget_start_date
      ,p_budget_end_date                =>  p_budget_end_date
      ,p_gl_budget_name                 =>  p_gl_budget_name
      ,p_psb_budget_flag                =>  p_psb_budget_flag
      ,p_transfer_to_gl_flag            =>  p_transfer_to_gl_flag
      ,p_transfer_to_grants_flag        =>  p_transfer_to_grants_flag
      ,p_status                         =>  p_status
      ,p_object_version_number          =>  l_object_version_number
      ,p_budget_unit1_id                =>  p_budget_unit1_id
      ,p_budget_unit2_id                =>  p_budget_unit2_id
      ,p_budget_unit3_id                =>  p_budget_unit3_id
      ,p_gl_set_of_books_id             =>  p_gl_set_of_books_id
      ,p_budget_unit1_aggregate         =>  p_budget_unit1_aggregate
      ,p_budget_unit2_aggregate         =>  p_budget_unit2_aggregate
      ,p_budget_unit3_aggregate         =>  p_budget_unit3_aggregate
      ,p_position_control_flag          =>  p_position_control_flag
      ,p_valid_grade_reqd_flag          =>  p_valid_grade_reqd_flag
      ,p_currency_code                  =>  p_currency_code
      ,p_dflt_budget_set_id             =>  p_dflt_budget_set_id
      ,p_effective_date                 =>  trunc(p_effective_date)
      );

Line: 398


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

Line: 427


    ROLLBACK TO update_budget;

Line: 440


    ROLLBACK TO update_budget;

Line: 443


end update_budget;

Line: 448


procedure delete_budget
  (p_validate                       in  boolean  default false
  ,p_budget_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_budget';

Line: 466


  savepoint delete_budget;

Line: 479


    pqh_budgets_bk3.delete_budget_b
      (
       p_budget_id                      =>  p_budget_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 488


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

Line: 507


    pqh_budgets_bk3.delete_budget_a
      (
       p_budget_id                      =>  p_budget_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 516


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

Line: 541


    ROLLBACK TO delete_budget;

Line: 552


    ROLLBACK TO delete_budget;

Line: 555


end delete_budget;