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_FORM_FUNCTIONS

Line 739: FROM fnd_form_functions

735: SELECT menu_id
736: FROM fnd_menu_entries
737: WHERE function_id =
738: (SELECT function_id
739: FROM fnd_form_functions
740: WHERE function_name = cp_function_name
741: );
742:
743: BEGIN

Line 1242: FROM fnd_menu_entries r, fnd_form_functions f,

1238: CURSOR menu_id_c (cp_function VARCHAR2, cp_object_id NUMBER,
1239: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
1240: IS
1241: SELECT p.parent_role_id parent_role_id
1242: FROM fnd_menu_entries r, fnd_form_functions f,
1243: fnd_menus m, ego_obj_role_mappings p
1244: WHERE r.function_id = f.function_id
1245: AND r.menu_id = m.menu_id
1246: AND f.function_name = cp_function

Line 2279: ' fnd_form_functions fnd_functions, ' ||

2275: -- R12C Security Changes Bug 6507794
2276: /* l_common_dyn_sql:=
2277: 'SELECT DISTINCT fnd_functions.function_name ' ||
2278: ' FROM fnd_grants grants, ' ||
2279: ' fnd_form_functions fnd_functions, ' ||
2280: ' fnd_menu_entries cmf '||
2281: ' WHERE grants.object_id = :object_id ' ||
2282: ' AND grants.start_date <= SYSDATE ' ||
2283: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 2299: ' fnd_form_functions fnd_functions, ' ||

2295: IF (p_object_name = 'EGO_CATALOG_GROUP') THEN
2296: l_common_dyn_sql:=
2297: 'SELECT DISTINCT fnd_functions.function_name ' ||
2298: ' FROM fnd_grants grants, ' ||
2299: ' fnd_form_functions fnd_functions, ' ||
2300: ' fnd_menu_entries cmf, '||
2301: ' ego_item_cat_denorm_hier cathier '||
2302: ' WHERE grants.object_id = :object_id ' ||
2303: ' AND grants.start_date <= SYSDATE ' ||

Line 2319: ' fnd_form_functions fnd_functions, ' ||

2315: ELSE
2316: l_common_dyn_sql:=
2317: 'SELECT DISTINCT fnd_functions.function_name ' ||
2318: ' FROM fnd_grants grants, ' ||
2319: ' fnd_form_functions fnd_functions, ' ||
2320: ' fnd_menu_entries cmf '||
2321: ' WHERE grants.object_id = :object_id ' ||
2322: ' AND grants.start_date <= SYSDATE ' ||
2323: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 2889: ' fnd_form_functions fnd_functions, ' ||

2885:
2886: l_common_dyn_sql:=
2887: 'SELECT DISTINCT fnd_functions.function_name ' ||
2888: ' FROM fnd_grants grants, ' ||
2889: ' fnd_form_functions fnd_functions, ' ||
2890: ' fnd_menu_entries cmf, '||
2891: ' ego_obj_role_mappings mapping '||
2892: ' WHERE grants.object_id = :object_id '||
2893: ' AND grants.start_date <= SYSDATE '||

Line 3028: ' FROM fnd_form_functions fnd_functions, ' ||

3024: IF (l_profile_role is not null) THEN
3025: l_dynamic_sql:= l_dynamic_sql ||
3026: ' UNION ' ||
3027: ' SELECT DISTINCT fnd_functions.function_name ' ||
3028: ' FROM fnd_form_functions fnd_functions, ' ||
3029: ' fnd_menu_entries cmf, ' ||
3030: ' ego_obj_role_mappings mapping, ' ||
3031: ' fnd_menus menus ' ||
3032: ' WHERE menus.menu_name = :profile_role ' ||

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

3585:
3586: if (p_statement_type = 'EXISTS') then
3587: --R12C Security Changes
3588: /* l_aggregate_predicate := l_aggregate_predicate ||
3589: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3590: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'; */
3591: if (p_object_name = 'EGO_CATALOG_GROUP') THEN
3592: l_aggregate_predicate := l_aggregate_predicate ||
3593: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, ego_item_cat_denorm_hier cathier ' ||

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

3589: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3590: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'; */
3591: if (p_object_name = 'EGO_CATALOG_GROUP') THEN
3592: l_aggregate_predicate := l_aggregate_predicate ||
3593: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, ego_item_cat_denorm_hier cathier ' ||
3594: ' WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id) AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')';
3595: else
3596: l_aggregate_predicate := l_aggregate_predicate ||
3597: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||

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

