7: -- in the TAPI: OKS_KLN_PVT.add_language )
8: DELETE FROM OKS_K_LINES_TLH T
9: WHERE NOT EXISTS (
10: SELECT NULL
11: FROM OKS_K_LINES_BH B
12: WHERE B.ID =T.ID
13: AND B.MAJOR_VERSION =T.MAJOR_VERSION
14: );
15:
686:
687:
688: FORALL i in 1..l_tabsize
689: INSERT
690: INTO OKS_K_LINES_B
691: (
692: id,
693: cle_id,
694: dnz_chr_id,
922: --RAISE;
923: END INSERT_ROW_UPG;
924:
925: -------------------------------------------------------------------
926: -- Procedure for mass insert in OKS_K_LINES_BH and OKS_K_LINES_TLH
927: -------------------------------------------------------------------
928: PROCEDURE CREATE_LINE_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
929: p_klnhv_tbl IN klnhv_tbl_type) IS
930:
1144: End Loop;
1145:
1146:
1147: FORALL i in 1..l_tabsize
1148: Insert Into oks_k_lines_bh
1149: (
1150: id ,
1151: major_version,
1152: cle_id ,