48: END assp_val_evsa_del;
49: --
50: -- To validate the calendar instance system cal status is not 'INACTIVE'
51: FUNCTION ASSP_VAL_CI_STATUS(
52: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
53: p_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
54: p_message_name OUT NOCOPY varchar2 )
55: RETURN boolean IS
56: gv_other_detail VARCHAR2(255);
49: --
50: -- To validate the calendar instance system cal status is not 'INACTIVE'
51: FUNCTION ASSP_VAL_CI_STATUS(
52: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
53: p_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
54: p_message_name OUT NOCOPY varchar2 )
55: RETURN boolean IS
56: gv_other_detail VARCHAR2(255);
57: BEGIN -- assp_val_ci_status