[Home] [Help]
PACKAGE BODY: APPS.CSD_SC_WORK_ENTITIES_PKG
Source
1 PACKAGE BODY CSD_SC_WORK_ENTITIES_PKG as
2 /* $Header: csdtscwb.pls 115.3 2003/11/05 00:50:06 gilam noship $ */
3 -- Start of Comments
4 -- Package name : CSD_SC_WORK_ENTITIES_PKG
5 -- Purpose : To create, update, delete and lock sc work entity
6 -- History : 20-Aug-2003 Gilam created
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_SC_WORK_ENTITIES_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtscwb.pls';
13
14 PROCEDURE Insert_Row(
15 px_SC_WORK_ENTITY_ID IN OUT NOCOPY NUMBER
16 ,p_OBJECT_VERSION_NUMBER NUMBER
17 ,p_SERVICE_CODE_ID NUMBER
18 ,p_WORK_ENTITY_ID1 NUMBER
19 ,p_CREATED_BY NUMBER
20 ,p_CREATION_DATE DATE
21 ,p_LAST_UPDATED_BY NUMBER
22 ,p_LAST_UPDATE_DATE DATE
23 ,p_LAST_UPDATE_LOGIN NUMBER
24 ,p_WORK_ENTITY_TYPE_CODE VARCHAR2
25 ,p_WORK_ENTITY_ID2 NUMBER
26 ,p_WORK_ENTITY_ID3 NUMBER
27 ,p_ATTRIBUTE_CATEGORY VARCHAR2
28 ,p_ATTRIBUTE1 VARCHAR2
29 ,p_ATTRIBUTE2 VARCHAR2
30 ,p_ATTRIBUTE3 VARCHAR2
31 ,p_ATTRIBUTE4 VARCHAR2
32 ,p_ATTRIBUTE5 VARCHAR2
33 ,p_ATTRIBUTE6 VARCHAR2
34 ,p_ATTRIBUTE7 VARCHAR2
35 ,p_ATTRIBUTE8 VARCHAR2
36 ,p_ATTRIBUTE9 VARCHAR2
37 ,p_ATTRIBUTE10 VARCHAR2
38 ,p_ATTRIBUTE11 VARCHAR2
39 ,p_ATTRIBUTE12 VARCHAR2
40 ,p_ATTRIBUTE13 VARCHAR2
41 ,p_ATTRIBUTE14 VARCHAR2
42 ,p_ATTRIBUTE15 VARCHAR2)
43
44 IS
45 CURSOR C2 IS SELECT CSD_SC_WORK_ENTITIES_S1.nextval FROM sys.dual;
46 BEGIN
47 If (px_SC_WORK_ENTITY_ID IS NULL) OR (px_SC_WORK_ENTITY_ID = FND_API.G_MISS_NUM) then
48 OPEN C2;
49 FETCH C2 INTO px_SC_WORK_ENTITY_ID;
50 CLOSE C2;
51 End If;
52 INSERT INTO CSD_SC_WORK_ENTITIES(
53 SC_WORK_ENTITY_ID
54 ,OBJECT_VERSION_NUMBER
55 ,SERVICE_CODE_ID
56 ,WORK_ENTITY_ID1
57 ,CREATED_BY
58 ,CREATION_DATE
59 ,LAST_UPDATED_BY
60 ,LAST_UPDATE_DATE
61 ,LAST_UPDATE_LOGIN
62 ,WORK_ENTITY_TYPE_CODE
63 ,WORK_ENTITY_ID2
64 ,WORK_ENTITY_ID3
65 ,ATTRIBUTE_CATEGORY
66 ,ATTRIBUTE1
67 ,ATTRIBUTE2
68 ,ATTRIBUTE3
69 ,ATTRIBUTE4
70 ,ATTRIBUTE5
71 ,ATTRIBUTE6
72 ,ATTRIBUTE7
73 ,ATTRIBUTE8
74 ,ATTRIBUTE9
75 ,ATTRIBUTE10
76 ,ATTRIBUTE11
77 ,ATTRIBUTE12
78 ,ATTRIBUTE13
79 ,ATTRIBUTE14
80 ,ATTRIBUTE15
81 ) VALUES (
82 px_SC_WORK_ENTITY_ID
83 ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
84 ,decode( p_SERVICE_CODE_ID, FND_API.G_MISS_NUM, NULL, p_SERVICE_CODE_ID)
85 ,decode( p_WORK_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_WORK_ENTITY_ID1)
86 ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
87 ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
88 ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
89 ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
90 ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
91 ,decode( p_WORK_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_WORK_ENTITY_TYPE_CODE)
92 ,decode( p_WORK_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_WORK_ENTITY_ID2)
93 ,decode( p_WORK_ENTITY_ID3, FND_API.G_MISS_NUM, NULL, p_WORK_ENTITY_ID3)
94 ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
95 ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
96 ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
97 ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
98 ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
99 ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
100 ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
101 ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
102 ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
103 ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
104 ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
105 ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
106 ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
107 ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
108 ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
109 ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
110 End Insert_Row;
111
112 PROCEDURE Update_Row(
113 p_SC_WORK_ENTITY_ID NUMBER
114 ,p_OBJECT_VERSION_NUMBER NUMBER
115 ,p_SERVICE_CODE_ID NUMBER
116 ,p_WORK_ENTITY_ID1 NUMBER
117 ,p_CREATED_BY NUMBER
118 ,p_CREATION_DATE DATE
119 ,p_LAST_UPDATED_BY NUMBER
120 ,p_LAST_UPDATE_DATE DATE
121 ,p_LAST_UPDATE_LOGIN NUMBER
122 ,p_WORK_ENTITY_TYPE_CODE VARCHAR2
123 ,p_WORK_ENTITY_ID2 NUMBER
124 ,p_WORK_ENTITY_ID3 NUMBER
125 ,p_ATTRIBUTE_CATEGORY VARCHAR2
126 ,p_ATTRIBUTE1 VARCHAR2
127 ,p_ATTRIBUTE2 VARCHAR2
128 ,p_ATTRIBUTE3 VARCHAR2
129 ,p_ATTRIBUTE4 VARCHAR2
130 ,p_ATTRIBUTE5 VARCHAR2
131 ,p_ATTRIBUTE6 VARCHAR2
132 ,p_ATTRIBUTE7 VARCHAR2
133 ,p_ATTRIBUTE8 VARCHAR2
134 ,p_ATTRIBUTE9 VARCHAR2
135 ,p_ATTRIBUTE10 VARCHAR2
136 ,p_ATTRIBUTE11 VARCHAR2
137 ,p_ATTRIBUTE12 VARCHAR2
138 ,p_ATTRIBUTE13 VARCHAR2
139 ,p_ATTRIBUTE14 VARCHAR2
140 ,p_ATTRIBUTE15 VARCHAR2)
141
142 IS
143 BEGIN
144 Update CSD_SC_WORK_ENTITIES
145 SET
146 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
147 ,SERVICE_CODE_ID = decode( p_SERVICE_CODE_ID, FND_API.G_MISS_NUM, NULL, NULL, SERVICE_CODE_ID, p_SERVICE_CODE_ID)
148 ,WORK_ENTITY_ID1 = decode( p_WORK_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, NULL, WORK_ENTITY_ID1, p_WORK_ENTITY_ID1)
149 ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
150 ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
151 ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
152 ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
153 ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
154 ,WORK_ENTITY_TYPE_CODE = decode( p_WORK_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WORK_ENTITY_TYPE_CODE, p_WORK_ENTITY_TYPE_CODE)
155 ,WORK_ENTITY_ID2 = decode( p_WORK_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, NULL, WORK_ENTITY_ID2, p_WORK_ENTITY_ID2)
156 ,WORK_ENTITY_ID3 = decode( p_WORK_ENTITY_ID3, FND_API.G_MISS_NUM, NULL, NULL, WORK_ENTITY_ID3, p_WORK_ENTITY_ID3)
157 ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
158 ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
159 ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
160 ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
161 ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
162 ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
163 ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
164 ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
165 ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
166 ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
167 ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
168 ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
169 ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
170 ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
171 ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
172 ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
173 where SC_WORK_ENTITY_ID = p_SC_WORK_ENTITY_ID;
174
175 If (SQL%NOTFOUND) then
176 RAISE NO_DATA_FOUND;
177 End If;
178 END Update_Row;
179
180 PROCEDURE Delete_Row(
181 p_SC_WORK_ENTITY_ID NUMBER)
182 IS
183 BEGIN
184 DELETE FROM CSD_SC_WORK_ENTITIES
185 WHERE SC_WORK_ENTITY_ID = p_SC_WORK_ENTITY_ID;
186 If (SQL%NOTFOUND) then
187 RAISE NO_DATA_FOUND;
188 End If;
189 END Delete_Row;
190
191 PROCEDURE Lock_Row(
192 p_SC_WORK_ENTITY_ID NUMBER
193 ,p_OBJECT_VERSION_NUMBER NUMBER
194
195 --commented out the rest of the record
196 /*
197 ,p_SERVICE_CODE_ID NUMBER
198 ,p_WORK_ENTITY_ID1 NUMBER
199 ,p_CREATED_BY NUMBER
200 ,p_CREATION_DATE DATE
201 ,p_LAST_UPDATED_BY NUMBER
202 ,p_LAST_UPDATE_DATE DATE
203 ,p_LAST_UPDATE_LOGIN NUMBER
204 ,p_WORK_ENTITY_TYPE_CODE VARCHAR2
205 ,p_WORK_ENTITY_ID2 NUMBER
206 ,p_WORK_ENTITY_ID3 NUMBER
207 ,p_ATTRIBUTE_CATEGORY VARCHAR2
208 ,p_ATTRIBUTE1 VARCHAR2
209 ,p_ATTRIBUTE2 VARCHAR2
210 ,p_ATTRIBUTE3 VARCHAR2
211 ,p_ATTRIBUTE4 VARCHAR2
212 ,p_ATTRIBUTE5 VARCHAR2
213 ,p_ATTRIBUTE6 VARCHAR2
214 ,p_ATTRIBUTE7 VARCHAR2
215 ,p_ATTRIBUTE8 VARCHAR2
216 ,p_ATTRIBUTE9 VARCHAR2
217 ,p_ATTRIBUTE10 VARCHAR2
218 ,p_ATTRIBUTE11 VARCHAR2
219 ,p_ATTRIBUTE12 VARCHAR2
220 ,p_ATTRIBUTE13 VARCHAR2
221 ,p_ATTRIBUTE14 VARCHAR2
222 ,p_ATTRIBUTE15 VARCHAR2
223 */
224 --
225 )
226
227 IS
228 CURSOR C IS
229 SELECT *
230 FROM CSD_SC_WORK_ENTITIES
231 WHERE SC_WORK_ENTITY_ID = p_SC_WORK_ENTITY_ID
232 FOR UPDATE of SC_WORK_ENTITY_ID NOWAIT;
233 Recinfo C%ROWTYPE;
234 BEGIN
235 OPEN C;
236 FETCH C INTO Recinfo;
237 If (C%NOTFOUND) then
238 CLOSE C;
239 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
240 APP_EXCEPTION.RAISE_EXCEPTION;
241 End If;
242 CLOSE C;
243 if (
244 ( Recinfo.SC_WORK_ENTITY_ID = p_SC_WORK_ENTITY_ID)
245 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
246 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
250 /*
247 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
248
249 --commented out the rest of the record
251 AND ( ( Recinfo.SERVICE_CODE_ID = p_SERVICE_CODE_ID)
252 OR ( ( Recinfo.SERVICE_CODE_ID IS NULL )
253 AND ( p_SERVICE_CODE_ID IS NULL )))
254 AND ( ( Recinfo.WORK_ENTITY_ID1 = p_WORK_ENTITY_ID1)
255 OR ( ( Recinfo.WORK_ENTITY_ID1 IS NULL )
256 AND ( p_WORK_ENTITY_ID1 IS NULL )))
257 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
258 OR ( ( Recinfo.CREATED_BY IS NULL )
259 AND ( p_CREATED_BY IS NULL )))
260 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
261 OR ( ( Recinfo.CREATION_DATE IS NULL )
262 AND ( p_CREATION_DATE IS NULL )))
263 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
264 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
265 AND ( p_LAST_UPDATED_BY IS NULL )))
266 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
267 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
268 AND ( p_LAST_UPDATE_DATE IS NULL )))
269 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
270 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
271 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
272 AND ( ( Recinfo.WORK_ENTITY_TYPE_CODE = p_WORK_ENTITY_TYPE_CODE)
273 OR ( ( Recinfo.WORK_ENTITY_TYPE_CODE IS NULL )
274 AND ( p_WORK_ENTITY_TYPE_CODE IS NULL )))
275 AND ( ( Recinfo.WORK_ENTITY_ID2 = p_WORK_ENTITY_ID2)
276 OR ( ( Recinfo.WORK_ENTITY_ID2 IS NULL )
277 AND ( p_WORK_ENTITY_ID2 IS NULL )))
278 AND ( ( Recinfo.WORK_ENTITY_ID3 = p_WORK_ENTITY_ID3)
279 OR ( ( Recinfo.WORK_ENTITY_ID3 IS NULL )
280 AND ( p_WORK_ENTITY_ID3 IS NULL )))
281 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
282 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
283 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
284 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
285 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
286 AND ( p_ATTRIBUTE1 IS NULL )))
287 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
288 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
289 AND ( p_ATTRIBUTE2 IS NULL )))
290 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
291 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
292 AND ( p_ATTRIBUTE3 IS NULL )))
293 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
294 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
295 AND ( p_ATTRIBUTE4 IS NULL )))
296 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
297 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
298 AND ( p_ATTRIBUTE5 IS NULL )))
299 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
300 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
301 AND ( p_ATTRIBUTE6 IS NULL )))
302 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
303 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
304 AND ( p_ATTRIBUTE7 IS NULL )))
305 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
306 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
307 AND ( p_ATTRIBUTE8 IS NULL )))
308 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
309 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
310 AND ( p_ATTRIBUTE9 IS NULL )))
311 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
312 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
313 AND ( p_ATTRIBUTE10 IS NULL )))
314 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
315 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
316 AND ( p_ATTRIBUTE11 IS NULL )))
317 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
318 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
319 AND ( p_ATTRIBUTE12 IS NULL )))
320 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
321 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
322 AND ( p_ATTRIBUTE13 IS NULL )))
323 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
324 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
325 AND ( p_ATTRIBUTE14 IS NULL )))
326 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
327 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
328 AND ( p_ATTRIBUTE15 IS NULL )))
329 */
330 --
331 ) then
332 return;
333 else
334 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
335 APP_EXCEPTION.RAISE_EXCEPTION;
336 End If;
337 END Lock_Row;
338
339 End CSD_SC_WORK_ENTITIES_PKG;