29: l_capacity_hrs NUMBER;
30: l_reduce_capacity_hrs NUMBER;
31:
32: BEGIN
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: -----------------
36: --Get calendar ID
37: -----------------
60: name = p_period_name;
61:
62: EXCEPTION
63: WHEN NO_DATA_FOUND THEN
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: x_err_code := SQLERRM;
66: RETURN;
67: END;
68:
86: ROWNUM = 1;
87:
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN
90: x_return_status := FND_API.G_RET_STS_ERROR;
91: x_err_code := SQLERRM;
92: RETURN;
93: END;
94:
99: ELSE
100: x_utl_percent := (x_utl_hours * 100)/x_utl_capacity;
101: END IF;
102:
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: x_err_code := SQLERRM;
109:
110: END get_utilization_dtls;
111: