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

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

Line: 11


PROCEDURE delete_vldtn_vern
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_wrkplc_vldtn_ver_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: 24


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

Line: 30


  savepoint delete_vldtn_vern_swi;

Line: 50


  pqh_de_vldver_api.delete_vldtn_vern
    (p_validate                     => l_validate
    ,p_wrkplc_vldtn_ver_id          => p_wrkplc_vldtn_ver_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 77


    rollback to delete_vldtn_vern_swi;

Line: 91


    rollback to delete_vldtn_vern_swi;

Line: 101


end delete_vldtn_vern;

Line: 105


PROCEDURE insert_vldtn_vern
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_business_group_id            in     number
  ,p_wrkplc_vldtn_id              in     number
  ,p_version_number               in     number    default NULL
  ,p_remuneration_job_description in     varchar2  default NULL
  ,p_tariff_contract_code         in     varchar2
  ,p_tariff_group_code            in     varchar2
  ,p_job_group_id                 in     number    default NULL
  ,p_remuneration_job_id          in     number    default NULL
  ,p_derived_grade_id             in     number    default NULL
  ,p_derived_case_group_id        in     number    default NULL
  ,p_derived_subcasgrp_id         in     number    default NULL
  ,p_user_enterable_grade_id      in     number    default NULL
  ,p_user_enterable_case_group_id in     number    default NULL
  ,p_user_enterable_subcasgrp_id  in     number    default NULL
  ,p_freeze                       in     varchar2  default NULL
  ,p_wrkplc_vldtn_ver_id             out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 134


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

Line: 140


  savepoint insert_vldtn_vern_swi;

Line: 163


  pqh_de_vldver_api.insert_vldtn_vern
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_business_group_id            => p_business_group_id
    ,p_wrkplc_vldtn_id              => p_wrkplc_vldtn_id
    ,p_version_number               => p_version_number
    ,p_remuneration_job_description => p_remuneration_job_description
    ,p_tariff_contract_code         => p_tariff_contract_code
    ,p_tariff_group_code            => p_tariff_group_code
    ,p_job_group_id                 => p_job_group_id
    ,p_remuneration_job_id          => p_remuneration_job_id
    ,p_derived_grade_id             => p_derived_grade_id
    ,p_derived_case_group_id        => p_derived_case_group_id
    ,p_derived_subcasgrp_id         => p_derived_subcasgrp_id
    ,p_user_enterable_grade_id      => p_user_enterable_grade_id
    ,p_user_enterable_case_group_id => p_user_enterable_case_group_id
    ,p_user_enterable_subcasgrp_id  => p_user_enterable_subcasgrp_id
    ,p_freeze                       => p_freeze
    ,p_wrkplc_vldtn_ver_id          => p_wrkplc_vldtn_ver_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 206


    rollback to insert_vldtn_vern_swi;

Line: 222


    rollback to insert_vldtn_vern_swi;

Line: 234


end insert_vldtn_vern;

Line: 238


PROCEDURE update_vldtn_vern
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_business_group_id            in     number
  ,p_wrkplc_vldtn_id              in     number    default hr_api.g_number
  ,p_version_number               in     number    default hr_api.g_number
  ,p_remuneration_job_description in     varchar2  default hr_api.g_varchar2
  ,p_tariff_contract_code         in     varchar2  default hr_api.g_varchar2
  ,p_tariff_group_code            in     varchar2  default hr_api.g_varchar2
  ,p_job_group_id                 in     number    default hr_api.g_number
  ,p_remuneration_job_id          in     number    default hr_api.g_number
  ,p_derived_grade_id             in     number    default hr_api.g_number
  ,p_derived_case_group_id        in     number    default hr_api.g_number
  ,p_derived_subcasgrp_id         in     number    default hr_api.g_number
  ,p_user_enterable_grade_id      in     number    default hr_api.g_number
  ,p_user_enterable_case_group_id in     number    default hr_api.g_number
  ,p_user_enterable_subcasgrp_id  in     number    default hr_api.g_number
  ,p_freeze                       in     varchar2  default hr_api.g_varchar2
  ,p_wrkplc_vldtn_ver_id          in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 268


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

Line: 274


  savepoint update_vldtn_vern_swi;

Line: 295


  pqh_de_vldver_api.update_vldtn_vern
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_business_group_id            => p_business_group_id
    ,p_wrkplc_vldtn_id              => p_wrkplc_vldtn_id
    ,p_version_number               => p_version_number
    ,p_remuneration_job_description => p_remuneration_job_description
    ,p_tariff_contract_code         => p_tariff_contract_code
    ,p_tariff_group_code            => p_tariff_group_code
    ,p_job_group_id                 => p_job_group_id
    ,p_remuneration_job_id          => p_remuneration_job_id
    ,p_derived_grade_id             => p_derived_grade_id
    ,p_derived_case_group_id        => p_derived_case_group_id
    ,p_derived_subcasgrp_id         => p_derived_subcasgrp_id
    ,p_user_enterable_grade_id      => p_user_enterable_grade_id
    ,p_user_enterable_case_group_id => p_user_enterable_case_group_id
    ,p_user_enterable_subcasgrp_id  => p_user_enterable_subcasgrp_id
    ,p_freeze                       => p_freeze
    ,p_wrkplc_vldtn_ver_id          => p_wrkplc_vldtn_ver_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 338


    rollback to update_vldtn_vern_swi;

Line: 353


    rollback to update_vldtn_vern_swi;

Line: 364


end update_vldtn_vern;