[Home] [Help]
85: subtype talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
86: subtype talv_tbl_type is OKL_TXL_ASSETS_PUB.tlpv_tbl_type;
87: subtype txdv_tbl_type is OKL_TXD_ASSETS_PUB.adpv_tbl_type;
88: subtype txdv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;
89: subtype itiv_rec_type is OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
90: subtype itiv_tbl_type is OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
91: subtype sidv_rec_type is OKL_SUPP_INVOICE_DTLS_PUB.sidv_rec_type;
92: subtype sidv_tbl_type is OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
93: TYPE g_ib_id_rec IS RECORD (
86: subtype talv_tbl_type is OKL_TXL_ASSETS_PUB.tlpv_tbl_type;
87: subtype txdv_tbl_type is OKL_TXD_ASSETS_PUB.adpv_tbl_type;
88: subtype txdv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;
89: subtype itiv_rec_type is OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
90: subtype itiv_tbl_type is OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
91: subtype sidv_rec_type is OKL_SUPP_INVOICE_DTLS_PUB.sidv_rec_type;
92: subtype sidv_tbl_type is OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
93: TYPE g_ib_id_rec IS RECORD (
94: id NUMBER := OKL_API.G_MISS_NUM,
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
1647: CREATION_DATE,
1648: LAST_UPDATED_BY,
1649: LAST_UPDATE_DATE,
1650: LAST_UPDATE_LOGIN
1651: FROM OKL_TXL_ITM_INSTS iti
1652: WHERE iti.kle_id = p_kle_id;
1653: BEGIN
1654: -- Get current database values
1655: OPEN okl_itiv_pk_csr (p_kle_id);
2240: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2241: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2242: RAISE OKL_API.G_EXCEPTION_ERROR;
2243: END IF;
2244: OKL_TXL_ITM_INSTS_PUB.create_txl_itm_insts(
2245: p_api_version => p_api_version,
2246: p_init_msg_list => p_init_msg_list,
2247: x_return_status => x_return_status,
2248: x_msg_count => x_msg_count,
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;