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_SECURITY_PUB dependencies on FND_GRANTS

Line 70: x_grant_guid fnd_grants.grant_guid%TYPE;

66: x_errorcode OUT NOCOPY NUMBER
67: )
68: IS
69:
70: x_grant_guid fnd_grants.grant_guid%TYPE;
71: l_grantee_type hz_parties.party_type%TYPE;
72: l_instance_type fnd_grants.instance_type%TYPE;
73: l_grantee_key fnd_grants.grantee_key%TYPE;
74: l_dummy VARCHAR2(1);

Line 72: l_instance_type fnd_grants.instance_type%TYPE;

68: IS
69:
70: x_grant_guid fnd_grants.grant_guid%TYPE;
71: l_grantee_type hz_parties.party_type%TYPE;
72: l_instance_type fnd_grants.instance_type%TYPE;
73: l_grantee_key fnd_grants.grantee_key%TYPE;
74: l_dummy VARCHAR2(1);
75: CURSOR get_party_type (cp_party_id NUMBER)
76: IS

Line 73: l_grantee_key fnd_grants.grantee_key%TYPE;

69:
70: x_grant_guid fnd_grants.grant_guid%TYPE;
71: l_grantee_type hz_parties.party_type%TYPE;
72: l_instance_type fnd_grants.instance_type%TYPE;
73: l_grantee_key fnd_grants.grantee_key%TYPE;
74: l_dummy VARCHAR2(1);
75: CURSOR get_party_type (cp_party_id NUMBER)
76: IS
77: SELECT party_type

Line 96: FROM fnd_grants grants,

92: cp_start_date DATE,
93: cp_end_date DATE) IS
94:
95: SELECT 'X'
96: FROM fnd_grants grants,
97: fnd_objects obj,
98: fnd_menus menus
99: WHERE grants.grantee_key=cp_grantee_key
100: AND grants.grantee_type=cp_grantee_type

Line 166: fnd_grants_pkg.grant_function(

162: cp_end_date => p_end_date);
163:
164: FETCH check_fnd_grant_exist INTO l_dummy;
165: IF( check_fnd_grant_exist%NOTFOUND) THEN
166: fnd_grants_pkg.grant_function(
167: p_api_version => 1.0,
168: p_menu_name => p_role_name ,
169: p_object_name => p_object_name,
170: p_instance_type => l_instance_type,

Line 224: l_instance_set_id fnd_grants.instance_set_id%TYPE;

220: -- Previous Version : None
221: -- Notes :
222: --
223: -- END OF comments
224: l_instance_set_id fnd_grants.instance_set_id%TYPE;
225: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
226: BEGIN
227: IF( p_instance_type ='SET') THEN
228: l_instance_set_id:=p_object_key;

Line 225: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

221: -- Notes :
222: --
223: -- END OF comments
224: l_instance_set_id fnd_grants.instance_set_id%TYPE;
225: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
226: BEGIN
227: IF( p_instance_type ='SET') THEN
228: l_instance_set_id:=p_object_key;
229: l_instance_pk1_value:= null;

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

275: x_grant_guid OUT NOCOPY RAW
276: )
277: IS
278:
279: --x_grant_guid fnd_grants.grant_guid%TYPE;
280: l_grantee_type hz_parties.party_type%TYPE;
281: l_instance_type fnd_grants.instance_type%TYPE;
282: l_grantee_key fnd_grants.grantee_key%TYPE;
283: l_dummy VARCHAR2(1);

Line 281: l_instance_type fnd_grants.instance_type%TYPE;

277: IS
278:
279: --x_grant_guid fnd_grants.grant_guid%TYPE;
280: l_grantee_type hz_parties.party_type%TYPE;
281: l_instance_type fnd_grants.instance_type%TYPE;
282: l_grantee_key fnd_grants.grantee_key%TYPE;
283: l_dummy VARCHAR2(1);
284: l_msg_count NUMBER;
285: l_msg_data VARCHAR2(4000);

Line 282: l_grantee_key fnd_grants.grantee_key%TYPE;

278:
279: --x_grant_guid fnd_grants.grant_guid%TYPE;
280: l_grantee_type hz_parties.party_type%TYPE;
281: l_instance_type fnd_grants.instance_type%TYPE;
282: l_grantee_key fnd_grants.grantee_key%TYPE;
283: l_dummy VARCHAR2(1);
284: l_msg_count NUMBER;
285: l_msg_data VARCHAR2(4000);
286: CURSOR get_party_type (cp_party_id NUMBER) IS

Line 306: FROM fnd_grants grants,

