APPS.OKL_SYSTEM_ACCT_OPT_PVT dependencies on FND_LOOKUPS

Line 12: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE

8: G_ADO_LOOKUP_TYPE CONSTANT VARCHAR2(30) := 'OKL_ACCOUNT_DERIVATION_OPTION';
9: G_ADO_ATS CONSTANT VARCHAR2(30) := 'ATS';
10: G_ADO_AMB CONSTANT VARCHAR2(30) := 'AMB';
11:
12: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
13: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
14: RETURN VARCHAR
15: IS
16: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type

Line 13: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)

9: G_ADO_ATS CONSTANT VARCHAR2(30) := 'ATS';
10: G_ADO_AMB CONSTANT VARCHAR2(30) := 'AMB';
11:
12: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
13: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
14: RETURN VARCHAR
15: IS
16: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
17: ,p_lookup_code fnd_lookups.lookup_code%type)

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

12: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
13: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
14: RETURN VARCHAR
15: IS
16: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
17: ,p_lookup_code fnd_lookups.lookup_code%type)
18: IS
19: SELECT MEANING
20: FROM FND_LOOKUPS FND

Line 17: ,p_lookup_code fnd_lookups.lookup_code%type)

13: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
14: RETURN VARCHAR
15: IS
16: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
17: ,p_lookup_code fnd_lookups.lookup_code%type)
18: IS
19: SELECT MEANING
20: FROM FND_LOOKUPS FND
21: WHERE FND.LOOKUP_TYPE = p_lookup_type

Line 20: FROM FND_LOOKUPS FND

16: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
17: ,p_lookup_code fnd_lookups.lookup_code%type)
18: IS
19: SELECT MEANING
20: FROM FND_LOOKUPS FND
21: WHERE FND.LOOKUP_TYPE = p_lookup_type
22: AND FND.LOOKUP_CODE = p_lookup_code;
23:
24: l_return_value VARCHAR2(200) := OKL_API.G_MISS_CHAR;