APPS.AMW_WF_HIERARCHY_PKG dependencies on FND_PROFILE

Line 119: select fnd_profile.value('AMW_SET_STD_PROCESS') into l_std_process_flag from dual;

115: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: select fnd_profile.value('AMW_SET_STD_PROCESS') into l_std_process_flag from dual;
120:
121: -- 8.1.7 compatibility issue
122: /*
123: open c_amwp_name;

Line 2540: if (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') = 'N') OR (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') is null) then

2536: function check_org_user_permission(org_id in number) return number is
2537: userId number := FND_GLOBAL.User_Id;
2538: l_dummy number;
2539: begin
2540: if (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') = 'N') OR (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') is null) then
2541: return 1;
2542: end if;
2543:
2544: if fnd_profile.value('AMW_ACCESS_ALL_ORGS') = 'Y' then

Line 2544: if fnd_profile.value('AMW_ACCESS_ALL_ORGS') = 'Y' then

2540: if (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') = 'N') OR (fnd_profile.value('AMW_ORG_SECURITY_SWITCH') is null) then
2541: return 1;
2542: end if;
2543:
2544: if fnd_profile.value('AMW_ACCESS_ALL_ORGS') = 'Y' then
2545: return 1;
2546: else
2547: l_dummy := isProcessOwner(userId, org_id) + hasOrgAccess(userId, org_id);
2548: if (l_dummy = 1) OR (l_dummy = 2) then

Line 2658: hier_name := fnd_profile.value('AMW_ORG_SECURITY_HIERARCHY');

2654: and hoi.org_information2 = l_emp;
2655:
2656: begin
2657:
2658: hier_name := fnd_profile.value('AMW_ORG_SECURITY_HIERARCHY');
2659:
2660: if hier_name is null then return 0; end if;
2661:
2662: open c_orgs(p_emp_id);