DBA Data[Home] [Help]

APPS.OKL_PA_DATA_INTEGRITY dependencies on FND_LOOKUPS

Line 356: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE

352:
353: END validate_status;
354:
355: -- This function returns the lookup meaning of the lookup code and lookup type passed to the function.
356: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
357: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
358: RETURN VARCHAR2
359: IS
360: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type

Line 357: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)

353: END validate_status;
354:
355: -- This function returns the lookup meaning of the lookup code and lookup type passed to the function.
356: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
357: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
358: RETURN VARCHAR2
359: IS
360: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
361: ,p_lookup_code fnd_lookups.lookup_code%type)

Line 360: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type

356: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
357: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
358: RETURN VARCHAR2
359: IS
360: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
361: ,p_lookup_code fnd_lookups.lookup_code%type)
362: IS
363: SELECT MEANING
364: FROM FND_LOOKUPS FND

Line 361: ,p_lookup_code fnd_lookups.lookup_code%type)

357: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
358: RETURN VARCHAR2
359: IS
360: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
361: ,p_lookup_code fnd_lookups.lookup_code%type)
362: IS
363: SELECT MEANING
364: FROM FND_LOOKUPS FND
365: WHERE FND.LOOKUP_TYPE = p_lookup_type

Line 364: FROM FND_LOOKUPS FND

360: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
361: ,p_lookup_code fnd_lookups.lookup_code%type)
362: IS
363: SELECT MEANING
364: FROM FND_LOOKUPS FND
365: WHERE FND.LOOKUP_TYPE = p_lookup_type
366: AND FND.LOOKUP_CODE = p_lookup_code;
367:
368: l_return_value fnd_lookups.meaning%TYPE;

Line 368: l_return_value fnd_lookups.meaning%TYPE;

364: FROM FND_LOOKUPS FND
365: WHERE FND.LOOKUP_TYPE = p_lookup_type
366: AND FND.LOOKUP_CODE = p_lookup_code;
367:
368: l_return_value fnd_lookups.meaning%TYPE;
369:
370: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.get_lookup_meaning';
371: l_debug_enabled VARCHAR2(10);
372: