APPS.PQH_TEM_BUS SQL Statements

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

Line: 168

    select null
    from   pqh_template_attributes a
    where  a.template_id = p_template_id;

Line: 173

    select null
    from   pqh_ref_templates a
    where  a.base_template_id = p_template_id;

Line: 249

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

Line: 330

    select  'x'
    from   fnd_territories_vl a
    where  a.territory_code = p_legislation_code;

Line: 335

  select legislation_code
  from pqh_template_attributes tat, pqh_attributes att
  where tat.template_id = p_template_id
  and tat.attribute_id= att.attribute_id
  and att.legislation_code is not null;

Line: 460

  select null
    from pqh_templates_vl
   where template_name = p_template_name
     and transaction_category_id = p_transaction_category_id
     and template_id <> nvl(p_template_id,0);

Line: 589

 Select null
   from pqh_transaction_templates
  Where template_id = p_template_id;

Line: 677

  End if; /* If update or insert */

Line: 807

  Select role_template_id,object_version_number
    From pqh_role_templates
   Where template_id = p_template_id;

Line: 821

      pqh_role_templates_api.update_role_template(
        p_validate               => false
       ,p_role_template_id       => rec.role_template_id
       ,p_enable_flag            => 'N'
       ,p_object_version_number  => l_object_version_number
       ,p_effective_date         => sysdate  );

Line: 871

    select null
    from pqh_ref_templates a
    where a.parent_template_id = p_template_id
      and a.reference_type_cd = 'REFERENCE';

Line: 1135

    Select  nvl(att.master_attribute_id,att.attribute_id),
            tca.attribute_id,rtrim(att.attribute_name),nvl(tat.attribute_id,-1),
            nvl(tat.view_flag,'N') , nvl(tat.edit_flag,'N')
    From    pqh_txn_category_attributes tca,pqh_attributes_vl att,
            pqh_template_attributes tat
    Where   tca.transaction_category_id = p_transaction_category_id
      AND   tca.attribute_id   = att.attribute_id
      AND   att.attribute_id   = tat.attribute_id(+)
      AND   tat.template_id(+) = p_template_id
    Order by 1,2;

Line: 1147

 Select rtrim(attribute_name)
   from pqh_attributes_vl
  Where attribute_id = p_attribute_id;

Line: 1418

    Select null
      from pqh_transaction_templates tt
     Where tt.template_id = p_template_id
       AND tt.transaction_id in (Select ptx.position_transaction_id
                                From pqh_position_transactions ptx
                               Where nvl(ptx.transaction_status,'PENDING') in
                                     ('APPROVED','SUBMITTED','PENDING'));

Line: 1458

   Select null from pqh_template_attributes
    Where template_id = p_template_id;

Line: 1463

   Select null from pqh_template_attributes
    Where template_id = p_template_id
      AND (view_flag is NOT NULL OR
           edit_flag IS NOT NULL OR
           required_flag IS NOT NULL);

Line: 1470

   Select null from pqh_ref_templates
    Where parent_template_id = p_template_id
      and reference_type_cd = 'COPY';

Line: 1475

   Select null from pqh_ref_templates
    Where parent_template_id = p_template_id
      and reference_type_cd = 'REFERENCE';

Line: 1656

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

Line: 1729

End insert_validate;

Line: 1734

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

Line: 1822

End update_validate;

Line: 1827

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

Line: 1839

End delete_validate;