DBA Data[Home] [Help]

APPS.AHL_FLEET_UTIL_HISTORY_PVT dependencies on FND_PROFILE

Line 22: G_APPLN_USAGE VARCHAR2(30) :=ltrim(rtrim(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));

18: g_err_msg VARCHAR2(4000);
19: g_err_code NUMBER;
20: -- added to debug concurrent worker pgms failure.
21: G_DEBUG_LINE_NUM NUMBER;
22: G_APPLN_USAGE VARCHAR2(30) :=ltrim(rtrim(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
23: G_PKG_NAME VARCHAR2(30) :='AHL_FLEET_UTIL_HISTORY_PVT';
24:
25:
26: -------------------------------------------------------------------------------

Line 1068: l_date_uom := FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_UOM');

1064: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Get_Forecasting_Window_Date');
1065: END IF;
1066:
1067: BEGIN
1068: l_date_uom := FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_UOM');
1069: l_value := to_number(FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_VALUE'));
1070: IF (l_date_uom IS NULL) THEN
1071: l_last_day_of_window := SYSDATE;
1072: ELSIF (l_value <= 0 OR l_value IS NULL) THEN

Line 1069: l_value := to_number(FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_VALUE'));

1065: END IF;
1066:
1067: BEGIN
1068: l_date_uom := FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_UOM');
1069: l_value := to_number(FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_VALUE'));
1070: IF (l_date_uom IS NULL) THEN
1071: l_last_day_of_window := SYSDATE;
1072: ELSIF (l_value <= 0 OR l_value IS NULL) THEN
1073: l_last_day_of_window := SYSDATE;