APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT dependencies on FND_DATE

Line 332: lp_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);

328:
329:
330:
331:
332: lp_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
333:
334: ---- Paramater validations -----
335:
336: IF trunc(lp_report_date) <> trunc(sysdate) THEN

Line 348: lp_k_start_date_from := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_FROM);

344: write_to_log('No workers specified');
345: return;
346: end if;
347:
348: lp_k_start_date_from := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_FROM);
349: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
350:
351:
352: IF P_END_DATE_FROM IS NOT NULL THEN

Line 349: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);

345: return;
346: end if;
347:
348: lp_k_start_date_from := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_FROM);
349: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
350:
351:
352: IF P_END_DATE_FROM IS NOT NULL THEN
353: lp_k_end_date_from := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_FROM);

Line 353: lp_k_end_date_from := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_FROM);

349: lp_k_start_date_to := FND_DATE.CANONICAL_TO_DATE(P_START_DATE_TO);
350:
351:
352: IF P_END_DATE_FROM IS NOT NULL THEN
353: lp_k_end_date_from := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_FROM);
354: END IF;
355:
356: IF P_END_DATE_TO IS NOT NULL THEN
357: lp_k_end_date_to := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_TO);

Line 357: lp_k_end_date_to := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_TO);

353: lp_k_end_date_from := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_FROM);
354: END IF;
355:
356: IF P_END_DATE_TO IS NOT NULL THEN
357: lp_k_end_date_to := FND_DATE.CANONICAL_TO_DATE(P_END_DATE_TO);
358: END IF;
359:
360: -- Select sequence for marking processes
361: select okl_opp_seq.nextval