APPS.PQH_TCA_SHD SQL Statements

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

Line: 70

    select
		txn_category_attribute_id,
	attribute_id,
	transaction_category_id,
	value_set_id,
	object_version_number,
	transaction_table_route_id,
	form_column_name,
	identifier_flag,
	list_identifying_flag,
	member_identifying_flag,
	refresh_flag,
        select_flag,
	value_style_cd
    from	pqh_txn_category_attributes
    where	txn_category_attribute_id = p_txn_category_attribute_id;

Line: 153

    select 	txn_category_attribute_id,
	attribute_id,
	transaction_category_id,
	value_set_id,
	object_version_number,
	transaction_table_route_id,
	form_column_name,
	identifier_flag,
	list_identifying_flag,
	member_identifying_flag,
	refresh_flag,
        select_flag,
	value_style_cd
    from	pqh_txn_category_attributes
    where	txn_category_attribute_id = p_txn_category_attribute_id
    for	update nowait;

Line: 229

        p_select_flag                   in varchar2,
	p_value_style_cd                in varchar2
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 254

  l_rec.select_flag                      := p_select_flag ;

Line: 279

  ,p_select_flag                    in  varchar2
  ,p_value_style_cd                 in  varchar2
  ,p_legislation_code               in  varchar2
  ,p_copy_to_bg_attr                in  varchar2
  ,p_owner                          in  varchar2
  ,p_last_update_date               in  varchar2
 ) is
--
--
   l_effective_date           date  := sysdate ;

Line: 291

   l_delete_attr_ranges_flag  varchar2(30) := 'N';

Line: 301

   l_last_updated_by            pqh_attributes.last_updated_by%TYPE;

Line: 303

   l_last_update_date           pqh_attributes.last_update_date%TYPE;

Line: 304

   l_last_update_login          pqh_attributes.last_update_login%TYPE;

Line: 306

   cursor c1 is select userenv('LANG') from dual ;

Line: 314

 select attribute_id
 from pqh_attributes
 where key_column_name = p_column_name
   and nvl(master_table_route_id,-999) = nvl(p_table_id, -999)
   and nvl(legislation_code,'$$$') = nvl(p_legislation_code, '$$$');

Line: 321

 select table_route_id
 from pqh_table_route
 where table_alias = p_table_alias;

Line: 326

 select transaction_category_id
 from pqh_transaction_categories
 where short_name = p_tran_cat_short_name
 and   business_group_id is null;

Line: 332

 select txn_category_attribute_id
 from pqh_txn_category_attributes
 where attribute_id = p_attribute_id
   and transaction_category_id = p_txn_category_id;

Line: 338

 select flex_value_set_id
 from fnd_flex_value_sets
 where flex_value_set_name = p_value_set_name;

Line: 344

     select transaction_category_id
     from pqh_transaction_categories
     where short_name = p_tran_cat_short_name
     and   business_group_id is not null;

Line: 402

    l_last_updated_by := -1;

Line: 405

    l_last_updated_by := 0;

Line: 408

  l_last_updated_by := fnd_load_util.owner_id(p_owner);

Line: 410

  l_creation_date := nvl(to_date(p_last_update_date,'YYYY/MM/DD'),trunc(sysdate));

Line: 411

  l_last_update_date := nvl(to_date(p_last_update_date,'YYYY/MM/DD'),trunc(sysdate));

Line: 414

  l_last_update_date := sysdate;

Line: 416

  l_last_update_login := 0;

Line: 420

     UPDATE pqh_txn_category_attributes
     SET value_set_id  = l_flex_value_set_id,
         transaction_table_route_id     =  l_transaction_table_route_id,
         form_column_name               =  p_form_column_name,
         identifier_flag                =  p_identifier_flag,
--         list_identifying_flag          =  p_list_identifying_flag,
--         member_identifying_flag        =  p_member_identifying_flag,
         refresh_flag                   =  p_refresh_flag,
         value_style_cd                 =  p_value_style_cd,
         select_flag                    =  p_select_flag,
         last_updated_by                =  l_last_updated_by,
         last_update_date               =  l_last_update_date,
         last_update_login              =  l_last_update_login
      WHERE txn_category_attribute_id = l_txn_category_attribute_id;

Line: 443

     UPDATE pqh_txn_category_attributes
     SET value_set_id  = l_flex_value_set_id,
         transaction_table_route_id     =  l_transaction_table_route_id,
         form_column_name               =  p_form_column_name,
         identifier_flag                =  p_identifier_flag,
         refresh_flag                   =  p_refresh_flag,
         value_style_cd                 =  p_value_style_cd,
         select_flag                    =  p_select_flag,
         last_updated_by                =  l_last_updated_by,
         last_update_date               =  l_last_update_date,
         last_update_login              =  l_last_update_login
      WHERE attribute_id = l_attribute_id
--         AND NVL(last_updated_by,-1) in (1,-1);

Line: 457

           select transaction_category_id
             from pqh_transaction_categories
            where short_name = p_tran_cat_short_name
              and business_group_id is not null);

Line: 467

     select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;

Line: 469

      INSERT INTO pqh_txn_category_attributes
       (txn_category_attribute_id,
        attribute_id,
        transaction_category_id,
        value_set_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date ,
        last_update_login,
        object_version_number,
        transaction_table_route_id,
        form_column_name,
        identifier_flag,
        list_identifying_flag,
        member_identifying_flag,
        refresh_flag,
        select_flag,
        value_style_cd)
     VALUES
       (l_txn_category_attribute_id,
        l_attribute_id,
        l_transaction_category_id,
        l_flex_value_set_id,
        l_created_by,
        l_creation_date,
        l_last_updated_by,
        l_last_update_date ,
        l_last_update_login,
        l_object_version_number,
        l_transaction_table_route_id,
        p_form_column_name,
        p_identifier_flag,
        p_list_identifying_flag,
        p_member_identifying_flag,
        p_refresh_flag,
        p_select_flag,
        p_value_style_cd);

Line: 515

        select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;

Line: 517

        INSERT INTO pqh_txn_category_attributes
       (txn_category_attribute_id,
        attribute_id,
        transaction_category_id,
        value_set_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date ,
        last_update_login,
        object_version_number,
        transaction_table_route_id,
        form_column_name,
        identifier_flag,
        list_identifying_flag,
        member_identifying_flag,
        refresh_flag,
        select_flag,
        value_style_cd)
        VALUES
       (l_txn_category_attribute_id,
        l_attribute_id,
        l_transaction_category_id,
        l_flex_value_set_id,
        l_created_by,
        l_creation_date,
        l_last_updated_by,
        l_last_update_date ,
        l_last_update_login,
        l_object_version_number,
        l_transaction_table_route_id,
        p_form_column_name,
        p_identifier_flag,
        p_list_identifying_flag,
        p_member_identifying_flag,
        p_refresh_flag,
        p_select_flag,
        p_value_style_cd);