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 dependencies on FND_COMPILED_MENU_FUNCTIONS

Line 688: insert into fnd_compiled_menu_functions

684: ' CUR_MNES(i).FUNCTION_ID:'|| to_char(CUR_MNES(i).FUNCTION_ID) ||
685: ' CUR_MNES(i).GRANT_FLAG:'|| CUR_MNES(i).GRANT_FLAG);
686: end if;
687: begin
688: insert into fnd_compiled_menu_functions
689: (menu_id, function_id, grant_flag)
690: values
691: (CUR_MNES(i).MENU_ID, C_INVALID_MENU_VAL, C_INVALID_GRANT_VAL);
692: commit;

Line 1098: from fnd_compiled_menu_functions

1094: some_compiled_menus := FALSE;
1095: begin
1096: select 1
1097: into dummy
1098: from fnd_compiled_menu_functions
1099: where menu_id = p_menu_id
1100: and rownum = 1;
1101: /* If we got here, there are compiled rows */
1102: some_compiled_menus := TRUE;

Line 1120: from fnd_compiled_menu_functions

1116: if (some_compiled_menus) then
1117: begin
1118: select 1
1119: into dummy
1120: from fnd_compiled_menu_functions
1121: where menu_id = p_menu_id
1122: and grant_flag = C_INVALID_GRANT_VAL
1123: and rownum = 1;
1124: /* If we got here we know this is marked as not compiled. */

Line 1151: from fnd_compiled_menu_functions

1147: end if;
1148:
1149: select 1
1150: into dummy
1151: from fnd_compiled_menu_functions
1152: where menu_id = p_menu_id
1153: and function_id = p_function_id
1154: and grant_flag = 'Y' ;
1155: else

Line 1165: from fnd_compiled_menu_functions

1161: end if;
1162:
1163: select 1
1164: into dummy
1165: from fnd_compiled_menu_functions
1166: where menu_id = p_menu_id
1167: and function_id = p_function_id;
1168: end if;
1169:

Line 1924: from fnd_compiled_menu_functions cmf

1920: cursor get_missing_menus_c is
1921: select /*+ INDEX_FFS(menus) */ menu_id from fnd_menus menus
1922: where not exists
1923: (select 'X'
1924: from fnd_compiled_menu_functions cmf
1925: where menus.menu_id = cmf.menu_id);
1926: z number;
1927: begin
1928: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

Line 1976: insert into fnd_compiled_menu_functions

1972:
1973: /* mark that menu as uncompiled */
1974: for q in 1..last_index loop
1975: begin
1976: insert into fnd_compiled_menu_functions
1977: (menu_id, function_id, grant_flag)
1978: values
1979: (tbl_menu_id(q), C_INVALID_MENU_VAL, C_INVALID_GRANT_VAL);
1980: -- We commit the menu mark in order to keep the rollback segment

Line 2038: /+ INDEX (fnd_compiled_menu_functions fnd_compiled_menu_functions_n3) /

2034: while (TRUE) loop
2035: /* Find a menu that needs compilation */
2036: begin /* The hint below was suggested to avoid FTS in bug 2078561 */
2037: select
2038: /*+ INDEX (fnd_compiled_menu_functions fnd_compiled_menu_functions_n3) */
2039: menu_id
2040: into l_menu_id
2041: from fnd_compiled_menu_functions
2042: where grant_flag = C_INVALID_GRANT_VAL

Line 2041: from fnd_compiled_menu_functions

2037: select
2038: /*+ INDEX (fnd_compiled_menu_functions fnd_compiled_menu_functions_n3) */
2039: menu_id
2040: into l_menu_id
2041: from fnd_compiled_menu_functions
2042: where grant_flag = C_INVALID_GRANT_VAL
2043: and rownum = 1;
2044: exception
2045: when no_data_found then

Line 2111: -- Other packages that reference FND_COMPILED_MENU_FUNCTIONS should

2107: --
2108: -- Recompiles all the marked menus if and only if they haven't yet
2109: -- been already compiled in this session.
2110: --
2111: -- Other packages that reference FND_COMPILED_MENU_FUNCTIONS should
2112: -- call it like this in their package initialization block:
2113: --
2114: -- if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
2115: -- FND_FUNCTION.FAST_COMPILE;

