eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FUNCTION_SECURITY dependencies on FND_FUNCTION_SECURITY

Line 1: PACKAGE BODY FND_FUNCTION_SECURITY AS

1: PACKAGE BODY FND_FUNCTION_SECURITY AS
2: /* $Header: AFSCFUNB.pls 115.10 2004/05/25 22:58:39 pdeluna ship $ */
3:
4:
5: --

Line 247: fnd_function_security_cache.update_resp(responsibility.responsibility_id,

243: SET end_date = sysdate
244: WHERE responsibility_key = responsibility.responsibility_key;
245:
246: -- Added for Function Security Cache Invalidation Project.
247: fnd_function_security_cache.update_resp(responsibility.responsibility_id,
248: responsibility.application_id);
249:
250: RETURN;
251: END IF;

Line 347: fnd_function_security_cache.insert_resp(responsibility.responsibility_id,

343: responsibility.web_agent_name
344: );
345:
346: -- Added for Function Security Cache Invalidation Project.
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 (

Line 398: fnd_function_security_cache.update_resp(responsibility.responsibility_id,

394: WHERE r.responsibility_id = responsibility.responsibility_id
395: AND r.application_id = responsibility.application_id;
396:
397: -- Added for Function Security Cache Invalidation Project.
398: fnd_function_security_cache.update_resp(responsibility.responsibility_id,
399: responsibility.application_id);
400:
401: -- Update TL
402: UPDATE fnd_responsibility_tl r

Line 500: fnd_function_security_cache.delete_function(form_function.function_id);

496: DELETE FROM fnd_form_functions
497: WHERE function_id = form_function.function_id;
498:
499: -- Added for Function Security Cache Invalidation Project.
500: fnd_function_security_cache.delete_function(form_function.function_id);
501:
502: DELETE FROM fnd_form_functions_tl
503: WHERE function_id = form_function.function_id;
504:

Line 513: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);

509:
510: -- Added for Function Security Cache Invalidation Project.
511: -- Seems that I need make sure that each responsibility excluded is taken into account.
512: FOR rs IN RESP_FUNC LOOP
513: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);
514: END LOOP;
515:
516: RETURN;
517: END IF;

Line 580: fnd_function_security_cache.insert_function(form_function.function_id);

576: form_function.TYPE
577: FROM sys.dual;
578:
579: -- Added for Function Security Cache Invalidation Project.
580: fnd_function_security_cache.insert_function(form_function.function_id);
581:
582: -- Insert into _TL
583: INSERT INTO fnd_form_functions_tl (
584: LANGUAGE,

Line 624: fnd_function_security_cache.update_function(form_function.function_id);

620: TYPE = form_function.TYPE
621: WHERE function_id = form_function.function_id;
622:
623: -- Added for Function Security Cache Invalidation Project.
624: fnd_function_security_cache.update_function(form_function.function_id);
625:
626: -- Update TL
627: UPDATE fnd_form_functions_tl SET
628: user_function_name = form_function.namebuf,

Line 727: fnd_function_security_cache.delete_menu(menu.menu_id);

723: DELETE FROM fnd_menus
724: WHERE menu_id = menu.menu_id;
725:
726: -- Added for Function Security Cache Invalidation Project.
727: fnd_function_security_cache.delete_menu(menu.menu_id);
728:
729: DELETE FROM fnd_menus_tl
730: WHERE menu_id = menu.menu_id;
731:

Line 739: fnd_function_security_cache.delete_menu_entry(menu.menu_id,

735:
736: -- Added for Function Security Cache Invalidation Project.
737: -- Need make sure that each menu entry deleted is taken into account.
738: FOR mn IN MN_ENTRY LOOP
739: fnd_function_security_cache.delete_menu_entry(menu.menu_id,
740: mn.sub_menu_id, mn.function_id);
741: END LOOP;
742:
743: DELETE FROM fnd_menu_entries_tl

Line 753: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);

749:
750: -- Added for Function Security Cache Invalidation Project.
751: -- Need make sure that each responsibility updated is taken into account.
752: FOR rs IN RESP_FUNC LOOP
753: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);
754: END LOOP;
755:
756: RETURN;
757: END IF;

Line 805: fnd_function_security_cache.insert_menu(menu.menu_id);

801: FROM sys.dual;
802:
803:
804: -- Added for Function Security Cache Invalidation Project.
805: fnd_function_security_cache.insert_menu(menu.menu_id);
806:
807: -- Insert into _TL
808: INSERT INTO fnd_menus_tl (
809: LANGUAGE,

Line 851: FND_FUNCTION_SECURITY_CACHE.update_menu(menu.menu_id);

847: WHERE menu_id = menu.menu_id
848: AND userenv('LANG') IN (LANGUAGE, source_lang);
849:
850: -- Added for Function Security Cache Invalidation Project
851: FND_FUNCTION_SECURITY_CACHE.update_menu(menu.menu_id);
852:
853: END MENU;
854:
855: --

Line 953: fnd_function_security_cache.delete_menu_entry(menu_entry.menu_id,

949:
950: -- Added for Function Security Cache Invalidation Project.
951: -- If menu_id exists, then sub_menu_id and function_id also exist and has already been
952: -- derived above.
953: fnd_function_security_cache.delete_menu_entry(menu_entry.menu_id,
954: menu_entry.sub_menu_id, menu_entry.function_id);
955:
956: DELETE FROM fnd_menu_entries_tl
957: WHERE menu_id = menu_entry.menu_id

Line 997: fnd_function_security_cache.insert_menu_entry(menu_entry.menu_id,

993: 1
994: );
995:
996: -- Added for Function Security Cache Invalidation Project.
997: fnd_function_security_cache.insert_menu_entry(menu_entry.menu_id,
998: menu_entry.sub_menu_id, menu_entry.function_id);
999:
1000: -- Insert into _TL
1001: INSERT INTO fnd_menu_entries_tl (

Line 1042: fnd_function_security_cache.update_menu_entry(menu_entry.menu_id,

1038: WHERE menu_id = menu_entry.menu_id
1039: AND entry_sequence = l_entry_sequence;
1040:
1041: -- Added for Function Security Cache Invalidation Project.
1042: fnd_function_security_cache.update_menu_entry(menu_entry.menu_id,
1043: menu_entry.sub_menu_id, menu_entry.function_id);
1044:
1045: -- Update TL
1046: UPDATE fnd_menu_entries_tl

Line 1119: fnd_function_security_cache.update_resp(security_rule.responsibility_id, security_rule.application_id);

1115: AND rule_type = security_rule.rule_type
1116: AND action_id = security_rule.action_id;
1117:
1118: -- Added for Function Security Cache Invalidation Project.
1119: fnd_function_security_cache.update_resp(security_rule.responsibility_id, security_rule.application_id);
1120:
1121: RETURN;
1122: END IF;
1123:

Line 1147: fnd_function_security_cache.update_resp(security_rule.responsibility_id,

1143: sysdate,
1144: 1);
1145:
1146: -- Added for Function Security Cache Invalidation Project.
1147: fnd_function_security_cache.update_resp(security_rule.responsibility_id,
1148: security_rule.application_id);
1149:
1150: -- No TL table
1151:

Line 1230: fnd_function_security_cache.update_function(oldid);

1226: SET FUNCTION_NAME = newname
1227: WHERE FUNCTION_NAME = oldname;
1228:
1229: -- Added for Function Security Cache Invalidation Project.
1230: fnd_function_security_cache.update_function(oldid);
1231:
1232: RETURN;
1233: END IF;
1234:

Line 1248: fnd_function_security_cache.update_menu_ENTRY(mn.menu_id, mn.sub_menu_id, newid);

1244:
1245: -- Added for Function Security Cache Invalidation Project.
1246: -- Need make sure that each menu entry updated is taken into account.
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

Line 1259: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);

1255:
1256: -- Added for Function Security Cache Invalidation Project.
1257: -- Need make sure that each responsibility updated is taken into account.
1258: FOR rs IN RESP_FUNC LOOP
1259: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);
1260: END LOOP;
1261:
1262: UPDATE FND_ATTACHMENT_FUNCTIONS
1263: SET FUNCTION_ID = oldid

Line 1272: fnd_function_security_cache.update_function(newid);

1268: DELETE FROM FND_FORM_FUNCTIONS
1269: WHERE FUNCTION_ID = newid;
1270:
1271: -- Added for Function Security Cache Invalidation Project.
1272: fnd_function_security_cache.update_function(newid);
1273:
1274: DELETE FROM FND_FORM_FUNCTIONS_TL
1275: WHERE FUNCTION_ID = newid;
1276:

Line 1283: fnd_function_security_cache.update_function(oldid);

1279: SET FUNCTION_NAME = newname
1280: WHERE FUNCTION_ID = oldid;
1281:
1282: -- Added for Function Security Cache Invalidation Project.
1283: fnd_function_security_cache.update_function(oldid);
1284:
1285: END UPDATE_FUNCTION_NAME;
1286:
1287: --

Line 1368: fnd_function_security_cache.update_menu(oldid);

1364: SET MENU_NAME = newname
1365: WHERE MENU_NAME = oldname;
1366:
1367: -- Added for Function Security Cache Invalidation Project.
1368: fnd_function_security_cache.update_menu(oldid);
1369:
1370: RETURN;
1371: END IF;
1372:

Line 1386: fnd_function_security_cache.update_menu_entry(newid, mn.sub_menu_id, mn.function_id);

1382:
1383: -- Added for Function Security Cache Invalidation Project.
1384: -- Need make sure that each menu entry updated is taken into account.
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

Line 1396: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);

1392:
1393: -- Added for Function Security Cache Invalidation Project.
1394: -- Need make sure that each responsibility updated is taken into account.
1395: FOR rs IN RESP_CURSOR LOOP
1396: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);
1397: END LOOP;
1398:
1399: UPDATE FND_MENU_ENTRIES
1400: SET MENU_ID = oldid

Line 1406: fnd_function_security_cache.update_menu_entry(newid, mn.sub_menu_id, mn.function_id);

1402:
1403: -- Added for Function Security Cache Invalidation Project.
1404: -- Need make sure that each menu entry updated is taken into account.
1405: FOR mn IN mn_entry LOOP
1406: fnd_function_security_cache.update_menu_entry(newid, mn.sub_menu_id, mn.function_id);
1407: END LOOP;
1408:
1409: UPDATE FND_MENU_ENTRIES_TL
1410: SET MENU_ID = oldid

Line 1421: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);

