APPS.PQH_TCT_SHD SQL Statements

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

Line: 83

    select
	transaction_category_id,
	custom_wf_process_name,
	custom_workflow_name,
	form_name,
	freeze_status_cd,
	future_action_cd,
	member_cd,
	name,
        short_name,
	post_style_cd,
	post_txn_function,
	route_validated_txn_flag,
        prevent_approver_skip,
        workflow_enable_flag,
        enable_flag,
	timeout_days,
	object_version_number,
	consolidated_table_route_id	,
        business_group_id,
        setup_type_cd,
        master_table_route_id
    from	pqh_transaction_categories
    where	transaction_category_id = p_transaction_category_id;

Line: 174

    select 	transaction_category_id,
	custom_wf_process_name,
	custom_workflow_name,
	form_name,
	freeze_status_cd,
	future_action_cd,
	member_cd,
	name,
        short_name,
	post_style_cd,
	post_txn_function,
	route_validated_txn_flag,
	prevent_approver_skip,
        workflow_enable_flag,
        enable_flag,
	timeout_days,
	object_version_number,
	consolidated_table_route_id,
        business_group_id,
        setup_type_cd,
        master_table_route_id
    from	pqh_transaction_categories
    where	transaction_category_id = p_transaction_category_id
    for	update nowait;

Line: 331

  ,p_last_update_date               in  varchar2
  ) is
--
--
l_data_migrator_mode varchar2(1);

Line: 369

            ,p_last_update_date             => p_last_update_date);

Line: 398

  ,p_last_update_date               in  varchar2
  ) is
--
   l_effective_date            date  := sysdate ;

Line: 413

   l_last_updated_by            pqh_transaction_categories.last_updated_by%TYPE;

Line: 415

   l_last_update_date           pqh_transaction_categories.last_update_date%TYPE;

Line: 416

   l_last_update_login          pqh_transaction_categories.last_update_login%TYPE;

Line: 419

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

Line: 422

    Select table_route_id
      From pqh_table_route
     Where table_alias = p_table_alias;

Line: 428

    Select transaction_category_id
      From pqh_transaction_categories_vl
     Where short_name = p_short_name and business_group_id IS NULL;

Line: 432

  Cursor C_Sel1 is select pqh_transaction_categories_s.nextval from sys.dual;

Line: 436

  Cursor c4 is select business_group_id
               from hr_all_organization_units
               where name = p_business_group_alias ;

Line: 470

    l_last_updated_by := -1;

Line: 473

    l_last_updated_by := 0;

Line: 477

  l_last_updated_by := fnd_load_util.owner_id(p_owner);

Line: 481

  l_last_update_date := sysdate;

Line: 483

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

Line: 484

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

Line: 485

  l_last_update_login := 0;

Line: 497

       update pqh_transaction_categories
       set
       custom_wf_process_name            = p_custom_wf_process_name,
       custom_workflow_name              = p_custom_workflow_name,
       form_name                         = p_form_name,
       freeze_status_cd                  = p_freeze_status_cd,
       future_action_cd                  = p_future_action_cd,
       member_cd                         = p_member_cd,
       name                              = p_name,
       short_name                        = p_short_name,
       post_style_cd                     = p_post_style_cd,
       post_txn_function                 = p_post_txn_function,
       route_validated_txn_flag          = p_route_validated_txn_flag,
       prevent_approver_skip             = p_prevent_approver_skip,
       workflow_enable_flag              = p_workflow_enable_flag,
     --  enable_flag                       = p_enable_flag,
       timeout_days                      = p_timeout_days,
       last_updated_by                   = l_last_updated_by,
       last_update_date                  = l_last_update_date,
       last_update_login                 = l_last_update_login,
       consolidated_table_route_id       = l_consolidated_table_route_id,
--      business_group_id                 = l_business_group_id,
--      setup_type_cd                     = p_setup_type_cd,
       master_table_route_id             = l_master_table_route_id
       WHERE transaction_category_id     = l_transaction_category_id
         AND NVL(last_updated_by,-1) in (l_last_updated_by,1,0,-1);

