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 IBC_DATA_SECURITY_PVT

Line 3861: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

3857: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
3858: FND_MSG_PUB.ADD; --|*|
3859: RAISE FND_API.G_EXC_ERROR; --|*|
3860: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
3861: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
3862: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 3862: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

3858: FND_MSG_PUB.ADD; --|*|
3859: RAISE FND_API.G_EXC_ERROR; --|*|
3860: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
3861: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
3862: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 3865: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

3861: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
3862: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 4130: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

4126: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
4127: FND_MSG_PUB.ADD; --|*|
4128: RAISE FND_API.G_EXC_ERROR; --|*|
4129: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
4130: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
4131: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 4131: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

4127: FND_MSG_PUB.ADD; --|*|
4128: RAISE FND_API.G_EXC_ERROR; --|*|
4129: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
4130: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
4131: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 4134: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

4130: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
4131: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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

Line 4141: IBC_DATA_SECURITY_PVT.has_permission( --|*|

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
4141: IBC_DATA_SECURITY_PVT.has_permission( --|*|
4142: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 4142: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

4138: AND
4139: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED)
4140: OR
4141: IBC_DATA_SECURITY_PVT.has_permission( --|*|
4142: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 4145: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

4141: IBC_DATA_SECURITY_PVT.has_permission( --|*|
4142: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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: )

Line 4590: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

4586: -- Copy the Item.
4587: --
4588:
4589: -- ***************PERMISSION CHECK*********************************************************************
4590: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
4591: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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) --|*|

Line 4591: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

4587: --
4588:
4589: -- ***************PERMISSION CHECK*********************************************************************
4590: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
4591: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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' --|*|

Line 4593: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

4589: -- ***************PERMISSION CHECK*********************************************************************
4590: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
4591: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 5263: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

5259: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
5260: FND_MSG_PUB.ADD; --|*|
5261: RAISE FND_API.G_EXC_ERROR; --|*|
5262: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
5263: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
5264: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 5264: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

5260: FND_MSG_PUB.ADD; --|*|
5261: RAISE FND_API.G_EXC_ERROR; --|*|
5262: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
5263: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
5264: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 5267: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

5263: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
5264: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 5557: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

5553: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
5554: FND_MSG_PUB.ADD; --|*|
5555: RAISE FND_API.G_EXC_ERROR; --|*|
5556: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
5557: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
5558: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 5558: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

5554: FND_MSG_PUB.ADD; --|*|
5555: RAISE FND_API.G_EXC_ERROR; --|*|
5556: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
5557: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
5558: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 5561: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

5557: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
5558: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 6345: IBC_DATA_SECURITY_PVT.has_permission( --|*|

6341: AND
6342: LANGUAGE = lang;
6343:
6344: IF( NVL(p_skip_security, FND_API.g_false) = FND_API.g_false AND
6345: IBC_DATA_SECURITY_PVT.has_permission( --|*|
6346: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 6346: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

6342: LANGUAGE = lang;
6343:
6344: IF( NVL(p_skip_security, FND_API.g_false) = FND_API.g_false AND
6345: IBC_DATA_SECURITY_PVT.has_permission( --|*|
6346: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 6349: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

6345: IBC_DATA_SECURITY_PVT.has_permission( --|*|
6346: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 6355: IBC_DATA_SECURITY_PVT.has_permission(

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(
6356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM')
6357: ,p_instance_pk1_value => x_content_item_id
6358: ,p_permission_code => 'CITEM_EDIT'
6359: ,p_container_object_id =>

Line 6356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM')

6352: ) = FND_API.g_false --|*|
6353: ) THEN IF --|*|
6354:
6355: IBC_DATA_SECURITY_PVT.has_permission(
6356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM')
6357: ,p_instance_pk1_value => x_content_item_id
6358: ,p_permission_code => 'CITEM_EDIT'
6359: ,p_container_object_id =>
6360: IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE'),

Line 6360: IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE'),

6356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM')
6357: ,p_instance_pk1_value => x_content_item_id
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'); --|*|

Line 8121: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

8117: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
8118: FND_MSG_PUB.ADD; --|*|
8119: RAISE FND_API.G_EXC_ERROR; --|*|
8120: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
8121: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8122: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 8122: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

8118: FND_MSG_PUB.ADD; --|*|
8119: RAISE FND_API.G_EXC_ERROR; --|*|
8120: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
8121: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8122: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 8125: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

8121: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8122: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 8475: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

8471: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
8472: FND_MSG_PUB.ADD; --|*|
8473: RAISE FND_API.G_EXC_ERROR; --|*|
8474: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
8475: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8476: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 8476: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

8472: FND_MSG_PUB.ADD; --|*|
8473: RAISE FND_API.G_EXC_ERROR; --|*|
8474: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
8475: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8476: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 8479: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

8475: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8476: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 8760: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

8756: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
8757: FND_MSG_PUB.ADD; --|*|
8758: RAISE FND_API.G_EXC_ERROR; --|*|
8759: ELSIF(isItemAdmin(px_content_item_id) = FND_API.g_false) THEN --|*|
8760: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8761: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 8761: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

8757: FND_MSG_PUB.ADD; --|*|
8758: RAISE FND_API.G_EXC_ERROR; --|*|
8759: ELSIF(isItemAdmin(px_content_item_id) = FND_API.g_false) THEN --|*|
8760: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8761: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 8764: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

8760: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8761: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 8783: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

8779: END IF;
8780: ELSE
8781: -- CREATING BRAND SPANKING NEW ITEM!!!!!!!!
8782: -- ***************PERMISSION CHECK*********************************************************************
8783: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8784: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 8784: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

8780: ELSE
8781: -- CREATING BRAND SPANKING NEW ITEM!!!!!!!!
8782: -- ***************PERMISSION CHECK*********************************************************************
8783: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8784: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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' --|*|

Line 8786: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

8782: -- ***************PERMISSION CHECK*********************************************************************
8783: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
8784: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 9092: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

9088: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
9089: FND_MSG_PUB.ADD; --|*|
9090: RAISE FND_API.G_EXC_ERROR; --|*|
9091: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
9092: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9093: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 9093: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

9089: FND_MSG_PUB.ADD; --|*|
9090: RAISE FND_API.G_EXC_ERROR; --|*|
9091: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
9092: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9093: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 9096: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

9092: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9093: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 9510: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

9506: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
9507: FND_MSG_PUB.ADD; --|*|
9508: RAISE FND_API.G_EXC_ERROR; --|*|
9509: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
9510: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9511: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 9511: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

9507: FND_MSG_PUB.ADD; --|*|
9508: RAISE FND_API.G_EXC_ERROR; --|*|
9509: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
9510: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9511: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 9514: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

9510: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9511: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 9959: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

9955: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
9956: FND_MSG_PUB.ADD; --|*|
9957: RAISE FND_API.G_EXC_ERROR; --|*|
9958: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
9959: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9960: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 9960: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

9956: FND_MSG_PUB.ADD; --|*|
9957: RAISE FND_API.G_EXC_ERROR; --|*|
9958: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
9959: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9960: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 9963: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

9959: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
9960: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 10311: IF (IBC_DATA_SECURITY_PVT.has_permission( --|*|

10307: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
10308: FND_MSG_PUB.ADD; --|*|
10309: RAISE FND_API.G_EXC_ERROR; --|*|
10310: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
10311: IF (IBC_DATA_SECURITY_PVT.has_permission( --|*|
10312: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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') --|*|

Line 10312: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

10308: FND_MSG_PUB.ADD; --|*|
10309: RAISE FND_API.G_EXC_ERROR; --|*|
10310: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
10311: IF (IBC_DATA_SECURITY_PVT.has_permission( --|*|
10312: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 10315: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE') --|*|

10311: IF (IBC_DATA_SECURITY_PVT.has_permission( --|*|
10312: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 10592: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

10588: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
10589: FND_MSG_PUB.ADD; --|*|
10590: RAISE FND_API.G_EXC_ERROR; --|*|
10591: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
10592: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
10593: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 10593: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

10589: FND_MSG_PUB.ADD; --|*|
10590: RAISE FND_API.G_EXC_ERROR; --|*|
10591: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
10592: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
10593: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 10596: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

10592: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
10593: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 10855: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

10851: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
10852: FND_MSG_PUB.ADD; --|*|
10853: RAISE FND_API.G_EXC_ERROR; --|*|
10854: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
10855: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
10856: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 10856: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

10852: FND_MSG_PUB.ADD; --|*|
10853: RAISE FND_API.G_EXC_ERROR; --|*|
10854: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
10855: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
10856: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 10859: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

10855: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
10856: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 11132: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

11128: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
11129: FND_MSG_PUB.ADD; --|*|
11130: RAISE FND_API.G_EXC_ERROR; --|*|
11131: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
11132: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11133: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 11133: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

11129: FND_MSG_PUB.ADD; --|*|
11130: RAISE FND_API.G_EXC_ERROR; --|*|
11131: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
11132: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11133: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 11136: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

11132: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11133: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 11385: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

11381: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
11382: FND_MSG_PUB.ADD; --|*|
11383: RAISE FND_API.G_EXC_ERROR; --|*|
11384: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
11385: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11386: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 11386: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

11382: FND_MSG_PUB.ADD; --|*|
11383: RAISE FND_API.G_EXC_ERROR; --|*|
11384: ELSIF(isItemAdmin(p_content_item_id) = FND_API.g_false) THEN --|*|
11385: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11386: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 11389: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

11385: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11386: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 11877: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

11873:
11874: -- INSERT -----------------------------------------------------
11875: IF (do_item = G_COMMAND_CREATE) THEN
11876: -- ***************PERMISSION CHECK*********************************************************************
11877: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11878: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 11878: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

11874: -- INSERT -----------------------------------------------------
11875: IF (do_item = G_COMMAND_CREATE) THEN
11876: -- ***************PERMISSION CHECK*********************************************************************
11877: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11878: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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' --|*|

Line 11880: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

11876: -- ***************PERMISSION CHECK*********************************************************************
11877: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
11878: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 12197: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

12193:
12194:
12195: -- ***************PERMISSION CHECK*********************************************************************
12196: IF(isItemAdmin(px_content_item_id) = FND_API.g_false) THEN --|*|
12197: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
12198: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 12198: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

12194:
12195: -- ***************PERMISSION CHECK*********************************************************************
12196: IF(isItemAdmin(px_content_item_id) = FND_API.g_false) THEN --|*|
12197: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
12198: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 12201: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

12197: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
12198: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 12275: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

12271: FOR i IN perm_code.FIRST..perm_code.LAST
12272: LOOP
12273: -- ***************PERMISSION CHECK*********************************************************************
12274: -- IF(isItemAdmin(px_content_item_id) = FND_API.g_false) THEN --|*|
12275: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
12276: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 12276: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

12272: LOOP
12273: -- ***************PERMISSION CHECK*********************************************************************
12274: -- IF(isItemAdmin(px_content_item_id) = FND_API.g_false) THEN --|*|
12275: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
12276: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 12279: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

12275: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
12276: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13355: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

13351: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
13352: FND_MSG_PUB.ADD; --|*|
13353: RAISE FND_API.G_EXC_ERROR; --|*|
13354: ELSIF(isItemAdmin(l_content_item_id) = FND_API.g_false) THEN --|*|
13355: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 13356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

13352: FND_MSG_PUB.ADD; --|*|
13353: RAISE FND_API.G_EXC_ERROR; --|*|
13354: ELSIF(isItemAdmin(l_content_item_id) = FND_API.g_false) THEN --|*|
13355: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13359: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

13355: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13356: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13610: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

13606:
13607: --sanshuma : 01/10/2004 : Changed p_permission_code from CITEM_DELETE to CITEM_EDIT
13608: -- ***************PERMISSION CHECK*********************************************************************
13609: IF(isItemAdmin(l_citem_id) = FND_API.g_false) THEN --|*|
13610: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13611: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 13611: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

13607: --sanshuma : 01/10/2004 : Changed p_permission_code from CITEM_DELETE to CITEM_EDIT
13608: -- ***************PERMISSION CHECK*********************************************************************
13609: IF(isItemAdmin(l_citem_id) = FND_API.g_false) THEN --|*|
13610: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13611: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13614: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

13610: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13611: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13910: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|

13906: FND_MESSAGE.Set_Name('IBC', 'INVALID_LOCK_PERMISSION'); --|*|
13907: FND_MSG_PUB.ADD; --|*|
13908: RAISE FND_API.G_EXC_ERROR; --|*|
13909: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
13910: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13911: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 13911: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

13907: FND_MSG_PUB.ADD; --|*|
13908: RAISE FND_API.G_EXC_ERROR; --|*|
13909: ELSIF(isItemAdmin(content_item_id) = FND_API.g_false) THEN --|*|
13910: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13911: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13914: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

13910: IF( IBC_DATA_SECURITY_PVT.has_permission( --|*|
13911: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13921: IBC_DATA_SECURITY_PVT.has_permission( --|*|

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 --|*|
13921: IBC_DATA_SECURITY_PVT.has_permission( --|*|
13922: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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')--|*|

Line 13922: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|

13918: AND --|*|
13919: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED) --|*|
13920: OR --|*|
13921: IBC_DATA_SECURITY_PVT.has_permission( --|*|
13922: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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 --|*|

Line 13925: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')--|*|

13921: IBC_DATA_SECURITY_PVT.has_permission( --|*|
13922: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
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: ) --|*|