671:
672: -- Checking split pct value is number or not
673: BEGIN
674: if l_trxapi_imp.split_pct is not null then
675: SELECT to_number(l_trxapi_imp.split_pct) into l_temp from dual;
676: end if;
677:
678: EXCEPTION
679:
779:
780: END IF;
781:
782: -- insert into cn_comm_lines_api
783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
784:
785: INSERT INTO cn_comm_lines_api
786: (ORG_ID,
787: comm_lines_api_id,