eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.CSI_CTR_DERIVED_FILTERS_PKG

Source


1 PACKAGE BODY CSI_CTR_DERIVED_FILTERS_PKG as
2 /* $Header: csitcdfb.pls 120.1 2008/04/03 21:53:21 devijay ship $*/
3 
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_CTR_DERIVED_FILTERS_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcdfb.pls';
6 
7 PROCEDURE Insert_Row(
8 	px_COUNTER_DERIVED_FILTER_ID       IN OUT NOCOPY NUMBER
9  	,p_COUNTER_ID                      NUMBER
10  	,p_SEQ_NO                          NUMBER
11  	,p_LEFT_PARENT                     VARCHAR2
12  	,p_COUNTER_PROPERTY_ID             NUMBER
13  	,p_RELATIONAL_OPERATOR             VARCHAR2
14  	,p_RIGHT_VALUE                     VARCHAR2
15  	,p_RIGHT_PARENT                    VARCHAR2
16  	,p_LOGICAL_OPERATOR                VARCHAR2
17  	,p_START_DATE_ACTIVE               DATE
18  	,p_END_DATE_ACTIVE                 DATE
19  	,p_OBJECT_VERSION_NUMBER           NUMBER
20  	,p_LAST_UPDATE_DATE                DATE
21  	,p_LAST_UPDATED_BY                 NUMBER
22  	,p_CREATION_DATE                   DATE
23  	,p_CREATED_BY                      NUMBER
24  	,p_LAST_UPDATE_LOGIN               NUMBER
25  	,p_ATTRIBUTE1                      VARCHAR2
26  	,p_ATTRIBUTE2                      VARCHAR2
27  	,p_ATTRIBUTE3                      VARCHAR2
28  	,p_ATTRIBUTE4                      VARCHAR2
29  	,p_ATTRIBUTE5                      VARCHAR2
30  	,p_ATTRIBUTE6                      VARCHAR2
31  	,p_ATTRIBUTE7                      VARCHAR2
32  	,p_ATTRIBUTE8                      VARCHAR2
33  	,p_ATTRIBUTE9                      VARCHAR2
34  	,p_ATTRIBUTE10                     VARCHAR2
35  	,p_ATTRIBUTE11                     VARCHAR2
36  	,p_ATTRIBUTE12                     VARCHAR2
37  	,p_ATTRIBUTE13                     VARCHAR2
38  	,p_ATTRIBUTE14                     VARCHAR2
39  	,p_ATTRIBUTE15                     VARCHAR2
40  	,p_ATTRIBUTE_CATEGORY              VARCHAR2
41  	,p_SECURITY_GROUP_ID               NUMBER
42  	,p_MIGRATED_FLAG                   VARCHAR2
43 		) IS
44 
45 	CURSOR C1 IS
46 	SELECT	CSI_CTR_DERIVED_FILTERS_S.nextval
47 	FROM	dual;
48 BEGIN
49 	IF (px_COUNTER_DERIVED_FILTER_ID IS NULL) OR (px_COUNTER_DERIVED_FILTER_ID = FND_API.G_MISS_NUM) THEN
50 		OPEN C1;
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
60  		,COUNTER_PROPERTY_ID
61  		,RELATIONAL_OPERATOR
62  		,RIGHT_VALUE
63  		,RIGHT_PARENT
64  		,LOGICAL_OPERATOR
65  		,START_DATE_ACTIVE
66  		,END_DATE_ACTIVE
67  		,OBJECT_VERSION_NUMBER
68  		,LAST_UPDATE_DATE
69  		,LAST_UPDATED_BY
70  		,CREATION_DATE
71  		,CREATED_BY
72  		,LAST_UPDATE_LOGIN
73  		,ATTRIBUTE1
74  		,ATTRIBUTE2
75  		,ATTRIBUTE3
76  		,ATTRIBUTE4
77  		,ATTRIBUTE5
78  		,ATTRIBUTE6
79  		,ATTRIBUTE7
80  		,ATTRIBUTE8
81  		,ATTRIBUTE9
82  		,ATTRIBUTE10
83  		,ATTRIBUTE11
84  		,ATTRIBUTE12
85  		,ATTRIBUTE13
86  		,ATTRIBUTE14
87  		,ATTRIBUTE15
88  		,ATTRIBUTE_CATEGORY
89  		,SECURITY_GROUP_ID
90  		,MIGRATED_FLAG
91 		)
92 	VALUES(
93 		px_COUNTER_DERIVED_FILTER_ID
94  		,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
95  		,decode(p_SEQ_NO, FND_API.G_MISS_NUM, NULL, p_SEQ_NO)
96  		,decode(p_LEFT_PARENT, FND_API.G_MISS_CHAR, NULL, p_LEFT_PARENT)
97  		,decode(p_COUNTER_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_PROPERTY_ID)
98  		,decode(p_RELATIONAL_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_RELATIONAL_OPERATOR)
99  		,decode(p_RIGHT_VALUE, FND_API.G_MISS_CHAR, NULL, p_RIGHT_VALUE)
100  		,decode(p_RIGHT_PARENT, FND_API.G_MISS_CHAR, NULL, p_RIGHT_PARENT)
101  		,decode(p_LOGICAL_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_LOGICAL_OPERATOR)
102  		,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE)
103  		,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE)
104  		,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
105  		,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106  		,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
107  		,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
108  		,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
109  		,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
110  		,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
111  		,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
112  		,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
113  		,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
114  		,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
115  		,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
116  		,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
117  		,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
118  		,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
119  		,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
120  		,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
121  		,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
122  		,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
123  		,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
124  		,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
125  		,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
126  		,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
127  		,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
128 		);
129 
130 End Insert_Row;
131 
132 PROCEDURE Update_Row(
133 	p_COUNTER_DERIVED_FILTER_ID        NUMBER
134  	,p_COUNTER_ID                      NUMBER
135  	,p_SEQ_NO                          NUMBER
136  	,p_LEFT_PARENT                     VARCHAR2
137  	,p_COUNTER_PROPERTY_ID             NUMBER
138  	,p_RELATIONAL_OPERATOR             VARCHAR2
139  	,p_RIGHT_VALUE                     VARCHAR2
140  	,p_RIGHT_PARENT                    VARCHAR2
141  	,p_LOGICAL_OPERATOR                VARCHAR2
142  	,p_START_DATE_ACTIVE               DATE
143  	,p_END_DATE_ACTIVE                 DATE
144  	,p_OBJECT_VERSION_NUMBER           NUMBER
145  	,p_LAST_UPDATE_DATE                DATE
146  	,p_LAST_UPDATED_BY                 NUMBER
147  	,p_CREATION_DATE                   DATE
148  	,p_CREATED_BY                      NUMBER
149  	,p_LAST_UPDATE_LOGIN               NUMBER
150  	,p_ATTRIBUTE1                      VARCHAR2
151  	,p_ATTRIBUTE2                      VARCHAR2
152  	,p_ATTRIBUTE3                      VARCHAR2
153  	,p_ATTRIBUTE4                      VARCHAR2
154  	,p_ATTRIBUTE5                      VARCHAR2
155  	,p_ATTRIBUTE6                      VARCHAR2
156  	,p_ATTRIBUTE7                      VARCHAR2
157  	,p_ATTRIBUTE8                      VARCHAR2
158  	,p_ATTRIBUTE9                      VARCHAR2
159  	,p_ATTRIBUTE10                     VARCHAR2
160  	,p_ATTRIBUTE11                     VARCHAR2
161  	,p_ATTRIBUTE12                     VARCHAR2
162  	,p_ATTRIBUTE13                     VARCHAR2
163  	,p_ATTRIBUTE14                     VARCHAR2
164  	,p_ATTRIBUTE15                     VARCHAR2
165  	,p_ATTRIBUTE_CATEGORY              VARCHAR2
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)
175  		,COUNTER_PROPERTY_ID = decode(p_COUNTER_PROPERTY_ID, NULL, COUNTER_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_PROPERTY_ID)
176  		,RELATIONAL_OPERATOR = decode(p_RELATIONAL_OPERATOR, NULL, RELATIONAL_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_RELATIONAL_OPERATOR)
177  		,RIGHT_VALUE = decode(p_RIGHT_VALUE, NULL, RIGHT_VALUE, FND_API.G_MISS_CHAR, NULL, p_RIGHT_VALUE)
178  		,RIGHT_PARENT = decode(p_RIGHT_PARENT, NULL, RIGHT_PARENT, FND_API.G_MISS_CHAR, NULL, p_RIGHT_PARENT)
179  		,LOGICAL_OPERATOR = decode(p_LOGICAL_OPERATOR, NULL, LOGICAL_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_LOGICAL_OPERATOR)
180  		,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
181  		,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
182  		,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
183  		,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
184  		,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
185  		,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
186 	    ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
187  		,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
188  		,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
189  		,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
190  		,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
191  		,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
192  		,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
193  		,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
194  		,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
195  		,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
196  		,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
197  		,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
198  		,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
199  		,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
200  		,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
201  		,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
202  		,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
203  		,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
204  		,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
205  		,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
206 	WHERE COUNTER_DERIVED_FILTER_ID = p_COUNTER_DERIVED_FILTER_ID;
207 
208     If (SQL%NOTFOUND) then
209         RAISE NO_DATA_FOUND;
210     End If;
211 END Update_Row;
212 
213 PROCEDURE Lock_Row(
214 	p_COUNTER_DERIVED_FILTER_ID        NUMBER
215  	,p_COUNTER_ID                      NUMBER
216  	,p_SEQ_NO                          NUMBER
217  	,p_LEFT_PARENT                     VARCHAR2
218  	,p_COUNTER_PROPERTY_ID             NUMBER
219  	,p_RELATIONAL_OPERATOR             VARCHAR2
220  	,p_RIGHT_VALUE                     VARCHAR2
221  	,p_RIGHT_PARENT                    VARCHAR2
222  	,p_LOGICAL_OPERATOR                VARCHAR2
223  	,p_START_DATE_ACTIVE               DATE
224  	,p_END_DATE_ACTIVE                 DATE
225  	,p_OBJECT_VERSION_NUMBER           NUMBER
226  	,p_LAST_UPDATE_DATE                DATE
227  	,p_LAST_UPDATED_BY                 NUMBER
228  	,p_CREATION_DATE                   DATE
229  	,p_CREATED_BY                      NUMBER
230  	,p_LAST_UPDATE_LOGIN               NUMBER
231  	,p_ATTRIBUTE1                      VARCHAR2
232  	,p_ATTRIBUTE2                      VARCHAR2
233  	,p_ATTRIBUTE3                      VARCHAR2
234  	,p_ATTRIBUTE4                      VARCHAR2
235  	,p_ATTRIBUTE5                      VARCHAR2
236  	,p_ATTRIBUTE6                      VARCHAR2
237  	,p_ATTRIBUTE7                      VARCHAR2
238  	,p_ATTRIBUTE8                      VARCHAR2
239  	,p_ATTRIBUTE9                      VARCHAR2
240  	,p_ATTRIBUTE10                     VARCHAR2
241  	,p_ATTRIBUTE11                     VARCHAR2
242  	,p_ATTRIBUTE12                     VARCHAR2
243  	,p_ATTRIBUTE13                     VARCHAR2
244  	,p_ATTRIBUTE14                     VARCHAR2
245  	,p_ATTRIBUTE15                     VARCHAR2
246  	,p_ATTRIBUTE_CATEGORY              VARCHAR2
247  	,p_SECURITY_GROUP_ID               NUMBER
251 	CURSOR C1 IS
248  	,p_MIGRATED_FLAG                   VARCHAR2
249         ) IS
250 
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
258 	OPEN C1;
259 	FETCH C1 INTO Recinfo;
260 	IF (C1%NOTFOUND) THEN
261 		CLOSE C1;
262 		FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
263 		APP_EXCEPTION.RAISE_EXCEPTION;
264 	END IF;
265 	CLOSE C1;
266 
267 	IF (
268 		(Recinfo.COUNTER_DERIVED_FILTER_ID = p_COUNTER_DERIVED_FILTER_ID)
269  		AND ((Recinfo.COUNTER_ID = p_COUNTER_ID) OR ((Recinfo.COUNTER_ID IS NULL) AND (p_COUNTER_ID IS NULL)))
270  		AND ((Recinfo.SEQ_NO = p_SEQ_NO) OR ((Recinfo.SEQ_NO IS NULL) AND (p_SEQ_NO IS NULL)))
271  		AND ((Recinfo.LEFT_PARENT = p_LEFT_PARENT) OR ((Recinfo.LEFT_PARENT IS NULL) AND (p_LEFT_PARENT IS NULL)))
272  		AND ((Recinfo.COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID) OR ((Recinfo.COUNTER_PROPERTY_ID IS NULL) AND (p_COUNTER_PROPERTY_ID IS NULL)))
273  		AND ((Recinfo.RELATIONAL_OPERATOR = p_RELATIONAL_OPERATOR) OR ((Recinfo.RELATIONAL_OPERATOR IS NULL) AND (p_RELATIONAL_OPERATOR IS NULL)))
274  		AND ((Recinfo.RIGHT_VALUE = p_RIGHT_VALUE) OR ((Recinfo.RIGHT_VALUE IS NULL) AND (p_RIGHT_VALUE IS NULL)))
275  		AND ((Recinfo.RIGHT_PARENT = p_RIGHT_PARENT) OR ((Recinfo.RIGHT_PARENT IS NULL) AND (p_RIGHT_PARENT IS NULL)))
276  		AND ((Recinfo.LOGICAL_OPERATOR = p_LOGICAL_OPERATOR) OR ((Recinfo.LOGICAL_OPERATOR IS NULL) AND (p_LOGICAL_OPERATOR IS NULL)))
277  		AND ((Recinfo.START_DATE_ACTIVE = p_START_DATE_ACTIVE) OR ((Recinfo.START_DATE_ACTIVE IS NULL) AND (p_START_DATE_ACTIVE IS NULL)))
278  		AND ((Recinfo.END_DATE_ACTIVE = p_END_DATE_ACTIVE) OR ((Recinfo.END_DATE_ACTIVE IS NULL) AND (p_END_DATE_ACTIVE IS NULL)))
279  		AND ((Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) OR ((Recinfo.OBJECT_VERSION_NUMBER IS NULL) AND (p_OBJECT_VERSION_NUMBER IS NULL)))
280  		AND ((Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) OR ((Recinfo.LAST_UPDATE_DATE IS NULL) AND (p_LAST_UPDATE_DATE IS NULL)))
281  		AND ((Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) OR ((Recinfo.LAST_UPDATED_BY IS NULL) AND (p_LAST_UPDATED_BY IS NULL)))
282  		AND ((Recinfo.CREATION_DATE = p_CREATION_DATE) OR ((Recinfo.CREATION_DATE IS NULL) AND (p_CREATION_DATE IS NULL)))
283  		AND ((Recinfo.CREATED_BY = p_CREATED_BY) OR ((Recinfo.CREATED_BY IS NULL) AND (p_CREATED_BY IS NULL)))
284  		AND ((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND (p_LAST_UPDATE_LOGIN IS NULL)))
285  		AND ((Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1) OR ((Recinfo.ATTRIBUTE1 IS NULL) AND (p_ATTRIBUTE1 IS NULL)))
286  		AND ((Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2) OR ((Recinfo.ATTRIBUTE2 IS NULL) AND (p_ATTRIBUTE2 IS NULL)))
287  		AND ((Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3) OR ((Recinfo.ATTRIBUTE3 IS NULL) AND (p_ATTRIBUTE3 IS NULL)))
288  		AND ((Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4) OR ((Recinfo.ATTRIBUTE4 IS NULL) AND (p_ATTRIBUTE4 IS NULL)))
289  		AND ((Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5) OR ((Recinfo.ATTRIBUTE5 IS NULL) AND (p_ATTRIBUTE5 IS NULL)))
290  		AND ((Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6) OR ((Recinfo.ATTRIBUTE6 IS NULL) AND (p_ATTRIBUTE6 IS NULL)))
291  		AND ((Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7) OR ((Recinfo.ATTRIBUTE7 IS NULL) AND (p_ATTRIBUTE7 IS NULL)))
292  		AND ((Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8) OR ((Recinfo.ATTRIBUTE8 IS NULL) AND (p_ATTRIBUTE8 IS NULL)))
293  		AND ((Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9) OR ((Recinfo.ATTRIBUTE9 IS NULL) AND (p_ATTRIBUTE9 IS NULL)))
294  		AND ((Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10) OR ((Recinfo.ATTRIBUTE10 IS NULL) AND (p_ATTRIBUTE10 IS NULL)))
295  		AND ((Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11) OR ((Recinfo.ATTRIBUTE11 IS NULL) AND (p_ATTRIBUTE11 IS NULL)))
296  		AND ((Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12) OR ((Recinfo.ATTRIBUTE12 IS NULL) AND (p_ATTRIBUTE12 IS NULL)))
297  		AND ((Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13) OR ((Recinfo.ATTRIBUTE13 IS NULL) AND (p_ATTRIBUTE13 IS NULL)))
298  		AND ((Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14) OR ((Recinfo.ATTRIBUTE14 IS NULL) AND (p_ATTRIBUTE14 IS NULL)))
299  		AND ((Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15) OR ((Recinfo.ATTRIBUTE15 IS NULL) AND (p_ATTRIBUTE15 IS NULL)))
300  		AND ((Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY) OR ((Recinfo.ATTRIBUTE_CATEGORY IS NULL) AND (p_ATTRIBUTE_CATEGORY IS NULL)))
301  		AND ((Recinfo.SECURITY_GROUP_ID = p_SECURITY_GROUP_ID) OR ((Recinfo.SECURITY_GROUP_ID IS NULL) AND (p_SECURITY_GROUP_ID IS NULL)))
302  		AND ((Recinfo.MIGRATED_FLAG = p_MIGRATED_FLAG) OR ((Recinfo.MIGRATED_FLAG IS NULL) AND (p_MIGRATED_FLAG IS NULL)))
303 	    ) THEN
304 		RETURN;
305    ELSE
306       FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
307       APP_EXCEPTION.RAISE_EXCEPTION;
308    END IF;
309 END Lock_Row;
310 
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;
320    END IF;
321 END Delete_Row;
322 
323 End CSI_CTR_DERIVED_FILTERS_PKG;