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_OBJECT_INSTANCE_SETS

Line 1060: ' fnd_object_instance_sets sets '||

1056: --
1057: l_dynamic_sql_1 :=
1058: ' SELECT DISTINCT sets.instance_SET_ID, sets.predicate ' ||
1059: ' FROM fnd_grants grants, ' ||
1060: ' fnd_object_instance_sets sets '||
1061: ' WHERE grants.object_id = :object_id ' ||
1062: ' AND grants.start_date <= SYSDATE ' ||
1063: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||
1064: ' AND grants.instance_type = :instance_type ' ||

Line 1561: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||

1557: l_set_predicates := '(';
1558: l_set_predicate_segment := '';
1559: l_dynamic_sql_1 :=
1560: ' SELECT DISTINCT instance_sets.predicate ' ||
1561: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||
1562: ' WHERE grants.instance_type = :instance_type '||
1563: ' AND grants.start_date <= SYSDATE ' ||
1564: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1565: ' AND grants.instance_set_id = instance_sets.instance_set_id ' ||

Line 2054: ' fnd_object_instance_sets sets '||

2050:
2051: l_dynamic_sql_1 :=
2052: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
2053: ' FROM fnd_grants grants, ' ||
2054: ' fnd_object_instance_sets sets '||
2055: ' WHERE grants.instance_type = :instance_type '||
2056: ' AND grants.start_date <= SYSDATE ' ||
2057: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
2058: ' AND grants.instance_set_id = sets.instance_set_id ' ||

Line 2741: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||

2737: -- Now we build dynamic SQL using the work we just did to optimize the query --
2738: -------------------------------------------------------------------------------
2739: l_dynamic_sql_1 :=
2740: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
2741: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||
2742: ' WHERE grants.object_id = :object_id ' ||
2743: ' AND grants.start_date <= SYSDATE ' ||
2744: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||
2745: ' AND grants.instance_type = :instance_type ' ||

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

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 ' ||
3677: ' AND cmf.function_id = functions.function_id ' ||

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

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 ' ||
4235: ' AND cmf.function_id = functions.function_id ' ||

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

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 ' ||
4725: ' AND cmf.function_id = functions.function_id ' ||

Line 5015: fnd_object_instance_sets instance_sets

5011: )
5012: IS
5013: SELECT DISTINCT instance_sets.predicate
5014: FROM fnd_grants grants,
5015: fnd_object_instance_sets instance_sets
5016: WHERE grants.instance_type = 'SET'
5017: AND grants.start_date <= SYSDATE
5018: AND ( grants.end_date IS NULL
5019: OR grants.end_date >= SYSDATE )

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

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 ' ||
5430: ' AND cmf.function_id = functions.function_id ' ||

Line 5487: ' fnd_object_instance_sets instance_sets,' ||

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

Line 6087: from fnd_objects o, fnd_object_instance_sets s

6083: l_pk2_col_type,
6084: l_pk3_col_type,
6085: l_pk4_col_type,
6086: l_pk5_col_type
6087: from fnd_objects o, fnd_object_instance_sets s
6088: where s.instance_set_name = p_instance_set_name
6089: and s.object_id = o.object_id;
6090: exception
6091: when no_data_found then

Line 6096: 'fnd_objects and fnd_object_instance_sets for instance set '||

6092: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6093: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6094: fnd_message.set_token('REASON',
6095: 'Data Error- couldn''t get predicate and/or object_name from '||
6096: 'fnd_objects and fnd_object_instance_sets for instance set '||
6097: '"'||p_instance_set_name||'"');
6098: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
6099: ,p_module => l_api_name
6100: ,p_message => 'The given data is not sufficient to find a valid instance set '

Line 7279: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||

7275: -- Now we build dynamic SQL using the work we just did to optimize the query --
7276: -------------------------------------------------------------------------------
7277: l_dynamic_sql_1 :=
7278: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
7279: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||
7280: ' WHERE grants.object_id = :object_id ' ||
7281: ' AND grants.start_date <= SYSDATE ' ||
7282: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
7283: ' AND grants.instance_type = :instance_type ' ||

Line 7992: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||

7988: l_set_predicate_segment := '';
7989:
7990: l_dynamic_sql_1 :=
7991: ' SELECT DISTINCT instance_sets.predicate ' ||
7992: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||
7993: ' WHERE grants.instance_type = :instance_type '||
7994: ' AND grants.start_date <= SYSDATE ' ||
7995: ' AND (grants.end_date IS NULL OR grants.end_date >= SYSDATE) ' ||
7996: ' AND grants.instance_set_id = instance_sets.instance_set_id ' ||