DBA Data[Home] [Help]

APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 968: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

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;

Line 969: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_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;

Line 972: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_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

Line 973: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_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
977:

Line 1149: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

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:

Line 1150: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;

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;

Line 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;

Line 1155: lx_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;
1159:

Line 1161: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

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:

Line 1163: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_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:
1166: --cursor to find out the fee type from okl_k_lines
1167: cursor l_fee_type_csr (p_cle_id in number) is

Line 1625: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

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:

Line 1626: lp_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;

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;

Line 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;

Line 1631: lx_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;
1635:

Line 1637: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

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:

Line 1639: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_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:
1642: --cursor to find out the fee type from okl_k_lines
1643: cursor l_fee_type_csr (p_cle_id in number) is

Line 1654: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

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;

Line 1656: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

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:

Line 2314: okl_okc_migration_pvt.create_contract_item(

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,

Line 2691: okl_okc_migration_pvt.update_contract_item(

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,

Line 2963: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

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;

Line 2965: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

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:

Line 3060: okl_okc_migration_pvt.delete_contract_item(

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,