eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROCESS_TMPT_SET_PVT dependencies on OKC_API

Line 499: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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

Line 507: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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;

Line 510: IF (x_avlv_rec.id = OKC_API.G_MISS_NUM) THEN

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

Line 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;

Line 517: IF (x_avlv_rec.set_of_books_id = OKC_API.G_MISS_NUM) THEN

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;

Line 520: IF (x_avlv_rec.sty_id = OKC_API.G_MISS_NUM) THEN

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;

Line 523: IF (x_avlv_rec.try_id = OKC_API.G_MISS_NUM) THEN

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;

Line 526: IF (x_avlv_rec.aes_id = OKC_API.G_MISS_NUM) THEN

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;

Line 529: IF (x_avlv_rec.syt_code = OKC_API.G_MISS_CHAR) THEN

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

Line 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

Line 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;

Line 540: IF (x_avlv_rec.fma_id = OKC_API.G_MISS_NUM) THEN

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;

Line 543: IF (x_avlv_rec.advance_arrears = OKC_API.G_MISS_CHAR) THEN

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;

Line 546: IF (x_avlv_rec.post_to_gl = OKC_API.G_MISS_CHAR) THEN

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;

Line 549: IF (x_avlv_rec.version = OKC_API.G_MISS_CHAR) THEN

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;

Line 552: IF (x_avlv_rec.start_date = OKC_API.G_MISS_DATE) THEN

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;

Line 555: IF (x_avlv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

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;

Line 558: IF (x_avlv_rec.memo_yn = OKC_API.G_MISS_CHAR) THEN

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;

Line 561: IF (x_avlv_rec.prior_year_yn = OKC_API.G_MISS_CHAR) THEN

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;

Line 564: IF (x_avlv_rec.description = OKC_API.G_MISS_CHAR) THEN

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;

Line 567: IF (x_avlv_rec.factoring_synd_flag = OKC_API.G_MISS_CHAR) THEN

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;

Line 570: IF (x_avlv_rec.end_date = OKC_API.G_MISS_DATE) THEN

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;

Line 573: IF (x_avlv_rec.accrual_yn = OKC_API.G_MISS_CHAR) THEN

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;

Line 576: IF (x_avlv_rec.org_id = OKC_API.G_MISS_NUM) THEN

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;

Line 579: IF (x_avlv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN

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;

Line 582: IF (x_avlv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN

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

Line 585: IF (x_avlv_rec.attribute2 = OKC_API.G_MISS_CHAR)

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)

Line 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

Line 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;

Line 596: IF (x_avlv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN

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;

Line 599: IF (x_avlv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN

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;

Line 602: IF (x_avlv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN

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;

Line 605: IF (x_avlv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN

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;

Line 608: IF (x_avlv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN

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;

Line 611: IF (x_avlv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN

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;

Line 614: IF (x_avlv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN

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;

Line 617: IF (x_avlv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN

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;

Line 620: IF (x_avlv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN

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;

Line 623: IF (x_avlv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN

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;

Line 626: IF (x_avlv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN

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;

Line 629: IF (x_avlv_rec.created_by = OKC_API.G_MISS_NUM) THEN

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;

Line 632: IF (x_avlv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

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;

Line 635: IF (x_avlv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

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;

Line 638: IF (x_avlv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

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;

Line 641: IF (x_avlv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

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);

Line 738: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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);

Line 744: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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;

Line 746: IF (x_atlv_rec.id = OKC_API.G_MISS_NUM)

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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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);

Line 1158: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 1212: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 1286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 1340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 1494: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 1547: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 1661: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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)

Line 1701: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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)

Line 1741: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 1893: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 1936: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 2175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 2189: Okc_Api.init_msg_list(p_init_msg_list);

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,

Line 2216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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)

Line 2255: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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)

Line 2293: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 2335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 2368: (p_atlv_rec.CODE_COMBINATION_ID = OKC_API.G_MISS_NUM))

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,

Line 2374: x_return_status := OKC_API.G_RET_STS_ERROR;

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:

Line 2386: (p_atlv_rec.CODE_COMBINATION_ID <> OKC_API.G_MISS_NUM))

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,

Line 2392: x_return_status := OKC_API.G_RET_STS_ERROR;

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: */

Line 2496: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 2695: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 2727: (p_atlv_rec.CODE_COMBINATION_ID = OKC_API.G_MISS_NUM))

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,

Line 2733: x_return_status := OKC_API.G_RET_STS_ERROR;

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:

Line 2747: (p_atlv_rec.CODE_COMBINATION_ID <> OKC_API.G_MISS_NUM))

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,

Line 2753: x_return_status := OKC_API.G_RET_STS_ERROR;

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:

Line 2857: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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)

Line 2899: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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)