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_CFL_PVT dependencies on OKC_API

Line 353: IF (l_cflv_rec.stub_days = OKC_API.G_MISS_NUM ) THEN

349: END IF;
350: IF (l_cflv_rec.level_sequence = OKL_API.G_MISS_NUM ) THEN
351: l_cflv_rec.level_sequence := NULL;
352: END IF;
353: IF (l_cflv_rec.stub_days = OKC_API.G_MISS_NUM ) THEN
354: l_cflv_rec.stub_days := NULL;
355: END IF;
356: IF (l_cflv_rec.stub_amount = OKC_API.G_MISS_NUM ) THEN
357: l_cflv_rec.stub_amount := NULL;

Line 356: IF (l_cflv_rec.stub_amount = OKC_API.G_MISS_NUM ) THEN

352: END IF;
353: IF (l_cflv_rec.stub_days = OKC_API.G_MISS_NUM ) THEN
354: l_cflv_rec.stub_days := NULL;
355: END IF;
356: IF (l_cflv_rec.stub_amount = OKC_API.G_MISS_NUM ) THEN
357: l_cflv_rec.stub_amount := NULL;
358: END IF;
359: IF (l_cflv_rec.start_date = OKC_API.G_MISS_DATE ) THEN
360: l_cflv_rec.start_date := NULL;

Line 359: IF (l_cflv_rec.start_date = OKC_API.G_MISS_DATE ) THEN

355: END IF;
356: IF (l_cflv_rec.stub_amount = OKC_API.G_MISS_NUM ) THEN
357: l_cflv_rec.stub_amount := NULL;
358: END IF;
359: IF (l_cflv_rec.start_date = OKC_API.G_MISS_DATE ) THEN
360: l_cflv_rec.start_date := NULL;
361: END IF;
362: IF (l_cflv_rec.rate = OKC_API.G_MISS_NUM ) THEN
363: l_cflv_rec.rate := NULL;

Line 362: IF (l_cflv_rec.rate = OKC_API.G_MISS_NUM ) THEN

