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:

Line 756: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;

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;

Line 757: x_hstv_rec OKC_K_HISTORY_PVT.hstv_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;
761: