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

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
762: );
763:
764: --********************************************** 8673870 *********************************

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 2381: ' fnd_form_functions fnd_functions, ' ||

2377: -- R12C Security Changes Bug 6507794
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 ' ||

Line 2401: ' fnd_form_functions fnd_functions, ' ||

2397: IF (p_object_name = 'EGO_CATALOG_GROUP') THEN
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 ' ||

Line 2421: ' fnd_form_functions fnd_functions, ' ||

2417: ELSE
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 ' ||

Line 2991: ' fnd_form_functions fnd_functions, ' ||

2987:
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 '||

Line 3130: ' FROM fnd_form_functions fnd_functions, ' ||

3126: IF (l_profile_role is not null) THEN
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 ' ||

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 3774: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||

3770: -- Now we build dynamic SQL using the work we just did to optimize the query --
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 ' ||

Line 4236: ' fnd_form_functions functions, ' ||

4232: /*l_aggregate_predicate :=
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'' ' ||

Line 4259: ' fnd_form_functions functions, ' ||

4255: l_aggregate_predicate :=
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||')' ||

Line 4284: ' fnd_form_functions functions, ' ||

4280: l_aggregate_predicate :=
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'' ' ||

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

4328:
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 ' ||

Line 4727: ' fnd_form_functions functions, ' ||

4723: /* l_aggregate_predicate :=
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'' ' ||

Line 4749: ' fnd_form_functions functions, ' ||

4745: if (p_object_name = 'EGO_CATALOG_GROUP') THEN
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||')' ||

Line 4774: ' fnd_form_functions functions, ' ||

4770: else
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'' ' ||

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

4818:
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 ' ||

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 5473: ' fnd_form_functions functions, ' ||

5469: l_aggregate_predicate :=
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

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

5523:
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 ' ||

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 7079: FROM fnd_form_functions functions,

7075:
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

Line 7440: ' fnd_form_functions fnd_functions, ' ||

7436:
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 '||

Line 7528: ' FROM fnd_form_functions fnd_functions, ' ||

7524:
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 ' ||

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