605: BEGIN
606: IF column_name is null then
607: NULL;
608: ELSIF upper(column_name) = 'GRD_CI_SEQUENCE_NUMBER' THEN
609: NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(column_value);
610: ELSIF upper(column_name) = 'US_GROUP_NUMBER' THEN
611: NEW_REFERENCES.US_GROUP_NUMBER := IGS_GE_NUMBER.to_num(column_value) ;
612: ELSIF upper(column_name) = 'ORDER_IN_PRESENTATION' THEN
613: NEW_REFERENCES.ORDER_IN_PRESENTATION := IGS_GE_NUMBER.to_num(column_value);
607: NULL;
608: ELSIF upper(column_name) = 'GRD_CI_SEQUENCE_NUMBER' THEN
609: NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(column_value);
610: ELSIF upper(column_name) = 'US_GROUP_NUMBER' THEN
611: NEW_REFERENCES.US_GROUP_NUMBER := IGS_GE_NUMBER.to_num(column_value) ;
612: ELSIF upper(column_name) = 'ORDER_IN_PRESENTATION' THEN
613: NEW_REFERENCES.ORDER_IN_PRESENTATION := IGS_GE_NUMBER.to_num(column_value);
614: ELSIF upper(column_name) = 'ACADEMIC_DRESS_RQRD_IND' THEN
615: NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND := column_value;
609: NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER := IGS_GE_NUMBER.to_num(column_value);
610: ELSIF upper(column_name) = 'US_GROUP_NUMBER' THEN
611: NEW_REFERENCES.US_GROUP_NUMBER := IGS_GE_NUMBER.to_num(column_value) ;
612: ELSIF upper(column_name) = 'ORDER_IN_PRESENTATION' THEN
613: NEW_REFERENCES.ORDER_IN_PRESENTATION := IGS_GE_NUMBER.to_num(column_value);
614: ELSIF upper(column_name) = 'ACADEMIC_DRESS_RQRD_IND' THEN
615: NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND := column_value;
616: ELSIF upper(column_name) = 'GUEST_TICKETS_REQUESTED' THEN
617: NEW_REFERENCES.GUEST_TICKETS_REQUESTED := IGS_GE_NUMBER.to_num(column_value);
613: NEW_REFERENCES.ORDER_IN_PRESENTATION := IGS_GE_NUMBER.to_num(column_value);
614: ELSIF upper(column_name) = 'ACADEMIC_DRESS_RQRD_IND' THEN
615: NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND := column_value;
616: ELSIF upper(column_name) = 'GUEST_TICKETS_REQUESTED' THEN
617: NEW_REFERENCES.GUEST_TICKETS_REQUESTED := IGS_GE_NUMBER.to_num(column_value);
618: ELSIF upper(column_name) = 'GUEST_TICKETS_ALLOCATED' THEN
619: NEW_REFERENCES.GUEST_TICKETS_ALLOCATED := IGS_GE_NUMBER.to_num(column_value);
620: ELSIF upper(column_name) = 'ACADEMIC_GOWN_SIZE' THEN
621: NEW_REFERENCES.ACADEMIC_GOWN_SIZE := column_value;
615: NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND := column_value;
616: ELSIF upper(column_name) = 'GUEST_TICKETS_REQUESTED' THEN
617: NEW_REFERENCES.GUEST_TICKETS_REQUESTED := IGS_GE_NUMBER.to_num(column_value);
618: ELSIF upper(column_name) = 'GUEST_TICKETS_ALLOCATED' THEN
619: NEW_REFERENCES.GUEST_TICKETS_ALLOCATED := IGS_GE_NUMBER.to_num(column_value);
620: ELSIF upper(column_name) = 'ACADEMIC_GOWN_SIZE' THEN
621: NEW_REFERENCES.ACADEMIC_GOWN_SIZE := column_value;
622: ELSIF upper(column_name) = 'ACADEMIC_HAT_SIZE' THEN
623: NEW_REFERENCES.ACADEMIC_HAT_SIZE := column_value;