Line 545: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
541: /*
542: l_effective_date := to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
543: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');
544: */ 545: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date)); 546: --
547: -- Sanity check that at least one field has been entered
548: --
549: if p_concurrent_request_id is null and