712: p_cplv_rec IN CPLV_REC_TYPE) is
713: l_dummy_var varchar2(1) := '?';
714: cursor l_cle_csr is
715: select 'x'
716: from OKC_K_LINES_B
717: where id = p_cplv_rec.cle_id;
718: begin
719:
720: IF (l_debug = 'Y') THEN
930: --
931: cursor cle_csr is
932: select '!'
933: from
934: okc_k_lines_b
935: ,okc_line_style_roles
936: where
937: okc_k_lines_b.ID = p_cplv_rec.cle_id
938: and okc_line_style_roles.LSE_ID = okc_k_lines_b.LSE_ID
933: from
934: okc_k_lines_b
935: ,okc_line_style_roles
936: where
937: okc_k_lines_b.ID = p_cplv_rec.cle_id
938: and okc_line_style_roles.LSE_ID = okc_k_lines_b.LSE_ID
939: and okc_line_style_roles.SRE_ID in
940: (
941: select okc_subclass_roles.ID
934: okc_k_lines_b
935: ,okc_line_style_roles
936: where
937: okc_k_lines_b.ID = p_cplv_rec.cle_id
938: and okc_line_style_roles.LSE_ID = okc_k_lines_b.LSE_ID
939: and okc_line_style_roles.SRE_ID in
940: (
941: select okc_subclass_roles.ID
942: from