DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 412: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

408: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_PTY_RLS';
409: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
410: l_debug_enabled VARCHAR2(10);
411: row_count NUMBER DEFAULT 0;
412: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
413: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
414: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
415: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
416:

Line 413: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

409: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
410: l_debug_enabled VARCHAR2(10);
411: row_count NUMBER DEFAULT 0;
412: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
413: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
414: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
415: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
416:
417: --Check for the existing party roles

Line 2019: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

2015: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2016: l_debug_enabled VARCHAR2(10);
2017: l_klev_rec okl_kle_pvt.klev_rec_type;
2018: lx_klev_rec okl_kle_pvt.klev_rec_type;
2019: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2020: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2021: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2022: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2023: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 2020: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

2016: l_debug_enabled VARCHAR2(10);
2017: l_klev_rec okl_kle_pvt.klev_rec_type;
2018: lx_klev_rec okl_kle_pvt.klev_rec_type;
2019: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2020: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2021: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2022: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2023: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2024: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 2021: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

2017: l_klev_rec okl_kle_pvt.klev_rec_type;
2018: lx_klev_rec okl_kle_pvt.klev_rec_type;
2019: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2020: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2021: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2022: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2023: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2024: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2025: l_quote_service_rec quote_service_rec_type;

Line 2022: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

2018: lx_klev_rec okl_kle_pvt.klev_rec_type;
2019: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2020: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2021: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2022: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2023: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2024: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2025: l_quote_service_rec quote_service_rec_type;
2026: line_number NUMBER := 0;

Line 2023: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

2019: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2020: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2021: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2022: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2023: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2024: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2025: l_quote_service_rec quote_service_rec_type;
2026: line_number NUMBER := 0;
2027: lx_chr_id NUMBER;

Line 2024: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

2020: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2021: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2022: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2023: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2024: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2025: l_quote_service_rec quote_service_rec_type;
2026: line_number NUMBER := 0;
2027: lx_chr_id NUMBER;
2028: lx_cle_id NUMBER;

Line 3443: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;

3439: l_pymnt_counter NUMBER := 0;
3440: l_ast_counter NUMBER:=0;
3441: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
3442: --asset rec
3443: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3444: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3445: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3446: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3447: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;

Line 3445: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;

3441: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
3442: --asset rec
3443: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3444: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3445: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3446: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3447: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3448: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3449: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;

Line 3446: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;

3442: --asset rec
3443: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3444: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3445: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3446: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3447: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3448: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3449: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3450: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;

Line 3447: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;

3443: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3444: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3445: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3446: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3447: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3448: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3449: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3450: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3451: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;

Line 3450: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;

3446: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3447: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3448: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3449: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3450: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3451: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3452: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3453: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3454: l_payment_levels_tbl payment_levels_tbl_type;

Line 3451: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;

3447: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3448: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3449: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3450: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3451: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3452: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3453: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3454: l_payment_levels_tbl payment_levels_tbl_type;
3455: l_qte_payment_levels_tbl payment_levels_tbl_type;

Line 3452: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;

3448: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3449: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3450: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3451: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3452: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3453: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3454: l_payment_levels_tbl payment_levels_tbl_type;
3455: l_qte_payment_levels_tbl payment_levels_tbl_type;
3456: l_pym_hdr_rec okl_la_payments_pvt.pym_hdr_rec_type;

Line 3453: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;

3449: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3450: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3451: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3452: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3453: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3454: l_payment_levels_tbl payment_levels_tbl_type;
3455: l_qte_payment_levels_tbl payment_levels_tbl_type;
3456: l_pym_hdr_rec okl_la_payments_pvt.pym_hdr_rec_type;
3457: l_pym_tbl okl_la_payments_pvt.pym_tbl_type;

Line 4387: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4383: l_party_desc VARCHAR2(2000);
4384: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
4385: -- Record/Table Type Declarations
4386: --party rec
4387: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4388: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4389: --party contacts rec
4390: lp_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4391: lx_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

Line 4388: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4384: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
4385: -- Record/Table Type Declarations
4386: --party rec
4387: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4388: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4389: --party contacts rec
4390: lp_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4391: lx_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4392:

Line 4755: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4751: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4752: l_debug_enabled VARCHAR2(10);
4753: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
4754: -- Record/Table Type Declarations
4755: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4756: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4757: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4758: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4759: --master lease/credit line rec

Line 4756: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4752: l_debug_enabled VARCHAR2(10);
4753: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
4754: -- Record/Table Type Declarations
4755: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4756: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4757: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4758: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4759: --master lease/credit line rec
4760: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 4760: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

4756: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4757: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4758: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4759: --master lease/credit line rec
4760: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
4761: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
4762:
4763: -- Added by rravikir (Bug 5142890)
4764: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;

Line 4761: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

4757: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4758: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4759: --master lease/credit line rec
4760: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
4761: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
4762:
4763: -- Added by rravikir (Bug 5142890)
4764: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;
4765: CURSOR l_qcl_csr IS

Line 4898: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'

4894: lp_mla_gvev_rec.chr_id := x_chr_id;
4895: lp_mla_gvev_rec.chr_id_referred := l_lapv_rec.MASTER_LEASE_ID;
4896: lp_mla_gvev_rec.copied_only_yn := 'N';
4897: IF(l_debug_enabled='Y') THEN
4898: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4899: ,'begin debug call create_governance');
4900: END IF;
4901: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
4902: p_init_msg_list => p_init_msg_list,

Line 4901: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,

4897: IF(l_debug_enabled='Y') THEN
4898: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4899: ,'begin debug call create_governance');
4900: END IF;
4901: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
4902: p_init_msg_list => p_init_msg_list,
4903: x_return_status => x_return_status,
4904: x_msg_count => x_msg_count,
4905: x_msg_data => x_msg_data,

Line 4910: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'

4906: p_gvev_rec => lp_mla_gvev_rec,
4907: x_gvev_rec => lx_mla_gvev_rec);
4908:
4909: IF(l_debug_enabled='Y') THEN
4910: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4911: ,'end debug call create_governance');
4912: END IF;
4913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4914: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4927: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'

4923: lp_mla_gvev_rec.chr_id := x_chr_id;
4924: lp_mla_gvev_rec.chr_id_referred := l_lapv_rec.CREDIT_LINE_ID;
4925: lp_mla_gvev_rec.copied_only_yn := 'N';
4926: IF(l_debug_enabled='Y') THEN
4927: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4928: ,'begin debug call create_governance');
4929: END IF;
4930: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
4931: p_init_msg_list => p_init_msg_list,

Line 4930: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,

4926: IF(l_debug_enabled='Y') THEN
4927: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4928: ,'begin debug call create_governance');
4929: END IF;
4930: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
4931: p_init_msg_list => p_init_msg_list,
4932: x_return_status => x_return_status,
4933: x_msg_count => x_msg_count,
4934: x_msg_data => x_msg_data,

Line 4939: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'

4935: p_gvev_rec => lp_mla_gvev_rec,
4936: x_gvev_rec => lx_mla_gvev_rec);
4937:
4938: IF(l_debug_enabled='Y') THEN
4939: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4940: ,'end debug call create_governance');
4941: END IF;
4942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;