10:
11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
12: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
13: PROCEDURE Check_lookup_name_Or_Id
14: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
15: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
16: p_meaning IN FND_LOOKUPS.meaning%TYPE,
17: p_check_id_flag IN VARCHAR2,
18: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
12: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
13: PROCEDURE Check_lookup_name_Or_Id
14: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
15: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
16: p_meaning IN FND_LOOKUPS.meaning%TYPE,
17: p_check_id_flag IN VARCHAR2,
18: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
19: x_return_status OUT NOCOPY VARCHAR2)
12: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
13: PROCEDURE Check_lookup_name_Or_Id
14: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
15: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
16: p_meaning IN FND_LOOKUPS.meaning%TYPE,
17: p_check_id_flag IN VARCHAR2,
18: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
19: x_return_status OUT NOCOPY VARCHAR2)
20: IS
14: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
15: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
16: p_meaning IN FND_LOOKUPS.meaning%TYPE,
17: p_check_id_flag IN VARCHAR2,
18: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
19: x_return_status OUT NOCOPY VARCHAR2)
20: IS
21:
22: BEGIN