APPS.CSI_CTR_PROPERTY_READING_PKG dependencies on CSI_CTR_PROPERTY_READINGS

Line 39: SELECT CSI_CTR_PROPERTY_READINGS_S.nextval

35: ,p_MIGRATED_FLAG VARCHAR2
36: ) IS
37:
38: CURSOR C1 IS
39: SELECT CSI_CTR_PROPERTY_READINGS_S.nextval
40: FROM dual;
41: BEGIN
42: IF (px_COUNTER_PROP_VALUE_ID IS NULL) OR (px_COUNTER_PROP_VALUE_ID = FND_API.G_MISS_NUM) THEN
43: OPEN C1;

Line 48: INSERT INTO CSI_CTR_PROPERTY_READINGS(

44: FETCH C1 INTO px_COUNTER_PROP_VALUE_ID;
45: CLOSE C1;
46: END IF;
47:
48: INSERT INTO CSI_CTR_PROPERTY_READINGS(
49: COUNTER_PROP_VALUE_ID
50: ,COUNTER_VALUE_ID
51: ,COUNTER_PROPERTY_ID
52: ,PROPERTY_VALUE

Line 142: UPDATE CSI_CTR_PROPERTY_READINGS

138: ,p_ATTRIBUTE_CATEGORY VARCHAR2
139: ,p_MIGRATED_FLAG VARCHAR2
140: ) IS
141: BEGIN
142: UPDATE CSI_CTR_PROPERTY_READINGS
143: SET
144: COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
145: ,COUNTER_PROPERTY_ID = decode(p_COUNTER_PROPERTY_ID, NULL, COUNTER_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_PROPERTY_ID)
146: ,PROPERTY_VALUE = decode(p_PROPERTY_VALUE, NULL, PROPERTY_VALUE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_VALUE)

Line 211: FROM CSI_CTR_PROPERTY_READINGS

207: ) IS
208:
209: CURSOR C1 IS
210: SELECT *
211: FROM CSI_CTR_PROPERTY_READINGS
212: WHERE COUNTER_PROP_VALUE_ID = p_COUNTER_PROP_VALUE_ID
213: FOR UPDATE of COUNTER_PROP_VALUE_ID NOWAIT;
214: Recinfo C1%ROWTYPE;
215: BEGIN

Line 267: DELETE FROM CSI_CTR_PROPERTY_READINGS

263: PROCEDURE Delete_Row(
264: p_COUNTER_PROP_VALUE_ID NUMBER
265: ) IS
266: BEGIN
267: DELETE FROM CSI_CTR_PROPERTY_READINGS
268: WHERE COUNTER_PROP_VALUE_ID = p_COUNTER_PROP_VALUE_ID;
269:
270: IF (SQL%NOTFOUND) then
271: RAISE NO_DATA_FOUND;