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.EGO_DATA_SECURITY dependencies on FND_MENU_ENTRIES

Line 757: FROM fnd_menu_entries

753: l_set_id_cnt NUMBER;
754:
755: CURSOR menu_functions_c (cp_function_name IN VARCHAR2) IS
756: SELECT menu_id
757: FROM fnd_menu_entries
758: WHERE function_id =
759: (SELECT function_id
760: FROM fnd_form_functions
761: WHERE function_name = cp_function_name

Line 1342: FROM fnd_menu_entries r, fnd_form_functions f,

1338: CURSOR menu_id_c (cp_function VARCHAR2, cp_object_id NUMBER,
1339: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
1340: IS
1341: SELECT p.parent_role_id parent_role_id
1342: FROM fnd_menu_entries r, fnd_form_functions f,
1343: fnd_menus m, ego_obj_role_mappings p
1344: WHERE r.function_id = f.function_id
1345: AND r.menu_id = m.menu_id
1346: AND f.function_name = cp_function

Line 2382: ' fnd_menu_entries cmf '||

2378: /* l_common_dyn_sql:=
2379: 'SELECT DISTINCT fnd_functions.function_name ' ||
2380: ' FROM fnd_grants grants, ' ||
2381: ' fnd_form_functions fnd_functions, ' ||
2382: ' fnd_menu_entries cmf '||
2383: ' WHERE grants.object_id = :object_id ' ||
2384: ' AND grants.start_date <= SYSDATE ' ||
2385: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
2386: ' AND ( ( grants.grantee_type = ''USER'' AND ' ||

Line 2402: ' fnd_menu_entries cmf, '||

2398: l_common_dyn_sql:=
2399: 'SELECT DISTINCT fnd_functions.function_name ' ||
2400: ' FROM fnd_grants grants, ' ||
2401: ' fnd_form_functions fnd_functions, ' ||
2402: ' fnd_menu_entries cmf, '||
2403: ' ego_item_cat_denorm_hier cathier '||
2404: ' WHERE grants.object_id = :object_id ' ||
2405: ' AND grants.start_date <= SYSDATE ' ||
2406: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 2422: ' fnd_menu_entries cmf '||

2418: l_common_dyn_sql:=
2419: 'SELECT DISTINCT fnd_functions.function_name ' ||
2420: ' FROM fnd_grants grants, ' ||
2421: ' fnd_form_functions fnd_functions, ' ||
2422: ' fnd_menu_entries cmf '||
2423: ' WHERE grants.object_id = :object_id ' ||
2424: ' AND grants.start_date <= SYSDATE ' ||
2425: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
2426: ' AND ( ( grants.grantee_type = ''USER'' AND ' ||

Line 2992: ' fnd_menu_entries cmf, '||

2988: l_common_dyn_sql:=
2989: 'SELECT DISTINCT fnd_functions.function_name ' ||
2990: ' FROM fnd_grants grants, ' ||
2991: ' fnd_form_functions fnd_functions, ' ||
2992: ' fnd_menu_entries cmf, '||
2993: ' ego_obj_role_mappings mapping '||
2994: ' WHERE grants.object_id = :object_id '||
2995: ' AND grants.start_date <= SYSDATE '||
2996: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 3131: ' fnd_menu_entries cmf, ' ||

3127: l_dynamic_sql:= l_dynamic_sql ||
3128: ' UNION ' ||
3129: ' SELECT DISTINCT fnd_functions.function_name ' ||
3130: ' FROM fnd_form_functions fnd_functions, ' ||
3131: ' fnd_menu_entries cmf, ' ||
3132: ' ego_obj_role_mappings mapping, ' ||
3133: ' fnd_menus menus ' ||
3134: ' WHERE menus.menu_name = :profile_role ' ||
3135: ' AND mapping.parent_role_id = menus.menu_id ' ||

Line 3691: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||

3687:
3688: if (p_statement_type = 'EXISTS') then
3689: --R12C Security Changes
3690: /* l_aggregate_predicate := l_aggregate_predicate ||
3691: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3692: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'; */
3693: if (p_object_name = 'EGO_CATALOG_GROUP') THEN
3694: l_aggregate_predicate := l_aggregate_predicate ||
3695: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, ego_item_cat_denorm_hier cathier ' ||

Line 3695: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, ego_item_cat_denorm_hier cathier ' ||

3691: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3692: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'; */
3693: if (p_object_name = 'EGO_CATALOG_GROUP') THEN
3694: l_aggregate_predicate := l_aggregate_predicate ||
3695: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, ego_item_cat_denorm_hier cathier ' ||
3696: ' WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id) AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')';
3697: else
3698: l_aggregate_predicate := l_aggregate_predicate ||
3699: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||

Line 3699: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||

3695: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, ego_item_cat_denorm_hier cathier ' ||
3696: ' WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id) AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')';
3697: else
3698: l_aggregate_predicate := l_aggregate_predicate ||
3699: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3700: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')';
3701: end if;
3702: --R12C Security Changes
3703: code_debug (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 3733: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||

3729: ,p_message => 'l_aggregate_predicate : '||l_aggregate_predicate
3730: );
3731: else
3732: l_aggregate_predicate := l_aggregate_predicate ||
3733: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3734: ' WHERE grants.start_date <= sysdate ';
3735: code_debug (p_log_level => G_DEBUG_LEVEL_STATEMENT
3736: ,p_module => l_api_name
3737: ,p_message => 'l_aggregate_predicate : '||l_aggregate_predicate

Line 3775: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

3771: -------------------------------------------------------------------------------
3772: l_dynamic_sql_1 :=
3773: ' SELECT DISTINCT instance_sets.predicate ' ||
3774: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
3775: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
3776: ' WHERE grants.instance_type = :instance_type ' ||
3777: ' AND grants.start_date <= SYSDATE ' ||
3778: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
3779: ' AND cmf.function_id = functions.function_id ' ||

Line 4237: ' fnd_menu_entries cmf ' ||

4233: l_aggregate_predicate ||
4234: ' SELECT INSTANCE_PK1_VALUE' ||
4235: ' FROM fnd_grants grants, ' ||
4236: ' fnd_form_functions functions, ' ||
4237: ' fnd_menu_entries cmf ' ||
4238: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'||
4239: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4240: ' AND grants.instance_type= ''INSTANCE'' ' ||
4241: ' AND cmf.function_id = functions.function_id ' ||

Line 4260: ' fnd_menu_entries cmf, ' ||

4256: l_aggregate_predicate ||
4257: ' SELECT INSTANCE_PK1_VALUE' ||
4258: ' FROM fnd_grants grants, ' ||
4259: ' fnd_form_functions functions, ' ||
4260: ' fnd_menu_entries cmf, ' ||
4261: ' ego_item_cat_denorm_hier cathier ' ||
4262: ' WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id)' ||
4263: ' AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')' ||
4264: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 4285: ' fnd_menu_entries cmf ' ||

