[Home] [Help]
PACKAGE BODY: APPS.CE_STAT_HDRS_DML_PKG
Source
1 PACKAGE BODY CE_STAT_HDRS_DML_PKG as
2 /* $Header: cesththb.pls 120.9.12000000.2 2007/07/27 10:41:46 csutaria ship $ */
3
4 G_action_flag varchar2(2);
5 G_xtr_company_code varchar2(100);
6 G_xtr_acct_number varchar2(100);
7
8
9 FUNCTION body_revision RETURN VARCHAR2 IS
10 BEGIN
11
12 RETURN '$Revision: 120.9.12000000.2 $';
13
14 END body_revision;
15
16 FUNCTION spec_revision RETURN VARCHAR2 IS
17 BEGIN
18
19 RETURN G_spec_revision;
20
21 END spec_revision;
22
23 PROCEDURE Insert_Row(
24 X_rowid IN OUT NOCOPY VARCHAR2,
25 X_statement_header_id IN OUT NOCOPY NUMBER,
26 X_bank_account_id NUMBER,
27 X_statement_number VARCHAR2,
28 X_statement_date DATE,
29 X_check_digits VARCHAR2,
30 X_control_begin_balance NUMBER,
31 X_control_end_balance NUMBER,
32 X_cashflow_balance NUMBER,
33 X_int_calc_balance NUMBER,
34 X_one_day_float NUMBER,
35 X_two_day_float NUMBER,
36 X_control_total_dr NUMBER,
37 X_control_total_cr NUMBER,
38 X_control_dr_line_count NUMBER,
39 X_control_cr_line_count NUMBER,
40 X_doc_sequence_id NUMBER,
41 X_doc_sequence_value NUMBER,
42 X_created_by NUMBER,
43 X_creation_date DATE,
44 X_last_updated_by NUMBER,
45 X_last_update_date DATE,
46 X_attribute_category VARCHAR2,
47 X_attribute1 VARCHAR2,
48 X_attribute2 VARCHAR2,
49 X_attribute3 VARCHAR2,
50 X_attribute4 VARCHAR2,
51 X_attribute5 VARCHAR2,
52 X_attribute6 VARCHAR2,
53 X_attribute7 VARCHAR2,
54 X_attribute8 VARCHAR2,
55 X_attribute9 VARCHAR2,
56 X_attribute10 VARCHAR2,
57 X_attribute11 VARCHAR2,
58 X_attribute12 VARCHAR2,
59 X_attribute13 VARCHAR2,
60 X_attribute14 VARCHAR2,
61 X_attribute15 VARCHAR2,
62 X_auto_loaded_flag VARCHAR2,
63 X_statement_complete_flag VARCHAR2,
64 X_gl_date DATE,
65 X_balance_flag VARCHAR2 DEFAULT 'N',
66 X_average_close_ledger_mtd NUMBER DEFAULT NULL,
67 X_average_close_ledger_ytd NUMBER DEFAULT NULL,
68 X_average_close_available_mtd NUMBER DEFAULT NULL,
69 X_average_close_available_ytd NUMBER DEFAULT NULL,
70 X_bank_acct_balance_id NUMBER DEFAULT NULL,
71 -- 5916290: GDF Changes
72 X_global_att_category VARCHAR2,
73 X_global_attribute1 VARCHAR2,
74 X_global_attribute2 VARCHAR2,
75 X_global_attribute3 VARCHAR2,
76 X_global_attribute4 VARCHAR2,
77 X_global_attribute5 VARCHAR2,
78 X_global_attribute6 VARCHAR2,
79 X_global_attribute7 VARCHAR2,
80 X_global_attribute8 VARCHAR2,
81 X_global_attribute9 VARCHAR2,
82 X_global_attribute10 VARCHAR2,
83 X_global_attribute11 VARCHAR2,
84 X_global_attribute12 VARCHAR2,
85 X_global_attribute13 VARCHAR2,
86 X_global_attribute14 VARCHAR2,
87 X_global_attribute15 VARCHAR2,
88 X_global_attribute16 VARCHAR2,
89 X_global_attribute17 VARCHAR2,
90 X_global_attribute18 VARCHAR2,
91 X_global_attribute19 VARCHAR2,
92 X_global_attribute20 VARCHAR2
93 ) IS
94 p_bank_acct_balance_id number;
95 p_xtr_val boolean;
96 CURSOR C IS SELECT rowid
97 FROM CE_STATEMENT_HEADERS
98 WHERE statement_header_id = X_Statement_Header_Id;
99 CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;
100 CURSOR C3 IS SELECT CE_BANK_ACCT_BALANCES_S.nextval FROM SYS.dual;
101 BEGIN
102 IF (X_statement_header_id IS NULL) THEN
103 OPEN C2;
104 FETCH C2 INTO X_statement_header_id;
105 CLOSE C2;
106 END IF;
107 INSERT INTO CE_STATEMENT_HEADERS (
108 statement_header_id,
109 bank_account_id,
110 statement_number,
111 statement_date,
112 check_digits,
113 control_begin_balance,
114 control_end_balance,
115 cashflow_balance,
116 int_calc_balance,
117 one_day_float,
118 two_day_float,
119 control_total_dr,
120 control_total_cr,
121 control_dr_line_count,
122 control_cr_line_count,
123 doc_sequence_id,
124 doc_sequence_value,
125 created_by,
126 creation_date,
127 last_updated_by,
128 last_update_date,
129 attribute_category,
130 attribute1,
131 attribute2,
132 attribute3,
133 attribute4,
134 attribute5,
135 attribute6,
136 attribute7,
137 attribute8,
138 attribute9,
139 attribute10,
140 attribute11,
141 attribute12,
142 attribute13,
143 attribute14,
144 attribute15,
145 auto_loaded_flag,
146 statement_complete_flag,
147 gl_date,
148 -- 5916290: GDF Changes
149 global_attribute_category,
150 global_attribute1,
151 global_attribute2,
152 global_attribute3,
153 global_attribute4,
154 global_attribute5,
155 global_attribute6,
156 global_attribute7,
157 global_attribute8,
158 global_attribute9,
159 global_attribute10,
160 global_attribute11,
161 global_attribute12,
162 global_attribute13,
163 global_attribute14,
164 global_attribute15,
165 global_attribute16,
166 global_attribute17,
167 global_attribute18,
168 global_attribute19,
169 global_attribute20) VALUES
170 (X_statement_header_id,
171 X_bank_account_id,
172 X_statement_number,
173 X_statement_date,
174 X_check_digits,
175 X_control_begin_balance,
176 X_control_end_balance,
177 X_cashflow_balance,
178 X_int_calc_balance,
179 X_one_day_float,
180 X_two_day_float,
181 X_control_total_dr,
182 X_control_total_cr,
183 X_control_dr_line_count,
184 X_control_cr_line_count,
185 X_doc_sequence_id,
186 X_doc_sequence_value,
187 X_created_by,
188 X_creation_date,
189 X_last_updated_by,
190 X_last_update_date,
191 X_attribute_category,
192 X_attribute1,
193 X_attribute2,
194 X_attribute3,
195 X_attribute4,
196 X_attribute5,
197 X_attribute6,
198 X_attribute7,
199 X_attribute8,
200 X_attribute9,
201 X_attribute10,
202 X_attribute11,
203 X_attribute12,
204 X_attribute13,
205 X_attribute14,
206 X_attribute15,
207 X_auto_loaded_flag,
208 X_statement_complete_flag,
209 X_gl_date,
210 -- 5916290: GDF Changes
211 X_global_att_category,
212 X_global_attribute1,
213 X_global_attribute2,
214 X_global_attribute3,
215 X_global_attribute4,
216 X_global_attribute5,
217 X_global_attribute6,
218 X_global_attribute7,
219 X_global_attribute8,
220 X_global_attribute9,
221 X_global_attribute10,
222 X_global_attribute11,
223 X_global_attribute12,
224 X_global_attribute13,
225 X_global_attribute14,
226 X_global_attribute15,
227 X_global_attribute16,
228 X_global_attribute17,
229 X_global_attribute18,
230 X_global_attribute19,
231 X_global_attribute20);
232
233 IF X_balance_flag in ('N','NM') THEN
234 IF X_bank_acct_balance_id IS NULL THEN
235 OPEN C3;
236 FETCH C3 INTO p_bank_acct_balance_id;
237 CLOSE C3;
238 ELSE
239 p_bank_acct_balance_id := X_bank_acct_balance_id;
240 END IF;
241 --if ((p_xtr_val and x_balance_flag= 'N') or x_balance_flag = 'NM') then
242 INSERT INTO CE_BANK_ACCT_BALANCES
243 (bank_acct_balance_id,
244 bank_account_id,
245 balance_date,
246 ledger_balance,
247 available_balance,
248 value_dated_balance,
249 one_day_float,
250 two_day_float,
251 average_close_ledger_mtd,
252 average_close_ledger_ytd,
253 average_close_available_mtd,
254 average_close_available_ytd,
255 last_update_date,
256 last_updated_by,
257 creation_date,
258 created_by,
259 last_update_login,
260 object_version_number)
261 values
262 (p_bank_acct_balance_id,
263 X_bank_account_id,
264 X_statement_date,
265 X_control_end_balance,
266 X_cashflow_balance,
267 X_int_calc_balance,
268 X_one_day_float,
269 X_two_day_float,
270 X_average_close_ledger_mtd,
271 X_average_close_ledger_ytd,
272 X_average_close_available_mtd,
273 X_average_close_available_ytd,
274 X_last_update_date,
275 X_last_updated_by,
276 X_creation_date,
277 X_created_by,
278 X_last_updated_by,
279 '1');
280 --end if;
281 ELSIF X_balance_flag = 'YO' THEN
282 UPDATE CE_BANK_ACCT_BALANCES
283 SET
284 BALANCE_DATE = X_statement_date,
285 LEDGER_BALANCE = X_control_end_balance,
286 AVAILABLE_BALANCE = X_cashflow_balance,
287 VALUE_DATED_BALANCE = X_int_calc_balance,
288 ONE_DAY_FLOAT = X_one_day_float,
289 TWO_DAY_FLOAT = X_two_day_float,
290 LAST_UPDATE_DATE = X_last_update_date,
291 LAST_UPDATED_BY = X_last_updated_by,
292 LAST_UPDATE_LOGIN = X_last_updated_by
293 WHERE
294 BANK_ACCOUNT_ID = X_bank_account_id and
295 BALANCE_DATE = X_statement_date;
296 END IF;
297
298 OPEN C;
299 FETCH C INTO X_rowid;
300 IF (C%NOTFOUND) THEN
301 CLOSE C;
302 Raise NO_DATA_FOUND;
303 END IF;
304 CLOSE C;
305
306 END insert_row;
307
308 PROCEDURE Update_Row( X_Row_id VARCHAR2,
309 X_statement_header_id NUMBER,
310 X_statement_number VARCHAR2,
311 X_statement_date DATE,
312 X_check_digits VARCHAR2,
313 X_control_begin_balance NUMBER,
314 X_control_end_balance NUMBER,
315 X_cashflow_balance NUMBER,
316 X_int_calc_balance NUMBER,
317 X_one_day_float NUMBER,
318 X_two_day_float NUMBER,
319 X_control_total_dr NUMBER,
320 X_control_total_cr NUMBER,
321 X_control_dr_line_count NUMBER,
322 X_control_cr_line_count NUMBER,
323 X_doc_sequence_value NUMBER,
324 X_doc_sequence_id NUMBER,
325 X_last_updated_by NUMBER,
326 X_last_update_date DATE,
327 X_attribute_category VARCHAR2,
328 X_attribute1 VARCHAR2,
329 X_attribute2 VARCHAR2,
330 X_attribute3 VARCHAR2,
331 X_attribute4 VARCHAR2,
332 X_attribute5 VARCHAR2,
333 X_attribute6 VARCHAR2,
334 X_attribute7 VARCHAR2,
335 X_attribute8 VARCHAR2,
336 X_attribute9 VARCHAR2,
337 X_attribute10 VARCHAR2,
338 X_attribute11 VARCHAR2,
339 X_attribute12 VARCHAR2,
340 X_attribute13 VARCHAR2,
341 X_attribute14 VARCHAR2,
342 X_attribute15 VARCHAR2,
343 X_statement_complete_flag VARCHAR2,
344 X_gl_date DATE,
345 X_flag VARCHAR2,
346 -- 5916290: GDF Changes
347 X_global_att_category VARCHAR2,
348 X_global_attribute1 VARCHAR2,
349 X_global_attribute2 VARCHAR2,
350 X_global_attribute3 VARCHAR2,
351 X_global_attribute4 VARCHAR2,
352 X_global_attribute5 VARCHAR2,
353 X_global_attribute6 VARCHAR2,
354 X_global_attribute7 VARCHAR2,
355 X_global_attribute8 VARCHAR2,
356 X_global_attribute9 VARCHAR2,
360 X_global_attribute13 VARCHAR2,
357 X_global_attribute10 VARCHAR2,
358 X_global_attribute11 VARCHAR2,
359 X_global_attribute12 VARCHAR2,
361 X_global_attribute14 VARCHAR2,
362 X_global_attribute15 VARCHAR2,
363 X_global_attribute16 VARCHAR2,
364 X_global_attribute17 VARCHAR2,
365 X_global_attribute18 VARCHAR2,
366 X_global_attribute19 VARCHAR2,
367 X_global_attribute20 VARCHAR2
368 ) IS
369
370 X_bank_account_id NUMBER;
371 X_balance_date DATE;
372
373 BEGIN
374 --from headers_event.update_row to override x_flag will be YO
375 IF (x_flag = 'YO') THEN
376 BEGIN
377 SELECT BANK_ACCOUNT_ID,STATEMENT_DATE
378 INTO X_bank_account_id,X_Balance_Date
379 FROM CE_STATEMENT_HEADERS
380 WHERE STATEMENT_HEADER_ID = X_Statement_Header_Id;
381
382 UPDATE CE_BANK_ACCT_BALANCES
383 SET
384 BALANCE_DATE = X_statement_date,
385 LEDGER_BALANCE = X_control_end_balance,
386 AVAILABLE_BALANCE = X_cashflow_balance,
387 VALUE_DATED_BALANCE = X_int_calc_balance,
388 ONE_DAY_FLOAT = X_one_day_float,
389 TWO_DAY_FLOAT = X_two_day_float,
390 LAST_UPDATE_DATE = X_last_update_date,
391 LAST_UPDATED_BY = X_last_updated_by,
392 LAST_UPDATE_LOGIN = X_last_updated_by
393 WHERE
394 BANK_ACCOUNT_ID = X_Bank_Account_ID and
395 BALANCE_DATE = X_Balance_Date;
396 EXCEPTION
397 WHEN OTHERS THEN
398 NULL;
399 END;
400 END IF;
401
402 --
403 -- Standard ON-UPDATE routine
404 --
405 UPDATE CE_STATEMENT_HEADERS
406 SET
407 statement_header_id = X_statement_header_id,
408 statement_number = X_statement_number,
409 statement_date = X_statement_date,
410 check_digits = X_check_digits,
411 control_begin_balance = X_control_begin_balance,
412 control_end_balance = X_control_end_balance,
413 cashflow_balance = X_cashflow_balance,
414 int_calc_balance = X_int_calc_balance,
415 one_day_float = X_one_day_float,
416 two_day_float = X_two_day_float,
417 control_total_dr = X_control_total_dr,
418 control_total_cr = X_control_total_cr,
419 control_dr_line_count = X_control_dr_line_count,
420 control_cr_line_count = X_control_cr_line_count,
421 doc_sequence_value = X_doc_sequence_value,
422 doc_sequence_id = X_doc_sequence_id,
423 last_updated_by = X_last_updated_by,
424 last_update_date = X_last_update_date,
425 attribute_category = X_attribute_category,
426 attribute1 = X_attribute1,
427 attribute2 = X_attribute2,
428 attribute3 = X_attribute3,
429 attribute4 = X_attribute4,
430 attribute5 = X_attribute5,
431 attribute6 = X_attribute6,
432 attribute7 = X_attribute7,
433 attribute8 = X_attribute8,
434 attribute9 = X_attribute9,
435 attribute10 = X_attribute10,
436 attribute11 = X_attribute11,
437 attribute12 = X_attribute12,
438 attribute13 = X_attribute13,
439 attribute14 = X_attribute14,
440 attribute15 = X_attribute15,
441 statement_complete_flag = X_statement_complete_flag,
442 gl_date = X_gl_date,
443 -- 5916290: GDF Changes
444 global_attribute_category = X_global_att_category,
445 global_attribute1 = X_global_attribute1,
446 global_attribute2 = X_global_attribute2,
447 global_attribute3 = X_global_attribute3,
448 global_attribute4 = X_global_attribute4,
449 global_attribute5 = X_global_attribute5,
450 global_attribute6 = X_global_attribute6,
451 global_attribute7 = X_global_attribute7,
452 global_attribute8 = X_global_attribute8,
453 global_attribute9 = X_global_attribute9,
454 global_attribute10 = X_global_attribute10,
455 global_attribute11 = X_global_attribute11,
456 global_attribute12 = X_global_attribute12,
457 global_attribute13 = X_global_attribute13,
458 global_attribute14 = X_global_attribute14,
459 global_attribute15 = X_global_attribute15,
460 global_attribute16 = X_global_attribute16,
461 global_attribute17 = X_global_attribute17,
462 global_attribute18 = X_global_attribute18,
463 global_attribute19 = X_global_attribute19,
464 global_attribute20 = X_global_attribute20
465 WHERE rowid = X_Row_Id;
466
467 if (SQL%NOTFOUND) then
468 Raise NO_DATA_FOUND;
469 end if;
470 END update_row;
471
472 PROCEDURE Delete_Row( X_Row_id VARCHAR2 ) IS
473 X_bank_account_id NUMBER;
474 X_balance_date DATE;
475
476 BEGIN
477
478 /*BEGIN
479 SELECT BANK_ACCOUNT_ID,STATEMENT_DATE
480 INTO X_bank_account_id,X_balance_date
481 FROM CE_STATEMENT_HEADERS
482 WHERE rowid = X_Row_Id;
483
484 DELETE FROM CE_BANK_ACCT_BALANCES
488 WHEN OTHERS THEN
485 WHERE bank_account_id = X_bank_account_id
486 AND balance_date = X_balance_date;
487 EXCEPTION
489 NULL;
490 END;*/
491
492 DELETE FROM CE_STATEMENT_HEADERS
493 WHERE rowid = X_Row_Id;
494
495 if (SQL%NOTFOUND) then
496 Raise NO_DATA_FOUND;
497 end if;
498 END Delete_Row;
499
500 PROCEDURE Lock_Row( X_Row_id VARCHAR2,
501 X_statement_header_id NUMBER,
502 X_bank_account_id NUMBER,
503 X_statement_number VARCHAR2,
504 X_statement_date DATE,
505 X_check_digits VARCHAR2,
506 X_doc_sequence_id NUMBER,
507 X_doc_sequence_value NUMBER,
508 X_control_begin_balance NUMBER,
509 X_control_end_balance NUMBER,
510 X_cashflow_balance NUMBER,
511 X_int_calc_balance NUMBER,
512 X_one_day_float NUMBER,
513 X_two_day_float NUMBER,
514 X_control_total_dr NUMBER,
515 X_control_total_cr NUMBER,
516 X_control_dr_line_count NUMBER,
517 X_control_cr_line_count NUMBER,
518 X_attribute_category VARCHAR2,
519 X_attribute1 VARCHAR2,
520 X_attribute2 VARCHAR2,
521 X_attribute3 VARCHAR2,
522 X_attribute4 VARCHAR2,
523 X_attribute5 VARCHAR2,
524 X_attribute6 VARCHAR2,
525 X_attribute7 VARCHAR2,
526 X_attribute8 VARCHAR2,
527 X_attribute9 VARCHAR2,
528 X_attribute10 VARCHAR2,
529 X_attribute11 VARCHAR2,
530 X_attribute12 VARCHAR2,
531 X_attribute13 VARCHAR2,
532 X_attribute14 VARCHAR2,
533 X_attribute15 VARCHAR2,
534 X_auto_loaded_flag VARCHAR2,
535 X_statement_complete_flag VARCHAR2,
536 X_gl_date DATE,
537 -- 5916290: GDF Changes
538 X_global_att_category VARCHAR2,
539 X_global_attribute1 VARCHAR2,
540 X_global_attribute2 VARCHAR2,
541 X_global_attribute3 VARCHAR2,
542 X_global_attribute4 VARCHAR2,
543 X_global_attribute5 VARCHAR2,
544 X_global_attribute6 VARCHAR2,
545 X_global_attribute7 VARCHAR2,
546 X_global_attribute8 VARCHAR2,
547 X_global_attribute9 VARCHAR2,
548 X_global_attribute10 VARCHAR2,
549 X_global_attribute11 VARCHAR2,
550 X_global_attribute12 VARCHAR2,
551 X_global_attribute13 VARCHAR2,
552 X_global_attribute14 VARCHAR2,
553 X_global_attribute15 VARCHAR2,
554 X_global_attribute16 VARCHAR2,
555 X_global_attribute17 VARCHAR2,
556 X_global_attribute18 VARCHAR2,
557 X_global_attribute19 VARCHAR2,
558 X_global_attribute20 VARCHAR2
559 ) IS
560 CURSOR C IS
561 SELECT *
562 FROM CE_STATEMENT_HEADERS
563 WHERE rowid = X_Row_Id
564 FOR UPDATE of Statement_Header_Id NOWAIT;
565 Recinfo C%ROWTYPE;
566
567 /* CURSOR C1 IS
568 SELECT *
569 FROM CE_BANK_ACCT_BALANCES
570 WHERE BANK_ACCOUNT_ID = X_bank_account_id
571 AND BALANCE_DATE = X_statement_date
572 FOR UPDATE of BANK_ACCT_BALANCE_ID NOWAIT;
573 Recinfo1 C1%ROWTYPE;*/
574
575 BEGIN
576 OPEN C;
577 FETCH C INTO Recinfo;
578 IF (C%NOTFOUND) then
579 CLOSE C;
580 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
581 APP_EXCEPTION.raise_exception;
582 end if;
583 CLOSE C;
584 /* OPEN C1;
585 FETCH C1 INTO Recinfo1;
586 CLOSE C1;*/
587
588 IF (
589 ( ( (Recinfo.statement_header_id = X_statement_header_id )
590 OR ( (Recinfo.statement_header_id IS NULL)
591 AND (X_statement_header_id IS NULL))))
592 AND ( ( (Recinfo.bank_account_id = X_bank_account_id )
593 OR ( (Recinfo.bank_account_id IS NULL)
594 AND (X_bank_account_id IS NULL))))
595 AND ( ( (Recinfo.statement_number = X_statement_number )
596 OR ( (Recinfo.statement_number IS NULL)
597 AND (X_statement_number IS NULL))))
598 AND ( ( (Recinfo.statement_date = X_statement_date )
599 OR ( (Recinfo.statement_date IS NULL)
600 AND (X_statement_date IS NULL))))
601 AND ( ( (Recinfo.check_digits = X_check_digits )
602 OR ( (Recinfo.check_digits IS NULL)
603 AND (X_check_digits IS NULL))))
604 AND ( ( (Recinfo.doc_sequence_value = X_doc_sequence_value )
605 OR ( (Recinfo.doc_sequence_value IS NULL)
606 AND (X_doc_sequence_value IS NULL))))
607 AND ( ( (Recinfo.doc_sequence_id = X_doc_sequence_id )
608 OR ( (Recinfo.doc_sequence_id IS NULL)
609 AND (X_doc_sequence_id IS NULL))))
610 AND ( ( (Recinfo.control_begin_balance = X_control_begin_balance )
611 OR ( (Recinfo.control_begin_balance IS NULL)
615 AND (X_control_end_balance IS NULL))))
612 AND (X_control_begin_balance IS NULL))))
613 AND ( ( (Recinfo.control_end_balance = X_control_end_balance)
614 OR ( (Recinfo.control_end_balance IS NULL)
616 AND ( ( (Recinfo.cashflow_balance = X_cashflow_balance)
617 OR ( (Recinfo.cashflow_balance IS NULL)
618 AND (X_cashflow_balance IS NULL))))
619 AND ( ( (Recinfo.int_calc_balance = X_int_calc_balance)
620 OR ( (Recinfo.int_calc_balance IS NULL)
621 AND (X_int_calc_balance IS NULL))))
622 AND ( ( (Recinfo.one_day_float = X_one_day_float)
623 OR ( (Recinfo.one_day_float IS NULL)
624 AND (X_one_day_float IS NULL)))) -- bug 3927648
625 AND ( ( (Recinfo.two_day_float = X_two_day_float)
626 OR ( (Recinfo.two_day_float IS NULL)
627 AND (X_two_day_float IS NULL))))
628 AND ( ( (Recinfo.control_total_dr = X_control_total_dr )
629 OR ( (Recinfo.control_total_dr IS NULL)
630 AND (X_control_total_dr IS NULL))))
631 AND ( ( (Recinfo.control_total_cr = X_control_total_cr )
632 OR ( (Recinfo.control_total_cr IS NULL)
633 AND (X_control_total_cr IS NULL))))
634 AND ( ( (Recinfo.control_dr_line_count = X_control_dr_line_count )
635 OR ( (Recinfo.control_dr_line_count IS NULL)
636 AND (X_control_dr_line_count IS NULL))))
637 AND ( ( (Recinfo.control_cr_line_count = X_control_cr_line_count )
638 OR ( (Recinfo.control_cr_line_count IS NULL)
639 AND (X_control_cr_line_count IS NULL))))
640 AND ( ( (Recinfo.attribute_category = X_attribute_category )
641 OR ( (Recinfo.attribute_category IS NULL)
642 AND (X_attribute_category IS NULL))))
643 AND ( ( (Recinfo.attribute1 = X_attribute1 )
644 OR ( (Recinfo.attribute1 IS NULL)
645 AND (X_attribute1 IS NULL))))
646 AND ( ( (Recinfo.attribute2 = X_attribute2 )
647 OR ( (Recinfo.attribute2 IS NULL)
648 AND (X_attribute2 IS NULL))))
649 AND ( ( (Recinfo.attribute3 = X_attribute3 )
650 OR ( (Recinfo.attribute3 IS NULL)
651 AND (X_attribute3 IS NULL))))
652 AND ( ( (Recinfo.attribute4 = X_attribute4 )
653 OR ( (Recinfo.attribute4 IS NULL)
654 AND (X_attribute4 IS NULL))))
655 AND ( ( (Recinfo.attribute5 = X_attribute5 )
656 OR ( (Recinfo.attribute5 IS NULL)
657 AND (X_attribute5 IS NULL))))
658 AND ( ( (Recinfo.attribute6 = X_attribute6 )
659 OR ( (Recinfo.attribute6 IS NULL)
660 AND (X_attribute6 IS NULL))))
661 AND ( ( (Recinfo.attribute7 = X_attribute7 )
662 OR ( (Recinfo.attribute7 IS NULL)
663 AND (X_attribute7 IS NULL))))
664 AND ( ( (Recinfo.attribute8 = X_attribute8 )
665 OR ( (Recinfo.attribute8 IS NULL)
666 AND (X_attribute8 IS NULL))))
667 AND ( ( (Recinfo.attribute9 = X_attribute9 )
668 OR ( (Recinfo.attribute9 IS NULL)
669 AND (X_attribute9 IS NULL))))
670 AND ( ( (Recinfo.attribute10 = X_attribute10 )
671 OR ( (Recinfo.attribute10 IS NULL)
672 AND (X_attribute10 IS NULL))))
673 AND ( ( (Recinfo.attribute11 = X_attribute11 )
674 OR ( (Recinfo.attribute11 IS NULL)
675 AND (X_attribute11 IS NULL))))
676 AND ( ( (Recinfo.attribute12 = X_attribute12 )
677 OR ( (Recinfo.attribute12 IS NULL)
678 AND (X_attribute12 IS NULL))))
679 AND ( ( (Recinfo.attribute13 = X_attribute13 )
680 OR ( (Recinfo.attribute13 IS NULL)
681 AND (X_attribute13 IS NULL))))
682 AND ( ( (Recinfo.attribute14 = X_attribute14 )
683 OR ( (Recinfo.attribute14 IS NULL)
684 AND (X_attribute14 IS NULL))))
685 AND ( ( (Recinfo.attribute15 = X_attribute15 )
686 OR ( (Recinfo.attribute15 IS NULL)
687 AND (X_attribute15 IS NULL))))
688 AND ( ( (Recinfo.auto_loaded_flag = X_auto_loaded_flag )
689 OR ( (Recinfo.auto_loaded_flag IS NULL)
690 AND (X_auto_loaded_flag IS NULL))))
691 AND ( ( (Recinfo.statement_complete_flag = X_statement_complete_flag )
692 OR ( (Recinfo.statement_complete_flag IS NULL)
693 AND (X_statement_complete_flag IS NULL))))
694 AND ( ( (Recinfo.gl_date = X_gl_date )
695 OR ( (Recinfo.gl_date IS NULL)
696 AND (X_gl_date IS NULL))))
697 -- 5916290: GDF Changes
698 AND ( ( (Recinfo.global_attribute_category = X_global_att_category)
699 OR ( (Recinfo.global_attribute_category IS NULL)
700 AND (X_global_att_category IS NULL))))
701 AND ( ( (Recinfo.global_attribute1 = X_global_attribute1)
702 OR ( (Recinfo.global_attribute1 IS NULL)
703 AND (X_global_attribute1 IS NULL))))
704 AND ( ( (Recinfo.global_attribute2 = X_global_attribute2)
705 OR ( (Recinfo.global_attribute2 IS NULL)
706 AND (X_global_attribute2 IS NULL))))
707 AND ( ( (Recinfo.global_attribute3 = X_global_attribute3)
708 OR ( (Recinfo.global_attribute3 IS NULL)
709 AND (X_global_attribute3 IS NULL))))
710 AND ( ( (Recinfo.global_attribute4 = X_global_attribute4)
711 OR ( (Recinfo.global_attribute4 IS NULL)
712 AND (X_global_attribute4 IS NULL))))
713 AND ( ( (Recinfo.global_attribute5 = X_global_attribute5)
714 OR ( (Recinfo.global_attribute5 IS NULL)
715 AND (X_global_attribute5 IS NULL))))
716 AND ( ( (Recinfo.global_attribute6 = X_global_attribute6)
717 OR ( (Recinfo.global_attribute6 IS NULL)
721 AND (X_global_attribute7 IS NULL))))
718 AND (X_global_attribute6 IS NULL))))
719 AND ( ( (Recinfo.global_attribute7 = X_global_attribute7)
720 OR ( (Recinfo.global_attribute7 IS NULL)
722 AND ( ( (Recinfo.global_attribute8 = X_global_attribute8)
723 OR ( (Recinfo.global_attribute8 IS NULL)
724 AND (X_global_attribute8 IS NULL))))
725 AND ( ( (Recinfo.global_attribute9 = X_global_attribute9)
726 OR ( (Recinfo.global_attribute9 IS NULL)
727 AND (X_global_attribute9 IS NULL))))
728 AND ( ( (Recinfo.global_attribute10 = X_global_attribute10)
729 OR ( (Recinfo.global_attribute10 IS NULL)
730 AND (X_global_attribute10 IS NULL))))
731 AND ( ( (Recinfo.global_attribute11 = X_global_attribute11)
732 OR ( (Recinfo.global_attribute11 IS NULL)
733 AND (X_global_attribute11 IS NULL))))
734 AND ( ( (Recinfo.global_attribute12 = X_global_attribute12)
735 OR ( (Recinfo.global_attribute12 IS NULL)
736 AND (X_global_attribute12 IS NULL))))
737 AND ( ( (Recinfo.global_attribute13 = X_global_attribute13)
738 OR ( (Recinfo.global_attribute13 IS NULL)
739 AND (X_global_attribute13 IS NULL))))
740 AND ( ( (Recinfo.global_attribute14 = X_global_attribute14)
741 OR ( (Recinfo.global_attribute14 IS NULL)
742 AND (X_global_attribute14 IS NULL))))
743 AND ( ( (Recinfo.global_attribute15 = X_global_attribute15)
744 OR ( (Recinfo.global_attribute15 IS NULL)
745 AND (X_global_attribute15 IS NULL))))
746 AND ( ( (Recinfo.global_attribute16 = X_global_attribute16)
747 OR ( (Recinfo.global_attribute16 IS NULL)
748 AND (X_global_attribute16 IS NULL))))
749 AND ( ( (Recinfo.global_attribute17 = X_global_attribute17)
750 OR ( (Recinfo.global_attribute17 IS NULL)
751 AND (X_global_attribute17 IS NULL))))
752 AND ( ( (Recinfo.global_attribute18 = X_global_attribute18)
753 OR ( (Recinfo.global_attribute18 IS NULL)
754 AND (X_global_attribute18 IS NULL))))
755 AND ( ( (Recinfo.global_attribute19 = X_global_attribute19)
756 OR ( (Recinfo.global_attribute19 IS NULL)
757 AND (X_global_attribute19 IS NULL))))
758 AND ( ( (Recinfo.global_attribute20 = X_global_attribute20)
759 OR ( (Recinfo.global_attribute20 IS NULL)
760 AND (X_global_attribute20 IS NULL))))
761 ) THEN
762 return;
763 ELSE
764 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
765 APP_EXCEPTION.RAISE_EXCEPTION;
766 END IF;
767 END Lock_Row;
768
769
770 END CE_STAT_HDRS_DML_PKG;