[Home] [Help]
PACKAGE BODY: APPS.OZF_AE_LINES_PKG
Source
1 PACKAGE BODY OZF_AE_LINES_PKG as
2 /* $Header: ozftaelb.pls 120.0 2005/06/01 00:15:14 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_AE_LINES_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_AE_LINES_PKG';
18 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftaelb.pls';
19
20
21 ----------------------------------------------------------
22 ---- MEDIA ----
23 ----------------------------------------------------------
24
25 -- ========================================================
26 --
27 -- NAME
28 -- createInsertBody
29 --
30 -- PURPOSE
31 --
32 -- NOTES
33 --
34 -- HISTORY
35 --
36 -- ========================================================
37 PROCEDURE Insert_Row(
38 px_ae_line_id IN OUT NOCOPY NUMBER,
39 px_object_version_number IN OUT NOCOPY NUMBER,
40 p_last_update_date DATE,
41 p_last_updated_by NUMBER,
42 p_creation_date DATE,
43 p_created_by NUMBER,
44 p_last_update_login NUMBER,
45 p_request_id NUMBER,
46 p_program_application_id NUMBER,
47 p_program_update_date DATE,
48 p_program_id NUMBER,
49 p_accounted_cr NUMBER,
50 p_accounted_dr NUMBER,
51 p_accounting_error_code VARCHAR2,
52 p_ae_header_id NUMBER,
53 p_ae_line_number NUMBER,
54 p_ae_line_type_code VARCHAR2,
55 p_applied_from_trx_hdr_id NUMBER,
56 p_applied_from_trx_hdr_table VARCHAR2,
57 p_applied_to_trx_hdr_id NUMBER,
58 p_applied_to_trx_hdr_table VARCHAR2,
59 p_code_combination_id NUMBER,
60 p_currency_code VARCHAR2,
61 p_currency_conversion_date DATE,
62 p_currency_conversion_rate NUMBER,
63 p_currency_conversion_type VARCHAR2,
64 p_description VARCHAR2,
65 p_entered_cr NUMBER,
66 p_entered_dr NUMBER,
67 p_gl_sl_link_id NUMBER,
68 p_gl_transfer_error_code VARCHAR2,
69 px_org_id IN OUT NOCOPY NUMBER,
70 p_reference1 VARCHAR2,
71 p_reference2 VARCHAR2,
72 p_reference3 VARCHAR2,
73 p_reference4 VARCHAR2,
74 p_reference5 VARCHAR2,
75 p_reference6 VARCHAR2,
76 p_reference7 VARCHAR2,
77 p_reference8 VARCHAR2,
78 p_reference9 VARCHAR2,
79 p_reference10 VARCHAR2,
80 p_source_id NUMBER,
81 p_source_table VARCHAR2,
82 p_stat_amount NUMBER,
83 p_subledger_doc_sequence_id NUMBER,
84 p_subledger_doc_sequence_value NUMBER,
85 p_taxable_accounted_cr NUMBER,
86 p_taxable_accounted_dr NUMBER,
87 p_taxable_entered_cr NUMBER,
88 p_taxable_entered_dr NUMBER,
89 p_tax_code_id NUMBER,
90 p_tax_link_id NUMBER,
91 p_third_party_id NUMBER,
92 p_third_party_sub_id NUMBER,
93 p_third_party_type VARCHAR2,
94 p_ussgl_transaction_code VARCHAR2,
95 p_attribute_category VARCHAR2,
96 p_attribute1 VARCHAR2,
97 p_attribute2 VARCHAR2,
98 p_attribute3 VARCHAR2,
99 p_attribute4 VARCHAR2,
100 p_attribute5 VARCHAR2,
101 p_attribute6 VARCHAR2,
102 p_attribute7 VARCHAR2,
103 p_attribute8 VARCHAR2,
104 p_attribute9 VARCHAR2,
105 p_attribute10 VARCHAR2,
106 p_attribute11 VARCHAR2,
107 p_attribute12 VARCHAR2,
108 p_attribute13 VARCHAR2,
109 p_attribute14 VARCHAR2,
110 p_attribute15 VARCHAR2)
111
112 IS
113 x_rowid VARCHAR2(30);
114
115
116 BEGIN
117
118 IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
119 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
120 INTO px_org_id
121 FROM DUAL;
122 END IF;
123
124
125 px_object_version_number := 1;
126
127
128 INSERT INTO OZF_AE_LINES_ALL(
129 ae_line_id,
130 object_version_number,
131 last_update_date,
132 last_updated_by,
133 creation_date,
134 created_by,
135 last_update_login,
136 request_id,
137 program_application_id,
138 program_update_date,
139 program_id,
140 accounted_cr,
141 accounted_dr,
142 accounting_error_code,
143 ae_header_id,
144 ae_line_number,
145 ae_line_type_code,
146 applied_from_trx_hdr_id,
147 applied_from_trx_hdr_table,
148 applied_to_trx_hdr_id,
149 applied_to_trx_hdr_table,
150 code_combination_id,
151 currency_code,
152 currency_conversion_date,
153 currency_conversion_rate,
154 currency_conversion_type,
155 description,
156 entered_cr,
157 entered_dr,
158 gl_sl_link_id,
159 gl_transfer_error_code,
160 org_id,
161 reference1,
162 reference2,
163 reference3,
164 reference4,
165 reference5,
166 reference6,
167 reference7,
168 reference8,
169 reference9,
170 reference10,
171 source_id,
172 source_table,
173 stat_amount,
174 subledger_doc_sequence_id,
175 subledger_doc_sequence_value,
176 taxable_accounted_cr,
177 taxable_accounted_dr,
178 taxable_entered_cr,
179 taxable_entered_dr,
180 tax_code_id,
181 tax_link_id,
182 third_party_id,
183 third_party_sub_id,
184 third_party_type,
185 ussgl_transaction_code,
186 attribute_category,
187 attribute1,
188 attribute2,
189 attribute3,
190 attribute4,
191 attribute5,
192 attribute6,
193 attribute7,
194 attribute8,
195 attribute9,
196 attribute10,
197 attribute11,
198 attribute12,
199 attribute13,
200 attribute14,
201 attribute15
202 ) VALUES (
203 px_ae_line_id,
204 px_object_version_number,
205 p_last_update_date,
206 p_last_updated_by,
207 p_creation_date,
208 p_created_by,
209 p_last_update_login,
210 p_request_id,
211 p_program_application_id,
212 p_program_update_date,
213 p_program_id,
214 p_accounted_cr,
215 p_accounted_dr,
216 p_accounting_error_code,
217 p_ae_header_id,
218 p_ae_line_number,
219 p_ae_line_type_code,
220 p_applied_from_trx_hdr_id,
221 p_applied_from_trx_hdr_table,
222 p_applied_to_trx_hdr_id,
223 p_applied_to_trx_hdr_table,
224 p_code_combination_id,
225 p_currency_code,
226 p_currency_conversion_date,
227 p_currency_conversion_rate,
228 p_currency_conversion_type,
229 p_description,
230 p_entered_cr,
231 p_entered_dr,
232 p_gl_sl_link_id,
233 p_gl_transfer_error_code,
234 px_org_id,
235 p_reference1,
236 p_reference2,
237 p_reference3,
238 p_reference4,
239 p_reference5,
240 p_reference6,
241 p_reference7,
242 p_reference8,
243 p_reference9,
244 p_reference10,
245 p_source_id,
246 p_source_table,
247 p_stat_amount,
248 p_subledger_doc_sequence_id,
249 p_subledger_doc_sequence_value,
250 p_taxable_accounted_cr,
251 p_taxable_accounted_dr,
252 p_taxable_entered_cr,
253 p_taxable_entered_dr,
254 p_tax_code_id,
255 p_tax_link_id,
256 p_third_party_id,
257 p_third_party_sub_id,
258 p_third_party_type,
259 p_ussgl_transaction_code,
260 p_attribute_category,
261 p_attribute1,
262 p_attribute2,
263 p_attribute3,
264 p_attribute4,
265 p_attribute5,
266 p_attribute6,
267 p_attribute7,
268 p_attribute8,
269 p_attribute9,
270 p_attribute10,
271 p_attribute11,
272 p_attribute12,
273 p_attribute13,
274 p_attribute14,
275 p_attribute15);
276 END Insert_Row;
277
278
279 ----------------------------------------------------------
280 ---- MEDIA ----
281 ----------------------------------------------------------
282
283 -- ========================================================
284 --
285 -- NAME
286 -- createUpdateBody
287 --
288 -- PURPOSE
289 --
290 -- NOTES
291 --
292 -- HISTORY
293 --
294 -- ========================================================
295 PROCEDURE Update_Row(
296 p_ae_line_id NUMBER,
297 p_object_version_number NUMBER,
298 p_last_update_date DATE,
299 p_last_updated_by NUMBER,
300 p_last_update_login NUMBER,
301 p_request_id NUMBER,
302 p_program_application_id NUMBER,
303 p_program_update_date DATE,
304 p_program_id NUMBER,
305 p_accounted_cr NUMBER,
306 p_accounted_dr NUMBER,
307 p_accounting_error_code VARCHAR2,
308 p_ae_header_id NUMBER,
309 p_ae_line_number NUMBER,
310 p_ae_line_type_code VARCHAR2,
311 p_applied_from_trx_hdr_id NUMBER,
312 p_applied_from_trx_hdr_table VARCHAR2,
313 p_applied_to_trx_hdr_id NUMBER,
314 p_applied_to_trx_hdr_table VARCHAR2,
315 p_code_combination_id NUMBER,
316 p_currency_code VARCHAR2,
317 p_currency_conversion_date DATE,
318 p_currency_conversion_rate NUMBER,
319 p_currency_conversion_type VARCHAR2,
320 p_description VARCHAR2,
321 p_entered_cr NUMBER,
322 p_entered_dr NUMBER,
323 p_gl_sl_link_id NUMBER,
324 p_gl_transfer_error_code VARCHAR2,
325 p_org_id NUMBER,
326 p_reference1 VARCHAR2,
327 p_reference2 VARCHAR2,
328 p_reference3 VARCHAR2,
329 p_reference4 VARCHAR2,
330 p_reference5 VARCHAR2,
331 p_reference6 VARCHAR2,
332 p_reference7 VARCHAR2,
333 p_reference8 VARCHAR2,
334 p_reference9 VARCHAR2,
335 p_reference10 VARCHAR2,
336 p_source_id NUMBER,
337 p_source_table VARCHAR2,
338 p_stat_amount NUMBER,
339 p_subledger_doc_sequence_id NUMBER,
340 p_subledger_doc_sequence_value NUMBER,
341 p_taxable_accounted_cr NUMBER,
342 p_taxable_accounted_dr NUMBER,
343 p_taxable_entered_cr NUMBER,
344 p_taxable_entered_dr NUMBER,
345 p_tax_code_id NUMBER,
346 p_tax_link_id NUMBER,
347 p_third_party_id NUMBER,
348 p_third_party_sub_id NUMBER,
349 p_third_party_type VARCHAR2,
350 p_ussgl_transaction_code VARCHAR2,
351 p_attribute_category VARCHAR2,
352 p_attribute1 VARCHAR2,
353 p_attribute2 VARCHAR2,
354 p_attribute3 VARCHAR2,
355 p_attribute4 VARCHAR2,
356 p_attribute5 VARCHAR2,
357 p_attribute6 VARCHAR2,
358 p_attribute7 VARCHAR2,
359 p_attribute8 VARCHAR2,
360 p_attribute9 VARCHAR2,
361 p_attribute10 VARCHAR2,
362 p_attribute11 VARCHAR2,
363 p_attribute12 VARCHAR2,
364 p_attribute13 VARCHAR2,
365 p_attribute14 VARCHAR2,
366 p_attribute15 VARCHAR2)
367
368 IS
369 BEGIN
370 Update OZF_AE_LINES_ALL
371 SET
372 ae_line_id = p_ae_line_id,
373 object_version_number = p_object_version_number,
374 last_update_date = p_last_update_date,
375 last_updated_by = p_last_updated_by,
376 last_update_login = p_last_update_login,
377 request_id = p_request_id,
378 program_application_id = p_program_application_id,
379 program_update_date = p_program_update_date,
380 program_id = p_program_id,
381 accounted_cr = p_accounted_cr,
382 accounted_dr = p_accounted_dr,
383 accounting_error_code = p_accounting_error_code,
384 ae_header_id = p_ae_header_id,
385 ae_line_number = p_ae_line_number,
386 ae_line_type_code = p_ae_line_type_code,
387 applied_from_trx_hdr_id = p_applied_from_trx_hdr_id,
388 applied_from_trx_hdr_table = p_applied_from_trx_hdr_table,
389 applied_to_trx_hdr_id = p_applied_to_trx_hdr_id,
390 applied_to_trx_hdr_table = p_applied_to_trx_hdr_table,
391 code_combination_id = p_code_combination_id,
392 currency_code = p_currency_code,
393 currency_conversion_date = p_currency_conversion_date,
394 currency_conversion_rate = p_currency_conversion_rate,
395 currency_conversion_type = p_currency_conversion_type,
396 description = p_description,
397 entered_cr = p_entered_cr,
398 entered_dr = p_entered_dr,
399 gl_sl_link_id = p_gl_sl_link_id,
400 gl_transfer_error_code = p_gl_transfer_error_code,
401 org_id = p_org_id,
402 reference1 = p_reference1,
403 reference2 = p_reference2,
404 reference3 = p_reference3,
405 reference4 = p_reference4,
406 reference5 = p_reference5,
407 reference6 = p_reference6,
408 reference7 = p_reference7,
409 reference8 = p_reference8,
410 reference9 = p_reference9,
411 reference10 = p_reference10,
412 source_id = p_source_id,
413 source_table = p_source_table,
414 stat_amount = p_stat_amount,
415 subledger_doc_sequence_id = p_subledger_doc_sequence_id,
416 subledger_doc_sequence_value = p_subledger_doc_sequence_value,
417 taxable_accounted_cr = p_taxable_accounted_cr,
418 taxable_accounted_dr = p_taxable_accounted_dr,
419 taxable_entered_cr = p_taxable_entered_cr,
420 taxable_entered_dr = p_taxable_entered_dr,
421 tax_code_id = p_tax_code_id,
422 tax_link_id = p_tax_link_id,
423 third_party_id = p_third_party_id,
427 attribute_category = p_attribute_category,
424 third_party_sub_id = p_third_party_sub_id,
425 third_party_type = p_third_party_type,
426 ussgl_transaction_code = p_ussgl_transaction_code,
428 attribute1 = p_attribute1,
429 attribute2 = p_attribute2,
430 attribute3 = p_attribute3,
431 attribute4 = p_attribute4,
432 attribute5 = p_attribute5,
433 attribute6 = p_attribute6,
434 attribute7 = p_attribute7,
435 attribute8 = p_attribute8,
436 attribute9 = p_attribute9,
437 attribute10 = p_attribute10,
438 attribute11 = p_attribute11,
439 attribute12 = p_attribute12,
440 attribute13 = p_attribute13,
441 attribute14 = p_attribute14,
442 attribute15 = p_attribute15
443 WHERE AE_LINE_ID = p_AE_LINE_ID
444 AND object_version_number = p_object_version_number;
445
446 IF (SQL%NOTFOUND) THEN
447 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448 END IF;
449 END Update_Row;
450
451
452 ----------------------------------------------------------
453 ---- MEDIA ----
454 ----------------------------------------------------------
455
456 -- ========================================================
457 --
458 -- NAME
459 -- createDeleteBody
460 --
461 -- PURPOSE
462 --
463 -- NOTES
464 --
465 -- HISTORY
466 --
467 -- ========================================================
468 PROCEDURE Delete_Row(
469 p_AE_LINE_ID NUMBER)
470 IS
471 BEGIN
472 DELETE FROM OZF_AE_LINES_ALL
473 WHERE AE_LINE_ID = p_AE_LINE_ID;
474 If (SQL%NOTFOUND) then
475 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476 End If;
477 END Delete_Row ;
478
479
480
481 ----------------------------------------------------------
482 ---- MEDIA ----
483 ----------------------------------------------------------
484
485 -- ========================================================
486 --
487 -- NAME
488 -- createLockBody
489 --
490 -- PURPOSE
491 --
492 -- NOTES
493 --
494 -- HISTORY
495 --
496 -- ========================================================
497 PROCEDURE Lock_Row(
498 p_ae_line_id NUMBER,
499 p_object_version_number NUMBER,
500 p_last_update_date DATE,
501 p_last_updated_by NUMBER,
502 p_creation_date DATE,
503 p_created_by NUMBER,
504 p_last_update_login NUMBER,
505 p_request_id NUMBER,
506 p_program_application_id NUMBER,
507 p_program_update_date DATE,
508 p_program_id NUMBER,
509 p_accounted_cr NUMBER,
510 p_accounted_dr NUMBER,
511 p_accounting_error_code VARCHAR2,
512 p_ae_header_id NUMBER,
513 p_ae_line_number NUMBER,
514 p_ae_line_type_code VARCHAR2,
515 p_applied_from_trx_hdr_id NUMBER,
516 p_applied_from_trx_hdr_table VARCHAR2,
517 p_applied_to_trx_hdr_id NUMBER,
518 p_applied_to_trx_hdr_table VARCHAR2,
519 p_code_combination_id NUMBER,
520 p_currency_code VARCHAR2,
521 p_currency_conversion_date DATE,
522 p_currency_conversion_rate NUMBER,
523 p_currency_conversion_type VARCHAR2,
524 p_description VARCHAR2,
525 p_entered_cr NUMBER,
526 p_entered_dr NUMBER,
527 p_gl_sl_link_id NUMBER,
528 p_gl_transfer_error_code VARCHAR2,
529 p_org_id NUMBER,
530 p_reference1 VARCHAR2,
531 p_reference2 VARCHAR2,
532 p_reference3 VARCHAR2,
533 p_reference4 VARCHAR2,
534 p_reference5 VARCHAR2,
535 p_reference6 VARCHAR2,
536 p_reference7 VARCHAR2,
537 p_reference8 VARCHAR2,
538 p_reference9 VARCHAR2,
539 p_reference10 VARCHAR2,
540 p_source_id NUMBER,
541 p_source_table VARCHAR2,
542 p_stat_amount NUMBER,
543 p_subledger_doc_sequence_id NUMBER,
544 p_subledger_doc_sequence_value NUMBER,
545 p_taxable_accounted_cr NUMBER,
546 p_taxable_accounted_dr NUMBER,
547 p_taxable_entered_cr NUMBER,
548 p_taxable_entered_dr NUMBER,
549 p_tax_code_id NUMBER,
550 p_tax_link_id NUMBER,
551 p_third_party_id NUMBER,
552 p_third_party_sub_id NUMBER,
553 p_third_party_type VARCHAR2,
554 p_ussgl_transaction_code VARCHAR2,
555 p_attribute_category VARCHAR2,
556 p_attribute1 VARCHAR2,
557 p_attribute2 VARCHAR2,
558 p_attribute3 VARCHAR2,
559 p_attribute4 VARCHAR2,
560 p_attribute5 VARCHAR2,
561 p_attribute6 VARCHAR2,
562 p_attribute7 VARCHAR2,
563 p_attribute8 VARCHAR2,
564 p_attribute9 VARCHAR2,
565 p_attribute10 VARCHAR2,
569 p_attribute14 VARCHAR2,
566 p_attribute11 VARCHAR2,
567 p_attribute12 VARCHAR2,
568 p_attribute13 VARCHAR2,
570 p_attribute15 VARCHAR2)
571
572 IS
573 CURSOR C IS
574 SELECT *
575 FROM OZF_AE_LINES_ALL
576 WHERE AE_LINE_ID = p_AE_LINE_ID
577 FOR UPDATE of AE_LINE_ID NOWAIT;
578 Recinfo C%ROWTYPE;
579 BEGIN
580 OPEN c;
581 FETCH c INTO Recinfo;
582 If (c%NOTFOUND) then
583 CLOSE c;
584 FND_MESSAGE.SET_NAME('OZF', 'OZF_API_RECORD_NOT_FOUND');
585 APP_EXCEPTION.RAISE_EXCEPTION;
586 END IF;
587 CLOSE C;
588 IF (
589 ( Recinfo.ae_line_id = p_ae_line_id)
590 AND ( ( Recinfo.object_version_number = p_object_version_number)
591 OR ( ( Recinfo.object_version_number IS NULL )
592 AND ( p_object_version_number IS NULL )))
593 AND ( ( Recinfo.last_update_date = p_last_update_date)
594 OR ( ( Recinfo.last_update_date IS NULL )
595 AND ( p_last_update_date IS NULL )))
596 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
597 OR ( ( Recinfo.last_updated_by IS NULL )
598 AND ( p_last_updated_by IS NULL )))
599 AND ( ( Recinfo.creation_date = p_creation_date)
600 OR ( ( Recinfo.creation_date IS NULL )
601 AND ( p_creation_date IS NULL )))
602 AND ( ( Recinfo.created_by = p_created_by)
603 OR ( ( Recinfo.created_by IS NULL )
604 AND ( p_created_by IS NULL )))
605 AND ( ( Recinfo.last_update_login = p_last_update_login)
606 OR ( ( Recinfo.last_update_login IS NULL )
607 AND ( p_last_update_login IS NULL )))
608 AND ( ( Recinfo.request_id = p_request_id)
609 OR ( ( Recinfo.request_id IS NULL )
610 AND ( p_request_id IS NULL )))
611 AND ( ( Recinfo.program_application_id = p_program_application_id)
612 OR ( ( Recinfo.program_application_id IS NULL )
613 AND ( p_program_application_id IS NULL )))
614 AND ( ( Recinfo.program_update_date = p_program_update_date)
615 OR ( ( Recinfo.program_update_date IS NULL )
616 AND ( p_program_update_date IS NULL )))
617 AND ( ( Recinfo.program_id = p_program_id)
618 OR ( ( Recinfo.program_id IS NULL )
619 AND ( p_program_id IS NULL )))
620 AND ( ( Recinfo.accounted_cr = p_accounted_cr)
621 OR ( ( Recinfo.accounted_cr IS NULL )
622 AND ( p_accounted_cr IS NULL )))
623 AND ( ( Recinfo.accounted_dr = p_accounted_dr)
624 OR ( ( Recinfo.accounted_dr IS NULL )
625 AND ( p_accounted_dr IS NULL )))
626 AND ( ( Recinfo.accounting_error_code = p_accounting_error_code)
627 OR ( ( Recinfo.accounting_error_code IS NULL )
628 AND ( p_accounting_error_code IS NULL )))
629 AND ( ( Recinfo.ae_header_id = p_ae_header_id)
630 OR ( ( Recinfo.ae_header_id IS NULL )
631 AND ( p_ae_header_id IS NULL )))
632 AND ( ( Recinfo.ae_line_number = p_ae_line_number)
633 OR ( ( Recinfo.ae_line_number IS NULL )
634 AND ( p_ae_line_number IS NULL )))
635 AND ( ( Recinfo.ae_line_type_code = p_ae_line_type_code)
636 OR ( ( Recinfo.ae_line_type_code IS NULL )
637 AND ( p_ae_line_type_code IS NULL )))
638 AND ( ( Recinfo.applied_from_trx_hdr_id = p_applied_from_trx_hdr_id)
639 OR ( ( Recinfo.applied_from_trx_hdr_id IS NULL )
640 AND ( p_applied_from_trx_hdr_id IS NULL )))
641 AND ( ( Recinfo.applied_from_trx_hdr_table = p_applied_from_trx_hdr_table)
642 OR ( ( Recinfo.applied_from_trx_hdr_table IS NULL )
643 AND ( p_applied_from_trx_hdr_table IS NULL )))
644 AND ( ( Recinfo.applied_to_trx_hdr_id = p_applied_to_trx_hdr_id)
645 OR ( ( Recinfo.applied_to_trx_hdr_id IS NULL )
646 AND ( p_applied_to_trx_hdr_id IS NULL )))
647 AND ( ( Recinfo.applied_to_trx_hdr_table = p_applied_to_trx_hdr_table)
648 OR ( ( Recinfo.applied_to_trx_hdr_table IS NULL )
649 AND ( p_applied_to_trx_hdr_table IS NULL )))
650 AND ( ( Recinfo.code_combination_id = p_code_combination_id)
651 OR ( ( Recinfo.code_combination_id IS NULL )
652 AND ( p_code_combination_id IS NULL )))
653 AND ( ( Recinfo.currency_code = p_currency_code)
654 OR ( ( Recinfo.currency_code IS NULL )
655 AND ( p_currency_code IS NULL )))
656 AND ( ( Recinfo.currency_conversion_date = p_currency_conversion_date)
657 OR ( ( Recinfo.currency_conversion_date IS NULL )
658 AND ( p_currency_conversion_date IS NULL )))
659 AND ( ( Recinfo.currency_conversion_rate = p_currency_conversion_rate)
660 OR ( ( Recinfo.currency_conversion_rate IS NULL )
661 AND ( p_currency_conversion_rate IS NULL )))
662 AND ( ( Recinfo.currency_conversion_type = p_currency_conversion_type)
663 OR ( ( Recinfo.currency_conversion_type IS NULL )
667 AND ( p_description IS NULL )))
664 AND ( p_currency_conversion_type IS NULL )))
665 AND ( ( Recinfo.description = p_description)
666 OR ( ( Recinfo.description IS NULL )
668 AND ( ( Recinfo.entered_cr = p_entered_cr)
669 OR ( ( Recinfo.entered_cr IS NULL )
670 AND ( p_entered_cr IS NULL )))
671 AND ( ( Recinfo.entered_dr = p_entered_dr)
672 OR ( ( Recinfo.entered_dr IS NULL )
673 AND ( p_entered_dr IS NULL )))
674 AND ( ( Recinfo.gl_sl_link_id = p_gl_sl_link_id)
675 OR ( ( Recinfo.gl_sl_link_id IS NULL )
676 AND ( p_gl_sl_link_id IS NULL )))
677 AND ( ( Recinfo.gl_transfer_error_code = p_gl_transfer_error_code)
678 OR ( ( Recinfo.gl_transfer_error_code IS NULL )
679 AND ( p_gl_transfer_error_code IS NULL )))
680 AND ( ( Recinfo.org_id = p_org_id)
681 OR ( ( Recinfo.org_id IS NULL )
682 AND ( p_org_id IS NULL )))
683 AND ( ( Recinfo.reference1 = p_reference1)
684 OR ( ( Recinfo.reference1 IS NULL )
685 AND ( p_reference1 IS NULL )))
686 AND ( ( Recinfo.reference2 = p_reference2)
687 OR ( ( Recinfo.reference2 IS NULL )
688 AND ( p_reference2 IS NULL )))
689 AND ( ( Recinfo.reference3 = p_reference3)
690 OR ( ( Recinfo.reference3 IS NULL )
691 AND ( p_reference3 IS NULL )))
692 AND ( ( Recinfo.reference4 = p_reference4)
693 OR ( ( Recinfo.reference4 IS NULL )
694 AND ( p_reference4 IS NULL )))
695 AND ( ( Recinfo.reference5 = p_reference5)
696 OR ( ( Recinfo.reference5 IS NULL )
697 AND ( p_reference5 IS NULL )))
698 AND ( ( Recinfo.reference6 = p_reference6)
699 OR ( ( Recinfo.reference6 IS NULL )
700 AND ( p_reference6 IS NULL )))
701 AND ( ( Recinfo.reference7 = p_reference7)
702 OR ( ( Recinfo.reference7 IS NULL )
703 AND ( p_reference7 IS NULL )))
704 AND ( ( Recinfo.reference8 = p_reference8)
705 OR ( ( Recinfo.reference8 IS NULL )
706 AND ( p_reference8 IS NULL )))
707 AND ( ( Recinfo.reference9 = p_reference9)
708 OR ( ( Recinfo.reference9 IS NULL )
709 AND ( p_reference9 IS NULL )))
710 AND ( ( Recinfo.reference10 = p_reference10)
711 OR ( ( Recinfo.reference10 IS NULL )
712 AND ( p_reference10 IS NULL )))
713 AND ( ( Recinfo.source_id = p_source_id)
714 OR ( ( Recinfo.source_id IS NULL )
715 AND ( p_source_id IS NULL )))
716 AND ( ( Recinfo.source_table = p_source_table)
717 OR ( ( Recinfo.source_table IS NULL )
718 AND ( p_source_table IS NULL )))
719 AND ( ( Recinfo.stat_amount = p_stat_amount)
720 OR ( ( Recinfo.stat_amount IS NULL )
721 AND ( p_stat_amount IS NULL )))
722 AND ( ( Recinfo.subledger_doc_sequence_id = p_subledger_doc_sequence_id)
723 OR ( ( Recinfo.subledger_doc_sequence_id IS NULL )
724 AND ( p_subledger_doc_sequence_id IS NULL )))
725 AND ( ( Recinfo.subledger_doc_sequence_value = p_subledger_doc_sequence_value)
726 OR ( ( Recinfo.subledger_doc_sequence_value IS NULL )
727 AND ( p_subledger_doc_sequence_value IS NULL )))
728 AND ( ( Recinfo.taxable_accounted_cr = p_taxable_accounted_cr)
729 OR ( ( Recinfo.taxable_accounted_cr IS NULL )
730 AND ( p_taxable_accounted_cr IS NULL )))
731 AND ( ( Recinfo.taxable_accounted_dr = p_taxable_accounted_dr)
732 OR ( ( Recinfo.taxable_accounted_dr IS NULL )
733 AND ( p_taxable_accounted_dr IS NULL )))
734 AND ( ( Recinfo.taxable_entered_cr = p_taxable_entered_cr)
735 OR ( ( Recinfo.taxable_entered_cr IS NULL )
736 AND ( p_taxable_entered_cr IS NULL )))
737 AND ( ( Recinfo.taxable_entered_dr = p_taxable_entered_dr)
738 OR ( ( Recinfo.taxable_entered_dr IS NULL )
739 AND ( p_taxable_entered_dr IS NULL )))
740 AND ( ( Recinfo.tax_code_id = p_tax_code_id)
741 OR ( ( Recinfo.tax_code_id IS NULL )
742 AND ( p_tax_code_id IS NULL )))
743 AND ( ( Recinfo.tax_link_id = p_tax_link_id)
744 OR ( ( Recinfo.tax_link_id IS NULL )
745 AND ( p_tax_link_id IS NULL )))
746 AND ( ( Recinfo.third_party_id = p_third_party_id)
747 OR ( ( Recinfo.third_party_id IS NULL )
748 AND ( p_third_party_id IS NULL )))
749 AND ( ( Recinfo.third_party_sub_id = p_third_party_sub_id)
750 OR ( ( Recinfo.third_party_sub_id IS NULL )
751 AND ( p_third_party_sub_id IS NULL )))
752 AND ( ( Recinfo.third_party_type = p_third_party_type)
753 OR ( ( Recinfo.third_party_type IS NULL )
754 AND ( p_third_party_type IS NULL )))
755 AND ( ( Recinfo.ussgl_transaction_code = p_ussgl_transaction_code)
756 OR ( ( Recinfo.ussgl_transaction_code IS NULL )
757 AND ( p_ussgl_transaction_code IS NULL )))
758 AND ( ( Recinfo.attribute_category = p_attribute_category)
759 OR ( ( Recinfo.attribute_category IS NULL )
760 AND ( p_attribute_category IS NULL )))
761 AND ( ( Recinfo.attribute1 = p_attribute1)
762 OR ( ( Recinfo.attribute1 IS NULL )
763 AND ( p_attribute1 IS NULL )))
764 AND ( ( Recinfo.attribute2 = p_attribute2)
765 OR ( ( Recinfo.attribute2 IS NULL )
766 AND ( p_attribute2 IS NULL )))
767 AND ( ( Recinfo.attribute3 = p_attribute3)
768 OR ( ( Recinfo.attribute3 IS NULL )
769 AND ( p_attribute3 IS NULL )))
770 AND ( ( Recinfo.attribute4 = p_attribute4)
771 OR ( ( Recinfo.attribute4 IS NULL )
772 AND ( p_attribute4 IS NULL )))
773 AND ( ( Recinfo.attribute5 = p_attribute5)
774 OR ( ( Recinfo.attribute5 IS NULL )
775 AND ( p_attribute5 IS NULL )))
776 AND ( ( Recinfo.attribute6 = p_attribute6)
777 OR ( ( Recinfo.attribute6 IS NULL )
778 AND ( p_attribute6 IS NULL )))
779 AND ( ( Recinfo.attribute7 = p_attribute7)
780 OR ( ( Recinfo.attribute7 IS NULL )
781 AND ( p_attribute7 IS NULL )))
782 AND ( ( Recinfo.attribute8 = p_attribute8)
783 OR ( ( Recinfo.attribute8 IS NULL )
784 AND ( p_attribute8 IS NULL )))
785 AND ( ( Recinfo.attribute9 = p_attribute9)
786 OR ( ( Recinfo.attribute9 IS NULL )
787 AND ( p_attribute9 IS NULL )))
788 AND ( ( Recinfo.attribute10 = p_attribute10)
789 OR ( ( Recinfo.attribute10 IS NULL )
790 AND ( p_attribute10 IS NULL )))
791 AND ( ( Recinfo.attribute11 = p_attribute11)
792 OR ( ( Recinfo.attribute11 IS NULL )
793 AND ( p_attribute11 IS NULL )))
794 AND ( ( Recinfo.attribute12 = p_attribute12)
795 OR ( ( Recinfo.attribute12 IS NULL )
796 AND ( p_attribute12 IS NULL )))
797 AND ( ( Recinfo.attribute13 = p_attribute13)
798 OR ( ( Recinfo.attribute13 IS NULL )
799 AND ( p_attribute13 IS NULL )))
800 AND ( ( Recinfo.attribute14 = p_attribute14)
801 OR ( ( Recinfo.attribute14 IS NULL )
802 AND ( p_attribute14 IS NULL )))
803 AND ( ( Recinfo.attribute15 = p_attribute15)
804 OR ( ( Recinfo.attribute15 IS NULL )
805 AND ( p_attribute15 IS NULL )))
806 ) THEN
807 RETURN;
808 ELSE
809 FND_MESSAGE.SET_NAME('OZF', 'OZF_API_RECORD_NOT_FOUND');
810 APP_EXCEPTION.RAISE_EXCEPTION;
811 END IF;
812 END Lock_Row;
813
814 END OZF_AE_LINES_PKG;