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 1762: fnd_plsql_cache.generic_1to1_get_value(cxc_cache_controller,

1758: END IF;
1759:
1760: g_cache_key := (appl_id || '.' || dflex_name || '.' ||
1761: p_id_or_value || '.' || seg_in);
1762: fnd_plsql_cache.generic_1to1_get_value(cxc_cache_controller,
1763: cxc_cache_storage,
1764: g_cache_key,
1765: g_cache_value,
1766: g_cache_return_code);

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

1763: cxc_cache_storage,
1764: g_cache_key,
1765: g_cache_value,
1766: g_cache_return_code);
1767: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1768: NULL;
1769: ELSE
1770: SELECT
1771: descriptive_flex_context_code,

Line 1789: fnd_plsql_cache.generic_1to1_put_value(cxc_cache_controller,

1785: (p_id_or_value = 'V' AND
1786: descriptive_flex_context_name = seg_in))
1787: AND enabled_flag = 'Y';
1788:
1789: fnd_plsql_cache.generic_1to1_put_value(cxc_cache_controller,
1790: cxc_cache_storage,
1791: g_cache_key,
1792: g_cache_value);
1793: END IF;

Line 1841: fnd_plsql_cache.generic_1to1_get_value(gcc_cache_controller,

1837: 'BEGIN SV4.get_global_context() ');
1838: END IF;
1839:
1840: g_cache_key := appl_id || '.' || dflex_name;
1841: fnd_plsql_cache.generic_1to1_get_value(gcc_cache_controller,
1842: gcc_cache_storage,
1843: g_cache_key,
1844: g_cache_value,
1845: g_cache_return_code);

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

1842: gcc_cache_storage,
1843: g_cache_key,
1844: g_cache_value,
1845: g_cache_return_code);
1846: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1847: NULL;
1848: ELSE
1849: SELECT
1850: descriptive_flex_context_code

Line 1859: fnd_plsql_cache.generic_1to1_put_value(gcc_cache_controller,

1855: AND descriptive_flexfield_name = dflex_name
1856: AND enabled_flag = 'Y'
1857: AND global_flag = 'Y';
1858:
1859: fnd_plsql_cache.generic_1to1_put_value(gcc_cache_controller,
1860: gcc_cache_storage,
1861: g_cache_key,
1862: g_cache_value);
1863: END IF;

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

1883:
1884: /* ----------------------------------------------------------------------- */
1885:
1886: BEGIN
1887: fnd_plsql_cache.generic_1to1_init('SV4.CXC',
1888: cxc_cache_controller,
1889: cxc_cache_storage);
1890:
1891: fnd_plsql_cache.generic_1to1_init('SV4.GCC',

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

1887: fnd_plsql_cache.generic_1to1_init('SV4.CXC',
1888: cxc_cache_controller,
1889: cxc_cache_storage);
1890:
1891: fnd_plsql_cache.generic_1to1_init('SV4.GCC',
1892: gcc_cache_controller,
1893: gcc_cache_storage);
1894: END fnd_flex_server4;