APPS.PER_PML_BUS SQL Statements

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

Line: 215

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in per_pml_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 237

End chk_non_updateable_args;

Line: 277

    select 'Y', nvl(valid_from,to_date('01/01/0001','MM/DD/YYYY')),nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY'))
    from  per_objectives_library pml
    where pml.objective_id <> nvl(p_objective_id, hr_api.g_number)
    and   upper(trim(pml.objective_name)) = upper(trim(p_objective_name))
    and
    (
         (
           nvl(valid_from,to_date('01/01/0001','MM/DD/YYYY')) between c_p_valid_from and c_p_valid_to
           or
           nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY')) between c_p_valid_from and c_p_valid_to
          )
          or
          (
            c_p_valid_from between nvl(valid_from,to_date('01/01/0001','MM/DD/YYYY'))
                        and nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY'))
           or c_p_valid_to between nvl( valid_from,to_date('01/01/0001','MM/DD/YYYY'))
                         and nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY'))
          )
    ) order by valid_from,valid_to;

Line: 1550

Procedure insert_validate
  (p_effective_date               in  date
  ,p_rec                          in  per_pml_shd.g_rec_type
  ,p_duplicate_name_warning       out nocopy boolean
  ,p_weighting_over_100_warning   out nocopy boolean
  ,p_weighting_appraisal_warning  out nocopy boolean
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1730

End insert_validate;

Line: 1736

Procedure update_validate
  (p_effective_date              in  date
  ,p_rec                         in  per_pml_shd.g_rec_type
  ,p_duplicate_name_warning      out nocopy boolean
  ,p_weighting_over_100_warning  out nocopy boolean
  ,p_weighting_appraisal_warning out nocopy boolean
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1755

  chk_non_updateable_args
    (p_effective_date     => p_effective_date
    ,p_rec              => p_rec);

Line: 1918

End update_validate;

Line: 1924

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

Line: 1936

End delete_validate;