1590: END IF;
1591: -- nocopy changes
1592: l_dtl_rec_nc := p_dtl_rec;
1593: -- Get the next sequence NUMBER to insert a record into the table
1594: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1595:
1596: INSERT INTO ben_ext_rslt_dtl
1597: (EXT_RSLT_DTL_ID
1598: ,EXT_RSLT_ID
12999: ,p_effective_date
13000: ,p_error_message
13001: ,l_seq_num);
13002:
13003: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;
13004:
13005: INSERT INTO ben_ext_rslt_dtl
13006: ( EXT_RSLT_DTL_ID
13007: ,EXT_RSLT_ID
13102: ,c_ext_dtl_rcd_id => l_rcd_id);
13103: FETCH csr_rslt_dtl INTO l_main_rec;
13104: CLOSE csr_rslt_dtl;
13105:
13106: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;
13107:
13108: INSERT INTO ben_ext_rslt_dtl
13109: ( EXT_RSLT_DTL_ID
13110: ,EXT_RSLT_ID