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.OTA_TAV_BUS SQL Statements

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

Line: 220


PROCEDURE chk_competency_update_level (p_activity_version_id                     IN number
                                   ,p_object_version_number                IN NUMBER
                                   ,p_competency_update_level                 IN VARCHAR2
                                   ,p_effective_date                       IN date) IS

--
  l_proc  VARCHAR2(72) := g_package||'chk_competency_update_level';

Line: 245


       NVL(ota_tav_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
         NVL(p_competency_update_level, hr_api.g_varchar2))
     OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN

       hr_utility.set_location(' Leaving:'||l_proc, 20);

Line: 252


       IF p_competency_update_level IS NOT NULL THEN
          IF hr_api.not_exists_in_hr_lookups
             (p_effective_date => p_effective_date
              ,p_lookup_type => 'OTA_COMPETENCY_UPDATE_LEVEL'
              ,p_lookup_code => p_competency_update_level) THEN
              fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');

Line: 272


                (p_associated_column1   => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN

                     hr_utility.set_location(' Leaving:'||l_proc, 42);

Line: 280


END chk_competency_update_level;

Line: 487


Procedure check_dates_update_ple
  (
   p_activity_version_id   in    number
  ,p_start_date            in    date
  ,p_end_date              in    date
  ) is
  --
  v_start_date            date;

Line: 496


  v_proc                  varchar2(72) := g_package||'check_dates_update_ple';

Line: 499


    select start_date
         , end_date
      from ota_price_list_entries    ple
     where ple.activity_version_id   = p_activity_version_id;

Line: 512


  ota_tav_api_business_rules.check_dates_update_ple( p_activity_version_id
                                                   , p_start_date
                                                   , p_end_date );

Line: 529


End check_dates_update_ple;

Line: 541


Procedure check_dates_update_tbd
  (
   p_activity_version_id   in    number
  ,p_start_date            in    date
  ,p_end_date              in    date
  ) is
  --
  v_proc                  varchar2(72) := g_package||'check_dates_update_tbd';

Line: 557


  ota_tav_api_business_rules.check_dates_update_tbd( p_activity_version_id
                                                   , p_start_date
                                                   , p_end_date );

Line: 574


End check_dates_update_tbd;

Line: 589


Procedure check_dates_update_evt
  (
   p_activity_version_id   in    number
  ,p_start_date            in    date
  ,p_end_date              in    date
  ) is
  --
  v_proc                  varchar2(72) := g_package||'check_dates_update_evt';

Line: 605


  ota_tav_api_business_rules.check_dates_update_evt( p_activity_version_id
                                                   , p_start_date
                                                   , p_end_date );

Line: 622


End check_dates_update_evt;

Line: 634


Procedure check_dates_update_tpm
  (
   p_activity_version_id   in    number
  ,p_start_date            in    date
  ,p_end_date              in    date
  ) is
  --
  v_proc                  varchar2(72) := g_package||'check_dates_update_tpm';

Line: 668


End check_dates_update_tpm;

Line: 1382


select cat.parent_cat_usage_id
from
ota_activity_definitions oad,
ota_category_usages cat
where
oad.category_usage_id=cat.category_usage_id
and oad.activity_id=p_activity_id;

Line: 1411


                (p_associated_column1   => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN

                     hr_utility.set_location(' Leaving:'||l_proc, 30);

Line: 1425


Procedure insert_validate(p_rec in ota_tav_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1482


  chk_competency_update_level (p_activity_version_id        => p_rec.activity_version_id
              ,p_object_version_number   => p_rec.object_version_number
              ,p_competency_update_level        => p_rec.competency_update_level
              ,p_effective_date          => trunc(sysdate));

Line: 1528


End insert_validate;

Line: 1534


Procedure update_validate(p_rec in ota_tav_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1664


chk_competency_update_level (p_activity_version_id        => p_rec.activity_version_id
              ,p_object_version_number   => p_rec.object_version_number
              ,p_competency_update_level        => p_rec.competency_update_level
              ,p_effective_date          => trunc(sysdate));

Line: 1710


    check_dates_update_ple( p_rec.activity_version_id
                          , p_rec.start_date
                          , p_rec.end_date );

Line: 1715


  ota_tav_api_business_rules.check_dates_update_rud( p_rec.activity_version_id
                                                   , p_rec.start_date
                                                   , p_rec.end_date
                                          , ota_tav_shd.g_old_rec.start_date
                                          , ota_tav_shd.g_old_rec.end_date
                                                   );

Line: 1722


    check_dates_update_tbd( p_rec.activity_version_id
                          , p_rec.start_date
                          , p_rec.end_date );

Line: 1726


    check_dates_update_evt( p_rec.activity_version_id
                          , p_rec.start_date
                          , p_rec.end_date );

Line: 1737


    check_dates_update_tpm
                          (p_rec.activity_version_id
                          ,p_rec.start_date
                          ,p_rec.end_date);

Line: 1845


End update_validate;

Line: 1850


Procedure delete_validate(p_rec in ota_tav_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1876


End delete_validate;

Line: 1894


          select legislation_code
          from   per_business_groups      pbg,
                 ota_activity_versions    oav,
                 ota_activity_definitions oad
          where  pbg.business_group_id    = oad.business_group_id
            and  oad.activity_id          = oav.activity_id
            and  oav.activity_version_id  = p_activity_version_id;