DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER4 dependencies on FND_PLSQL_CACHE

Line 36: g_cache_value fnd_plsql_cache.generic_cache_value_type;

32: -- ==================================================
33:
34: g_cache_return_code VARCHAR2(30);
35: g_cache_key VARCHAR2(2000);
36: g_cache_value fnd_plsql_cache.generic_cache_value_type;
37:
38: -- --------------------------------------------------
39: -- cxc : Context Cache
40: -- --------------------------------------------------

Line 41: cxc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

37:
38: -- --------------------------------------------------
39: -- cxc : Context Cache
40: -- --------------------------------------------------
41: cxc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
42: cxc_cache_storage fnd_plsql_cache.generic_cache_values_type;
43:
44: -- --------------------------------------------------
45: -- gcc : Global Context Cache

Line 42: cxc_cache_storage fnd_plsql_cache.generic_cache_values_type;

38: -- --------------------------------------------------
39: -- cxc : Context Cache
40: -- --------------------------------------------------
41: cxc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
42: cxc_cache_storage fnd_plsql_cache.generic_cache_values_type;
43:
44: -- --------------------------------------------------
45: -- gcc : Global Context Cache
46: -- --------------------------------------------------

Line 47: gcc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

43:
44: -- --------------------------------------------------
45: -- gcc : Global Context Cache
46: -- --------------------------------------------------
47: gcc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
48: gcc_cache_storage fnd_plsql_cache.generic_cache_values_type;
49:
50: /* -------------------------------------------------------------------- */
51: /* Private global variables */

Line 48: gcc_cache_storage fnd_plsql_cache.generic_cache_values_type;

44: -- --------------------------------------------------
45: -- gcc : Global Context Cache
46: -- --------------------------------------------------
47: gcc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
48: gcc_cache_storage fnd_plsql_cache.generic_cache_values_type;
49:
50: /* -------------------------------------------------------------------- */
51: /* Private global variables */
52: /* -------------------------------------------------------------------- */

Line 1751: fnd_plsql_cache.generic_1to1_get_value(cxc_cache_controller,

1747: END IF;
1748:
1749: g_cache_key := (appl_id || '.' || dflex_name || '.' ||
1750: p_id_or_value || '.' || seg_in);
1751: fnd_plsql_cache.generic_1to1_get_value(cxc_cache_controller,
1752: cxc_cache_storage,
1753: g_cache_key,
1754: g_cache_value,
1755: g_cache_return_code);

Line 1756: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1752: cxc_cache_storage,
1753: g_cache_key,
1754: g_cache_value,
1755: g_cache_return_code);
1756: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1757: NULL;
1758: ELSE
1759: SELECT
1760: descriptive_flex_context_code,

Line 1778: fnd_plsql_cache.generic_1to1_put_value(cxc_cache_controller,

1774: (p_id_or_value = 'V' AND
1775: descriptive_flex_context_name = seg_in))
1776: AND enabled_flag = 'Y';
1777:
1778: fnd_plsql_cache.generic_1to1_put_value(cxc_cache_controller,
1779: cxc_cache_storage,
1780: g_cache_key,
1781: g_cache_value);
1782: END IF;

Line 1830: fnd_plsql_cache.generic_1to1_get_value(gcc_cache_controller,

1826: 'BEGIN SV4.get_global_context() ');
1827: END IF;
1828:
1829: g_cache_key := appl_id || '.' || dflex_name;
1830: fnd_plsql_cache.generic_1to1_get_value(gcc_cache_controller,
1831: gcc_cache_storage,
1832: g_cache_key,
1833: g_cache_value,
1834: g_cache_return_code);

Line 1835: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1831: gcc_cache_storage,
1832: g_cache_key,
1833: g_cache_value,
1834: g_cache_return_code);
1835: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1836: NULL;
1837: ELSE
1838: SELECT
1839: descriptive_flex_context_code

Line 1848: fnd_plsql_cache.generic_1to1_put_value(gcc_cache_controller,

1844: AND descriptive_flexfield_name = dflex_name
1845: AND enabled_flag = 'Y'
1846: AND global_flag = 'Y';
1847:
1848: fnd_plsql_cache.generic_1to1_put_value(gcc_cache_controller,
1849: gcc_cache_storage,
1850: g_cache_key,
1851: g_cache_value);
1852: END IF;

Line 1876: fnd_plsql_cache.generic_1to1_init('SV4.CXC',

1872:
1873: /* ----------------------------------------------------------------------- */
1874:
1875: BEGIN
1876: fnd_plsql_cache.generic_1to1_init('SV4.CXC',
1877: cxc_cache_controller,
1878: cxc_cache_storage);
1879:
1880: fnd_plsql_cache.generic_1to1_init('SV4.GCC',

Line 1880: fnd_plsql_cache.generic_1to1_init('SV4.GCC',

1876: fnd_plsql_cache.generic_1to1_init('SV4.CXC',
1877: cxc_cache_controller,
1878: cxc_cache_storage);
1879:
1880: fnd_plsql_cache.generic_1to1_init('SV4.GCC',
1881: gcc_cache_controller,
1882: gcc_cache_storage);
1883: END fnd_flex_server4;