APPS.OKL_AMORT_SCHED_PROCESS_PVT dependencies on DUAL

Line 34: select okl_amort_sched_hdr_s.nextval into l_hdr_id from dual;

30: --Insert for Detail
31: --Insert 4 records into the header for detail for Principal, Interest, Principal Balance, and Period
32: for ins_count in 1 .. G_DET_COLUMNS
33: loop
34: select okl_amort_sched_hdr_s.nextval into l_hdr_id from dual;
35: if ins_count = 1 then
36: l_amor_hdr_id(l_indx).pri_det_id := l_hdr_id;
37: l_amor_type := G_PRINCIPAL_TYPE;
38: elsif ins_count = 2 then

Line 72: select okl_amort_sched_hdr_s.nextval into l_hdr_id from dual;

68:
69: --Insert 5 records into the header for detail for Principal, Interest, Principal Balance, Date from and Date to
70: for ins_count in 1 .. G_SUMM_COLUMNS
71: loop
72: select okl_amort_sched_hdr_s.nextval into l_hdr_id from dual;
73: if ins_count = 1 then
74: l_amor_hdr_id(l_indx).pri_summ_id := l_hdr_id;
75: l_amor_type := G_PRINCIPAL_TYPE;
76: elsif ins_count = 2 then

Line 297: select okl_amort_sched_lines_s.nextval into l_det_amor_line_id(i) from dual;

293: l_rec_count := l_rec_count - 1;
294: l_det_amor_line_id.extend(l_rec_count,1);
295: for i in 1 .. l_det_amor_line_id.count
296: loop
297: select okl_amort_sched_lines_s.nextval into l_det_amor_line_id(i) from dual;
298: end loop;
299: end if;
300: -- dbms_output.put_line('l_det_amor_line_id : ' || l_det_amor_line_id.count || ',p_det_amort_sched_tbl.count: ' || p_det_amort_sched_tbl.count);
301: l_rec_count := 0;

Line 325: select okl_amort_sched_lines_s.nextval into l_summ_amor_line_id(i) from dual;

321: if l_summ_amor_line_id.count > l_det_amor_line_id.count then
322: l_summ_det_cnt := l_summ_det_cnt + 1;
323: for i in l_summ_det_cnt .. l_summ_amor_line_id.count
324: loop
325: select okl_amort_sched_lines_s.nextval into l_summ_amor_line_id(i) from dual;
326: end loop;
327: end if;
328: end if;
329: