APPS.HR_SCL_UPD SQL Statements

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

Line: 42

  If (p_rec.program_update_date = hr_api.g_date) then
    p_rec.program_update_date :=
    hr_scl_shd.g_old_rec.program_update_date;

Line: 230

          p_program_update_date    in     date     default hr_api.g_date,
          p_soft_coding_keyflex_id in out nocopy number,
          p_concatenated_segments     out nocopy varchar2,
          p_validate               in     boolean default false) is
--
  l_proc          varchar2(72) := g_package||'upd_or_sel';

Line: 250

       p_program_update_date,
       null,
       null,
       null,
       null,
       null,
       p_segment1,
       p_segment2,
       p_segment3,
       p_segment4,
       p_segment5,
       p_segment6,
       p_segment7,
       p_segment8,
       p_segment9,
       p_segment10,
       p_segment11,
       p_segment12,
       p_segment13,
       p_segment14,
       p_segment15,
       p_segment16,
       p_segment17,
       p_segment18,
       p_segment19,
       p_segment20,
       p_segment21,
       p_segment22,
       p_segment23,
       p_segment24,
       p_segment25,
       p_segment26,
       p_segment27,
       p_segment28,
       p_segment29,
       p_segment30);

Line: 406

    if (l_rec.program_update_date = hr_api.g_date) then
      l_rec.program_update_date := null;

Line: 449

     p_program_update_date    => l_rec.program_update_date,
     p_soft_coding_keyflex_id => l_rec.soft_coding_keyflex_id,
     p_concatenated_segments  => l_rec.concatenated_segments,
     p_validate               => p_validate);