APPS.FND_CACHE_VERSIONS_PKG SQL Statements

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

Line: 17

   select NAME, VERSION
   bulk collect into cacheName, cacheVersion
   from FND_CACHE_VERSIONS;

Line: 35

   insert into FND_CACHE_VERSIONS(
      NAME,
      VERSION
   ) values (
      p_name,
      0);

Line: 59

   update FND_CACHE_VERSIONS
   set VERSION = VERSION + 1
   where NAME = p_name;

Line: 147

 *   p_version - version, can be updated with current_version if applicable.
 *               If p_version is updated with current_version, then the RETURN
 *               value of the function is FALSE and the p_version value
 *               returned can be used to obtain the new value from cache.
 *
 * RETURN
 *   TRUE/FALSE - If TRUE, no need to retrieve value from cache (wherever
 *                cache is).
 *                If FALSE, retrieve the value from cache since a newer
 *                version exists.
 *
 * RAISES
 *   Never raises exceptions
 */
function check_version (p_name IN varchar2,
                        p_version IN OUT nocopy number)
   return boolean
is
   current_version number;