3593: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, ego_item_cat_denorm_hier cathier ' ||
3594: ' WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id) AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')';
3595: else
3596: l_aggregate_predicate := l_aggregate_predicate ||
3597: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3598: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')';
3599: end if;
3600: --R12C Security Changes
3601: code_debug (p_log_level => G_DEBUG_LEVEL_STATEMENT

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

3627: ,p_message => 'l_aggregate_predicate : '||l_aggregate_predicate
3628: );
3629: else
3630: l_aggregate_predicate := l_aggregate_predicate ||
3631: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
3632: ' WHERE grants.start_date <= sysdate ';
3633: code_debug (p_log_level => G_DEBUG_LEVEL_STATEMENT
3634: ,p_module => l_api_name
3635: ,p_message => 'l_aggregate_predicate : '||l_aggregate_predicate

Line 3672: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||

3668: -- Now we build dynamic SQL using the work we just did to optimize the query --
3669: -------------------------------------------------------------------------------
3670: l_dynamic_sql_1 :=
3671: ' SELECT DISTINCT instance_sets.predicate ' ||
3672: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
3673: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
3674: ' WHERE grants.instance_type = :instance_type ' ||
3675: ' AND grants.start_date <= SYSDATE ' ||
3676: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 4134: ' fnd_form_functions functions, ' ||

4130: /*l_aggregate_predicate :=
4131: l_aggregate_predicate ||
4132: ' SELECT INSTANCE_PK1_VALUE' ||
4133: ' FROM fnd_grants grants, ' ||
4134: ' fnd_form_functions functions, ' ||
4135: ' fnd_menu_entries cmf ' ||
4136: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'||
4137: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4138: ' AND grants.instance_type= ''INSTANCE'' ' ||

Line 4157: ' fnd_form_functions functions, ' ||

4153: l_aggregate_predicate :=
4154: l_aggregate_predicate ||
4155: ' SELECT INSTANCE_PK1_VALUE' ||
4156: ' FROM fnd_grants grants, ' ||
4157: ' fnd_form_functions functions, ' ||
4158: ' fnd_menu_entries cmf, ' ||
4159: ' ego_item_cat_denorm_hier cathier ' ||
4160: ' WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id)' ||
4161: ' AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')' ||

Line 4182: ' fnd_form_functions functions, ' ||

4178: l_aggregate_predicate :=
4179: l_aggregate_predicate ||
4180: ' SELECT INSTANCE_PK1_VALUE' ||
4181: ' FROM fnd_grants grants, ' ||
4182: ' fnd_form_functions functions, ' ||
4183: ' fnd_menu_entries cmf ' ||
4184: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('||p_pk1_alias||')'||
4185: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4186: ' AND grants.instance_type= ''INSTANCE'' ' ||

Line 4230: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||

4226:
4227: IF(l_instance_set_flag = TRUE) THEN
4228: l_dynamic_sql_1 :=
4229: ' SELECT DISTINCT instance_sets.predicate ' ||
4230: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
4231: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
4232: ' WHERE grants.instance_type = :instance_type ' ||
4233: ' AND grants.start_date <= SYSDATE ' ||
4234: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 4625: ' fnd_form_functions functions, ' ||

4621: /* l_aggregate_predicate :=
4622: l_aggregate_predicate ||
4623: ' SELECT INSTANCE_PK1_VALUE' ||
4624: ' FROM fnd_grants grants, ' ||
4625: ' fnd_form_functions functions, ' ||
4626: ' fnd_menu_entries cmf ' ||
4627: ' WHERE grants.start_date <= sysdate ' ||
4628: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4629: ' AND grants.instance_type= ''INSTANCE'' ' ||

Line 4647: ' fnd_form_functions functions, ' ||

4643: if (p_object_name = 'EGO_CATALOG_GROUP') THEN
4644: l_aggregate_predicate := l_aggregate_predicate ||
4645: ' SELECT INSTANCE_PK1_VALUE' ||
4646: ' FROM fnd_grants grants, ' ||
4647: ' fnd_form_functions functions, ' ||
4648: ' fnd_menu_entries cmf, ' ||
4649: 'ego_item_cat_denorm_hier cathier ' ||
4650: 'WHERE grants.INSTANCE_PK1_VALUE=to_char(cathier.parent_catalog_group_id) '||
4651: 'AND cathier.child_catalog_group_id = to_char('||p_pk1_alias||')' ||

Line 4672: ' fnd_form_functions functions, ' ||

4668: else
4669: l_aggregate_predicate := l_aggregate_predicate ||
4670: ' SELECT INSTANCE_PK1_VALUE' ||
4671: ' FROM fnd_grants grants, ' ||
4672: ' fnd_form_functions functions, ' ||
4673: ' fnd_menu_entries cmf ' ||
4674: ' WHERE grants.start_date <= sysdate ' ||
4675: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4676: ' AND grants.instance_type= ''INSTANCE'' ' ||

Line 4720: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||

4716:
4717: IF(l_instance_set_flag = TRUE) THEN
4718: l_dynamic_sql :=
4719: ' SELECT DISTINCT instance_sets.predicate ' ||
4720: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
4721: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
4722: ' WHERE grants.instance_type = :instance_type ' ||
4723: ' AND grants.start_date <= SYSDATE ' ||
4724: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 5024: FROM fnd_menu_entries r, fnd_form_functions f,

5020: AND grants.instance_set_id = instance_sets.instance_set_id
5021: AND grants.object_id = cp_parent_object_id
5022: AND ( grants.menu_id in
5023: ( SELECT p.parent_role_id
5024: FROM fnd_menu_entries r, fnd_form_functions f,
5025: fnd_menus m, ego_obj_role_mappings p
5026: WHERE r.function_id = f.function_id
5027: AND r.menu_id = m.menu_id
5028: AND f.function_name = cp_function

Line 5051: FROM fnd_menu_entries r, fnd_form_functions f,

5047: cp_object_type VARCHAR2
5048: )
5049: IS
5050: SELECT DISTINCT p.parent_role_id
5051: FROM fnd_menu_entries r, fnd_form_functions f,
5052: fnd_menus m, ego_obj_role_mappings p
5053: WHERE r.function_id = f.function_id
5054: AND r.menu_id = m.menu_id
5055: AND f.function_name = cp_function

Line 5068: FROM fnd_menu_entries r, fnd_form_functions f,

5064: cp_parent_object_id VARCHAR2
5065: )
5066: IS
5067: SELECT DISTINCT p.parent_role_id
5068: FROM fnd_menu_entries r, fnd_form_functions f,
5069: fnd_menus m, ego_obj_role_mappings p
5070: WHERE r.function_id = f.function_id
5071: AND r.menu_id = m.menu_id
5072: AND f.function_name = cp_function

Line 5371: ' fnd_form_functions functions, ' ||

5367: l_aggregate_predicate :=
5368: l_aggregate_predicate ||
5369: ' SELECT '||l_type_converted_val_cols ||
5370: ' FROM fnd_grants grants, ' ||
5371: ' fnd_form_functions functions, ' ||
5372: ' fnd_menu_entries cmf ';
5373:
5374: if (p_statement_type = 'EXISTS') then
5375: -- R12C Security Changes

Line 5425: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||

5421:
5422: IF(l_instance_set_flag = TRUE) THEN
5423: l_dynamic_sql_1 :=
5424: ' SELECT DISTINCT instance_sets.predicate ' ||
5425: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
5426: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
5427: ' WHERE grants.instance_type = :instance_type ' ||
5428: ' AND grants.start_date <= SYSDATE ' ||
5429: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

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

5484: l_dynamic_sql_2 :=
5485: ' SELECT DISTINCT instance_sets.predicate '||
5486: ' FROM fnd_grants grants, '||
5487: ' fnd_object_instance_sets instance_sets,' ||
5488: ' fnd_form_functions F, fnd_menu_entries R, '||
5489: ' fnd_menus M, ego_obj_role_mappings P '||
5490: ' WHERE grants.instance_type = ''SET'' '||
5491: ' AND grants.start_date <= SYSDATE ' ||
5492: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||

Line 6977: FROM fnd_form_functions functions,

6973:
6974: CURSOR role_function_c (cp_role_name VARCHAR2)
6975: IS
6976: SELECT functions.function_name
6977: FROM fnd_form_functions functions,
6978: fnd_menu_entries cmf,
6979: fnd_menus menus
6980: WHERE functions.function_id = cmf.function_id
6981: AND menus.menu_id = cmf.menu_id

Line 7338: ' fnd_form_functions fnd_functions, ' ||

7334:
7335: l_common_dyn_sql:=
7336: 'SELECT DISTINCT fnd_functions.function_name ' ||
7337: ' FROM fnd_grants grants, ' ||
7338: ' fnd_form_functions fnd_functions, ' ||
7339: ' fnd_menu_entries cmf, '||
7340: ' ego_obj_role_mappings mapping '||
7341: ' WHERE grants.object_id = :object_id '||
7342: ' AND grants.start_date <= SYSDATE '||

Line 7426: ' FROM fnd_form_functions fnd_functions, ' ||

7422:
7423: IF (l_profile_role is not null) THEN
7424: l_dynamic_sql:= l_dynamic_sql ||' UNION ' ||
7425: ' SELECT DISTINCT fnd_functions.function_name ' ||
7426: ' FROM fnd_form_functions fnd_functions, ' ||
7427: ' fnd_menu_entries cmf, ' ||
7428: ' ego_obj_role_mappings mapping, ' ||
7429: ' fnd_menus menus ' ||
7430: ' WHERE menus.menu_name = :profile_role ' ||

Line 7728: from fnd_menu_entries r, fnd_form_functions f,

7724: CURSOR menu_id_c (cp_function VARCHAR2, cp_object_id NUMBER,
7725: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
7726: IS
7727: select p.parent_role_id parent_role_id
7728: from fnd_menu_entries r, fnd_form_functions f,
7729: fnd_menus m, ego_obj_role_mappings p
7730: where r.function_id = f.function_id
7731: and r.menu_id = m.menu_id
7732: and f.function_name = cp_function