DBA Data[Home] [Help]

APPS.IBC_CITEM_WORKFLOW_PVT dependencies on FND_PROFILE

Line 435: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'Y'

431: ,p_permission_code => 'CITEM_APPROVE'
432: ,p_container_object_id => l_directory_object_type
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

Line 512: NVL(Fnd_Profile.Value_specific('IBC_CUSTOMIZED_APPROVAL_WF',-999,-999,-999), 'N') = 'N'

508: CLOSE c_submitter_name;
509:
510: l_already_approved := 'N';
511: IF l_wf_no_approver_defined = 'Y' AND
512: NVL(Fnd_Profile.Value_specific('IBC_CUSTOMIZED_APPROVAL_WF',-999,-999,-999), 'N') = 'N'
513: THEN
514: -- If no approver or submitter is approver
515: -- and approval workflow has not been customized
516: -- then change status directly.

Line 567: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'N' AND

563: FETCH c_owner INTO l_owner_resource_id, l_owner_resource_type, l_version_number, l_creator_id;
564:
565: -- Functionality for Approval in case IBC_USE_ACCESS_CONTROL is set to 'N'
566: IF l_wf_no_approver_defined = 'Y' AND
567: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'N' AND
568: l_owner_resource_id IS NOT NULL AND
569: ((l_owner_resource_type IS NULL AND l_owner_resource_id <> l_creator_id) OR
570: (l_owner_resource_type IS NOT NULL AND
571: IBC_UTILITIES_PVT.check_current_user(NULL,l_owner_resource_id,l_owner_resource_type, l_creator_id) = 'FALSE'))

Line 1961: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'Y'

1957: ,p_permission_code => 'CITEM_APPROVE_TRANSLATE'
1958: ,p_container_object_id => l_directory_object_type
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

Line 2007: NVL(Fnd_Profile.Value_specific('IBC_CUSTOMIZED_APPROVAL_WF',-999,-999,-999), 'N') = 'N'

2003: --======================================================================
2004: --======================================================================
2005:
2006: IF l_wf_no_approver_defined = 'Y' AND
2007: NVL(Fnd_Profile.Value_specific('IBC_CUSTOMIZED_APPROVAL_WF',-999,-999,-999), 'N') = 'N'
2008: THEN
2009: -- Set Status of Content Item Version
2010: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2011: p_citem_ver_id => p_citem_ver_id

Line 2133: AND NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'N'

2129: -- If the submitter is not the owner then send a notification to him by a
2130: -- creating an appripriate role.
2131:
2132: IF l_wf_no_approver_defined = 'Y'
2133: AND NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'N'
2134: AND l_owner_resource_id IS NOT NULL
2135: AND (( l_owner_resource_type IS NULL
2136: AND l_owner_resource_id <> l_creator_id)
2137: OR