274: ) AS
275: v_message_name VARCHAR2(30);
276: BEGIN
277: -- Delete the history records.
278: IF IGS_GR_GEN_001.GRDP_DEL_GAC_HIST (
279: old_references.person_id,
280: old_references.create_dt,
281: old_references.grd_cal_type,
282: old_references.grd_ci_sequence_number,
393: -- If the Ceremony Number has been updated then remove the history records.
394: -- p_updating the Ceremony Number is the equivalent to creating a new record.
395: -- For this reason all existing history records are deleted.
396: IF old_references.ceremony_number = new_references.ceremony_number THEN
397: IGS_GR_GEN_001.GRDP_INS_GAC_HIST (
398: old_references.person_id,
399: old_references.create_dt,
400: old_references.grd_cal_type,
401: old_references.grd_ci_sequence_number,
435: new_references.special_requirements,
436: old_references.comments,
437: new_references.comments);
438: ELSE
439: IF IGS_GR_GEN_001.GRDP_DEL_GAC_HIST (
440: old_references.person_id,
441: old_references.create_dt,
442: old_references.grd_cal_type,
443: old_references.grd_ci_sequence_number,