APPS.AMW_LOAD_CTRL_DATA dependencies on FND_PROFILE

Line 332: l_amw_delt_ctrl_intf := NVL(fnd_profile.VALUE ('AMW_DELT_CTRL_INTF'), 'N');

328:
329: --
330: -- get profile info for deleting records from interface table
331: --
332: l_amw_delt_ctrl_intf := NVL(fnd_profile.VALUE ('AMW_DELT_CTRL_INTF'), 'N');
333:
334: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
335: p_token_name => 'OBJ_TYPE',
336: p_token_value => AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','CTRL'));

Line 359: l_amw_control_name_prefix := fnd_profile.VALUE ('AMW_CONTROL_NAME_PREFIX');

355: lx_control_id := null;
356: v_control_db_approval_status := null;
357:
358: ---02.18.2005 npanandi: fix for bug 4141121
359: l_amw_control_name_prefix := fnd_profile.VALUE ('AMW_CONTROL_NAME_PREFIX');
360: ---02.18.2005 npanandi: ends fix for bug 4141121
361:
362: SELECT DECODE (ctrl_rec.control_name,NULL
363: ,l_amw_control_name_prefix||amw_controls_tl_s1.NEXTVAL

Line 1347: l_security_switch := NVL(fnd_profile.VALUE ('AMW_DATA_SECURITY_SWITCH'), 'N');

1343: open c_get_user_name;
1344: fetch c_get_user_name into l_user_name;
1345: close c_get_user_name;
1346:
1347: l_security_switch := NVL(fnd_profile.VALUE ('AMW_DATA_SECURITY_SWITCH'), 'N');
1348:
1349: if(l_security_switch = 'Y') then ---check for Upd prvlg only if Security mode is set on
1350: l_has_access := fnd_data_security.check_function(
1351: p_api_version => 1