358: END IF;
359: IF (l_cflv_rec.start_date = OKC_API.G_MISS_DATE ) THEN
360: l_cflv_rec.start_date := NULL;
361: END IF;
362: IF (l_cflv_rec.rate = OKC_API.G_MISS_NUM ) THEN
363: l_cflv_rec.rate := NULL;
364: END IF;
365: IF (l_cflv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
366: l_cflv_rec.attribute_category := NULL;

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

438: ---------------------------------
439: PROCEDURE validate_id(
440: p_cflv_rec IN cflv_rec_type,
441: x_return_status OUT NOCOPY VARCHAR2) IS
442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
443: BEGIN
444:
445: IF (p_cflv_rec.id = OKL_API.G_MISS_NUM OR p_cflv_rec.id IS NULL)
446: THEN

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

465: -------------------------------------
466: PROCEDURE validate_caf_id(
467: p_cflv_rec IN cflv_rec_type,
468: x_return_status OUT NOCOPY VARCHAR2) IS
469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
470:
471: l_dummy_var VARCHAR2(1) := '?' ;
472:
473: CURSOR okl_cflv_cafv_fk_csr (p_id IN NUMBER) IS

Line 490: OKC_API.set_message(g_app_name,

486: FETCH okl_cflv_cafv_fk_csr into l_dummy_var ;
487: CLOSE okl_cflv_cafv_fk_csr ;
488: -- still set to default means data was not found
489: IF ( l_dummy_var = '?' ) THEN
490: OKC_API.set_message(g_app_name,
491: g_no_parent_record,
492: g_col_name_token,
493: 'caf_id',
494: g_child_table_token ,

Line 498: l_return_status := OKC_API.G_RET_STS_ERROR;

494: g_child_table_token ,
495: 'OKL_CASH_FLOW_LELELS_V',
496: g_parent_table_token ,
497: 'OKL_CASH_FLOWS_V');
498: l_return_status := OKC_API.G_RET_STS_ERROR;
499:
500: END IF;
501: END IF;
502: x_return_status := l_return_status;

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

516: -------------------------------------
517: PROCEDURE validate_amount(
518: p_cflv_rec IN cflv_rec_type,
519: x_return_status OUT NOCOPY VARCHAR2) IS
520: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
521: BEGIN
522:
523: /* IF (p_cflv_rec.amount = OKL_API.G_MISS_NUM OR p_cflv_rec.amount IS NULL)
524: THEN

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

544: ------------------------------------------------
545: PROCEDURE validate_number_of_periods(
546: p_cflv_rec IN cflv_rec_type,
547: x_return_status OUT NOCOPY VARCHAR2) IS
548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
549: BEGIN
550:
551: /* IF (p_cflv_rec.number_of_periods = OKL_API.G_MISS_NUM OR p_cflv_rec.number_of_periods IS NULL)
552: THEN

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

574: -------------------------------------
575: PROCEDURE validate_stub_days(
576: p_cflv_rec IN cflv_rec_type,
577: x_return_status OUT NOCOPY VARCHAR2) IS
578: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
579: BEGIN
580:
581: IF (p_cflv_rec.stub_days <> OKL_API.G_MISS_NUM AND p_cflv_rec.stub_days IS NOT NULL) THEN
582: IF p_cflv_rec.stub_days = 0 THEN

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

604: -------------------------------------
605: PROCEDURE validate_stub_amount(
606: p_cflv_rec IN cflv_rec_type,
607: x_return_status OUT NOCOPY VARCHAR2) IS
608: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
609: BEGIN
610:
611: IF (p_cflv_rec.stub_amount <> OKL_API.G_MISS_NUM AND p_cflv_rec.stub_amount IS NOT NULL) THEN
612: IF p_cflv_rec.stub_amount = 0 THEN

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

634: ---------------------------------------
635: PROCEDURE validate_fqy_code(
636: p_cflv_rec IN cflv_rec_type,
637: x_return_status OUT NOCOPY VARCHAR2) IS
638: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
639:
640: l_dummy_var VARCHAR2(1) := '?' ;
641:
642: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 662: OKC_API.set_message(g_app_name,

658: FETCH okl_cflv_fqy_fk_csr into l_dummy_var ;
659: CLOSE okl_cflv_fqy_fk_csr ;
660: -- still set to default means data was not found
661: IF ( l_dummy_var = '?' ) THEN
662: OKC_API.set_message(g_app_name,
663: g_no_parent_record,
664: g_col_name_token,
665: 'fqy_code',
666: g_child_table_token ,

Line 670: l_return_status := OKC_API.G_RET_STS_ERROR;

666: g_child_table_token ,
667: 'OKL_CASH_FLOW_LEVELS_V',
668: g_parent_table_token ,
669: 'FND_LOOKUP_VALUES');
670: l_return_status := OKC_API.G_RET_STS_ERROR;
671:
672: END IF;
673: END IF;
674: x_return_status := l_return_status;

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

689: -----------------------------------------
690: PROCEDURE validate_start_date(
691: p_cflv_rec IN cflv_rec_type,
692: x_return_status OUT NOCOPY VARCHAR2) IS
693: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
694: BEGIN
695:
696: IF (p_cflv_rec.start_date = OKL_API.G_MISS_DATE OR p_cflv_rec.start_date IS NULL)
697: THEN

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

720: ---------------------------------------------
721: PROCEDURE validate_level_sequence(
722: p_cflv_rec IN cflv_rec_type,
723: x_return_status OUT NOCOPY VARCHAR2) IS
724: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
725: BEGIN
726:
727: IF (p_cflv_rec.level_sequence = OKL_API.G_MISS_NUM OR p_cflv_rec.level_sequence IS NULL)
728: THEN

Line 765: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

761: -- ***
762: -- id
763: -- ***
764: validate_id(p_cflv_rec, l_return_status);
765: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
767: x_return_status := l_return_status;
768: RAISE G_EXCEPTION_HALT_VALIDATION;
769: ELSE

Line 766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

762: -- id
763: -- ***
764: validate_id(p_cflv_rec, l_return_status);
765: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
767: x_return_status := l_return_status;
768: RAISE G_EXCEPTION_HALT_VALIDATION;
769: ELSE
770: x_return_status := l_return_status;

Line 778: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

774: -- ***
775: -- caf_id
776: -- ***
777: validate_caf_id(p_cflv_rec, l_return_status);
778: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
779: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
780: x_return_status := l_return_status;
781: RAISE G_EXCEPTION_HALT_VALIDATION;
782: ELSE

Line 779: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

775: -- caf_id
776: -- ***
777: validate_caf_id(p_cflv_rec, l_return_status);
778: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
779: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
780: x_return_status := l_return_status;
781: RAISE G_EXCEPTION_HALT_VALIDATION;
782: ELSE
783: x_return_status := l_return_status;

Line 791: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

787: -- ***
788: -- amount
789: -- ***
790: validate_amount(p_cflv_rec, l_return_status);
791: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
793: x_return_status := l_return_status;
794: RAISE G_EXCEPTION_HALT_VALIDATION;
795: ELSE

Line 792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

788: -- amount
789: -- ***
790: validate_amount(p_cflv_rec, l_return_status);
791: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
793: x_return_status := l_return_status;
794: RAISE G_EXCEPTION_HALT_VALIDATION;
795: ELSE
796: x_return_status := l_return_status;

Line 804: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

800: -- ***
801: -- number_of_periods
802: -- ***
803: validate_number_of_periods(p_cflv_rec, l_return_status);
804: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
806: x_return_status := l_return_status;
807: RAISE G_EXCEPTION_HALT_VALIDATION;
808: ELSE

Line 805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

801: -- number_of_periods
802: -- ***
803: validate_number_of_periods(p_cflv_rec, l_return_status);
804: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
805: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
806: x_return_status := l_return_status;
807: RAISE G_EXCEPTION_HALT_VALIDATION;
808: ELSE
809: x_return_status := l_return_status;

Line 817: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

813: -- ***
814: -- stub_days
815: -- ***
816: validate_stub_days(p_cflv_rec, l_return_status);
817: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
818: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
819: x_return_status := l_return_status;
820: RAISE G_EXCEPTION_HALT_VALIDATION;
821: ELSE

Line 818: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

814: -- stub_days
815: -- ***
816: validate_stub_days(p_cflv_rec, l_return_status);
817: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
818: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
819: x_return_status := l_return_status;
820: RAISE G_EXCEPTION_HALT_VALIDATION;
821: ELSE
822: x_return_status := l_return_status;

Line 833: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

829: -- Guru fix for bug 4299023 start - removing the following validation
830: /*
831:
832: validate_stub_amount(p_cflv_rec, l_return_status);
833: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
834: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
835: x_return_status := l_return_status;
836: RAISE G_EXCEPTION_HALT_VALIDATION;
837: ELSE

Line 834: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

830: /*
831:
832: validate_stub_amount(p_cflv_rec, l_return_status);
833: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
834: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
835: x_return_status := l_return_status;
836: RAISE G_EXCEPTION_HALT_VALIDATION;
837: ELSE
838: x_return_status := l_return_status;

Line 849: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

845: -- ***
846: -- fqy_code
847: -- ***
848: validate_fqy_code(p_cflv_rec, l_return_status);
849: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
850: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
851: x_return_status := l_return_status;
852: RAISE G_EXCEPTION_HALT_VALIDATION;
853: ELSE

Line 850: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

846: -- fqy_code
847: -- ***
848: validate_fqy_code(p_cflv_rec, l_return_status);
849: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
850: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
851: x_return_status := l_return_status;
852: RAISE G_EXCEPTION_HALT_VALIDATION;
853: ELSE
854: x_return_status := l_return_status;

Line 862: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

858: -- ***
859: -- level_sequence
860: -- ***
861: /* validate_level_sequence(p_cflv_rec, l_return_status);
862: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
863: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
864: x_return_status := l_return_status;
865: RAISE G_EXCEPTION_HALT_VALIDATION;
866: ELSE

Line 863: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

859: -- level_sequence
860: -- ***
861: /* validate_level_sequence(p_cflv_rec, l_return_status);
862: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
863: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
864: x_return_status := l_return_status;
865: RAISE G_EXCEPTION_HALT_VALIDATION;
866: ELSE
867: x_return_status := l_return_status;

Line 876: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

872: -- ***
873: -- start_date
874: -- ***
875: validate_start_date(p_cflv_rec, l_return_status);
876: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
877: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
878: x_return_status := l_return_status;
879: RAISE G_EXCEPTION_HALT_VALIDATION;
880: ELSE

Line 877: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

873: -- start_date
874: -- ***
875: validate_start_date(p_cflv_rec, l_return_status);
876: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
877: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
878: x_return_status := l_return_status;
879: RAISE G_EXCEPTION_HALT_VALIDATION;
880: ELSE
881: x_return_status := l_return_status;

Line 996: x_return_status := OKC_API.G_RET_STS_ERROR;

992: (p_cflv_rec.number_of_periods = OKL_API.G_MISS_NUM OR p_cflv_rec.number_of_periods IS NULL) AND
993: (p_cflv_rec.amount = OKL_API.G_MISS_NUM OR p_cflv_rec.amount IS NULL)
994: ) THEN
995:
996: x_return_status := OKC_API.G_RET_STS_ERROR;
997: --Cashflow level details are incomplete. Payment should consists of periodic amounts or stubs.
998: OKL_API.set_message(p_app_name => 'OKL',
999: p_msg_name => 'OKL_AM_NO_PYMT_INFO');
1000:

Line 1010: x_return_status := OKC_API.G_RET_STS_ERROR;

1006: (p_cflv_rec.number_of_periods <> OKL_API.G_MISS_NUM AND p_cflv_rec.number_of_periods IS NOT NULL) AND
1007: (p_cflv_rec.amount <> OKL_API.G_MISS_NUM AND p_cflv_rec.amount IS NOT NULL)
1008: ) THEN
1009:
1010: x_return_status := OKC_API.G_RET_STS_ERROR;
1011: --A payment can not have both the stub and periodic payment attributes.
1012: OKL_API.set_message(p_app_name => 'OKL',
1013: p_msg_name => 'OKL_AM_STUB_OR_PERIODIC');
1014:

Line 1028: x_return_status := OKC_API.G_RET_STS_ERROR;

1024: (p_cflv_rec.stub_days = OKL_API.G_MISS_NUM OR p_cflv_rec.stub_days IS NULL) AND
1025: (p_cflv_rec.stub_amount <> OKL_API.G_MISS_NUM AND p_cflv_rec.stub_amount IS NOT NULL)
1026: ) THEN
1027:
1028: x_return_status := OKC_API.G_RET_STS_ERROR;
1029: OKL_API.set_message(p_app_name => 'OKL',
1030: p_msg_name => 'OKL_AM_MISSING_STUB_INFO');
1031:
1032: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1046: x_return_status := OKC_API.G_RET_STS_ERROR;

1042: (p_cflv_rec.number_of_periods = OKL_API.G_MISS_NUM OR p_cflv_rec.number_of_periods IS NULL) AND
1043: (p_cflv_rec.amount <> OKL_API.G_MISS_NUM AND p_cflv_rec.amount IS NOT NULL)
1044: ) THEN
1045:
1046: x_return_status := OKC_API.G_RET_STS_ERROR;
1047: OKL_API.set_message(p_app_name => 'OKL',
1048: p_msg_name => 'OKL_AM_MISSING_PERIOD_INFO');
1049:
1050: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1069: x_return_status := OKC_API.G_RET_STS_ERROR;

1065: )
1066:
1067: THEN
1068:
1069: x_return_status := OKC_API.G_RET_STS_ERROR;
1070: OKL_API.set_message(p_app_name => 'OKL',
1071: p_msg_name => 'OKL_AM_STUB_OR_PERIODIC');
1072:
1073: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1091: x_return_status := OKC_API.G_RET_STS_ERROR;

1087: )
1088:
1089: THEN
1090:
1091: x_return_status := OKC_API.G_RET_STS_ERROR;
1092: OKL_API.set_message(p_app_name => 'OKL',
1093: p_msg_name => 'OKL_AM_STUB_OR_PERIODIC');
1094:
1095: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 2560: IF (x_cfl_rec.stub_days = OKC_API.G_MISS_NUM)

2556: IF (x_cfl_rec.level_sequence = OKL_API.G_MISS_NUM)
2557: THEN
2558: x_cfl_rec.level_sequence := l_cfl_rec.level_sequence;
2559: END IF;
2560: IF (x_cfl_rec.stub_days = OKC_API.G_MISS_NUM)
2561: THEN
2562: x_cfl_rec.stub_days := l_cfl_rec.stub_days;
2563: END IF;
2564: IF (x_cfl_rec.stub_amount = OKC_API.G_MISS_NUM)

Line 2564: IF (x_cfl_rec.stub_amount = OKC_API.G_MISS_NUM)

2560: IF (x_cfl_rec.stub_days = OKC_API.G_MISS_NUM)
2561: THEN
2562: x_cfl_rec.stub_days := l_cfl_rec.stub_days;
2563: END IF;
2564: IF (x_cfl_rec.stub_amount = OKC_API.G_MISS_NUM)
2565: THEN
2566: x_cfl_rec.stub_amount := l_cfl_rec.stub_amount;
2567: END IF;
2568:

Line 2569: IF (x_cfl_rec.start_date = OKC_API.G_MISS_DATE)

2565: THEN
2566: x_cfl_rec.stub_amount := l_cfl_rec.stub_amount;
2567: END IF;
2568:
2569: IF (x_cfl_rec.start_date = OKC_API.G_MISS_DATE)
2570: THEN
2571: x_cfl_rec.start_date := l_cfl_rec.start_date;
2572: END IF;
2573:

Line 2574: IF (x_cfl_rec.rate = OKC_API.G_MISS_NUM)

2570: THEN
2571: x_cfl_rec.start_date := l_cfl_rec.start_date;
2572: END IF;
2573:
2574: IF (x_cfl_rec.rate = OKC_API.G_MISS_NUM)
2575: THEN
2576: x_cfl_rec.rate := l_cfl_rec.rate;
2577: END IF;
2578:

Line 2856: IF (x_cflv_rec.stub_days = OKC_API.G_MISS_NUM)

2852: IF (x_cflv_rec.level_sequence = OKL_API.G_MISS_NUM)
2853: THEN
2854: x_cflv_rec.level_sequence := l_db_cflv_rec.level_sequence;
2855: END IF;
2856: IF (x_cflv_rec.stub_days = OKC_API.G_MISS_NUM)
2857: THEN
2858: x_cflv_rec.stub_days := l_db_cflv_rec.stub_days;
2859: END IF;
2860: IF (x_cflv_rec.stub_amount = OKC_API.G_MISS_NUM)

Line 2860: IF (x_cflv_rec.stub_amount = OKC_API.G_MISS_NUM)

2856: IF (x_cflv_rec.stub_days = OKC_API.G_MISS_NUM)
2857: THEN
2858: x_cflv_rec.stub_days := l_db_cflv_rec.stub_days;
2859: END IF;
2860: IF (x_cflv_rec.stub_amount = OKC_API.G_MISS_NUM)
2861: THEN
2862: x_cflv_rec.stub_amount := l_db_cflv_rec.stub_amount;
2863: END IF;
2864:

Line 2865: IF (x_cflv_rec.start_date = OKC_API.G_MISS_DATE)

2861: THEN
2862: x_cflv_rec.stub_amount := l_db_cflv_rec.stub_amount;
2863: END IF;
2864:
2865: IF (x_cflv_rec.start_date = OKC_API.G_MISS_DATE)
2866: THEN
2867: x_cflv_rec.start_date := l_db_cflv_rec.start_date;
2868: END IF;
2869:

Line 2870: IF (x_cflv_rec.rate = OKC_API.G_MISS_NUM)

2866: THEN
2867: x_cflv_rec.start_date := l_db_cflv_rec.start_date;
2868: END IF;
2869:
2870: IF (x_cflv_rec.rate = OKC_API.G_MISS_NUM)
2871: THEN
2872: x_cflv_rec.rate := l_db_cflv_rec.rate;
2873: END IF;
2874: IF (x_cflv_rec.attribute_category = OKL_API.G_MISS_CHAR)