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

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

Line: 57


Procedure dt_update_dml
        (p_rec                   in out nocopy ghr_dut_shd.g_rec_type,
         p_effective_date        in     date,
         p_datetrack_mode        in     varchar2,
         p_validation_start_date in     date,
         p_validation_end_date   in     date) is
--
  l_proc        varchar2(72) := g_package||'dt_update_dml';

Line: 86


    update  ghr_duty_stations_f
    set
    duty_station_id                 = p_rec.duty_station_id,
    locality_pay_area_id            = p_rec.locality_pay_area_id,
    leo_pay_area_code               = p_rec.leo_pay_area_code,
    name                            = p_rec.name,
    duty_station_code               = p_rec.duty_station_code,
    msa_code                        = p_rec.msa_code  ,
    cmsa_code			    = p_rec.cmsa_code ,
    state_or_country_code           = p_rec.state_or_country_code,
    county_code			    = p_rec.county_code,
    is_duty_station                 = p_rec.is_duty_station
    where   duty_station_id = p_rec.duty_station_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;

Line: 125


End dt_update_dml;

Line: 158


Procedure update_dml
        (p_rec                   in out nocopy ghr_dut_shd.g_rec_type,
         p_effective_date        in     date,
         p_datetrack_mode        in     varchar2,
         p_validation_start_date in     date,
         p_validation_end_date   in     date) is
--
  l_proc        varchar2(72) := g_package||'update_dml';

Line: 170


  dt_update_dml(p_rec                   => p_rec,
                p_effective_date        => p_effective_date,
                p_datetrack_mode        => p_datetrack_mode,
                p_validation_start_date => p_validation_start_date,
                p_validation_end_date   => p_validation_end_date);

Line: 177


End update_dml;

Line: 222


Procedure dt_pre_update
        (p_rec                   in out nocopy ghr_dut_shd.g_rec_type,
         p_effective_date        in     date,
         p_datetrack_mode        in     varchar2,
         p_validation_start_date in     date,
         p_validation_end_date   in     date) is
--
  l_proc                 varchar2(72) := g_package||'dt_pre_update';

Line: 247


    If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
      hr_utility.set_location(l_proc, 15);

Line: 253


      ghr_dut_del.delete_dml
        (p_rec                   => p_rec,
         p_effective_date        => p_effective_date,
         p_datetrack_mode        => p_datetrack_mode,
         p_validation_start_date => p_validation_start_date,
         p_validation_end_date   => p_validation_end_date);

Line: 264


    ghr_dut_ins.insert_dml
      (p_rec                    => p_rec,
       p_effective_date         => p_effective_date,
       p_datetrack_mode         => p_datetrack_mode,
       p_validation_start_date  => p_validation_start_date,
       p_validation_end_date    => p_validation_end_date);

Line: 272


End dt_pre_update;

Line: 307


Procedure pre_update
        (p_rec                   in out nocopy ghr_dut_shd.g_rec_type,
         p_effective_date        in     date,
         p_datetrack_mode        in     varchar2,
         p_validation_start_date in     date,
         p_validation_end_date   in     date) is
--
  l_proc        varchar2(72) := g_package||'pre_update';

Line: 320


  dt_pre_update
    (p_rec                   => p_rec,
     p_effective_date        => p_effective_date,
     p_datetrack_mode        => p_datetrack_mode,
     p_validation_start_date => p_validation_start_date,
     p_validation_end_date   => p_validation_end_date);

Line: 328


End pre_update;

Line: 362


Procedure post_update
        (p_rec                   in ghr_dut_shd.g_rec_type,
         p_effective_date        in date,
         p_datetrack_mode        in varchar2,
         p_validation_start_date in date,
         p_validation_end_date   in date) is
--
  l_proc        varchar2(72) := g_package||'post_update';

Line: 374


  ghr_dut_rku.after_update(
			    p_duty_station_id	    =>  p_rec.duty_station_id
			   ,p_effective_start_date   =>  p_rec.effective_start_date
			   ,p_effective_end_date     =>  p_rec.effective_end_date
			   ,p_locality_pay_area_id   =>  p_rec.locality_pay_area_id
			   ,p_leo_pay_area_code      =>  p_rec.leo_pay_area_code
			   ,p_name                   =>  p_rec.name
			   ,p_duty_station_code      =>  p_rec.duty_station_code
			   ,p_is_duty_station        =>  p_rec.is_duty_station
			   ,p_effective_date         =>  p_effective_date
			   ,p_datetrack_update_mode  =>  p_datetrack_mode
			   ,p_object_version_number  =>  p_rec.object_version_number
			   );

Line: 388


End post_update;

Line: 467


  p_datetrack_update_mode      in      varchar2
  ) is
--
  l_proc                        varchar2(72) := g_package||'upd';

Line: 479


  dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_update_mode);

Line: 485


         p_datetrack_mode        => p_datetrack_update_mode,
         p_duty_station_id        => p_rec.duty_station_id,
         p_object_version_number => p_rec.object_version_number,
         p_validation_start_date => l_validation_start_date,
         p_validation_end_date   => l_validation_end_date);

Line: 498


  ghr_dut_bus.update_validate
        (p_rec                   => p_rec,
         p_effective_date        => p_effective_date,
         p_datetrack_mode        =>p_datetrack_update_mode,
         p_validation_start_date => l_validation_start_date,
         p_validation_end_date   => l_validation_end_date);

Line: 507


  pre_update
        (p_rec                   => p_rec,
         p_effective_date        => p_effective_date,
         p_datetrack_mode        => p_datetrack_update_mode,
         p_validation_start_date => l_validation_start_date,
         p_validation_end_date   => l_validation_end_date);

Line: 516


  update_dml
        (p_rec                   => p_rec,
         p_effective_date        => p_effective_date,
         p_datetrack_mode        => p_datetrack_update_mode,
         p_validation_start_date => l_validation_start_date,
         p_validation_end_date   => l_validation_end_date);

Line: 525


  post_update
        (p_rec                   => p_rec,
         p_effective_date        => p_effective_date,
         p_datetrack_mode        => p_datetrack_update_mode,
         p_validation_start_date => l_validation_start_date,
         p_validation_end_date   => l_validation_end_date);

Line: 552


  p_datetrack_update_mode	 in         varchar2
  ) is
--
  l_rec         ghr_dut_shd.g_rec_type;

Line: 588


  upd(l_rec, p_effective_date, p_datetrack_update_mode);