Line 675: SELECT to_number(l_trxapi_imp.split_pct) into l_temp from dual;
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:
Line 783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
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,