APPS.PQH_CEC_SHD SQL Statements

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

Line: 51

    select
		context,
	application_short_name,
	legislation_code,
	responsibility_key,
	transaction_short_name,
	object_version_number
    from	pqh_copy_entity_contexts
    where	context = p_context;

Line: 130

    select 	context,
	application_short_name,
	legislation_code,
	responsibility_key,
	transaction_short_name,
	object_version_number
    from	pqh_copy_entity_contexts
    where	context = p_context
    for	update nowait;

Line: 232

    ,p_last_update_date               in varchar2
 ) is

--
   l_effective_date           date  := sysdate ;

Line: 242

   l_last_updated_by            pqh_copy_entity_contexts.last_updated_by%TYPE;

Line: 244

   l_last_update_date           pqh_copy_entity_contexts.last_update_date%TYPE;

Line: 245

   l_last_update_login          pqh_copy_entity_contexts.last_update_login%TYPE;

Line: 247

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

Line: 255

 select context
 from pqh_copy_entity_contexts
 where context = p_context;

Line: 278

  l_last_updated_by := 1;

Line: 280

  l_last_updated_by := fnd_load_util.owner_id(p_owner);

Line: 282

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

Line: 283

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

Line: 286

  l_last_update_date := sysdate;

Line: 288

  l_last_update_login := 0;

Line: 296

  insert into pqh_copy_entity_contexts
  (     context,
        application_short_name,
        legislation_code,
        responsibility_key,
        transaction_short_name,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date ,
        last_update_login
  )
  Values
  (  p_context,
     p_application_short_name,
     p_legislation_code,
     p_responsibility_key,
     p_transaction_short_name,
     l_object_version_number,
     l_created_by,
     l_creation_date,
     l_last_updated_by,
     l_last_update_date,
     l_last_update_login
  );

Line: 327

    update pqh_copy_entity_contexts
     set  application_short_name = p_application_short_name,
          legislation_code       = p_legislation_code,
          responsibility_key     = p_responsibility_key,
          transaction_short_name = p_transaction_short_name,
          last_updated_by        =  l_last_updated_by,
          last_update_date       =  l_last_update_date,
          last_update_login      =  l_last_update_login
     where context = p_context
       and nvl(last_updated_by,-1) in (l_last_updated_by,-1,1) ;