1 package FND_CACHE_VERSIONS_PKG as
2 /* $Header: AFCCHVRS.pls 120.1 2005/07/02 03:57:50 appldev noship $ */
3
4 /*
5 * get_values
6 * Use this API to do a bulk collect on FND_CACHE_VERSIONS
7 */
8 procedure get_values;
9
10 /*
11 * add_cache_name
12 * Use this API to add an entry in FND_CACHE_VERSIONS
13 *
14 * IN
15 * p_name - name of cache
16 *
17 */
18 procedure add_cache_name (p_name varchar2);
19
20 /*
21 * bump_version
22 * Use this API to increase the version by 1 in FND_CACHE_VERSIONS
23 *
24 * IN
25 * p_name - name of cache
26 *
27 */
28 procedure bump_version (p_name varchar2);
29
30 /*
31 * get_version
32 * Use this API to get the current version in FND_CACHE_VERSIONS
33 *
34 * IN
35 * p_name - name of cache
36 *
37 * RETURN
38 * returns the current_version in FND_CACHE_VERSIONS given a name
39 *
40 * RAISES
41 * Never raises exceptions, returns -1 if name does not exist
42 */
43 function get_version (p_name varchar2)
44 return number;
45 pragma restrict_references(get_version, WNDS, TRUST);
46 /*
47 * check_version
48 * Use this API to get the current version in FND_CACHE_VERSIONS
49 *
50 * IN
51 * p_name - name of cache
52 *
53 * IN/OUT
54 * p_version - version, can be updated with current_version if applicable.
55 * If p_version is updated with current_version, then the RETURN
56 * value of the function is FALSE and the p_version value
57 * returned can be used to obtain the new value from cache.
58 *
59 * RETURN
60 * TRUE/FALSE - If TRUE, no need to retrieve value from cache (wherever
61 * cache is.
62 * If FALSE, retrieve the value from cache since a newer
63 * version exists.
64 *
65 * RAISES
66 * Never raises exceptions
67 */
68 function check_version (p_name IN varchar2,
69 p_version IN OUT nocopy number)
70 return boolean;
71 pragma restrict_references(check_version, WNDS, TRUST);
72
73 end FND_CACHE_VERSIONS_PKG;