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_RELEASE_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 57: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.CLEV_REC_TYPE;

53: TYPE g_top_line_tbl IS TABLE OF OKC_K_LINES_V.ID%TYPE
54: INDEX BY BINARY_INTEGER;
55: TYPE g_asset_num_tbl IS TABLE OF OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE
56: INDEX BY BINARY_INTEGER;
57: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.CLEV_REC_TYPE;
58: subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
59: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
60: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
61: -------------------------------------------------------------------------------------------------

Line 59: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;

55: TYPE g_asset_num_tbl IS TABLE OF OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE
56: INDEX BY BINARY_INTEGER;
57: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.CLEV_REC_TYPE;
58: subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
59: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
60: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
61: -------------------------------------------------------------------------------------------------
62: ------------------------------------------------------------------------------
63: --Start of comments

Line 275: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

271: AND okcsts.code = line.sts_code
272: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED');
273:
274: lp_klev_rec okl_kle_pvt.klev_rec_type;
275: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
276: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
277: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
278: lx_klev_rec okl_kle_pvt.klev_rec_type;
279: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 276: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

272: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED');
273:
274: lp_klev_rec okl_kle_pvt.klev_rec_type;
275: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
276: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
277: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
278: lx_klev_rec okl_kle_pvt.klev_rec_type;
279: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
280:

Line 279: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

275: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
276: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
277: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
278: lx_klev_rec okl_kle_pvt.klev_rec_type;
279: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
280:
281: begin
282:
283: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 903: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

899: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
900: l_cle_id OKC_K_LINES_B.ID%TYPE;
901: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
902: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
903: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
904: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
905: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
906:
907: --Cursor to check if lease chr has lines to change effectivity

Line 904: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

900: l_cle_id OKC_K_LINES_B.ID%TYPE;
901: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
902: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
903: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
904: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
905: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
906:
907: --Cursor to check if lease chr has lines to change effectivity
908:

