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_PLSQL_CACHE dependencies on FND_GLOBAL

Line 509: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

505: p_key IN VARCHAR2,
506: x_value OUT nocopy generic_cache_value_type,
507: x_return_code OUT nocopy VARCHAR2)
508: IS
509: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
510: l_key_index NUMBER;
511: BEGIN
512: -- Similar logic exists in custom_1to1_get_get_index()
513: --

Line 541: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

537: px_storage IN OUT nocopy generic_cache_values_type,
538: p_key IN VARCHAR2,
539: p_value IN generic_cache_value_type)
540: IS
541: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
542: l_key_index NUMBER;
543: BEGIN
544: -- Similar logic exists in custom_1to1_get_put_index()
545: --

Line 650: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

646: x_numof_values OUT nocopy NUMBER,
647: x_values OUT nocopy generic_cache_values_type,
648: x_return_code OUT nocopy VARCHAR2)
649: IS
650: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
651: l_key_index NUMBER;
652: l_indexes_vc2 VARCHAR2(2048);
653: BEGIN
654: -- Similar logic exists in custom_1tom_get_get_indexes()

Line 816: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

812: p_key IN VARCHAR2,
813: x_index OUT nocopy BINARY_INTEGER,
814: x_return_code OUT nocopy VARCHAR2)
815: IS
816: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
817: l_key_index NUMBER;
818: BEGIN
819: -- Similar logic exists in generic_1to1_get_value()
820: --

Line 847: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

843: (px_controller IN OUT nocopy cache_1to1_controller_type,
844: p_key IN VARCHAR2,
845: x_index OUT nocopy BINARY_INTEGER)
846: IS
847: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
848: l_key_index NUMBER;
849: BEGIN
850: -- Similar logic exists in generic_1to1_put_value()
851: --

Line 881: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

877: PROCEDURE custom_1to1_remove_key
878: (px_controller IN OUT nocopy cache_1to1_controller_type,
879: p_key IN VARCHAR2)
880: IS
881: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
882: l_key_index NUMBER;
883: BEGIN
884: --
885: -- Get the key index. (1..px_controller.max_numof_keys)

Line 1056: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

1052: x_numof_indexes OUT nocopy NUMBER,
1053: x_indexes OUT nocopy custom_cache_indexes_type,
1054: x_return_code OUT nocopy VARCHAR2)
1055: IS
1056: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
1057: l_key_index NUMBER;
1058: l_indexes_vc2 VARCHAR2(2048);
1059: BEGIN
1060: -- Similar logic exists in generic_1tom_get_values()

Line 1103: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

1099: p_numof_indexes IN NUMBER,
1100: x_indexes OUT nocopy custom_cache_indexes_type,
1101: x_return_code OUT nocopy VARCHAR2)
1102: IS
1103: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
1104: l_key_index NUMBER;
1105: l_indexes_vc2 VARCHAR2(2048);
1106: BEGIN
1107: --

Line 1190: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

1186: PROCEDURE custom_1tom_remove_key
1187: (px_controller IN OUT nocopy cache_1tom_controller_type,
1188: p_key IN VARCHAR2)
1189: IS
1190: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
1191: l_key_index NUMBER;
1192: BEGIN
1193: --
1194: -- Get the key index. (1..px_controller.max_numof_keys)

Line 1542: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;

1538:
1539: -- ----------------------------------------------------------------------
1540: FUNCTION test_get_same_index_key(p_key IN VARCHAR2) RETURN VARCHAR2
1541: IS
1542: l_key VARCHAR2(2048) := fnd_global.session_context || '.' || p_key;
1543: l_key_index NUMBER;
1544: l_index NUMBER;
1545: i NUMBER;
1546: l_return VARCHAR2(2000);

Line 2058: g_newline := fnd_global.newline();

2054: g_rsp_custom_1tom_storage.DELETE;
2055: END sample_package;
2056:
2057: BEGIN
2058: g_newline := fnd_global.newline();
2059: END fnd_plsql_cache;