APPS.CSI_CTR_ESTIMATED_READINGS_PKG dependencies on CSI_CTR_ESTIMATED_READINGS

Line 1: PACKAGE BODY CSI_CTR_ESTIMATED_READINGS_PKG as

1: PACKAGE BODY CSI_CTR_ESTIMATED_READINGS_PKG as
2: /* $Header: csitcerb.pls 120.0 2005/06/09 21:36:10 epajaril noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_ESTIMATED_READINGS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcerb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_ESTIMATED_READINGS_PKG';

1: PACKAGE BODY CSI_CTR_ESTIMATED_READINGS_PKG as
2: /* $Header: csitcerb.pls 120.0 2005/06/09 21:36:10 epajaril noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_ESTIMATED_READINGS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcerb.pls';
6:
7: PROCEDURE Insert_Row(
8: px_ESTIMATED_READING_ID IN OUT NOCOPY NUMBER

Line 44: SELECT CSI_CTR_ESTIMATED_READINGS_S.nextval

40: ,p_MIGRATED_FLAG VARCHAR2
41: ) IS
42:
43: CURSOR C1 IS
44: SELECT CSI_CTR_ESTIMATED_READINGS_S.nextval
45: FROM dual;
46: BEGIN
47: IF (px_ESTIMATED_READING_ID IS NULL) OR (px_ESTIMATED_READING_ID = FND_API.G_MISS_NUM) then
48: OPEN C1;

Line 53: INSERT INTO CSI_CTR_ESTIMATED_READINGS(

49: FETCH C1 INTO px_ESTIMATED_READING_ID;
50: CLOSE C1;
51: END IF;
52:
53: INSERT INTO CSI_CTR_ESTIMATED_READINGS(
54: ESTIMATED_READING_ID
55: ,COUNTER_ID
56: ,ESTIMATION_ID
57: ,VALUE_TIMESTAMP

Line 159: UPDATE CSI_CTR_ESTIMATED_READINGS

155: ,p_CREATED_BY NUMBER
156: ,p_OBJECT_VERSION_NUMBER NUMBER
157: ,p_MIGRATED_FLAG VARCHAR2) IS
158: BEGIN
159: UPDATE CSI_CTR_ESTIMATED_READINGS
160: SET COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
161: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
162: ,VALUE_TIMESTAMP = decode(p_VALUE_TIMESTAMP, NULL, VALUE_TIMESTAMP, FND_API.G_MISS_DATE, NULL, p_VALUE_TIMESTAMP)
163: ,ESTIMATED_METER_READING = decode(p_ESTIMATED_METER_READING, NULL, ESTIMATED_METER_READING, FND_API.G_MISS_NUM, NULL, p_ESTIMATED_METER_READING)

Line 235: FROM CSI_CTR_ESTIMATED_READINGS

231: ,p_MIGRATED_FLAG VARCHAR2) IS
232:
233: CURSOR C1 IS
234: SELECT *
235: FROM CSI_CTR_ESTIMATED_READINGS
236: WHERE ESTIMATED_READING_ID = p_ESTIMATED_READING_ID
237: FOR UPDATE of ESTIMATED_READING_ID NOWAIT;
238: Recinfo C1%ROWTYPE;
239: BEGIN

Line 352: DELETE FROM CSI_CTR_ESTIMATED_READINGS

348: END lock_row;
349:
350: PROCEDURE delete_row(p_ESTIMATED_READING_ID NUMBER) IS
351: BEGIN
352: DELETE FROM CSI_CTR_ESTIMATED_READINGS
353: WHERE ESTIMATED_READING_ID = p_ESTIMATED_READING_ID;
354: IF (SQL%NOTFOUND) then
355: RAISE NO_DATA_FOUND;
356: END IF;

Line 361: End CSI_CTR_ESTIMATED_READINGS_PKG;

357:
358: END delete_row;
359:
360:
361: End CSI_CTR_ESTIMATED_READINGS_PKG;