APPS.PQH_CEF_SHD SQL Statements

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

Line: 55

    select
		copy_entity_function_id,
	table_route_id,
	function_type_cd,
	pre_copy_function_name,
	copy_function_name,
	post_copy_function_name,
	object_version_number,
	context
    from	pqh_copy_entity_functions
    where	copy_entity_function_id = p_copy_entity_function_id;

Line: 133

    select 	copy_entity_function_id,
	table_route_id,
	function_type_cd,
	pre_copy_function_name,
	copy_function_name,
	post_copy_function_name,
	object_version_number,
	context
    from	pqh_copy_entity_functions
    where	copy_entity_function_id = p_copy_entity_function_id
    for	update nowait;

Line: 241

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

Line: 254

   l_last_updated_by            pqh_copy_entity_functions.last_updated_by%TYPE;

Line: 256

   l_last_update_date           pqh_copy_entity_functions.last_update_date%TYPE;

Line: 257

   l_last_update_login          pqh_copy_entity_functions.last_update_login%TYPE;

Line: 259

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

Line: 265

 select table_route_id
 from pqh_table_route
 where table_alias = p_table_alias;

Line: 272

 select copy_entity_function_id
 from pqh_copy_entity_functions
 where table_route_id = p_table_route_id
   and function_type_cd = p_function_type_cd
   and context   = p_context;

Line: 310

  l_last_updated_by := 1;

Line: 312

  l_last_updated_by := fnd_load_util.owner_id(p_owner);

Line: 314

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

Line: 315

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

Line: 318

  l_last_update_date := sysdate;

Line: 320

  l_last_update_login := 0;

Line: 329

     update pqh_copy_entity_functions
      set pre_copy_function_name         = p_pre_copy_function_name,
          copy_function_name             = p_copy_function_name,
          post_copy_function_name        = p_post_copy_function_name,
          last_updated_by                =  l_last_updated_by,
          last_update_date               =  l_last_update_date,
          last_update_login              =  l_last_update_login
      where copy_entity_function_id = l_copy_entity_function_id
        and nvl(last_updated_by , -1) in (l_last_updated_by,-1,1);

Line: 341

  select pqh_copy_entity_functions_s.nextval into l_copy_entity_function_id from dual;

Line: 343

  insert into pqh_copy_entity_functions
  (     copy_entity_function_id,
        table_route_id,
        function_type_cd,
        pre_copy_function_name,
        copy_function_name,
        post_copy_function_name,
        object_version_number,
        context,
        creation_date,
        created_by,
        last_update_date,
        last_update_login,
        last_updated_by
  )
  Values
  (
      l_copy_entity_function_id,
      l_table_route_id,
      p_function_type_cd,
      p_pre_copy_function_name,
      p_copy_function_name,
      p_post_copy_function_name,
      l_object_version_number,
      p_context,
      l_creation_date,
      l_created_by,
      l_last_update_date,
      l_last_update_login,
      l_last_updated_by
  );