270: p_special_requirement_cd IN VARCHAR2 ,
271: p_message_name OUT NOCOPY VARCHAR2)
272: RETURN BOOLEAN AS
273: BEGIN -- enrp_val_srq_closed
274: -- Validate that the IGS_GE_SPL_REQ is not closed
275: DECLARE
276: CURSOR c_srq IS
277: SELECT 'x'
278: FROM IGS_GE_SPL_REQ srq
274: -- Validate that the IGS_GE_SPL_REQ is not closed
275: DECLARE
276: CURSOR c_srq IS
277: SELECT 'x'
278: FROM IGS_GE_SPL_REQ srq
279: WHERE srq.special_requirement_cd = p_special_requirement_cd AND
280: srq.closed_ind = 'Y';
281: v_closed_ind VARCHAR2(1) DEFAULT NULL;
282: BEGIN