29: -- DESCRIPTION :
30: -- used to retrieve lookup code
31: --
32: PROCEDURE Check_lookup_name_Or_Id
33: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
34: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
35: p_meaning IN FND_LOOKUPS.meaning%TYPE,
36: p_check_id_flag IN VARCHAR2,
37: x_lookup_code OUT NOCOPY VARCHAR2,
30: -- used to retrieve lookup code
31: --
32: PROCEDURE Check_lookup_name_Or_Id
33: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
34: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
35: p_meaning IN FND_LOOKUPS.meaning%TYPE,
36: p_check_id_flag IN VARCHAR2,
37: x_lookup_code OUT NOCOPY VARCHAR2,
38: x_return_status OUT NOCOPY VARCHAR2)
31: --
32: PROCEDURE Check_lookup_name_Or_Id
33: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
34: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
35: p_meaning IN FND_LOOKUPS.meaning%TYPE,
36: p_check_id_flag IN VARCHAR2,
37: x_lookup_code OUT NOCOPY VARCHAR2,
38: x_return_status OUT NOCOPY VARCHAR2)
39: IS