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_FORM_FUNCTIONS

Line 50: FROM fnd_form_functions f

46: dummy NUMBER;
47: BEGIN
48: SELECT 1
49: INTO dummy
50: FROM fnd_form_functions f
51: WHERE f.function_name = form_function_exists.function_name;
52:
53: RETURN TRUE;
54: EXCEPTION

Line 104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f

100: dummy NUMBER;
101: BEGIN
102: SELECT 1
103: INTO dummy
104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f
105: WHERE me.menu_id = m.menu_id
106: AND m.menu_name = menu_entry_exists.menu_name
107: AND me.sub_menu_id = s.menu_id (+)
108: AND nvl(s.menu_name, 'x') = nvl(menu_entry_exists.sub_menu_name, 'x')

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 461: FROM fnd_form_functions

457: BEGIN
458: BEGIN
459: SELECT function_id
460: INTO form_function.function_id
461: FROM fnd_form_functions
462: WHERE function_name = form_function.function_name;
463: EXCEPTION
464: WHEN no_data_found THEN
465: function_id := -1;

Line 496: DELETE FROM fnd_form_functions

492: RETURN;
493: END;
494: END IF;
495:
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);

Line 502: DELETE FROM fnd_form_functions_tl

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:
505: -- Cascade deletes to resp functions
506: DELETE FROM fnd_resp_functions rf

Line 526: FROM fnd_form_functions_vl ff

522: namebuf := form_function.user_function_name;
523: LOOP
524: SELECT count(1)
525: INTO dummy
526: FROM fnd_form_functions_vl ff
527: WHERE ff.user_function_name = namebuf
528: AND ff.function_id <> form_function.function_id;
529:
530: EXIT WHEN dummy = 0;

Line 548: SELECT fnd_form_functions_s.NEXTVAL

544:
545: -- Decide if this is insert or update
546: IF (function_id = -1) THEN
547:
548: SELECT fnd_form_functions_s.NEXTVAL
549: INTO form_function.function_id
550: FROM dual;
551:
552: -- Insert into base

Line 553: INSERT INTO fnd_form_functions (

549: INTO form_function.function_id
550: FROM dual;
551:
552: -- Insert into base
553: INSERT INTO fnd_form_functions (
554: function_id,
555: function_name,
556: application_id,
557: form_id,

Line 583: INSERT INTO fnd_form_functions_tl (

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,
585: function_id,
586: user_function_name,
587: description,

Line 605: FROM fnd_form_functions f, fnd_languages l

601: sysdate,
602: 1,
603: 1,
604: userenv('LANG')
605: FROM fnd_form_functions f, fnd_languages l
606: WHERE f.function_name = form_function.function_name
607: AND l.installed_flag IN ('I', 'B');
608:
609: RETURN;

Line 613: UPDATE fnd_form_functions SET

609: RETURN;
610: END IF;
611:
612: -- Update base
613: UPDATE fnd_form_functions SET
614: application_id = form_function.application_id,
615: form_id = form_function.form_id,
616: PARAMETERS = form_function.PARAMETERS,
617: last_update_date = sysdate,

Line 627: UPDATE fnd_form_functions_tl SET

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,
629: description = form_function.description,
630: last_update_date = sysdate,
631: last_updated_by = 1,

Line 915: FROM fnd_form_functions

911: -- Get function_id
912: IF (function_name IS NOT NULL) THEN
913: SELECT function_id
914: INTO menu_entry.function_id
915: FROM fnd_form_functions
916: WHERE function_name = menu_entry.function_name;
917: END IF;
918:
919: -- Find local entry sequence matching submenu/function pair.

Line 1101: FROM fnd_form_functions

1097: -- Get action id
1098: IF (rule_type = 'F') THEN
1099: SELECT function_id
1100: INTO security_rule.action_id
1101: FROM fnd_form_functions
1102: WHERE function_name = security_rule.rule_name;
1103: ELSE
1104: SELECT menu_id
1105: INTO security_rule.action_id

Line 1196: FROM FND_FORM_FUNCTIONS

1192: -- Find which function names have already been changed
1193: BEGIN
1194: SELECT FUNCTION_ID
1195: INTO oldid
1196: FROM FND_FORM_FUNCTIONS
1197: WHERE FUNCTION_NAME = oldname;
1198: EXCEPTION
1199: WHEN no_data_found THEN
1200: oldid := -1;

Line 1206: FROM FND_FORM_FUNCTIONS

1202:
1203: BEGIN
1204: SELECT FUNCTION_ID
1205: INTO newid
1206: FROM FND_FORM_FUNCTIONS
1207: WHERE FUNCTION_NAME = newname;
1208: EXCEPTION
1209: WHEN no_data_found THEN
1210: newid := -1;

Line 1225: UPDATE FND_FORM_FUNCTIONS

1221: END IF;
1222:
1223: -- If only oldname exists, only update oldname to newname
1224: IF ((oldid <> -1) AND (newid = -1)) THEN
1225: UPDATE FND_FORM_FUNCTIONS
1226: SET FUNCTION_NAME = newname
1227: WHERE FUNCTION_NAME = oldname;
1228:
1229: -- Added for Function Security Cache Invalidation Project.

Line 1268: DELETE FROM FND_FORM_FUNCTIONS

1264: WHERE FUNCTION_TYPE = 'F'
1265: AND FUNCTION_ID = newid;
1266:
1267: -- 2. Delete new row
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);

Line 1274: DELETE FROM FND_FORM_FUNCTIONS_TL

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:
1277: -- 3. Update oldname to newname in old row
1278: UPDATE FND_FORM_FUNCTIONS

Line 1278: UPDATE FND_FORM_FUNCTIONS

1274: DELETE FROM FND_FORM_FUNCTIONS_TL
1275: WHERE FUNCTION_ID = newid;
1276:
1277: -- 3. Update oldname to newname in old row
1278: UPDATE FND_FORM_FUNCTIONS
1279: SET FUNCTION_NAME = newname
1280: WHERE FUNCTION_ID = oldid;
1281:
1282: -- Added for Function Security Cache Invalidation Project.