1417:
1418: -- Added for Function Security Cache Invalidation Project.
1419: -- Seems that I need make sure that each responsibility updated is taken into account.
1420: FOR rs IN RESP_FUNC LOOP
1421: fnd_function_security_cache.update_resp(rs.responsibility_id, rs.application_id);
1422: END LOOP;
1423:
1424: -- 2. Delete new row
1425: DELETE FROM FND_MENUS

Line 1429: fnd_function_security_cache.update_menu(newid);

1425: DELETE FROM FND_MENUS
1426: WHERE MENU_ID = newid;
1427:
1428: -- Added for Function Security Cache Invalidation Project.
1429: fnd_function_security_cache.update_menu(newid);
1430:
1431: DELETE FROM FND_MENUS_TL
1432: WHERE MENU_ID = newid;
1433:

Line 1440: fnd_function_security_cache.update_menu(oldid);

1436: SET MENU_NAME = newname
1437: WHERE MENU_ID = oldid;
1438:
1439: -- Added for Function Security Cache Invalidation Project.
1440: fnd_function_security_cache.update_menu(oldid);
1441:
1442: END UPDATE_MENU_NAME;
1443:
1444: END FND_FUNCTION_SECURITY;

Line 1444: END FND_FUNCTION_SECURITY;

1440: fnd_function_security_cache.update_menu(oldid);
1441:
1442: END UPDATE_MENU_NAME;
1443:
1444: END FND_FUNCTION_SECURITY;