495: x_avlv_rec OUT NOCOPY avlv_rec_type
496: ) RETURN VARCHAR2 IS
497: l_avlv_rec avlv_rec_type;
498: l_row_notfound BOOLEAN := TRUE;
499: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: BEGIN
501:
502: x_avlv_rec := p_avlv_rec;
503: -- Get current database values
503: -- Get current database values
504: l_avlv_rec := get_rec_avl(p_avlv_rec, l_row_notfound);
505:
506: IF (l_row_notfound) THEN
507: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
508: END IF;
509:
510: IF (x_avlv_rec.id = OKC_API.G_MISS_NUM) THEN
511: x_avlv_rec.id := l_avlv_rec.id;
506: IF (l_row_notfound) THEN
507: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
508: END IF;
509:
510: IF (x_avlv_rec.id = OKC_API.G_MISS_NUM) THEN
511: x_avlv_rec.id := l_avlv_rec.id;
512: END IF;
513:
514: IF (x_avlv_rec.name = OKC_API.G_MISS_CHAR) THEN
510: IF (x_avlv_rec.id = OKC_API.G_MISS_NUM) THEN
511: x_avlv_rec.id := l_avlv_rec.id;
512: END IF;
513:
514: IF (x_avlv_rec.name = OKC_API.G_MISS_CHAR) THEN
515: x_avlv_rec.name := l_avlv_rec.name;
516: END IF;
517: IF (x_avlv_rec.set_of_books_id = OKC_API.G_MISS_NUM) THEN
518: x_avlv_rec.set_of_books_id := l_avlv_rec.set_of_books_id;
513:
514: IF (x_avlv_rec.name = OKC_API.G_MISS_CHAR) THEN
515: x_avlv_rec.name := l_avlv_rec.name;
516: END IF;
517: IF (x_avlv_rec.set_of_books_id = OKC_API.G_MISS_NUM) THEN
518: x_avlv_rec.set_of_books_id := l_avlv_rec.set_of_books_id;
519: END IF;
520: IF (x_avlv_rec.sty_id = OKC_API.G_MISS_NUM) THEN
521: x_avlv_rec.sty_id := l_avlv_rec.sty_id;
516: END IF;
517: IF (x_avlv_rec.set_of_books_id = OKC_API.G_MISS_NUM) THEN
518: x_avlv_rec.set_of_books_id := l_avlv_rec.set_of_books_id;
519: END IF;
520: IF (x_avlv_rec.sty_id = OKC_API.G_MISS_NUM) THEN
521: x_avlv_rec.sty_id := l_avlv_rec.sty_id;
522: END IF;
523: IF (x_avlv_rec.try_id = OKC_API.G_MISS_NUM) THEN
524: x_avlv_rec.try_id := l_avlv_rec.try_id;
519: END IF;
520: IF (x_avlv_rec.sty_id = OKC_API.G_MISS_NUM) THEN
521: x_avlv_rec.sty_id := l_avlv_rec.sty_id;
522: END IF;
523: IF (x_avlv_rec.try_id = OKC_API.G_MISS_NUM) THEN
524: x_avlv_rec.try_id := l_avlv_rec.try_id;
525: END IF;
526: IF (x_avlv_rec.aes_id = OKC_API.G_MISS_NUM) THEN
527: x_avlv_rec.aes_id := l_avlv_rec.aes_id;
522: END IF;
523: IF (x_avlv_rec.try_id = OKC_API.G_MISS_NUM) THEN
524: x_avlv_rec.try_id := l_avlv_rec.try_id;
525: END IF;
526: IF (x_avlv_rec.aes_id = OKC_API.G_MISS_NUM) THEN
527: x_avlv_rec.aes_id := l_avlv_rec.aes_id;
528: END IF;
529: IF (x_avlv_rec.syt_code = OKC_API.G_MISS_CHAR) THEN
530: x_avlv_rec.syt_code := l_avlv_rec.syt_code;
525: END IF;
526: IF (x_avlv_rec.aes_id = OKC_API.G_MISS_NUM) THEN
527: x_avlv_rec.aes_id := l_avlv_rec.aes_id;
528: END IF;
529: IF (x_avlv_rec.syt_code = OKC_API.G_MISS_CHAR) THEN
530: x_avlv_rec.syt_code := l_avlv_rec.syt_code;
531: END IF;
532: -- Added by HKPATEL for Bug# 2943310
533: IF (x_avlv_rec.inv_code = OKC_API.G_MISS_CHAR) THEN
529: IF (x_avlv_rec.syt_code = OKC_API.G_MISS_CHAR) THEN
530: x_avlv_rec.syt_code := l_avlv_rec.syt_code;
531: END IF;
532: -- Added by HKPATEL for Bug# 2943310
533: IF (x_avlv_rec.inv_code = OKC_API.G_MISS_CHAR) THEN
534: x_avlv_rec.inv_code := l_avlv_rec.inv_code;
535: END IF;
536: -- Added code ends here
537: IF (x_avlv_rec.fac_code = OKC_API.G_MISS_CHAR) THEN
533: IF (x_avlv_rec.inv_code = OKC_API.G_MISS_CHAR) THEN
534: x_avlv_rec.inv_code := l_avlv_rec.inv_code;
535: END IF;
536: -- Added code ends here
537: IF (x_avlv_rec.fac_code = OKC_API.G_MISS_CHAR) THEN
538: x_avlv_rec.fac_code := l_avlv_rec.fac_code;
539: END IF;
540: IF (x_avlv_rec.fma_id = OKC_API.G_MISS_NUM) THEN
541: x_avlv_rec.fma_id := l_avlv_rec.fma_id;
536: -- Added code ends here
537: IF (x_avlv_rec.fac_code = OKC_API.G_MISS_CHAR) THEN
538: x_avlv_rec.fac_code := l_avlv_rec.fac_code;
539: END IF;
540: IF (x_avlv_rec.fma_id = OKC_API.G_MISS_NUM) THEN
541: x_avlv_rec.fma_id := l_avlv_rec.fma_id;
542: END IF;
543: IF (x_avlv_rec.advance_arrears = OKC_API.G_MISS_CHAR) THEN
544: x_avlv_rec.advance_arrears := l_avlv_rec.advance_arrears;
539: END IF;
540: IF (x_avlv_rec.fma_id = OKC_API.G_MISS_NUM) THEN
541: x_avlv_rec.fma_id := l_avlv_rec.fma_id;
542: END IF;
543: IF (x_avlv_rec.advance_arrears = OKC_API.G_MISS_CHAR) THEN
544: x_avlv_rec.advance_arrears := l_avlv_rec.advance_arrears;
545: END IF;
546: IF (x_avlv_rec.post_to_gl = OKC_API.G_MISS_CHAR) THEN
547: x_avlv_rec.post_to_gl := l_avlv_rec.post_to_gl;
542: END IF;
543: IF (x_avlv_rec.advance_arrears = OKC_API.G_MISS_CHAR) THEN
544: x_avlv_rec.advance_arrears := l_avlv_rec.advance_arrears;
545: END IF;
546: IF (x_avlv_rec.post_to_gl = OKC_API.G_MISS_CHAR) THEN
547: x_avlv_rec.post_to_gl := l_avlv_rec.post_to_gl;
548: END IF;
549: IF (x_avlv_rec.version = OKC_API.G_MISS_CHAR) THEN
550: x_avlv_rec.version := l_avlv_rec.version;
545: END IF;
546: IF (x_avlv_rec.post_to_gl = OKC_API.G_MISS_CHAR) THEN
547: x_avlv_rec.post_to_gl := l_avlv_rec.post_to_gl;
548: END IF;
549: IF (x_avlv_rec.version = OKC_API.G_MISS_CHAR) THEN
550: x_avlv_rec.version := l_avlv_rec.version;
551: END IF;
552: IF (x_avlv_rec.start_date = OKC_API.G_MISS_DATE) THEN
553: x_avlv_rec.start_date := l_avlv_rec.start_date;
548: END IF;
549: IF (x_avlv_rec.version = OKC_API.G_MISS_CHAR) THEN
550: x_avlv_rec.version := l_avlv_rec.version;
551: END IF;
552: IF (x_avlv_rec.start_date = OKC_API.G_MISS_DATE) THEN
553: x_avlv_rec.start_date := l_avlv_rec.start_date;
554: END IF;
555: IF (x_avlv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
556: x_avlv_rec.object_version_number := l_avlv_rec.object_version_number;
551: END IF;
552: IF (x_avlv_rec.start_date = OKC_API.G_MISS_DATE) THEN
553: x_avlv_rec.start_date := l_avlv_rec.start_date;
554: END IF;
555: IF (x_avlv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
556: x_avlv_rec.object_version_number := l_avlv_rec.object_version_number;
557: END IF;
558: IF (x_avlv_rec.memo_yn = OKC_API.G_MISS_CHAR) THEN
559: x_avlv_rec.memo_yn := l_avlv_rec.memo_yn;
554: END IF;
555: IF (x_avlv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
556: x_avlv_rec.object_version_number := l_avlv_rec.object_version_number;
557: END IF;
558: IF (x_avlv_rec.memo_yn = OKC_API.G_MISS_CHAR) THEN
559: x_avlv_rec.memo_yn := l_avlv_rec.memo_yn;
560: END IF;
561: IF (x_avlv_rec.prior_year_yn = OKC_API.G_MISS_CHAR) THEN
562: x_avlv_rec.prior_year_yn := l_avlv_rec.prior_year_yn;
557: END IF;
558: IF (x_avlv_rec.memo_yn = OKC_API.G_MISS_CHAR) THEN
559: x_avlv_rec.memo_yn := l_avlv_rec.memo_yn;
560: END IF;
561: IF (x_avlv_rec.prior_year_yn = OKC_API.G_MISS_CHAR) THEN
562: x_avlv_rec.prior_year_yn := l_avlv_rec.prior_year_yn;
563: END IF;
564: IF (x_avlv_rec.description = OKC_API.G_MISS_CHAR) THEN
565: x_avlv_rec.description := l_avlv_rec.description;
560: END IF;
561: IF (x_avlv_rec.prior_year_yn = OKC_API.G_MISS_CHAR) THEN
562: x_avlv_rec.prior_year_yn := l_avlv_rec.prior_year_yn;
563: END IF;
564: IF (x_avlv_rec.description = OKC_API.G_MISS_CHAR) THEN
565: x_avlv_rec.description := l_avlv_rec.description;
566: END IF;
567: IF (x_avlv_rec.factoring_synd_flag = OKC_API.G_MISS_CHAR) THEN
568: x_avlv_rec.factoring_synd_flag := l_avlv_rec.factoring_synd_flag;
563: END IF;
564: IF (x_avlv_rec.description = OKC_API.G_MISS_CHAR) THEN
565: x_avlv_rec.description := l_avlv_rec.description;
566: END IF;
567: IF (x_avlv_rec.factoring_synd_flag = OKC_API.G_MISS_CHAR) THEN
568: x_avlv_rec.factoring_synd_flag := l_avlv_rec.factoring_synd_flag;
569: END IF;
570: IF (x_avlv_rec.end_date = OKC_API.G_MISS_DATE) THEN
571: x_avlv_rec.end_date := l_avlv_rec.end_date;
566: END IF;
567: IF (x_avlv_rec.factoring_synd_flag = OKC_API.G_MISS_CHAR) THEN
568: x_avlv_rec.factoring_synd_flag := l_avlv_rec.factoring_synd_flag;
569: END IF;
570: IF (x_avlv_rec.end_date = OKC_API.G_MISS_DATE) THEN
571: x_avlv_rec.end_date := l_avlv_rec.end_date;
572: END IF;
573: IF (x_avlv_rec.accrual_yn = OKC_API.G_MISS_CHAR) THEN
574: x_avlv_rec.accrual_yn := l_avlv_rec.accrual_yn;
569: END IF;
570: IF (x_avlv_rec.end_date = OKC_API.G_MISS_DATE) THEN
571: x_avlv_rec.end_date := l_avlv_rec.end_date;
572: END IF;
573: IF (x_avlv_rec.accrual_yn = OKC_API.G_MISS_CHAR) THEN
574: x_avlv_rec.accrual_yn := l_avlv_rec.accrual_yn;
575: END IF;
576: IF (x_avlv_rec.org_id = OKC_API.G_MISS_NUM) THEN
577: x_avlv_rec.org_id := l_avlv_rec.org_id;
572: END IF;
573: IF (x_avlv_rec.accrual_yn = OKC_API.G_MISS_CHAR) THEN
574: x_avlv_rec.accrual_yn := l_avlv_rec.accrual_yn;
575: END IF;
576: IF (x_avlv_rec.org_id = OKC_API.G_MISS_NUM) THEN
577: x_avlv_rec.org_id := l_avlv_rec.org_id;
578: END IF;
579: IF (x_avlv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
580: x_avlv_rec.attribute_category := l_avlv_rec.attribute_category;
575: END IF;
576: IF (x_avlv_rec.org_id = OKC_API.G_MISS_NUM) THEN
577: x_avlv_rec.org_id := l_avlv_rec.org_id;
578: END IF;
579: IF (x_avlv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
580: x_avlv_rec.attribute_category := l_avlv_rec.attribute_category;
581: END IF;
582: IF (x_avlv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
583: x_avlv_rec.attribute1 := l_avlv_rec.attribute1;
578: END IF;
579: IF (x_avlv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
580: x_avlv_rec.attribute_category := l_avlv_rec.attribute_category;
581: END IF;
582: IF (x_avlv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
583: x_avlv_rec.attribute1 := l_avlv_rec.attribute1;
584: END IF;
585: IF (x_avlv_rec.attribute2 = OKC_API.G_MISS_CHAR)
586: THEN
581: END IF;
582: IF (x_avlv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
583: x_avlv_rec.attribute1 := l_avlv_rec.attribute1;
584: END IF;
585: IF (x_avlv_rec.attribute2 = OKC_API.G_MISS_CHAR)
586: THEN
587: x_avlv_rec.attribute2 := l_avlv_rec.attribute2;
588: END IF;
589: IF (x_avlv_rec.attribute3 = OKC_API.G_MISS_CHAR)
585: IF (x_avlv_rec.attribute2 = OKC_API.G_MISS_CHAR)
586: THEN
587: x_avlv_rec.attribute2 := l_avlv_rec.attribute2;
588: END IF;
589: IF (x_avlv_rec.attribute3 = OKC_API.G_MISS_CHAR)
590: THEN
591: x_avlv_rec.attribute3 := l_avlv_rec.attribute3;
592: END IF;
593: IF (x_avlv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
589: IF (x_avlv_rec.attribute3 = OKC_API.G_MISS_CHAR)
590: THEN
591: x_avlv_rec.attribute3 := l_avlv_rec.attribute3;
592: END IF;
593: IF (x_avlv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
594: x_avlv_rec.attribute4 := l_avlv_rec.attribute4;
595: END IF;
596: IF (x_avlv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
597: x_avlv_rec.attribute5 := l_avlv_rec.attribute5;
592: END IF;
593: IF (x_avlv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
594: x_avlv_rec.attribute4 := l_avlv_rec.attribute4;
595: END IF;
596: IF (x_avlv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
597: x_avlv_rec.attribute5 := l_avlv_rec.attribute5;
598: END IF;
599: IF (x_avlv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
600: x_avlv_rec.attribute6 := l_avlv_rec.attribute6;
595: END IF;
596: IF (x_avlv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
597: x_avlv_rec.attribute5 := l_avlv_rec.attribute5;
598: END IF;
599: IF (x_avlv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
600: x_avlv_rec.attribute6 := l_avlv_rec.attribute6;
601: END IF;
602: IF (x_avlv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
603: x_avlv_rec.attribute7 := l_avlv_rec.attribute7;
598: END IF;
599: IF (x_avlv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
600: x_avlv_rec.attribute6 := l_avlv_rec.attribute6;
601: END IF;
602: IF (x_avlv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
603: x_avlv_rec.attribute7 := l_avlv_rec.attribute7;
604: END IF;
605: IF (x_avlv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
606: x_avlv_rec.attribute8 := l_avlv_rec.attribute8;
601: END IF;
602: IF (x_avlv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
603: x_avlv_rec.attribute7 := l_avlv_rec.attribute7;
604: END IF;
605: IF (x_avlv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
606: x_avlv_rec.attribute8 := l_avlv_rec.attribute8;
607: END IF;
608: IF (x_avlv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
609: x_avlv_rec.attribute9 := l_avlv_rec.attribute9;
604: END IF;
605: IF (x_avlv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
606: x_avlv_rec.attribute8 := l_avlv_rec.attribute8;
607: END IF;
608: IF (x_avlv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
609: x_avlv_rec.attribute9 := l_avlv_rec.attribute9;
610: END IF;
611: IF (x_avlv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
612: x_avlv_rec.attribute10 := l_avlv_rec.attribute10;
607: END IF;
608: IF (x_avlv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
609: x_avlv_rec.attribute9 := l_avlv_rec.attribute9;
610: END IF;
611: IF (x_avlv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
612: x_avlv_rec.attribute10 := l_avlv_rec.attribute10;
613: END IF;
614: IF (x_avlv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
615: x_avlv_rec.attribute11 := l_avlv_rec.attribute11;
610: END IF;
611: IF (x_avlv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
612: x_avlv_rec.attribute10 := l_avlv_rec.attribute10;
613: END IF;
614: IF (x_avlv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
615: x_avlv_rec.attribute11 := l_avlv_rec.attribute11;
616: END IF;
617: IF (x_avlv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
618: x_avlv_rec.attribute12 := l_avlv_rec.attribute12;
613: END IF;
614: IF (x_avlv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
615: x_avlv_rec.attribute11 := l_avlv_rec.attribute11;
616: END IF;
617: IF (x_avlv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
618: x_avlv_rec.attribute12 := l_avlv_rec.attribute12;
619: END IF;
620: IF (x_avlv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
621: x_avlv_rec.attribute13 := l_avlv_rec.attribute13;
616: END IF;
617: IF (x_avlv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
618: x_avlv_rec.attribute12 := l_avlv_rec.attribute12;
619: END IF;
620: IF (x_avlv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
621: x_avlv_rec.attribute13 := l_avlv_rec.attribute13;
622: END IF;
623: IF (x_avlv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
624: x_avlv_rec.attribute14 := l_avlv_rec.attribute14;
619: END IF;
620: IF (x_avlv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
621: x_avlv_rec.attribute13 := l_avlv_rec.attribute13;
622: END IF;
623: IF (x_avlv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
624: x_avlv_rec.attribute14 := l_avlv_rec.attribute14;
625: END IF;
626: IF (x_avlv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
627: x_avlv_rec.attribute15 := l_avlv_rec.attribute15;
622: END IF;
623: IF (x_avlv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
624: x_avlv_rec.attribute14 := l_avlv_rec.attribute14;
625: END IF;
626: IF (x_avlv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
627: x_avlv_rec.attribute15 := l_avlv_rec.attribute15;
628: END IF;
629: IF (x_avlv_rec.created_by = OKC_API.G_MISS_NUM) THEN
630: x_avlv_rec.created_by := l_avlv_rec.created_by;
625: END IF;
626: IF (x_avlv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
627: x_avlv_rec.attribute15 := l_avlv_rec.attribute15;
628: END IF;
629: IF (x_avlv_rec.created_by = OKC_API.G_MISS_NUM) THEN
630: x_avlv_rec.created_by := l_avlv_rec.created_by;
631: END IF;
632: IF (x_avlv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
633: x_avlv_rec.creation_date := l_avlv_rec.creation_date;
628: END IF;
629: IF (x_avlv_rec.created_by = OKC_API.G_MISS_NUM) THEN
630: x_avlv_rec.created_by := l_avlv_rec.created_by;
631: END IF;
632: IF (x_avlv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
633: x_avlv_rec.creation_date := l_avlv_rec.creation_date;
634: END IF;
635: IF (x_avlv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
636: x_avlv_rec.last_updated_by := l_avlv_rec.last_updated_by;
631: END IF;
632: IF (x_avlv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
633: x_avlv_rec.creation_date := l_avlv_rec.creation_date;
634: END IF;
635: IF (x_avlv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
636: x_avlv_rec.last_updated_by := l_avlv_rec.last_updated_by;
637: END IF;
638: IF (x_avlv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
639: x_avlv_rec.last_update_date := l_avlv_rec.last_update_date;
634: END IF;
635: IF (x_avlv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
636: x_avlv_rec.last_updated_by := l_avlv_rec.last_updated_by;
637: END IF;
638: IF (x_avlv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
639: x_avlv_rec.last_update_date := l_avlv_rec.last_update_date;
640: END IF;
641: IF (x_avlv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
642: x_avlv_rec.last_update_login := l_avlv_rec.last_update_login;
637: END IF;
638: IF (x_avlv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
639: x_avlv_rec.last_update_date := l_avlv_rec.last_update_date;
640: END IF;
641: IF (x_avlv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
642: x_avlv_rec.last_update_login := l_avlv_rec.last_update_login;
643: END IF;
644:
645: RETURN(l_return_status);
734: x_atlv_rec OUT NOCOPY atlv_rec_type
735: ) RETURN VARCHAR2 IS
736: l_atlv_rec atlv_rec_type;
737: l_row_notfound BOOLEAN := TRUE;
738: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
739: BEGIN
740: x_atlv_rec := p_atlv_rec;
741: -- Get current database values
742: l_atlv_rec := get_rec_atl(p_atlv_rec, l_row_notfound);
740: x_atlv_rec := p_atlv_rec;
741: -- Get current database values
742: l_atlv_rec := get_rec_atl(p_atlv_rec, l_row_notfound);
743: IF (l_row_notfound) THEN
744: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
745: END IF;
746: IF (x_atlv_rec.id = OKC_API.G_MISS_NUM)
747: THEN
748: x_atlv_rec.id := l_atlv_rec.id;
742: l_atlv_rec := get_rec_atl(p_atlv_rec, l_row_notfound);
743: IF (l_row_notfound) THEN
744: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
745: END IF;
746: IF (x_atlv_rec.id = OKC_API.G_MISS_NUM)
747: THEN
748: x_atlv_rec.id := l_atlv_rec.id;
749: END IF;
750: IF (x_atlv_rec.object_version_number = OKC_API.G_MISS_NUM)
746: IF (x_atlv_rec.id = OKC_API.G_MISS_NUM)
747: THEN
748: x_atlv_rec.id := l_atlv_rec.id;
749: END IF;
750: IF (x_atlv_rec.object_version_number = OKC_API.G_MISS_NUM)
751: THEN
752: x_atlv_rec.object_version_number := l_atlv_rec.object_version_number;
753: END IF;
754: IF (x_atlv_rec.avl_id = OKC_API.G_MISS_NUM)
750: IF (x_atlv_rec.object_version_number = OKC_API.G_MISS_NUM)
751: THEN
752: x_atlv_rec.object_version_number := l_atlv_rec.object_version_number;
753: END IF;
754: IF (x_atlv_rec.avl_id = OKC_API.G_MISS_NUM)
755: THEN
756: x_atlv_rec.avl_id := l_atlv_rec.avl_id;
757: END IF;
758: IF (x_atlv_rec.crd_code = OKC_API.G_MISS_CHAR)
754: IF (x_atlv_rec.avl_id = OKC_API.G_MISS_NUM)
755: THEN
756: x_atlv_rec.avl_id := l_atlv_rec.avl_id;
757: END IF;
758: IF (x_atlv_rec.crd_code = OKC_API.G_MISS_CHAR)
759: THEN
760: x_atlv_rec.crd_code := l_atlv_rec.crd_code;
761: END IF;
762: IF (x_atlv_rec.code_combination_id = OKC_API.G_MISS_NUM)
758: IF (x_atlv_rec.crd_code = OKC_API.G_MISS_CHAR)
759: THEN
760: x_atlv_rec.crd_code := l_atlv_rec.crd_code;
761: END IF;
762: IF (x_atlv_rec.code_combination_id = OKC_API.G_MISS_NUM)
763: THEN
764: x_atlv_rec.code_combination_id := l_atlv_rec.code_combination_id;
765: END IF;
766: IF (x_atlv_rec.ae_line_type = OKC_API.G_MISS_CHAR)
762: IF (x_atlv_rec.code_combination_id = OKC_API.G_MISS_NUM)
763: THEN
764: x_atlv_rec.code_combination_id := l_atlv_rec.code_combination_id;
765: END IF;
766: IF (x_atlv_rec.ae_line_type = OKC_API.G_MISS_CHAR)
767: THEN
768: x_atlv_rec.ae_line_type := l_atlv_rec.ae_line_type;
769: END IF;
770: IF (x_atlv_rec.sequence_number = OKC_API.G_MISS_NUM)
766: IF (x_atlv_rec.ae_line_type = OKC_API.G_MISS_CHAR)
767: THEN
768: x_atlv_rec.ae_line_type := l_atlv_rec.ae_line_type;
769: END IF;
770: IF (x_atlv_rec.sequence_number = OKC_API.G_MISS_NUM)
771: THEN
772: x_atlv_rec.sequence_number := l_atlv_rec.sequence_number;
773: END IF;
774: IF (x_atlv_rec.description = OKC_API.G_MISS_CHAR)
770: IF (x_atlv_rec.sequence_number = OKC_API.G_MISS_NUM)
771: THEN
772: x_atlv_rec.sequence_number := l_atlv_rec.sequence_number;
773: END IF;
774: IF (x_atlv_rec.description = OKC_API.G_MISS_CHAR)
775: THEN
776: x_atlv_rec.description := l_atlv_rec.description;
777: END IF;
778: IF (x_atlv_rec.percentage = OKC_API.G_MISS_NUM)
774: IF (x_atlv_rec.description = OKC_API.G_MISS_CHAR)
775: THEN
776: x_atlv_rec.description := l_atlv_rec.description;
777: END IF;
778: IF (x_atlv_rec.percentage = OKC_API.G_MISS_NUM)
779: THEN
780: x_atlv_rec.percentage := l_atlv_rec.percentage;
781: END IF;
782: IF (x_atlv_rec.account_builder_yn = OKC_API.G_MISS_CHAR)
778: IF (x_atlv_rec.percentage = OKC_API.G_MISS_NUM)
779: THEN
780: x_atlv_rec.percentage := l_atlv_rec.percentage;
781: END IF;
782: IF (x_atlv_rec.account_builder_yn = OKC_API.G_MISS_CHAR)
783: THEN
784: x_atlv_rec.account_builder_yn := l_atlv_rec.account_builder_yn;
785: END IF;
786: IF (x_atlv_rec.attribute_category = OKC_API.G_MISS_CHAR)
782: IF (x_atlv_rec.account_builder_yn = OKC_API.G_MISS_CHAR)
783: THEN
784: x_atlv_rec.account_builder_yn := l_atlv_rec.account_builder_yn;
785: END IF;
786: IF (x_atlv_rec.attribute_category = OKC_API.G_MISS_CHAR)
787: THEN
788: x_atlv_rec.attribute_category := l_atlv_rec.attribute_category;
789: END IF;
790: IF (x_atlv_rec.attribute1 = OKC_API.G_MISS_CHAR)
786: IF (x_atlv_rec.attribute_category = OKC_API.G_MISS_CHAR)
787: THEN
788: x_atlv_rec.attribute_category := l_atlv_rec.attribute_category;
789: END IF;
790: IF (x_atlv_rec.attribute1 = OKC_API.G_MISS_CHAR)
791: THEN
792: x_atlv_rec.attribute1 := l_atlv_rec.attribute1;
793: END IF;
794: IF (x_atlv_rec.attribute2 = OKC_API.G_MISS_CHAR)
790: IF (x_atlv_rec.attribute1 = OKC_API.G_MISS_CHAR)
791: THEN
792: x_atlv_rec.attribute1 := l_atlv_rec.attribute1;
793: END IF;
794: IF (x_atlv_rec.attribute2 = OKC_API.G_MISS_CHAR)
795: THEN
796: x_atlv_rec.attribute2 := l_atlv_rec.attribute2;
797: END IF;
798: IF (x_atlv_rec.attribute3 = OKC_API.G_MISS_CHAR)
794: IF (x_atlv_rec.attribute2 = OKC_API.G_MISS_CHAR)
795: THEN
796: x_atlv_rec.attribute2 := l_atlv_rec.attribute2;
797: END IF;
798: IF (x_atlv_rec.attribute3 = OKC_API.G_MISS_CHAR)
799: THEN
800: x_atlv_rec.attribute3 := l_atlv_rec.attribute3;
801: END IF;
802: IF (x_atlv_rec.attribute4 = OKC_API.G_MISS_CHAR)
798: IF (x_atlv_rec.attribute3 = OKC_API.G_MISS_CHAR)
799: THEN
800: x_atlv_rec.attribute3 := l_atlv_rec.attribute3;
801: END IF;
802: IF (x_atlv_rec.attribute4 = OKC_API.G_MISS_CHAR)
803: THEN
804: x_atlv_rec.attribute4 := l_atlv_rec.attribute4;
805: END IF;
806: IF (x_atlv_rec.attribute5 = OKC_API.G_MISS_CHAR)
802: IF (x_atlv_rec.attribute4 = OKC_API.G_MISS_CHAR)
803: THEN
804: x_atlv_rec.attribute4 := l_atlv_rec.attribute4;
805: END IF;
806: IF (x_atlv_rec.attribute5 = OKC_API.G_MISS_CHAR)
807: THEN
808: x_atlv_rec.attribute5 := l_atlv_rec.attribute5;
809: END IF;
810: IF (x_atlv_rec.attribute6 = OKC_API.G_MISS_CHAR)
806: IF (x_atlv_rec.attribute5 = OKC_API.G_MISS_CHAR)
807: THEN
808: x_atlv_rec.attribute5 := l_atlv_rec.attribute5;
809: END IF;
810: IF (x_atlv_rec.attribute6 = OKC_API.G_MISS_CHAR)
811: THEN
812: x_atlv_rec.attribute6 := l_atlv_rec.attribute6;
813: END IF;
814: IF (x_atlv_rec.attribute7 = OKC_API.G_MISS_CHAR)
810: IF (x_atlv_rec.attribute6 = OKC_API.G_MISS_CHAR)
811: THEN
812: x_atlv_rec.attribute6 := l_atlv_rec.attribute6;
813: END IF;
814: IF (x_atlv_rec.attribute7 = OKC_API.G_MISS_CHAR)
815: THEN
816: x_atlv_rec.attribute7 := l_atlv_rec.attribute7;
817: END IF;
818: IF (x_atlv_rec.attribute8 = OKC_API.G_MISS_CHAR)
814: IF (x_atlv_rec.attribute7 = OKC_API.G_MISS_CHAR)
815: THEN
816: x_atlv_rec.attribute7 := l_atlv_rec.attribute7;
817: END IF;
818: IF (x_atlv_rec.attribute8 = OKC_API.G_MISS_CHAR)
819: THEN
820: x_atlv_rec.attribute8 := l_atlv_rec.attribute8;
821: END IF;
822: IF (x_atlv_rec.attribute9 = OKC_API.G_MISS_CHAR)
818: IF (x_atlv_rec.attribute8 = OKC_API.G_MISS_CHAR)
819: THEN
820: x_atlv_rec.attribute8 := l_atlv_rec.attribute8;
821: END IF;
822: IF (x_atlv_rec.attribute9 = OKC_API.G_MISS_CHAR)
823: THEN
824: x_atlv_rec.attribute9 := l_atlv_rec.attribute9;
825: END IF;
826: IF (x_atlv_rec.attribute10 = OKC_API.G_MISS_CHAR)
822: IF (x_atlv_rec.attribute9 = OKC_API.G_MISS_CHAR)
823: THEN
824: x_atlv_rec.attribute9 := l_atlv_rec.attribute9;
825: END IF;
826: IF (x_atlv_rec.attribute10 = OKC_API.G_MISS_CHAR)
827: THEN
828: x_atlv_rec.attribute10 := l_atlv_rec.attribute10;
829: END IF;
830: IF (x_atlv_rec.attribute11 = OKC_API.G_MISS_CHAR)
826: IF (x_atlv_rec.attribute10 = OKC_API.G_MISS_CHAR)
827: THEN
828: x_atlv_rec.attribute10 := l_atlv_rec.attribute10;
829: END IF;
830: IF (x_atlv_rec.attribute11 = OKC_API.G_MISS_CHAR)
831: THEN
832: x_atlv_rec.attribute11 := l_atlv_rec.attribute11;
833: END IF;
834: IF (x_atlv_rec.attribute12 = OKC_API.G_MISS_CHAR)
830: IF (x_atlv_rec.attribute11 = OKC_API.G_MISS_CHAR)
831: THEN
832: x_atlv_rec.attribute11 := l_atlv_rec.attribute11;
833: END IF;
834: IF (x_atlv_rec.attribute12 = OKC_API.G_MISS_CHAR)
835: THEN
836: x_atlv_rec.attribute12 := l_atlv_rec.attribute12;
837: END IF;
838: IF (x_atlv_rec.attribute13 = OKC_API.G_MISS_CHAR)
834: IF (x_atlv_rec.attribute12 = OKC_API.G_MISS_CHAR)
835: THEN
836: x_atlv_rec.attribute12 := l_atlv_rec.attribute12;
837: END IF;
838: IF (x_atlv_rec.attribute13 = OKC_API.G_MISS_CHAR)
839: THEN
840: x_atlv_rec.attribute13 := l_atlv_rec.attribute13;
841: END IF;
842: IF (x_atlv_rec.attribute14 = OKC_API.G_MISS_CHAR)
838: IF (x_atlv_rec.attribute13 = OKC_API.G_MISS_CHAR)
839: THEN
840: x_atlv_rec.attribute13 := l_atlv_rec.attribute13;
841: END IF;
842: IF (x_atlv_rec.attribute14 = OKC_API.G_MISS_CHAR)
843: THEN
844: x_atlv_rec.attribute14 := l_atlv_rec.attribute14;
845: END IF;
846: IF (x_atlv_rec.attribute15 = OKC_API.G_MISS_CHAR)
842: IF (x_atlv_rec.attribute14 = OKC_API.G_MISS_CHAR)
843: THEN
844: x_atlv_rec.attribute14 := l_atlv_rec.attribute14;
845: END IF;
846: IF (x_atlv_rec.attribute15 = OKC_API.G_MISS_CHAR)
847: THEN
848: x_atlv_rec.attribute15 := l_atlv_rec.attribute15;
849: END IF;
850: IF (x_atlv_rec.org_id = OKC_API.G_MISS_NUM)
846: IF (x_atlv_rec.attribute15 = OKC_API.G_MISS_CHAR)
847: THEN
848: x_atlv_rec.attribute15 := l_atlv_rec.attribute15;
849: END IF;
850: IF (x_atlv_rec.org_id = OKC_API.G_MISS_NUM)
851: THEN
852: x_atlv_rec.org_id := l_atlv_rec.org_id;
853: END IF;
854: IF (x_atlv_rec.created_by = OKC_API.G_MISS_NUM)
850: IF (x_atlv_rec.org_id = OKC_API.G_MISS_NUM)
851: THEN
852: x_atlv_rec.org_id := l_atlv_rec.org_id;
853: END IF;
854: IF (x_atlv_rec.created_by = OKC_API.G_MISS_NUM)
855: THEN
856: x_atlv_rec.created_by := l_atlv_rec.created_by;
857: END IF;
858: IF (x_atlv_rec.creation_date = OKC_API.G_MISS_DATE)
854: IF (x_atlv_rec.created_by = OKC_API.G_MISS_NUM)
855: THEN
856: x_atlv_rec.created_by := l_atlv_rec.created_by;
857: END IF;
858: IF (x_atlv_rec.creation_date = OKC_API.G_MISS_DATE)
859: THEN
860: x_atlv_rec.creation_date := l_atlv_rec.creation_date;
861: END IF;
862: IF (x_atlv_rec.last_updated_by = OKC_API.G_MISS_NUM)
858: IF (x_atlv_rec.creation_date = OKC_API.G_MISS_DATE)
859: THEN
860: x_atlv_rec.creation_date := l_atlv_rec.creation_date;
861: END IF;
862: IF (x_atlv_rec.last_updated_by = OKC_API.G_MISS_NUM)
863: THEN
864: x_atlv_rec.last_updated_by := l_atlv_rec.last_updated_by;
865: END IF;
866: IF (x_atlv_rec.last_update_date = OKC_API.G_MISS_DATE)
862: IF (x_atlv_rec.last_updated_by = OKC_API.G_MISS_NUM)
863: THEN
864: x_atlv_rec.last_updated_by := l_atlv_rec.last_updated_by;
865: END IF;
866: IF (x_atlv_rec.last_update_date = OKC_API.G_MISS_DATE)
867: THEN
868: x_atlv_rec.last_update_date := l_atlv_rec.last_update_date;
869: END IF;
870: IF (x_atlv_rec.last_update_login = OKC_API.G_MISS_NUM)
866: IF (x_atlv_rec.last_update_date = OKC_API.G_MISS_DATE)
867: THEN
868: x_atlv_rec.last_update_date := l_atlv_rec.last_update_date;
869: END IF;
870: IF (x_atlv_rec.last_update_login = OKC_API.G_MISS_NUM)
871: THEN
872: x_atlv_rec.last_update_login := l_atlv_rec.last_update_login;
873: END IF;
874: RETURN(l_return_status);
1154:
1155:
1156: PROCEDURE create_tmpt_set(
1157: p_api_version IN NUMBER
1158: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1159: ,x_return_status OUT NOCOPY VARCHAR2
1160: ,x_msg_count OUT NOCOPY NUMBER
1161: ,x_msg_data OUT NOCOPY VARCHAR2
1162: ,p_aesv_rec IN aesv_rec_type
1208: END create_tmpt_set;
1209:
1210:
1211: PROCEDURE update_tmpt_set(p_api_version IN NUMBER
1212: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1213: ,x_return_status OUT NOCOPY VARCHAR2
1214: ,x_msg_count OUT NOCOPY NUMBER
1215: ,x_msg_data OUT NOCOPY VARCHAR2
1216: ,p_aesv_rec IN aesv_rec_type
1282:
1283:
1284:
1285: PROCEDURE create_tmpt_set(p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1287: x_return_status OUT NOCOPY VARCHAR2,
1288: x_msg_count OUT NOCOPY NUMBER,
1289: x_msg_data OUT NOCOPY VARCHAR2,
1290: p_aesv_tbl IN aesv_tbl_type,
1336:
1337:
1338:
1339: PROCEDURE create_tmpt_set(p_api_version IN NUMBER,
1340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1341: x_return_status OUT NOCOPY VARCHAR2,
1342: x_msg_count OUT NOCOPY NUMBER,
1343: x_msg_data OUT NOCOPY VARCHAR2,
1344: p_aesv_rec IN aesv_rec_type,
1490:
1491: END create_tmpt_set;
1492:
1493: PROCEDURE update_tmpt_set(p_api_version IN NUMBER,
1494: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1495: x_return_status OUT NOCOPY VARCHAR2,
1496: x_msg_count OUT NOCOPY NUMBER,
1497: x_msg_data OUT NOCOPY VARCHAR2,
1498: p_aesv_tbl IN aesv_tbl_type,
1543:
1544:
1545:
1546: PROCEDURE update_tmpt_set(p_api_version IN NUMBER,
1547: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1548: x_return_status OUT NOCOPY VARCHAR2,
1549: x_msg_count OUT NOCOPY NUMBER,
1550: x_msg_data OUT NOCOPY VARCHAR2,
1551: p_aesv_rec IN aesv_rec_type,
1657:
1658:
1659: PROCEDURE delete_tmpt_set(
1660: p_api_version IN NUMBER,
1661: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1662: x_return_status OUT NOCOPY VARCHAR2,
1663: x_msg_count OUT NOCOPY NUMBER,
1664: x_msg_data OUT NOCOPY VARCHAR2,
1665: p_aesv_tbl IN aesv_tbl_type)
1697:
1698:
1699: PROCEDURE delete_tmpt_set(
1700: p_api_version IN NUMBER,
1701: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1702: x_return_status OUT NOCOPY VARCHAR2,
1703: x_msg_count OUT NOCOPY NUMBER,
1704: x_msg_data OUT NOCOPY VARCHAR2,
1705: p_aesv_rec IN aesv_rec_type)
1737:
1738:
1739:
1740: PROCEDURE create_template(p_api_version IN NUMBER,
1741: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_avlv_rec IN avlv_rec_type,
1889: END create_template;
1890:
1891:
1892: PROCEDURE create_template(p_api_version IN NUMBER,
1893: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1894: x_return_status OUT NOCOPY VARCHAR2,
1895: x_msg_count OUT NOCOPY NUMBER,
1896: x_msg_data OUT NOCOPY VARCHAR2,
1897: p_avlv_tbl IN avlv_tbl_type,
1932: END create_template;
1933:
1934:
1935: PROCEDURE update_template(p_api_version IN NUMBER,
1936: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1937: x_return_status OUT NOCOPY VARCHAR2,
1938: x_msg_count OUT NOCOPY NUMBER,
1939: x_msg_data OUT NOCOPY VARCHAR2,
1940: p_avlv_rec IN avlv_rec_type,
2171:
2172:
2173: PROCEDURE update_template(
2174: p_api_version IN NUMBER,
2175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2176: x_return_status OUT NOCOPY VARCHAR2,
2177: x_msg_count OUT NOCOPY NUMBER,
2178: x_msg_data OUT NOCOPY VARCHAR2,
2179: p_avlv_tbl IN avlv_tbl_type,
2185: l_overall_Status VARCHAR2(1) := G_RET_STS_SUCCESS;
2186:
2187: BEGIN
2188:
2189: Okc_Api.init_msg_list(p_init_msg_list);
2190: FOR i IN 1..p_avlv_tbl.COUNT LOOP
2191:
2192: update_template(p_api_version => l_api_version,
2193: p_init_msg_list => p_init_msg_list,
2212:
2213:
2214: PROCEDURE delete_template(
2215: p_api_version IN NUMBER,
2216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2217: x_return_status OUT NOCOPY VARCHAR2,
2218: x_msg_count OUT NOCOPY NUMBER,
2219: x_msg_data OUT NOCOPY VARCHAR2,
2220: p_avlv_tbl IN avlv_tbl_type)
2251:
2252:
2253: PROCEDURE delete_template(
2254: p_api_version IN NUMBER,
2255: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2256: x_return_status OUT NOCOPY VARCHAR2,
2257: x_msg_count OUT NOCOPY NUMBER,
2258: x_msg_data OUT NOCOPY VARCHAR2,
2259: p_avlv_rec IN avlv_rec_type)
2289: END delete_template;
2290:
2291:
2292: PROCEDURE create_tmpt_lines(p_api_version IN NUMBER,
2293: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2294: x_return_status OUT NOCOPY VARCHAR2,
2295: x_msg_count OUT NOCOPY NUMBER,
2296: x_msg_data OUT NOCOPY VARCHAR2,
2297: p_atlv_tbl IN atlv_tbl_type,
2331:
2332:
2333:
2334: PROCEDURE create_tmpt_lines(p_api_version IN NUMBER,
2335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2336: x_return_status OUT NOCOPY VARCHAR2,
2337: x_msg_count OUT NOCOPY NUMBER,
2338: x_msg_data OUT NOCOPY VARCHAR2,
2339: p_atlv_rec IN atlv_rec_type,
2364:
2365: -- If CCID is NULL and Account_Builder_YN is N then raise Error
2366:
2367: IF ((p_atlv_rec.CODE_COMBINATION_ID IS NULL) OR
2368: (p_atlv_rec.CODE_COMBINATION_ID = OKC_API.G_MISS_NUM))
2369: AND
2370: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'N')
2371: THEN
2372: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2370: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'N')
2371: THEN
2372: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2373: p_msg_name => 'OKL_CCID_OR_BUILDER_REQD');
2374: x_return_status := OKC_API.G_RET_STS_ERROR;
2375: RAISE OKL_API.G_EXCEPTION_ERROR;
2376:
2377: END IF;
2378:
2382: /*
2383: -- If CCID is given then Account Builder YN cannot be 'Y'
2384:
2385: IF ((p_atlv_rec.CODE_COMBINATION_ID IS NOT NULL) AND
2386: (p_atlv_rec.CODE_COMBINATION_ID <> OKC_API.G_MISS_NUM))
2387: AND
2388: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'Y' )
2389: THEN
2390: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2388: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'Y' )
2389: THEN
2390: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2391: p_msg_name => 'OKL_GIVE_CCID_OR_BUILDER');
2392: x_return_status := OKC_API.G_RET_STS_ERROR;
2393: RAISE OKL_API.G_EXCEPTION_ERROR;
2394:
2395: END IF;
2396: */
2492:
2493:
2494:
2495: PROCEDURE update_tmpt_lines(p_api_version IN NUMBER,
2496: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2497: x_return_status OUT NOCOPY VARCHAR2,
2498: x_msg_count OUT NOCOPY NUMBER,
2499: x_msg_data OUT NOCOPY VARCHAR2,
2500: p_atlv_tbl IN atlv_tbl_type,
2691:
2692:
2693:
2694: PROCEDURE update_tmpt_lines(p_api_version IN NUMBER,
2695: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2696: x_return_status OUT NOCOPY VARCHAR2,
2697: x_msg_count OUT NOCOPY NUMBER,
2698: x_msg_data OUT NOCOPY VARCHAR2,
2699: p_atlv_rec IN atlv_rec_type,
2723:
2724: -- If CCID is NULL and Account_Builder_YN is N then raise Error
2725:
2726: IF ((p_atlv_rec.CODE_COMBINATION_ID IS NULL) OR
2727: (p_atlv_rec.CODE_COMBINATION_ID = OKC_API.G_MISS_NUM))
2728: AND
2729: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'N')
2730: THEN
2731: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2729: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'N')
2730: THEN
2731: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2732: p_msg_name => 'OKL_CCID_OR_BUILDER_REQD');
2733: x_return_status := OKC_API.G_RET_STS_ERROR;
2734: RAISE OKL_API.G_EXCEPTION_ERROR;
2735:
2736: END IF;
2737:
2743:
2744: -- If CCID is given then Account Builder YN cannot be 'Y'
2745:
2746: IF ((p_atlv_rec.CODE_COMBINATION_ID IS NOT NULL) AND
2747: (p_atlv_rec.CODE_COMBINATION_ID <> OKC_API.G_MISS_NUM))
2748: AND
2749: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'Y' )
2750: THEN
2751: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2749: (p_atlv_rec.ACCOUNT_BUILDER_YN = 'Y' )
2750: THEN
2751: OKL_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME,
2752: p_msg_name => 'OKL_GIVE_CCID_OR_BUILDER');
2753: x_return_status := OKC_API.G_RET_STS_ERROR;
2754: RAISE OKL_API.G_EXCEPTION_ERROR;
2755:
2756: END IF;
2757:
2853:
2854:
2855:
2856: PROCEDURE delete_tmpt_lines(p_api_version IN NUMBER,
2857: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2858: x_return_status OUT NOCOPY VARCHAR2,
2859: x_msg_count OUT NOCOPY NUMBER,
2860: x_msg_data OUT NOCOPY VARCHAR2,
2861: p_atlv_tbl IN atlv_tbl_type)
2895:
2896:
2897:
2898: PROCEDURE delete_tmpt_lines(p_api_version IN NUMBER,
2899: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2900: x_return_status OUT NOCOPY VARCHAR2,
2901: x_msg_count OUT NOCOPY NUMBER,
2902: x_msg_data OUT NOCOPY VARCHAR2,
2903: p_atlv_rec IN atlv_rec_type)