APPS.AHL_AVF_OPER_VSTS_PVT dependencies on FND_PROFILE

Line 1725: l_profile_varchar := FND_PROFILE.VALUE('AHL_AVF_VST_UPD_FLT_TIME');

1721: THEN
1722: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1723: END IF;
1724:
1725: l_profile_varchar := FND_PROFILE.VALUE('AHL_AVF_VST_UPD_FLT_TIME');
1726: l_profile_varchar2 := FND_PROFILE.VALUE('AHL_AVF_FLT_VST_UPD_WINDOW');
1727:
1728: -- Loop through all the flight schedule records whose status is Updated.
1729: FOR flight_schedule_rec IN get_flight_schedule_rows('U') LOOP

Line 1726: l_profile_varchar2 := FND_PROFILE.VALUE('AHL_AVF_FLT_VST_UPD_WINDOW');

1722: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1723: END IF;
1724:
1725: l_profile_varchar := FND_PROFILE.VALUE('AHL_AVF_VST_UPD_FLT_TIME');
1726: l_profile_varchar2 := FND_PROFILE.VALUE('AHL_AVF_FLT_VST_UPD_WINDOW');
1727:
1728: -- Loop through all the flight schedule records whose status is Updated.
1729: FOR flight_schedule_rec IN get_flight_schedule_rows('U') LOOP
1730: -- store all the flight params in the record

Line 3997: END If; -- IF((l_difference_arrival_time > nvl(FND_PROFILE

3993: ELSE
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3995: END IF;
3996: END IF; -- Return Status is not Success
3997: END If; -- IF((l_difference_arrival_time > nvl(FND_PROFILE
3998: ELSE -- there is no visit associated to the arrival org of current FS
3999: -- Look for creating an arrival visit
4000: OPEN get_oper_param_rows1(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.arrival_org_id,
4001: flight_schedule_rec.arrival_dept_id, flight_schedule_rec.flight_category_code, l_count_org, l_count_dep, l_count_cat,