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.

[Home] [Help]

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 11829: p_new_owner_resource_id := FND_GLOBAL.user_id;

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

Line 11863: locked_by := FND_GLOBAL.user_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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