800: -- PURPOSE
801: -- To derive the any of the lookup codes to its lookup values
802: --------------------------------------------------------------------
803: PROCEDURE Check_Lookup_Name_Or_Id
804: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
805: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
806: p_meaning IN FND_LOOKUPS.meaning%TYPE,
807: p_check_id_flag IN VARCHAR2,
808:
801: -- To derive the any of the lookup codes to its lookup values
802: --------------------------------------------------------------------
803: PROCEDURE Check_Lookup_Name_Or_Id
804: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
805: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
806: p_meaning IN FND_LOOKUPS.meaning%TYPE,
807: p_check_id_flag IN VARCHAR2,
808:
809: x_lookup_code OUT NOCOPY VARCHAR2,
802: --------------------------------------------------------------------
803: PROCEDURE Check_Lookup_Name_Or_Id
804: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
805: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
806: p_meaning IN FND_LOOKUPS.meaning%TYPE,
807: p_check_id_flag IN VARCHAR2,
808:
809: x_lookup_code OUT NOCOPY VARCHAR2,
810: x_return_status OUT NOCOPY VARCHAR2)