[Home] [Help]
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.
1856: RETURN responsibilities_array_type
1857: IS
1858: CURSOR resp_cursor IS
1859: SELECT r.responsibility_id, r.responsibility_key, r.responsibility_name
1860: FROM fnd_responsibility_vl r, fnd_application a
1861: WHERE a.application_short_name = p_application_short_name
1862: AND r.application_id = a.application_id;
1863:
1864: l_responsibilities responsibilities_array_type;
1929: RETURN responsibilities_array_type
1930: IS
1931: CURSOR resp_cursor IS
1932: SELECT r.responsibility_id, r.responsibility_key, r.responsibility_name
1933: FROM fnd_responsibility_vl r, fnd_application a
1934: WHERE a.application_short_name = p_application_short_name
1935: AND r.application_id = a.application_id;
1936:
1937: l_responsibilities responsibilities_array_type;
1991: END get_responsibilities_custom;
1992:
1993: PROCEDURE any_procedure
1994: IS
1995: l_fnd_application application_record_type;
1996: l_fnd_responsibilities responsibilities_array_type;
1997: BEGIN
1998: --
1999: -- This will hit the DB
1997: BEGIN
1998: --
1999: -- This will hit the DB
2000: --
2001: l_fnd_application := get_application_generic('FND');
2002: l_fnd_responsibilities := get_responsibilities_generic('FND');
2003:
2004: --
2005: -- This will get it from cache.
2003:
2004: --
2005: -- This will get it from cache.
2006: --
2007: l_fnd_application := get_application_generic('FND');
2008: l_fnd_responsibilities := get_responsibilities_generic('FND');
2009:
2010: --
2011: -- This will hit the DB
2009:
2010: --
2011: -- This will hit the DB
2012: --
2013: l_fnd_application := get_application_custom('FND');
2014: l_fnd_responsibilities := get_responsibilities_custom('FND');
2015:
2016: --
2017: -- This will get it from cache.
2015:
2016: --
2017: -- This will get it from cache.
2018: --
2019: l_fnd_application := get_application_custom('FND');
2020: l_fnd_responsibilities := get_responsibilities_custom('FND');
2021:
2022: END any_procedure;
2023: