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.IBC_CITEM_ADMIN_GRP dependencies on FND_GLOBAL

Line 547: (locked_by_user_id = FND_GLOBAL.user_id) );

543: content_item_id = f_content_item_id
544: AND
545: ( (locked_by_user_id IS NULL)
546: OR
547: (locked_by_user_id = FND_GLOBAL.user_id) );
548:
549:
550: temp NUMBER;
551: BEGIN

Line 730: ELSIF (cby = FND_GLOBAL.user_id) THEN

726: -- not found!
727: CLOSE c_admin;
728: RETURN FND_API.g_false;
729: -- if creator
730: ELSIF (cby = FND_GLOBAL.user_id) THEN
731: CLOSE c_admin;
732: RETURN FND_API.g_true;
733: -- if owner (USER_ID)
734: ELSIF ort IS NULL

Line 735: AND ori = FND_GLOBAL.user_id

731: CLOSE c_admin;
732: RETURN FND_API.g_true;
733: -- if owner (USER_ID)
734: ELSIF ort IS NULL
735: AND ori = FND_GLOBAL.user_id
736: THEN
737: CLOSE c_admin;
738: RETURN FND_API.g_true;
739: -- if owner (Resource)

Line 3867: ,p_current_user_id => FND_GLOBAL.user_id --|*|

3863: ,p_instance_pk1_value => p_content_item_id --|*|
3864: ,p_permission_code => 'CITEM_EDIT' --|*|
3865: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
3866: ,p_container_pk1_value => dir_id --|*|
3867: ,p_current_user_id => FND_GLOBAL.user_id --|*|
3868: ) = FND_API.g_false --|*|
3869: ) THEN --|*|
3870: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
3871: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 4136: ,p_current_user_id => FND_GLOBAL.user_id --|*|

4132: ,p_instance_pk1_value => content_item_id --|*|
4133: ,p_permission_code => 'CITEM_EDIT' --|*|
4134: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
4135: ,p_container_pk1_value => dir_id --|*|
4136: ,p_current_user_id => FND_GLOBAL.user_id --|*|
4137: ) = FND_API.g_false
4138: AND
4139: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED)
4140: OR

Line 4147: ,p_current_user_id => FND_GLOBAL.user_id --|*|

4143: ,p_instance_pk1_value => content_item_id --|*|
4144: ,p_permission_code => 'CITEM_APPROVE' --|*|
4145: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
4146: ,p_container_pk1_value => dir_id --|*|
4147: ,p_current_user_id => FND_GLOBAL.user_id --|*|
4148: ) = FND_API.g_false --|*|
4149: )
4150: ) THEN --|*|
4151: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|

Line 4596: ,p_current_user_id => FND_GLOBAL.user_id --|*|

4592: ,p_instance_pk1_value => NULL --|*|
4593: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
4594: ,p_container_pk1_value => NVL(p_directory_node_id, o_dir_node) --|*|
4595: ,p_permission_code => 'CITEM_EDIT' --|*|
4596: ,p_current_user_id => FND_GLOBAL.user_id --|*|
4597: ) = FND_API.g_false --|*|
4598: ) THEN --|*|
4599: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
4600: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 4622: ,p_owner_resource_id => FND_GLOBAL.USER_ID

4618: ,p_locked_by_user_id => NULL
4619: ,p_wd_restricted_flag => o_wd_flag
4620: ,p_base_language => lang
4621: ,p_translation_required_flag => o_trans_flag
4622: ,p_owner_resource_id => FND_GLOBAL.USER_ID
4623: ,p_owner_resource_type => 'USER'
4624: ,p_application_id => NULL
4625: ,p_parent_item_id => NULL
4626: ,p_request_id => NULL

Line 5269: ,p_current_user_id => FND_GLOBAL.user_id --|*|

5265: ,p_instance_pk1_value => content_item_id --|*|
5266: ,p_permission_code => 'CITEM_EDIT' --|*|
5267: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
5268: ,p_container_pk1_value => dir_id --|*|
5269: ,p_current_user_id => FND_GLOBAL.user_id --|*|
5270: ) = FND_API.g_false --|*|
5271: ) THEN --|*|
5272: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
5273: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 5563: ,p_current_user_id => FND_GLOBAL.user_id --|*|

5559: ,p_instance_pk1_value => p_content_item_id --|*|
5560: ,p_permission_code => 'CITEM_EDIT' --|*|
5561: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
5562: ,p_container_pk1_value => dir_id --|*|
5563: ,p_current_user_id => FND_GLOBAL.user_id --|*|
5564: ) = FND_API.g_false --|*|
5565: ) THEN --|*|
5566: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
5567: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 6351: ,p_current_user_id => FND_GLOBAL.user_id --|*|

6347: ,p_instance_pk1_value => x_content_item_id --|*|
6348: ,p_permission_code => 'CITEM_READ' --|*|
6349: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
6350: ,p_container_pk1_value => x_dir_node_id --|*|
6351: ,p_current_user_id => FND_GLOBAL.user_id --|*|
6352: ) = FND_API.g_false --|*|
6353: ) THEN IF --|*|
6354:
6355: IBC_DATA_SECURITY_PVT.has_permission(

Line 6362: p_current_user_id => FND_GLOBAL.user_id ) = FND_API.g_false THEN

6358: ,p_permission_code => 'CITEM_EDIT'
6359: ,p_container_object_id =>
6360: IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE'),
6361: p_container_pk1_value => x_dir_node_id,
6362: p_current_user_id => FND_GLOBAL.user_id ) = FND_API.g_false THEN
6363:
6364: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
6365: x_return_status := FND_API.G_RET_STS_ERROR; --|*|
6366: FND_MESSAGE.Set_Name('IBC', 'INSUFFICIENT_PRIVILEGES'); --|*|

Line 8127: ,p_current_user_id => FND_GLOBAL.user_id --|*|

8123: ,p_instance_pk1_value => content_item_id --|*|
8124: ,p_permission_code => 'CITEM_EDIT' --|*|
8125: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
8126: ,p_container_pk1_value => dir_id --|*|
8127: ,p_current_user_id => FND_GLOBAL.user_id --|*|
8128: ) = FND_API.g_false --|*|
8129: ) THEN --|*|
8130: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
8131: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 8481: ,p_current_user_id => FND_GLOBAL.user_id --|*|

8477: ,p_instance_pk1_value => p_content_item_id --|*|
8478: ,p_permission_code => 'CITEM_EDIT' --|*|
8479: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
8480: ,p_container_pk1_value => dir_id --|*|
8481: ,p_current_user_id => FND_GLOBAL.user_id --|*|
8482: ) = FND_API.g_false --|*|
8483: ) THEN --|*|
8484: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
8485: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 8766: ,p_current_user_id => FND_GLOBAL.user_id --|*|

8762: ,p_instance_pk1_value => px_content_item_id --|*|
8763: ,p_permission_code => 'CITEM_EDIT' --|*|
8764: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
8765: ,p_container_pk1_value => p_dir_node_id --|*|
8766: ,p_current_user_id => FND_GLOBAL.user_id --|*|
8767: ) = FND_API.g_false --|*|
8768: ) THEN --|*|
8769: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
8770: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 8789: ,p_current_user_id => FND_GLOBAL.user_id --|*|

8785: ,p_instance_pk1_value => NULL --|*|
8786: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
8787: ,p_container_pk1_value => p_dir_node_id --|*|
8788: ,p_permission_code => 'CITEM_EDIT' --|*|
8789: ,p_current_user_id => FND_GLOBAL.user_id --|*|
8790: ) = FND_API.g_false --|*|
8791: ) THEN --|*|
8792: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
8793: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 8804: locked_by := FND_GLOBAL.user_id;

8800: END IF;
8801:
8802: -- setting locked_by info
8803: IF (p_lock_flag = FND_API.g_true) THEN
8804: locked_by := FND_GLOBAL.user_id;
8805: ELSE
8806: locked_by := NULL;
8807: END IF;
8808:

Line 8824: ,p_owner_resource_id => FND_GLOBAL.USER_ID

8820: ,p_locked_by_user_id => locked_by
8821: ,p_wd_restricted_flag => FND_API.g_false
8822: ,p_base_language => USERENV('LANG')
8823: ,p_translation_required_flag => FND_API.g_false
8824: ,p_owner_resource_id => FND_GLOBAL.USER_ID
8825: ,p_owner_resource_type => 'USER'
8826: ,p_application_id => NULL
8827: ,p_parent_item_id => NULL
8828: ,p_request_id => NULL

Line 9098: ,p_current_user_id => FND_GLOBAL.user_id --|*|

9094: ,p_instance_pk1_value => p_content_item_id --|*|
9095: ,p_permission_code => 'CITEM_EDIT' --|*|
9096: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
9097: ,p_container_pk1_value => dir_id --|*|
9098: ,p_current_user_id => FND_GLOBAL.user_id --|*|
9099: ) = FND_API.g_false --|*|
9100: ) THEN --|*|
9101: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
9102: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 9110: changeLock(p_content_item_id,FND_GLOBAL.user_id);

9106: END IF; --|*|
9107: END IF; --|*|
9108: -- ***************PERMISSION CHECK*********************************************************************
9109:
9110: changeLock(p_content_item_id,FND_GLOBAL.user_id);
9111:
9112: -- getting object version number
9113: x_object_version_number := getObjVerNum(p_content_item_id);
9114:

Line 9516: ,p_current_user_id => FND_GLOBAL.user_id --|*|

9512: ,p_instance_pk1_value => content_item_id --|*|
9513: ,p_permission_code => 'CITEM_EDIT' --|*|
9514: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
9515: ,p_container_pk1_value => dir_id --|*|
9516: ,p_current_user_id => FND_GLOBAL.user_id --|*|
9517: ) = FND_API.g_false --|*|
9518: ) THEN --|*|
9519: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
9520: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 9965: ,p_current_user_id => FND_GLOBAL.user_id --|*|

9961: ,p_instance_pk1_value => content_item_id --|*|
9962: ,p_permission_code => 'CITEM_EDIT' --|*|
9963: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
9964: ,p_container_pk1_value => dir_id --|*|
9965: ,p_current_user_id => FND_GLOBAL.user_id --|*|
9966: ) = FND_API.g_false --|*|
9967: ) THEN --|*|
9968: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
9969: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 10289: p_new_owner_resource_id := FND_GLOBAL.user_id;

10285: ELSE
10286: p_new_owner_resource_type := p_owner_resource_type;
10287: END IF;
10288: ELSE -- user does not pass resource_id default to login user id
10289: p_new_owner_resource_id := FND_GLOBAL.user_id;
10290: p_new_owner_resource_type := 'USER';
10291: END IF;
10292:
10293:

Line 10317: ,p_current_user_id => FND_GLOBAL.user_id --|*|

10313: ,p_instance_pk1_value => p_content_item_id --|*|
10314: ,p_permission_code => 'CITEM_EDIT' --|*|
10315: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE') --|*|
10316: ,p_container_pk1_value => directory_node --|*|
10317: ,p_current_user_id => FND_GLOBAL.user_id --|*|
10318: ) = FND_API.g_false --|*|
10319: ) THEN --|*|
10320: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
10321: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 10598: ,p_current_user_id => FND_GLOBAL.user_id --|*|

10594: ,p_instance_pk1_value => p_content_item_id --|*|
10595: ,p_permission_code => 'CITEM_EDIT' --|*|
10596: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
10597: ,p_container_pk1_value => l_dir_id --|*|
10598: ,p_current_user_id => FND_GLOBAL.user_id --|*|
10599: ) = FND_API.g_false --|*|
10600: ) THEN --|*|
10601: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
10602: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 10861: ,p_current_user_id => FND_GLOBAL.user_id --|*|

10857: ,p_instance_pk1_value => content_item_id --|*|
10858: ,p_permission_code => 'CITEM_EDIT' --|*|
10859: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
10860: ,p_container_pk1_value => directory_node --|*|
10861: ,p_current_user_id => FND_GLOBAL.user_id --|*|
10862: ) = FND_API.g_false --|*|
10863: ) THEN --|*|
10864: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
10865: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 11138: ,p_current_user_id => FND_GLOBAL.user_id --|*|

11134: ,p_instance_pk1_value => p_content_item_id --|*|
11135: ,p_permission_code => 'CITEM_EDIT' --|*|
11136: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
11137: ,p_container_pk1_value => dir_id --|*|
11138: ,p_current_user_id => FND_GLOBAL.user_id --|*|
11139: ) = FND_API.g_false --|*|
11140: ) THEN --|*|
11141: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
11142: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 11391: ,p_current_user_id => FND_GLOBAL.user_id --|*|

11387: ,p_instance_pk1_value => p_content_item_id --|*|
11388: ,p_permission_code => 'CITEM_EDIT' --|*|
11389: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
11390: ,p_container_pk1_value => dir_id --|*|
11391: ,p_current_user_id => FND_GLOBAL.user_id --|*|
11392: ) = FND_API.g_false --|*|
11393: ) THEN --|*|
11394: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
11395: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 11830: p_new_owner_resource_id := FND_GLOBAL.user_id;

11826: ELSE
11827: p_new_owner_resource_type := p_owner_resource_type;
11828: END IF;
11829: ELSE -- user does not pass resource_id default to login user id
11830: p_new_owner_resource_id := FND_GLOBAL.user_id;
11831: p_new_owner_resource_type := 'USER';
11832: END IF;
11833:
11834:

Line 11864: locked_by := FND_GLOBAL.user_id;

11860: END IF;
11861:
11862: -- setting locked_by info
11863: IF (p_lock_flag = FND_API.g_true) THEN
11864: locked_by := FND_GLOBAL.user_id;
11865: ELSE
11866: locked_by := NULL;
11867: END IF;
11868:

Line 11884: ,p_current_user_id => FND_GLOBAL.user_id --|*|

11880: ,p_instance_pk1_value => NULL --|*|
11881: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
11882: ,p_container_pk1_value => directory_node --|*|
11883: ,p_permission_code => 'CITEM_EDIT' --|*|
11884: ,p_current_user_id => FND_GLOBAL.user_id --|*|
11885: ) = FND_API.g_false --|*|
11886: ) THEN --|*|
11887: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
11888: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 12204: ,p_current_user_id => FND_GLOBAL.user_id --|*|

12200: ,p_instance_pk1_value => px_content_item_id --|*|
12201: ,p_permission_code => perm_code(1) --|*|
12202: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
12203: ,p_container_pk1_value => directory_node --|*|
12204: ,p_current_user_id => FND_GLOBAL.user_id --|*|
12205: ) = FND_API.g_false --|*|
12206: ) THEN --|*|
12207: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
12208: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 12282: ,p_current_user_id => FND_GLOBAL.user_id --|*|

12278: ,p_instance_pk1_value => px_content_item_id --|*|
12279: ,p_permission_code => perm_code(i) --|*|
12280: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
12281: ,p_container_pk1_value => directory_node --|*|
12282: ,p_current_user_id => FND_GLOBAL.user_id --|*|
12283: ) = FND_API.g_false --|*|
12284: ) THEN --|*|
12285: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
12286: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 13362: ,p_current_user_id => FND_GLOBAL.user_id --|*|

13358: ,p_instance_pk1_value => l_content_item_id --|*|
13359: ,p_permission_code => 'CITEM_EDIT' --|*|
13360: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
13361: ,p_container_pk1_value => l_directory_node_id --|*|
13362: ,p_current_user_id => FND_GLOBAL.user_id --|*|
13363: ) = FND_API.g_false --|*|
13364: ) THEN --|*|
13365: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
13366: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 13617: ,p_current_user_id => FND_GLOBAL.user_id --|*|

13613: ,p_instance_pk1_value => l_citem_id --|*|
13614: ,p_permission_code => 'CITEM_EDIT' --|*|
13615: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
13616: ,p_container_pk1_value => l_directory_node_id --|*|
13617: ,p_current_user_id => FND_GLOBAL.user_id --|*|
13618: ) = FND_API.g_false --|*|
13619: ) THEN --|*|
13620: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|
13621: x_return_status := FND_API.G_RET_STS_ERROR; --|*|

Line 13917: ,p_current_user_id => FND_GLOBAL.user_id --|*|

13913: ,p_instance_pk1_value => content_item_id --|*|
13914: ,p_permission_code => 'CITEM_EDIT' --|*|
13915: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
13916: ,p_container_pk1_value => dir_id --|*|
13917: ,p_current_user_id => FND_GLOBAL.user_id --|*|
13918: ) = FND_API.g_false --|*|
13919: AND --|*|
13920: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED) --|*|
13921: OR --|*|

Line 13928: ,p_current_user_id => FND_GLOBAL.user_id --|*|

13924: ,p_instance_pk1_value => content_item_id --|*|
13925: ,p_permission_code => 'CITEM_APPROVE' --|*|
13926: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|
13927: ,p_container_pk1_value => dir_id --|*|
13928: ,p_current_user_id => FND_GLOBAL.user_id --|*|
13929: ) = FND_API.g_false --|*|
13930: ) --|*|
13931: ) THEN --|*|
13932: --DBMS_OUTPUT.put_line('EX - no permissions'); --|*|

Line 14175: AND NVL(locked_by_user_id,FND_GLOBAL.user_id) = FND_GLOBAL.user_id;

14171: CURSOR cur IS
14172: SELECT 'X'
14173: FROM ibc_content_items
14174: WHERE content_item_id = p_content_item_id
14175: AND NVL(locked_by_user_id,FND_GLOBAL.user_id) = FND_GLOBAL.user_id;
14176: BEGIN
14177: l_result := FALSE;
14178: OPEN cur;
14179: FETCH cur INTO l_dummy;