APPS.FND_FUNCTION_SECURITY dependencies on FND_RESPONSIBILITY

Line 25: FROM fnd_responsibility r

21: dummy NUMBER;
22: BEGIN
23: SELECT 1
24: INTO dummy
25: FROM fnd_responsibility r
26: WHERE r.responsibility_key = responsibility_exists.responsibility_key;
27:
28: RETURN TRUE;
29: EXCEPTION

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 242: UPDATE fnd_responsibility

238:
239: -- Delete if requested
240: IF (delete_flag <> 'N') THEN
241: -- Resps are never deleted. Set the end_date instead.
242: UPDATE fnd_responsibility
243: SET end_date = sysdate
244: WHERE responsibility_key = responsibility.responsibility_key;
245:
246: -- Added for Function Security Cache Invalidation Project.

Line 260: FROM fnd_responsibility_vl fr

256: namebuf := responsibility.responsibility_name;
257: LOOP
258: SELECT count(1)
259: INTO dummy
260: FROM fnd_responsibility_vl fr
261: WHERE fr.responsibility_name = namebuf
262: AND (fr.responsibility_id <> responsibility.responsibility_id
263: OR fr.application_id <> responsibility.application_id);
264:

Line 300: FROM fnd_responsibility r

296: -- Select to decide if this is insert or update
297: BEGIN
298: SELECT responsibility_id
299: INTO dummy
300: FROM fnd_responsibility r
301: WHERE r.responsibility_key = responsibility.responsibility_key;
302: EXCEPTION
303: WHEN no_data_found THEN
304: -- Insert into base

Line 305: INSERT INTO fnd_responsibility (

301: WHERE r.responsibility_key = responsibility.responsibility_key;
302: EXCEPTION
303: WHEN no_data_found THEN
304: -- Insert into base
305: INSERT INTO fnd_responsibility (
306: application_id,
307: responsibility_id,
308: responsibility_key,
309: creation_date,

Line 351: INSERT INTO fnd_responsibility_tl (

347: fnd_function_security_cache.insert_resp(responsibility.responsibility_id,
348: responsibility.application_id);
349:
350: -- Insert into tl
351: INSERT INTO fnd_responsibility_tl (
352: application_id,
353: responsibility_id,
354: LANGUAGE,
355: responsibility_name,

Line 382: UPDATE fnd_responsibility r

378: RETURN;
379: END;
380:
381: -- Update existing row
382: UPDATE fnd_responsibility r
383: SET responsibility_key = responsibility.responsibility_key,
384: START_DATE = responsibility.START_DATE,
385: end_date = responsibility.end_date,
386: data_group_id = responsibility.data_group_id,

Line 402: UPDATE fnd_responsibility_tl r

398: fnd_function_security_cache.update_resp(responsibility.responsibility_id,
399: responsibility.application_id);
400:
401: -- Update TL
402: UPDATE fnd_responsibility_tl r
403: SET responsibility_name = namebuf,
404: description = responsibility.description
405: WHERE r.responsibility_id = responsibility.responsibility_id
406: AND r.application_id = responsibility.application_id

Line 714: FROM fnd_responsibility r

710: INTO dummy
711: FROM sys.dual
712: WHERE NOT EXISTS
713: (SELECT 1
714: FROM fnd_responsibility r
715: WHERE r.menu_id = menu.menu_id);
716:
717: EXCEPTION
718: WHEN no_data_found THEN

Line 1094: FROM fnd_responsibility fr

1090:
1091: -- Get responsibility ids
1092: SELECT fr.responsibility_id, fr.application_id
1093: INTO security_rule.responsibility_id, security_rule.application_id
1094: FROM fnd_responsibility fr
1095: WHERE fr.responsibility_key = security_rule.responsibility_key;
1096:
1097: -- Get action id
1098: IF (rule_type = 'F') THEN

Line 1315: FROM FND_RESPONSIBILITY

1311: newid NUMBER;
1312:
1313: CURSOR RESP_CURSOR IS
1314: SELECT RESPONSIBILITY_ID, APPLICATION_ID
1315: FROM FND_RESPONSIBILITY
1316: WHERE MENU_ID = oldid;
1317:
1318: CURSOR RESP_FUNC IS
1319: SELECT APPLICATION_ID, RESPONSIBILITY_ID

Line 1389: UPDATE FND_RESPONSIBILITY

1385: FOR mn IN mn_entry LOOP
1386: fnd_function_security_cache.update_menu_entry(newid, mn.sub_menu_id, mn.function_id);
1387: END LOOP;
1388:
1389: UPDATE FND_RESPONSIBILITY
1390: SET MENU_ID = oldid
1391: WHERE MENU_ID = newid;
1392:
1393: -- Added for Function Security Cache Invalidation Project.