[Home] [Help]
PACKAGE BODY: APPS.CSI_TRANSACTIONS_PKG
Source
1 PACKAGE BODY csi_transactions_pkg AS
2 /* $Header: csittrxb.pls 120.1 2005/07/06 18:47:58 sguthiva noship $ */
3 -- start of comments
4 -- package name : csi_transactions_pkg
5 -- purpose :
6 -- history :
7 -- note :
8 -- end of comments
9
10
11 g_pkg_name CONSTANT VARCHAR2(30):= 'csi_transactions_pkg';
12 g_file_name CONSTANT VARCHAR2(12) := 'csittrxb.pls';
13
14 /* ---------------------------------------------------------------------------------- */
15 /* --- this PROCEDURE is used to insert the record INTO csi_transactions table. --- */
16 /* ---------------------------------------------------------------------------------- */
17
18 PROCEDURE insert_row(
19 px_transaction_id IN OUT NOCOPY NUMBER ,
20 p_transaction_date DATE ,
21 p_source_transaction_date DATE ,
22 p_transaction_type_id NUMBER ,
23 p_txn_sub_type_id NUMBER ,
24 p_source_group_ref_id NUMBER ,
25 p_source_group_ref VARCHAR2,
26 p_source_header_ref_id NUMBER ,
27 p_source_header_ref VARCHAR2,
28 p_source_line_ref_id NUMBER ,
29 p_source_line_ref VARCHAR2,
30 p_source_dist_ref_id1 NUMBER ,
31 p_source_dist_ref_id2 NUMBER ,
32 p_inv_material_transaction_id NUMBER ,
33 p_transaction_quantity NUMBER ,
34 p_transaction_uom_code VARCHAR2,
35 p_transacted_by NUMBER ,
36 p_transaction_status_code VARCHAR2,
37 p_transaction_action_code VARCHAR2,
38 p_message_id NUMBER ,
39 p_context VARCHAR2,
40 p_attribute1 VARCHAR2,
41 p_attribute2 VARCHAR2,
42 p_attribute3 VARCHAR2,
43 p_attribute4 VARCHAR2,
44 p_attribute5 VARCHAR2,
45 p_attribute6 VARCHAR2,
46 p_attribute7 VARCHAR2,
47 p_attribute8 VARCHAR2,
48 p_attribute9 VARCHAR2,
49 p_attribute10 VARCHAR2,
50 p_attribute11 VARCHAR2,
51 p_attribute12 VARCHAR2,
52 p_attribute13 VARCHAR2,
53 p_attribute14 VARCHAR2,
54 p_attribute15 VARCHAR2,
55 p_created_by NUMBER ,
56 p_creation_date DATE ,
57 p_last_updated_by NUMBER ,
58 p_last_update_date DATE ,
59 p_last_update_login NUMBER ,
60 p_object_version_number NUMBER ,
61 p_split_reason_code VARCHAR2,
62 p_gl_interface_status_code NUMBER )
63
64 IS
65 CURSOR c2 IS SELECT csi_transactions_s.nextval FROM sys.dual;
66 BEGIN
67 IF (px_transaction_id IS NULL) or (px_transaction_id = fnd_api.g_miss_num) THEN
68 OPEN c2;
69 FETCH c2 INTO px_transaction_id;
70 CLOSE c2;
71 END IF;
72
73
74 insert INTO csi_transactions(
75 transaction_id,
76 transaction_date,
77 source_transaction_date,
78 transaction_type_id,
79 txn_sub_type_id,
80 source_group_ref_id,
81 source_group_ref,
82 source_header_ref_id,
83 source_header_ref,
84 source_line_ref_id,
85 source_line_ref,
86 source_dist_ref_id1,
87 source_dist_ref_id2,
88 inv_material_transaction_id,
89 transaction_quantity,
90 transaction_uom_code,
91 transacted_by,
92 transaction_status_code,
93 transaction_action_code,
94 message_id,
95 context,
96 attribute1,
97 attribute2,
98 attribute3,
99 attribute4,
100 attribute5,
101 attribute6,
102 attribute7,
103 attribute8,
104 attribute9,
105 attribute10,
106 attribute11,
107 attribute12,
108 attribute13,
109 attribute14,
110 attribute15,
111 created_by,
112 creation_date,
113 last_updated_by,
114 last_update_date,
115 last_update_login,
116 object_version_number,
117 split_reason_code,
118 gl_interface_status_code
119 ) values (
120 px_transaction_id,
121 decode( p_transaction_date, fnd_api.g_miss_date, to_date(null), p_transaction_date),
122 decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),
123 decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124 decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125 decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126 decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127 decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128 decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129 decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130 decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131 decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132 decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133 decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134 decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135 decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136 decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137 decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138 decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139 decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140 decode( p_context, fnd_api.g_miss_char, null, p_context),
141 decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142 decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143 decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144 decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145 decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146 decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147 decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148 decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149 decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150 decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151 decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152 decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153 decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154 decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155 decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156 decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157 decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158 decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159 decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160 decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161 decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),
162 decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),
163 decode( p_gl_interface_status_code, fnd_api.g_miss_num, null, p_gl_interface_status_code)
164 );
165
166 -- commit;
167 end insert_row;
168
169 /* ---------------------------------------------------------------------------------- */
170 /* --- this procedure is used to update the record into csi_transactions table. --- */
171 /* ---------------------------------------------------------------------------------- */
172
173 PROCEDURE update_row(
174 p_transaction_id NUMBER := fnd_api.g_miss_num ,
175 p_transaction_date DATE := fnd_api.g_miss_date,
176 p_source_transaction_date DATE := fnd_api.g_miss_date,
177 p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178 p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179 p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180 p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181 p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182 p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183 p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184 p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185 p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186 p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187 p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188 p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189 p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190 p_transacted_by NUMBER := fnd_api.g_miss_num ,
191 p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192 p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193 p_message_id NUMBER := fnd_api.g_miss_num ,
194 p_context VARCHAR2 := fnd_api.g_miss_char,
195 p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196 p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197 p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198 p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199 p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200 p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201 p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202 p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203 p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204 p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205 p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206 p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207 p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208 p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209 p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210 p_created_by NUMBER := fnd_api.g_miss_num ,
211 p_creation_date DATE := fnd_api.g_miss_date,
212 p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213 p_last_update_date DATE := fnd_api.g_miss_date,
214 p_last_update_login NUMBER := fnd_api.g_miss_num ,
215 p_object_version_number NUMBER := fnd_api.g_miss_num ,
216 p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
217 p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
218 )
219 is
220 BEGIN
221 update csi_transactions
222 set
223 transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),
224 source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225 transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226 txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227 source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228 source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229 source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230 source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231 source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232 source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233 source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234 source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235 inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236 transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237 transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238 transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239 transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240 transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241 message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242 context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243 attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244 attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245 attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246 attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247 attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248 attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249 attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250 attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251 attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252 attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253 attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254 attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255 attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256 attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257 attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258 created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259 creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260 last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261 last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262 last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263 object_version_number = object_version_number+1,
267
264 --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),
265 split_reason_code = decode( p_split_reason_code, fnd_api.g_miss_char, split_reason_code, p_split_reason_code),
266 gl_interface_status_code = decode( p_gl_interface_status_code, fnd_api.g_miss_num, gl_interface_status_code, p_gl_interface_status_code)
268 WHERE transaction_id = p_transaction_id;
269
270 IF (SQL%NOTFOUND) THEN
271 RAISE NO_DATA_FOUND;
272 END IF;
273 --commit;
274 end update_row;
275
276 /*
277 PROCEDURE delete_row(
278 p_transaction_id NUMBER)
279 is
280 BEGIN
281 delete FROM csi_transactions
282 WHERE transaction_id = p_transaction_id;
283 IF (SQL%NOTFOUND) THEN
284 raise no_data_found;
285 END IF;
286 end delete_row;
287
288 PROCEDURE lock_row(
289 p_transaction_id NUMBER,
290 p_transaction_date date,
291 p_source_transaction_date date,
292 p_transaction_type_id NUMBER,
293 p_source_group_ref_id NUMBER,
294 p_source_group_ref VARCHAR2,
295 p_source_header_ref_id NUMBER,
296 p_source_header_ref VARCHAR2,
297 p_source_line_ref_id NUMBER,
298 p_source_line_ref VARCHAR2,
299 p_source_dist_ref_id1 NUMBER,
300 p_source_dist_ref_id2 NUMBER,
301 p_inv_material_transaction_id NUMBER,
302 p_transaction_quantity NUMBER,
303 p_transaction_uom_code VARCHAR2,
304 p_transacted_by NUMBER,
305 p_transaction_status_code VARCHAR2,
306 p_transaction_action_code VARCHAR2,
307 p_message_id NUMBER,
308 p_context VARCHAR2,
309 p_attribute1 VARCHAR2,
310 p_attribute2 VARCHAR2,
311 p_attribute3 VARCHAR2,
312 p_attribute4 VARCHAR2,
313 p_attribute5 VARCHAR2,
314 p_attribute6 VARCHAR2,
315 p_attribute7 VARCHAR2,
316 p_attribute8 VARCHAR2,
317 p_attribute9 VARCHAR2,
318 p_attribute10 VARCHAR2,
319 p_attribute11 VARCHAR2,
320 p_attribute12 VARCHAR2,
321 p_attribute13 VARCHAR2,
322 p_attribute14 VARCHAR2,
323 p_attribute15 VARCHAR2,
324 p_created_by NUMBER,
325 p_creation_date date,
326 p_last_updated_by NUMBER,
327 p_last_update_date date,
328 p_last_update_login NUMBER,
329 p_object_version_NUMBER NUMBER,
330
331 is
332 CURSOR c is
333 SELECT *
334 FROM csi_transactions
335 WHERE transaction_id = p_transaction_id
336 for update of transaction_id nowait;
337 recinfo c%rowtype;
338 BEGIN
339 open c;
340 FETCH c INTO recinfo;
341 if (c%notfound) THEN
342 close c;
343 fnd_message.set_name('fnd', 'form_record_deleted');
344 app_exception.raise_exception;
345 END IF;
346 close c;
347 if (
348 ( recinfo.transaction_id = p_transaction_id)
349 AND ( ( recinfo.transaction_date = p_transaction_date)
350 or ( ( recinfo.transaction_date IS NULL )
351 AND ( p_transaction_date IS NULL )))
352 AND ( ( recinfo.source_transaction_date = p_source_transaction_date)
353 or ( ( recinfo.source_transaction_date IS NULL )
354 AND ( p_source_transaction_date IS NULL )))
355 AND ( ( recinfo.transaction_type_id = p_transaction_type_id)
356 or ( ( recinfo.transaction_type_id IS NULL )
357 AND ( p_transaction_type_id IS NULL )))
358 AND ( ( recinfo.source_group_ref_id = p_source_group_ref_id)
359 or ( ( recinfo.source_group_ref_id IS NULL )
360 AND ( p_source_group_ref_id IS NULL )))
361 AND ( ( recinfo.source_group_ref = p_source_group_ref)
362 or ( ( recinfo.source_group_ref IS NULL )
363 AND ( p_source_group_ref IS NULL )))
364 AND ( ( recinfo.source_header_ref_id = p_source_header_ref_id)
365 or ( ( recinfo.source_header_ref_id IS NULL )
366 AND ( p_source_header_ref_id IS NULL )))
367 AND ( ( recinfo.source_header_ref = p_source_header_ref)
368 or ( ( recinfo.source_header_ref IS NULL )
369 AND ( p_source_header_ref IS NULL )))
370 AND ( ( recinfo.source_line_ref_id = p_source_line_ref_id)
371 or ( ( recinfo.source_line_ref_id IS NULL )
372 AND ( p_source_line_ref_id IS NULL )))
373 AND ( ( recinfo.source_line_ref = p_source_line_ref)
374 or ( ( recinfo.source_line_ref IS NULL )
375 AND ( p_source_line_ref IS NULL )))
376 AND ( ( recinfo.source_dist_ref_id1 = p_source_dist_ref_id1)
377 or ( ( recinfo.source_dist_ref_id1 IS NULL )
378 AND ( p_source_dist_ref_id1 IS NULL )))
379 AND ( ( recinfo.source_dist_ref_id2 = p_source_dist_ref_id2)
380 or ( ( recinfo.source_dist_ref_id2 IS NULL )
381 AND ( p_source_dist_ref_id2 IS NULL )))
382 AND ( ( recinfo.inv_material_transaction_id = p_inv_material_transaction_id)
386 or ( ( recinfo.transaction_quantity IS NULL )
383 or ( ( recinfo.inv_material_transaction_id IS NULL )
384 AND ( p_inv_material_transaction_id IS NULL )))
385 AND ( ( recinfo.transaction_quantity = p_transaction_quantity)
387 AND ( p_transaction_quantity IS NULL )))
388 AND ( ( recinfo.transaction_uom_code = p_transaction_uom_code)
389 or ( ( recinfo.transaction_uom_code IS NULL )
390 AND ( p_transaction_uom_code IS NULL )))
391 AND ( ( recinfo.transacted_by = p_transacted_by)
392 or ( ( recinfo.transacted_by IS NULL )
393 AND ( p_transacted_by IS NULL )))
394 AND ( ( recinfo.transaction_status_code = p_transaction_status_code)
395 or ( ( recinfo.transaction_status_code IS NULL )
396 AND ( p_transaction_status_code IS NULL )))
397 AND ( ( recinfo.transaction_action_code = p_transaction_action_code)
398 or ( ( recinfo.transaction_action_code IS NULL )
399 AND ( p_transaction_action_code IS NULL )))
400 AND ( ( recinfo.message_id = p_message_id)
401 or ( ( recinfo.message_id IS NULL )
402 AND ( p_message_id IS NULL )))
403 AND ( ( recinfo.context = p_context)
404 or ( ( recinfo.context IS NULL )
405 AND ( p_context IS NULL )))
406 AND ( ( recinfo.attribute1 = p_attribute1)
407 or ( ( recinfo.attribute1 IS NULL )
408 AND ( p_attribute1 IS NULL )))
409 AND ( ( recinfo.attribute2 = p_attribute2)
410 or ( ( recinfo.attribute2 IS NULL )
411 AND ( p_attribute2 IS NULL )))
412 AND ( ( recinfo.attribute3 = p_attribute3)
413 or ( ( recinfo.attribute3 IS NULL )
414 AND ( p_attribute3 IS NULL )))
415 AND ( ( recinfo.attribute4 = p_attribute4)
416 or ( ( recinfo.attribute4 IS NULL )
417 AND ( p_attribute4 IS NULL )))
418 AND ( ( recinfo.attribute5 = p_attribute5)
419 or ( ( recinfo.attribute5 IS NULL )
420 AND ( p_attribute5 IS NULL )))
421 AND ( ( recinfo.attribute6 = p_attribute6)
422 or ( ( recinfo.attribute6 IS NULL )
423 AND ( p_attribute6 IS NULL )))
424 AND ( ( recinfo.attribute7 = p_attribute7)
425 or ( ( recinfo.attribute7 IS NULL )
426 AND ( p_attribute7 IS NULL )))
427 AND ( ( recinfo.attribute8 = p_attribute8)
428 or ( ( recinfo.attribute8 IS NULL )
429 AND ( p_attribute8 IS NULL )))
430 AND ( ( recinfo.attribute9 = p_attribute9)
431 or ( ( recinfo.attribute9 IS NULL )
432 AND ( p_attribute9 IS NULL )))
433 AND ( ( recinfo.attribute10 = p_attribute10)
434 or ( ( recinfo.attribute10 IS NULL )
435 AND ( p_attribute10 IS NULL )))
436 AND ( ( recinfo.attribute11 = p_attribute11)
437 or ( ( recinfo.attribute11 IS NULL )
438 AND ( p_attribute11 IS NULL )))
439 AND ( ( recinfo.attribute12 = p_attribute12)
440 or ( ( recinfo.attribute12 IS NULL )
441 AND ( p_attribute12 IS NULL )))
442 AND ( ( recinfo.attribute13 = p_attribute13)
443 or ( ( recinfo.attribute13 IS NULL )
444 AND ( p_attribute13 IS NULL )))
445 AND ( ( recinfo.attribute14 = p_attribute14)
446 or ( ( recinfo.attribute14 IS NULL )
447 AND ( p_attribute14 IS NULL )))
448 AND ( ( recinfo.attribute15 = p_attribute15)
449 or ( ( recinfo.attribute15 IS NULL )
450 AND ( p_attribute15 IS NULL )))
451 AND ( ( recinfo.created_by = p_created_by)
452 or ( ( recinfo.created_by IS NULL )
453 AND ( p_created_by IS NULL )))
454 AND ( ( recinfo.creation_date = p_creation_date)
455 or ( ( recinfo.creation_date IS NULL )
456 AND ( p_creation_date IS NULL )))
457 AND ( ( recinfo.last_updated_by = p_last_updated_by)
458 or ( ( recinfo.last_updated_by IS NULL )
459 AND ( p_last_updated_by IS NULL )))
460 AND ( ( recinfo.last_update_date = p_last_update_date)
461 or ( ( recinfo.last_update_date IS NULL )
462 AND ( p_last_update_date IS NULL )))
463 AND ( ( recinfo.last_update_login = p_last_update_login)
464 or ( ( recinfo.last_update_login IS NULL )
465 AND ( p_last_update_login IS NULL )))
466 AND ( ( recinfo.object_version_NUMBER = p_object_version_NUMBER)
467 or ( ( recinfo.object_version_NUMBER IS NULL )
468 AND ( p_object_version_NUMBER IS NULL )))
469 ) THEN
470 return;
471 ELSE
472 fnd_message.set_name('fnd', 'form_record_changed');
473 app_exception.raise_exception;
474 END IF;
475 end lock_row;
476 */
477 END csi_transactions_pkg;