45: END assp_val_sat_closed;
46: --
47: -- Validate assessment items exist for assessment type
48: FUNCTION assp_val_ai_exist2(
49: p_assessment_type IN IGS_AS_ASSESSMNT_ITM_ALL.assessment_type%TYPE ,
50: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
51: RETURN BOOLEAN AS
52:
53: BEGIN -- assp_val_ai_exist2
54: -- Validate assessment items exist for a particular assessment type.
55: DECLARE
56: CURSOR c_ai IS
57: SELECT 'x'
58: FROM IGS_AS_ASSESSMNT_ITM ai
59: WHERE assessment_type = p_assessment_type;
60: v_ai_exists VARCHAR2(1);
61: BEGIN
62: -- Set the default message number