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

Line 755: from fnd_compiled_menu_functions cmf

751: WHERE rownum = 1
752: AND g.grantee_key = u2.role_name
753: AND g.menu_id in
754: (select cmf.menu_id
755: from fnd_compiled_menu_functions cmf
756: where cmf.function_id = cp_function_id)
757: AND( g.ctx_secgrp_id = -1
758: OR g.ctx_secgrp_id = SYS_CONTEXT('FND','SECURITY_GROUP_ID'))
759: AND( g.ctx_resp_id = -1

Line 808: from fnd_compiled_menu_functions cmf

804: and f.person_party_id = incrns.orig_system_id)))))
805: OR (g.grantee_type = 'GLOBAL'))
806: AND g.menu_id in
807: (select cmf.menu_id
808: from fnd_compiled_menu_functions cmf
809: where cmf.function_id = cp_function_id)
810: AND( g.ctx_secgrp_id = -1
811: OR g.ctx_secgrp_id = SYS_CONTEXT('FND','SECURITY_GROUP_ID'))
812: AND( g.ctx_resp_id = -1

Line 858: from fnd_compiled_menu_functions cmf

854: WHERE rownum = 1
855: AND g.grantee_key = u2.role_name
856: AND g.menu_id in
857: (select cmf.menu_id
858: from fnd_compiled_menu_functions cmf
859: where cmf.function_id = cp_function_id)
860: AND( g.ctx_secgrp_id = -1
861: OR g.ctx_secgrp_id = SYS_CONTEXT('FND','SECURITY_GROUP_ID'))
862: AND( g.ctx_resp_id = -1

Line 923: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */

919: end if;
920: return 'U';
921: END IF;
922:
923: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */
924: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
925: FND_FUNCTION.FAST_COMPILE;
926: end if;
927:

Line 1338: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */

1334: end if;
1335: l_user_name := p_user_name;
1336: end if;
1337:
1338: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */
1339: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
1340: FND_FUNCTION.FAST_COMPILE;
1341: end if;
1342:

Line 1785: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */

1781: x_return_status := 'U';
1782: return;
1783: END IF;
1784:
1785: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */
1786: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
1787: FND_FUNCTION.FAST_COMPILE;
1788: end if;
1789:

Line 2191: from fnd_compiled_menu_functions cmf

2187: AND g.object_id = cp_object_id
2188: AND ( (cp_function_id = -1)
2189: OR (g.menu_id in
2190: (select cmf.menu_id
2191: from fnd_compiled_menu_functions cmf
2192: where cmf.function_id = cp_function_id)))
2193: AND g.instance_set_id = instance_sets.instance_set_id
2194: AND ( g.ctx_secgrp_id = -1
2195: OR g.ctx_secgrp_id =

Line 2241: from fnd_compiled_menu_functions cmf

2237: AND g.object_id = cp_object_id
2238: AND ( (cp_function_id = -1)
2239: OR (g.menu_id in
2240: (select cmf.menu_id
2241: from fnd_compiled_menu_functions cmf
2242: where cmf.function_id = cp_function_id)))
2243: AND g.instance_set_id = instance_sets.instance_set_id
2244: AND ( g.ctx_secgrp_id = -1
2245: OR g.ctx_secgrp_id =

Line 2287: from fnd_compiled_menu_functions cmf

2283: AND g.object_id = cp_object_id
2284: AND ( (cp_function_id = -1)
2285: OR (g.menu_id in
2286: (select cmf.menu_id
2287: from fnd_compiled_menu_functions cmf
2288: where cmf.function_id = cp_function_id)))
2289: AND g.instance_set_id = instance_sets.instance_set_id
2290: AND ( g.ctx_secgrp_id = -1
2291: OR g.ctx_secgrp_id =

Line 2321: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */

2317: end if;
2318:
2319: x_return_status := 'T'; /* Assume Success */
2320:
2321: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */
2322: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
2323: FND_FUNCTION.FAST_COMPILE;
2324: end if;
2325:

Line 2684: 'fnd_compiled_menu_functions CMF, '||

2680: l_aggregate_predicate := l_aggregate_predicate ||
2681: 'SELECT unique FF.FUNCTION_NAME '||
2682: ' FROM fnd_grants GNT, ' ||
2683: l_db_object_name||' OBJTAB, '||
2684: 'fnd_compiled_menu_functions CMF, '||
2685: 'fnd_form_functions FF '||
2686: ' WHERE ';
2687: ELSIF (l_grants_only_flag = TRUE) then
2688: NULL;

Line 2759: ' from fnd_compiled_menu_functions cmf'||

2755: if (l_function_id <> -1) then
2756: l_aggregate_predicate := l_aggregate_predicate ||
2757: ' AND GNT.menu_id in'||
2758: ' (select cmf.menu_id'||
2759: ' from fnd_compiled_menu_functions cmf'||
2760: ' where cmf.function_id = '||l_function_id||')';
2761: end if;
2762: l_aggregate_predicate := l_aggregate_predicate ||
2763: ' AND( GNT.ctx_secgrp_id = -1'||

Line 3205: from fnd_compiled_menu_functions cmf

3201: AND g.object_id = cp_object_id
3202: AND ( (cp_function_id = -1)
3203: OR (g.menu_id in
3204: (select cmf.menu_id
3205: from fnd_compiled_menu_functions cmf
3206: where cmf.function_id = cp_function_id)))
3207: AND ( g.ctx_secgrp_id = -1
3208: OR g.ctx_secgrp_id =
3209: SYS_CONTEXT('FND','SECURITY_GROUP_ID'))

Line 3258: from fnd_compiled_menu_functions cmf

3254: and g.object_id = cp_object_id
3255: and ((cp_function_id = -1)
3256: or (g.menu_id in
3257: (select cmf.menu_id
3258: from fnd_compiled_menu_functions cmf
3259: where cmf.function_id = cp_function_id)))
3260: and ( g.ctx_secgrp_id = -1
3261: or g.ctx_secgrp_id =
3262: SYS_CONTEXT('FND','SECURITY_GROUP_ID'))

Line 3310: from fnd_compiled_menu_functions cmf

3306: and g.object_id = cp_object_id
3307: and ((cp_function_id = -1)
3308: or (g.menu_id in
3309: (select cmf.menu_id
3310: from fnd_compiled_menu_functions cmf
3311: where cmf.function_id = cp_function_id)))
3312: and ( g.ctx_secgrp_id = -1
3313: or g.ctx_secgrp_id =
3314: SYS_CONTEXT('FND','SECURITY_GROUP_ID'))

Line 3369: from fnd_compiled_menu_functions cmf

3365: AND g.instance_type = 'SET'
3366: AND g.object_id = cp_object_id
3367: AND (g.menu_id in
3368: (select cmf.menu_id
3369: from fnd_compiled_menu_functions cmf
3370: where cmf.function_id = cp_function_id))
3371: AND g.instance_set_id = instance_sets.instance_set_id
3372: AND ( g.ctx_secgrp_id = -1
3373: OR g.ctx_secgrp_id =

Line 3506: from fnd_compiled_menu_functions cmf

3502: WHERE g.grantee_key = u2.role_name
3503: AND g.object_id = cp_object_id
3504: AND (g.menu_id in
3505: (select cmf.menu_id
3506: from fnd_compiled_menu_functions cmf
3507: where cmf.function_id = cp_function_id))
3508: AND g.instance_set_id = instance_sets.instance_set_id
3509: AND ( g.ctx_secgrp_id = -1
3510: OR g.ctx_secgrp_id =

Line 3556: from fnd_compiled_menu_functions cmf

3552: and f.person_party_id = incrns.orig_system_id))))))
3553: AND g.object_id = cp_object_id
3554: AND (g.menu_id in
3555: (select cmf.menu_id
3556: from fnd_compiled_menu_functions cmf
3557: where cmf.function_id = cp_function_id))
3558: AND g.instance_set_id = instance_sets.instance_set_id
3559: AND ( g.ctx_secgrp_id = -1
3560: OR g.ctx_secgrp_id =

Line 3675: from fnd_compiled_menu_functions cmf

3671: AND (g.grantee_type = 'GLOBAL')
3672: AND g.object_id = cp_object_id
3673: AND (g.menu_id in
3674: (select cmf.menu_id
3675: from fnd_compiled_menu_functions cmf
3676: where cmf.function_id = cp_function_id))
3677: AND g.instance_set_id = instance_sets.instance_set_id
3678: AND ( g.ctx_secgrp_id = -1
3679: OR g.ctx_secgrp_id =

Line 3948: from fnd_compiled_menu_functions cmf

3944: where g.grantee_key = U2.role_name
3945: AND g.object_id = l_object_id
3946: AND (l_function_id = -1 or
3947: g.menu_id IN (select cmf.menu_id
3948: from fnd_compiled_menu_functions cmf
3949: where cmf.function_id = l_function_id));
3950: -- code added for bug14826159 ends
3951: /* Check one level cache to see if we have this value cached already*/
3952: if ( (g_gsp_function = p_function

Line 4014: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */

4010: return;
4011: end if;
4012:
4013:
4014: /* Make sure that the FND_COMPILED_MENU_FUNCTIONS table is compiled */
4015: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
4016: FND_FUNCTION.FAST_COMPILE;
4017: end if;
4018:

Line 5118: ' from fnd_compiled_menu_functions cmf'||

5114: if (l_function_id <> -1) then
5115: l_instance_predicate := l_instance_predicate ||
5116: ' AND GNT.menu_id in'||
5117: ' (select cmf.menu_id'||
5118: ' from fnd_compiled_menu_functions cmf'||
5119: ' where cmf.function_id = :FUNCTION_ID_BIND )';
5120: x_function_id := l_function_id;
5121: if(x_bind_order is not NULL) then
5122: x_bind_order := x_bind_order || 'F';

Line 5132: ' from fnd_compiled_menu_functions cmf'||

5128: if (l_function_id <> -1) then
5129: l_instance_predicate := l_instance_predicate ||
5130: ' AND GNT.menu_id in'||
5131: ' (select cmf.menu_id'||
5132: ' from fnd_compiled_menu_functions cmf'||
5133: ' where cmf.function_id = '||l_function_id||')';
5134: end if;
5135: end if;
5136: l_instance_predicate := l_instance_predicate ||

Line 6179: ) EXCL, fnd_compiled_menu_functions fcmf1

6175: select frf.rule_type,frf.action_id,frf.responsibility_id
6176: from fnd_resp_functions frf, FU_FURG
6177: where FRF.RESPONSIBILITY_ID = FU_FURG.RESPONSIBILITY_ID
6178: and frf.application_id =fu_furg.responsibility_application_id)
6179: ) EXCL, fnd_compiled_menu_functions fcmf1
6180: where EXCL.MENU_ID=fcmf1.menu_id(+)
6181: ),
6182: NFT AS
6183: (

Line 6193: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG, PROMPT1,NFT

6189: U.function_id,U.responsibility_name,U.responsibility_id, U.application_id, U.security_group_id, U.menu_id,U.prompt
6190: from
6191: (select /*+ use_hash(prompt1) swap_join_inputs(prompt1) */ fcmf.function_id,fr.responsibility_name,
6192: fr.responsibility_id, fr.application_id, fu_furg.security_group_id, prompt1.menu_id, prompt1.prompt
6193: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG, PROMPT1,NFT
6194: where fu_furg.responsibility_id=fr.responsibility_id
6195: and fu_furg.responsibility_application_id=fr.application_id
6196: and fcmf.menu_id=fr.menu_id
6197: and fcmf.grant_flag='Y'

Line 6232: ) GRANTS, fnd_compiled_menu_functions fcmf_in

6228: where g.grantee_key = u2.role_name
6229: AND ( g.end_date IS NULL OR g.end_date >= sysdate )
6230: AND g.start_date <= sysdate
6231: AND ( (g.instance_type = 'GLOBAL') AND (g.object_id = -1))
6232: ) GRANTS, fnd_compiled_menu_functions fcmf_in
6233: where GRANTS.menu_id = fcmf_in.menu_id
6234: ) GRANTS_FN,
6235: (select /*+ no_merge */ distinct
6236: fcmf.function_id,fr.responsibility_name,fr.responsibility_id,fr.application_id, fu_furg.security_group_id, fr.menu_id

Line 6237: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG

6233: where GRANTS.menu_id = fcmf_in.menu_id
6234: ) GRANTS_FN,
6235: (select /*+ no_merge */ distinct
6236: fcmf.function_id,fr.responsibility_name,fr.responsibility_id,fr.application_id, fu_furg.security_group_id, fr.menu_id
6237: from fnd_compiled_menu_functions fcmf, fnd_responsibility_vl fr,FU_FURG
6238: where fu_furg.responsibility_id=fr.responsibility_id
6239: and fu_furg.responsibility_application_id=fr.application_id
6240: and fcmf.menu_id=fr.menu_id
6241: ) FLAT, prompt1, NFT