APPS.OKL_EC_EVALUATE_PVT dependencies on FND_LOOKUPS

Line 6: FUNCTION get_lookup_meaning(p_lookup_type fnd_lookups.lookup_type%TYPE

2: /* $Header: OKLRECUB.pls 120.3 2005/08/23 05:38:27 asawanka noship $ */
3: /**
4: This function returs the lookup meaning for the given lookup type and code.
5: **/
6: FUNCTION get_lookup_meaning(p_lookup_type fnd_lookups.lookup_type%TYPE
7: ,p_lookup_code fnd_lookups.lookup_code%TYPE) RETURN varchar2 IS
8:
9: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
10: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS

Line 7: ,p_lookup_code fnd_lookups.lookup_code%TYPE) RETURN varchar2 IS

3: /**
4: This function returs the lookup meaning for the given lookup type and code.
5: **/
6: FUNCTION get_lookup_meaning(p_lookup_type fnd_lookups.lookup_type%TYPE
7: ,p_lookup_code fnd_lookups.lookup_code%TYPE) RETURN varchar2 IS
8:
9: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
10: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
11: SELECT meaning

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

5: **/
6: FUNCTION get_lookup_meaning(p_lookup_type fnd_lookups.lookup_type%TYPE
7: ,p_lookup_code fnd_lookups.lookup_code%TYPE) RETURN varchar2 IS
8:
9: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
10: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
11: SELECT meaning
12: FROM fnd_lookups fnd
13: WHERE fnd.lookup_type = p_lookup_type

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

6: FUNCTION get_lookup_meaning(p_lookup_type fnd_lookups.lookup_type%TYPE
7: ,p_lookup_code fnd_lookups.lookup_code%TYPE) RETURN varchar2 IS
8:
9: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
10: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
11: SELECT meaning
12: FROM fnd_lookups fnd
13: WHERE fnd.lookup_type = p_lookup_type
14: AND fnd.lookup_code = p_lookup_code;

Line 12: FROM fnd_lookups fnd

8:
9: CURSOR fnd_lookup_csr(p_lookup_type fnd_lookups.lookup_type%TYPE
10: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
11: SELECT meaning
12: FROM fnd_lookups fnd
13: WHERE fnd.lookup_type = p_lookup_type
14: AND fnd.lookup_code = p_lookup_code;
15: l_return_value varchar2(200) := okl_api.g_miss_char;
16: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_lookup_meaning';

Line 110: FROM fnd_lookups

106: ,p_src_name IN varchar2) RETURN varchar2 IS
107:
108: CURSOR get_op IS
109: SELECT meaning
110: FROM fnd_lookups
111: WHERE lookup_type = 'OKL_FE_OPERATORS' AND lookup_code = p_operator;
112: l_operator varchar2(30);
113: l_msg varchar2(240);
114: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_msg_single';