407: END;
408:
409:
410: PROCEDURE Check_lookup_name_Or_Id
411: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
412: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
413: p_meaning IN FND_LOOKUPS.meaning%TYPE,
414: p_check_id_flag IN VARCHAR2,
415: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
408:
409:
410: PROCEDURE Check_lookup_name_Or_Id
411: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
412: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
413: p_meaning IN FND_LOOKUPS.meaning%TYPE,
414: p_check_id_flag IN VARCHAR2,
415: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
416: x_return_status OUT NOCOPY VARCHAR2)
409:
410: PROCEDURE Check_lookup_name_Or_Id
411: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
412: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
413: p_meaning IN FND_LOOKUPS.meaning%TYPE,
414: p_check_id_flag IN VARCHAR2,
415: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
416: x_return_status OUT NOCOPY VARCHAR2)
417: IS
411: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
412: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
413: p_meaning IN FND_LOOKUPS.meaning%TYPE,
414: p_check_id_flag IN VARCHAR2,
415: x_lookup_code OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE,
416: x_return_status OUT NOCOPY VARCHAR2)
417: IS
418: BEGIN
419: IF (p_lookup_code IS NOT NULL) THEN