964: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
965: i NUMBER;
966: l_chr_id NUMBER;
967:
968: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
969: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
970: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
971:
972: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
965: i NUMBER;
966: l_chr_id NUMBER;
967:
968: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
969: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
970: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
971:
972: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
973: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
968: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
969: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
970: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
971:
972: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
973: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
974: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
975:
976: BEGIN
969: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
970: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
971:
972: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
973: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
974: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
975:
976: BEGIN
977:
1145: from okl_k_lines_full_v cle
1146: where cle.id = p_cle_id
1147: and cle.dnz_chr_id = p_chr_id;
1148:
1149: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1150: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1151: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1152: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1153:
1146: where cle.id = p_cle_id
1147: and cle.dnz_chr_id = p_chr_id;
1148:
1149: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1150: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1151: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1152: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1153:
1154: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1150: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1151: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1152: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1153:
1154: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1155: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1156: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1157:
1158: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1151: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1152: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1153:
1154: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1155: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1156: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1157:
1158: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1159:
1157:
1158: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1159:
1160: --Bug# 3877032
1161: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1162: l_fin_klev_rec okl_contract_pub.klev_rec_type;
1163: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1164: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
1165:
1159:
1160: --Bug# 3877032
1161: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1162: l_fin_klev_rec okl_contract_pub.klev_rec_type;
1163: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1164: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
1165:
1166: --cursor to find out the fee type from okl_k_lines
1167: cursor l_fee_type_csr (p_cle_id in number) is
1621: where lse.lse_parent_id = cle.lse_id
1622: and cle.id = p_cle_id
1623: and cle.dnz_chr_id = p_chr_id;
1624:
1625: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1626: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1627: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1628: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1629:
1622: and cle.id = p_cle_id
1623: and cle.dnz_chr_id = p_chr_id;
1624:
1625: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1626: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1627: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1628: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1629:
1630: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1626: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1627: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1628: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1629:
1630: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1631: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1632: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1633:
1634: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1627: lp_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1628: lp_srv_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1629:
1630: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1631: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1632: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1633:
1634: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1635:
1633:
1634: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1635:
1636: --Bug# 3877032
1637: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1638: l_fin_klev_rec okl_contract_pub.klev_rec_type;
1639: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1640: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
1641:
1635:
1636: --Bug# 3877032
1637: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1638: l_fin_klev_rec okl_contract_pub.klev_rec_type;
1639: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1640: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
1641:
1642: --cursor to find out the fee type from okl_k_lines
1643: cursor l_fee_type_csr (p_cle_id in number) is
1650: select object1_id1, dnz_chr_id
1651: from okc_k_items
1652: where id = p_cim_id;
1653:
1654: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
1655: l_fin_klev_tbl okl_contract_pub.klev_tbl_type;
1656: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
1657: lx_fin_klev_tbl okl_contract_pub.klev_tbl_type;
1658: j number;
1652: where id = p_cim_id;
1653:
1654: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
1655: l_fin_klev_tbl okl_contract_pub.klev_tbl_type;
1656: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
1657: lx_fin_klev_tbl okl_contract_pub.klev_tbl_type;
1658: j number;
1659: --Bug# 3877032
1660:
2310:
2311: --
2312: -- call procedure in complex API
2313: --
2314: okl_okc_migration_pvt.create_contract_item(
2315: p_api_version => p_api_version,
2316: p_init_msg_list => p_init_msg_list,
2317: x_return_status => x_return_status,
2318: x_msg_count => x_msg_count,
2687:
2688: --
2689: -- call procedure in complex API
2690: --
2691: okl_okc_migration_pvt.update_contract_item(
2692: p_api_version => p_api_version,
2693: p_init_msg_list => p_init_msg_list,
2694: x_return_status => x_return_status,
2695: x_msg_count => x_msg_count,
2959: and nvl(fee_kle.fee_type,'GENERAL') = 'CAPITALIZED';
2960:
2961: l_cap_fee_asst_rec l_cap_fee_asst_csr%ROWTYPE;
2962:
2963: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
2964: l_fin_klev_tbl okl_contract_pub.klev_tbl_type;
2965: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
2966: lx_fin_klev_tbl okl_contract_pub.klev_tbl_type;
2967: i number;
2961: l_cap_fee_asst_rec l_cap_fee_asst_csr%ROWTYPE;
2962:
2963: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
2964: l_fin_klev_tbl okl_contract_pub.klev_tbl_type;
2965: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
2966: lx_fin_klev_tbl okl_contract_pub.klev_tbl_type;
2967: i number;
2968: --Bug# 3877032
2969:
3056:
3057: --
3058: -- call procedure in complex API
3059: --
3060: okl_okc_migration_pvt.delete_contract_item(
3061: p_api_version => p_api_version,
3062: p_init_msg_list => p_init_msg_list,
3063: x_return_status => x_return_status,
3064: x_msg_count => x_msg_count,