2618: and nvl(crg.cle_id,-1) = p_cle_id; */
2619:
2620: ln_old_line_id OKL_K_LINES_V.ID%TYPE;
2621: ln_service_line_id OKL_K_LINES_V.ID%TYPE;
2622: ln_rule_amount OKC_RULES_V.RULE_INFORMATION2%TYPE;
2623: ln_rule_id OKC_RULES_V.ID%TYPE;
2624: lv_num_periods OKC_RULES_V.RULE_INFORMATION1%TYPE;
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2619:
2620: ln_old_line_id OKL_K_LINES_V.ID%TYPE;
2621: ln_service_line_id OKL_K_LINES_V.ID%TYPE;
2622: ln_rule_amount OKC_RULES_V.RULE_INFORMATION2%TYPE;
2623: ln_rule_id OKC_RULES_V.ID%TYPE;
2624: lv_num_periods OKC_RULES_V.RULE_INFORMATION1%TYPE;
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2620: ln_old_line_id OKL_K_LINES_V.ID%TYPE;
2621: ln_service_line_id OKL_K_LINES_V.ID%TYPE;
2622: ln_rule_amount OKC_RULES_V.RULE_INFORMATION2%TYPE;
2623: ln_rule_id OKC_RULES_V.ID%TYPE;
2624: lv_num_periods OKC_RULES_V.RULE_INFORMATION1%TYPE;
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2628: ln_rule_info_2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
2622: ln_rule_amount OKC_RULES_V.RULE_INFORMATION2%TYPE;
2623: ln_rule_id OKC_RULES_V.ID%TYPE;
2624: lv_num_periods OKC_RULES_V.RULE_INFORMATION1%TYPE;
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2628: ln_rule_info_2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
2629: ln_rule_info_7 OKC_RULES_V.RULE_INFORMATION7%TYPE;
2630: ln_rule_info_8 OKC_RULES_V.RULE_INFORMATION8%TYPE;
2623: ln_rule_id OKC_RULES_V.ID%TYPE;
2624: lv_num_periods OKC_RULES_V.RULE_INFORMATION1%TYPE;
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2628: ln_rule_info_2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
2629: ln_rule_info_7 OKC_RULES_V.RULE_INFORMATION7%TYPE;
2630: ln_rule_info_8 OKC_RULES_V.RULE_INFORMATION8%TYPE;
2631: -- end rravikir added for bug 3504415
2624: lv_num_periods OKC_RULES_V.RULE_INFORMATION1%TYPE;
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2628: ln_rule_info_2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
2629: ln_rule_info_7 OKC_RULES_V.RULE_INFORMATION7%TYPE;
2630: ln_rule_info_8 OKC_RULES_V.RULE_INFORMATION8%TYPE;
2631: -- end rravikir added for bug 3504415
2632:
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2628: ln_rule_info_2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
2629: ln_rule_info_7 OKC_RULES_V.RULE_INFORMATION7%TYPE;
2630: ln_rule_info_8 OKC_RULES_V.RULE_INFORMATION8%TYPE;
2631: -- end rravikir added for bug 3504415
2632:
2633: BEGIN
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2628: ln_rule_info_2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
2629: ln_rule_info_7 OKC_RULES_V.RULE_INFORMATION7%TYPE;
2630: ln_rule_info_8 OKC_RULES_V.RULE_INFORMATION8%TYPE;
2631: -- end rravikir added for bug 3504415
2632:
2633: BEGIN
2634: x_return_status := OKL_API.G_RET_STS_SUCCESS;