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_WORKFLOW_PVT dependencies on IBC_DATA_SECURITY_PVT

Line 314: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');

310:
311: l_directory_node_id NUMBER;
312: l_directory_path VARCHAR2(4000);
313:
314: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
315: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
316:
317: CURSOR c_directory(p_content_item_id NUMBER) IS
318: SELECT citem.directory_node_id, dirnode.directory_path

Line 315: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');

311: l_directory_node_id NUMBER;
312: l_directory_path VARCHAR2(4000);
313:
314: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
315: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
316:
317: CURSOR c_directory(p_content_item_id NUMBER) IS
318: SELECT citem.directory_node_id, dirnode.directory_path
319: FROM ibc_content_items citem,

Line 428: IF IBC_DATA_SECURITY_PVT.has_permission(

424: OPEN c_directory(l_content_item_id);
425: FETCH c_directory INTO l_directory_node_id, l_directory_path;
426: CLOSE c_directory;
427:
428: IF IBC_DATA_SECURITY_PVT.has_permission(
429: p_instance_object_id => l_citem_object_type
430: ,p_instance_pk1_value => l_content_item_id
431: ,p_permission_code => 'CITEM_APPROVE'
432: ,p_container_object_id => l_directory_object_type

Line 437: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

433: ,p_container_pk1_value => l_directory_node_id) = FND_API.g_false
434: AND
435: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'Y'
436: THEN
437: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
438: p_instance_object_id => l_citem_object_type
439: ,p_instance_pk1_value => l_content_item_id
440: ,p_permission_code => 'CITEM_APPROVE'
441: ,p_container_object_id => l_directory_object_type

Line 1094: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

1090: OPEN c_directory(l_content_item_id);
1091: FETCH c_directory INTO l_directory_node_id, l_directory_path;
1092: CLOSE c_directory;
1093:
1094: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
1095: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM')
1096: ,p_instance_pk1_value => l_content_item_id
1097: ,p_permission_code => 'CITEM_TRANSLATE'
1098: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')

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

1091: FETCH c_directory INTO l_directory_node_id, l_directory_path;
1092: CLOSE c_directory;
1093:
1094: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
1095: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM')
1096: ,p_instance_pk1_value => l_content_item_id
1097: ,p_permission_code => 'CITEM_TRANSLATE'
1098: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')
1099: ,p_container_pk1_value => l_directory_node_id

Line 1098: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')

1094: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
1095: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM')
1096: ,p_instance_pk1_value => l_content_item_id
1097: ,p_permission_code => 'CITEM_TRANSLATE'
1098: ,p_container_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE')
1099: ,p_container_pk1_value => l_directory_node_id
1100: ,x_usernames => l_user_list
1101: ,x_return_status => l_return_status
1102: ,x_msg_count => l_msg_count

Line 1858: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');

1854:
1855: l_directory_node_id NUMBER;
1856: l_directory_path VARCHAR2(4000);
1857:
1858: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
1859: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
1860:
1861: CURSOR c_directory(p_content_item_id NUMBER) IS
1862: SELECT citem.directory_node_id, dirnode.directory_path

Line 1859: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');

1855: l_directory_node_id NUMBER;
1856: l_directory_path VARCHAR2(4000);
1857:
1858: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
1859: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
1860:
1861: CURSOR c_directory(p_content_item_id NUMBER) IS
1862: SELECT citem.directory_node_id, dirnode.directory_path
1863: FROM ibc_content_items citem,

Line 1954: IF IBC_DATA_SECURITY_PVT.has_permission(

1950: FETCH c_directory INTO l_directory_node_id, l_directory_path;
1951: CLOSE c_directory;
1952:
1953:
1954: IF IBC_DATA_SECURITY_PVT.has_permission(
1955: p_instance_object_id => l_citem_object_type
1956: ,p_instance_pk1_value => l_content_item_id
1957: ,p_permission_code => 'CITEM_APPROVE_TRANSLATE'
1958: ,p_container_object_id => l_directory_object_type

Line 1963: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

1959: ,p_container_pk1_value => l_directory_node_id) = FND_API.g_false
1960: AND
1961: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'Y'
1962: THEN
1963: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
1964: p_instance_object_id => l_citem_object_type
1965: ,p_instance_pk1_value => l_content_item_id
1966: ,p_permission_code => 'CITEM_APPROVE_TRANSLATE'
1967: ,p_container_object_id => l_directory_object_type

Line 2701: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');

2697: GROUP BY IAS.ITEM_KEY;
2698:
2699: l_item_key VARCHAR2(80);
2700: l_item_approve_users VARCHAR2(32767);
2701: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
2702: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
2703: l_return_status VARCHAR2(30);
2704: l_msg_count NUMBER;
2705: l_msg_data VARCHAR2(2000);

Line 2702: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');

2698:
2699: l_item_key VARCHAR2(80);
2700: l_item_approve_users VARCHAR2(32767);
2701: l_citem_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
2702: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
2703: l_return_status VARCHAR2(30);
2704: l_msg_count NUMBER;
2705: l_msg_data VARCHAR2(2000);
2706:

Line 2710: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

2706:
2707: BEGIN
2708: l_result := TRUE;
2709:
2710: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
2711: p_instance_object_id => l_citem_object_type
2712: ,p_instance_pk1_value => NULL
2713: ,p_permission_code => 'CITEM_APPROVE'
2714: ,p_container_object_id => l_directory_object_type

Line 2845: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CATEGORY_NODE');

2841:
2842: -- Get the users list
2843: IF p_object_name = 'IBC_CATEGORY_NODE' THEN
2844: l_permission_code := 'PD_VIEW';
2845: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CATEGORY_NODE');
2846: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CATEGORY_NODE');
2847:
2848: ELSE
2849: l_permission_code := 'CITEM_READ';

Line 2846: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CATEGORY_NODE');

2842: -- Get the users list
2843: IF p_object_name = 'IBC_CATEGORY_NODE' THEN
2844: l_permission_code := 'PD_VIEW';
2845: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CATEGORY_NODE');
2846: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CATEGORY_NODE');
2847:
2848: ELSE
2849: l_permission_code := 'CITEM_READ';
2850: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');

Line 2850: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');

2846: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CATEGORY_NODE');
2847:
2848: ELSE
2849: l_permission_code := 'CITEM_READ';
2850: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
2851: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
2852: END IF;
2853:
2854: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

Line 2851: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');

2847:
2848: ELSE
2849: l_permission_code := 'CITEM_READ';
2850: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
2851: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
2852: END IF;
2853:
2854: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
2855: p_instance_object_id => l_citem_object_type

Line 2854: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

2850: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
2851: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
2852: END IF;
2853:
2854: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
2855: p_instance_object_id => l_citem_object_type
2856: ,p_instance_pk1_value => p_content_item_id
2857: ,p_permission_code => l_permission_code
2858: ,p_container_object_id => l_directory_object_type

Line 3034: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');

3030: NULL;
3031: END IF;
3032:
3033: l_permission_code := 'CITEM_TRANSLATE';
3034: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
3035: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
3036: l_object := 'Content Item';
3037:
3038: -- Get the users list with CITEM_TRANSLATE permission

Line 3035: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');

3031: END IF;
3032:
3033: l_permission_code := 'CITEM_TRANSLATE';
3034: l_citem_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM');
3035: l_directory_object_type := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
3036: l_object := 'Content Item';
3037:
3038: -- Get the users list with CITEM_TRANSLATE permission
3039:

Line 3040: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

3036: l_object := 'Content Item';
3037:
3038: -- Get the users list with CITEM_TRANSLATE permission
3039:
3040: IBC_DATA_SECURITY_PVT.get_grantee_usernames(
3041: p_instance_object_id => l_citem_object_type
3042: ,p_instance_pk1_value => p_content_item_id
3043: ,p_permission_code => l_permission_code
3044: ,p_container_object_id => l_directory_object_type