eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_SERVER dependencies on FND_PLSQL_CACHE

Line 24: g_cache_value fnd_plsql_cache.generic_cache_value_type;

20: -- ======================================================================
21: g_cache_return_code VARCHAR2(30);
22: g_cache_key VARCHAR2(2000);
23: g_cache_index BINARY_INTEGER;
24: g_cache_value fnd_plsql_cache.generic_cache_value_type;
25: g_newline VARCHAR2(8);
26:
27: -- --------------------------------------------------
28: -- vst : Value set cache.

Line 33: vst_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

29: -- --------------------------------------------------
30: TYPE vst_cache_storage_table_type IS TABLE OF fnd_flex_value_sets%ROWTYPE
31: INDEX BY BINARY_INTEGER;
32:
33: vst_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
34: vst_cache_storage vst_cache_storage_table_type;
35:
36: -- ======================================================================
37: -- Value Security Cache : VSC

Line 44: vsc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

40: -- || NEWLINE || || NEWLINE ||
41: --
42: --
43: -- ======================================================================
44: vsc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
45: vsc_cache_storage fnd_plsql_cache.generic_cache_values_type;
46:
47: -- --------------------------------------------------
48: -- Get KFV Concat Segs: Select Statement Cache

Line 45: vsc_cache_storage fnd_plsql_cache.generic_cache_values_type;

41: --
42: --
43: -- ======================================================================
44: vsc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
45: vsc_cache_storage fnd_plsql_cache.generic_cache_values_type;
46:
47: -- --------------------------------------------------
48: -- Get KFV Concat Segs: Select Statement Cache
49: -- --------------------------------------------------

Line 58: kfvssc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

54: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);
55:
56: TYPE kfvssc_table_type IS TABLE OF kfvssc_record_type INDEX BY BINARY_INTEGER;
57:
58: kfvssc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
59: kfvssc_cache_storage kfvssc_table_type;
60:
61: -- --------------------------------------------------
62: -- Get KFV Concat Segs: Code Combination Table Info Cache

Line 73: kfvcct_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

69: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);
70:
71: TYPE kfvcct_table_type IS TABLE OF kfvcct_record_type INDEX BY BINARY_INTEGER;
72:
73: kfvcct_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
74: kfvcct_cache_storage kfvcct_table_type;
75:
76: TYPE table_of_varchar2_32000 IS TABLE OF VARCHAR2(32000)
77: INDEX BY BINARY_INTEGER;

Line 4437: fnd_plsql_cache.generic_1to1_get_value(vsc_cache_controller,

4433: p_responsibility_id || '.' ||
4434: p_value_set_id || '.' ||
4435: p_value);
4436:
4437: fnd_plsql_cache.generic_1to1_get_value(vsc_cache_controller,
4438: vsc_cache_storage,
4439: g_cache_key,
4440: g_cache_value,
4441: g_cache_return_code);

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

4439: g_cache_key,
4440: g_cache_value,
4441: g_cache_return_code);
4442:
4443: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
4444: px_security_status := g_cache_value.varchar2_1;
4445: px_error_message := g_cache_value.varchar2_2;
4446: END IF;
4447:

Line 4451: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);

4447:
4448: RETURN(g_cache_return_code);
4449: EXCEPTION
4450: WHEN OTHERS THEN
4451: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);
4452: END check_vsc;
4453:
4454: PROCEDURE update_vsc(p_application_id IN NUMBER,
4455: p_responsibility_id IN NUMBER,

Line 4472: fnd_plsql_cache.generic_cache_new_value

4468: p_responsibility_id || '.' ||
4469: p_value_set_id || '.' ||
4470: p_value);
4471:
4472: fnd_plsql_cache.generic_cache_new_value
4473: (x_value => g_cache_value,
4474: p_varchar2_1 => p_security_status,
4475: p_varchar2_2 => p_error_message);
4476:

