APPS.FND_FUNCTION_SECURITY dependencies on FND_RESP_FUNCTIONS

Line 143: FROM fnd_resp_functions rf, fnd_responsibility r, fnd_form_functions f

139: BEGIN
140: IF (rule_type = 'F') THEN
141: SELECT 1
142: INTO dummy
143: FROM fnd_resp_functions rf, fnd_responsibility r, fnd_form_functions f
144: WHERE rf.responsibility_id = r.responsibility_id
145: AND rf.application_id = r.application_id
146: AND r.responsibility_key = security_rule_exists.responsibility_key
147: AND rf.rule_type = 'F'

Line 153: FROM fnd_resp_functions rf, fnd_responsibility r, fnd_menus m

149: AND f.function_name = security_rule_exists.rule_name;
150: ELSE
151: SELECT 1
152: INTO dummy
153: FROM fnd_resp_functions rf, fnd_responsibility r, fnd_menus m
154: WHERE rf.responsibility_id = r.responsibility_id
155: AND rf.application_id = r.application_id
156: AND r.responsibility_key = security_rule_exists.responsibility_key
157: AND rf.rule_type = 'M'

Line 453: FROM FND_RESP_FUNCTIONS

449: dummy NUMBER;
450:
451: CURSOR RESP_FUNC IS
452: SELECT APPLICATION_ID, RESPONSIBILITY_ID
453: FROM FND_RESP_FUNCTIONS
454: WHERE rule_type = 'F'
455: AND action_id = form_function.function_id;
456:
457: BEGIN

Line 506: DELETE FROM fnd_resp_functions rf

502: DELETE FROM fnd_form_functions_tl
503: WHERE function_id = form_function.function_id;
504:
505: -- Cascade deletes to resp functions
506: DELETE FROM fnd_resp_functions rf
507: WHERE rf.rule_type = 'F'
508: AND rf.action_id = form_function.function_id;
509:
510: -- Added for Function Security Cache Invalidation Project.

Line 675: FROM FND_RESP_FUNCTIONS

671: dummy NUMBER;
672:
673: CURSOR RESP_FUNC IS
674: SELECT APPLICATION_ID, RESPONSIBILITY_ID
675: FROM FND_RESP_FUNCTIONS
676: WHERE rule_type = 'M'
677: AND action_id = menu.menu_id;
678:
679: CURSOR MN_ENTRY is

Line 746: DELETE FROM fnd_resp_functions rf

742:
743: DELETE FROM fnd_menu_entries_tl
744: WHERE menu_id = menu.menu_id;
745:
746: DELETE FROM fnd_resp_functions rf
747: WHERE rf.rule_type = 'M'
748: AND rf.action_id = menu.menu_id;
749:
750: -- Added for Function Security Cache Invalidation Project.

Line 1112: DELETE FROM fnd_resp_functions

1108: END IF;
1109:
1110: -- Delete if requested
1111: IF (delete_flag = 'Y') THEN
1112: DELETE FROM fnd_resp_functions
1113: WHERE responsibility_id = security_rule.responsibility_id
1114: AND application_id = security_rule.application_id
1115: AND rule_type = security_rule.rule_type
1116: AND action_id = security_rule.action_id;

Line 1125: INSERT INTO fnd_resp_functions (

1121: RETURN;
1122: END IF;
1123:
1124: -- Must always be an insert - nothing to update
1125: INSERT INTO fnd_resp_functions (
1126: application_id,
1127: responsibility_id,
1128: action_id,
1129: rule_type,

Line 1187: FROM FND_RESP_FUNCTIONS

1183: WHERE FUNCTION_ID = newid;
1184:
1185: CURSOR RESP_FUNC IS
1186: SELECT APPLICATION_ID, RESPONSIBILITY_ID
1187: FROM FND_RESP_FUNCTIONS
1188: WHERE rule_type = 'F'
1189: AND action_id = newid;
1190:
1191: BEGIN

Line 1251: UPDATE FND_RESP_FUNCTIONS

1247: FOR mn IN MNU_ENTRY LOOP
1248: fnd_function_security_cache.update_menu_ENTRY(mn.menu_id, mn.sub_menu_id, newid);
1249: END LOOP;
1250:
1251: UPDATE FND_RESP_FUNCTIONS
1252: SET ACTION_ID = oldid
1253: WHERE RULE_TYPE = 'F'
1254: AND ACTION_ID = newid;
1255:

Line 1320: FROM FND_RESP_FUNCTIONS

1316: WHERE MENU_ID = oldid;
1317:
1318: CURSOR RESP_FUNC IS
1319: SELECT APPLICATION_ID, RESPONSIBILITY_ID
1320: FROM FND_RESP_FUNCTIONS
1321: WHERE rule_type = 'M'
1322: AND action_id = newid;
1323:
1324: CURSOR mn_entry IS

Line 1413: UPDATE FND_RESP_FUNCTIONS

1409: UPDATE FND_MENU_ENTRIES_TL
1410: SET MENU_ID = oldid
1411: WHERE MENU_ID = newid;
1412:
1413: UPDATE FND_RESP_FUNCTIONS
1414: SET ACTION_ID = oldid
1415: WHERE RULE_TYPE = 'M'
1416: AND ACTION_ID = newid;
1417: