DBA Data[Home] [Help]

APPS.FND_FUNCTION dependencies on FND_RESP_FUNCTIONS

Line 258: SELECT RULE_TYPE, ACTION_ID from fnd_resp_functions

254:
255:
256: /* Cursor to get exclusions */
257: cursor excl_c is
258: SELECT RULE_TYPE, ACTION_ID from fnd_resp_functions
259: where application_id = p_appl_id
260: and responsibility_id = p_resp_id;
261:
262: /* Cursor to get menu entries on a particular menu.*/

Line 281: -- Populate the list of exclusions by selecting from FND_RESP_FUNCTIONS

277: --
278: -- This routine processes the menu hierarchy and exclusion rules in PL/SQL
279: -- rather than in the database.
280: -- The basic algorithm of this routine is:
281: -- Populate the list of exclusions by selecting from FND_RESP_FUNCTIONS
282: -- menulist(1) = p_menu_id
283: -- while (elements on menulist)
284: -- {
285: -- Remove first element off menulist

Line 944: from fnd_resp_functions

940: begin
941: /* See if there are any exclusions */
942: select 1
943: into dummy
944: from fnd_resp_functions
945: where responsibility_id = l_resp_id
946: and application_id = l_resp_appl_id
947: and rownum = 1;
948: