248: p_cal_type IN VARCHAR2 ,
249: p_message_name OUT NOCOPY VARCHAR2 )
250: RETURN BOOLEAN IS
251: v_other_detail VARCHAR2(255);
252: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;
253: CURSOR c_cal_type IS
254: SELECT *
255: FROM IGS_CA_TYPE
256: WHERE cal_type = p_cal_type;
251: v_other_detail VARCHAR2(255);
252: v_cal_type_rec IGS_CA_TYPE%ROWTYPE;
253: CURSOR c_cal_type IS
254: SELECT *
255: FROM IGS_CA_TYPE
256: WHERE cal_type = p_cal_type;
257: BEGIN
258: P_MESSAGE_NAME := null;
259: OPEN c_cal_type;