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_PLSQL_CACHE

Line 1: PACKAGE BODY fnd_plsql_cache AS

1: PACKAGE BODY fnd_plsql_cache AS
2: /* $Header: AFUTPSCB.pls 120.1.12010000.1 2008/07/25 14:23:34 appldev ship $ */
3:
4: -- ----------------------------------------------------------------------
5: -- Error codes

Line 1246: lg_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

1242: PROCEDURE test
1243: IS
1244: TYPE custom_cache_storage_type IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1245:
1246: lg_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
1247: lg_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
1248:
1249: lg_generic_storage fnd_plsql_cache.generic_cache_values_type;
1250: lg_custom_storage custom_cache_storage_type;

Line 1247: lg_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;

1243: IS
1244: TYPE custom_cache_storage_type IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1245:
1246: lg_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
1247: lg_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
1248:
1249: lg_generic_storage fnd_plsql_cache.generic_cache_values_type;
1250: lg_custom_storage custom_cache_storage_type;
1251:

Line 1249: lg_generic_storage fnd_plsql_cache.generic_cache_values_type;

1245:
1246: lg_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
1247: lg_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
1248:
1249: lg_generic_storage fnd_plsql_cache.generic_cache_values_type;
1250: lg_custom_storage custom_cache_storage_type;
1251:
1252: lg_return_code VARCHAR2(1);
1253:

Line 1261: l_value fnd_plsql_cache.generic_cache_value_type;

1257: -- ----------------------------------------------------------------------
1258: PROCEDURE test_generic_1to1_put(p_key IN VARCHAR2,
1259: p_value IN VARCHAR2)
1260: IS
1261: l_value fnd_plsql_cache.generic_cache_value_type;
1262: BEGIN
1263: generic_cache_new_value(l_value,
1264: p_varchar2_1 => p_value);
1265: generic_1to1_put_value(lg_1to1_controller, lg_generic_storage,

Line 1274: l_value fnd_plsql_cache.generic_cache_value_type;

1270: -- ----------------------------------------------------------------------
1271: PROCEDURE test_generic_1to1_get(p_key IN VARCHAR2,
1272: p_is_found_expected IN BOOLEAN)
1273: IS
1274: l_value fnd_plsql_cache.generic_cache_value_type;
1275: BEGIN
1276: generic_1to1_get_value(lg_1to1_controller, lg_generic_storage,
1277: p_key, l_value, lg_return_code);
1278:

Line 1305: l_value fnd_plsql_cache.generic_cache_value_type;

1301: p_value3 IN VARCHAR2 DEFAULT NULL,
1302: p_value4 IN VARCHAR2 DEFAULT NULL,
1303: p_value5 IN VARCHAR2 DEFAULT NULL)
1304: IS
1305: l_value fnd_plsql_cache.generic_cache_value_type;
1306: l_values fnd_plsql_cache.generic_cache_values_type;
1307: l_numof_values NUMBER;
1308: BEGIN
1309: IF (p_value1 IS NOT NULL) THEN

Line 1306: l_values fnd_plsql_cache.generic_cache_values_type;

1302: p_value4 IN VARCHAR2 DEFAULT NULL,
1303: p_value5 IN VARCHAR2 DEFAULT NULL)
1304: IS
1305: l_value fnd_plsql_cache.generic_cache_value_type;
1306: l_values fnd_plsql_cache.generic_cache_values_type;
1307: l_numof_values NUMBER;
1308: BEGIN
1309: IF (p_value1 IS NOT NULL) THEN
1310: generic_cache_new_value(l_value,

Line 1366: l_values fnd_plsql_cache.generic_cache_values_type;

1362: PROCEDURE test_generic_1tom_get(p_key IN VARCHAR2,
1363: p_is_found_expected IN BOOLEAN)
1364: IS
1365: l_numof_values NUMBER;
1366: l_values fnd_plsql_cache.generic_cache_values_type;
1367: BEGIN
1368: generic_1tom_get_values(lg_1tom_controller, lg_generic_storage,
1369: p_key, l_numof_values, l_values,
1370: lg_return_code);

Line 1445: l_indexes fnd_plsql_cache.custom_cache_indexes_type;

1441: p_value3 IN VARCHAR2 DEFAULT NULL,
1442: p_value4 IN VARCHAR2 DEFAULT NULL,
1443: p_value5 IN VARCHAR2 DEFAULT NULL)
1444: IS
1445: l_indexes fnd_plsql_cache.custom_cache_indexes_type;
1446: l_values custom_cache_storage_type;
1447: l_numof_indexes NUMBER;
1448: BEGIN
1449: IF (p_value1 IS NOT NULL) THEN

Line 1507: l_indexes fnd_plsql_cache.custom_cache_indexes_type;

1503: PROCEDURE test_custom_1tom_get(p_key IN VARCHAR2,
1504: p_is_found_expected IN BOOLEAN)
1505: IS
1506: l_numof_indexes NUMBER;
1507: l_indexes fnd_plsql_cache.custom_cache_indexes_type;
1508: BEGIN
1509: custom_1tom_get_get_indexes(lg_1tom_controller,
1510: p_key, l_numof_indexes, l_indexes,
1511: lg_return_code);

