APPS.CSI_CTR_USAGE_FORECAST_PKG dependencies on CSI_COUNTER_USAGE_FORECAST

Line 23: SELECT CSI_COUNTER_USAGE_FORECAST_S.nextval

19: ,p_LAST_UPDATE_LOGIN NUMBER
20: ) IS
21:
22: CURSOR C1 IS
23: SELECT CSI_COUNTER_USAGE_FORECAST_S.nextval
24: FROM dual;
25: BEGIN
26: IF (px_INSTANCE_FORECAST_ID IS NULL) OR (px_INSTANCE_FORECAST_ID = FND_API.G_MISS_NUM) THEN
27: OPEN C1;

Line 32: INSERT INTO CSI_COUNTER_USAGE_FORECAST(

28: FETCH C1 INTO px_INSTANCE_FORECAST_ID;
29: CLOSE C1;
30: END IF;
31:
32: INSERT INTO CSI_COUNTER_USAGE_FORECAST(
33: INSTANCE_FORECAST_ID
34: ,COUNTER_ID
35: ,USAGE_RATE
36: ,USE_PAST_READING

Line 77: UPDATE CSI_COUNTER_USAGE_FORECAST

73: ,p_CREATED_BY NUMBER
74: ,p_LAST_UPDATE_LOGIN NUMBER
75: ) IS
76: BEGIN
77: UPDATE CSI_COUNTER_USAGE_FORECAST
78: SET
79: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
80: ,USAGE_RATE = decode(p_USAGE_RATE, NULL, USAGE_RATE, FND_API.G_MISS_NUM, NULL, p_USAGE_RATE)
81: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)

Line 114: FROM CSI_COUNTER_USAGE_FORECAST

110: ) IS
111:
112: CURSOR C1 IS
113: SELECT *
114: FROM CSI_COUNTER_USAGE_FORECAST
115: WHERE INSTANCE_FORECAST_ID = p_INSTANCE_FORECAST_ID
116: FOR UPDATE of INSTANCE_FORECAST_ID NOWAIT;
117: Recinfo C1%ROWTYPE;
118: BEGIN

Line 153: DELETE FROM CSI_COUNTER_USAGE_FORECAST

149: PROCEDURE Delete_Row(
150: p_INSTANCE_FORECAST_ID NUMBER
151: ) IS
152: BEGIN
153: DELETE FROM CSI_COUNTER_USAGE_FORECAST
154: WHERE INSTANCE_FORECAST_ID = p_INSTANCE_FORECAST_ID;
155: IF (SQL%NOTFOUND) then
156: RAISE NO_DATA_FOUND;
157: END IF;