617: l_start_date okc_k_headers_b.start_date%type := null;
618: l_end_date okc_k_headers_b.end_date%type := null;
619:
620: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
621: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
622:
623: CURSOR get_capitalize_yn_csr(cap_yn VARCHAR2) IS
624: SELECT CAPITALIZE_YN
625: FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP
627: AND OKL_STRMTYP.STATUS = 'A';
628:
629: CURSOR get_lty_code_csr(lse_id NUMBER) IS
630: select lty_code
631: from okc_line_styles_v
632: where id = lse_id;
633:
634:
635: BEGIN
953: l_start_date okc_k_headers_b.start_date%type := null;
954: l_end_date okc_k_headers_b.end_date%type := null;
955:
956: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
957: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
958:
959: CURSOR get_capitalize_yn_csr(cap_yn VARCHAR2) IS
960: SELECT CAPITALIZE_YN
961: FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP
963: AND OKL_STRMTYP.STATUS = 'A';
964:
965: CURSOR get_lty_code_csr(lse_id NUMBER) IS
966: select lty_code
967: from okc_line_styles_v
968: where id = lse_id;
969:
970: -- Bug# 6438785
971: CURSOR c_orig_cle_csr(p_cle_id IN NUMBER) IS