APPS.FND_FLEX_KEY_API dependencies on FND_PLSQL_CACHE

Line 9: g_cache_value fnd_plsql_cache.generic_cache_value_type;

5: -- CACHING
6: -- ==================================================
7: g_cache_return_code VARCHAR2(30);
8: g_cache_key VARCHAR2(2000);
9: g_cache_value fnd_plsql_cache.generic_cache_value_type;
10:
11: -- --------------------------------------------------
12: -- soq : Segment Order by Qualifier Name Cache
13: -- --------------------------------------------------

Line 14: soq_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

10:
11: -- --------------------------------------------------
12: -- soq : Segment Order by Qualifier Name Cache
13: -- --------------------------------------------------
14: soq_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
15: soq_cache_storage fnd_plsql_cache.generic_cache_values_type;
16:
17: value_too_large EXCEPTION;
18: PRAGMA EXCEPTION_INIT(value_too_large, -01401);

Line 15: soq_cache_storage fnd_plsql_cache.generic_cache_values_type;

11: -- --------------------------------------------------
12: -- soq : Segment Order by Qualifier Name Cache
13: -- --------------------------------------------------
14: soq_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
15: soq_cache_storage fnd_plsql_cache.generic_cache_values_type;
16:
17: value_too_large EXCEPTION;
18: PRAGMA EXCEPTION_INIT(value_too_large, -01401);
19:

Line 3857: fnd_plsql_cache.generic_1to1_get_value(soq_cache_controller,

3853: BEGIN
3854: g_cache_key := (p_application_id || '.' || p_id_flex_code || '.' ||
3855: p_id_flex_num || '.' || p_segment_attribute_type);
3856:
3857: fnd_plsql_cache.generic_1to1_get_value(soq_cache_controller,
3858: soq_cache_storage,
3859: g_cache_key,
3860: g_cache_value,
3861: g_cache_return_code);

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

3859: g_cache_key,
3860: g_cache_value,
3861: g_cache_return_code);
3862:
3863: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
3864: l_segment_order := g_cache_value.number_1;
3865: ELSE
3866: SELECT s.segment_num
3867: INTO l_segment_num

Line 3896: fnd_plsql_cache.generic_cache_new_value

3892: AND enabled_flag = 'Y'
3893: AND segment_num <= l_segment_num
3894: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3895:
3896: fnd_plsql_cache.generic_cache_new_value
3897: (x_value => g_cache_value,
3898: p_number_1 => l_segment_order);
3899:
3900: fnd_plsql_cache.generic_1to1_put_value(soq_cache_controller,

Line 3900: fnd_plsql_cache.generic_1to1_put_value(soq_cache_controller,

3896: fnd_plsql_cache.generic_cache_new_value
3897: (x_value => g_cache_value,
3898: p_number_1 => l_segment_order);
3899:
3900: fnd_plsql_cache.generic_1to1_put_value(soq_cache_controller,
3901: soq_cache_storage,
3902: g_cache_key,
3903: g_cache_value);
3904: END IF;

Line 4434: fnd_plsql_cache.generic_1to1_init('KAI.SOQ',

4430:
4431: END awc_exists;
4432:
4433: BEGIN
4434: fnd_plsql_cache.generic_1to1_init('KAI.SOQ',
4435: soq_cache_controller,
4436: soq_cache_storage);
4437:
4438: END fnd_flex_key_api;