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

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

Line: 68


    select
     step_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,spinal_point_id
    ,grade_spine_id
    ,sequence
    ,request_id
    ,program_application_id
    ,program_id
    ,program_update_date
    ,information1
    ,information2
    ,information3
    ,information4
    ,information5
    ,information6
    ,information7
    ,information8
    ,information9
    ,information10
    ,information11
    ,information12
    ,information13
    ,information14
    ,information15
    ,information16
    ,information17
    ,information18
    ,information19
    ,information20
    ,information21
    ,information22
    ,information23
    ,information24
    ,information25
    ,information26
    ,information27
    ,information28
    ,information29
    ,information30
    ,information_category
    ,object_version_number
    from        per_spinal_point_steps_f
    where       step_id = p_step_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 174


  ,p_update                 out nocopy boolean
  ,p_update_override        out nocopy boolean
  ,p_update_change_insert   out nocopy boolean
  ) is
--
  l_proc        varchar2(72) := g_package||'find_dt_upd_modes';

Line: 192


    ,p_update                => p_update
    ,p_update_override       => p_update_override
    ,p_update_change_insert  => p_update_change_insert
    );

Line: 207


  ,p_delete                out nocopy boolean
  ,p_future_change         out nocopy boolean
  ,p_delete_next_change    out nocopy boolean
  ) is
  --
  l_proc                varchar2(72)    := g_package||'find_dt_del_modes';

Line: 217


    select
     t.grade_spine_id
    from   per_spinal_point_steps_f t
    where  t.step_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 249


   ,p_delete                        => p_delete
   ,p_future_change                 => p_future_change
   ,p_delete_next_change            => p_delete_next_change
   );

Line: 291


  update  per_spinal_point_steps_f t
  set     t.effective_end_date    = p_new_effective_end_date
    ,     t.object_version_number = l_object_version_number
  where   t.step_id        = p_base_key_value
  and     p_effective_date
  between t.effective_start_date and t.effective_end_date;

Line: 330


    select
     step_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,spinal_point_id
    ,grade_spine_id
    ,sequence
    ,request_id
    ,program_application_id
    ,program_id
    ,program_update_date
    ,information1
    ,information2
    ,information3
    ,information4
    ,information5
    ,information6
    ,information7
    ,information8
    ,information9
    ,information10
    ,information11
    ,information12
    ,information13
    ,information14
    ,information15
    ,information16
    ,information17
    ,information18
    ,information19
    ,information20
    ,information21
    ,information22
    ,information23
    ,information24
    ,information25
    ,information26
    ,information27
    ,information28
    ,information29
    ,information30
    ,information_category
    ,object_version_number
    from    per_spinal_point_steps_f
    where   step_id = p_step_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 411


  If (p_datetrack_mode <> hr_api.g_insert) then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;

Line: 507


  ,p_program_update_date            in date
  ,p_information1                   in varchar2
  ,p_information2                   in varchar2
  ,p_information3                   in varchar2
  ,p_information4                   in varchar2
  ,p_information5                   in varchar2
  ,p_information6                   in varchar2
  ,p_information7                   in varchar2
  ,p_information8                   in varchar2
  ,p_information9                   in varchar2
  ,p_information10                  in varchar2
  ,p_information11                  in varchar2
  ,p_information12                  in varchar2
  ,p_information13                  in varchar2
  ,p_information14                  in varchar2
  ,p_information15                  in varchar2
  ,p_information16                  in varchar2
  ,p_information17                  in varchar2
  ,p_information18                  in varchar2
  ,p_information19                  in varchar2
  ,p_information20                  in varchar2
  ,p_information21                  in varchar2
  ,p_information22                  in varchar2
  ,p_information23                  in varchar2
  ,p_information24                  in varchar2
  ,p_information25                  in varchar2
  ,p_information26                  in varchar2
  ,p_information27                  in varchar2
  ,p_information28                  in varchar2
  ,p_information29                  in varchar2
  ,p_information30                  in varchar2
  ,p_information_category           in varchar2
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 559


  l_rec.program_update_date              := p_program_update_date;