325:
326:
327:
328:
329: lp_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
330:
331: ---- Paramater validations -----
332:
333: IF trunc(lp_report_date) <> trunc(sysdate) THEN
341: write_to_log('No workers specified');
342: return;
343: end if;
344:
345: lp_k_start_date_from := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_FROM);
346: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
347:
348:
349: -- Select sequence for marking processes
342: return;
343: end if;
344:
345: lp_k_start_date_from := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_FROM);
346: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
347:
348:
349: -- Select sequence for marking processes
350: select okl_opp_seq.nextval