Line: 528

      UPDATE pqh_transaction_categories_tl
      SET  name               =  p_name,
         last_updated_by                =  l_last_updated_by,
         last_update_date               =  l_last_update_date,
         last_update_login              =  l_last_update_login,
         source_lang                    = userenv('LANG')
      WHERE transaction_category_id  =  l_transaction_category_id
        AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 541

      insert into pqh_transaction_categories_tl
      (	transaction_category_id,
	name,
	language,
	source_lang,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date ,
        last_update_login
       )
       Select
        l_transaction_category_id,
	p_name,
	l.language_code,
	l_language ,
        l_created_by,
        l_creation_date,
        l_last_updated_by,
        l_last_update_date,
        l_last_update_login
       from fnd_languages l
       where l.installed_flag in ('I','B')
       and not exists (select null
                  from pqh_transaction_categories_tl ctl
                  where ctl.transaction_category_id = l_transaction_category_id
                  and ctl.language         = l.language_code );

Line: 601

       insert into pqh_transaction_categories
       (	transaction_category_id,
	custom_wf_process_name,
	custom_workflow_name,
	form_name,
	freeze_status_cd,
	future_action_cd,
	member_cd,
	name,
        short_name,
	post_style_cd,
	post_txn_function,
	route_validated_txn_flag,
	prevent_approver_skip,
        workflow_enable_flag,
 --       enable_flag,
	timeout_days,
	consolidated_table_route_id ,
  --      business_group_id,
  --      setup_type_cd,
	master_table_route_id ,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date ,
        last_update_login,
        object_version_number
       )
       Values
       (l_transaction_category_id,
	p_custom_wf_process_name,
	p_custom_workflow_name,
	p_form_name,
	p_freeze_status_cd,
	p_future_action_cd,
	p_member_cd,
	p_name,
        p_short_name,
	p_post_style_cd,
	p_post_txn_function,
	p_route_validated_txn_flag,
	p_prevent_approver_skip,
        p_workflow_enable_flag,
   --     p_enable_flag,
	p_timeout_days,
	l_consolidated_table_route_id ,
  --      l_business_group_id,
    --    p_setup_type_cd,
	l_master_table_route_id ,
        l_created_by,
        l_creation_date,
        l_last_updated_by,
        l_last_update_date,
        l_last_update_login,
	l_object_version_number
       );

Line: 661

      insert into pqh_transaction_categories_tl
      (	transaction_category_id,
	name,
	language,
	source_lang,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date ,
        last_update_login
       )
       Select
        l_transaction_category_id,
	p_name,
	l.language_code,
	l_language ,
        l_created_by,
        l_creation_date,
        l_last_updated_by,
        l_last_update_date,
        l_last_update_login
       from fnd_languages l
       where l.installed_flag in ('I','B')
       and not exists (select null
                  from pqh_transaction_categories_tl ctl
                  where ctl.transaction_category_id = l_transaction_category_id
                  and ctl.language         = l.language_code );

Line: 705

  delete from PQH_TRANSACTION_CATEGORIES_TL T
  where not exists
    (select NULL
    from PQH_TRANSACTION_CATEGORIES B
    where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
    );

Line: 712

  update PQH_TRANSACTION_CATEGORIES_TL T set (
      NAME
    ) = (select
      B.NAME
    from PQH_TRANSACTION_CATEGORIES_TL B
    where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TRANSACTION_CATEGORY_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TRANSACTION_CATEGORY_ID,
      SUBT.LANGUAGE
    from PQH_TRANSACTION_CATEGORIES_TL SUBB, PQH_TRANSACTION_CATEGORIES_TL SUBT
    where SUBB.TRANSACTION_CATEGORY_ID = SUBT.TRANSACTION_CATEGORY_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
  ));

Line: 731

  insert into PQH_TRANSACTION_CATEGORIES_TL (
    TRANSACTION_CATEGORY_ID,
    NAME,
    LAST_UPDATE_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LAST_UPDATED_BY,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.TRANSACTION_CATEGORY_ID,
    B.NAME,
    B.LAST_UPDATE_DATE,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.LAST_UPDATED_BY,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from PQH_TRANSACTION_CATEGORIES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from PQH_TRANSACTION_CATEGORIES_TL T
    where T.TRANSACTION_CATEGORY_ID = B.TRANSACTION_CATEGORY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);