[Home] [Help]
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: -- check if the seeded flag is passed in and is not
389: -- null, if passed in check if the lookup code
390: -- exists in fnd lookups for this date, if not
391: -- its an invalid argument.
392: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
393: ( p_seeded_flag IS NOT NULL )) THEN
394: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
540: -- |----------------------< lookup_code_not_exists >---------------------------
541: -- ----------------------------------------------------------------------------
542: -- Description:
543: -- Function used to validate the lookup code using
544: -- the fnd_lookups table returns TRUE if the lookup code
545: -- exists else returns FALSE.
546: --
547: -- Uses p_effective_Date to date track the records.
548: --
571: -- Declare Local cursors
572: --
573: cursor csr_lookup_code is
574: select null
575: from fnd_lookups
576: where lookup_code = p_lookup_code
577: and lookup_type = p_lookup_type
578: and enabled_flag = 'Y'
579: and trunc(p_effective_date) between