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