3412: ) IS
3413:
3414: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3415: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3416: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3417: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3418:
3419: l_chr_id okc_k_headers_b.id%type;
3420: l_rul_id okc_rules_v.id%type := null;
3413:
3414: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3415: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3416: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3417: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3418:
3419: l_chr_id okc_k_headers_b.id%type;
3420: l_rul_id okc_rules_v.id%type := null;
3421: l_rgp_id okc_rules_v.id%type := null;
3490: lp_lapsth_rgpv_rec.cle_id := p_cle_id;
3491: lp_lapsth_rgpv_rec.rgp_type := 'KRG';
3492:
3493:
3494: OKL_RULE_PUB.update_rule_group(
3495: p_api_version => p_api_version,
3496: p_init_msg_list => p_init_msg_list,
3497: x_return_status => x_return_status,
3498: x_msg_count => x_msg_count,
3515: lp_lastrm_rulv_rec.jtot_object1_code := 'OKL_STRMTYP';
3516: lp_lastrm_rulv_rec.WARN_YN := 'N';
3517: lp_lastrm_rulv_rec.STD_TEMPLATE_YN := 'N';
3518:
3519: OKL_RULE_PUB.update_rule(
3520: p_api_version => p_api_version,
3521: p_init_msg_list => p_init_msg_list,
3522: x_return_status => x_return_status,
3523: x_msg_count => x_msg_count,
3541: lp_lapsth_rgpv_rec.chr_id := null;
3542: lp_lapsth_rgpv_rec.cle_id := p_cle_id;
3543: lp_lapsth_rgpv_rec.rgp_type := 'KRG';
3544:
3545: OKL_RULE_PUB.create_rule_group(
3546: p_api_version => p_api_version,
3547: p_init_msg_list => p_init_msg_list,
3548: x_return_status => x_return_status,
3549: x_msg_count => x_msg_count,
3574: lp_lastrm_rulv_rec.jtot_object1_code := 'OKL_STRMTYP';
3575: lp_lastrm_rulv_rec.WARN_YN := 'N';
3576: lp_lastrm_rulv_rec.STD_TEMPLATE_YN := 'N';
3577:
3578: OKL_RULE_PUB.create_rule(
3579: p_api_version => p_api_version,
3580: p_init_msg_list => p_init_msg_list,
3581: x_return_status => x_return_status,
3582: x_msg_count => x_msg_count,
3594:
3595: -- call the package to create rule
3596: lp_lastrm_rulv_rec.id := l_rul_id;
3597:
3598: OKL_RULE_PUB.delete_rule(
3599: p_api_version => p_api_version,
3600: p_init_msg_list => p_init_msg_list,
3601: x_return_status => x_return_status,
3602: x_msg_count => x_msg_count,
3610: End If;
3611: /*
3612: lp_lapsth_rgpv_rec.id := l_rgp_id;
3613:
3614: OKL_RULE_PUB.delete_rule_group(
3615: p_api_version => p_api_version,
3616: p_init_msg_list => p_init_msg_list,
3617: x_return_status => x_return_status,
3618: x_msg_count => x_msg_count,
3674: ) IS
3675:
3676: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3677: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3678: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3679: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3680:
3681: l_chr_id okc_k_headers_b.id%type;
3682: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3675:
3676: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3677: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3678: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3679: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3680:
3681: l_chr_id okc_k_headers_b.id%type;
3682: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3683: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3761: lp_lapsth_rgpv_rec.chr_id := null;
3762: lp_lapsth_rgpv_rec.cle_id := p_cle_id;
3763: lp_lapsth_rgpv_rec.rgp_type := 'KRG';
3764:
3765: OKL_RULE_PUB.create_rule_group(
3766: p_api_version => p_api_version,
3767: p_init_msg_list => p_init_msg_list,
3768: x_return_status => x_return_status,
3769: x_msg_count => x_msg_count,
3786: lp_lastrm_rulv_rec.jtot_object1_code := 'OKL_STRMTYP';
3787: lp_lastrm_rulv_rec.WARN_YN := 'N';
3788: lp_lastrm_rulv_rec.STD_TEMPLATE_YN := 'N';
3789:
3790: OKL_RULE_PUB.create_rule(
3791: p_api_version => p_api_version,
3792: p_init_msg_list => p_init_msg_list,
3793: x_return_status => x_return_status,
3794: x_msg_count => x_msg_count,
3850: ) IS
3851:
3852: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3853: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3854: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3855: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3856:
3857: l_chr_id okc_k_headers_b.id%type;
3858: l_rgp_id okc_k_headers_b.id%type;
3851:
3852: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3853: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3854: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3855: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3856:
3857: l_chr_id okc_k_headers_b.id%type;
3858: l_rgp_id okc_k_headers_b.id%type;
3859: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3916: lp_lastrm_rulv_rec.jtot_object1_code := 'OKL_STRMTYP';
3917: lp_lastrm_rulv_rec.warn_yn := 'N';
3918: lp_lastrm_rulv_rec.std_template_yn := 'N';
3919:
3920: OKL_RULE_PUB.update_rule(
3921: p_api_version => p_api_version,
3922: p_init_msg_list => p_init_msg_list,
3923: x_return_status => x_return_status,
3924: x_msg_count => x_msg_count,