APPS.OKE_K_ORGANIZER_PKG SQL Statements

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

Line: 44

   l_str := 'select k_number, k_header_id
             from oke_k_headers_secure_v k
             where ' || x_user_value ||
             ' order by k_number';

Line: 124

     INSERT INTO oke_k_fifo_logs
     ( user_log_id
     , k_header_id
     , sequence
     , object_name
     , last_update_date
     , last_updated_by
     , creation_date
     , created_by
     , last_update_login )
     SELECT oke_k_fifo_logs_s.nextval
     ,      X_K_Header_ID
     ,      0
     ,      X_Object_Name
     ,      sysdate
     ,      X_User_ID
     ,      sysdate
     ,      X_User_ID
     ,      null
     FROM   dual
     WHERE NOT EXISTS (
       SELECT null
       FROM   oke_k_fifo_logs
       WHERE  k_header_id = X_K_Header_ID
       AND    object_name = X_Object_Name
       AND    created_by  = X_User_ID
     );

Line: 155

     UPDATE oke_k_fifo_logs
     SET    last_update_date = sysdate
     ,      last_updated_by  = X_User_ID
     ,      sequence         = 0
     WHERE  k_header_id = X_K_Header_ID
     AND    object_name = X_Object_Name
     AND    created_by  = X_User_ID
     AND    sequence   <> 0;

Line: 167

     UPDATE oke_k_fifo_logs l1
     SET    sequence = (
       SELECT count(1)
       FROM   oke_k_fifo_logs l2
       WHERE  l2.object_name = l1.object_name
       AND    l2.created_by  = l1.created_by
       AND    l2.last_update_date >= l1.last_update_date )
     WHERE object_name = X_Object_Name
     AND   created_by  = X_User_ID;

Line: 181

	 DELETE FROM oke_k_fifo_logs
	 WHERE object_name = X_Object_Name
	 AND   created_by  = X_User_ID
	 AND   sequence    > nvl(log_size , 6);

Line: 215

      select object1_id1,
             object1_id2,
             jtot_object1_code
      from   okc_k_party_roles_b
      where  dnz_chr_id = x_k_header_id
      and    rle_code = x_role;

Line: 223

      select from_table,
             where_clause
      from   jtf_objects_b
      where  object_code = l_object;

Line: 268

       l_str := 'select name from ' || l_name.from_table
                || ' where id1 = ' || to_number(l_id1);

Line: 276

       l_str := 'select name from ' || l_name.from_table
                || ' where id1 = :id1';