Line 962: okl_okc_migration_pvt.update_contract_line(

958:
959: l_clev_rec.id := l_cle_id;
960: l_clev_rec.start_date := p_khrv_rec.date_deal_transferred;
961:
962: okl_okc_migration_pvt.update_contract_line(
963: p_api_version => p_api_version,
964: p_init_msg_list => p_init_msg_list,
965: x_return_status => x_return_status,
966: x_msg_count => x_msg_count,

Line 984: OKL_OKC_MIGRATION_PVT.update_contract_header(

980: */
981: -- Bug 5769216 - End
982: --Bug# 9927005: End
983:
984: OKL_OKC_MIGRATION_PVT.update_contract_header(
985: p_api_version => p_api_version,
986: p_init_msg_list => p_init_msg_list,
987: x_return_status => x_return_status,
988: x_msg_count => x_msg_count,

Line 1101: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

1097: and rgp.chr_id = p_chr_id
1098: and rul.dnz_chr_id = p_chr_id;
1099:
1100: larles_rec larles_csr%ROWTYPE;
1101: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1102: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1103: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1104: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1105:

Line 1102: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

1098: and rul.dnz_chr_id = p_chr_id;
1099:
1100: larles_rec larles_csr%ROWTYPE;
1101: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1102: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1103: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1104: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1105:
1106: BEGIN

Line 2526: l_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;

2522: l_capitalized_interest NUMBER;
2523:
2524: l_model_clev_rec okc_contract_pub.clev_rec_type;
2525: lx_model_clev_rec okc_contract_pub.clev_rec_type;
2526: l_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2527: lx_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2528: l_finast_klev_rec okl_contract_pub.klev_rec_type;
2529: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2530: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;

Line 2527: lx_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;

2523:
2524: l_model_clev_rec okc_contract_pub.clev_rec_type;
2525: lx_model_clev_rec okc_contract_pub.clev_rec_type;
2526: l_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2527: lx_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2528: l_finast_klev_rec okl_contract_pub.klev_rec_type;
2529: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2530: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2531: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;

Line 2530: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;

2526: l_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2527: lx_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2528: l_finast_klev_rec okl_contract_pub.klev_rec_type;
2529: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2530: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2531: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2532: l_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2533: lx_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2534:

Line 2531: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;

2527: lx_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2528: l_finast_klev_rec okl_contract_pub.klev_rec_type;
2529: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2530: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2531: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2532: l_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2533: lx_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2534:
2535: --cursor to fetch new contract currency

Line 4267: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

4263: l_new_fee_amount NUMBER;
4264: l_new_idc_amount NUMBER;
4265:
4266: lp_klev_rec okl_kle_pvt.klev_rec_type;
4267: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4268:
4269: lx_klev_rec okl_kle_pvt.klev_rec_type;
4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4271:

Line 4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

4266: lp_klev_rec okl_kle_pvt.klev_rec_type;
4267: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4268:
4269: lx_klev_rec okl_kle_pvt.klev_rec_type;
4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4271:
4272: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4272: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4268:
4269: lx_klev_rec okl_kle_pvt.klev_rec_type;
4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4271:
4272: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4275:
4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

Line 4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

4269: lx_klev_rec okl_kle_pvt.klev_rec_type;
4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4271:
4272: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4275:
4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

Line 4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4271:
4272: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4275:
4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4278: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;

Line 4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4278: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4279:
4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4282:
4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

Line 4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4278: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4279:
4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4282:
4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;

Line 4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;

4279:
4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4282:
4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4286: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4287: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;

Line 4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4282:
4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4286: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4287: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4288: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;

Line 4287: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;

4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4286: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4287: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4288: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
4289:
4290: l_subline_present VARCHAR2(1);
4291: l_sub_cap_amt NUMBER;

Line 5370: OKL_OKC_MIGRATION_PVT.update_contract_item

5366: if (fee_item_rec.id IS NOT NULL) then
5367: lp_cimv_rec.id := fee_item_rec.id;
5368: lp_cimv_rec.object1_id1 := pymt_details_rec.object1_id1;
5369:
5370: OKL_OKC_MIGRATION_PVT.update_contract_item
5371: (p_api_version => p_api_version,
5372: p_init_msg_list => p_init_msg_list,
5373: x_return_status => x_return_status,
5374: x_msg_count => x_msg_count,

Line 5762: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

5758: l_new_service_amount NUMBER;
5759: l_per_period_amount NUMBER;
5760:
5761: lp_klev_rec okl_kle_pvt.klev_rec_type;
5762: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5763:
5764: lx_klev_rec okl_kle_pvt.klev_rec_type;
5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5766:

Line 5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

5761: lp_klev_rec okl_kle_pvt.klev_rec_type;
5762: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5763:
5764: lx_klev_rec okl_kle_pvt.klev_rec_type;
5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5766:
5767: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 5767: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

5763:
5764: lx_klev_rec okl_kle_pvt.klev_rec_type;
5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5766:
5767: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5770:
5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

Line 5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

5764: lx_klev_rec okl_kle_pvt.klev_rec_type;
5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5766:
5767: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5770:
5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

Line 5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5766:
5767: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5770:
5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;

Line 5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;

5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5774:
5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5778: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5779: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;

Line 5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5774:
5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5778: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5779: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5780: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;

Line 6996: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

6992: lx_talv_rec okl_txl_assets_pub.tlpv_rec_type;
6993: l_txdv_rec okl_txd_assets_pub.adpv_rec_type;
6994: lx_txdv_rec okl_txd_assets_pub.adpv_rec_type;
6995:
6996: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6997: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6998:
6999: lp_klev_rec okl_kle_pvt.klev_rec_type;
7000: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6997: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

6993: l_txdv_rec okl_txd_assets_pub.adpv_rec_type;
6994: lx_txdv_rec okl_txd_assets_pub.adpv_rec_type;
6995:
6996: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6997: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6998:
6999: lp_klev_rec okl_kle_pvt.klev_rec_type;
7000: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7001:

Line 7000: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

6996: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6997: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6998:
6999: lp_klev_rec okl_kle_pvt.klev_rec_type;
7000: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7001:
7002: lx_klev_rec okl_kle_pvt.klev_rec_type;
7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7004:

Line 7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

6999: lp_klev_rec okl_kle_pvt.klev_rec_type;
7000: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7001:
7002: lx_klev_rec okl_kle_pvt.klev_rec_type;
7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7004:
7005: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
7006: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
7007: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

Line 7005: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;

7001:
7002: lx_klev_rec okl_kle_pvt.klev_rec_type;
7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7004:
7005: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
7006: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
7007: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
7008:
7009: --Bug# 3950089

Line 7007: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7004:
7005: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
7006: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
7007: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
7008:
7009: --Bug# 3950089
7010: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
7011: SELECT currency_code

Line 7355: OKL_OKC_MIGRATION_PVT.update_contract_item

7351: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7353: END IF;
7354:
7355: OKL_OKC_MIGRATION_PVT.update_contract_item
7356: (p_api_version => p_api_version,
7357: p_init_msg_list => p_init_msg_list,
7358: x_return_status => x_return_status,
7359: x_msg_count => x_msg_count,

Line 7513: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

7509: WHERE chr_id = p_chr_id
7510: AND rle_code = 'LESSEE';
7511:
7512: party_role_rec party_role_csr%ROWTYPE;
7513: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7514: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7515:
7516: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7517: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 7514: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

7510: AND rle_code = 'LESSEE';
7511:
7512: party_role_rec party_role_csr%ROWTYPE;
7513: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7514: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7515:
7516: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7517: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7518:

Line 7516: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

7512: party_role_rec party_role_csr%ROWTYPE;
7513: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7514: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7515:
7516: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7517: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7518:
7519: CURSOR hdr_rules_csr(p_chr_id IN NUMBER,
7520: p_rgd_code IN VARCHAR2,

Line 7517: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

7513: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7514: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
7515:
7516: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7517: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7518:
7519: CURSOR hdr_rules_csr(p_chr_id IN NUMBER,
7520: p_rgd_code IN VARCHAR2,
7521: p_rul_cat IN VARCHAR2) IS

Line 7559: lp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

7555: WHERE chr.id = gve.chr_id_referred
7556: AND chr.scs_code = p_scs_code);
7557:
7558: governance_rec governance_csr%ROWTYPE;
7559: lp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7560: lx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7561: lp_gvev_temp_rec okl_okc_migration_pvt.gvev_rec_type;
7562:
7563: CURSOR taa_lines_csr(p_chr_id IN NUMBER,

Line 7560: lx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;

7556: AND chr.scs_code = p_scs_code);
7557:
7558: governance_rec governance_csr%ROWTYPE;
7559: lp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7560: lx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7561: lp_gvev_temp_rec okl_okc_migration_pvt.gvev_rec_type;
7562:
7563: CURSOR taa_lines_csr(p_chr_id IN NUMBER,
7564: p_taa_trx_id IN NUMBER) IS

Line 7561: lp_gvev_temp_rec okl_okc_migration_pvt.gvev_rec_type;

7557:
7558: governance_rec governance_csr%ROWTYPE;
7559: lp_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7560: lx_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
7561: lp_gvev_temp_rec okl_okc_migration_pvt.gvev_rec_type;
7562:
7563: CURSOR taa_lines_csr(p_chr_id IN NUMBER,
7564: p_taa_trx_id IN NUMBER) IS
7565: SELECT cle.id,

Line 7584: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

7580: AND tcl.kle_id = cle.orig_system_id1
7581: AND tcl.before_transfer_yn = 'N';
7582:
7583: lp_klev_rec okl_kle_pvt.klev_rec_type;
7584: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7585:
7586: lx_klev_rec okl_kle_pvt.klev_rec_type;
7587: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7588:

Line 7587: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

7583: lp_klev_rec okl_kle_pvt.klev_rec_type;
7584: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7585:
7586: lx_klev_rec okl_kle_pvt.klev_rec_type;
7587: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7588:
7589: CURSOR txl_asset_csr(p_chr_id IN NUMBER,
7590: p_cle_id IN NUMBER) IS
7591: SELECT txlb.id

Line 7694: OKL_OKC_MIGRATION_PVT.update_k_party_role

7690: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7691: -- to update records in tables
7692: -- okc_k_party_roles_b and okl_k_party_roles
7693: /*
7694: OKL_OKC_MIGRATION_PVT.update_k_party_role
7695: (p_api_version => p_api_version,
7696: p_init_msg_list => p_init_msg_list,
7697: x_return_status => x_return_status,
7698: x_msg_count => x_msg_count,

Line 7734: OKL_OKC_MIGRATION_PVT.update_contract_header(

7730: IF (taa_chr_hdr_dtl_rec.bill_to_site_id IS NOT NULL) THEN
7731: l_chrv_rec.bill_to_site_use_id := taa_chr_hdr_dtl_rec.bill_to_site_id;
7732: END IF;
7733:
7734: OKL_OKC_MIGRATION_PVT.update_contract_header(
7735: p_api_version => p_api_version,
7736: p_init_msg_list => p_init_msg_list,
7737: x_return_status => x_return_status,
7738: x_msg_count => x_msg_count,

Line 7897: OKL_OKC_MIGRATION_PVT.create_governance

7893:
7894: IF (governance_rec.id IS NULL) THEN
7895: lp_gvev_rec.id := NULL;
7896:
7897: OKL_OKC_MIGRATION_PVT.create_governance
7898: (p_api_version => p_api_version,
7899: p_init_msg_list => p_init_msg_list,
7900: x_return_status => x_return_status,
7901: x_msg_count => x_msg_count,

Line 7916: OKL_OKC_MIGRATION_PVT.update_governance

7912: ELSE
7913:
7914: lp_gvev_rec.id := governance_rec.id;
7915:
7916: OKL_OKC_MIGRATION_PVT.update_governance
7917: (p_api_version => p_api_version,
7918: p_init_msg_list => p_init_msg_list,
7919: x_return_status => x_return_status,
7920: x_msg_count => x_msg_count,

Line 7952: OKL_OKC_MIGRATION_PVT.create_governance

7948:
7949: IF (governance_rec.id IS NULL) THEN
7950: lp_gvev_rec.id := NULL;
7951:
7952: OKL_OKC_MIGRATION_PVT.create_governance
7953: (p_api_version => p_api_version,
7954: p_init_msg_list => p_init_msg_list,
7955: x_return_status => x_return_status,
7956: x_msg_count => x_msg_count,

Line 7971: OKL_OKC_MIGRATION_PVT.update_governance

7967: ELSE
7968:
7969: lp_gvev_rec.id := governance_rec.id;
7970:
7971: OKL_OKC_MIGRATION_PVT.update_governance
7972: (p_api_version => p_api_version,
7973: p_init_msg_list => p_init_msg_list,
7974: x_return_status => x_return_status,
7975: x_msg_count => x_msg_count,

Line 8280: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

8276: and cleb.dnz_chr_id = p_chr_id
8277: and cleb.lse_id = 33; --financial asset line id
8278:
8279: l_finast_rec l_finast_csr%ROWTYPE;
8280: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
8281: l_fin_klev_rec okl_contract_pub.klev_rec_type;
8282: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
8283: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
8284: --End Bug# 4631549

Line 8282: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

8278:
8279: l_finast_rec l_finast_csr%ROWTYPE;
8280: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
8281: l_fin_klev_rec okl_contract_pub.klev_rec_type;
8282: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
8283: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
8284: --End Bug# 4631549
8285:
8286: BEGIN

Line 8912: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,

8908: x_return_status := OKL_API.G_RET_STS_ERROR;
8909: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8910: END IF;
8911: CLOSE get_item_info;
8912: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
8913: p_init_msg_list => p_init_msg_list,
8914: x_return_status => x_return_status,
8915: x_msg_count => x_msg_count,
8916: x_msg_data => x_msg_data,

Line 8964: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,

8960: x_return_status := OKL_API.G_RET_STS_ERROR;
8961: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8962: END IF;
8963: CLOSE get_item_info;
8964: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
8965: p_init_msg_list => p_init_msg_list,
8966: x_return_status => x_return_status,
8967: x_msg_count => x_msg_count,
8968: x_msg_data => x_msg_data,