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_GRANTS

Line 876: ' FROM fnd_grants grants ' ||

872: --dbms_output.put_line('2. Diff. in Get Time 100th of a sec ::'||to_char(end_date-start_date,'9999999'));
873: -- R12C Security Changes
874: /* l_dynamic_sql :=
875: 'SELECT ''X'' ' ||
876: ' FROM fnd_grants grants ' ||
877: ' WHERE grants.object_id = :object_id ' ||
878: ' AND grants.start_date <= SYSDATE '||
879: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
880: ' AND grants.instance_type = :instance_type ' ||

Line 903: ' FROM fnd_grants grants, ego_item_cat_denorm_hier cathier ' ||

899:
900: IF (p_object_name = 'EGO_CATALOG_GROUP') THEN
901: l_dynamic_sql :=
902: 'SELECT ''X'' ' ||
903: ' FROM fnd_grants grants, ego_item_cat_denorm_hier cathier ' ||
904: ' WHERE grants.object_id = :object_id ' ||
905: ' AND grants.start_date <= SYSDATE '||
906: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
907: ' AND grants.instance_type = :instance_type ' ||

Line 930: ' FROM fnd_grants grants ' ||

926: ' ( grants.instance_pk5_value = ''*NULL*'' AND :pk5_val is NULL )) ';
927: ELSE
928: l_dynamic_sql :=
929: 'SELECT ''X'' ' ||
930: ' FROM fnd_grants grants ' ||
931: ' WHERE grants.object_id = :object_id ' ||
932: ' AND grants.start_date <= SYSDATE '||
933: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
934: ' AND grants.instance_type = :instance_type ' ||

Line 1059: ' FROM fnd_grants grants, ' ||

1055: -- open cursor for candidate sets and find out what all are required
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 '||

Line 1394: -- (NOTE: following bug 2865553, FND_GRANTS will not --

1390: END IF;
1391:
1392: -------------------------------------------------------
1393: -- We set PK query strings based on values passed in --
1394: -- (NOTE: following bug 2865553, FND_GRANTS will not --
1395: -- have null PK column values, so I'm changing this --
1396: -- code to check for '*NULL*' instead of null. -Dylan--
1397: -------------------------------------------------------
1398: translate_pk_values (p_instance_pk2_value => p_parent_instance_pk2_value

Line 1438: ' FROM fnd_grants grants ' ||

1434: -------------------------------------------------------------------------------
1435: -- R12C Security Changes
1436: /* l_dynamic_sql_1 :=
1437: ' SELECT ''X'' ' ||
1438: ' FROM fnd_grants grants ' ||
1439: ' WHERE grants.object_id = :object_id' ||
1440: ' AND grants.start_date <= SYSDATE ' ||
1441: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1442: ' AND grants.instance_type = :instance_type ' ||

Line 1462: ' FROM fnd_grants grants , ego_item_cat_denorm_hier cathier ' ||

1458:
1459: IF (p_object_name = 'EGO_CATALOG_GROUP') THEN
1460: l_dynamic_sql_1 :=
1461: ' SELECT ''X'' ' ||
1462: ' FROM fnd_grants grants , ego_item_cat_denorm_hier cathier ' ||
1463: ' WHERE grants.object_id = :object_id' ||
1464: ' AND grants.start_date <= SYSDATE ' ||
1465: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1466: ' AND grants.instance_type = :instance_type ' ||

Line 1485: ' FROM fnd_grants grants ' ||

1481: ' AND grants.menu_id IN (' || l_menu_info ||') ';
1482: ELSE
1483: l_dynamic_sql_1 :=
1484: ' SELECT ''X'' ' ||
1485: ' FROM fnd_grants grants ' ||
1486: ' WHERE grants.object_id = :object_id' ||
1487: ' AND grants.start_date <= SYSDATE ' ||
1488: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1489: ' 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 2053: ' FROM fnd_grants grants, ' ||

2049: --dbms_output.put_line('2. Diff. in Get Time 100th of a sec ::'||to_char(end_date-start_date,'9999999'));
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 ' ||

Line 2278: ' FROM fnd_grants grants, ' ||

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

Line 2298: ' FROM fnd_grants grants, ' ||

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

Line 2318: ' FROM fnd_grants grants, ' ||

2314: ' AND cmf.menu_id = grants.menu_id ';
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 ' ||

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 2888: ' FROM fnd_grants grants, ' ||

2884: l_inst_dyn_sql := '';
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 '||

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 3908: p_user_name FND_GRANTS.grantee_key%TYPE;

3904: FROM hz_parties
3905: WHERE party_id=cp_party_id;
3906:
3907: l_object_id number;
3908: p_user_name FND_GRANTS.grantee_key%TYPE;
3909: l_party_type VARCHAR2(30);
3910: BEGIN
3911: SetGlobals();
3912: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4133: ' FROM fnd_grants grants, ' ||

4129: --R12C Security Changes
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 ' ||

Line 4156: ' FROM fnd_grants grants, ' ||

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

Line 4181: ' FROM fnd_grants grants, ' ||

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

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 4394: p_user_name FND_GRANTS.grantee_key%TYPE;

4390: SELECT party_type
4391: FROM hz_parties
4392: WHERE party_id=cp_party_id;
4393: l_object_id NUMBER;
4394: p_user_name FND_GRANTS.grantee_key%TYPE;
4395: l_party_type VARCHAR2(30);
4396: l_append_inst_set_predicate VARCHAR2(2000);
4397: BEGIN
4398:

Line 4624: ' FROM fnd_grants grants, ' ||

4620: -- R12C Security Predicate
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 ' ||

Line 4646: ' FROM fnd_grants grants, ' ||

4642: ' OR (grants.grantee_type = ''GLOBAL'' AND grants.grantee_key in (''HZ_GLOBAL:-1000'', ''GLOBAL'') )))';*/
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) '||

