APPS.CSI_CTR_READING_INTERFACE_PKG dependencies on CSI_CTR_READINGS_INTERFACE

Line 75: SELECT CSI_CTR_READINGS_INTERFACE_S.nextval

71: ,p_SOURCE_COUNTER_VALUE_ID NUMBER
72: ) IS
73:
74: CURSOR C1 IS
75: SELECT CSI_CTR_READINGS_INTERFACE_S.nextval
76: FROM dual;
77:
78: CURSOR C2 IS
79: SELECT CSI_COUNTER_READINGS_S.nextval

Line 94: INSERT INTO CSI_CTR_READINGS_INTERFACE(

90: FETCH c2 INTO px_COUNTER_VALUE_ID;
91: CLOSE c2;
92: END IF;
93:
94: INSERT INTO CSI_CTR_READINGS_INTERFACE(
95: COUNTER_INTERFACE_ID
96: ,PARALLEL_WORKER_ID
97: ,BATCH_NAME
98: ,SOURCE_TRANSACTION_DATE

Line 294: UPDATE CSI_CTR_READINGS_INTERFACE

290: ,p_NET_READING NUMBER
291: ,p_LIFE_TO_DATE_READING NUMBER
292: ,p_SOURCE_COUNTER_VALUE_ID NUMBER) IS
293: BEGIN
294: UPDATE CSI_CTR_READINGS_INTERFACE
295: SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297: ,SOURCE_TRANSACTION_DATE = decode(p_SOURCE_TRANSACTION_DATE, NULL, SOURCE_TRANSACTION_DATE, FND_API.G_MISS_DATE, NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)

Line 431: FROM CSI_CTR_READINGS_INTERFACE

427: ,p_SOURCE_COUNTER_VALUE_ID NUMBER) IS
428:
429: CURSOR C1 IS
430: SELECT *
431: FROM CSI_CTR_READINGS_INTERFACE
432: WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID
433: FOR UPDATE of COUNTER_INTERFACE_ID NOWAIT;
434: Recinfo C1%ROWTYPE;
435: BEGIN

Line 641: DELETE FROM CSI_CTR_READINGS_INTERFACE

637:
638:
639: PROCEDURE delete_row(p_COUNTER_INTERFACE_ID NUMBER) IS
640: BEGIN
641: DELETE FROM CSI_CTR_READINGS_INTERFACE
642: WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID;
643: IF (SQL%NOTFOUND) then
644: RAISE NO_DATA_FOUND;
645: END IF;