eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKC_K_ITEMS_V

Line 200: -- FUNCTION get_rec for: OKC_K_ITEMS_V

196: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
197: RETURN(x_return_status);
198: END get_tasv_rec;
199: ----------------------------------------------------------------------------
200: -- FUNCTION get_rec for: OKC_K_ITEMS_V
201: ---------------------------------------------------------------------------
202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)

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

198: END get_tasv_rec;
199: ----------------------------------------------------------------------------
200: -- FUNCTION get_rec for: OKC_K_ITEMS_V
201: ---------------------------------------------------------------------------
202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

199: ----------------------------------------------------------------------------
200: -- FUNCTION get_rec for: OKC_K_ITEMS_V
201: ---------------------------------------------------------------------------
202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

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

202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
208: SELECT CIM.ID,
209: CIM.OBJECT_VERSION_NUMBER,
210: CIM.CLE_ID,

Line 207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
208: SELECT CIM.ID,
209: CIM.OBJECT_VERSION_NUMBER,
210: CIM.CLE_ID,
211: CIM.CHR_ID,

Line 228: FROM okc_k_items_v cim

224: CIM.CREATION_DATE,
225: CIM.LAST_UPDATED_BY,
226: CIM.LAST_UPDATE_DATE,
227: CIM.LAST_UPDATE_LOGIN
228: FROM okc_k_items_v cim
229: WHERE cim.dnz_chr_id = p_dnz_chr_id
230: AND cim.cle_id = p_cle_id;
231: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
232: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

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

3508: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3509: OKL_API.set_message(p_app_name => G_APP_NAME,
3510: p_msg_name => G_NO_MATCHING_RECORD,
3511: p_token1 => G_COL_NAME_TOKEN,
3512: p_token1_value => 'OKC_K_ITEMS_V record');
3513: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
3514: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3515: OKL_API.set_message(p_app_name => G_APP_NAME,
3516: p_msg_name => G_NO_MATCHING_RECORD,

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

3514: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3515: OKL_API.set_message(p_app_name => G_APP_NAME,
3516: p_msg_name => G_NO_MATCHING_RECORD,
3517: p_token1 => G_COL_NAME_TOKEN,
3518: p_token1_value => 'OKC_K_ITEMS_V record');
3519: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3520: END IF;
3521:
3522: -- To get the old information of the old asset

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

3603: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3604: OKL_API.set_message(p_app_name => G_APP_NAME,
3605: p_msg_name => G_NO_MATCHING_RECORD,
3606: p_token1 => G_COL_NAME_TOKEN,
3607: p_token1_value => 'OKC_K_ITEMS_V record');
3608: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
3609: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3610: OKL_API.set_message(p_app_name => G_APP_NAME,
3611: p_msg_name => G_NO_MATCHING_RECORD,

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

3609: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3610: OKL_API.set_message(p_app_name => G_APP_NAME,
3611: p_msg_name => G_NO_MATCHING_RECORD,
3612: p_token1 => G_COL_NAME_TOKEN,
3613: p_token1_value => 'OKC_K_ITEMS_V record');
3614: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3615: END IF;
3616: -- To get the old information of the old asset
3617: OPEN get_item_info(p_orig_chr_id => ln_orig_system_id1,