2659:
2660: FOR dist_rec IN get_dist_cur(p_term_id) LOOP
2661:
2662: l_new_dist_id := NULL;
2663: SELECT pn_distributions_s.nextval
2664: INTO l_new_dist_id
2665: FROM DUAL;
2666:
2667: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_dist_id : '||l_new_dist_id);
3252: i = 2) OR
3253: (p_eff_str_dt = term_rec.start_date AND
3254: i = 1) THEN
3255:
3256: SELECT pn_distributions_s.NEXTVAL
3257: INTO l_dist_id
3258: FROM DUAL;
3259:
3260: l_insert_dist_hist := 'Y';