1686: --
1687: -- Declare your data types
1688: --
1689: TYPE application_record_type IS RECORD
1690: (application_id fnd_application_vl.application_id%TYPE,
1691: application_short_name fnd_application_vl.application_short_name%TYPE,
1692: application_name fnd_application_vl.application_name%TYPE);
1693:
1694: TYPE applications_array_type IS TABLE OF application_record_type
1687: -- Declare your data types
1688: --
1689: TYPE application_record_type IS RECORD
1690: (application_id fnd_application_vl.application_id%TYPE,
1691: application_short_name fnd_application_vl.application_short_name%TYPE,
1692: application_name fnd_application_vl.application_name%TYPE);
1693:
1694: TYPE applications_array_type IS TABLE OF application_record_type
1695: INDEX BY BINARY_INTEGER;
1688: --
1689: TYPE application_record_type IS RECORD
1690: (application_id fnd_application_vl.application_id%TYPE,
1691: application_short_name fnd_application_vl.application_short_name%TYPE,
1692: application_name fnd_application_vl.application_name%TYPE);
1693:
1694: TYPE applications_array_type IS TABLE OF application_record_type
1695: INDEX BY BINARY_INTEGER;
1696:
1770: -- Entity is not in the cache, get it from DB.
1771: --
1772: SELECT application_id, application_short_name, application_name
1773: INTO l_application
1774: FROM fnd_application_vl
1775: WHERE application_short_name = p_application_short_name;
1776:
1777: --
1778: -- Create the cache value, and populate it with values came from DB.
1832: -- Entity is not in the cache, get it from DB.
1833: --
1834: SELECT application_id, application_short_name, application_name
1835: INTO l_application
1836: FROM fnd_application_vl
1837: WHERE application_short_name = p_application_short_name;
1838:
1839: --
1840: -- Put the value in cache.