Line 2119: -- the FND_COMPILED_MENU_FUNCTIONS table, like this:

2115: -- FND_FUNCTION.FAST_COMPILE;
2116: -- end if;
2117: --
2118: -- Administrators can also call it from SQL*Plus in order to compile
2119: -- the FND_COMPILED_MENU_FUNCTIONS table, like this:
2120: --
2121: -- execute FND_FUNCTION.FAST_COMPILE;
2122: --
2123: procedure FAST_COMPILE is

Line 2134: /+ INDEX (fnd_compiled_menu_functions fnd_compiled_menu_functions_n3) /

2130: -- Check if any menus need compilation bug5184601
2131: begin
2132:
2133: select
2134: /*+ INDEX (fnd_compiled_menu_functions fnd_compiled_menu_functions_n3) */
2135: MENU_ID into L_MENU_ID
2136: from FND_COMPILED_MENU_FUNCTIONS
2137: where GRANT_FLAG = C_INVALID_GRANT_VAL
2138: and ROWNUM = 1;

Line 2136: from FND_COMPILED_MENU_FUNCTIONS

2132:
2133: select
2134: /*+ INDEX (fnd_compiled_menu_functions fnd_compiled_menu_functions_n3) */
2135: MENU_ID into L_MENU_ID
2136: from FND_COMPILED_MENU_FUNCTIONS
2137: where GRANT_FLAG = C_INVALID_GRANT_VAL
2138: and ROWNUM = 1;
2139: exception
2140: when NO_DATA_FOUND then

Line 2162: -- Delete all rows from fnd_compiled_menu_functions for this menu_id

2158: --
2159: -- COMPILE_MENU_MARKED_I
2160: -- if (not force mode) and (this menu is not marked)
2161: -- return; we're done
2162: -- Delete all rows from fnd_compiled_menu_functions for this menu_id
2163: -- for each menu_entry on this menu
2164: -- if this is a function
2165: -- add it to the compiled table
2166: -- if this is a menu

Line 2202: from fnd_compiled_menu_functions

2198:
2199: l_submnu_id NUMBER;
2200: cursor get_compiled_menu_fns_c is
2201: select function_id, grant_flag
2202: from fnd_compiled_menu_functions
2203: where menu_id = l_submnu_id
2204: and grant_flag <> C_INVALID_GRANT_VAL
2205: and grant_flag <> C_BLANK_GRANT_VAL;
2206: TBL_COPY_FUNC_ID NUMBER_TABLE_TYPE;

Line 2231: from fnd_compiled_menu_functions

2227: if((p_force is NULL) OR (p_force <> 'Y')) then
2228: begin
2229: select 1
2230: into dummy
2231: from fnd_compiled_menu_functions
2232: where menu_id = p_menu_id
2233: and grant_flag = C_INVALID_GRANT_VAL
2234: and rownum = 1;
2235: exception

Line 2263: delete from fnd_compiled_menu_functions

2259: TBL_RECURS_DETEC_MENU_ID(TBL_RECURS_DETEC_MENU_ID_MAX) := p_menu_id;
2260:
2261: /* If we havent already deleted the data for this menu, delete it now. */
2262: begin
2263: delete from fnd_compiled_menu_functions
2264: where menu_id = p_menu_id
2265: and grant_flag <> C_INVALID_GRANT_VAL;
2266: exception when no_data_found then
2267: null;

Line 2328: insert into fnd_compiled_menu_functions

2324: ||' func_id:'||to_char(tbl_func_id(q) )
2325: ||' gnt_flag:'||tbl_gnt_flg(q) );
2326: end if;
2327: l_rows_processed := l_rows_processed + 1;
2328: insert into fnd_compiled_menu_functions
2329: (MENU_ID, FUNCTION_ID, GRANT_FLAG)
2330: values
2331: (p_menu_id, tbl_func_id(q), tbl_gnt_flg(q));
2332: exception

Line 2347: update fnd_compiled_menu_functions

