APPS.FND_PLSQL_CACHE dependencies on FND_APPLICATION_VL

Line 1690: (application_id fnd_application_vl.application_id%TYPE,

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

Line 1691: application_short_name fnd_application_vl.application_short_name%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;

Line 1692: application_name fnd_application_vl.application_name%TYPE);

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:

Line 1774: FROM fnd_application_vl

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.

Line 1836: FROM fnd_application_vl

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.