Line 4671: ' FROM fnd_grants grants, ' ||

4667: ' OR (grants.grantee_type = ''GLOBAL'' AND grants.grantee_key in (''HZ_GLOBAL:-1000'', ''GLOBAL'') )))';
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 ' ||

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 5014: FROM fnd_grants grants,

5010: cp_object_id VARCHAR2
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

Line 5370: ' FROM fnd_grants grants, ' ||

5366: end if;
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

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 5486: ' FROM fnd_grants grants, '||

5482: END IF;
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'' '||

Line 5634: ' FROM fnd_grants grants ';

5630: IF(l_instance_flag = TRUE) THEN
5631: l_parent_predicate :=
5632: l_parent_predicate ||
5633: ' SELECT '||l_type_converted_val_cols ||
5634: ' FROM fnd_grants grants ';
5635:
5636: if (p_statement_type = 'EXISTS') then
5637: l_parent_predicate := l_parent_predicate ||
5638: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('|| p_parent_obj_pk1alias_tbl(l_table_index)||')';

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 7337: ' FROM fnd_grants grants, ' ||

7333: l_inst_dyn_sql := '';
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 '||

Line 7891: -- (NOTE: following bug 2865553, FND_GRANTS will not --

7887: );
7888:
7889: -------------------------------------------------------
7890: -- We set PK query strings based on values passed in --
7891: -- (NOTE: following bug 2865553, FND_GRANTS will not --
7892: -- have null PK column values, so I'm changing this --
7893: -- code to check for '*NULL*' instead of null. -Dylan--
7894: -------------------------------------------------------
7895: l_db_pk1_column := null;

Line 7946: ' FROM fnd_grants grants ' ||

7942: -------------------------------------------------------------------------------
7943:
7944: l_dynamic_sql_1 :=
7945: 'SELECT ''X'' ' ||
7946: ' FROM fnd_grants grants ' ||
7947: ' WHERE grants.object_id = :object_id ' ||
7948: ' AND grants.start_date <= SYSDATE '||
7949: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
7950: ' 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 ' ||