APPS.OKL_LLA_UTIL_PVT dependencies on FND_LOOKUPS

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

43: -- Parameters :
44: -- Version : 1.0
45: -- History : 21-FEB-2007 asahoo created
46: -- End of comments
47: FUNCTION get_lookup_meaning(p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
48: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
49: RETURN VARCHAR2 IS
50: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
51: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS

Line 48: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)

44: -- Version : 1.0
45: -- History : 21-FEB-2007 asahoo created
46: -- End of comments
47: FUNCTION get_lookup_meaning(p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
48: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
49: RETURN VARCHAR2 IS
50: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
51: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
52: SELECT MEANING

Line 50: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE

46: -- End of comments
47: FUNCTION get_lookup_meaning(p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
48: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
49: RETURN VARCHAR2 IS
50: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
51: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
52: SELECT MEANING
53: FROM FND_LOOKUPS FND
54: WHERE FND.LOOKUP_TYPE = p_lookup_type

Line 51: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS

47: FUNCTION get_lookup_meaning(p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
48: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
49: RETURN VARCHAR2 IS
50: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
51: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
52: SELECT MEANING
53: FROM FND_LOOKUPS FND
54: WHERE FND.LOOKUP_TYPE = p_lookup_type
55: AND FND.LOOKUP_CODE = p_lookup_code;

Line 53: FROM FND_LOOKUPS FND

49: RETURN VARCHAR2 IS
50: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
51: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
52: SELECT MEANING
53: FROM FND_LOOKUPS FND
54: WHERE FND.LOOKUP_TYPE = p_lookup_type
55: AND FND.LOOKUP_CODE = p_lookup_code;
56: l_return_value FND_LOOKUPS.MEANING%TYPE := NULL;
57: BEGIN

Line 56: l_return_value FND_LOOKUPS.MEANING%TYPE := NULL;

52: SELECT MEANING
53: FROM FND_LOOKUPS FND
54: WHERE FND.LOOKUP_TYPE = p_lookup_type
55: AND FND.LOOKUP_CODE = p_lookup_code;
56: l_return_value FND_LOOKUPS.MEANING%TYPE := NULL;
57: BEGIN
58: IF (p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL) THEN
59: OPEN fnd_lookup_csr(p_lookup_type, p_lookup_code);
60: FETCH fnd_lookup_csr INTO l_return_value;