4281: l_aggregate_predicate ||
4282: ' SELECT INSTANCE_PK1_VALUE' ||
4283: ' FROM fnd_grants grants, ' ||
4284: ' fnd_form_functions functions, ' ||
4285: ' fnd_menu_entries cmf ' ||
4286: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'||
4287: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4288: ' AND grants.instance_type= ''INSTANCE'' ' ||
4289: ' AND cmf.function_id = functions.function_id ' ||

Line 4333: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

4329: IF(l_instance_set_flag = TRUE) THEN
4330: l_dynamic_sql_1 :=
4331: ' SELECT DISTINCT instance_sets.predicate ' ||
4332: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
4333: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
4334: ' WHERE grants.instance_type = :instance_type ' ||
4335: ' AND grants.start_date <= SYSDATE ' ||
4336: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4337: ' AND cmf.function_id = functions.function_id ' ||

Line 4728: ' fnd_menu_entries cmf ' ||

4724: l_aggregate_predicate ||
4725: ' SELECT INSTANCE_PK1_VALUE' ||
4726: ' FROM fnd_grants grants, ' ||
4727: ' fnd_form_functions functions, ' ||
4728: ' fnd_menu_entries cmf ' ||
4729: ' WHERE grants.start_date <= sysdate ' ||
4730: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4731: ' AND grants.instance_type= ''INSTANCE'' ' ||
4732: ' AND cmf.function_id = functions.function_id ' ||

Line 4750: ' fnd_menu_entries cmf, ' ||

4746: l_aggregate_predicate := l_aggregate_predicate ||
4747: ' SELECT INSTANCE_PK1_VALUE' ||
4748: ' FROM fnd_grants grants, ' ||
4749: ' fnd_form_functions functions, ' ||
4750: ' fnd_menu_entries cmf, ' ||
4751: 'ego_item_cat_denorm_hier cathier ' ||
4752: 'WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id) '||
4753: 'AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')' ||
4754: ' AND grants.start_date <= sysdate ' ||

Line 4775: ' fnd_menu_entries cmf ' ||

4771: l_aggregate_predicate := l_aggregate_predicate ||
4772: ' SELECT INSTANCE_PK1_VALUE' ||
4773: ' FROM fnd_grants grants, ' ||
4774: ' fnd_form_functions functions, ' ||
4775: ' fnd_menu_entries cmf ' ||
4776: ' WHERE grants.start_date <= sysdate ' ||
4777: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4778: ' AND grants.instance_type= ''INSTANCE'' ' ||
4779: ' AND cmf.function_id = functions.function_id ' ||

Line 4823: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

4819: IF(l_instance_set_flag = TRUE) THEN
4820: l_dynamic_sql :=
4821: ' SELECT DISTINCT instance_sets.predicate ' ||
4822: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
4823: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
4824: ' WHERE grants.instance_type = :instance_type ' ||
4825: ' AND grants.start_date <= SYSDATE ' ||
4826: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4827: ' AND cmf.function_id = functions.function_id ' ||

Line 5126: FROM fnd_menu_entries r, fnd_form_functions f,

