1165: l_msg_data VARCHAR2(2000);
1166:
1167: CURSOR csr_k_details (p_chr_id NUMBER) IS
1168: select okch.scs_code, oksh.wf_item_key
1169: from okc_k_headers_all_b okch, oks_k_headers_b oksh
1170: where okch.ID = p_chr_id
1171: and okch.id = oksh.chr_id;
1172: begin
1173:
1234: l_msg_data VARCHAR2(2000);
1235:
1236: CURSOR csr_class_code(p_chr_id NUMBER) IS
1237: select scs_code
1238: from okc_k_headers_all_b
1239: where ID = p_chr_id;
1240:
1241: begin
1242:
1304: l_msg_data VARCHAR2(2000);
1305:
1306: CURSOR csr_k_details (p_chr_id NUMBER) IS
1307: select okch.scs_code, oksh.wf_item_key
1308: from okc_k_headers_all_b okch, oks_k_headers_b oksh
1309: where okch.ID = p_chr_id
1310: and okch.id = oksh.chr_id;
1311: begin
1312: