5224: END IF;
5225: END IF;
5226: EXIT WHEN (l_id_tbl.count = 0);
5227:
5228: --delete all OKS_K_LINES_TL records
5229: FORALL i IN l_id_tbl.first..l_id_tbl.last
5230: DELETE FROM oks_k_lines_tl WHERE id IN
5231: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5232:
5226: EXIT WHEN (l_id_tbl.count = 0);
5227:
5228: --delete all OKS_K_LINES_TL records
5229: FORALL i IN l_id_tbl.first..l_id_tbl.last
5230: DELETE FROM oks_k_lines_tl WHERE id IN
5231: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5232:
5233: --delete all OKS_K_LINES_B records
5234: FORALL i IN l_id_tbl.first..l_id_tbl.last