328:
329:
330:
331:
332: -- lp_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE); sechawla 25-sep-09 8890513
333:
334:
335:
336: ---- Paramater validations -----
347: write_to_log('No workers specified');
348: return;
349: end if;
350:
351: lp_k_start_date_from := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_FROM);
352: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
353:
354:
355: IF P_END_DATE_FROM IS NOT NULL THEN
348: return;
349: end if;
350:
351: lp_k_start_date_from := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_FROM);
352: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
353:
354:
355: IF P_END_DATE_FROM IS NOT NULL THEN
356: lp_k_end_date_from := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_FROM);
352: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
353:
354:
355: IF P_END_DATE_FROM IS NOT NULL THEN
356: lp_k_end_date_from := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_FROM);
357: END IF;
358:
359: IF P_END_DATE_TO IS NOT NULL THEN
360: lp_k_end_date_to := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_TO);
356: lp_k_end_date_from := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_FROM);
357: END IF;
358:
359: IF P_END_DATE_TO IS NOT NULL THEN
360: lp_k_end_date_to := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_TO);
361: END IF;
362:
363: -- Select sequence for marking processes
364: select okl_opp_seq.nextval