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: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
781: p_control_rec IN control_rec_type,
782: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
783:
784: l_currency_code VARCHAR2(5);
785: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
786: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
787: l_version VARCHAR2(255);
788: l_status VARCHAR2(30) := NULL;
789: l_new_status VARCHAR2(30) := NULL;
782: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
783:
784: l_currency_code VARCHAR2(5);
785: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
786: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
787: l_version VARCHAR2(255);
788: l_status VARCHAR2(30) := NULL;
789: l_new_status VARCHAR2(30) := NULL;
790: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;