[Home] [Help]
114: SELECT DNZ_CHR_ID
115: FROM OKC_K_LINES_B
116: WHERE ID = p_kle_id1;
117:
118: FUNCTION generate_instance_number_ib(x_instance_number_ib OUT NOCOPY OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE)
119: RETURN VARCHAR2 IS
120: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
121: -- cursor to get sequence number for asset number
122: Cursor c_instance_no_ib IS
3538: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3539: OKL_API.set_message(p_app_name => G_APP_NAME,
3540: p_msg_name => G_NO_MATCHING_RECORD,
3541: p_token1 => G_COL_NAME_TOKEN,
3542: p_token1_value => 'OKL_TXL_ITM_INSTS_V record');
3543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3544: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3545: OKL_API.set_message(p_app_name => G_APP_NAME,
3546: p_msg_name => G_NO_MATCHING_RECORD,
3544: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3545: OKL_API.set_message(p_app_name => G_APP_NAME,
3546: p_msg_name => G_NO_MATCHING_RECORD,
3547: p_token1 => G_COL_NAME_TOKEN,
3548: p_token1_value => 'OKL_TXL_ITM_INSTS_V record');
3549: RAISE OKL_API.G_EXCEPTION_ERROR;
3550: END IF;
3551: -- Since the above get rec itiv will get the old kle_id
3552: -- w.r.t p_from cle_id(top Line).
4140: IS
4141: SELECT 1
4142: FROM DUAL
4143: WHERE EXISTS (SELECT '1'
4144: FROM OKL_TXL_ITM_INSTS_V
4145: WHERE kle_id = p_ib_kle_id);
4146:
4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
5037: IF c_check_iti_rec%NOTFOUND THEN
5038: OKL_API.set_message(p_app_name => G_APP_NAME,
5039: p_msg_name => G_NO_MATCHING_RECORD,
5040: p_token1 => G_COL_NAME_TOKEN,
5041: p_token1_value => 'OKL_TXL_ITM_INSTS_V.KLE_ID');
5042: x_return_status := OKL_API.G_RET_STS_ERROR;
5043: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
5044: END IF;
5045: FETCH c_check_iti_rec INTO ln_iti_rec;