591: l_last_run_date := l_last_run_date + l_freq;
592: ELSIF l_freq_unit = 'MONTHS' then
593: SELECT add_months(l_last_run_date, l_freq)
594: INTO l_last_run_date
595: FROM dual;
596: ELSIF l_freq_unit = 'YEAR' then
597: SELECT add_months(l_last_run_date, l_freq * 12)
598: INTO l_last_run_date
599: FROM dual;
595: FROM dual;
596: ELSIF l_freq_unit = 'YEAR' then
597: SELECT add_months(l_last_run_date, l_freq * 12)
598: INTO l_last_run_date
599: FROM dual;
600: END IF;
601:
602: IF OZF_DEBUG_LOW_ON THEN
603: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_last_run_date :' || to_char(l_last_run_date));
733: l_last_run_date := l_last_run_date + l_freq;
734: ELSIF l_freq_unit = 'MONTHS' then
735: SELECT add_months(l_last_run_date, l_freq)
736: INTO l_last_run_date
737: FROM dual;
738: ELSIF l_freq_unit = 'YEAR' then
739: SELECT add_months(l_last_run_date, l_freq * 12)
740: INTO l_last_run_date
741: FROM dual;
737: FROM dual;
738: ELSIF l_freq_unit = 'YEAR' then
739: SELECT add_months(l_last_run_date, l_freq * 12)
740: INTO l_last_run_date
741: FROM dual;
742: END IF;
743:
744: FND_FILE.PUT_LINE(FND_FILE.LOG,'SuppSite Loop: l_last_run_date post calculation : ' || l_last_run_date);
745:
1167: l_supplier_id := p_supplier_id;
1168: l_supplier_site_id := p_supplier_site_id;
1169: l_batch_new := p_batch_new;
1170:
1171: SELECT ozf_sd_batch_headers_all_s.nextval INTO l_batch_id FROM dual;
1172:
1173: l_org_id := p_org_id;
1174: p_batch_id := l_batch_id;
1175: l_batch_threshold := p_batch_threshold;