426: v_Index Binary_Integer;
427:
428: CURSOR Child_Cur1(P_Parent_Id IN NUMBER)
429: IS SELECT ID
430: FROM OKc_K_Lines_b
431: WHERE cle_id=P_Parent_Id;
432:
433: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
434: IS SELECT ID
431: WHERE cle_id=P_Parent_Id;
432:
433: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
434: IS SELECT ID
435: FROM Okc_K_Lines_b
436: WHERE cle_Id=P_Parent_Id;
437:
438: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
439: IS SELECT ID
436: WHERE cle_Id=P_Parent_Id;
437:
438: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
439: IS SELECT ID
440: FROM Okc_K_Lines_b
441: WHERE cle_Id=P_Parent_Id;
442:
443: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
444: IS SELECT ID
441: WHERE cle_Id=P_Parent_Id;
442:
443: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
444: IS SELECT ID
445: FROM Okc_K_Lines_b
446: WHERE cle_Id=P_Parent_Id;
447:
448: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
449: IS SELECT ID
446: WHERE cle_Id=P_Parent_Id;
447:
448: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
449: IS SELECT ID
450: FROM Okc_K_Lines_b
451: WHERE cle_Id=P_Parent_Id;
452:
453: n NUMBER:=0;
454: l_cle_tbl_in OKE_CLE_PVT.cle_tbl_type;
1389: where k_header_id = p_header_id;
1390:
1391: delete from OKE_K_LINES_H
1392: where k_line_id in
1393: (select id from okc_k_lines_bh
1394: where dnz_chr_id = p_header_id);
1395:
1396: delete from OKE_K_DELIVERABLES_TLH
1397: where deliverable_id in