APPS.PQH_RNG_BUS SQL Statements

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

Line: 110

    select null
    from   per_all_positions a
    where  a.position_id = p_position_id;

Line: 189

    select transaction_category_id
    from   pqh_routing_categories a
    where  a.routing_category_id = p_routing_category_id;

Line: 194

  select nvl(freeze_status_cd,hr_api.g_varchar2)
  from   pqh_transaction_categories a
  where  a.transaction_category_id = l_tcat;

Line: 278

    select null
    from   pqh_routing_list_members a
    where  a.routing_list_member_id = p_routing_list_member_id;

Line: 367

    select nvl(routing_list_id,hr_api.g_number),
           nvl(position_structure_id,hr_api.g_number)
    from   pqh_routing_categories a
    where  a.routing_category_id = p_routing_category_id;

Line: 373

    Select nvl(routing_list_id,hr_api.g_number),nvl(enable_flag,'N')
    from   pqh_routing_list_members a
    where  a.routing_list_member_id = p_routing_list_member_id;

Line: 378

 select null
  from per_pos_structure_versions v, per_pos_structure_elements e
 where v.position_structure_id = p_position_structure_id
   and sysdate between v.date_from and
                   nvl(v.date_to,to_date('31-12-4712','dd-mm-RRRR'))
   and v.pos_structure_version_id = e.pos_structure_version_id
   and (e.subordinate_position_id = p_position_id or
        e.parent_position_id = p_position_id);

Line: 388

  Select 'x'
    From pqh_attribute_ranges
   Where attribute_id = p_attribute_id
     and range_name = p_range_name
     and routing_category_id = p_routing_category_id
     and routing_list_member_id = p_routing_list_member_id;

Line: 550

    select null
    from   pqh_attributes a
    where  a.attribute_id = p_attribute_id;

Line: 650

    select transaction_category_id
    from   pqh_routing_categories a
    where  a.routing_category_id = p_routing_category_id;

Line: 655

    select att.attribute_name,nvl(att.column_type,hr_api.g_varchar2),
           tca.transaction_category_id,
           nvl(tca.list_identifying_flag,hr_api.g_varchar2),
           nvl(tca.member_identifying_flag,hr_api.g_varchar2)
    from   pqh_txn_category_attributes tca,pqh_attributes att
    where  att.attribute_id = p_attribute_id
      AND  tca.attribute_id = att.attribute_id
      AND  tca.transaction_category_id = p_transaction_category_id;

Line: 852

 Select nvl(enable_flag,'N')
   From pqh_routing_list_members
  Where routing_list_id = p_routing_list_id
    And routing_list_member_id = p_routing_list_member_id;

Line: 915

    select nvl(routing_list_id,hr_api.g_number)
    from   pqh_routing_categories a
    where  a.routing_category_id = p_routing_category_id;

Line: 1014

Procedure chk_delete_flag(p_attribute_range_id          in number,
                          p_delete_flag                 in varchar2,
                          p_effective_date              in date,
                          p_object_version_number       in number) is
  --
  l_proc         varchar2(72) := g_package||'chk_delete_flag';

Line: 1031

      and p_delete_flag
      <> nvl(pqh_rng_shd.g_old_rec.delete_flag,hr_api.g_varchar2)
      or not l_api_updating)
      and p_delete_flag is not null then
    --
    -- check if value of lookup falls within lookup type.
    --
    if hr_api.not_exists_in_hr_lookups
          (p_lookup_type    => 'YES_NO',
           p_lookup_code    => p_delete_flag,
           p_effective_date => p_effective_date) then
      --
      -- raise error as does not exist as lookup
      --
      hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

Line: 1055

end chk_delete_flag;

Line: 1060

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

Line: 1118

  chk_delete_flag
  (p_attribute_range_id          => p_rec.attribute_range_id,
   p_delete_flag                 => p_rec.delete_flag,
   p_effective_date              => p_effective_date,
   p_object_version_number       => p_rec.object_version_number);

Line: 1142

End insert_validate;

Line: 1147

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

Line: 1206

  chk_delete_flag
  (p_attribute_range_id          => p_rec.attribute_range_id,
   p_delete_flag                 => p_rec.delete_flag,
   p_effective_date              => p_effective_date,
   p_object_version_number       => p_rec.object_version_number);

Line: 1229

End update_validate;

Line: 1234

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

Line: 1245

End delete_validate;