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.AMW_SECURITY_PUB dependencies on FND_GRANTS

Line 544: --x_grant_guid fnd_grants.grant_guid%TYPE;

540: p_check_for_existing IN VARCHAR2 := FND_API.G_TRUE
541: )
542: IS
543:
544: --x_grant_guid fnd_grants.grant_guid%TYPE;
545: l_grantee_type hz_parties.party_type%TYPE;
546: l_instance_type fnd_grants.instance_type%TYPE;
547: l_grantee_key fnd_grants.grantee_key%TYPE;
548: l_dummy VARCHAR2(1);

Line 546: l_instance_type fnd_grants.instance_type%TYPE;

542: IS
543:
544: --x_grant_guid fnd_grants.grant_guid%TYPE;
545: l_grantee_type hz_parties.party_type%TYPE;
546: l_instance_type fnd_grants.instance_type%TYPE;
547: l_grantee_key fnd_grants.grantee_key%TYPE;
548: l_dummy VARCHAR2(1);
549: l_not_found boolean := true;
550: CURSOR get_party_type (cp_party_id NUMBER)

Line 547: l_grantee_key fnd_grants.grantee_key%TYPE;

543:
544: --x_grant_guid fnd_grants.grant_guid%TYPE;
545: l_grantee_type hz_parties.party_type%TYPE;
546: l_instance_type fnd_grants.instance_type%TYPE;
547: l_grantee_key fnd_grants.grantee_key%TYPE;
548: l_dummy VARCHAR2(1);
549: l_not_found boolean := true;
550: CURSOR get_party_type (cp_party_id NUMBER)
551: IS

Line 571: FROM fnd_grants grants,

567: cp_start_date DATE,
568: cp_end_date DATE) IS
569:
570: SELECT 'X'
571: FROM fnd_grants grants,
572: fnd_objects obj,
573: fnd_menus menus
574: WHERE grants.grantee_key=cp_grantee_key
575: AND grants.grantee_type=cp_grantee_type

Line 652: fnd_grants_pkg.grant_function(

648: END IF;
649: CLOSE check_fnd_grant_exist;
650: END IF;
651: IF (l_not_found) THEN
652: fnd_grants_pkg.grant_function(
653: p_api_version => 1.0,
654: p_menu_name => p_role_name ,
655: p_object_name => p_object_name,
656: p_instance_type => l_instance_type,

Line 732: l_instance_set_id fnd_grants.instance_set_id%TYPE;

728: -- Previous Version : None
729: -- Notes :
730: --
731: -- END OF comments
732: l_instance_set_id fnd_grants.instance_set_id%TYPE;
733: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
734: v_start_date DATE := sysdate;
735:
736: BEGIN

Line 733: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

729: -- Notes :
730: --
731: -- END OF comments
732: l_instance_set_id fnd_grants.instance_set_id%TYPE;
733: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
734: v_start_date DATE := sysdate;
735:
736: BEGIN
737: IF( p_instance_type ='SET') THEN

Line 799: l_grant_guid fnd_grants.grant_guid%TYPE;

795: -- Notes :
796: --
797: -- END OF comments
798:
799: l_grant_guid fnd_grants.grant_guid%TYPE;
800: CURSOR get_grant_guid(cp_grant_id VARCHAR2)
801: IS
802: SELECT grant_guid
803: FROM fnd_grants

Line 803: FROM fnd_grants

799: l_grant_guid fnd_grants.grant_guid%TYPE;
800: CURSOR get_grant_guid(cp_grant_id VARCHAR2)
801: IS
802: SELECT grant_guid
803: FROM fnd_grants
804: WHERE grant_guid=HEXTORAW(cp_grant_id);
805:
806: BEGIN
807: OPEN get_grant_guid(cp_grant_id=>p_grant_guid);

Line 816: fnd_grants_pkg.revoke_grant(

812: p_grant_guid => l_grant_guid,
813: x_success => x_return_status,
814: x_errorcode => x_errorcode);
815:
816: fnd_grants_pkg.revoke_grant(
817: p_api_version => p_api_version,
818: p_grant_guid => l_grant_guid ,
819: x_success => x_return_status,
820: x_errorcode => x_errorcode

Line 853: l_grant_guid fnd_grants.grant_guid%TYPE;

849: -- END OF comments
850:
851: --x_success VARCHAR2(2);
852: l_dummy VARCHAR2(1);
853: l_grant_guid fnd_grants.grant_guid%TYPE;
854: CURSOR get_grant_guid(cp_grant_id VARCHAR2,
855: cp_start_date DATE,
856: cp_end_date DATE)
857: IS

Line 859: FROM fnd_grants g1, fnd_grants g2

855: cp_start_date DATE,
856: cp_end_date DATE)
857: IS
858: SELECT g1.grant_guid
859: FROM fnd_grants g1, fnd_grants g2
860: WHERE g1.grant_guid=HEXTORAW(cp_grant_id)
861: AND g2.grant_guid<>HEXTORAW(cp_grant_id)
862: AND g1.object_id=g2.object_id
863: AND g1.menu_id=g2.menu_id

Line 882: fnd_grants_pkg.update_grant (

878: cp_end_date=>p_end_date);
879: FETCH get_grant_guid INTO l_grant_guid;
880:
881: IF( get_grant_guid%NOTFOUND) THEN
882: fnd_grants_pkg.update_grant (
883: p_api_version => p_api_version,
884: p_grant_guid => HEXTORAW(p_grant_guid),
885: p_start_date => p_start_date,
886: p_end_date => p_end_date,

Line 996: SELECT /+ INDEX(g, FND_GRANTS_N1) / 1

992: select 1 from
993: dual
994: where exists
995: (
996: SELECT /*+ INDEX(g, FND_GRANTS_N1) */ 1
997: FROM fnd_grants g
998: WHERE (g.grantee_type = 'GLOBAL')
999: AND g.object_id = cp_object_id
1000: AND ( (cp_function_id = -1)

Line 997: FROM fnd_grants g

993: dual
994: where exists
995: (
996: SELECT /*+ INDEX(g, FND_GRANTS_N1) */ 1
997: FROM fnd_grants g
998: WHERE (g.grantee_type = 'GLOBAL')
999: AND g.object_id = cp_object_id
1000: AND ( (cp_function_id = -1)
1001: OR (g.menu_id in

Line 1032: SELECT /+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) / 'X'

1028: select 1 from
1029: dual
1030: where exists
1031: (
1032: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */ 'X'
1033: FROM
1034: ( select /*+ NO_MERGE */ role_name
1035: from wf_user_roles wur,
1036: (

Line 1048: fnd_grants g

1044: and incr1.partition_id = 9 /* HZ_PARTY */
1045: ) incr2
1046: where wur.user_name = incr2.name
1047: ) u2,
1048: fnd_grants g
1049: WHERE rownum = 1
1050: AND g.grantee_key = u2.role_name
1051: and g.object_id = cp_object_id
1052: and ((cp_function_id = -1)

Line 1078: SELECT /+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) /

1074: CURSOR isg_grp_glob_fn_c (cp_user_name varchar2,
1075: cp_function_id NUMBER,
1076: cp_object_id VARCHAR2)
1077: IS
1078: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */
1079: instance_sets.predicate, instance_sets.instance_set_id,
1080: g.grant_guid
1081: FROM
1082: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual

Line 1098: fnd_grants g,

1094: and incr1.partition_id = 9 /* HZ_PARTY */
1095: ) incr2
1096: where wur.user_name = incr2.name
1097: ) u2,
1098: fnd_grants g,
1099: fnd_object_instance_sets instance_sets
1100: WHERE g.grantee_key = u2.role_name
1101: AND g.instance_type = 'SET'
1102: AND g.object_id = cp_object_id

Line 1128: SELECT /+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) /

1124: CURSOR isg_grp_fn_c (cp_user_name varchar2,
1125: cp_function_id NUMBER,
1126: cp_object_id VARCHAR2)
1127: IS
1128: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */
1129: instance_sets.predicate, instance_sets.instance_set_id,
1130: g.grant_guid
1131: FROM
1132: ( select /*+ NO_MERGE */ role_name

Line 1146: fnd_grants g,

1142: and incr1.partition_id = 9 /* HZ_PARTY */
1143: ) incr2
1144: where wur.user_name = incr2.name
1145: ) u2,
1146: fnd_grants g,
1147: fnd_object_instance_sets instance_sets
1148: WHERE g.grantee_key = u2.role_name
1149: AND g.object_id = cp_object_id
1150: AND (g.menu_id in

Line 1178: FROM fnd_grants g,

1174: cp_object_id VARCHAR2)
1175: IS
1176: SELECT instance_sets.predicate, instance_sets.instance_set_id,
1177: g.grant_guid
1178: FROM fnd_grants g,
1179: fnd_object_instance_sets instance_sets
1180: WHERE g.instance_type = 'SET'
1181: AND (g.grantee_type = 'GLOBAL')
1182: AND g.object_id = cp_object_id

Line 1688: ' FROM fnd_grants g, fnd_compiled_menu_functions cmf ' ||

1684: /* against the grants table */
1685: -- abedajna begin
1686:
1687: top := ' SELECT g.grant_guid ' ||
1688: ' FROM fnd_grants g, fnd_compiled_menu_functions cmf ' ||
1689: ' WHERE g.instance_type = '||''''||'SET'||'''' ||
1690: ' and g.instance_set_id = ' || d_instance_set_id ||
1691: ' AND g.menu_id = cmf.menu_id AND cmf.function_id = '|| l_function_id;
1692:

Line 1755: ' from fnd_grants gnt'||

1751:
1752: l_aggregate_predicate :=
1753: substrb( l_aggregate_predicate ||
1754: ' exists (select null'||
1755: ' from fnd_grants gnt'||
1756: ' where gnt.grant_guid in ' || guid_subquery,
1757: 1, c_pred_buf_size);
1758: l_need_to_close_pred := TRUE;
1759: l_refers_to_grants := TRUE;

Line 1817: ' from fnd_grants gnt';

1813: if (l_inst_instance_type) then
1814: l_instance_predicate :=
1815: l_instance_predicate ||
1816: ' exists (select null'||
1817: ' from fnd_grants gnt';
1818: if (p_with_binds = 'Y') then
1819: l_instance_predicate :=
1820: l_instance_predicate ||
1821: ' where (GNT.object_id = :OBJECT_ID_BIND'||