290: TAX_CLASSIFICATION_CODE,
291: EXEMPT_CERTIFICATE_NUMBER,
292: EXEMPT_REASON_CODE,
293: COVERAGE_ID,
294: STANDARD_COV_YN,
295: ORIG_SYSTEM_ID1,
296: ORIG_SYSTEM_REFERENCE1,
297: ORIG_SYSTEM_SOURCE_CODE
298: -- R12 Data Model Changes 4485150 End
405: l_klnv_rec.tax_classification_code,
406: l_klnv_rec.exempt_certificate_number,
407: l_klnv_rec.exempt_reason_code,
408: l_klnv_rec.coverage_id,
409: l_klnv_rec.standard_cov_yn,
410: l_klnv_rec.orig_system_id1,
411: l_klnv_rec.orig_system_reference1,
412: l_klnv_rec.orig_system_source_code
413: -- R12 Data Model Changes 4485150 End
548: TAX_CLASSIFICATION_CODE,
549: EXEMPT_CERTIFICATE_NUMBER,
550: EXEMPT_REASON_CODE,
551: COVERAGE_ID,
552: STANDARD_COV_YN,
553: ORIG_SYSTEM_ID1,
554: ORIG_SYSTEM_REFERENCE1,
555: ORIG_SYSTEM_SOURCE_CODE
556: -- R12 Data Model Changes 4485150 End
657: l_kln_rec.tax_classification_code,
658: l_kln_rec.exempt_certificate_number,
659: l_kln_rec.exempt_reason_code,
660: l_kln_rec.coverage_id,
661: l_kln_rec.standard_cov_yn,
662: l_kln_rec.orig_system_id1,
663: l_kln_rec.orig_system_reference1,
664: l_kln_rec.orig_system_source_code
665: -- R12 Data Model Changes 4485150 End
1088:
1089: IF (l_klnv_rec.coverage_id = OKC_API.G_MISS_NUM ) THEN
1090: l_klnv_rec.coverage_id := NULL;
1091: END IF;
1092: IF (l_klnv_rec.standard_cov_yn = OKC_API.G_MISS_CHAR ) THEN
1093: l_klnv_rec.standard_cov_yn := NULL;
1094: END IF;
1095: IF (l_klnv_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
1096: l_klnv_rec.orig_system_id1 := NULL;
1089: IF (l_klnv_rec.coverage_id = OKC_API.G_MISS_NUM ) THEN
1090: l_klnv_rec.coverage_id := NULL;
1091: END IF;
1092: IF (l_klnv_rec.standard_cov_yn = OKC_API.G_MISS_CHAR ) THEN
1093: l_klnv_rec.standard_cov_yn := NULL;
1094: END IF;
1095: IF (l_klnv_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
1096: l_klnv_rec.orig_system_id1 := NULL;
1097: END IF;
1441: p_to.exempt_certificate_number := p_from.exempt_certificate_number;
1442: p_to.exempt_reason_code := p_from.exempt_reason_code;
1443:
1444: p_to.coverage_id := p_from.coverage_id;
1445: p_to.standard_cov_yn := p_from.standard_cov_yn;
1446: p_to.orig_system_id1 := p_from.orig_system_id1;
1447: p_to.orig_system_reference1 := p_from.orig_system_reference1;
1448: p_to.orig_system_source_code := p_from.orig_system_source_code;
1449: -- R12 Data Model Changes 4485150 End
1549: p_to.exempt_certificate_number := p_from.exempt_certificate_number;
1550: p_to.exempt_reason_code := p_from.exempt_reason_code;
1551:
1552: p_to.coverage_id := p_from.coverage_id;
1553: p_to.standard_cov_yn := p_from.standard_cov_yn;
1554: p_to.orig_system_id1 := p_from.orig_system_id1;
1555: p_to.orig_system_reference1 := p_from.orig_system_reference1;
1556: p_to.orig_system_source_code := p_from.orig_system_source_code;
1557: -- R12 Data Model Changes 4485150 End
1974: tax_classification_code,
1975: exempt_certificate_number,
1976: exempt_reason_code,
1977: coverage_id,
1978: standard_cov_yn,
1979: orig_system_id1,
1980: orig_system_reference1,
1981: orig_system_source_code
1982: -- R12 Data Model Changes 4485150 End
2076: l_kln_rec.tax_classification_code,
2077: l_kln_rec.exempt_certificate_number,
2078: l_kln_rec.exempt_reason_code,
2079: l_kln_rec.coverage_id,
2080: l_kln_rec.standard_cov_yn,
2081: l_kln_rec.orig_system_id1,
2082: l_kln_rec.orig_system_reference1,
2083: l_kln_rec.orig_system_source_code
2084: -- R12 Data Model Changes 4485150 End
3447: IF (x_kln_rec.coverage_id = OKC_API.G_MISS_NUM)
3448: THEN
3449: x_kln_rec.coverage_id := l_kln_rec.coverage_id;
3450: END IF;
3451: IF (x_kln_rec.standard_cov_yn = OKC_API.G_MISS_CHAR)
3452: THEN
3453: x_kln_rec.standard_cov_yn := l_kln_rec.standard_cov_yn;
3454: END IF;
3455: IF (x_kln_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
3449: x_kln_rec.coverage_id := l_kln_rec.coverage_id;
3450: END IF;
3451: IF (x_kln_rec.standard_cov_yn = OKC_API.G_MISS_CHAR)
3452: THEN
3453: x_kln_rec.standard_cov_yn := l_kln_rec.standard_cov_yn;
3454: END IF;
3455: IF (x_kln_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
3456: THEN
3457: x_kln_rec.orig_system_id1 := l_kln_rec.orig_system_id1;
3608: TAX_CLASSIFICATION_CODE = l_def_kln_rec.tax_classification_code,
3609: EXEMPT_CERTIFICATE_NUMBER = l_def_kln_rec.exempt_certificate_number,
3610: EXEMPT_REASON_CODE = l_def_kln_rec.exempt_reason_code,
3611: COVERAGE_ID = l_def_kln_rec.coverage_id,
3612: STANDARD_COV_YN = l_def_kln_rec.standard_cov_yn,
3613: ORIG_SYSTEM_ID1 = l_def_kln_rec.orig_system_id1,
3614: ORIG_SYSTEM_REFERENCE1 = l_def_kln_rec.orig_system_reference1,
3615: ORIG_SYSTEM_SOURCE_CODE = l_def_kln_rec.orig_system_source_code
3616: -- R12 Data Model Changes 4485150 End
4283: IF (x_klnv_rec.coverage_id = OKC_API.G_MISS_NUM)
4284: THEN
4285: x_klnv_rec.coverage_id := l_db_klnv_rec.coverage_id ;
4286: END IF;
4287: IF (x_klnv_rec.standard_cov_yn = OKC_API.G_MISS_CHAR)
4288: THEN
4289: x_klnv_rec.standard_cov_yn := l_db_klnv_rec.standard_cov_yn;
4290: END IF;
4291: IF (x_klnv_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
4285: x_klnv_rec.coverage_id := l_db_klnv_rec.coverage_id ;
4286: END IF;
4287: IF (x_klnv_rec.standard_cov_yn = OKC_API.G_MISS_CHAR)
4288: THEN
4289: x_klnv_rec.standard_cov_yn := l_db_klnv_rec.standard_cov_yn;
4290: END IF;
4291: IF (x_klnv_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
4292: THEN
4293: x_klnv_rec.orig_system_id1 := l_db_klnv_rec.orig_system_id1;