APPS.PQH_RLS_BUS SQL Statements

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

Line: 28

select 'Y'
from   pqh_roles
where  role_type_cd = decode(p_role_type_cd,'PQH_EXCL','PQH_INCL','PQH_EXCL')
and    enable_flag  = 'Y'
and    business_group_id = p_business_group_id;

Line: 35

select 'Y'
from   pqh_roles
where  role_type_cd = decode(p_role_type_cd,'PQH_EXCL','PQH_INCL','PQH_EXCL')
and    enable_flag  = 'Y'
and    business_group_id is null;

Line: 77

    select pbg.security_group_id
      from per_business_groups pbg
         ,pqh_roles rls
     where
       rls.role_id = p_role_id
       and pbg.business_group_id = rls.business_group_id;

Line: 138

    select pbg.legislation_code
      from per_business_groups pbg
         ,pqh_roles rls
     where
       rls.role_id = p_role_id
       and pbg.business_group_id = rls.business_group_id;

Line: 227

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

Line: 261

End chk_non_updateable_args;

Line: 368

SELECT count(*)
FROM pqh_position_roles_v
WHERE role_id = p_role_id;

Line: 373

SELECT role_name
FROM pqh_roles
WHERE role_id = p_role_id;

Line: 551

      select count(*) into  l_role_assign_count
      from per_people_extra_info pei
      where pei.information_type='PQH_ROLE_USERS'
      and pei.pei_information3=p_role_id;

Line: 581

select 'X'
from pqh_roles
where role_name = p_role_name
  and role_id <> nvl(p_role_id,0);

Line: 609

Procedure chk_role_delete (p_role_id                in number ) is
  --
  l_proc         varchar2(72) := g_package||'chk_role_delete';

Line: 620

select count(*)
from pqh_role_templates
where role_id = NVL(p_role_id,0)
  and nvl(enable_flag,'N') = 'Y';

Line: 626

select count(*)
from pqh_position_roles_v
where role_id = NVL(p_role_id,0);

Line: 631

select count(*)
from pqh_role_users_v
where role_id = NVL(p_role_id,0);

Line: 636

select count(*)
from pqh_routing_list_members
where role_id = NVL(p_role_id,0);

Line: 662

       hr_utility.set_message(8302,'PQH_DELETE_ROLE');

Line: 670

       hr_utility.set_message(8302,'PQH_DELETE_ROLE');

Line: 678

       hr_utility.set_message(8302,'PQH_DELETE_ROLE');

Line: 686

       hr_utility.set_message(8302,'PQH_DELETE_ROLE');

Line: 695

end chk_role_delete;

Line: 709

  select distinct ptc.transaction_category_id, ptc.name transaction_category,
         ptc.business_group_id
  from pqh_routing_list_members rlm, pqh_routing_categories rct,
       pqh_transaction_categories ptc
  where rlm.routing_list_id =  rct.routing_list_id
  and rlm.role_id = p_role_id
  and rct.transaction_category_id=ptc.transaction_category_id;

Line: 758

  select distinct transaction_category_id
  from pqh_routing_list_members rlm, pqh_routing_categories rct
  where (rlm.routing_list_id =  rct.routing_list_id
  and rlm.user_id = p_user_id
  and rlm.role_id = p_role_id)
  or (rct.override_user_id = p_user_id and rct.override_role_id = p_role_id) ;

Line: 967

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

Line: 1018

End insert_validate;

Line: 1023

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

Line: 1060

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

Line: 1080

End update_validate;

Line: 1085

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

Line: 1098

  chk_role_delete
  (p_role_id          => p_rec.role_id );

Line: 1108

End delete_validate;