[Home] [Help]
148: p_message_name OUT NOCOPY VARCHAR2 )
149: RETURN BOOLEAN IS
150: BEGIN
151: DECLARE
152: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
153: CURSOR c_cort(
154: cp_correspondence_type IGS_CO_TYPE.correspondence_type%TYPE) IS
155: SELECT cort.closed_ind
156: FROM IGS_CO_TYPE cort
150: BEGIN
151: DECLARE
152: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
153: CURSOR c_cort(
154: cp_correspondence_type IGS_CO_TYPE.correspondence_type%TYPE) IS
155: SELECT cort.closed_ind
156: FROM IGS_CO_TYPE cort
157: WHERE cort.correspondence_type = cp_correspondence_type;
158: BEGIN
152: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
153: CURSOR c_cort(
154: cp_correspondence_type IGS_CO_TYPE.correspondence_type%TYPE) IS
155: SELECT cort.closed_ind
156: FROM IGS_CO_TYPE cort
157: WHERE cort.correspondence_type = cp_correspondence_type;
158: BEGIN
159: -- Validate if the correspondence type is closed
160: p_message_name := null;