APPS.PQH_RCT_BUS SQL Statements

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

Line: 113

    select null
    from   pqh_transaction_categories a
    where  a.transaction_category_id = p_transaction_category_id;

Line: 362

Procedure chk_delete_flag (p_routing_category_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: 380

      and p_delete_flag
      <> nvl(pqh_rct_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: 404

end chk_delete_flag;

Line: 426

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

Line: 503

          hr_utility.set_message(8302,'PQH_NO_UPDATE_ROUT_CAT');

Line: 513

          hr_utility.set_message(8302,'PQH_NO_INSERT_ROUT_CAT');

Line: 564

    select a.member_cd
    from   pqh_transaction_categories a
    where  a.transaction_category_id = p_transaction_category_id;

Line: 569

    select null
    from pqh_attribute_ranges
    where routing_category_id = p_routing_category_id;

Line: 768

    select nvl(enable_flag,'N')
    from   pqh_routing_lists a
    where  a.routing_list_id = p_routing_list_id;

Line: 854

    select nvl(enable_flag,'N')
    from   pqh_roles a
    where  a.role_id = p_override_role_id;

Line: 945

    select null
    from   fnd_user a
    where  a.user_id = p_override_user_id;

Line: 950

    select null
      from pqh_role_users_v
     Where user_id = p_override_user_id
       and role_id = p_override_role_id;

Line: 1062

    select null
    from   per_position_structures a
    where  a.position_structure_id = p_position_structure_id;

Line: 1138

   select null
   from   hr_all_positions_f a
   where  a.position_id = p_override_position_id;

Line: 1144

 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_override_position_id or
        e.parent_position_id = p_override_position_id);

Line: 1236

  Select member_cd
    From pqh_transaction_categories
   Where transaction_category_id = p_transaction_category_id;

Line: 1283

     sql_stmt := 'select b.routing_category_id,RLT.routing_list_name list_name,';

Line: 1285

     sql_stmt := 'select b.routing_category_id,PPS.name list_name,';

Line: 1287

     sql_stmt := 'select b.routing_category_id,hr_general.decode_lookup('
                ||''''||'PQH_SUPERVISORY_HIERARCHY'||''''||','
                ||''''||'SUPERVISORY_HIERARCHY'||''''||'),';

Line: 1295

                       ||' and nvl(b.default_flag,:null_val) <> :p_default_flag and nvl(b.delete_flag,:null_val2) <> :p_delete_flag and b.routing_category_id = a.routing_category_id(+) ';

Line: 1434

  sql_stmt := 'Select routing_category_id from pqh_routing_categories where transaction_category_id = :t';

Line: 1471

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

Line: 1523

  chk_delete_flag
  (p_routing_category_id          => p_rec.routing_category_id,
   p_delete_flag                 => p_rec.delete_flag,
   p_effective_date               => p_effective_date,
   p_object_version_number        => p_rec.object_version_number);

Line: 1557

End insert_validate;

Line: 1562

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

Line: 1607

  chk_delete_flag
  (p_routing_category_id          => p_rec.routing_category_id,
   p_delete_flag                 => p_rec.delete_flag,
   p_effective_date               => p_effective_date,
   p_object_version_number        => p_rec.object_version_number);

Line: 1642

End update_validate;

Line: 1647

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

Line: 1658

End delete_validate;