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

957: --dbms_output.put_line('2. Diff. in Get Time 100th of a sec ::'||to_char(end_date-start_date,'9999999'));
958: -- R12C Security Changes
959: /* l_dynamic_sql :=
960: 'SELECT ''X'' ' ||
961: ' FROM fnd_grants grants ' ||
962: ' WHERE grants.object_id = :object_id ' ||
963: ' AND grants.start_date <= SYSDATE '||
964: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
965: ' AND grants.instance_type = :instance_type ' ||

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

984:
985: IF (p_object_name = 'EGO_CATALOG_GROUP') THEN
986: l_dynamic_sql :=
987: 'SELECT ''X'' ' ||
988: ' FROM fnd_grants grants, ego_item_cat_denorm_hier cathier ' ||
989: ' WHERE grants.object_id = :object_id ' ||
990: ' AND grants.start_date <= SYSDATE '||
991: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
992: ' AND grants.instance_type = :instance_type ' ||

Line 1016: ' FROM fnd_grants grants ' ||

1012: ' ( grants.instance_pk5_value = ''*NULL*'' AND :pk5_val is NULL )) ';
1013: ELSE
1014: l_dynamic_sql :=
1015: 'SELECT ''X'' ' ||
1016: ' FROM fnd_grants grants ' ||
1017: ' WHERE grants.object_id = :object_id ' ||
1018: ' AND grants.start_date <= SYSDATE '||
1019: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
1020: ' AND grants.instance_type = :instance_type ' ||

Line 1152: ' FROM fnd_grants grants '||

1148: ' SELECT sets.instance_SET_ID, sets.predicate ' ||
1149: ' FROM fnd_object_instance_sets sets '||
1150: ' WHERE (sets.instance_set_id, sets.object_id) IN ' ||
1151: ' (SELECT grants.instance_set_id, grants.object_id ' ||
1152: ' FROM fnd_grants grants '||
1153: ' WHERE grants.object_id = :object_id '||
1154: ' AND grants.start_date <= SYSDATE ' ||
1155: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||
1156: ' AND grants.instance_type = :instance_type ' ||

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

1490: END IF;
1491:
1492: -------------------------------------------------------
1493: -- We set PK query strings based on values passed in --
1494: -- (NOTE: following bug 2865553, FND_GRANTS will not --
1495: -- have null PK column values, so I'm changing this --
1496: -- code to check for '*NULL*' instead of null. -Dylan--
1497: -------------------------------------------------------
1498: translate_pk_values (p_instance_pk2_value => p_parent_instance_pk2_value

Line 1538: ' FROM fnd_grants grants ' ||

1534: -------------------------------------------------------------------------------
1535: -- R12C Security Changes
1536: /* l_dynamic_sql_1 :=
1537: ' SELECT ''X'' ' ||
1538: ' FROM fnd_grants grants ' ||
1539: ' WHERE grants.object_id = :object_id' ||
1540: ' AND grants.start_date <= SYSDATE ' ||
1541: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1542: ' AND grants.instance_type = :instance_type ' ||

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

1558:
1559: IF (p_object_name = 'EGO_CATALOG_GROUP') THEN
1560: l_dynamic_sql_1 :=
1561: ' SELECT ''X'' ' ||
1562: ' FROM fnd_grants grants , ego_item_cat_denorm_hier cathier ' ||
1563: ' WHERE grants.object_id = :object_id' ||
1564: ' AND grants.start_date <= SYSDATE ' ||
1565: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1566: ' AND grants.instance_type = :instance_type ' ||

Line 1586: ' FROM fnd_grants grants ' ||

1582:
1583: ELSE
1584: l_dynamic_sql_1 :=
1585: ' SELECT ''X'' ' ||
1586: ' FROM fnd_grants grants ' ||
1587: ' WHERE grants.object_id = :object_id' ||
1588: ' AND grants.start_date <= SYSDATE ' ||
1589: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1590: ' AND grants.instance_type = :instance_type ' ||

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

1659: l_set_predicates := '(';
1660: l_set_predicate_segment := '';
1661: l_dynamic_sql_1 :=
1662: ' SELECT DISTINCT instance_sets.predicate ' ||
1663: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||
1664: ' WHERE grants.instance_type = :instance_type '||
1665: ' AND grants.start_date <= SYSDATE ' ||
1666: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1667: ' AND grants.instance_set_id = instance_sets.instance_set_id ' ||

Line 2155: ' FROM fnd_grants grants, ' ||

2151: --dbms_output.put_line('2. Diff. in Get Time 100th of a sec ::'||to_char(end_date-start_date,'9999999'));
2152:
2153: l_dynamic_sql_1 :=
2154: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
2155: ' FROM fnd_grants grants, ' ||
2156: ' fnd_object_instance_sets sets '||
2157: ' WHERE grants.instance_type = :instance_type '||
2158: ' AND grants.start_date <= SYSDATE ' ||
2159: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 2380: ' FROM fnd_grants grants, ' ||

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

Line 2400: ' FROM fnd_grants grants, ' ||

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

Line 2420: ' FROM fnd_grants grants, ' ||

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

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

2839: -- Now we build dynamic SQL using the work we just did to optimize the query --
2840: -------------------------------------------------------------------------------
2841: l_dynamic_sql_1 :=
2842: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
2843: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||
2844: ' WHERE grants.object_id = :object_id ' ||
2845: ' AND grants.start_date <= SYSDATE ' ||
2846: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||
2847: ' AND grants.instance_type = :instance_type ' ||

Line 2990: ' FROM fnd_grants grants, ' ||

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

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

4006: FROM hz_parties
4007: WHERE party_id=cp_party_id;
4008:
4009: l_object_id number;
4010: p_user_name FND_GRANTS.grantee_key%TYPE;
4011: l_party_type VARCHAR2(30);
4012: BEGIN
4013: SetGlobals();
4014: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 4235: ' FROM fnd_grants grants, ' ||

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

Line 4258: ' FROM fnd_grants grants, ' ||

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

Line 4283: ' FROM fnd_grants grants, ' ||

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

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

4492: SELECT party_type
4493: FROM hz_parties
4494: WHERE party_id=cp_party_id;
4495: l_object_id NUMBER;
4496: p_user_name FND_GRANTS.grantee_key%TYPE;
4497: l_party_type VARCHAR2(30);
4498: l_append_inst_set_predicate VARCHAR2(2000);
4499: BEGIN
4500:

Line 4726: ' FROM fnd_grants grants, ' ||

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

Line 4748: ' FROM fnd_grants grants, ' ||

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

Line 4773: ' FROM fnd_grants grants, ' ||

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

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

5112: cp_object_id VARCHAR2
5113: )
5114: IS
5115: SELECT DISTINCT instance_sets.predicate
5116: FROM fnd_grants grants,
5117: fnd_object_instance_sets instance_sets
5118: WHERE grants.instance_type = 'SET'
5119: AND grants.start_date <= SYSDATE
5120: AND ( grants.end_date IS NULL

Line 5472: ' FROM fnd_grants grants, ' ||

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

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

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

Line 5736: ' FROM fnd_grants grants ';

5732: IF(l_instance_flag = TRUE) THEN
5733: l_parent_predicate :=
5734: l_parent_predicate ||
5735: ' SELECT '||l_type_converted_val_cols ||
5736: ' FROM fnd_grants grants ';
5737:
5738: if (p_statement_type = 'EXISTS') then
5739: l_parent_predicate := l_parent_predicate ||
5740: ' WHERE grants.INSTANCE_PK1_VALUE=to_char('|| p_parent_obj_pk1alias_tbl(l_table_index)||')';

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

7377: -- Now we build dynamic SQL using the work we just did to optimize the query --
7378: -------------------------------------------------------------------------------
7379: l_dynamic_sql_1 :=
7380: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
7381: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||
7382: ' WHERE grants.object_id = :object_id ' ||
7383: ' AND grants.start_date <= SYSDATE ' ||
7384: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
7385: ' AND grants.instance_type = :instance_type ' ||

Line 7439: ' FROM fnd_grants grants, ' ||

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

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

7989: );
7990:
7991: -------------------------------------------------------
7992: -- We set PK query strings based on values passed in --
7993: -- (NOTE: following bug 2865553, FND_GRANTS will not --
7994: -- have null PK column values, so I'm changing this --
7995: -- code to check for '*NULL*' instead of null. -Dylan--
7996: -------------------------------------------------------
7997: l_db_pk1_column := null;

Line 8048: ' FROM fnd_grants grants ' ||

8044: -------------------------------------------------------------------------------
8045:
8046: l_dynamic_sql_1 :=
8047: 'SELECT ''X'' ' ||
8048: ' FROM fnd_grants grants ' ||
8049: ' WHERE grants.object_id = :object_id ' ||
8050: ' AND grants.start_date <= SYSDATE '||
8051: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
8052: ' AND grants.instance_type = :instance_type ' ||

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

8091: l_set_predicate_segment := '';
8092:
8093: l_dynamic_sql_1 :=
8094: ' SELECT DISTINCT instance_sets.predicate ' ||
8095: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||
8096: ' WHERE grants.instance_type = :instance_type '||
8097: ' AND grants.start_date <= SYSDATE ' ||
8098: ' AND (grants.end_date IS NULL OR grants.end_date >= SYSDATE) ' ||
8099: ' AND grants.instance_set_id = instance_sets.instance_set_id ' ||