Line 1712: g_app_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

1708:
1709: --
1710: -- Application cache, generic version. One value per key
1711: --
1712: g_app_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
1713: g_app_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
1714:
1715: --
1716: -- Application cache, custom version. One value per key

Line 1713: g_app_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

1709: --
1710: -- Application cache, generic version. One value per key
1711: --
1712: g_app_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
1713: g_app_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
1714:
1715: --
1716: -- Application cache, custom version. One value per key
1717: --

Line 1718: g_app_custom_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

1714:
1715: --
1716: -- Application cache, custom version. One value per key
1717: --
1718: g_app_custom_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
1719: g_app_custom_1to1_storage applications_array_type;
1720:
1721: --
1722: -- Responsibility cache, generic version. Many values per key

Line 1724: g_rsp_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;

1720:
1721: --
1722: -- Responsibility cache, generic version. Many values per key
1723: --
1724: g_rsp_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
1725: g_rsp_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
1726:
1727: --
1728: -- Responsibility cache, custom version. Many values per key

Line 1725: g_rsp_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;

1721: --
1722: -- Responsibility cache, generic version. Many values per key
1723: --
1724: g_rsp_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
1725: g_rsp_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
1726:
1727: --
1728: -- Responsibility cache, custom version. Many values per key
1729: --

Line 1730: g_rsp_custom_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;

1726:
1727: --
1728: -- Responsibility cache, custom version. Many values per key
1729: --
1730: g_rsp_custom_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
1731: g_rsp_custom_1tom_storage responsibilities_array_type;
1732:
1733: --
1734: -- Implement your getter functions

Line 1742: l_value fnd_plsql_cache.generic_cache_value_type;

1738: RETURN application_record_type
1739: IS
1740: l_application application_record_type;
1741: l_key VARCHAR2(2000);
1742: l_value fnd_plsql_cache.generic_cache_value_type;
1743: l_return_code VARCHAR2(1);
1744: BEGIN
1745: --
1746: -- Create the key. If you have a composite key then concatenate

Line 1754: fnd_plsql_cache.generic_1to1_get_value(g_app_generic_1to1_controller,

1750:
1751: --
1752: -- First check the cache.
1753: --
1754: fnd_plsql_cache.generic_1to1_get_value(g_app_generic_1to1_controller,
1755: g_app_generic_1to1_storage,
1756: l_key,
1757: l_value,
1758: l_return_code);

Line 1760: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1756: l_key,
1757: l_value,
1758: l_return_code);
1759:
1760: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1761: --
1762: -- Entity is in the cache, populate the return value.
1763: --
1764: l_application.application_id := l_value.number_1;

Line 1780: fnd_plsql_cache.generic_cache_new_value

1776:
1777: --
1778: -- Create the cache value, and populate it with values came from DB.
1779: --
1780: fnd_plsql_cache.generic_cache_new_value
1781: (x_value => l_value,
1782: p_number_1 => l_application.application_id,
1783: p_varchar2_1 => l_application.application_short_name,
1784: p_varchar2_2 => l_application.application_name);

Line 1789: fnd_plsql_cache.generic_1to1_put_value(g_app_generic_1to1_controller,

1785:
1786: --
1787: -- Put the value in cache.
1788: --
1789: fnd_plsql_cache.generic_1to1_put_value(g_app_generic_1to1_controller,
1790: g_app_generic_1to1_storage,
1791: l_key,
1792: l_value);
1793: END IF;

Line 1819: fnd_plsql_cache.custom_1to1_get_get_index(g_app_custom_1to1_controller,

1815:
1816: --
1817: -- First check the cache.
1818: --
1819: fnd_plsql_cache.custom_1to1_get_get_index(g_app_custom_1to1_controller,
1820: l_key,
1821: l_index,
1822: l_return_code);
1823:

Line 1824: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1820: l_key,
1821: l_index,
1822: l_return_code);
1823:
1824: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1825: --
1826: -- Entity is in the cache, populate the return value.
1827: --
1828: l_application := g_app_custom_1to1_storage(l_index);

Line 1842: fnd_plsql_cache.custom_1to1_get_put_index(g_app_custom_1to1_controller,

1838:
1839: --
1840: -- Put the value in cache.
1841: --
1842: fnd_plsql_cache.custom_1to1_get_put_index(g_app_custom_1to1_controller,
1843: l_key,
1844: l_index);
1845: g_app_custom_1to1_storage(l_index) := l_application;
1846: END IF;

Line 1866: l_values fnd_plsql_cache.generic_cache_values_type;

1862: AND r.application_id = a.application_id;
1863:
1864: l_responsibilities responsibilities_array_type;
1865: l_key VARCHAR2(2000);
1866: l_values fnd_plsql_cache.generic_cache_values_type;
1867: l_numof_values NUMBER;
1868: l_return_code VARCHAR2(1);
1869: i NUMBER;
1870: BEGIN

Line 1880: fnd_plsql_cache.generic_1tom_get_values(g_rsp_generic_1tom_controller,

1876:
1877: --
1878: -- First check the cache.
1879: --
1880: fnd_plsql_cache.generic_1tom_get_values(g_rsp_generic_1tom_controller,
1881: g_rsp_generic_1tom_storage,
1882: l_key,
1883: l_numof_values,
1884: l_values,

Line 1887: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1883: l_numof_values,
1884: l_values,
1885: l_return_code);
1886:
1887: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1888: --
1889: -- Entity is in the cache, populate the return values.
1890: --
1891: FOR i IN 1..l_numof_values LOOP

Line 1906: fnd_plsql_cache.generic_cache_new_value

1902: l_responsibilities(i) := r;
1903: --
1904: -- Create the cache value, and populate it with values came from DB.
1905: --
1906: fnd_plsql_cache.generic_cache_new_value
1907: (x_value => l_values(i),
1908: p_number_1 => r.responsibility_id,
1909: p_varchar2_1 => r.responsibility_key,
1910: p_varchar2_2 => r.responsibility_name);

Line 1917: fnd_plsql_cache.generic_1tom_put_values(g_rsp_generic_1tom_controller,

1913: l_numof_values := i;
1914: --
1915: -- Put the values in cache.
1916: --
1917: fnd_plsql_cache.generic_1tom_put_values(g_rsp_generic_1tom_controller,
1918: g_rsp_generic_1tom_storage,
1919: l_key,
1920: l_numof_values,
1921: l_values);

Line 1940: l_indexes fnd_plsql_cache.custom_cache_indexes_type;

1936:
1937: l_responsibilities responsibilities_array_type;
1938: l_key VARCHAR2(2000);
1939: l_numof_indexes NUMBER;
1940: l_indexes fnd_plsql_cache.custom_cache_indexes_type;
1941: l_return_code VARCHAR2(1);
1942: i NUMBER;
1943: BEGIN
1944: --

Line 1953: fnd_plsql_cache.custom_1tom_get_get_indexes(g_rsp_custom_1tom_controller,

1949:
1950: --
1951: -- First check the cache.
1952: --
1953: fnd_plsql_cache.custom_1tom_get_get_indexes(g_rsp_custom_1tom_controller,
1954: l_key,
1955: l_numof_indexes,
1956: l_indexes,
1957: l_return_code);

Line 1959: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1955: l_numof_indexes,
1956: l_indexes,
1957: l_return_code);
1958:
1959: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1960: --
1961: -- Entity is in the cache, populate the return values.
1962: --
1963: FOR i IN 1..l_numof_indexes LOOP

Line 1977: fnd_plsql_cache.custom_1tom_get_put_indexes(g_rsp_generic_1tom_controller,

1973: l_numof_indexes := i;
1974: --
1975: -- Put the values in cache.
1976: --
1977: fnd_plsql_cache.custom_1tom_get_put_indexes(g_rsp_generic_1tom_controller,
1978: l_key,
1979: l_numof_indexes,
1980: l_indexes,
1981: l_return_code);

Line 2031: fnd_plsql_cache.generic_1to1_init('Application Generic 1to1 Cache',

2027: --
2028: --
2029: -- Application Generic 1to1 Cache.
2030: --
2031: fnd_plsql_cache.generic_1to1_init('Application Generic 1to1 Cache',
2032: g_app_generic_1to1_controller,
2033: g_app_generic_1to1_storage);
2034:
2035: --

Line 2038: fnd_plsql_cache.custom_1to1_init('Application Custom 1to1 Cache',

2034:
2035: --
2036: -- Application Custom 1to1 Cache.
2037: --
2038: fnd_plsql_cache.custom_1to1_init('Application Custom 1to1 Cache',
2039: g_app_custom_1to1_controller);
2040: g_app_custom_1to1_storage.DELETE;
2041:
2042: --

Line 2045: fnd_plsql_cache.generic_1tom_init('Responsibilities Generic 1toM Cache',

2041:
2042: --
2043: -- Responsibilities Generic 1toM Cache
2044: --
2045: fnd_plsql_cache.generic_1tom_init('Responsibilities Generic 1toM Cache',
2046: g_rsp_generic_1tom_controller,
2047: g_rsp_generic_1tom_storage);
2048:
2049: --

Line 2052: fnd_plsql_cache.custom_1tom_init('Responsibilities Custom 1toM Cache',

2048:
2049: --
2050: -- Responsibilities Custom 1toM Cache
2051: --
2052: fnd_plsql_cache.custom_1tom_init('Responsibilities Custom 1toM Cache',
2053: g_rsp_custom_1tom_controller);
2054: g_rsp_custom_1tom_storage.DELETE;
2055: END sample_package;
2056:

Line 2059: END fnd_plsql_cache;

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