APPS.PQH_TCT_BUS SQL Statements

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

Line: 110

    select null
    from   pqh_table_route a
    where  a.table_route_id = p_consolidated_table_route_id;

Line: 186

    select null
    from   pqh_table_route a
    where  a.table_route_id = p_master_table_route_id;

Line: 252

    select null
    from   hr_all_organization_units a
    where  a.organization_id = p_business_group_id;

Line: 646

   Select null
   from pqh_routing_categories a
   where a.transaction_category_id = p_transaction_category_id
     and nvl(a.enable_flag,'N') = 'Y';

Line: 843

   Select count(*)
     From pqh_txn_category_attributes
    Where transaction_category_id = p_transaction_category_id
      AND list_identifying_flag = 'Y';

Line: 886

  sql_stmt := 'Select rct.routing_category_id, count(rng.range_name)'
           || ' from pqh_routing_categories rct,pqh_attribute_ranges rng'
           || ' Where rct.transaction_category_id = :p_transaction_category_id'
           || '   and rct.enable_flag = :p_enable_flag'
           || '   and nvl(rct.default_flag,:dummy1) <> :yes_flag1 '
           || '   and nvl(rct.delete_flag,:dummy2) <> :yes_flag2 ';

Line: 903

           || ' and nvl(rng.delete_flag(+),:dummy3) <> :yes_flag3'
           || ' and rng.routing_list_member_id(+) IS NULL'
           || ' and rng.position_id(+) IS NULL'
           || ' and rng.assignment_id(+) IS NULL'
     || ' group by rct.routing_category_id'
     || ' order by rct.routing_category_id';

Line: 964

     sql_stmt1 :='Select rct.routing_category_id'
             ||' from pqh_routing_categories rct'
             ||' Where rct.transaction_category_id=:p_transaction_category_id'
             ||' and rct.enable_flag = :p_enable_flag'
             ||' and nvl(rct.default_flag,:dummy1) <> :p_default_flag'
             ||' and nvl(rct.delete_flag,:dummy2) <> :p_delete_flag';

Line: 971

     sql_stmt2 := 'Select null from pqh_attribute_ranges'
                ||' Where routing_category_id = :p_routing_category_id'
                ||'   and enable_flag   = :p_enable_flag'
                ||'   and approver_flag = :p_approver_flag';

Line: 1040

    Select decode(RCT.routing_list_id,NULL,decode(RCT.position_structure_id,NULL,hr_general.decode_lookup('PQH_SUPERVISORY_HIERARCHY','SUPERVISORY_HIERARCHY'),PPS.name),RLT.routing_list_name) list_name
      From pqh_routing_categories RCT ,
           pqh_routing_lists RLT,
           per_position_structures PPS
     WHERE RCT.routing_category_id = p_routing_category_id AND
           RCT.routing_list_id = RLT.routing_list_id(+) and
           RCT.position_structure_id = PPS.position_structure_id(+);

Line: 1308

       Select count(*) from pqh_txn_category_attributes tca
       where tca.transaction_category_id = p_transaction_category_id
       AND   tca.list_identifying_flag = 'Y';

Line: 1313

       Select count(*) from pqh_txn_category_attributes tca
       where  tca.transaction_category_id = p_transaction_category_id
       AND    tca.member_identifying_flag = 'Y';

Line: 1377

     select 'Y'
     into l_dummy
     from dual
     where exists ( select null
                    from pqh_worksheets
                    where wf_transaction_category_id = p_transaction_category_id
                      and transaction_status not in ('REJECT','TERMINATE','APPLIED'));

Line: 1385

     select 'Y'
     into l_dummy
     from dual
     where exists ( select null from pqh_budget_pools
                    where wf_transaction_category_id = p_transaction_category_id
                      and approval_status in ('P'));

Line: 1392

     select 'Y'
     into l_dummy
     from dual
     where exists ( select null from pqh_position_transactions
                    where wf_transaction_category_id = p_transaction_category_id
                      and transaction_status not in ('REJECT','TERMINATE','APPLIED'));

Line: 1428

  Select short_name
  into l_short_name
  From   pqh_transaction_categories
  Where  transaction_category_id = p_transaction_category_id;

Line: 1458

  Select tr.from_clause,tr.table_alias,tr.where_clause
  From   pqh_transaction_categories tct,pqh_table_route tr
  Where  tct.transaction_category_id = p_transaction_category_id
    AND  tct.consolidated_table_route_id  = tr.table_route_id;

Line: 1498

       sql_stmt:=  'Select null From '
               ||l_from_clause
               ||' Where '
               ||l_new_where;

Line: 1551

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

Line: 1638

End insert_validate;

Line: 1643

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

Line: 1730

End update_validate;

Line: 1735

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

Line: 1746

End delete_validate;