4278: else
4279: for i in l_clev_tbl_in.first .. l_clev_tbl_in.last
4280: loop
4281: BEGIN
4282: delete okc_k_lines_tl where
4283: id =l_clev_tbl_in(i).id;
4284: delete okc_k_lines_b where
4285: id =l_clev_tbl_in(i).id;
4286:
10666: ANNUALIZED_FACTOR
10667: FROM okc_k_lines_b
10668: WHERE id = p_old_line_id;
10669:
10670: INSERT INTO okc_k_lines_tl
10671: ( ID,
10672: LANGUAGE,
10673: SOURCE_LANG,
10674: SFWT_FLAG,
10700: FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN,
10701: SECURITY_GROUP_ID,
10702: OKE_BOE_DESCRIPTION,
10703: COGNOMEN
10704: FROM okc_k_lines_tl
10705: where id=p_old_line_id;
10706:
10707:
10708: RETURN x_return_status;