[Home] [Help]
PACKAGE BODY: APPS.CSI_I_ASSETS_H_PKG
Source
1 PACKAGE BODY CSI_I_ASSETS_H_PKG as
2 /* $Header: csitashb.pls 120.2 2005/06/08 15:39:14 appldev $ */
3
4
5 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_ASSETS_H_PKG';
6 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitashb.pls';
7
8 PROCEDURE Insert_Row(
9 px_INSTANCE_ASSET_HISTORY_ID IN OUT NOCOPY NUMBER,
10 p_INSTANCE_ASSET_ID NUMBER,
11 p_TRANSACTION_ID NUMBER,
12 p_OLD_INSTANCE_ID NUMBER,
13 p_NEW_INSTANCE_ID NUMBER,
14 p_OLD_FA_ASSET_ID NUMBER,
15 p_NEW_FA_ASSET_ID NUMBER,
16 p_OLD_ASSET_QUANTITY NUMBER,
17 p_NEW_ASSET_QUANTITY NUMBER,
18 p_OLD_FA_BOOK_TYPE_CODE VARCHAR2,
19 p_NEW_FA_BOOK_TYPE_CODE VARCHAR2,
20 p_OLD_FA_LOCATION_ID NUMBER,
21 p_NEW_FA_LOCATION_ID NUMBER,
22 p_OLD_UPDATE_STATUS VARCHAR2,
23 p_NEW_UPDATE_STATUS VARCHAR2,
24 p_OLD_FA_SYNC_FLAG VARCHAR2,
25 p_NEW_FA_SYNC_FLAG VARCHAR2,
26 p_OLD_FA_MASS_ADDITION_ID NUMBER,
27 p_NEW_FA_MASS_ADDITION_ID NUMBER,
28 p_OLD_CREATION_COMPLETE_FLAG VARCHAR2,
29 p_NEW_CREATION_COMPLETE_FLAG VARCHAR2,
30 p_FULL_DUMP_FLAG VARCHAR2,
31 p_CREATED_BY NUMBER,
32 p_CREATION_DATE DATE,
33 p_LAST_UPDATED_BY NUMBER,
34 p_LAST_UPDATE_DATE DATE,
35 p_LAST_UPDATE_LOGIN NUMBER,
36 p_OBJECT_VERSION_NUMBER NUMBER,
37 p_OLD_ACTIVE_START_DATE DATE,
38 p_NEW_ACTIVE_START_DATE DATE,
39 p_OLD_ACTIVE_END_DATE DATE,
40 p_NEW_ACTIVE_END_DATE DATE)
41
42 IS
43 CURSOR C2 IS SELECT CSI_I_ASSETS_H_S.nextval FROM sys.dual;
44 BEGIN
45 If (px_INSTANCE_ASSET_HISTORY_ID IS NULL) OR (px_INSTANCE_ASSET_HISTORY_ID = FND_API.G_MISS_NUM) then
46 OPEN C2;
47 FETCH C2 INTO px_INSTANCE_ASSET_HISTORY_ID;
48 CLOSE C2;
49 End If;
50 INSERT INTO CSI_I_ASSETS_H(
51 INSTANCE_ASSET_HISTORY_ID,
52 INSTANCE_ASSET_ID,
53 TRANSACTION_ID,
54 OLD_INSTANCE_ID,
55 NEW_INSTANCE_ID,
56 OLD_FA_ASSET_ID,
57 NEW_FA_ASSET_ID,
58 OLD_ASSET_QUANTITY,
59 NEW_ASSET_QUANTITY,
60 OLD_FA_BOOK_TYPE_CODE,
61 NEW_FA_BOOK_TYPE_CODE,
62 OLD_FA_LOCATION_ID,
63 NEW_FA_LOCATION_ID,
64 OLD_UPDATE_STATUS,
65 NEW_UPDATE_STATUS,
66 OLD_FA_SYNC_FLAG,
67 NEW_FA_SYNC_FLAG,
68 OLD_FA_MASS_ADDITION_ID,
69 NEW_FA_MASS_ADDITION_ID,
70 OLD_CREATION_COMPLETE_FLAG,
71 NEW_CREATION_COMPLETE_FLAG,
72 FULL_DUMP_FLAG,
73 CREATED_BY,
74 CREATION_DATE,
75 LAST_UPDATED_BY,
76 LAST_UPDATE_DATE,
77 LAST_UPDATE_LOGIN,
78 OBJECT_VERSION_NUMBER,
79 OLD_ACTIVE_START_DATE,
80 NEW_ACTIVE_START_DATE,
81 OLD_ACTIVE_END_DATE,
82 NEW_ACTIVE_END_DATE
83 ) VALUES (
84 px_INSTANCE_ASSET_HISTORY_ID,
85 decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ASSET_ID),
86 decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
87 decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_ID),
88 decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_ID),
89 decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_ASSET_ID),
90 decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_ASSET_ID),
91 decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_ASSET_QUANTITY),
92 decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_ASSET_QUANTITY),
93 decode( p_OLD_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_BOOK_TYPE_CODE),
94 decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_BOOK_TYPE_CODE),
95 decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_LOCATION_ID),
96 decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_LOCATION_ID),
97 decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_UPDATE_STATUS),
98 decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_UPDATE_STATUS),
99 decode( p_OLD_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_FA_SYNC_FLAG),
100 decode( p_NEW_FA_SYNC_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_FA_SYNC_FLAG),
101 decode( p_OLD_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_FA_MASS_ADDITION_ID),
102 decode( p_NEW_FA_MASS_ADDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_FA_MASS_ADDITION_ID),
103 decode( p_OLD_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_OLD_CREATION_COMPLETE_FLAG),
104 decode( p_NEW_CREATION_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_NEW_CREATION_COMPLETE_FLAG),
105 decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
106 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
107 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
108 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
109 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
110 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
111 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
112 decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
113 decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
114 decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
115 decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE));
116 End Insert_Row;
117
118 PROCEDURE Update_Row(
119 p_INSTANCE_ASSET_HISTORY_ID NUMBER,
120 p_INSTANCE_ASSET_ID NUMBER,
121 p_TRANSACTION_ID NUMBER,
122 p_OLD_INSTANCE_ID NUMBER,
123 p_NEW_INSTANCE_ID NUMBER,
124 p_OLD_FA_ASSET_ID NUMBER,
125 p_NEW_FA_ASSET_ID NUMBER,
126 p_OLD_ASSET_QUANTITY NUMBER,
127 p_NEW_ASSET_QUANTITY NUMBER,
128 p_OLD_FA_BOOK_TYPE_CODE VARCHAR2,
129 p_NEW_FA_BOOK_TYPE_CODE VARCHAR2,
130 p_OLD_FA_LOCATION_ID NUMBER,
131 p_NEW_FA_LOCATION_ID NUMBER,
132 p_OLD_UPDATE_STATUS VARCHAR2,
133 p_NEW_UPDATE_STATUS VARCHAR2,
134 p_OLD_FA_SYNC_FLAG VARCHAR2,
135 p_NEW_FA_SYNC_FLAG VARCHAR2,
136 p_OLD_FA_MASS_ADDITION_ID NUMBER,
137 p_NEW_FA_MASS_ADDITION_ID NUMBER,
138 p_OLD_CREATION_COMPLETE_FLAG VARCHAR2,
139 p_NEW_CREATION_COMPLETE_FLAG VARCHAR2,
140 p_FULL_DUMP_FLAG VARCHAR2,
141 p_CREATED_BY NUMBER,
142 p_CREATION_DATE DATE,
143 p_LAST_UPDATED_BY NUMBER,
144 p_LAST_UPDATE_DATE DATE,
145 p_LAST_UPDATE_LOGIN NUMBER,
146 p_OBJECT_VERSION_NUMBER NUMBER,
147 p_OLD_ACTIVE_START_DATE DATE,
148 p_NEW_ACTIVE_START_DATE DATE,
149 p_OLD_ACTIVE_END_DATE DATE,
150 p_NEW_ACTIVE_END_DATE DATE)
151
152 IS
153 BEGIN
154 Update CSI_I_ASSETS_H
155 SET INSTANCE_ASSET_ID =
156 decode( p_INSTANCE_ASSET_ID, FND_API.G_MISS_NUM, INSTANCE_ASSET_ID, p_INSTANCE_ASSET_ID),
157 TRANSACTION_ID =
158 decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
159 OLD_INSTANCE_ID =
160 decode( p_OLD_INSTANCE_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_ID, p_OLD_INSTANCE_ID),
161 NEW_INSTANCE_ID =
162 decode( p_NEW_INSTANCE_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_ID, p_NEW_INSTANCE_ID),
163 OLD_FA_ASSET_ID =
164 decode( p_OLD_FA_ASSET_ID, FND_API.G_MISS_NUM, OLD_FA_ASSET_ID, p_OLD_FA_ASSET_ID),
165 NEW_FA_ASSET_ID =
166 decode( p_NEW_FA_ASSET_ID, FND_API.G_MISS_NUM, NEW_FA_ASSET_ID, p_NEW_FA_ASSET_ID),
167 OLD_ASSET_QUANTITY =
168 decode( p_OLD_ASSET_QUANTITY, FND_API.G_MISS_NUM, OLD_ASSET_QUANTITY, p_OLD_ASSET_QUANTITY),
169 NEW_ASSET_QUANTITY =
170 decode( p_NEW_ASSET_QUANTITY, FND_API.G_MISS_NUM, NEW_ASSET_QUANTITY, p_NEW_ASSET_QUANTITY),
171 OLD_FA_BOOK_TYPE_CODE =
172 decode(p_OLD_FA_BOOK_TYPE_CODE,FND_API.G_MISS_CHAR,OLD_FA_BOOK_TYPE_CODE,p_OLD_FA_BOOK_TYPE_CODE),
173 NEW_FA_BOOK_TYPE_CODE =
174 decode( p_NEW_FA_BOOK_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_FA_BOOK_TYPE_CODE, p_NEW_FA_BOOK_TYPE_CODE),
175 OLD_FA_LOCATION_ID =
176 decode( p_OLD_FA_LOCATION_ID, FND_API.G_MISS_NUM, OLD_FA_LOCATION_ID, p_OLD_FA_LOCATION_ID),
177 NEW_FA_LOCATION_ID =
178 decode( p_NEW_FA_LOCATION_ID, FND_API.G_MISS_NUM, NEW_FA_LOCATION_ID, p_NEW_FA_LOCATION_ID),
179 OLD_UPDATE_STATUS =
180 decode( p_OLD_UPDATE_STATUS, FND_API.G_MISS_CHAR, OLD_UPDATE_STATUS, p_OLD_UPDATE_STATUS),
181 NEW_UPDATE_STATUS =
182 decode( p_NEW_UPDATE_STATUS, FND_API.G_MISS_CHAR, NEW_UPDATE_STATUS, p_NEW_UPDATE_STATUS),
183 OLD_FA_SYNC_FLAG =
184 decode(p_old_fa_sync_flag, FND_API.g_miss_char, old_fa_sync_flag, p_old_fa_sync_flag),
185 NEW_FA_SYNC_FLAG =
186 decode(p_new_fa_sync_flag, FND_API.g_miss_char, new_fa_sync_flag, p_new_fa_sync_flag),
187 OLD_FA_MASS_ADDITION_ID =
188 decode(p_old_fa_mass_addition_id, FND_API.g_miss_num, old_fa_mass_addition_id, p_old_fa_mass_addition_id),
189 NEW_FA_MASS_ADDITION_ID =
190 decode(p_new_fa_mass_addition_id, FND_API.g_miss_num, new_fa_mass_addition_id, p_new_fa_mass_addition_id),
191 OLD_CREATION_COMPLETE_FLAG =
192 decode(p_old_CREATION_COMPLETE_flag, FND_API.g_miss_char, old_CREATION_COMPLETE_flag, p_old_CREATION_COMPLETE_flag),
193 NEW_CREATION_COMPLETE_FLAG =
194 decode(p_new_CREATION_COMPLETE_flag, FND_API.g_miss_char, new_CREATION_COMPLETE_flag, p_new_CREATION_COMPLETE_flag),
195 FULL_DUMP_FLAG =
196 decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
197 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
198 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
199 LAST_UPDATED_BY =
200 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
201 LAST_UPDATE_DATE =
202 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
203 LAST_UPDATE_LOGIN =
204 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
205 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
206 OLD_ACTIVE_START_DATE =
207 decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
208 NEW_ACTIVE_START_DATE =
209 decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
210 OLD_ACTIVE_END_DATE =
211 decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
212 NEW_ACTIVE_END_DATE =
213 decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE)
214 WHERE INSTANCE_ASSET_HISTORY_ID = p_INSTANCE_ASSET_HISTORY_ID;
215
216 If (SQL%NOTFOUND) then
217 RAISE NO_DATA_FOUND;
218 End If;
219 END Update_Row;
220
221 PROCEDURE Delete_Row(
222 p_INSTANCE_ASSET_HISTORY_ID NUMBER)
223 IS
224 BEGIN
225 DELETE FROM CSI_I_ASSETS_H
226 WHERE INSTANCE_ASSET_HISTORY_ID = p_INSTANCE_ASSET_HISTORY_ID;
227 If (SQL%NOTFOUND) then
228 RAISE NO_DATA_FOUND;
229 End If;
230 END Delete_Row;
231
232 PROCEDURE Lock_Row(
233 p_INSTANCE_ASSET_HISTORY_ID NUMBER,
234 p_INSTANCE_ASSET_ID NUMBER,
235 p_TRANSACTION_ID NUMBER,
236 p_OLD_INSTANCE_ID NUMBER,
237 p_NEW_INSTANCE_ID NUMBER,
238 p_OLD_FA_ASSET_ID NUMBER,
239 p_NEW_FA_ASSET_ID NUMBER,
240 p_OLD_ASSET_QUANTITY NUMBER,
241 p_NEW_ASSET_QUANTITY NUMBER,
242 p_OLD_FA_BOOK_TYPE_CODE VARCHAR2,
243 p_NEW_FA_BOOK_TYPE_CODE VARCHAR2,
244 p_OLD_FA_LOCATION_ID NUMBER,
245 p_NEW_FA_LOCATION_ID NUMBER,
246 p_OLD_UPDATE_STATUS VARCHAR2,
247 p_NEW_UPDATE_STATUS VARCHAR2,
248 p_OLD_FA_SYNC_FLAG VARCHAR2,
249 p_NEW_FA_SYNC_FLAG VARCHAR2,
250 p_OLD_FA_MASS_ADDITION_ID NUMBER,
251 p_NEW_FA_MASS_ADDITION_ID NUMBER,
252 p_OLD_CREATION_COMPLETE_FLAG VARCHAR2,
253 p_NEW_CREATION_COMPLETE_FLAG VARCHAR2,
254 p_FULL_DUMP_FLAG VARCHAR2,
255 p_CREATED_BY NUMBER,
256 p_CREATION_DATE DATE,
257 p_LAST_UPDATED_BY NUMBER,
258 p_LAST_UPDATE_DATE DATE,
259 p_LAST_UPDATE_LOGIN NUMBER,
260 p_OBJECT_VERSION_NUMBER NUMBER,
261 p_OLD_ACTIVE_START_DATE DATE,
262 p_NEW_ACTIVE_START_DATE DATE,
263 p_OLD_ACTIVE_END_DATE DATE,
264 p_NEW_ACTIVE_END_DATE DATE)
265
266 IS
267 CURSOR C IS
268 SELECT *
269 FROM CSI_I_ASSETS_H
270 WHERE INSTANCE_ASSET_HISTORY_ID = p_INSTANCE_ASSET_HISTORY_ID
271 FOR UPDATE of INSTANCE_ASSET_HISTORY_ID NOWAIT;
272 Recinfo C%ROWTYPE;
273 BEGIN
274 OPEN C;
275 FETCH C INTO Recinfo;
276 If (C%NOTFOUND) then
277 CLOSE C;
278 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
279 APP_EXCEPTION.RAISE_EXCEPTION;
280 End If;
281 CLOSE C;
282 if (
283 ( Recinfo.INSTANCE_ASSET_HISTORY_ID = p_INSTANCE_ASSET_HISTORY_ID)
284 AND ( ( Recinfo.INSTANCE_ASSET_ID = p_INSTANCE_ASSET_ID)
285 OR ( ( Recinfo.INSTANCE_ASSET_ID IS NULL )
286 AND ( p_INSTANCE_ASSET_ID IS NULL )))
287 AND ( ( Recinfo.TRANSACTION_ID = p_TRANSACTION_ID)
291 OR ( ( Recinfo.OLD_INSTANCE_ID IS NULL )
288 OR ( ( Recinfo.TRANSACTION_ID IS NULL )
289 AND ( p_TRANSACTION_ID IS NULL )))
290 AND ( ( Recinfo.OLD_INSTANCE_ID = p_OLD_INSTANCE_ID)
292 AND ( p_OLD_INSTANCE_ID IS NULL )))
293 AND ( ( Recinfo.NEW_INSTANCE_ID = p_NEW_INSTANCE_ID)
294 OR ( ( Recinfo.NEW_INSTANCE_ID IS NULL )
295 AND ( p_NEW_INSTANCE_ID IS NULL )))
296 AND ( ( Recinfo.OLD_FA_ASSET_ID = p_OLD_FA_ASSET_ID)
297 OR ( ( Recinfo.OLD_FA_ASSET_ID IS NULL )
298 AND ( p_OLD_FA_ASSET_ID IS NULL )))
299 AND ( ( Recinfo.NEW_FA_ASSET_ID = p_NEW_FA_ASSET_ID)
300 OR ( ( Recinfo.NEW_FA_ASSET_ID IS NULL )
301 AND ( p_NEW_FA_ASSET_ID IS NULL )))
302 AND ( ( Recinfo.OLD_ASSET_QUANTITY = p_OLD_ASSET_QUANTITY)
303 OR ( ( Recinfo.OLD_ASSET_QUANTITY IS NULL )
304 AND ( p_OLD_ASSET_QUANTITY IS NULL )))
305 AND ( ( Recinfo.NEW_ASSET_QUANTITY = p_NEW_ASSET_QUANTITY)
306 OR ( ( Recinfo.NEW_ASSET_QUANTITY IS NULL )
307 AND ( p_NEW_ASSET_QUANTITY IS NULL )))
308 AND ( ( Recinfo.OLD_FA_BOOK_TYPE_CODE = p_OLD_FA_BOOK_TYPE_CODE)
309 OR ( ( Recinfo.OLD_FA_BOOK_TYPE_CODE IS NULL )
310 AND ( p_OLD_FA_BOOK_TYPE_CODE IS NULL )))
311 AND ( ( Recinfo.NEW_FA_BOOK_TYPE_CODE = p_NEW_FA_BOOK_TYPE_CODE)
312 OR ( ( Recinfo.NEW_FA_BOOK_TYPE_CODE IS NULL )
313 AND ( p_NEW_FA_BOOK_TYPE_CODE IS NULL )))
314 AND ( ( Recinfo.OLD_FA_LOCATION_ID = p_OLD_FA_LOCATION_ID)
315 OR ( ( Recinfo.OLD_FA_LOCATION_ID IS NULL )
316 AND ( p_OLD_FA_LOCATION_ID IS NULL )))
317 AND ( ( Recinfo.NEW_FA_LOCATION_ID = p_NEW_FA_LOCATION_ID)
318 OR ( ( Recinfo.NEW_FA_LOCATION_ID IS NULL )
319 AND ( p_NEW_FA_LOCATION_ID IS NULL )))
320 AND ( ( Recinfo.OLD_UPDATE_STATUS = p_OLD_UPDATE_STATUS)
321 OR ( ( Recinfo.OLD_UPDATE_STATUS IS NULL )
322 AND ( p_OLD_UPDATE_STATUS IS NULL )))
323 AND ( ( Recinfo.NEW_UPDATE_STATUS = p_NEW_UPDATE_STATUS)
324 OR ( ( Recinfo.NEW_UPDATE_STATUS IS NULL )
325 AND ( p_NEW_UPDATE_STATUS IS NULL )))
326 AND ( ( Recinfo.FULL_DUMP_FLAG = p_FULL_DUMP_FLAG)
327 OR ( ( Recinfo.FULL_DUMP_FLAG IS NULL )
328 AND ( p_FULL_DUMP_FLAG IS NULL )))
329 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
330 OR ( ( Recinfo.CREATED_BY IS NULL )
331 AND ( p_CREATED_BY IS NULL )))
332 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
333 OR ( ( Recinfo.CREATION_DATE IS NULL )
334 AND ( p_CREATION_DATE IS NULL )))
335 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
336 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
337 AND ( p_LAST_UPDATED_BY IS NULL )))
338 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
339 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
340 AND ( p_LAST_UPDATE_DATE IS NULL )))
341 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
342 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
343 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
344 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
345 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
346 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
347 AND ( ( Recinfo.OLD_ACTIVE_START_DATE = p_OLD_ACTIVE_START_DATE)
348 OR ( ( Recinfo.OLD_ACTIVE_START_DATE IS NULL )
349 AND ( p_OLD_ACTIVE_START_DATE IS NULL )))
350 AND ( ( Recinfo.NEW_ACTIVE_START_DATE = p_NEW_ACTIVE_START_DATE)
351 OR ( ( Recinfo.NEW_ACTIVE_START_DATE IS NULL )
352 AND ( p_NEW_ACTIVE_START_DATE IS NULL )))
353 AND ( ( Recinfo.OLD_ACTIVE_END_DATE = p_OLD_ACTIVE_END_DATE)
354 OR ( ( Recinfo.OLD_ACTIVE_END_DATE IS NULL )
355 AND ( p_OLD_ACTIVE_END_DATE IS NULL )))
356 AND ( ( Recinfo.NEW_ACTIVE_END_DATE = p_NEW_ACTIVE_END_DATE)
357 OR ( ( Recinfo.NEW_ACTIVE_END_DATE IS NULL )
358 AND ( p_NEW_ACTIVE_END_DATE IS NULL )))
359 ) then
360 return;
361 else
362 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
363 APP_EXCEPTION.RAISE_EXCEPTION;
364 End If;
365 END Lock_Row;
366
367 End CSI_I_ASSETS_H_PKG;
368