2343: c_log_head || l_api_name || '.upd_gnt_flag',
2344: 'About to update grant_flag.');
2345: end if;
2346: /* If the grant flag isn't right, update it. */
2347: update fnd_compiled_menu_functions
2348: set grant_flag = tbl_gnt_flg(q)
2349: where menu_id = p_menu_id
2350: and function_id = tbl_func_id(q)
2351: and grant_flag = 'N';

Line 2419: insert into fnd_compiled_menu_functions

2415: 'Inserting into compiled table p_menu_id: '|| to_char(p_menu_id)
2416: ||' tbl_copy_func_id(z):'||tbl_copy_func_id(z)
2417: ||' tbl_copy_gnt_flg(ze):'||tbl_copy_gnt_flg(z) );
2418: end if;
2419: insert into fnd_compiled_menu_functions
2420: (menu_id, function_id, grant_flag)
2421: values
2422: (p_menu_id, tbl_copy_func_id(z), tbl_copy_gnt_flg(z));
2423: exception

Line 2442: update fnd_compiled_menu_functions

2438: c_log_head || l_api_name || '.upd_gnt_flag2',
2439: 'About to update grant_flag.');
2440: end if;
2441: /* If the grant flag isn't right, update it. */
2442: update fnd_compiled_menu_functions
2443: set grant_flag = tbl_copy_gnt_flg(z)
2444: where menu_id = p_menu_id
2445: and function_id = tbl_copy_func_id(z)
2446: and grant_flag = 'N';

Line 2463: insert into fnd_compiled_menu_functions

2459: c_log_head || l_api_name || '.insert_blank',
2460: 'Inserting blank row into compiled table p_menu_id: '||
2461: to_char(p_menu_id) );
2462: end if;
2463: insert into fnd_compiled_menu_functions
2464: (menu_id, function_id, grant_flag)
2465: values
2466: (p_menu_id, C_BLANK_MENU_VAL, C_BLANK_GRANT_VAL);
2467: exception

Line 2485: delete from fnd_compiled_menu_functions

2481: c_log_head || l_api_name || '.del_mark',
2482: 'Removing uncompiled mark from p_menu_id:'||p_menu_id);
2483: end if;
2484: begin
2485: delete from fnd_compiled_menu_functions
2486: where menu_id = p_menu_id
2487: and grant_flag = C_INVALID_GRANT_VAL;
2488: exception when no_data_found then
2489: null; /* We should never get here, but dont bomb if we do */

Line 2517: -- Delete all rows from fnd_compiled_menu_functions for this menu_id

2513: --
2514: -- COMPILE_MENU_MARKED
2515: -- if (not force mode) and (this menu is not marked)
2516: -- return; we're done
2517: -- Delete all rows from fnd_compiled_menu_functions for this menu_id
2518: -- for each menu_entry on this menu
2519: -- if this is a function
2520: -- add it to the compiled table
2521: -- if this is a menu

Line 2580: delete from fnd_compiled_menu_functions

2576: while (more_to_delete) loop
2577: begin
2578: more_to_delete := FALSE;
2579: -- Delete menus one menu at a time.
2580: delete from fnd_compiled_menu_functions
2581: where menu_id = (select menu_id
2582: from fnd_compiled_menu_functions
2583: where rownum = 1);
2584: -- Commit to keep the rollback small

Line 2582: from fnd_compiled_menu_functions

2578: more_to_delete := FALSE;
2579: -- Delete menus one menu at a time.
2580: delete from fnd_compiled_menu_functions
2581: where menu_id = (select menu_id
2582: from fnd_compiled_menu_functions
2583: where rownum = 1);
2584: -- Commit to keep the rollback small
2585: commit;
2586: if (sql%rowcount > 0) then

Line 2638: insert into fnd_compiled_menu_functions

2634:
2635: /* mark that menu as uncompiled */
2636: for q in 1..last_index loop
2637: begin
2638: insert into fnd_compiled_menu_functions
2639: (menu_id, function_id, grant_flag)
2640: values
2641: (tbl_menu_id(q), C_INVALID_MENU_VAL, C_INVALID_GRANT_VAL);
2642: -- We commit the menu mark in order to keep the rollback segment