APPS.CSI_CTR_READ_PROP_INTFACE_PKG dependencies on CSI_CTR_READ_PROP_INTERFACE

Line 51: INSERT INTO CSI_CTR_READ_PROP_INTERFACE(

47: FETCH C1 INTO px_COUNTER_READ_PROP_INT_ID;
48: CLOSE C1;
49: END IF;
50:
51: INSERT INTO CSI_CTR_READ_PROP_INTERFACE(
52: COUNTER_READ_PROP_INT_ID
53: ,COUNTER_INTERFACE_ID
54: ,PARALLEL_WORKER_ID
55: ,ERROR_TEXT

Line 155: UPDATE CSI_CTR_READ_PROP_INTERFACE

151: ,p_ATTRIBUTE15 VARCHAR2
152: ,p_ATTRIBUTE_CATEGORY VARCHAR2
153: ,p_MIGRATED_FLAG VARCHAR2) IS
154: BEGIN
155: UPDATE CSI_CTR_READ_PROP_INTERFACE
156: SET COUNTER_INTERFACE_ID = decode(p_COUNTER_INTERFACE_ID, NULL, COUNTER_INTERFACE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_INTERFACE_ID)
157: ,PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
158: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
159: ,PROPERTY_VALUE = decode(p_PROPERTY_VALUE, NULL, PROPERTY_VALUE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_VALUE)

Line 227: FROM CSI_CTR_READ_PROP_INTERFACE

223: ,p_MIGRATED_FLAG VARCHAR2) IS
224:
225: CURSOR C1 IS
226: SELECT *
227: FROM CSI_CTR_READ_PROP_INTERFACE
228: WHERE COUNTER_READ_PROP_INT_ID = p_COUNTER_READ_PROP_INT_ID
229: FOR UPDATE of COUNTER_INTERFACE_ID NOWAIT;
230: Recinfo C1%ROWTYPE;
231: BEGIN

Line 344: DELETE FROM CSI_CTR_READ_PROP_INTERFACE

340:
341:
342: PROCEDURE delete_row(p_COUNTER_READ_PROP_INT_ID NUMBER) IS
343: BEGIN
344: DELETE FROM CSI_CTR_READ_PROP_INTERFACE
345: WHERE COUNTER_READ_PROP_INT_ID = p_COUNTER_READ_PROP_INT_ID;
346: IF (SQL%NOTFOUND) then
347: RAISE NO_DATA_FOUND;
348: END IF;