431: Select meaning
432: from okc_subclasses_v
433: where code=p_chrv_rec.scs_code;
434: l_scs_meaning VARCHAR2(30);
435: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
436: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
437: l_version VARCHAR2(255);
438:
439: CURSOR version_csr(p_chr_id NUMBER) IS
432: from okc_subclasses_v
433: where code=p_chrv_rec.scs_code;
434: l_scs_meaning VARCHAR2(30);
435: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
436: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
437: l_version VARCHAR2(255);
438:
439: CURSOR version_csr(p_chr_id NUMBER) IS
440: SELECT to_char (major_version)||'.'||to_char(minor_version)
560: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
561: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
562:
563: l_currency_code VARCHAR2(5);
564: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
565: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
566: l_version VARCHAR2(255);
567: l_status VARCHAR2(30) := NULL;
568: l_new_status VARCHAR2(30) := NULL;
561: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
562:
563: l_currency_code VARCHAR2(5);
564: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
565: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
566: l_version VARCHAR2(255);
567: l_status VARCHAR2(30) := NULL;
568: l_new_status VARCHAR2(30) := NULL;
569:
752: p_control_rec IN control_rec_type,
753: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
754:
755: l_currency_code VARCHAR2(5);
756: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
757: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
758: l_version VARCHAR2(255);
759: l_status VARCHAR2(30) := NULL;
760: l_new_status VARCHAR2(30) := NULL;
753: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
754:
755: l_currency_code VARCHAR2(5);
756: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
757: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
758: l_version VARCHAR2(255);
759: l_status VARCHAR2(30) := NULL;
760: l_new_status VARCHAR2(30) := NULL;
761: