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

98: WHERE obj.obj_name= cp_object_name
99: AND menus.menu_name=cp_menu_name
100: and exists
101: ( SELECT /*+ no_unnest */ 'x'
102: FROM fnd_grants grants
103: WHERE grants.grantee_key=cp_grantee_key
104: AND grants.grantee_type=cp_grantee_type
105: AND grants.instance_type=cp_instance_type
106: AND (grants.instance_pk1_value=cp_instance_pk1_value AND cp_instance_pk1_value IS NOT NULL )

Line 125: FROM fnd_grants grants

121: and obj.object_id=grants.object_id
122: AND menus.menu_id=grants.menu_id
123: UNION ALL
124: SELECT /*+ no_unnest */ 'x'
125: FROM fnd_grants grants
126: WHERE grants.grantee_key=cp_grantee_key
127: AND grants.grantee_type=cp_grantee_type
128: AND grants.instance_type=cp_instance_type
129: AND ( grants.instance_pk1_value = '*NULL*' AND cp_instance_pk1_value IS NULL )

Line 191: fnd_grants_pkg.grant_function(

187: cp_end_date => p_end_date);
188:
189: FETCH check_fnd_grant_exist INTO l_dummy;
190: IF( check_fnd_grant_exist%NOTFOUND) THEN
191: fnd_grants_pkg.grant_function(
192: p_api_version => 1.0,
193: p_menu_name => p_role_name ,
194: p_object_name => p_object_name,
195: p_instance_type => l_instance_type,

Line 249: l_instance_set_id fnd_grants.instance_set_id%TYPE;

245: -- Previous Version : None
246: -- Notes :
247: --
248: -- END OF comments
249: l_instance_set_id fnd_grants.instance_set_id%TYPE;
250: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
251: BEGIN
252: IF( p_instance_type ='SET') THEN
253: l_instance_set_id:=p_object_key;

Line 250: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

246: -- Notes :
247: --
248: -- END OF comments
249: l_instance_set_id fnd_grants.instance_set_id%TYPE;
250: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
251: BEGIN
252: IF( p_instance_type ='SET') THEN
253: l_instance_set_id:=p_object_key;
254: l_instance_pk1_value:= null;

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

300: x_grant_guid OUT NOCOPY RAW
301: )
302: IS
303:
304: --x_grant_guid fnd_grants.grant_guid%TYPE;
305: l_grantee_type hz_parties.party_type%TYPE;
306: l_instance_type fnd_grants.instance_type%TYPE;
307: l_grantee_key fnd_grants.grantee_key%TYPE;
308: l_dummy VARCHAR2(1);

Line 306: l_instance_type fnd_grants.instance_type%TYPE;

302: IS
303:
304: --x_grant_guid fnd_grants.grant_guid%TYPE;
305: l_grantee_type hz_parties.party_type%TYPE;
306: l_instance_type fnd_grants.instance_type%TYPE;
307: l_grantee_key fnd_grants.grantee_key%TYPE;
308: l_dummy VARCHAR2(1);
309: l_msg_count NUMBER;
310: l_msg_data VARCHAR2(4000);

Line 307: l_grantee_key fnd_grants.grantee_key%TYPE;

303:
304: --x_grant_guid fnd_grants.grant_guid%TYPE;
305: l_grantee_type hz_parties.party_type%TYPE;
306: l_instance_type fnd_grants.instance_type%TYPE;
307: l_grantee_key fnd_grants.grantee_key%TYPE;
308: l_dummy VARCHAR2(1);
309: l_msg_count NUMBER;
310: l_msg_data VARCHAR2(4000);
311: CURSOR get_party_type (cp_party_id NUMBER) IS

Line 338: FROM fnd_grants grants

334: WHERE obj.obj_name= cp_object_name
335: AND menus.menu_name=cp_menu_name
336: and exists
337: ( SELECT /*+ no_unnest */ 'x'
338: FROM fnd_grants grants
339: WHERE grants.grantee_key=cp_grantee_key
340: AND grants.grantee_type=cp_grantee_type
341: AND grants.instance_type=cp_instance_type
342: AND (grants.instance_pk1_value=cp_instance_pk1_value AND cp_instance_pk1_value IS NOT NULL )

Line 361: FROM fnd_grants grants

357: and obj.object_id=grants.object_id
358: AND menus.menu_id=grants.menu_id
359: UNION ALL
360: SELECT /*+ no_unnest */ 'x'
361: FROM fnd_grants grants
362: WHERE grants.grantee_key=cp_grantee_key
363: AND grants.grantee_type=cp_grantee_type
364: AND grants.instance_type=cp_instance_type
365: AND ( grants.instance_pk1_value = '*NULL*' AND cp_instance_pk1_value IS NULL )

Line 437: fnd_grants_pkg.grant_function(

433: cp_end_date => p_end_date);
434:
435: FETCH check_fnd_grant_exist INTO l_dummy;
436: IF( check_fnd_grant_exist%NOTFOUND) THEN
437: fnd_grants_pkg.grant_function(
438: p_api_version => 1.0,
439: p_menu_name => p_role_name ,
440: p_object_name => p_object_name,
441: p_instance_type => l_instance_type,

Line 521: l_instance_set_id fnd_grants.instance_set_id%TYPE;

517: -- Previous Version : None
518: -- Notes :
519: --
520: -- END OF comments
521: l_instance_set_id fnd_grants.instance_set_id%TYPE;
522: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
523: v_start_date DATE := sysdate;
524:
525: BEGIN

Line 522: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

518: -- Notes :
519: --
520: -- END OF comments
521: l_instance_set_id fnd_grants.instance_set_id%TYPE;
522: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
523: v_start_date DATE := sysdate;
524:
525: BEGIN
526: IF( p_instance_type ='SET') THEN

Line 588: l_grant_guid fnd_grants.grant_guid%TYPE;

584: -- Notes :
585: --
586: -- END OF comments
587:
588: l_grant_guid fnd_grants.grant_guid%TYPE;
589: CURSOR get_grant_guid(cp_grant_id VARCHAR2)
590: IS
591: SELECT grant_guid
592: FROM fnd_grants

Line 592: FROM fnd_grants

588: l_grant_guid fnd_grants.grant_guid%TYPE;
589: CURSOR get_grant_guid(cp_grant_id VARCHAR2)
590: IS
591: SELECT grant_guid
592: FROM fnd_grants
593: WHERE grant_guid=HEXTORAW(cp_grant_id);
594:
595: BEGIN
596: OPEN get_grant_guid(cp_grant_id=>p_grant_guid);

Line 600: fnd_grants_pkg.revoke_grant(

596: OPEN get_grant_guid(cp_grant_id=>p_grant_guid);
597: FETCH get_grant_guid INTO l_grant_guid;
598: CLOSE get_grant_guid;
599:
600: fnd_grants_pkg.revoke_grant(
601: p_api_version => p_api_version,
602: p_grant_guid => l_grant_guid ,
603: x_success => x_return_status,
604: x_errorcode => x_errorcode

Line 750: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;

746: --
747: -- END OF comments
748:
749:
750: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
751: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
752:
753: BEGIN
754: -- IF(check_override_datasec(p_party_id)) THEN

Line 751: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;

747: -- END OF comments
748:
749:
750: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
751: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
752:
753: BEGIN
754: -- IF(check_override_datasec(p_party_id)) THEN
755: -- RETURN 'T';

Line 890: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;

886: IS
887:
888: --x_functions_tbl EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
889:
890: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
891: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
892: l_index INTEGER;
893: CURSOR get_party_type (cp_party_id NUMBER)
894: IS

Line 891: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;

887:
888: --x_functions_tbl EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
889:
890: l_grantee_key fnd_grants.GRANTEE_KEY%TYPE;
891: l_grantee_type fnd_grants.GRANTEE_TYPE%TYPE;
892: l_index INTEGER;
893: CURSOR get_party_type (cp_party_id NUMBER)
894: IS
895: SELECT party_type

Line 951: l_grantee_key FND_GRANTS.grantee_key%TYPE;

947: x_object_key_tbl OUT NOCOPY ID_TBL_TYPE
948: )
949: IS
950: x_object_key_tbl_fnd EGO_DATA_SECURITY.EGO_INSTANCE_TABLE_TYPE;
951: l_grantee_key FND_GRANTS.grantee_key%TYPE;
952:
953:
954: BEGIN
955:

Line 1187: l_grantee_key fnd_grants.grantee_key%TYPE;

1183: -- Notes :
1184: --
1185: -- END OF comments
1186:
1187: l_grantee_key fnd_grants.grantee_key%TYPE;
1188: l_grantee_type fnd_grants.grantee_type%TYPE;
1189: x_predicate VARCHAR2(32000);
1190:
1191:

Line 1188: l_grantee_type fnd_grants.grantee_type%TYPE;

1184: --
1185: -- END OF comments
1186:
1187: l_grantee_key fnd_grants.grantee_key%TYPE;
1188: l_grantee_type fnd_grants.grantee_type%TYPE;
1189: x_predicate VARCHAR2(32000);
1190:
1191:
1192: BEGIN

Line 1405: l_grant_guid fnd_grants.grant_guid%TYPE;

1401: -- END OF comments
1402:
1403: --x_success VARCHAR2(2);
1404: l_dummy VARCHAR2(1);
1405: l_grant_guid fnd_grants.grant_guid%TYPE;
1406: CURSOR get_grant_guid(cp_grant_id VARCHAR2,
1407: cp_start_date DATE,
1408: cp_end_date DATE)
1409: IS

Line 1411: FROM fnd_grants g1, fnd_grants g2

1407: cp_start_date DATE,
1408: cp_end_date DATE)
1409: IS
1410: SELECT g1.grant_guid
1411: FROM fnd_grants g1, fnd_grants g2
1412: WHERE g1.grant_guid=HEXTORAW(cp_grant_id)
1413: AND g2.grant_guid<>HEXTORAW(cp_grant_id)
1414: AND g1.object_id=g2.object_id
1415: AND g1.menu_id=g2.menu_id

Line 1437: fnd_grants_pkg.update_grant (

1433: cp_end_date=>p_end_date);
1434: FETCH get_grant_guid INTO l_grant_guid;
1435:
1436: IF( get_grant_guid%NOTFOUND) THEN
1437: fnd_grants_pkg.update_grant (
1438: p_api_version => p_api_version,
1439: p_grant_guid => HEXTORAW(p_grant_guid),
1440: p_start_date => p_start_date,
1441: p_end_date => p_end_date,

Line 1670: FROM fnd_grants grants

1666: WHERE obj.obj_name= cp_object_name
1667: AND menus.menu_name=cp_menu_name
1668: and exists
1669: ( SELECT /*+ no_unnest */ 'x'
1670: FROM fnd_grants grants
1671: WHERE grants.grantee_key=cp_grantee_key
1672: AND grants.grantee_type=cp_grantee_type
1673: AND grants.instance_type=cp_instance_type
1674: AND (grants.instance_pk1_value=cp_instance_pk1_value AND cp_instance_pk1_value IS NOT NULL )

Line 1693: FROM fnd_grants grants

1689: and obj.object_id=grants.object_id
1690: AND menus.menu_id=grants.menu_id
1691: UNION ALL
1692: SELECT /*+ no_unnest */ 'x'
1693: FROM fnd_grants grants
1694: WHERE grants.grantee_key=cp_grantee_key
1695: AND grants.grantee_type=cp_grantee_type
1696: AND grants.instance_type=cp_instance_type
1697: AND ( grants.instance_pk1_value = '*NULL*' AND cp_instance_pk1_value IS NULL )

Line 1722: l_grantee_key fnd_grants.grantee_key%TYPE;

1718:
1719:
1720:
1721: l_grantee_type hz_parties.party_type%TYPE;
1722: l_grantee_key fnd_grants.grantee_key%TYPE;
1723: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1724: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1725: l_dummy VARCHAR2(1);
1726: CURSOR get_party_type (cp_party_id NUMBER)

Line 1723: l_instance_set_id fnd_grants.instance_set_id%TYPE;

1719:
1720:
1721: l_grantee_type hz_parties.party_type%TYPE;
1722: l_grantee_key fnd_grants.grantee_key%TYPE;
1723: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1724: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1725: l_dummy VARCHAR2(1);
1726: CURSOR get_party_type (cp_party_id NUMBER)
1727: IS

Line 1724: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

1720:
1721: l_grantee_type hz_parties.party_type%TYPE;
1722: l_grantee_key fnd_grants.grantee_key%TYPE;
1723: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1724: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1725: l_dummy VARCHAR2(1);
1726: CURSOR get_party_type (cp_party_id NUMBER)
1727: IS
1728: SELECT party_type

Line 1860: FROM fnd_grants grants

1856: cp_instance_set_id NUMBER,
1857: cp_start_date DATE,
1858: cp_end_date DATE) IS
1859: SELECT 'X'
1860: FROM fnd_grants grants
1861: WHERE grants.grantee_key=cp_grantee_key
1862: AND grants.grantee_type=cp_grantee_type
1863: AND grants.menu_id=cp_menu_id
1864: AND grants.object_id = cp_object_id

Line 1876: l_grantee_key fnd_grants.grantee_key%TYPE;

1872: OR ((grants.start_date >= cp_start_date )
1873: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1874:
1875: l_grantee_type hz_parties.party_type%TYPE;
1876: l_grantee_key fnd_grants.grantee_key%TYPE;
1877: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1878: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1879: l_dummy VARCHAR2(1);
1880:

Line 1877: l_instance_set_id fnd_grants.instance_set_id%TYPE;

1873: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1874:
1875: l_grantee_type hz_parties.party_type%TYPE;
1876: l_grantee_key fnd_grants.grantee_key%TYPE;
1877: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1878: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1879: l_dummy VARCHAR2(1);
1880:
1881: CURSOR get_party_type (cp_party_id NUMBER)

Line 1878: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;

1874:
1875: l_grantee_type hz_parties.party_type%TYPE;
1876: l_grantee_key fnd_grants.grantee_key%TYPE;
1877: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1878: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1879: l_dummy VARCHAR2(1);
1880:
1881: CURSOR get_party_type (cp_party_id NUMBER)
1882: IS