DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_K_HISTORY_PVT

Line 435: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

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

Line 436: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

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)

Line 564: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

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;

Line 565: x_hstv_rec OKC_K_HISTORY_PVT.hstv_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;
569: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 785: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

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;

Line 786: x_hstv_rec OKC_K_HISTORY_PVT.hstv_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;
790: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;