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 4466: fnd_plsql_cache.generic_1to1_get_value(vsc_cache_controller,

4462: p_responsibility_id || '.' ||
4463: p_value_set_id || '.' ||
4464: p_value);
4465:
4466: fnd_plsql_cache.generic_1to1_get_value(vsc_cache_controller,
4467: vsc_cache_storage,
4468: g_cache_key,
4469: g_cache_value,
4470: g_cache_return_code);

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

4468: g_cache_key,
4469: g_cache_value,
4470: g_cache_return_code);
4471:
4472: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
4473: px_security_status := g_cache_value.varchar2_1;
4474: px_error_message := g_cache_value.varchar2_2;
4475: END IF;
4476:

Line 4480: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);

4476:
4477: RETURN(g_cache_return_code);
4478: EXCEPTION
4479: WHEN OTHERS THEN
4480: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);
4481: END check_vsc;
4482:
4483: PROCEDURE update_vsc(p_application_id IN NUMBER,
4484: p_responsibility_id IN NUMBER,

Line 4501: fnd_plsql_cache.generic_cache_new_value

4497: p_responsibility_id || '.' ||
4498: p_value_set_id || '.' ||
4499: p_value);
4500:
4501: fnd_plsql_cache.generic_cache_new_value
4502: (x_value => g_cache_value,
4503: p_varchar2_1 => p_security_status,
4504: p_varchar2_2 => p_error_message);
4505:

Line 4506: fnd_plsql_cache.generic_1to1_put_value(vsc_cache_controller,

4502: (x_value => g_cache_value,
4503: p_varchar2_1 => p_security_status,
4504: p_varchar2_2 => p_error_message);
4505:
4506: fnd_plsql_cache.generic_1to1_put_value(vsc_cache_controller,
4507: vsc_cache_storage,
4508: g_cache_key,
4509: g_cache_value);
4510: EXCEPTION

Line 4685: fnd_plsql_cache.custom_1to1_get_get_index(vst_cache_controller,

4681: --
4682: -- Get the value set.
4683: --
4684: g_cache_key := p_flex_value_set_id;
4685: fnd_plsql_cache.custom_1to1_get_get_index(vst_cache_controller,
4686: g_cache_key,
4687: g_cache_index,
4688: g_cache_return_code);
4689: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

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

4685: fnd_plsql_cache.custom_1to1_get_get_index(vst_cache_controller,
4686: g_cache_key,
4687: g_cache_index,
4688: g_cache_return_code);
4689: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
4690: l_vset := vst_cache_storage(g_cache_index);
4691: ELSE
4692: BEGIN
4693: SELECT *

Line 4706: fnd_plsql_cache.custom_1to1_get_put_index(vst_cache_controller,

4702: l_x_security_status := 'VSET-NOTFOUND';
4703: l_x_error_message := fnd_message.get;
4704: GOTO goto_return;
4705: END;
4706: fnd_plsql_cache.custom_1to1_get_put_index(vst_cache_controller,
4707: g_cache_key,
4708: g_cache_index);
4709:
4710: vst_cache_storage(g_cache_index) := l_vset;

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

4745: p_value => p_flex_value,
4746: px_security_status => l_x_security_status,
4747: px_error_message => l_x_error_message);
4748:
4749: IF (l_vsc_code = fnd_plsql_cache.CACHE_FOUND) THEN
4750: IF (fnd_flex_server1.g_debug_level > 0) THEN
4751: fnd_flex_server1.add_debug('Found in SSV.VSC.');
4752: END IF;
4753: GOTO goto_return;

Line 5402: fnd_plsql_cache.custom_1to1_get_get_index(kfvcct_cache_controller,

5398: BEGIN
5399: l_kfvcct_key := (p_application_id || g_newline ||
5400: p_id_flex_code);
5401:
5402: fnd_plsql_cache.custom_1to1_get_get_index(kfvcct_cache_controller,
5403: l_kfvcct_key,
5404: g_cache_index,
5405: g_cache_return_code);
5406:

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

5403: l_kfvcct_key,
5404: g_cache_index,
5405: g_cache_return_code);
5406:
5407: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
5408: px_kfvcct_record := kfvcct_cache_storage(g_cache_index);
5409:
5410: ELSE
5411:

Line 5430: fnd_plsql_cache.custom_1to1_get_put_index(kfvcct_cache_controller,

5426: AND fif.id_flex_code = p_id_flex_code
5427: AND ft.application_id = fif.table_application_id
5428: AND ft.table_name = fif.application_table_name;
5429:
5430: fnd_plsql_cache.custom_1to1_get_put_index(kfvcct_cache_controller,
5431: l_kfvcct_key,
5432: g_cache_index);
5433:
5434: kfvcct_cache_storage(g_cache_index) := px_kfvcct_record;

Line 5591: fnd_plsql_cache.custom_1to1_get_get_index(kfvssc_cache_controller,

5587: l_kfvssc_key := (p_application_id || g_newline ||
5588: p_id_flex_code || g_newline ||
5589: p_id_flex_num);
5590:
5591: fnd_plsql_cache.custom_1to1_get_get_index(kfvssc_cache_controller,
5592: l_kfvssc_key,
5593: g_cache_index,
5594: g_cache_return_code);
5595:

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

5592: l_kfvssc_key,
5593: g_cache_index,
5594: g_cache_return_code);
5595:
5596: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
5597: px_kfvssc_record := kfvssc_cache_storage(g_cache_index);
5598:
5599: ELSE
5600: create_kfvssc_record(p_application_id,

Line 5605: fnd_plsql_cache.custom_1to1_get_put_index(kfvssc_cache_controller,

5601: p_id_flex_code,
5602: p_id_flex_num,
5603: px_kfvssc_record);
5604:
5605: fnd_plsql_cache.custom_1to1_get_put_index(kfvssc_cache_controller,
5606: l_kfvssc_key,
5607: g_cache_index);
5608:
5609: kfvssc_cache_storage(g_cache_index) := px_kfvssc_record;

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

6624: g_non_forms_warnings_count := 0;
6625:
6626: -- Initialize Caches
6627:
6628: fnd_plsql_cache.custom_1to1_init('SSV.VST',
6629: vst_cache_controller);
6630: vst_cache_storage.DELETE;
6631:
6632: fnd_plsql_cache.custom_1to1_init('SSV.KFVSSC',

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

6628: fnd_plsql_cache.custom_1to1_init('SSV.VST',
6629: vst_cache_controller);
6630: vst_cache_storage.DELETE;
6631:
6632: fnd_plsql_cache.custom_1to1_init('SSV.KFVSSC',
6633: kfvssc_cache_controller);
6634: kfvssc_cache_storage.DELETE;
6635:
6636: fnd_plsql_cache.custom_1to1_init('SSV.KFVCCT',

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

6632: fnd_plsql_cache.custom_1to1_init('SSV.KFVSSC',
6633: kfvssc_cache_controller);
6634: kfvssc_cache_storage.DELETE;
6635:
6636: fnd_plsql_cache.custom_1to1_init('SSV.KFVCCT',
6637: kfvcct_cache_controller);
6638:
6639: kfvcct_cache_storage.DELETE;
6640:

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

6637: kfvcct_cache_controller);
6638:
6639: kfvcct_cache_storage.DELETE;
6640:
6641: fnd_plsql_cache.generic_1to1_init('SSV.VSC',
6642: vsc_cache_controller,
6643: vsc_cache_storage);
6644:
6645: END fnd_flex_server;