DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 414: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

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

Line 415: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

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

Line 2023: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

2019: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2020: l_debug_enabled VARCHAR2(10);
2021: l_klev_rec okl_kle_pvt.klev_rec_type;
2022: lx_klev_rec okl_kle_pvt.klev_rec_type;
2023: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2024: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2025: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2026: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2027: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 2024: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

2020: l_debug_enabled VARCHAR2(10);
2021: l_klev_rec okl_kle_pvt.klev_rec_type;
2022: lx_klev_rec okl_kle_pvt.klev_rec_type;
2023: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2024: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2025: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2026: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2027: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2028: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 2025: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

2021: l_klev_rec okl_kle_pvt.klev_rec_type;
2022: lx_klev_rec okl_kle_pvt.klev_rec_type;
2023: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2024: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2025: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2026: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2027: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2028: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2029: l_quote_service_rec quote_service_rec_type;

Line 2026: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

2022: lx_klev_rec okl_kle_pvt.klev_rec_type;
2023: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2024: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2025: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2026: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2027: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2028: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2029: l_quote_service_rec quote_service_rec_type;
2030: line_number NUMBER := 0;

Line 2027: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

2023: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
2024: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2025: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2026: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2027: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2028: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2029: l_quote_service_rec quote_service_rec_type;
2030: line_number NUMBER := 0;
2031: lx_chr_id NUMBER;

Line 2028: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

2024: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2025: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2026: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2027: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2028: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2029: l_quote_service_rec quote_service_rec_type;
2030: line_number NUMBER := 0;
2031: lx_chr_id NUMBER;
2032: lx_cle_id NUMBER;

Line 3481: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;

3477: l_pymnt_counter NUMBER := 0;
3478: l_ast_counter NUMBER:=0;
3479: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
3480: --asset rec
3481: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3482: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3483: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3484: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3485: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;

Line 3483: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;

3479: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
3480: --asset rec
3481: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3482: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3483: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3484: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3485: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3486: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3487: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;

Line 3484: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;

3480: --asset rec
3481: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3482: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3483: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3484: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3485: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3486: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3487: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3488: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;

Line 3485: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;

3481: l_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3482: l_klev_fin_rec okl_kle_pvt.klev_rec_type;
3483: l_cimv_model_rec okl_okc_migration_pvt.cimv_rec_type;
3484: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3485: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3486: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3487: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3488: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3489: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;

Line 3488: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;

3484: l_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3485: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3486: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3487: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3488: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3489: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3490: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3491: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3492: l_payment_levels_tbl payment_levels_tbl_type;

Line 3489: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;

3485: l_cimv_fa_rec okl_okc_migration_pvt.cimv_rec_type;
3486: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3487: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3488: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3489: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3490: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3491: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3492: l_payment_levels_tbl payment_levels_tbl_type;
3493: l_qte_payment_levels_tbl payment_levels_tbl_type;

Line 3490: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;

3486: l_talv_fa_rec okl_tal_pvt.talv_rec_type;
3487: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3488: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3489: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3490: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3491: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3492: l_payment_levels_tbl payment_levels_tbl_type;
3493: l_qte_payment_levels_tbl payment_levels_tbl_type;
3494: l_pym_hdr_rec okl_la_payments_pvt.pym_hdr_rec_type;

Line 3491: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;

3487: l_itiv_tbl okl_iti_pvt.itiv_tbl_type;
3488: lx_clev_fin_rec okl_okc_migration_pvt.clev_rec_type;
3489: lx_clev_model_rec okl_okc_migration_pvt.clev_rec_type;
3490: lx_clev_fa_rec okl_okc_migration_pvt.clev_rec_type;
3491: lx_clev_ib_rec okl_okc_migration_pvt.clev_rec_type;
3492: l_payment_levels_tbl payment_levels_tbl_type;
3493: l_qte_payment_levels_tbl payment_levels_tbl_type;
3494: l_pym_hdr_rec okl_la_payments_pvt.pym_hdr_rec_type;
3495: l_pym_tbl okl_la_payments_pvt.pym_tbl_type;

Line 4500: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4496: l_party_desc VARCHAR2(2000);
4497: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
4498: -- Record/Table Type Declarations
4499: --party rec
4500: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4501: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4502: --party contacts rec
4503: lp_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4504: lx_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

Line 4501: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4497: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
4498: -- Record/Table Type Declarations
4499: --party rec
4500: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4501: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4502: --party contacts rec
4503: lp_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4504: lx_ctcv_rec OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
4505:

Line 4629: null_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4625: AND status = 'A'
4626: AND identifying_address_flag = 'Y' ;
4627:
4628: -- Variables Declaration Section
4629: null_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4630: null_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4631: lp_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4632: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4633: l_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

Line 5327: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5323: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5324: l_debug_enabled VARCHAR2(10);
5325: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
5326: -- Record/Table Type Declarations
5327: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5328: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5329: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5330: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5331: --master lease/credit line rec

Line 5328: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

5324: l_debug_enabled VARCHAR2(10);
5325: l_lapv_rec c_get_leaseapp_hdr%ROWTYPE;
5326: -- Record/Table Type Declarations
5327: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5328: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5329: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5330: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5331: --master lease/credit line rec
5332: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 5332: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5328: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5329: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5330: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5331: --master lease/credit line rec
5332: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5333: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5334:
5335: -- Added by rravikir (Bug 5142890)
5336: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;

Line 5333: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

5329: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5330: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
5331: --master lease/credit line rec
5332: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5333: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5334:
5335: -- Added by rravikir (Bug 5142890)
5336: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;
5337: CURSOR l_qcl_csr IS

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

5532: lp_mla_gvev_rec.chr_id := x_chr_id;
5533: lp_mla_gvev_rec.chr_id_referred := l_lapv_rec.MASTER_LEASE_ID;
5534: lp_mla_gvev_rec.copied_only_yn := 'N';
5535: IF(l_debug_enabled='Y') THEN
5536: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
5537: ,'begin debug call create_governance');
5538: END IF;
5539: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
5540: p_init_msg_list => p_init_msg_list,

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

5535: IF(l_debug_enabled='Y') THEN
5536: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
5537: ,'begin debug call create_governance');
5538: END IF;
5539: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
5540: p_init_msg_list => p_init_msg_list,
5541: x_return_status => x_return_status,
5542: x_msg_count => x_msg_count,
5543: x_msg_data => x_msg_data,

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

5544: p_gvev_rec => lp_mla_gvev_rec,
5545: x_gvev_rec => lx_mla_gvev_rec);
5546:
5547: IF(l_debug_enabled='Y') THEN
5548: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
5549: ,'end debug call create_governance');
5550: END IF;
5551: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

5561: lp_mla_gvev_rec.chr_id := x_chr_id;
5562: lp_mla_gvev_rec.chr_id_referred := l_lapv_rec.CREDIT_LINE_ID;
5563: lp_mla_gvev_rec.copied_only_yn := 'N';
5564: IF(l_debug_enabled='Y') THEN
5565: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
5566: ,'begin debug call create_governance');
5567: END IF;
5568: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
5569: p_init_msg_list => p_init_msg_list,

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

5564: IF(l_debug_enabled='Y') THEN
5565: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
5566: ,'begin debug call create_governance');
5567: END IF;
5568: OKL_OKC_MIGRATION_PVT.create_governance(p_api_version => p_api_version,
5569: p_init_msg_list => p_init_msg_list,
5570: x_return_status => x_return_status,
5571: x_msg_count => x_msg_count,
5572: x_msg_data => x_msg_data,

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

5573: p_gvev_rec => lp_mla_gvev_rec,
5574: x_gvev_rec => lx_mla_gvev_rec);
5575:
5576: IF(l_debug_enabled='Y') THEN
5577: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
5578: ,'end debug call create_governance');
5579: END IF;
5580: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;