APPS.CSI_CTR_DERIVED_FILTERS_PKG dependencies on CSI_COUNTER_DERIVED_FILTERS

Line 55: INSERT INTO CSI_COUNTER_DERIVED_FILTERS(

51: FETCH C1 INTO px_COUNTER_DERIVED_FILTER_ID;
52: CLOSE C1;
53: END IF;
54:
55: INSERT INTO CSI_COUNTER_DERIVED_FILTERS(
56: COUNTER_DERIVED_FILTER_ID
57: ,COUNTER_ID
58: ,SEQ_NO
59: ,LEFT_PARENT

Line 170: UPDATE CSI_COUNTER_DERIVED_FILTERS

166: ,p_SECURITY_GROUP_ID NUMBER
167: ,p_MIGRATED_FLAG VARCHAR2
168: ) IS
169: BEGIN
170: UPDATE CSI_COUNTER_DERIVED_FILTERS
171: SET
172: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
173: ,SEQ_NO = decode(p_SEQ_NO, NULL, SEQ_NO, FND_API.G_MISS_NUM, NULL, p_SEQ_NO)
174: ,LEFT_PARENT = decode(p_LEFT_PARENT, NULL, LEFT_PARENT, FND_API.G_MISS_CHAR, NULL, p_LEFT_PARENT)

Line 253: FROM CSI_COUNTER_DERIVED_FILTERS

249: ) IS
250:
251: CURSOR C1 IS
252: SELECT *
253: FROM CSI_COUNTER_DERIVED_FILTERS
254: WHERE COUNTER_DERIVED_FILTER_ID = p_COUNTER_DERIVED_FILTER_ID
255: FOR UPDATE of COUNTER_DERIVED_FILTER_ID NOWAIT;
256: Recinfo C1%ROWTYPE;
257: BEGIN

Line 315: DELETE FROM CSI_COUNTER_DERIVED_FILTERS

311: PROCEDURE Delete_Row(
312: p_COUNTER_DERIVED_FILTER_ID NUMBER
313: ) IS
314: BEGIN
315: DELETE FROM CSI_COUNTER_DERIVED_FILTERS
316: WHERE COUNTER_DERIVED_FILTER_ID = p_COUNTER_DERIVED_FILTER_ID;
317:
318: IF (SQL%NOTFOUND) then
319: RAISE NO_DATA_FOUND;