APPS.PER_CPO_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , per_competence_outcomes cpo
     where cpo.outcome_id = p_outcome_id;

Line: 98

    select pbg.legislation_code
      from per_business_groups_perf     pbg
         , per_competence_outcomes cpo
     where cpo.outcome_id = p_outcome_id;

Line: 185

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

Line: 207

End chk_non_updateable_args;

Line: 320

     select '1' from per_competences
     where  competence_id  = p_competence_id;

Line: 424

     select null from per_competence_outcomes
     where  competence_id = p_competence_id
     and    outcome_number = p_outcome_number
     and   (p_date_from <= nvl(date_to, hr_api.g_eot)
             and NVL(p_date_to, hr_api.g_eot) >= date_from);

Line: 431

     select null from per_competence_outcomes
     where   outcome_id <> p_outcome_id
     and     competence_id = p_competence_id
     and     outcome_number = p_outcome_number
     and    (p_date_from <= nvl(date_to, hr_api.g_eot)
              and NVL(p_date_to, hr_api.g_eot) >= date_from);

Line: 553

     select null from per_competence_outcomes
     where  competence_id = p_competence_id
     and    name = p_name
     and   (p_date_from <= nvl(date_to, hr_api.g_eot)
             and NVL(p_date_to, hr_api.g_eot) >= date_from);

Line: 560

     select null from per_competence_outcomes
     where  outcome_id <> p_outcome_id
     and    competence_id = p_competence_id
     and    name = p_name
     and   (p_date_from <= nvl(date_to, hr_api.g_eot)
             and NVL(p_date_to, hr_api.g_eot) >= date_from);

Line: 743

PROCEDURE chk_delete(
   p_outcome_id         in per_competence_outcomes.outcome_id%TYPE
 ) is
  --
  l_proc         varchar2(72) := g_package||'chk_delete';

Line: 751

           select 'x'
           FROM per_comp_element_outcomes
           WHERE outcome_id = p_outcome_id;

Line: 778

end chk_delete;

Line: 1055

Procedure insert_validate
  (p_effective_date               in date
  ,p_rec                          in per_cpo_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1149

End insert_validate;

Line: 1154

Procedure update_validate
  (p_effective_date               in date
  ,p_rec                          in per_cpo_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1238

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

Line: 1252

End update_validate;

Line: 1257

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

Line: 1268

  chk_delete
  (p_outcome_id    => p_rec.outcome_id
  );

Line: 1281

End delete_validate;