Line 4477: fnd_plsql_cache.generic_1to1_put_value(vsc_cache_controller,

4473: (x_value => g_cache_value,
4474: p_varchar2_1 => p_security_status,
4475: p_varchar2_2 => p_error_message);
4476:
4477: fnd_plsql_cache.generic_1to1_put_value(vsc_cache_controller,
4478: vsc_cache_storage,
4479: g_cache_key,
4480: g_cache_value);
4481: EXCEPTION

Line 4557: fnd_plsql_cache.custom_1to1_get_get_index(vst_cache_controller,

4553: --
4554: -- Get the value set.
4555: --
4556: g_cache_key := p_flex_value_set_id;
4557: fnd_plsql_cache.custom_1to1_get_get_index(vst_cache_controller,
4558: g_cache_key,
4559: g_cache_index,
4560: g_cache_return_code);
4561: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

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

4557: fnd_plsql_cache.custom_1to1_get_get_index(vst_cache_controller,
4558: g_cache_key,
4559: g_cache_index,
4560: g_cache_return_code);
4561: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
4562: l_vset := vst_cache_storage(g_cache_index);
4563: ELSE
4564: BEGIN
4565: SELECT *

Line 4578: fnd_plsql_cache.custom_1to1_get_put_index(vst_cache_controller,

4574: l_x_security_status := 'VSET-NOTFOUND';
4575: l_x_error_message := fnd_message.get;
4576: GOTO goto_return;
4577: END;
4578: fnd_plsql_cache.custom_1to1_get_put_index(vst_cache_controller,
4579: g_cache_key,
4580: g_cache_index);
4581:
4582: vst_cache_storage(g_cache_index) := l_vset;

Line 4621: IF (l_vsc_code = fnd_plsql_cache.CACHE_FOUND) THEN

4617: p_value => p_flex_value,
4618: px_security_status => l_x_security_status,
4619: px_error_message => l_x_error_message);
4620:
4621: IF (l_vsc_code = fnd_plsql_cache.CACHE_FOUND) THEN
4622: IF (fnd_flex_server1.g_debug_level > 0) THEN
4623: fnd_flex_server1.add_debug('Found in SSV.VSC.');
4624: END IF;
4625: GOTO goto_return;

Line 5209: fnd_plsql_cache.custom_1to1_get_get_index(kfvcct_cache_controller,

5205: BEGIN
5206: l_kfvcct_key := (p_application_id || g_newline ||
5207: p_id_flex_code);
5208:
5209: fnd_plsql_cache.custom_1to1_get_get_index(kfvcct_cache_controller,
5210: l_kfvcct_key,
5211: g_cache_index,
5212: g_cache_return_code);
5213:

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

5210: l_kfvcct_key,
5211: g_cache_index,
5212: g_cache_return_code);
5213:
5214: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
5215: px_kfvcct_record := kfvcct_cache_storage(g_cache_index);
5216:
5217: ELSE
5218:

Line 5237: fnd_plsql_cache.custom_1to1_get_put_index(kfvcct_cache_controller,

5233: AND fif.id_flex_code = p_id_flex_code
5234: AND ft.application_id = fif.table_application_id
5235: AND ft.table_name = fif.application_table_name;
5236:
5237: fnd_plsql_cache.custom_1to1_get_put_index(kfvcct_cache_controller,
5238: l_kfvcct_key,
5239: g_cache_index);
5240:
5241: kfvcct_cache_storage(g_cache_index) := px_kfvcct_record;

Line 5398: fnd_plsql_cache.custom_1to1_get_get_index(kfvssc_cache_controller,

5394: l_kfvssc_key := (p_application_id || g_newline ||
5395: p_id_flex_code || g_newline ||
5396: p_id_flex_num);
5397:
5398: fnd_plsql_cache.custom_1to1_get_get_index(kfvssc_cache_controller,
5399: l_kfvssc_key,
5400: g_cache_index,
5401: g_cache_return_code);
5402:

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

5399: l_kfvssc_key,
5400: g_cache_index,
5401: g_cache_return_code);
5402:
5403: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
5404: px_kfvssc_record := kfvssc_cache_storage(g_cache_index);
5405:
5406: ELSE
5407: create_kfvssc_record(p_application_id,

Line 5412: fnd_plsql_cache.custom_1to1_get_put_index(kfvssc_cache_controller,

5408: p_id_flex_code,
5409: p_id_flex_num,
5410: px_kfvssc_record);
5411:
5412: fnd_plsql_cache.custom_1to1_get_put_index(kfvssc_cache_controller,
5413: l_kfvssc_key,
5414: g_cache_index);
5415:
5416: kfvssc_cache_storage(g_cache_index) := px_kfvssc_record;

Line 6435: fnd_plsql_cache.custom_1to1_init('SSV.VST',

6431: g_non_forms_warnings_count := 0;
6432:
6433: -- Initialize Caches
6434:
6435: fnd_plsql_cache.custom_1to1_init('SSV.VST',
6436: vst_cache_controller);
6437: vst_cache_storage.DELETE;
6438:
6439: fnd_plsql_cache.custom_1to1_init('SSV.KFVSSC',

Line 6439: fnd_plsql_cache.custom_1to1_init('SSV.KFVSSC',

6435: fnd_plsql_cache.custom_1to1_init('SSV.VST',
6436: vst_cache_controller);
6437: vst_cache_storage.DELETE;
6438:
6439: fnd_plsql_cache.custom_1to1_init('SSV.KFVSSC',
6440: kfvssc_cache_controller);
6441: kfvssc_cache_storage.DELETE;
6442:
6443: fnd_plsql_cache.custom_1to1_init('SSV.KFVCCT',

Line 6443: fnd_plsql_cache.custom_1to1_init('SSV.KFVCCT',

6439: fnd_plsql_cache.custom_1to1_init('SSV.KFVSSC',
6440: kfvssc_cache_controller);
6441: kfvssc_cache_storage.DELETE;
6442:
6443: fnd_plsql_cache.custom_1to1_init('SSV.KFVCCT',
6444: kfvcct_cache_controller);
6445:
6446: kfvcct_cache_storage.DELETE;
6447:

Line 6448: fnd_plsql_cache.generic_1to1_init('SSV.VSC',

6444: kfvcct_cache_controller);
6445:
6446: kfvcct_cache_storage.DELETE;
6447:
6448: fnd_plsql_cache.generic_1to1_init('SSV.VSC',
6449: vsc_cache_controller,
6450: vsc_cache_storage);
6451:
6452: END fnd_flex_server;