5122: AND grants.instance_set_id = instance_sets.instance_set_id
5123: AND grants.object_id = cp_parent_object_id
5124: AND ( grants.menu_id in
5125: ( SELECT p.parent_role_id
5126: FROM fnd_menu_entries r, fnd_form_functions f,
5127: fnd_menus m, ego_obj_role_mappings p
5128: WHERE r.function_id = f.function_id
5129: AND r.menu_id = m.menu_id
5130: AND f.function_name = cp_function

Line 5153: FROM fnd_menu_entries r, fnd_form_functions f,

5149: cp_object_type VARCHAR2
5150: )
5151: IS
5152: SELECT DISTINCT p.parent_role_id
5153: FROM fnd_menu_entries r, fnd_form_functions f,
5154: fnd_menus m, ego_obj_role_mappings p
5155: WHERE r.function_id = f.function_id
5156: AND r.menu_id = m.menu_id
5157: AND f.function_name = cp_function

Line 5170: FROM fnd_menu_entries r, fnd_form_functions f,

5166: cp_parent_object_id VARCHAR2
5167: )
5168: IS
5169: SELECT DISTINCT p.parent_role_id
5170: FROM fnd_menu_entries r, fnd_form_functions f,
5171: fnd_menus m, ego_obj_role_mappings p
5172: WHERE r.function_id = f.function_id
5173: AND r.menu_id = m.menu_id
5174: AND f.function_name = cp_function

Line 5474: ' fnd_menu_entries cmf ';

5470: l_aggregate_predicate ||
5471: ' SELECT '||l_type_converted_val_cols ||
5472: ' FROM fnd_grants grants, ' ||
5473: ' fnd_form_functions functions, ' ||
5474: ' fnd_menu_entries cmf ';
5475:
5476: if (p_statement_type = 'EXISTS') then
5477: -- R12C Security Changes
5478: /* l_aggregate_predicate := l_aggregate_predicate ||

Line 5528: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

5524: IF(l_instance_set_flag = TRUE) THEN
5525: l_dynamic_sql_1 :=
5526: ' SELECT DISTINCT instance_sets.predicate ' ||
5527: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
5528: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
5529: ' WHERE grants.instance_type = :instance_type ' ||
5530: ' AND grants.start_date <= SYSDATE ' ||
5531: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
5532: ' AND cmf.function_id = functions.function_id ' ||

Line 5590: ' fnd_form_functions F, fnd_menu_entries R, '||

5586: l_dynamic_sql_2 :=
5587: ' SELECT DISTINCT instance_sets.predicate '||
5588: ' FROM fnd_grants grants, '||
5589: ' fnd_object_instance_sets instance_sets,' ||
5590: ' fnd_form_functions F, fnd_menu_entries R, '||
5591: ' fnd_menus M, ego_obj_role_mappings P '||
5592: ' WHERE grants.instance_type = ''SET'' '||
5593: ' AND grants.start_date <= SYSDATE ' ||
5594: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||

Line 7080: fnd_menu_entries cmf,

7076: CURSOR role_function_c (cp_role_name VARCHAR2)
7077: IS
7078: SELECT functions.function_name
7079: FROM fnd_form_functions functions,
7080: fnd_menu_entries cmf,
7081: fnd_menus menus
7082: WHERE functions.function_id = cmf.function_id
7083: AND menus.menu_id = cmf.menu_id
7084: AND menus.menu_name = cp_role_name;

Line 7441: ' fnd_menu_entries cmf, '||

7437: l_common_dyn_sql:=
7438: 'SELECT DISTINCT fnd_functions.function_name ' ||
7439: ' FROM fnd_grants grants, ' ||
7440: ' fnd_form_functions fnd_functions, ' ||
7441: ' fnd_menu_entries cmf, '||
7442: ' ego_obj_role_mappings mapping '||
7443: ' WHERE grants.object_id = :object_id '||
7444: ' AND grants.start_date <= SYSDATE '||
7445: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 7529: ' fnd_menu_entries cmf, ' ||

7525: IF (l_profile_role is not null) THEN
7526: l_dynamic_sql:= l_dynamic_sql ||' UNION ' ||
7527: ' SELECT DISTINCT fnd_functions.function_name ' ||
7528: ' FROM fnd_form_functions fnd_functions, ' ||
7529: ' fnd_menu_entries cmf, ' ||
7530: ' ego_obj_role_mappings mapping, ' ||
7531: ' fnd_menus menus ' ||
7532: ' WHERE menus.menu_name = :profile_role ' ||
7533: ' AND mapping.parent_role_id = menus.menu_id ' ||

Line 7830: from fnd_menu_entries r, fnd_form_functions f,

7826: CURSOR menu_id_c (cp_function VARCHAR2, cp_object_id NUMBER,
7827: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
7828: IS
7829: select p.parent_role_id parent_role_id
7830: from fnd_menu_entries r, fnd_form_functions f,
7831: fnd_menus m, ego_obj_role_mappings p
7832: where r.function_id = f.function_id
7833: and r.menu_id = m.menu_id
7834: and f.function_name = cp_function