APPS.AMW_CONTROLS_PAGE_PKG dependencies on FND_PROFILE

Line 269: from fnd_profile_options_vl

265:
266: if ((p_control_type = 'A' or p_control_type = 'C') AND (p_automation_type = '1')) then
267: select user_profile_option_name
268: into l_control_source_name
269: from fnd_profile_options_vl
270: --where to_char(profile_option_id) = p_control_source_id
271: where to_char(profile_option_id) = l_control_source_id
272: and application_id = p_application_id;
273: elsif ((p_control_type = 'A' or p_control_type = 'C') AND (p_automation_type = '2')) then

Line 926: L_PROFILE_OPTION_VALUE := NVL(fnd_profile.VALUE('AMW_DISABLE_WORKFLOW_APPROVAL'),'N');

922: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925:
926: L_PROFILE_OPTION_VALUE := NVL(fnd_profile.VALUE('AMW_DISABLE_WORKFLOW_APPROVAL'),'N');
927: --HARDCODING PURELY FOR TESTINGP PURPOSES!! REMOVE THIS ASAP!!!
928: --L_PROFILE_OPTION_VALUE := 'Y';
929:
930: IF(L_PROFILE_OPTION_VALUE = 'N')THEN

Line 997: L_UOM_CLASS := FND_PROFILE.VALUE('AMW_CTRL_UOM_CLASS');

993: L_UOM_CLASS AMW_LOOKUPS.LOOKUP_CODE%TYPE;
994: LX_UNIT_OF_MEASURE_TL AMW_LOOKUPS.MEANING%TYPE;
995: BEGIN
996: /*
997: L_UOM_CLASS := FND_PROFILE.VALUE('AMW_CTRL_UOM_CLASS');
998:
999: BEGIN
1000: SELECT UNIT_OF_MEASURE_TL
1001: INTO LX_UNIT_OF_MEASURE_TL