APPS.CSI_COUNTER_READING_LOCK_PKG dependencies on CSI_COUNTER_READING_LOCKS

Line 37: INSERT INTO CSI_COUNTER_READING_LOCKS(

33: FETCH C1 INTO px_READING_LOCK_ID;
34: CLOSE C1;
35: END IF;
36:
37: INSERT INTO CSI_COUNTER_READING_LOCKS(
38: READING_LOCK_ID
39: ,COUNTER_ID
40: ,READING_LOCK_DATE
41: ,OBJECT_VERSION_NUMBER

Line 97: UPDATE CSI_COUNTER_READING_LOCKS

93: ,p_SOURCE_DIST_REF_ID1 NUMBER
94: ,p_SOURCE_DIST_REF_ID2 NUMBER
95: ) IS
96: BEGIN
97: UPDATE CSI_COUNTER_READING_LOCKS
98: SET
99: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
100: ,READING_LOCK_DATE = decode(p_READING_LOCK_DATE, NULL, READING_LOCK_DATE, FND_API.G_MISS_DATE, NULL, p_READING_LOCK_DATE)
101: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

Line 144: FROM CSI_COUNTER_READING_LOCKS

140: ) IS
141:
142: CURSOR C1 IS
143: SELECT *
144: FROM CSI_COUNTER_READING_LOCKS
145: WHERE READING_LOCK_ID = p_READING_LOCK_ID
146: FOR UPDATE of READING_LOCK_ID NOWAIT;
147: Recinfo C1%ROWTYPE;
148: BEGIN

Line 188: DELETE FROM CSI_COUNTER_READING_LOCKS

184: PROCEDURE Delete_Row(
185: p_READING_LOCK_ID NUMBER
186: ) IS
187: BEGIN
188: DELETE FROM CSI_COUNTER_READING_LOCKS
189: WHERE READING_LOCK_ID = p_READING_LOCK_ID;
190:
191: If (SQL%NOTFOUND) then
192: RAISE NO_DATA_FOUND;