DBA Data[Home] [Help]

APPS.OKC_STATUS_CHANGE_PVT dependencies on FND_DATE

Line 3301: l_last_rundate := nvl(fnd_date.canonical_to_date(p_last_rundate), to_date('01011901','ddmmyyyy')) - 3; -- a three day grace period.

3297: v_active_m := 'Signed';
3298: end if;
3299: close sts;
3300:
3301: l_last_rundate := nvl(fnd_date.canonical_to_date(p_last_rundate), to_date('01011901','ddmmyyyy')) - 3; -- a three day grace period.
3302:
3303: -- from active hold signed to terminated
3304: c := 0;
3305: l_new_status := null;