DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKC_K_ITEMS_V

Line 709: -- FUNCTION get_rec for: OKC_K_ITEMS_V

705: END IF;
706: RETURN(x_return_status);
707: END get_rec_chrv;
708: ----------------------------------------------------------------------------
709: -- FUNCTION get_rec for: OKC_K_ITEMS_V
710: ---------------------------------------------------------------------------
711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)

Line 711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,

707: END get_rec_chrv;
708: ----------------------------------------------------------------------------
709: -- FUNCTION get_rec for: OKC_K_ITEMS_V
710: ---------------------------------------------------------------------------
711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

708: ----------------------------------------------------------------------------
709: -- FUNCTION get_rec for: OKC_K_ITEMS_V
710: ---------------------------------------------------------------------------
711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

Line 715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
717: SELECT CIM.ID,
718: CIM.OBJECT_VERSION_NUMBER,
719: CIM.CLE_ID,

Line 716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
717: SELECT CIM.ID,
718: CIM.OBJECT_VERSION_NUMBER,
719: CIM.CLE_ID,
720: CIM.CHR_ID,

Line 737: FROM okc_k_items_v cim

733: CIM.CREATION_DATE,
734: CIM.LAST_UPDATED_BY,
735: CIM.LAST_UPDATE_DATE,
736: CIM.LAST_UPDATE_LOGIN
737: FROM okc_k_items_v cim
738: WHERE cim.dnz_chr_id = p_dnz_chr_id
739: AND cim.cle_id = p_cle_id;
740: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
741: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 8891: p_token1_value => 'OKC_K_ITEMS_V record');

8887: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8888: OKL_API.set_message(p_app_name => G_APP_NAME,
8889: p_msg_name => G_NO_MATCHING_RECORD,
8890: p_token1 => G_COL_NAME_TOKEN,
8891: p_token1_value => 'OKC_K_ITEMS_V record');
8892: x_return_status := OKL_API.G_RET_STS_ERROR;
8893: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8895: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 8898: p_token1_value => 'OKC_K_ITEMS_V record');

8894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8895: OKL_API.set_message(p_app_name => G_APP_NAME,
8896: p_msg_name => G_NO_MATCHING_RECORD,
8897: p_token1 => G_COL_NAME_TOKEN,
8898: p_token1_value => 'OKC_K_ITEMS_V record');
8899: x_return_status := OKL_API.G_RET_STS_ERROR;
8900: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8901: END IF;
8902: -- To get the old information of the old asset

Line 8943: p_token1_value => 'OKC_K_ITEMS_V record');

8939: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8940: OKL_API.set_message(p_app_name => G_APP_NAME,
8941: p_msg_name => G_NO_MATCHING_RECORD,
8942: p_token1 => G_COL_NAME_TOKEN,
8943: p_token1_value => 'OKC_K_ITEMS_V record');
8944: x_return_status := OKL_API.G_RET_STS_ERROR;
8945: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8947: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 8950: p_token1_value => 'OKC_K_ITEMS_V record');

8946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8947: OKL_API.set_message(p_app_name => G_APP_NAME,
8948: p_msg_name => G_NO_MATCHING_RECORD,
8949: p_token1 => G_COL_NAME_TOKEN,
8950: p_token1_value => 'OKC_K_ITEMS_V record');
8951: x_return_status := OKL_API.G_RET_STS_ERROR;
8952: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8953: END IF;
8954: -- To get the old information of the old asset