APPS.HR_QSN_BUS SQL Statements

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

Line: 30

    select inf.org_information14
      from hr_organization_information inf
         , hr_questionnaires                qsn
     where qsn.questionnaire_template_id = p_questionnaire_template_id
       and inf.organization_id   = qsn.business_group_id(+)
       and inf.org_information_context || '' = 'Business Group Information';

Line: 68

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

Line: 122

end chk_non_updateable_args;

Line: 139

    select null
    from hr_questionnaires
    where name = p_name
    and ((p_business_group_id is null and business_group_id is null)
    or business_group_id = p_business_group_id);

Line: 283

procedure chk_row_delete
  (p_questionnaire_template_id in hr_questionnaires.questionnaire_template_id%TYPE)
  is
  --
  l_proc   varchar2(72) := g_package || 'chk_row_delete';

Line: 293

    select null
      from hr_quest_fields qsf
     where qsf.questionnaire_template_id = p_questionnaire_template_id;

Line: 327

end chk_row_delete;

Line: 331

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

Line: 365

End insert_validate;

Line: 370

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

Line: 389

  chk_non_updateable_args(p_rec);

Line: 398

End update_validate;

Line: 403

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

Line: 412

  chk_row_delete(p_questionnaire_template_id => p_rec.questionnaire_template_id);

Line: 414

End delete_validate;

Line: 426

     select pbg.legislation_code
       from per_business_groups pbg
    , hr_questionnaires qsn
      where qsn.questionnaire_template_id = p_questionnaire_template_id
  and pbg.business_group_id = qsn.business_group_id;