806: -- PURPOSE
807: -- To derive the any of the lookup codes to its lookup values
808: --------------------------------------------------------------------
809: PROCEDURE Check_Lookup_Name_Or_Id
810: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
811: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
812: p_meaning IN FND_LOOKUPS.meaning%TYPE,
813: p_check_id_flag IN VARCHAR2,
814:
807: -- To derive the any of the lookup codes to its lookup values
808: --------------------------------------------------------------------
809: PROCEDURE Check_Lookup_Name_Or_Id
810: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
811: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
812: p_meaning IN FND_LOOKUPS.meaning%TYPE,
813: p_check_id_flag IN VARCHAR2,
814:
815: x_lookup_code OUT NOCOPY VARCHAR2,
808: --------------------------------------------------------------------
809: PROCEDURE Check_Lookup_Name_Or_Id
810: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
811: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
812: p_meaning IN FND_LOOKUPS.meaning%TYPE,
813: p_check_id_flag IN VARCHAR2,
814:
815: x_lookup_code OUT NOCOPY VARCHAR2,
816: x_return_status OUT NOCOPY VARCHAR2)