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
80: FROM dual;
76: FROM dual;
77:
78: CURSOR C2 IS
79: SELECT CSI_COUNTER_READINGS_S.nextval
80: FROM dual;
81: BEGIN
82: IF (px_COUNTER_INTERFACE_ID IS NULL) OR (px_COUNTER_INTERFACE_ID = FND_API.G_MISS_NUM) then
83: OPEN C1;
84: FETCH C1 INTO px_COUNTER_INTERFACE_ID;