DBA Data[Home] [Help]

APPS.FND_PLSQL_CACHE dependencies on FND_RESPONSIBILITY_VL

Line 1698: (responsibility_id fnd_responsibility_vl.responsibility_id%TYPE,

1694: TYPE applications_array_type IS TABLE OF application_record_type
1695: INDEX BY BINARY_INTEGER;
1696:
1697: TYPE responsibility_record_type IS RECORD
1698: (responsibility_id fnd_responsibility_vl.responsibility_id%TYPE,
1699: responsibility_key fnd_responsibility_vl.responsibility_key%TYPE,
1700: responsibility_name fnd_responsibility_vl.responsibility_name%TYPE);
1701:
1702: TYPE responsibilities_array_type IS TABLE OF responsibility_record_type

Line 1699: responsibility_key fnd_responsibility_vl.responsibility_key%TYPE,

1695: INDEX BY BINARY_INTEGER;
1696:
1697: TYPE responsibility_record_type IS RECORD
1698: (responsibility_id fnd_responsibility_vl.responsibility_id%TYPE,
1699: responsibility_key fnd_responsibility_vl.responsibility_key%TYPE,
1700: responsibility_name fnd_responsibility_vl.responsibility_name%TYPE);
1701:
1702: TYPE responsibilities_array_type IS TABLE OF responsibility_record_type
1703: INDEX BY BINARY_INTEGER;

Line 1700: responsibility_name fnd_responsibility_vl.responsibility_name%TYPE);

1696:
1697: TYPE responsibility_record_type IS RECORD
1698: (responsibility_id fnd_responsibility_vl.responsibility_id%TYPE,
1699: responsibility_key fnd_responsibility_vl.responsibility_key%TYPE,
1700: responsibility_name fnd_responsibility_vl.responsibility_name%TYPE);
1701:
1702: TYPE responsibilities_array_type IS TABLE OF responsibility_record_type
1703: INDEX BY BINARY_INTEGER;
1704:

Line 1860: FROM fnd_responsibility_vl r, fnd_application a

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;

Line 1933: FROM fnd_responsibility_vl r, fnd_application a

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;