302: cp_start_date DATE,
303: cp_end_date DATE) IS
304:
305: SELECT 'X'
306: FROM fnd_grants grants,
307: fnd_objects obj,
308: fnd_menus menus
309: WHERE grants.grantee_key=cp_grantee_key
310: AND grants.grantee_type=cp_grantee_type

Line 382: fnd_grants_pkg.grant_function(

378: cp_end_date => p_end_date);
379:
380: FETCH check_fnd_grant_exist INTO l_dummy;
381: IF( check_fnd_grant_exist%NOTFOUND) THEN
382: fnd_grants_pkg.grant_function(
383: p_api_version => 1.0,
384: p_menu_name => p_role_name ,
385: p_object_name => p_object_name,
386: p_instance_type => l_instance_type,

Line 466: l_instance_set_id fnd_grants.instance_set_id%TYPE;

462: -- Previous Version : None
463: -- Notes :
464: --
465: -- END OF comments
466: l_instance_set_id fnd_grants.instance_set_id%TYPE;
467: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
468: v_start_date DATE := sysdate;
469:
470: BEGIN

Line 467: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

463: -- Notes :
464: --
465: -- END OF comments
466: l_instance_set_id fnd_grants.instance_set_id%TYPE;
467: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
468: v_start_date DATE := sysdate;
469:
470: BEGIN
471: IF( p_instance_type ='SET') THEN

Line 533: l_grant_guid fnd_grants.grant_guid%TYPE;

529: -- Notes :
530: --
531: -- END OF comments
532:
533: l_grant_guid fnd_grants.grant_guid%TYPE;
534: CURSOR get_grant_guid(cp_grant_id VARCHAR2)
535: IS
536: SELECT grant_guid
537: FROM fnd_grants

Line 537: FROM fnd_grants

533: l_grant_guid fnd_grants.grant_guid%TYPE;
534: CURSOR get_grant_guid(cp_grant_id VARCHAR2)
535: IS
536: SELECT grant_guid
537: FROM fnd_grants
538: WHERE grant_guid=HEXTORAW(cp_grant_id);
539:
540: BEGIN
541: OPEN get_grant_guid(cp_grant_id=>p_grant_guid);

Line 545: fnd_grants_pkg.revoke_grant(

541: OPEN get_grant_guid(cp_grant_id=>p_grant_guid);
542: FETCH get_grant_guid INTO l_grant_guid;
543: CLOSE get_grant_guid;
544:
545: fnd_grants_pkg.revoke_grant(
546: p_api_version => p_api_version,
547: p_grant_guid => l_grant_guid ,
548: x_success => x_return_status,
549: x_errorcode => x_errorcode

Line 695: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;

691: --
692: -- END OF comments
693:
694:
695: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
696: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
697:
698: BEGIN
699: -- IF(check_override_datasec(p_party_id)) THEN

Line 696: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;

692: -- END OF comments
693:
694:
695: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
696: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
697:
698: BEGIN
699: -- IF(check_override_datasec(p_party_id)) THEN
700: -- RETURN 'T';

Line 835: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;

831: IS
832:
833: --x_functions_tbl EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
834:
835: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
836: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
837: l_index INTEGER;
838: CURSOR get_party_type (cp_party_id NUMBER)
839: IS

Line 836: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;

832:
833: --x_functions_tbl EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
834:
835: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
836: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
837: l_index INTEGER;
838: CURSOR get_party_type (cp_party_id NUMBER)
839: IS
840: SELECT party_type

Line 896: l_grantee_key FND_GRANTS.grantee_key%TYPE;

892: x_object_key_tbl OUT NOCOPY ID_TBL_TYPE
893: )
894: IS
895: x_object_key_tbl_fnd EGO_DATA_SECURITY.EGO_INSTANCE_TABLE_TYPE;
896: l_grantee_key FND_GRANTS.grantee_key%TYPE;
897:
898:
899: BEGIN
900:

Line 1132: l_grantee_key fnd_grants.grantee_key%TYPE;

1128: -- Notes :
1129: --
1130: -- END OF comments
1131:
1132: l_grantee_key fnd_grants.grantee_key%TYPE;
1133: l_grantee_type fnd_grants.grantee_type%TYPE;
1134: x_predicate VARCHAR2(32000);
1135:
1136:

Line 1133: l_grantee_type fnd_grants.grantee_type%TYPE;

1129: --
1130: -- END OF comments
1131:
1132: l_grantee_key fnd_grants.grantee_key%TYPE;
1133: l_grantee_type fnd_grants.grantee_type%TYPE;
1134: x_predicate VARCHAR2(32000);
1135:
1136:
1137: BEGIN

Line 1350: l_grant_guid fnd_grants.grant_guid%TYPE;

1346: -- END OF comments
1347:
1348: --x_success VARCHAR2(2);
1349: l_dummy VARCHAR2(1);
1350: l_grant_guid fnd_grants.grant_guid%TYPE;
1351: CURSOR get_grant_guid(cp_grant_id VARCHAR2,
1352: cp_start_date DATE,
1353: cp_end_date DATE)
1354: IS

Line 1356: FROM fnd_grants g1, fnd_grants g2

1352: cp_start_date DATE,
1353: cp_end_date DATE)
1354: IS
1355: SELECT g1.grant_guid
1356: FROM fnd_grants g1, fnd_grants g2
1357: WHERE g1.grant_guid=HEXTORAW(cp_grant_id)
1358: AND g2.grant_guid<>HEXTORAW(cp_grant_id)
1359: AND g1.object_id=g2.object_id
1360: AND g1.menu_id=g2.menu_id

Line 1382: fnd_grants_pkg.update_grant (

1378: cp_end_date=>p_end_date);
1379: FETCH get_grant_guid INTO l_grant_guid;
1380:
1381: IF( get_grant_guid%NOTFOUND) THEN
1382: fnd_grants_pkg.update_grant (
1383: p_api_version => p_api_version,
1384: p_grant_guid => HEXTORAW(p_grant_guid),
1385: p_start_date => p_start_date,
1386: p_end_date => p_end_date,

Line 1608: FROM fnd_grants grants,

1604: cp_start_date DATE,
1605: cp_end_date DATE) IS
1606:
1607: SELECT 'X'
1608: FROM fnd_grants grants,
1609: fnd_objects obj,
1610: fnd_menus menus
1611: WHERE grants.grantee_key=cp_grantee_key
1612: AND grants.grantee_type=cp_grantee_type

Line 1636: l_grantee_key fnd_grants.grantee_key%TYPE;

1632: OR ((grants.start_date >= cp_start_date )
1633: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1634:
1635: l_grantee_type hz_parties.party_type%TYPE;
1636: l_grantee_key fnd_grants.grantee_key%TYPE;
1637: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1638: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1639: l_dummy VARCHAR2(1);
1640: CURSOR get_party_type (cp_party_id NUMBER)

Line 1637: l_instance_set_id fnd_grants.instance_set_id%TYPE;

1633: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1634:
1635: l_grantee_type hz_parties.party_type%TYPE;
1636: l_grantee_key fnd_grants.grantee_key%TYPE;
1637: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1638: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1639: l_dummy VARCHAR2(1);
1640: CURSOR get_party_type (cp_party_id NUMBER)
1641: IS

Line 1638: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

1634:
1635: l_grantee_type hz_parties.party_type%TYPE;
1636: l_grantee_key fnd_grants.grantee_key%TYPE;
1637: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1638: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1639: l_dummy VARCHAR2(1);
1640: CURSOR get_party_type (cp_party_id NUMBER)
1641: IS
1642: SELECT party_type

Line 1774: FROM fnd_grants grants

1770: cp_instance_set_id NUMBER,
1771: cp_start_date DATE,
1772: cp_end_date DATE) IS
1773: SELECT 'X'
1774: FROM fnd_grants grants
1775: WHERE grants.grantee_key=cp_grantee_key
1776: AND grants.grantee_type=cp_grantee_type
1777: AND grants.menu_id=cp_menu_id
1778: AND grants.object_id = cp_object_id

Line 1790: l_grantee_key fnd_grants.grantee_key%TYPE;

1786: OR ((grants.start_date >= cp_start_date )
1787: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1788:
1789: l_grantee_type hz_parties.party_type%TYPE;
1790: l_grantee_key fnd_grants.grantee_key%TYPE;
1791: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1792: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1793: l_dummy VARCHAR2(1);
1794:

Line 1791: l_instance_set_id fnd_grants.instance_set_id%TYPE;

1787: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1788:
1789: l_grantee_type hz_parties.party_type%TYPE;
1790: l_grantee_key fnd_grants.grantee_key%TYPE;
1791: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1792: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1793: l_dummy VARCHAR2(1);
1794:
1795: CURSOR get_party_type (cp_party_id NUMBER)

Line 1792: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

1788:
1789: l_grantee_type hz_parties.party_type%TYPE;
1790: l_grantee_key fnd_grants.grantee_key%TYPE;
1791: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1792: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1793: l_dummy VARCHAR2(1);
1794:
1795: CURSOR get_party_type (cp_party_id NUMBER)
1796: IS