70:
71: l_party_found VARCHAR2(1);
72: l_rrd_id NUMBER;
73:
74: lp_lalabl_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
75: lx_lalabl_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
76:
77: lp_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
78: lx_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
71: l_party_found VARCHAR2(1);
72: l_rrd_id NUMBER;
73:
74: lp_lalabl_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
75: lx_lalabl_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
76:
77: lp_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
78: lx_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
79:
76:
77: lp_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
78: lx_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
79:
80: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
81: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
82:
83: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
84: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
77: lp_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
78: lx_lalogo_rulv_rec Okl_Rule_Pub.rulv_rec_type;
79:
80: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
81: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
82:
83: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
84: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
85:
82:
83: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
84: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
85:
86: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
87: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
88:
89: l_msg_data VARCHAR2(4000);
90: l_msg_index_out number;
83: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
84: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
85:
86: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
87: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
88:
89: l_msg_data VARCHAR2(4000);
90: l_msg_index_out number;
91:
566:
567: l_api_name VARCHAR2(30) := 'process_gurantor';
568: l_api_version CONSTANT NUMBER := 1.0;
569:
570: lp_lagrdt_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
571: lx_lagrdt_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
572:
573: lp_lagrnp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
574: lx_lagrnp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
567: l_api_name VARCHAR2(30) := 'process_gurantor';
568: l_api_version CONSTANT NUMBER := 1.0;
569:
570: lp_lagrdt_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
571: lx_lagrdt_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
572:
573: lp_lagrnp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
574: lx_lagrnp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
575:
575:
576: lp_lagrnt_rulv_rec Okl_Rule_Pub.rulv_rec_type;
577: lx_lagrnt_rulv_rec Okl_Rule_Pub.rulv_rec_type;
578:
579: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
580: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
581:
582: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
583: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
576: lp_lagrnt_rulv_rec Okl_Rule_Pub.rulv_rec_type;
577: lx_lagrnt_rulv_rec Okl_Rule_Pub.rulv_rec_type;
578:
579: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
580: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
581:
582: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
583: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
584:
581:
582: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
583: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
584:
585: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
586: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
587:
588: CURSOR c_get_rrd_id(p_chr_id NUMBER, p_rle_code VARCHAR2, p_rgd_code VARCHAR2) IS
589: SELECT rgrdfs.id
582: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
583: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
584:
585: lp_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
586: lx_rmpv_rec OKL_OKC_MIGRATION_PVT.rmpv_rec_type;
587:
588: CURSOR c_get_rrd_id(p_chr_id NUMBER, p_rle_code VARCHAR2, p_rgd_code VARCHAR2) IS
589: SELECT rgrdfs.id
590: FROM okc_k_headers_b chr,